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

Novel library structure data

A library structure and data technology, applied in the field of library structure data, can solve the problems of low efficiency of data import and export, achieve the effect of improving speed and saving storage space

Inactive Publication Date: 2018-10-09
亳州中药材商品交易中心有限公司
View PDF2 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Patent No. of the prior art: 201610889114.5, which discloses a data integration structure of a relational database, provides a data integration structure of a relational database, and realizes convenient and fast transfer from MySQL database to MySQL database, from Oracle database to The data integration of the MySQL database reduces the workload of importing and exporting data, making data synchronization easier and more controllable; Patent No.: 201410818000.2, which discloses a mixed data storage method in the database, for column storage in complex application scenarios The database provides a method to effectively solve the low materialization efficiency of the select* application model, which improves the query efficiency of the column-storage database for the select* type, expands the scope of application of the column-storage database, and reduces the occupation of the existing row-column hybrid storage method. space, and data compression efficiency is similar to that of column storage
In the existing technology, relational data is still stored and processed through row storage, and it still needs to be collected across multiple systems, and the efficiency of data import and export is low

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
  • Novel library structure data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0054] A new type of database structure data, constructing a "vertical structure database", using the latest vertical storage technology. The vertical structure database will be used as the shared database of the business department. Analysts only need to conceive relevant ideas and select the keywords they need on the "vertical structure database" to summarize relevant data. If you suddenly find that some fields are omitted or some fields are not needed, you only need to re-check the relevant fields. Due to the high efficiency of the vertical storage database, the process of re-selecting fields for processing is very fast, and the required data or list can be re-output in a very short time.

[0055] Step 1. Establish a mapping vertical table of at least one keyword and at least one classification identifier.

[0056] Obtain at least one keyword and at least one category identifier, and establish a mapping vertical table according to the rule that one category identifier corr...

Embodiment 2

[0068] A new type of database structure data, constructing a "vertical structure database", using the latest vertical storage technology. The vertical structure database will be used as the shared database of the business department. Analysts only need to conceive relevant ideas and select the keywords they need on the "vertical structure database" to summarize relevant data. If you suddenly find that some fields are omitted or some fields are not needed, you only need to re-check the relevant fields. Due to the high efficiency of the vertical storage database, the process of re-selecting fields for processing is very fast, and the required data or list can be re-output in a very short time. The data screening and merging methods of the vertical structure database include:

[0069] S1: Use the storage format to store the first-level value corresponding to the first-level classification identifier;

[0070] S2: Subdivide the data in each category identifier column into data p...

Embodiment 3

[0090] A new type of database structure data, the hash index method in the vertical structure database also includes a multi-hash map index method, including:

[0091] 1) The first layer of hash mapping is done on the vertical structure database, and all written data is assigned to a specific hash bucket after being mapped by the first layer of hash function through the classification identifier;

[0092] 2) Build a B+ tree on the value space of the first-level hash. The original linear search time complexity is O(n), and it is optimized to tree search. The tree search time complexity is O(log n), and the hash map is optimized value search;

[0093] 3) Hash-mapping the first-level hash buckets again through the second-level hash function, that is, re-dividing the first-level hash buckets to reduce the data capacity in the hash buckets;

[0094] 4) Pointer connections are established between two adjacent layers of hash buckets. The next layer of hashes is a subdivision of the ...

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 relates to novel library structure data which comprises a vertical structure database. A use method of the vertical structure database comprises the steps that 1, at least one keyword and a mapping vertical table of at least one classification identification are built; 2, user data is written in a data field corresponding to the classification identification in the database; 3, preset classification identification corresponding to a preset keyword is found from the stored mapping vertical table according to the preset keyword; 4, a preset data field is read in the database according to the preset classification identification; 5, data contained in the preset data field is calculated according to a preset algorithm, and an output result is obtained. The novel library structuredata has the advantages that the problem that when an existing computer platform system processes data, all data needs to be re-extracted when missing data needs to be extracted is solved; the data processing speed is increased, and reliability of the platform system is improved; the storage space is saved through a vertical storage technology.

Description

technical field [0001] The invention relates to the field of data processing, in particular to a novel library structure data. Background technique [0002] With the implementation of the Smart China strategy, big data has a profound impact on various industries. Based on the needs of dealer segmentation and refined marketing of dealers, it has gradually become the main means of reforming the Chinese herbal medicine market. At present, for the data management and marketing needs of the bulk trading platform, the business department usually analyzes various business indicators, screens out the business indicators that need attention, and then submits a specific list of relevant business fields collected by the technical department, and finally the technical department based on According to the plan proposed by the business department, the relevant data is manually analyzed and the results are output. Based on the current data analysis process, it is necessary to frequently ...

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 亳州中药材商品交易中心有限公司