METHOD AND SYSTEM FOR ADAPTIVELY BUILDING AND UPDATING A COLUMN STORE DATABASE FROM A ROW STORE DATABASE BASED ON QUERY DEMANDS

摘要

A method for adaptively building and updating a column store database from a row store database using queries. The method includes establishing the row store database for storing data, wherein at least one row of the row store includes attributes. The method includes establishing the column store including data structured to satisfy received analytic queries, wherein the column store includes attribute vectors corresponding to attributes in the row store, wherein at least one of the attribute vectors includes data used to satisfy previously received analytic queries. The method includes receiving change transactions directed to the row store, wherein the change transactions are ordered. The method includes when a first referenced attribute referenced by an analytic query corresponds to an attribute vector in the column store, updating the attribute vector based on log information corresponding to change transactions directed to the referenced attribute to satisfy the analytic query.

主权项

1. A computer system for updating a database system, comprising:
memory having stored therein computer-executable instructions; and a processor executing said computer-executable instructions, said instructions including:
establishing a row store database for storing data, wherein at least row of said row store database comprises a plurality of attributes;establishing a column store database comprising data structured to satisfy received analytic queries, wherein said column store database comprises a plurality of attribute vectors corresponding to at least one attribute in said row store database, wherein said plurality of attribute vectors comprises data used to satisfy at least one of a plurality of previously received analytic queries;receiving a plurality of change transactions directed to said row store database, wherein said plurality of change transactions are ordered; andwhen a first referenced attribute referenced by a first analytic query corresponds to a first attribute vector in said column store database, updating a first attribute vector based on said log information corresponding to change transactions directed to said first referenced attribute to satisfy said first analytic query.