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

Method for inserting multiple data sources into databases

A multi-data source and database technology, applied in the Internet field, can solve problems such as slow insertion speed, slow response, affecting database performance, etc., to reduce pressure and improve performance.

Inactive Publication Date: 2016-12-14
GUANGDONG ESHORE TECH
View PDF6 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] Using the queue method can solve the problem of slow user response on the interface, but taking out data from the queue regularly and inserting them into the database one by one will still cause slow insertion speed, affect database performance, and cannot effectively solve the fundamental problem

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 inserting multiple data sources into databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0022] In the use of the call platform, a large amount of CDR data will be generated every moment, and these data must be inserted into the database. Inserting one by one into the database will cause problems such as delay and database blocking. In order to solve this problem, the present invention proposes a method for quickly inserting data into a database based on multiple data sources. Through this method, CDR data can be quickly and batch-inserted into the data...

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 method for inserting multiple data sources into databases. The method includes: dividing a service demand into multiple data sources, wherein a message queue with unfixed size is correspondingly established for each data source, a thread for regularly acquiring queue data for each queue, and a corresponding thread pool is established for each thread; calling an interface for inserting CDR data when CDR (calling detail records) generate data to store the data into the corresponding message queues of the data sources; regularly acquiring thread data of the queues, storing the thread data into the corresponding thread pools in a grouping manner, allowing the thread pools to call their tasks when the thread pools have idle threads, and submitting the grouped CDR data in the tasks to the corresponding databases once in a batch. The method can rapidly insert the CDR data into the corresponding database in real time in a batch, can relieve the load of the databases, and can improve the performance of the databases.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a method for inserting multiple data sources into a database. Background technique [0002] CDR (calling detail records) is an important data parameter in the voice traffic system. The operating system will have more CDR data for each call, call, hang-up, etc., and all the generated CDR data must be inserted into the database in real time. So that the query can be displayed on the system page. [0003] Most of the technical solutions implemented in the existing system are inserted into the database one by one. Every time a CDR record is generated in the system, the method of inserting into the database is called immediately, and then waits for the return, and finally the processing result is displayed on the page. [0004] Using the scheme of inserting into the database one by one, of course, it can meet the requirements when the traffic volume is not large, but when the tr...

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/30G06F9/54
CPCG06F9/546G06F16/27G06F2209/548
Inventor 刘栩生李幼庭王向辉曹露露黄正华
Owner GUANGDONG ESHORE TECH