Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Line and column hybrid storage method of database system

A hybrid storage and database technology, applied in the field of row-column hybrid storage of database systems, can solve problems such as difficulty in unification, different organization methods and query execution methods, and achieve the effect of unification

Inactive Publication Date: 2013-12-11
NORTHWESTERN POLYTECHNICAL UNIV
View PDF2 Cites 29 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In order to overcome the disadvantages of the row-column hybrid storage method of the existing row-type database system, which are difficult to unify due to the different organization methods and query execution methods, the present invention provides a row-column hybrid storage method of the database system

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
  • Line and column hybrid storage method of database system
  • Line and column hybrid storage method of database system
  • Line and column hybrid storage method of database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] refer to Figure 1-2 . The specific steps of the row-column hybrid storage method of the database system of the present invention are as follows:

[0028] 1. Establish a mixed storage model of rows and columns.

[0029] The row-column mixed database system proposed by the present invention means that a table in the database system can be stored by row or column, and only one copy of each table is stored in the database, and the user specifies the storage of the table according to the requirement when creating the table. way to obtain the corresponding read and write performance. Specific steps are as follows:

[0030] (1) Define an access parameter list, which is responsible for the access mode of row files and column files, see Table 1.

[0031] Table 1 Access parameter description table

[0032]

[0033] (2) Then access the storage engine subpackage layer to hide storage details upwards and provide a consistent data access interface. The query...

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

The invention discloses a line and column hybrid storage method of a database system and is used for solving the technical problems that an organizational method and a query execution method of a line and column hybrid storage method of a traditional line-type database system are different and are difficult to unify. The technical scheme is that the line and column hybrid storage method of the database system comprises the following steps of respectively establishing a line storage engine and a column storage engine on a storage layer of the database system, then, packaging the line storage engine and the column storage engine by an access interface layer, performing tuple materialization on a list, performing projection on the list, and providing a unified data access interface for a query engine. Therefore, storage differences are concealed, and the unification of query processing is realized.

Description

technical field [0001] The invention relates to a row-column hybrid storage method, in particular to a row-column hybrid storage method of a database system. Background technique [0002] refer to image 3 . In a relational database system, data is logically organized into tables. The performance of the access table is an important factor affecting the performance of the database system. There are two types of table storage modes: row storage and column storage. In the row storage mode, data is stored in tuples, and all attributes of each tuple are stored together. If you want to query a certain attribute value of a tuple, you need to read the data of the entire tuple first. Most current relational database systems use row storage technology. Column storage organizes each column of the table together for storage, and different columns are stored independently. [0003] With the continuous deepening of social informatization, the continuous accumulation of massive data ...

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
Inventor 王卓肖玉泽陈群刘海龙白松孙林超李战怀
Owner NORTHWESTERN POLYTECHNICAL UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com