Supercharge Your Innovation With Domain-Expert AI Agents!

Inter-database data interaction method and system, database of transmitter and database of receiver

A data interaction and database technology, applied in the database field, can solve problems such as high cost, data errors, and expensive third-party servers, and achieve the effects of reducing costs, avoiding cost increases, and improving accuracy and real-time performance.

Inactive Publication Date: 2011-05-04
CSMC TECH FAB1
View PDF4 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] 1. Since it is expensive to set up a third-party server that can realize the above data type conversion, the cost of the above solution is very high;
[0008] 2. The third-party server performs data type conversion operations regularly, that is, the data sent by the source database 11 and the target database 12 to the third-party server needs to wait until the conversion time before being converted by the third-party server, so real-time data interaction cannot be realized;
[0009] 3. Since the data interaction between the source database 11 and the target database 12 needs to be transferred through a third-party server, the nodes for data transmission are added, and the possibility of data errors is relatively high

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
  • Inter-database data interaction method and system, database of transmitter and database of receiver
  • Inter-database data interaction method and system, database of transmitter and database of receiver
  • Inter-database data interaction method and system, database of transmitter and database of receiver

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0033] Embodiment 1. Assuming that the source database needs to insert Chinese data into table a of the target database, the source database is used as the sender database, the target database is used as the receiver database, and the table a is the data object corresponding to the Chinese data.

[0034] refer to image 3 , is the implementation process diagram of the first embodiment of the present invention, the implementation process includes:

[0035] Step a1, the target database pre-creates view a and trigger a of table a, where view a is the receiver view, trigger a is triggered by the update of view a, and the trigger a is used to receive the hexadecimal value received by the target database The data is converted into ZHS16GH encoded Chinese data; in the Oracle database, trigger a can be Trigger Insert or Trigger update;

[0036] In step a2, the source database establishes a data connection with the target database, such as but not limited to Dblink;

[0037] Step a3, t...

Embodiment 2

[0047] Embodiment 2. Assuming that the source database needs to read Chinese data in table b of the target database, the source database is used as the receiver database, and the target database is used as the sender database.

[0048] refer to Figure 4 , is the implementation flowchart of the second embodiment of the present invention, the implementation process is:

[0049] Step b1, the target database pre-creates view b of table b as the view of the sender;

[0050] Step b2, establishing a data connection between the source database and the target database, such as a Dblink connection, etc.;

[0051] Step b3, the source database selects view b in the target database;

[0052] Step b4, view b converts the Chinese data encoded in ZHS16GH in form b into hexadecimal data;

[0053] Step b5, the target database sends the hexadecimal data to the source database through Dblink;

[0054] In step b6, the application server connected to the source database converts the received h...

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 an inter-database data interaction method, an inter-database data interaction system, a database of a transmitter and a database of a receiver, in order to reduce the cost of data interaction between the databases adopting different encoding types to encode data and improve the accuracy and the real time of data interaction. The method comprises the following steps of: converting the data encoded by a first encoding type in the database of the transmitter into the data encoded by a third encoding type; transmitting the converted data to the database of the receiver by the database of the transmitter; receiving the transmitted data by the database of the receiver; and converting the data received by the database of the receiver into the data encoded by a second encoding type, wherein the data encoded by the third encoding type can be identified by the database of the transmitter and the database of the receiver.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data interaction method and system between databases, a sender database, and a receiver database. Background technique [0002] When an application server manages data stored in one or more databases, it can usually access the databases through the application layer for management. However, there are currently some application servers that cannot access more than two databases through the application layer. [0003] refer to figure 1 , is a schematic diagram of the database system structure in the prior art. According to this figure, if the application server 10 cannot access the source database 11 and the target database 12 through the application layer, the source database 11 and the target database 12 are connected to each other. The access process is: the application server 10 accesses the source database 11 through the data layer, and then accesses the target database 12 through ...

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
Inventor 杨郁州
Owner CSMC TECH FAB1
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com