首页>
外国专利>
STATEMENT BASED MIGRATION FOR ADAPTIVELY BUILDING AND UPDATING COLUMN STORE DATABASE FROM ROW STORE DATABASE BASED ON QUERY DEMANDS USING DISPARATE DATABASE SYSTEMS
STATEMENT BASED MIGRATION FOR ADAPTIVELY BUILDING AND UPDATING COLUMN STORE DATABASE FROM ROW STORE DATABASE BASED ON QUERY DEMANDS USING DISPARATE DATABASE SYSTEMS
展开▼
机译:基于语句的基于迁移的数据库从行存储数据库自适应构建和更新列存储数据库的基于语句的迁移
展开▼
页面导航
摘要
著录项
相似文献
摘要
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.
展开▼