Row and line mixed database storage method

A database, row-column technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as reducing query performance, and achieve the effect of avoiding full table query, reducing I/O overhead, and improving speed and performance.

Active Publication Date: 2012-09-19
山西同方知网数字出版技术有限公司
View PDF3 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This lookup process reduces the performance of the query

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
  • Row and line mixed database storage method
  • Row and line mixed database storage method
  • Row and line mixed database storage method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] In order to make the purpose, technical solutions and advantages of the present invention clearer, the implementation of the present invention will be further described in detail below in conjunction with the accompanying drawings:

[0017] This embodiment provides a mixed row and column database storage method, wherein,

[0018] see figure 1 , the method includes the following steps:

[0019] Step 10 Create the table and the physical storage space corresponding to the table, and establish the corresponding relationship between the column and the storage space according to the application requirements;

[0020] Step 20 inserting records into the table, and grouping according to the corresponding relationship between columns and physical storage space;

[0021] Step 30 writes the recorded column values ​​as rows into the corresponding physical storage space.

[0022] The creation of the table in the above step 10 includes creating the name and fields of the table, and...

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 row and line mixed database storage method, which comprises the steps of: creating a table and physical storage spaces corresponding to the table, and determining the corresponding relationship between lines and the physical storage spaces according to application requirements; inserting records into the table, and grouping according to the corresponding relationship between the lines and the physical storage spaces; and writing recorded line values as rows into the corresponding physical storage spaces. By means of the row and line mixed database storage method provided by the invention, whole-table inquiry is avoided effectively, I / O (Input / Output) expenditure is reduced, and the speed of data reading and the inquiry performance of a full-text database are increased.

Description

technical field [0001] The invention relates to a technology for storing data in a database, in particular to an application-oriented mixed row-column storage method for storing massive unstructured data objects. Background technique [0002] At present, the data managed by the database management system is presented in the form of a two-dimensional table of rows and columns, where rows correspond to records, and columns correspond to fields of records. [0003] When traditional row-based databases store data, the data value of a row is written into memory or hard disk as a one-dimensional string. Therefore, if you want to query a field value of a record, you need to read the entire record. But for query-intensive applications, most queries often only use a part of the field values ​​of the records. The use of row storage technology will cause the system to have the following deficiencies in data reading and storage, and the performance cannot meet the needs of applications...

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 山西同方知网数字出版技术有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap