Xiaoying Wang

Title: Innovations by Xiaoying Wang in Database Systems

Introduction

Xiaoying Wang is an accomplished inventor based in Coquitlam, Canada. She has made significant contributions to the field of database systems, particularly in the area of index tuning. Her innovative approach addresses the challenges of budget constraints in database management.

Latest Patents

Xiaoying Wang holds a patent titled "Budget-constrained index tuning in database systems." This patent outlines a method for index tuning that involves receiving a budget constraint and generating a set of candidate indexes for a workload of queries. The method determines a derived cost for each query-configuration pair (QCP) and identifies subsets of QCPs where the derived cost and a what-if cost have a delta value below a predefined difference threshold. The approach allocates the budget constraint to these identified QCPs to avoid unnecessary what-if calls. Additionally, it reallocates a saved portion of the budget constraint to other QCPs where the delta value exceeds the difference threshold, evaluates these other QCPs using what-if calls, and selects an optimal index configuration to apply to the database system.

Career Highlights

Xiaoying Wang is currently employed at Microsoft Technology Licensing, LLC, where she continues to develop innovative solutions in database technology. Her work has been instrumental in enhancing the efficiency and effectiveness of database systems.

Collaborations

Xiaoying has collaborated with notable colleagues, including Wentao Wu and Chi Wang, contributing to a dynamic and innovative work environment.

Conclusion

Xiaoying Wang's contributions to database systems through her patent on budget-constrained index tuning exemplify her innovative spirit and dedication to advancing technology. Her work continues to influence the field and improve database management practices.