CN1477562A - Distributed data processing method on information management system with C/S structure - Google Patents

Distributed data processing method on information management system with C/S structure Download PDF

Info

Publication number
CN1477562A
CN1477562A CNA021365768A CN02136576A CN1477562A CN 1477562 A CN1477562 A CN 1477562A CN A021365768 A CNA021365768 A CN A021365768A CN 02136576 A CN02136576 A CN 02136576A CN 1477562 A CN1477562 A CN 1477562A
Authority
CN
China
Prior art keywords
database
branch
distributed data
management system
information management
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CNA021365768A
Other languages
Chinese (zh)
Other versions
CN1238806C (en
Inventor
陶怀仁
李光亚
于俊府
王兆进
王英杰
沈宇青
王巍
周栋
翁佩芳
范春
袁力靖
唐春风
矫成东
查峻
刘继华
孙嘉明
徐奎东
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
WANDA INFORMATION CO Ltd
Original Assignee
WANDA INFORMATION CO Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by WANDA INFORMATION CO Ltd filed Critical WANDA INFORMATION CO Ltd
Priority to CN02136576.8A priority Critical patent/CN1238806C/en
Publication of CN1477562A publication Critical patent/CN1477562A/en
Application granted granted Critical
Publication of CN1238806C publication Critical patent/CN1238806C/en
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The present invention provides a distributed data processing method on the information management system of C/S structure, it has subsection data base and central data base, and has a service duplication and treatment process between all the bata bases. The data processing method can reduce requirements for network and communication band width, can raise operation efficiency of the system, and reduce operation cost of the network and can raise reliability of said system.

Description

The method of distributed data processing on the information management system of C/S structure
Technical field
The present invention relates to information management system, relate in particular to the method for distributed data processing on the information management system of C/S structure.
Background technology
Client/server (C/S) structure is the main architecture that adopts in the current information management system, abbreviates the C/S architecture as.In the information management system of C/S structure, be furnished with high performance private server, server end installation data library software, client application software sends request with sql like language to server, result after server will be handled passes to client, is request and the relation of serving between the two.
But traditional C/S structure is had relatively high expectations to network and communication bandwidth, and the operational efficiency of system is not high, and taking precautions against calamities of system is indifferent.
Summary of the invention
The invention provides a kind of data processing method that can overcome the technical disadvantages of centralized data processing on traditional C/S structural information management system.Utilize this data processing method, can reduce requirement, improve the operational efficiency of system, reduce the operating cost of network, improve the reliability of system network and communication bandwidth.
The objective of the invention is to realize as follows:
Step a, set up a central database, deposit all business datums, each branch's database is summarized in central database by the data synchronization means with whole business datums;
Step b, set up the local branch database of several branches, deposit business datum relevant with this branch and common data, the service unit of each branch uses local database to carry out vocational work;
Step c, need carry out the table that data duplicate to all increase a column-flag in branch's database on the basis of former database, the value of this column-flag has determined this table whether will copy to central database still will copy to other branch's databases; If will copy to central database, then enter steps d; If will copy to branch's database 2, then enter step f from branch's database 1;
Steps d, be the master end, on central database, set up readonlysnapshot with relevant table in branch's database, at the master end with the value of the column-flag described in the step c as the trigger condition of holding definition of data to duplicate at master; The naming rule that central database is set up snapshot is, former table name+" _ "+branch's database code at table place;
Step e, in central database, set up the partition view of a former table name of called after, enter step h and finish based on the snapshot of all branch's databases;
Step f, the table that need duplicate with branch's database 1 are the master end, on branch's database 2, set up updateble snapshot, and master end with the value of the column-flag among the step c as the trigger condition of holding definition of data to duplicate at master; The naming rule of setting up table at described branch database 1 is, former table name+" _ "+branch's database 1 code; Table name corresponding in each branch's database of snapshot title and other that branch's database 2 is set up is identical; The naming rule that branch's database 2 is set up table is, former table name+" _ "+branch's database 2 codes.
Step g, the view that in distributed data base 2, will set up a former table name of called after based on the snapshot and the distributed data base 2 own corresponding table of each branch's database 1; On view, be established to the trigger of corresponding table or snapshot, make this view can be considered a table.
Step h, end.
Method provided by the invention helps reducing the requirement to network and communication bandwidth, improves the operational efficiency of system, reduces the operating cost of network, improves the reliability of system.The centralized central database that is provided with in the inventive method helps the comprehensive inquiry and the statistics of information, help providing omnibearing information service, help the data-interface that externally provides unified, help the information sharing of total system and reduce the complicacy of information sharing.The strategy that the present invention adopts the distributed treatment of data to combine with the centralized information service can be given full play to the advantage of various data management modes, properly solves the contradiction of management and efficient; Central database, each branch's database data backup each other, and can improve the ability of taking precautions against natural calamities of system.
Description of drawings
Fig. 1: distributed database structure figure
Fig. 2: the duplicating of the business datum between branch's database 2 and other branch's database (comprising distributed data base 1)
Fig. 3: each branch's data bank service data gathering to central database
Embodiment
Further introduce the present invention below in conjunction with drawings and Examples.
Give an example and further specify characteristics of the present invention:
The information management system Test_MIS of an existing C/S structure, it has only a flow process, promptly accepts in branch office, examines in main office then.If examine defectively, branch office is rejected in application.Branch office can the query statistic business datum in addition.Have only a table---" tab_test " in the database
If adopt traditional centralized data management, as long as a sets of data library software is installed on the server of main office, use application program to connect the database of main office in branch office then, just can carry out all business operations and query statistic function.If but obstructed with the connection line of main office, even the server of the main office machine of delaying, the business of so all branch officies all can't have been carried out.This situation may often take place along with the user's of branch office increases, and can influence work efficiency greatly like this.
If use DDM method proposed by the invention, reduce requirement to network and communication bandwidth, improve the operational efficiency of system, reduce the operating cost of network, improve the reliability of system.
The total system design as shown in Figure 1.
Here main office's Service Database is mainly deposited branch office and is uploaded the data that need examine and the data of having examined corresponding to 2 databases of the branch in the accompanying drawing 1.
The 1...n of branch office database is deposited the business datum of each branch office corresponding to the 1...n of the branch database in the accompanying drawing 1.
Whole business datums is deposited corresponding to the central database in the accompanying drawing 1 in main office combined data storehouse.
At first design table " tab_test " increases a column-" flag " on the basis of former data structure, is defined as 2 char temporarily, and on behalf of a kind of data, each all duplicate that (0-does not duplicate; 1-duplicates).First: represent uploading, assigning between branch office and the main office's Service Database; Second: represent gathering of each Service Database to duplicate, comprising: main office's Service Database and branch office's database duplicating to main office combined data storehouse.
If realize uploading, assigning between branch office and the main office's Service Database (be equivalent to realize between branch's database 1 and the branch's database 2 business datum duplicate), see accompanying drawing 2, the table " tab_test " that carry out following steps: a, duplicates with the needs on branch office's database is the master end, on main office's Service Database, set up updatable Snapshot, the trigger condition of duplicating at master end definition of data (is judged the value of the column " flag " of every table then, substr (tab_test.flag, 1,1)=' 1 ').The naming rule of setting up tab_test on b, the branch office's database is: ' tab_test_ '+other branch office's codes are (such as 1,2,3...n).Table name corresponding in the Snapshot title of setting up on c, the main office's Service Database and other branch office's databases is identical.Corresponding tables " tab_test " called after in d, the main office's Service Database: ' tab_test_0 '.E, in main office's Service Database, will set up a View, called after tab_test based on the snapshot of other branch office's databases and own corresponding table.F, on the View of main office's Service Database, set up Trigger (instead of insert/update/delete to corresponding table or snapshot), make this View can be considered a table and operate.
If realize business datum the gathering of each branch office's database and main office's Service Database to main office combined data storehouse, see accompanying drawing 3, carry out following steps: a, be the master end with table tab_test in branch office's database and the main office's Service Database, on main office combined data storehouse, set up Readonly Snapshot respectively, (judge the value of the column " flag " of every table in the trigger condition that master end definition of data duplicates, substr (tab_test.flag, 2,1)=' 1 ').The Snapshot naming rule of setting up on b, the main office combined data storehouse is: ' tab_test_ '+code.C, the snapshot based on all branch officies and main office's Service Database in main office combined data storehouse set up a Partition View (called after tab_test).
Finish above these steps, a distributed data base has just been put up.Later on all application programs are only operated (it is transparent that relevant data are duplicated application programs) to the database object of tab_test by name, application program need be controlled at the proper time of business flow processing, and the value of the column " flag " among the tab_test correctly is set.
Such management information system, main office carries out in the combined data storehouse comprehensive inquiry and the statistics of information, help providing omnibearing information service, help the data-interface that externally provides unified, help the information sharing of total system and reduce the complicacy of information sharing.
Main office's database, each branch office's database data backup each other, and can improve the ability of taking precautions against natural calamities of system.
Help reducing requirement, improve the operational efficiency of system, reduce the operating cost of network, improve the reliability of system network and communication bandwidth.

Claims (7)

1, the method for distributed data processing on a kind of information management system of C/S structure is characterized in that described method comprises the steps:
Step a, set up a central database, deposit all business datums;
Step b, set up the local branch database of several branches, deposit business datum relevant and common data with this branch;
Step c, need carry out the table that data duplicate to all increase a column-flag in branch's database on the basis of former database, the value of this column-flag has determined this table whether will copy to central database still will copy to other branch's databases; If will copy to central database, then enter steps d; If will copy to branch's database 2, then enter step f from branch's database 1;
Steps d, be master end, on central database, set up readonly snapshot with branch's database, at the master end with the value of the column-flag described in the step c as the trigger condition of holding definition of data to duplicate at master;
Step e, in central database, set up the partition view of a former table name of called after, enter step h and finish based on the snapshot of all branch's databases;
Step f, be master end, on branch's database 2, set up updateble snapshot with branch's database 1, and the master end with the value of the column-flag among the step c as the trigger condition of holding definition of data to duplicate at master;
Step g, in distributed data base 2, will set up the view of a former table name of called after based on the snapshot of each branch's database 1 and the distributed data base 2 corresponding table that controls oneself;
Step h, end.
2, the method for distributed data processing on the information management system of a kind of C/S structure as claimed in claim 1 is characterized in that, in step a, described each branch's database is summarized in central database by the data synchronization means with whole business datums.
3, the method for distributed data processing on the information management system of a kind of C/S structure as claimed in claim 1, it is characterized in that, in step f, the naming rule of setting up table at described branch database 1 is, former table name+" _ "+branch's database 1 code.
4, the method for distributed data processing on the information management system of a kind of C/S structure as claimed in claim 2, it is characterized in that, in step f, the naming rule of setting up table at described branch database 2 is, former table name+" _ "+branch's database 2 codes.
5, the method for distributed data processing on the information management system of a kind of C/S structure as claimed in claim 2 is characterized in that, in step f, table name corresponding in each branch's database of snapshot title and other that branch's database 2 is set up is identical.
6, the method for distributed data processing on the information management system of a kind of C/S structure as claimed in claim 2 is characterized in that, in step g, is established to the trigger of corresponding table or snapshot on view, makes this view can be considered a table.
7, the method for distributed data processing on the information management system of a kind of C/S structure as claimed in claim 1, it is characterized in that, in steps d, the naming rule that described central database is set up snapshot is, former table name+" _ "+branch's database code at table place.
CN02136576.8A 2002-08-19 2002-08-19 Distributed data processing method on information management system with C/S structure Expired - Lifetime CN1238806C (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN02136576.8A CN1238806C (en) 2002-08-19 2002-08-19 Distributed data processing method on information management system with C/S structure

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN02136576.8A CN1238806C (en) 2002-08-19 2002-08-19 Distributed data processing method on information management system with C/S structure

Publications (2)

Publication Number Publication Date
CN1477562A true CN1477562A (en) 2004-02-25
CN1238806C CN1238806C (en) 2006-01-25

Family

ID=34146551

Family Applications (1)

Application Number Title Priority Date Filing Date
CN02136576.8A Expired - Lifetime CN1238806C (en) 2002-08-19 2002-08-19 Distributed data processing method on information management system with C/S structure

Country Status (1)

Country Link
CN (1) CN1238806C (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101976243A (en) * 2010-09-30 2011-02-16 中国科学院国家天文台 System for processing satellite data
CN101595490B (en) * 2007-01-26 2011-12-07 日本电气株式会社 Content distribution system, and content distribution method
CN102508927A (en) * 2011-12-01 2012-06-20 中国核工业二三建设有限公司 Device and method of data synchronization technology based on nuclear power construction multi-project management
CN104462192A (en) * 2011-12-01 2015-03-25 中国核工业二三建设有限公司 Data synchronization technology device and method based on nuclear power construction multi-project management
CN104598610A (en) * 2015-01-29 2015-05-06 无锡江南计算技术研究所 Step-by-step database data distribution uploading and synchronizing method
CN106528090A (en) * 2016-10-14 2017-03-22 沈阳化工大学 Method for transplanting C/S structure to B/S structure
CN107835983A (en) * 2015-04-16 2018-03-23 诺宝公司 Backup-and-restore is carried out in distributed data base using consistent database snapshot
US11222008B2 (en) 2015-05-29 2022-01-11 Nuodb, Inc. Disconnected operation within distributed database systems

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101595490B (en) * 2007-01-26 2011-12-07 日本电气株式会社 Content distribution system, and content distribution method
CN101976243A (en) * 2010-09-30 2011-02-16 中国科学院国家天文台 System for processing satellite data
CN102508927A (en) * 2011-12-01 2012-06-20 中国核工业二三建设有限公司 Device and method of data synchronization technology based on nuclear power construction multi-project management
CN102508927B (en) * 2011-12-01 2014-12-03 中国核工业二三建设有限公司 Device and method of data synchronization technology based on nuclear power construction multi-project management
CN104462192A (en) * 2011-12-01 2015-03-25 中国核工业二三建设有限公司 Data synchronization technology device and method based on nuclear power construction multi-project management
CN104462192B (en) * 2011-12-01 2017-09-01 中国核工业二三建设有限公司 Method based on nuclear power construction Amulti-project management data synchronization technology device
CN104598610B (en) * 2015-01-29 2017-12-12 无锡江南计算技术研究所 A kind of distributed data base data distribution uploads synchronous method
CN104598610A (en) * 2015-01-29 2015-05-06 无锡江南计算技术研究所 Step-by-step database data distribution uploading and synchronizing method
CN107835983A (en) * 2015-04-16 2018-03-23 诺宝公司 Backup-and-restore is carried out in distributed data base using consistent database snapshot
CN107835983B (en) * 2015-04-16 2022-02-18 诺宝公司 Backup and restore in distributed databases using consistent database snapshots
US11222008B2 (en) 2015-05-29 2022-01-11 Nuodb, Inc. Disconnected operation within distributed database systems
US12001420B2 (en) 2015-05-29 2024-06-04 Nuodb, Inc. Disconnected operation within distributed database systems
CN106528090A (en) * 2016-10-14 2017-03-22 沈阳化工大学 Method for transplanting C/S structure to B/S structure

Also Published As

Publication number Publication date
CN1238806C (en) 2006-01-25

Similar Documents

Publication Publication Date Title
CN1261877C (en) Multi-node file syn chronizing system and method
US7240059B2 (en) System and method for configuring a parallel-processing database system
US7756898B2 (en) Systems and methods for notifying listeners of events
US7293024B2 (en) Method for sorting and distributing data among a plurality of nodes
US7526513B2 (en) Multi-level replication and conflict resolution
CA2652111C (en) Apparatus and method for forming a homogenous transaction data store from heterogeneous sources
US8676843B2 (en) Failure recovery in a parallel-processing database system
CN103455557B (en) A kind of structural data synchronous method based on daily record
CN1545252A (en) A method for implementing foreground data configuration in network management system
CN1122233C (en) Method and apparatus for supporting dynamic run-time object definition in a relational detabase management system
CN106599043A (en) Middleware used for multilevel database and multilevel database system
US20040098359A1 (en) Method and system for parallel processing of database queries
US20040098374A1 (en) Query scheduling in a parallel-processing database system
US20040098372A1 (en) Global-results processing matrix for processing queries
US7251670B1 (en) Methods and apparatus for replicating a catalog in a content distribution network
JPH09501809A (en) Real-time data access method in automatic call distribution system
US7389313B1 (en) System and method for creating a snapshot copy of a database
CN101031907A (en) Index processing
CN1690961A (en) Client program automatic updating system and method
CN1477562A (en) Distributed data processing method on information management system with C/S structure
CN1292125A (en) Method and apparatus for optimizing query generation by selectively utilizing attributes or key values
US7069270B1 (en) Automated method and mechanism for converting a single instance application to a multiple instance application
Ratner et al. Peer replication with selective control
CN1477546A (en) Method for duplicating data of identical data table between two data bases
CN1482764A (en) Method for synchronisation of master and standby background net management data

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
CX01 Expiry of patent term
CX01 Expiry of patent term

Granted publication date: 20060125