Patents by Inventor Panfeng ZHOU
Panfeng ZHOU has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11775488Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.Type: GrantFiled: March 21, 2022Date of Patent: October 3, 2023Assignee: SAP SEInventors: Panfeng Zhou, Vivek Kandiyanallur, Colin Florendo, Robert Schulze, Zheng-Wei She, Yanhong Wang, Amarnadh Sai Eluri
-
Patent number: 11500928Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.Type: GrantFiled: January 6, 2020Date of Patent: November 15, 2022Assignee: SAP SEInventors: Panfeng Zhou, Mihnea Andrei, Vivek Kandiyanallur, Xin Liu, Neeraj Kulkarni
-
Publication number: 20220207002Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.Type: ApplicationFiled: March 21, 2022Publication date: June 30, 2022Inventors: PANFENG ZHOU, Vivek KANDIYANALLUR, Colin FLORENDO, Robert SCHULZE, Zheng-wei SHE, Yanhong WANG, Amarnadh Sai ELURI
-
Patent number: 11308047Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.Type: GrantFiled: March 12, 2020Date of Patent: April 19, 2022Assignee: SAP SEInventors: Panfeng Zhou, Vivek Kandiyanallur, Colin Florendo, Robert Schulze, Zheng-Wei She, Yanhong Wang, Amarnadh Sai Eluri
-
Patent number: 11249962Abstract: Disclosed herein are systems, methods, and devices for providing load unit recommendations. An example method includes monitoring queries executed by a database management system including a database object, determining an access frequency of the database object based upon the monitoring, and determining relative access counter information for the database object based on the access frequency. Subsequently, the method includes generating a sorted element based on the relative access counter information, determining threshold values based on threshold information and the sorted element, and determining a load unit for the database object based on the sorted element and the threshold values. The load unit indicates whether to load the whole database object, or only a portion thereof, into a main memory of the DBMS while accessing the database object.Type: GrantFiled: May 14, 2019Date of Patent: February 15, 2022Assignee: SAP SEInventors: Panfeng Zhou, Xu-Dong Qian, Yanhong Wang, Shyam Sunder Reddy Avula, Amarnadh Sai Eluri, Chirag Samtani
-
Publication number: 20210286777Abstract: System, method, and various embodiments for providing a data access and recommendation system are described herein. An embodiment operates by identifying a column access of one or more data values of a first column of a plurality of columns of a table of a database during a sampling period. A count of how many of the one or more data values are accessed during the column access are recorded. A first counter, corresponding to the first column and stored in a distributed hash table, is incremented by the count. The sampling period is determined to have expired. A load recommendation on how to load data values into the first column based on the first counter is computed. The load recommendation for implementation into the database for one or more subsequent column accesses is provided.Type: ApplicationFiled: March 12, 2020Publication date: September 16, 2021Inventors: PANFENG ZHOU, Vivek Kandiyanallur, Colin Florendo, Robert Schulze, Zheng-wei She, Yanhong Wang, Amarnadh Sai Eluri
-
Patent number: 11086832Abstract: The subject matter disclosed herein relates to out of memory error handling in a database system. A database operation can be received by an in-memory database. The database operation can be for a database object stored in a database table that can be represented as a plurality of pages that can be persisted in a page chain. The in-memory database can reserve out of memory space sufficient to load a predetermined number of pages in the page chain into memory. The in-memory database can iteratively process each page in the page chain until completion of the database operation. The iterative process can include loading the page from persistence into memory of the in-memory database, performing at least a portion of the database operation using the loaded page, and unloading the page from the memory of the in-memory database. Related apparatus, systems, techniques, and articles are also described.Type: GrantFiled: October 16, 2015Date of Patent: August 10, 2021Assignee: SAP SEInventors: Panfeng Zhou, Colin Florendo, Ivan Schreter, Thorsten Glebe, David Wein
-
Publication number: 20200364193Abstract: Disclosed herein are system, method, and device embodiments for providing load unit recommendations. An embodiment operates by monitoring queries executed by a database management system including a database object, determining an access frequency of the database object based upon the monitoring, and determining relative access counter information for the database object based on the access frequency. Some embodiments may further operate by generating a sorted element based on the relative access counter information, determining threshold values based on threshold information and the sorted element, and determining a load unit for the database object based on the sorted element and the threshold values, wherein the load unit may indicate whether to load the whole database object into main memory of the DBMS while accessing the database object or only load a portion of the database object into main memory of the DBMS when accessing the database object.Type: ApplicationFiled: May 14, 2019Publication date: November 19, 2020Inventors: Panfeng ZHOU, Xu-dong QIAN, Yanhong WANG, Shyam Sunder Reddy AVULA, Amarnadh Sai ELURI, Chirag SAMTANI
-
Patent number: 10747737Abstract: Disclosed herein are system, method, and computer program product embodiments for altering the data type of a column in a database. An embodiment operates by converting an original dictionary associated with a column into a new dictionary. The new dictionary stores the values of the original dictionary using a different data type. An index vector containing the keys of the original dictionary is then updated to contain the associated keys of the new dictionary. Because the size of the original dictionary is often substantially smaller than the number of rows in the associated column, this dictionary conversion decreases the computation cost to the database system of altering the data type of the column and reduces or even minimizes database downtime for users.Type: GrantFiled: November 25, 2014Date of Patent: August 18, 2020Assignee: SAP SEInventors: Colin Florendo, Ivan Schreter, Panfeng Zhou, David Wein, Steffen Geissinger, Michael Muehle
-
Publication number: 20200142929Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.Type: ApplicationFiled: January 6, 2020Publication date: May 7, 2020Inventors: Panfeng Zhou, Mihnea Andrei, Vivek Kandiyanallur, Xin Liu, Neeraj Kulkarni
-
Patent number: 10558704Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.Type: GrantFiled: August 31, 2017Date of Patent: February 11, 2020Assignee: SAP SEInventors: Panfeng Zhou, Mihnea Andrei, Vivek Kandiyanallur, Xin Liu, Neeraj Kulkarni
-
Publication number: 20190026387Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.Type: ApplicationFiled: August 31, 2017Publication date: January 24, 2019Inventors: Panfeng Zhou, Mihnea Andrei, Vivek Kandiyanallur, Xin Liu, Neeraj Kulkarni
-
Patent number: 9779104Abstract: Log records are accessed as part of a database operation in a database. The log records log insert, update, and delete operations in the database and include, for each row, a row position, a fragment identifier (ID), and a row ID. Thereafter, as part of the database operation, rows specified by the log records are located by: using the fragment identifier and the row position within the corresponding record of the log if the fragment with the corresponding fragment identifier is still available, otherwise, using the row identifier within the corresponding record of the log to look up the row position in an index of a corresponding row identifier column. The database operation is then finalized using the located rows. Related apparatus, systems, techniques and articles are also described.Type: GrantFiled: November 25, 2014Date of Patent: October 3, 2017Assignee: SAP SEInventors: Mihnea Andrei, Ivan Schreter, David Wein, Shiping Chen, Panfeng Zhou, Steffen Geissinger
-
Publication number: 20170109044Abstract: The subject matter disclosed herein relates to out of memory error handling in a database system. A database operation can be received by an in-memory database. The database operation can be for a database object stored in a database table that can be represented as a plurality of pages that can be persisted in a page chain. The in-memory database can reserve out of memory space sufficient to load a predetermined number of pages in the page chain into memory. The in-memory database can iteratively process each page in the page chain until completion of the database operation. The iterative process can include loading the page from persistence into memory of the in-memory database, performing at least a portion of the database operation using the loaded page, and unloading the page from the memory of the in-memory database. Related apparatus, systems, techniques, and articles are also described.Type: ApplicationFiled: October 16, 2015Publication date: April 20, 2017Inventors: Panfeng Zhou, Colin Florendo, Ivan Schreter, Thorsten Glebe, David Wein
-
Publication number: 20160147776Abstract: Disclosed herein are system, method, and computer program product embodiments for altering the data type of a column in a database. An embodiment operates by converting an original dictionary associated with a column into a new dictionary. The new dictionary stores the values of the original dictionary using a different data type. An index vector containing the keys of the original dictionary is then updated to contain the associated keys of the new dictionary. Because the size of the original dictionary is often substantially smaller than the number of rows in the associated column, this dictionary conversion decreases the computation cost to the database system of altering the data type of the column and reduces or even minimizes database downtime for users.Type: ApplicationFiled: November 25, 2014Publication date: May 26, 2016Inventors: Colin Florendo, Ivan Schreter, Panfeng Zhou, David Wein, Steffen Geissinger, Michael Muehle
-
Publication number: 20160147786Abstract: Log records are accessed as part of a database operation in a database. The log records log insert, update, and delete operations in the database and include, for each row, a row position, a fragment identifier (ID), and a row ID. Thereafter, as part of the database operation, rows specified by the log records are located by: using the fragment identifier and the row position within the corresponding record of the log if the fragment with the corresponding fragment identifier is still available, otherwise, using the row identifier within the corresponding record of the log to look up the row position in an index of a corresponding row identifier column. The database operation is then finalized using the located rows. Related apparatus, systems, techniques and articles are also described.Type: ApplicationFiled: November 25, 2014Publication date: May 26, 2016Inventors: Mihnea Andrei, Ivan Schreter, David Wein, Shiping Chen, Panfeng Zhou, Steffen Geissinger
-
Patent number: 8965857Abstract: Methods, systems, and computer program products are provided to manage a database system. The method includes locking during a database system idle time access by the database system to a data page of a data allocation unit, compressing during the database system idle time a data stored in the locked data page, and recording during the database system idle time an indication that the compressed and locked data page includes free storage space, wherein unlocked data pages of the data allocation unit are accessible by the database system during the compressing of the data stored in the locked data page. Thus, the data page may be compressed during idle time and the space freed therein may be used during a subsequent run time without the need for a reorganization of the data pages within the corresponding table (as in, for example, operation of a reorg+rebuild SQL command combination).Type: GrantFiled: December 28, 2012Date of Patent: February 24, 2015Assignee: Sybase, Inc.Inventors: Panfeng Zhou, Katsunori Terada, Yanhong Wang
-
Publication number: 20140188821Abstract: Methods, systems, and computer program products are provided to manage a database system. The method includes locking during a database system idle time access by the database system to a data page of a data allocation unit, compressing during the database system idle time a data stored in the locked data page, and recording during the database system idle time an indication that the compressed and locked data page includes free storage space, wherein unlocked data pages of the data allocation unit are accessible by the database system during the compressing of the data stored in the locked data page. Thus, the data page may be compressed during idle time and the space freed therein may be used during a subsequent run time without the need for a reorganization of the data pages within the corresponding table (as in, for example, operation of a reorg+rebuild SQL command combination).Type: ApplicationFiled: December 28, 2012Publication date: July 3, 2014Inventors: Panfeng ZHOU, Katsunori TERADA, Yanhong WANG
-
Publication number: 20130080481Abstract: Methods, systems, and computer program products are provided to efficiently allocate extremely large storage spaces for use by dynamic hash tables. A contiguous storage space is designated from which dynamic hash tables can be created. These dynamic hash tables benefit from rapid allocation by being able to reserve many allocation units (each potentially comprising a large number of pages, e.g., 256 pages) within a short span of time, rather than resorting to reserving individual pages. The efficiency from allocation and the contiguous space significantly improves performance for databases in the 50 GB-100 GB size range.Type: ApplicationFiled: September 27, 2011Publication date: March 28, 2013Applicant: Sybase, Inc.Inventors: Panfeng ZHOU, Shampa Chakravarty, Elton Philip Wildermuth, Yanhong Wang
-
Publication number: 20100257181Abstract: Aspects for achieving efficient data access to data elements in a relational database management system are provided. In a computer-implemented method aspect, the efficient data access occurs by establishing a hash table for data elements of a database in a predetermined continuous space of allocated storage, and optimizing utilization of the hash table during database query operations through linear hashing, wherein extension of the hash table occurs automatically to increase a number of pages in the hash table without discernible interruptions of data access to the data elements.Type: ApplicationFiled: April 1, 2009Publication date: October 7, 2010Applicant: Sybase, Inc.Inventors: Panfeng ZHOU, Katsunori TERADA, Yanhong WANG