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 PDFInfo
- 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
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
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.
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)
| 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 |
-
2002
- 2002-08-19 CN CN02136576.8A patent/CN1238806C/en not_active Expired - Lifetime
Cited By (13)
| 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 |