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

Method for realizing heterogeneous database data acquisition

A data collection and database technology, applied in structured data retrieval, database management systems, special data processing applications, etc., can solve problems such as time-consuming, labor-intensive, manpower maintenance, and incomplete consideration.

Pending Publication Date: 2021-12-21
TAIYUAN GREAT TIMES TECH CO LTD
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, many companies did not have such needs in the early stage of the project, or did not consider fully, which led to the use of different systems by the head office and branch offices, resulting in different databases and tables, which brought great inconvenience to the later data collection
[0003] In addition, the general data acquisition system is developed separately for each branch, and then the data is transmitted to the head office. The development work is cumbersome, and human maintenance is required in the later stage, which is time-consuming and laborious.

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 realizing heterogeneous database data acquisition
  • Method for realizing heterogeneous database data acquisition
  • Method for realizing heterogeneous database data acquisition

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0097] Embodiments of the present invention provide a method for realizing heterogeneous database data acquisition, such as figure 1 shown, including:

[0098] Step 1: according to the basic information of each branch database, configure database information and trigger rules for each branch database;

[0099] Step 2: According to the database configuration information of each branch, select the database driver, and determine the data acquisition interface based on the database driver;

[0100] Step 3: Log in to the branch database according to the trigger rule, and use the data collection interface to collect data;

[0101] Step 4: Process the collected data and summarize it to the head office database.

[0102] In this embodiment, the database driver is essentially a driver program, which is used to realize the startup and various operations of the database.

[0103] In this embodiment, the trigger rule is used to wake up the branch database to provide a basis for subsequ...

Embodiment 2

[0106] On the basis of Embodiment 1, the embodiment of the present invention provides a method for realizing heterogeneous database data collection. Before step 1, it also includes: obtaining the basic information of each branch database, and the process is as follows:

[0107] Obtain the key value of each branch database, and determine the data type of the key value;

[0108] determining a preset parsing rule corresponding to the data type, using the preset parsing rule to parse the key value, and obtaining characteristic data corresponding to the key value;

[0109] Determine the port range of each branch database service based on the characteristic data, and determine the database type of each branch database according to the mapping relationship between the port range-database type;

[0110] Determine the feature extension rules of the database type, and use the feature extension rules to scan the databases of each branch company to obtain the basic information of the data...

Embodiment 3

[0119] Based on Embodiment 1, the embodiment of the present invention provides a method for realizing heterogeneous database data collection. In step 1, configure database information and trigger rules for each branch database according to the basic information of each branch database include:

[0120] Based on the basic information of each branch database, determine the configuration server and configuration information attributes;

[0121] Based on the configuration server, determining a configuration transmission start point and a configuration transmission end point;

[0122] Obtain a dynamic configuration process based on the configuration information attribute, and determine a configuration transmission process point;

[0123] Establishing a configuration path based on the predetermined configuration transmission starting point, configuration transmission process point, and configuration transmission end point;

[0124] Acquire database information from the configurati...

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 realizing heterogeneous database data acquisition, which comprises the following steps: configuring database configuration information and a trigger rule for each branch company database according to basic information of each branch company database; selecting a database driver according to the database configuration information of each branch company, and determining a data acquisition interface based on the database driver; logging in a branch company database according to the trigger rule, and performing data acquisition by using the data acquisition interface; processing the collected data and summarizing the data to a database of a head office. Data of databases of all branch companies are directly collected and summarized to a database of a head office, and great inconvenience brought to later data summarization due to inconsistent data formats is avoided; by configuring database information and trigger rules for the databases of the branch companies, one-time development of database drive is realized. The invention is suitable for each branch company.

Description

technical field [0001] The invention relates to the technical field of data collection, in particular to a method for realizing heterogeneous database data collection. Background technique [0002] Data has become a major priority for businesses of all sizes. As the technology to collect and analyze data proliferates, so does the ability of businesses to put that data in context and derive new insights from it. In order to more accurately predict the behavior path of consumers, companies need to collect information every day, store and analyze the data. If there is no data support, the marketing of the enterprise may be blind marketing, and the purpose of the brand to hope that the products and services can reach the target audience or role is very likely to fail. However, many companies did not have such needs in the early stage of the project, or did not consider fully, which led to the use of different systems by the head office and branch offices, resulting in differen...

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): G06F16/25
CPCG06F16/25Y02D10/00
Inventor 和雄伟师丹华杨光华魏专利梁晓霞
Owner TAIYUAN GREAT TIMES TECH CO LTD