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, comprising;

• establishing said row store database for storing data, wherein at least one row of said row store database comprises a plurality of attributes;
• establishing said 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;
• and
• when 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.

A non-transitory computer-readable medium having computer-executable instructions for causing a computer system to perform a method for accessing information, comprising;

• establishing a row store database for storing data, wherein at least one 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;
• executing said plurality of change transactions on said row store database;
• determining a subset of change transactions taken from said plurality of change transactions directed to attributes stored within said plurality of attribute vectors;
• storing log information corresponding to said subset of change transactions;
• receiving a first analytic query, wherein said first analytic query is directed to a first referenced attribute in said plurality of attributes;
• and
• when said first referenced attribute corresponds to a first attribute vector in said column store database, updating said first attribute vector based on said log information corresponding to change transactions directed to said first referenced attribute to satisfy said first analytic query.