Patents by Inventor Qingwei Ren
Qingwei Ren 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: 11995104Abstract: Computer-readable media, methods, and systems are disclosed for linear interval-based dynamic range partitioning in one or more database systems. A request is received by a database management system to insert a new row into a partitioned database table. The partitioned database table may include a plurality of existing partitions and a partition others partition. Based on determining that the new row should be inserted into the partition others partition a series of steps are performed. First, one or more new partitions are added to the partitioned database table. Then, the new row is inserted into the one of the one or more new partitions in the partitioned database table.Type: GrantFiled: May 27, 2022Date of Patent: May 28, 2024Assignee: SAP SEInventors: Zhilong Hao, Xiaoke Liu, Jiaxin Liu, Weimin Qi, Zhe Qu, Qingwei Ren
-
Patent number: 11940972Abstract: Computer-readable media, methods, and systems are disclosed for utilizing partition-based locking mechanisms to improve execution of overlapping data definition language (DDL) and data manipulation language (DML) operations on a partitioned database table. A first node receives a DML statement associated with a first transaction. The first node acquires a intent exclusive lock on table metadata. A second node receives a DDL statement associated with a second transaction and acquires an exclusive metadata lock on the partitioned table metadata. Next, an intent exclusive lock is acquired for the relevant partition table data on the second node and an exclusive lock on table metadata on the second node. The second transaction waits for the DML operation of the first transaction to complete. Then the first transaction is committed. Finally exclusive locks are acquired on table data and metadata and the second transaction is executed and committed.Type: GrantFiled: May 27, 2022Date of Patent: March 26, 2024Assignee: SAP SEInventors: Xiaoke Liu, Zhilong Hao, Weimin Qi, Zhe Qu, Jiaxin Liu, Qingwei Ren
-
Patent number: 11914598Abstract: Computer-readable media, methods, and systems are disclosed for database table partition pruning based on statistical information associated with non-partition columns. A tree partition specification is received defining partitions for a plurality of computed column statistics. Respective partitions are created for the plurality of computed column statistics based on the tree partition specification. A request is received to compute statistics for a plurality of columns of the plurality of computed column statistics to result in a plurality of computed column statistics. In response to determining that one or more modifications have been made to the partitioned database, the plurality of computed column statistics is marked as invalid. The computed column statistics are refreshed in response to modifications of the partitioned table. Thereafter, the statistics are marked as valid. Unnecessary table partitions are pruned based on the statistics, and the associated query is executed.Type: GrantFiled: May 27, 2022Date of Patent: February 27, 2024Assignee: SAP SEInventors: Qingwei Ren, Weimin Qi, Zhe Qu, Xiaoke Liu, Jiaxin Liu, Zhilong Hao
-
Publication number: 20230409603Abstract: Computer-readable media, methods, and systems are disclosed for linear interval-based dynamic range partitioning in one or more database systems. A request is received by a database management system to insert a new row into a partitioned database table. The partitioned database table may include a plurality of existing partitions and a partition others partition. Based on determining that the new row should be inserted into the partition others partition a series of steps are performed. First, one or more new partitions are added to the partitioned database table. Then, the new row is inserted into the one of the one or more new partitions in the partitioned database table.Type: ApplicationFiled: May 27, 2022Publication date: December 21, 2023Inventors: Zhilong Hao, Xiaoke Liu, Jiaxin Liu, Weimin Qi, Zhe Qu, Qingwei Ren
-
Publication number: 20230385263Abstract: Computer-readable media, methods, and systems are disclosed for utilizing partition-based locking mechanisms to improve execution of overlapping data definition language (DDL) and data manipulation language (DML) operations on a partitioned database table. A first node receives a DML statement associated with a first transaction. The first node acquires a intent exclusive lock on table metadata. A second node receives a DDL statement associated with a second transaction and acquires an exclusive metadata lock on the partitioned table metadata. Next, an intent exclusive lock is acquired for the relevant partition table data on the second node and an exclusive lock on table metadata on the second node. The second transaction waits for the DML operation of the first transaction to complete. Then the first transaction is committed. Finally exclusive locks are acquired on table data and metadata and the second transaction is executed and committed.Type: ApplicationFiled: May 27, 2022Publication date: November 30, 2023Inventors: Xiaoke Liu, Zhilong Hao, Weimin Qi, Zhe Qu, Jiaxin Liu, Qingwei Ren
-
Publication number: 20230385282Abstract: Computer-readable media, methods, and systems are disclosed for database table partition pruning based on statistical information associated with non-partition columns. A tree partition specification is received defining partitions for a plurality of computed column statistics. Respective partitions are created for the plurality of computed column statistics based on the tree partition specification. A request is received to compute statistics for a plurality of columns of the plurality of computed column statistics to result in a plurality of computed column statistics. In response to determining that one or more modifications have been made to the partitioned database, the plurality of computed column statistics is marked as invalid. The computed column statistics are refreshed in response to modifications of the partitioned table. Thereafter, the statistics are marked as valid. Unnecessary table partitions are pruned based on the statistics, and the associated query is executed.Type: ApplicationFiled: May 27, 2022Publication date: November 30, 2023Inventors: Qingwei Ren, Weimin Qi, Zhe Qu, Xiaoke Liu, Jiaxin Liu, Zhilong Hao
-
Patent number: 11741127Abstract: A method may include generating a database table to include a first partition having a first range and a dynamic partition associated with an undefined range of a specified length. A record may be inserted into the database table. In response to one or more values of the record being outside of the first range of the first partition, a second partition having a second range of the specified length that includes the one or more values of the record may be generated. The record may be stored in the second partition. Moreover, a query on the database table may be executed by the first partition and/or the second partition of the database table. Related systems and articles of manufacture are also provided.Type: GrantFiled: October 27, 2021Date of Patent: August 29, 2023Assignee: SAP SEInventors: Xiaoke Liu, Qingwei Ren, Zhe Qu, Zhilong Hao, Weimin Qi, Long Zhang, Jiaxin Liu, Xiaolong Yang
-
Publication number: 20230129468Abstract: A method may include generating a database table to include a first partition having a first range and a dynamic partition associated with an undefined range of a specified length. A record may be inserted into the database table. In response to one or more values of the record being outside of the first range of the first partition, a second partition having a second range of the specified length that includes the one or more values of the record may be generated. The record may be stored in the second partition. Moreover, a query on the database table may be executed by the first partition and/or the second partition of the database table. Related systems and articles of manufacture are also provided.Type: ApplicationFiled: October 27, 2021Publication date: April 27, 2023Inventors: Xiaoke Liu, Qingwei Ren, Zhe Qu, Zhilong Hao, Weimin Qi, Long Zhang, Jiaxin Liu, Xiaolong Yang
-
Publication number: 20230126103Abstract: A method for processing a query may include evaluating a query on a database table to identify a time based function included in the query. One or more partitions of the database table may be pruned from the query based at least on the partitions being associated with a first time range that does not overlap with a second time range associated with the time based function. An execution plan for the query may be generated to include a sequence of operations that avoids accessing the one or more partitions pruned from the query. The query may be executed based at least on the execution plan by at least accessing a second partition of the database table but not the first partition of the database table pruned from the query. Related systems and articles of manufacture are also provided.Type: ApplicationFiled: October 27, 2021Publication date: April 27, 2023Inventors: Qingwei Ren, Zhe Qu, Zhilong Hao, Weimin Qi, Long Zhang, Jiaxin Liu, Xiaoke Liu, Xiaolong Yang