Database data reading-writing method and device

A data reading and writing, database technology, applied in the database field, can solve problems such as initial data dissatisfaction, delay in work, slowness, etc., and achieve the effect of improving concurrency and efficiency

Active Publication Date: 2016-11-23
安徽三禾一信息科技有限公司
View PDF4 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, in actual production, when hundreds of thousands, millions, or even larger data are encountered, this method is extremely slow. A background synchronization data task may not...

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 data reading-writing method and device
  • Database data reading-writing method and device
  • Database data reading-writing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0046] In order to facilitate the understanding of those skilled in the art, the present invention will be further described below in conjunction with the accompanying drawings, which cannot be used to limit the protection scope of the present invention. It should be noted that, in the case of no conflict, the embodiments in the present application and various manners in the embodiments can be combined with each other.

[0047] It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0048] A mobile terminal implementing various embodiments of the present invention will now be described with reference to the accompanying drawings. In the following description, use of suffixes such as 'module', 'part' or 'unit' for denoting elements is only for facilitating description of the present invention and has no specific meaning by itself. Therefore, "module" and "component" may be used m...

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 database data reading-writing device and method. The device is arranged on a data server. The database data reading-writing device comprises a reading unit for reading original data from an application server, packaging the original data to obtain target data and caching the target data to a caching queue and a submitting unit for reading conditions according to preset caching and storing the target data cached in the caching queue in a database. By the adoption of the scheme, reading-writing tasks in the database data synchronizing process are separated, the reading unit reads the data from a peripheral database, performs package and then writes the data in a high-speed caching queue, the caching queue has high reading-writing rate, accordingly the task reading efficiency is improved, the submitting unit extracts the data from the queue and performs batch saving according to given fixed step length. Accordingly, the reading unit and the submitting unit respectively and independently operate, and the concurrence efficiency is improved.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a method and device for reading and writing database data. Background technique [0002] With the establishment of a new project, when building a new project, a large amount of data is required to initialize the database. These data often come from multiple peripheral system databases. A data table in this system often needs to synchronize data from multiple peripheral databases. It takes a lot of time at the beginning of the project Develop timing tasks to synchronize data from different data tables in different databases to this system. [0003] Usually choose a popular (ORM) database mapping framework, such as Hibernate, without writing SQL statements, read from the peripheral database, traverse the data list, and insert into the database one by one. This mode is more efficient in development and code writing is faster. [0004] However, in actual production, when hundreds...

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
IPC IPC(8): G06F17/30
CPCG06F16/217G06F16/27
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