Future Wei Technologies, Inc.

Huawei Technologies Co., Limited

Chi Yong Ku

Mengmeng Chen

Guangyu Shi

Masood Mortazavi

Ron-Chung Hu

Aniket Adnaik

Fang Cao

Ron Chung Hu

A method for updating a column store database and includes establishing a row store database, wherein each row comprises a plurality of attributes. The method includes establishing a column store database including attribute vectors corresponding to at least one attribute in the row store, wherein each attribute vector includes data used to satisfy at least one of previously received analytic queries. The method includes collecting a SQL change statements beginning from a synchronization point indicating when the row store database and the column store database are synchronized, and continuing until an analytic query is received. The method includes sending the plurality of SQL change statements to the column store database upon receipt of the analytic query for updating the column store database for purposes of satisfying the query, wherein the analytic query is directed to a queried range of primary key attributes in the plurality of attributes.

Statement based migration for adaptively building and updating a column store database from a row store database based on query demands using disparate database systems

A method for dynamically building a column store database from a row store database. The method includes establishing the row store database for storing data, wherein each row includes a plurality of attributes, and wherein data in row store database is current to a temporal point in time. The method includes establishing the column store database including data structured to satisfy received analytic queries. The method includes beginning from an initial state of the column store database, for each subsequently received analytic query, importing a targeted amount of data from a corresponding temporal state of the row store database into the column store database to satisfy the corresponding subsequently received analytic query.

Method and system for adaptively building a column store database from a temporal row store database based on query demands

Growing community of inventors

San Ramon, CA, United States of America

Chi Yong Ku