Microsoft Technology Licensing, LLC

Haoqiong Bian

Thomas Moscibroda

Liang Jeff Chen

Ying Yan

Xiao Huang

Yueguo Chen

Xudong Zheng

Systems, methods, and computer-readable media for determining column ordering of a data storage table for search optimization are described herein. In some examples, a computing system is configured to receive input containing statistics of a plurality of queries. The computing system can then determine a new column order (i.e., layout) based at least in part on the statistics. In some example techniques described herein, the computing system can determine the new column order based at least in part on the hardware components storing the data storage table, storage system parameters, and/or user preference information. Example techniques described herein can apply the new column order to data subsequently added to the data storage table. Example techniques described herein can apply the new column order to existing data in the data storage table.

Growing community of inventors

Redmond, WA, United States of America

Haoqiong Bian