Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for adaptively building and updating column store database from row store database based on query demands

A database and column storage technology, applied in special data processing applications, electrical digital data processing, instruments, etc., can solve problems such as system downtime and performance loss

Active Publication Date: 2017-05-24
HUAWEI TECH CO LTD
View PDF9 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In addition, to speed up access, these traditional column store databases are built in main memory such as random access memory (random access memory, RAM), but when the entire column store database is wiped, it will suffer huge damage during system crashes. performance loss
As a result, the system remains down during a system recovery that rebuilds the entire columnstore database

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for adaptively building and updating column store database from row store database based on query demands
  • Method and system for adaptively building and updating column store database from row store database based on query demands
  • Method and system for adaptively building and updating column store database from row store database based on query demands

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] Reference will now be made in detail to various embodiments of the invention, examples illustrated in the accompanying drawings. While described in conjunction with these Examples, it will be understood that they are not intended to limit the invention to these Examples. On the contrary, the invention is intended to cover alternatives, modifications and equivalents, which may be included within the spirit and scope of the present disclosure as defined by the appended claims. In addition, in the following detailed description of the invention, numerous specific details are set forth in order to provide a thorough understanding of the present invention. It is understood, however, that in practice these specific details of the invention may not be included. In other instances, well-known methods, procedures, components, and circuits have not been described in detail so as not to unnecessarily obscure aspects of the present invention.

[0034] Therefore, embodiments of th...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

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 a 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, and 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.

Description

Background technique [0001] Based on the storage format of data records, in a relational database system, row storage or column storage can be used to store data records. In a row store database, data records are arranged in a row format. In online transaction processing (OLTP) transactions, which typically include INSERT / DELETE / UPDATE operations, row storage typically exhibits good performance. For example, information can be changed for an entire row involving a disk I / O operation. On the other hand, in a column store database, data records are arranged in a columnar format. Column storage performs well in online analytical processing (OLAP) queries because it only needs to read those columns needed to process the query, greatly reducing disk I / O operations. [0002] Since row stores and column stores are suitable for different types of queries, it has been proposed to include both row stores and column stores in database systems, that is, hybrid row / column stores, to han...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/273G06F16/254
Inventor 胡荣中施广宇马苏德·莫塔扎维古志勇曹方
Owner HUAWEI TECH CO LTD