Supercharge Your Innovation With Domain-Expert AI Agents!

Database establishment method and database establishment system based on column storage technology

A technology for establishing a method and database, which is applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as inappropriate establishment of databases, large-scale data storage, and poor convenience of analysis and retrieval, and achieve the effect of improving storage

Active Publication Date: 2013-01-23
苏州迈科网络安全技术股份有限公司
View PDF2 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] For row storage technology, the basic operation data is a record (composed of multiple columns), and its data structure is stronger. It is more convenient to change the data (such as: delete, modify) and realize the strong consistency of the data. The convenience of storage, analysis and retrieval of large quantities of data is poor, and it is not suitable for establishing a 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
  • Database establishment method and database establishment system based on column storage technology
  • Database establishment method and database establishment system based on column storage technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0031] Such as figure 1 As shown, the database establishment method based on column storage technology in an embodiment of the present invention includes:

[0032] S1. Create a table, the table is a two-dimensional table in the corresponding relational database, which is stored in the form of a directory, and the directory name is the table name (unique in the system);

[0033] S2. Create a column file describing the column information of the data structure in the table; this column file is created when the table is created, and it records the following information:

[0034] options nature illustrate column name must unique in the table type of data must Support byte array, byte, short (2-byte integer), int (...

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 provides a database establishment method and a database establishment system based on the column storage technology. The database establishment method comprises the steps of establishing a table; establishing a column file for forming column information and describing data structure in the table; storing column metadata forming the column information into the column file, and partitioning the column file into blocks, wherein each block stores a fixed number of column metadata; and generating an array with all bytes in the table, calculating a hash valve for each array metadata of the array, and storing the hash valve into the column file. Compared with the prior art, the database establishment method has the advantages that a database on basis of the storage technology can be established, and the convenience for the storage, the analysis and the retrieval of the database can be greatly enhanced.

Description

【Technical field】 [0001] The invention relates to a database establishment method and system based on column storage technology. 【Background technique】 [0002] With the development of Internet technology, the continuous update of IT technology, and the deepening of social informatization, data has ushered in explosive growth. Traditional relational databases are no longer suitable for such huge storage and computing requirements. Emerging big data storage databases have two options: "record" based row stores and column stores. [0003] For row storage technology, the basic operation data is a record (composed of multiple columns), and its data structure is stronger. It is more convenient to change the data (such as: delete, modify) and realize the strong consistency of the data. The convenience of storage, analysis and retrieval of large quantities of data is poor, and it is not suitable for building a database. [0004] In view of this, the present invention provides a m...

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 苏州迈科网络安全技术股份有限公司
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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