Method and system for inserting data into database

A database and data technology, applied in the database field, can solve problems such as poor versatility, and achieve the effects of less consumption and occupation, better versatility, and improved efficiency

Pending Publication Date: 2017-07-18
BEIJING KUANGEN NETWORK TECH
View PDF0 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Although table structure design and SQL statements are portable between different database software; however, this kind of table structure design and SQL statement optimization for specific business scenarios is no longer applicable to other business scenarios. The versatility of different business scenarios is relatively poor

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 inserting data into database
  • Method and system for inserting data into database
  • Method and system for inserting data into database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0028] see figure 1 Shown is a schematic structural diagram of a database applying an embodiment of the present invention, such as figure 1 As shown, the database includes a data header table and a data information table, and stores data by combining the data header table and the data information table. Among them, the data serial number 1, data serial number 2 ~ data serial number n data serial number column and the data header information column corresponding to the data serial number column are recorded in the data header table; the data information table has the data serial number column and function code data information column. The data link between the data information table and the data header table is established through the data sequence number column, for example: the data header information corresponding to the data sequence number 1 and the function code information 1 corresponding to the data sequence number 1 form data 1.

[0029] In one embodiment, n pieces o...

Embodiment 2

[0041] Embodiment 2 can be regarded as a further optimization of Embodiment 1, because in Embodiment 1, the implementation of inserting data into the database, although only need to query the data header table part in the database can complete the insertion of data can be in To a certain extent, the efficiency of data insertion into the database is improved, but there is still room for improvement. Embodiment 2 here discloses a better embodiment relative to Embodiment 1.

[0042] In the step 102 of the method shown in the first embodiment, the scheme of passing through the buffer queue is introduced, that is, the execution of the step 102 may include:

[0043] A matching check is performed on the obtained data header information through the cache queue that caches multiple pieces of data header information in the data header table, so as to determine whether the obtained data header information exists in the data header table.

[0044] When the obtained data header information...

Embodiment 3

[0061] Embodiment 3 can be regarded as a more preferred embodiment of Embodiment 2 in a certain application scenario, because part of the content of Embodiment 2 states that the data to be inserted in the cache queue can be updated through the heat algorithm to improve the hit rate, so as to improve the database scheme for data insertion efficiency. However, the cache queue is generally implemented based on the first-in-first-out queue (FIFO, FirstInput First Output), but in the second embodiment, the cache queue is updated based on the data heat update and the FIFO method is used to update the cache queue. There is still room for improvement. , because the FIFO method is very likely to cause the data header information with a higher data popularity value to be updated. In view of this, the embodiment of the present invention discloses another embodiment 3 here, to replace the first-in-first-out (FIFO) method of the buffer queue under normal circumstances.

[0062] More speci...

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 disclosure relates to a method and system for inserting data into a database, and relates to the technical field of a database. The method for inserting the data into the database comprises the steps of: acquiring data head information and functional data information of data to be inserted; judging whether the acquired data head information exists in a data head table in the database, wherein a corresponding relationship between the data head information of the data and a data sequence number is stored in the data head table; when the acquired data head information exists in the data head table, acquiring the data sequence number corresponding to the data head information from the data head table; and inserting the data sequence number as well as the functional data information corresponding to the acquired data head information into a data information table, wherein a corresponding relationship between the data sequence number of each piece of data and the functional data information is stored in the data information table. Therefore, efficiency of inserting the data into the database is promoted, and the method and the system have excellent universality for various database insertion scenes.

Description

technical field [0001] The present disclosure relates to the technical field of databases, in particular to a method and system for inserting data into a database. Background technique [0002] With the development of Industry 4.0, the industrial control network has a trend of networking, IP, and intelligence, which also brings requirements for the security of industrial control networks, so more and more network audit products are used in industrial control network. Due to the hard real-time requirements of industrial control networks, the requirements for database insertion efficiency in network audit products are very high. [0003] In the current related technologies, the technologies to improve the efficiency of inserting data into the database mainly rely on the configuration value optimization of the database itself and SQL (Structured Query Language, Structured Query Language) statement-level optimization. These two solutions have their own usage scenarios , there ...

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/2308
Inventor 杨小帅高飞
Owner BEIJING KUANGEN NETWORK TECH
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