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

Method for rapidly writing mass data into database once

A database, one-time technology, applied in electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as writing, and achieve the effect of fast writing and speeding up data writing.

Inactive Publication Date: 2010-08-11
LANGCHAO ELECTRONIC INFORMATION IND CO LTD
View PDF3 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since data is used to store data, a problem that developers can never avoid is writing data to the database
As the performance of the database management system is getting higher and higher, the speed of accessing a small amount of data is faster, but when a huge amount of data is written to the database in an instant, the database management system still needs a certain amount of time to process, and this time sometimes is unbearable for users

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 for rapidly writing mass data into database once
  • Method for rapidly writing mass data into database once
  • Method for rapidly writing mass data into database once

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0015] The method of the present invention is described in detail below with reference to the accompanying drawings.

[0016] Refer to the attached figure 2 , the content of the present invention is described with a specific example to realize the process of this method.

[0017] As described in the summary of the invention, the architecture of the present invention mainly includes: a temporary table generation and processing unit, a temporary table, and a destination table processing unit. in:

[0018] The temporary table generation and processing unit is the core of the method, dynamically generates a temporary table according to the amount of written data, and writes the data into the generated temporary table.

[0019] The temporary table is an intermediate in this method, temporarily storing the written data.

[0020] The destination table processing unit judges the system load, and when the system is idle, obtains data from the temporary table and writes it into 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 provides a method for rapidly writing mass data into a database once, which comprises the following operation steps of: when mass data are to be written into a target table in the database, dynamically generating a plurality of temporary tables according to the written data volume by a temporary table generating and processing unit and writing table names into a temporary name table; then starting a plurality of threads for writing the data into all temporary tables in groups and finishing in shorter time by writing a plurality of tables; automatically judging the loading condition of a computer by a target table processing unit; executing the target table writing operation when a system is idle; reading the table names of the temporary tables from the temporary name table, and then cyclically reading all records from each table according to the table names; writing to the target table, and finishing the operation.

Description

technical field [0001] The invention relates to the application field of database systems, in particular to a method for one-time and fast writing of huge amount of data into a database. Background technique [0002] At present, computers are becoming more and more popular, and their applications are becoming wider and wider. With the wide application of information systems, due to the limitations of file redundancy and ease of operation, it is a relatively common way to use databases to access data. Since data is used to store data, one problem that developers can never avoid is writing data to the database. As the performance of the database management system is getting higher and higher, the speed of accessing a small amount of data is faster, but when a huge amount of data is written to the database in an instant, the database management system still needs a certain amount of time to process, and this time sometimes It is unbearable for users. [0003] In order to sol...

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 LANGCHAO ELECTRONIC INFORMATION IND CO LTD
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