公开(公告)号：US10671594B2

公开(公告)日：2020-06-02

申请号：US14489192

申请日：2014-09-17

Applicant: Futurewei Technologies, Inc.

Inventor： Ron-Chung Hu ,  Mengmeng Chen ,  Aniket Adnaik ,  Chi Yong Ku

IPC: G06F16/23 ,  G06F16/20 ,  G06F16/242 ,  G06F16/10 ,  G06F16/28

Abstract: 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.

公开(公告)号：US09836507B2

公开(公告)日：2017-12-05

申请号：US14488775

申请日：2014-09-17

Applicant: Futurewei Technologies, Inc.

Inventor： Ron Chung Hu ,  Guangyu Shi ,  Masood Mortazavi ,  Chi Yong Ku ,  Mengmeng Chen

IPC: G06F17/30

CPC classification number: G06F17/30466 ,  G06F17/30289 ,  G06F17/30315 ,  G06F17/30377 ,  G06F17/30592

Abstract: 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.