Xiaoke Liu

Title: Innovations of Xiaoke Liu

Introduction

Xiaoke Liu is a prominent inventor based in Xian, China, known for his contributions to database management systems. With a total of four patents to his name, Liu has made significant strides in improving the efficiency and functionality of partitioned database tables.

Latest Patents

One of Liu's latest patents is titled "Linear interval-based dynamic range partitioning." This invention discloses computer-readable media, methods, and systems for linear interval-based dynamic range partitioning in one or more database systems. The process begins when a request is received by a database management system to insert a new row into a partitioned database table. If it is determined that the new row should be inserted into the partition others partition, a series of steps are performed. Initially, one or more new partitions are added to the partitioned database table, followed by the insertion of the new row into one of the new partitions.

Another notable patent by Liu is focused on "Execution of operations on partitioned tables." This invention reveals methods and systems for utilizing partition-based locking mechanisms to enhance the execution of overlapping data definition language (DDL) and data manipulation language (DML) operations on a partitioned database table. In this process, a first node receives a DML statement associated with a first transaction and acquires an intent exclusive lock on table metadata. Simultaneously, a second node receives a DDL statement associated with a second transaction and acquires an exclusive metadata lock on the partitioned table metadata. The second transaction waits for the DML operation of the first transaction to complete before executing and committing.

Career Highlights

Xiaoke Liu is currently employed at SAP SE, where he continues to innovate and develop advanced database solutions. His work has significantly impacted the field of database management, particularly in the area of partitioning and data operations.

Collaborations

Liu has collaborated with notable coworkers, including Qingwei Ren and Zhe Qu, contributing to various projects and advancements in database technology.

Conclusion

Xiaoke Liu's innovative patents and contributions to database management systems highlight his expertise and commitment to advancing technology in this field. His work continues to influence the efficiency of data operations and partitioning strategies in modern database systems.