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 updating a column store database system using statement based migration, comprising:

• establishing a row store database, wherein each 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 each of said plurality of attribute vectors comprises data used to satisfy at least one of a plurality of previously received analytic queries;
• collecting a plurality of SQL change statements beginning from a synchronization point indicating when said row store database and said column store database are synchronized and continuing until an analytic query is received;
• sending said plurality of SQL change statements to said column store database upon receipt of said analytic query for updating said column store database for purposes of satisfying said query, wherein said analytic query is directed to a queried range of primary key attributes in said plurality of attributes.

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, wherein each 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 each of said plurality of attribute vectors comprises data used to satisfy at least one of a plurality of previously received analytic queries;
• collecting a plurality of SQL change statements beginning from a synchronization point indicating when said row store database and said column store database are synchronized and continuing until an analytic query is received;
• sending said plurality of SQL change statements to said column store database upon receipt of said analytic query for updating said column store database for purposes of satisfying said query, wherein said analytic query is directed to a queried range of primary key attributes in said plurality of attributes.