Method for synchronizing table data application programs of network databases

A technology of application synchronization and data synchronization, applied in special data processing applications, electrical digital data processing, instruments, etc., can solve data consistency problems and other problems, achieve the effect of ensuring security and reducing the use of network bandwidth

Active Publication Date: 2011-05-18
INSPUR SOFTWARE CO LTD
View PDF4 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The purpose of the present invention is to provide a method to solve the problem of data consistency between databases after database segmentation, so as to realize the purpose of database distributed architecture

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 synchronizing table data application programs of network databases
  • Method for synchronizing table data application programs of network databases
  • Method for synchronizing table data application programs of network databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0020] Embodiment: Introduce the realization content of main several parts respectively below:

[0021] initialization

[0022] The initialization process is actually the process of the service engine reading configuration information, including reading the synchronization service-related information defined by the system from the upload URL table (UPLOAD_URL), and reading the synchronization service corresponding to the relevant table from the URL mapping table (URL_TAB). Service information, confirm the specific table that needs to be transferred, and which synchronization service to use for synchronization; then read the configuration information of each table that needs to upload data, mainly including upload data table (UPLOAD_TABS), upload field table (UPLOAD_COLS), incremental Information of fields table (INCREMENT_COLS), custom function table (CUSTOMIZE) and other tables. As shown in the table below.

[0023] UPLOAD_URL

[0024] serial number

column n...

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 synchronizing table data application programs of network databases, which comprises the steps of: firstly, defining two databases needing synchronizing as a client end and a server end, defining the database at a data source end as the client end, defining the database at one end needing updating data as the server end, determining tables needing synchronizing and defining corresponding synchronizing services by timer service of a client end system though reading basic configuration information tables, realizing data synchronization between the two databases by the synchronizing service and the synchronizing service of the server end through establishing an HTTP (Hyper Text Transfer Protocol) channel, compressing the data before the data enters the HTTPchannel, decompressing after the synchronizing service of the server end is carried out, analyzing the database after decompressing, and executing updating the data.

Description

technical field [0001] The invention relates to the field of distributed databases in the Internet industry, the synchronization between network database data realized through the J2EE framework, in particular to a method for realizing the application program of network database table data synchronization. Background technique [0002] With the rapid development of Internet applications, enterprises have their own application systems and websites on the Internet; the restrictions of different networks across regions lead to the need for sites to be established in different regions due to network reasons, even in the same city or region. Because of the huge number of users, it is difficult to meet the consideration of hardware alone. The technical architecture needs to support clustering, including load balancing of web servers, clustering of application servers, and horizontal segmentation at the database level, all in order to support distributed In this context, most web s...

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): H04L29/08G06F17/30
Inventor 宋智强武志强
Owner INSPUR SOFTWARE CO LTD
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

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap