CN1983263A - Method for correcting database - Google Patents
Method for correcting database Download PDFInfo
- Publication number
- CN1983263A CN1983263A CN 200610080813 CN200610080813A CN1983263A CN 1983263 A CN1983263 A CN 1983263A CN 200610080813 CN200610080813 CN 200610080813 CN 200610080813 A CN200610080813 A CN 200610080813A CN 1983263 A CN1983263 A CN 1983263A
- Authority
- CN
- China
- Prior art keywords
- data
- client
- server
- modification
- message
- 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
A method for revising databank includes informing those client ends to update data image after data-revision command is received by server carried with databank and enquire is carried out on client end applying data to be revised as well as permission is obtained from client end applying data to be revised, revising its own stored data by server after all those client ends are finalized with their revisions.
Description
Technical field
The present invention relates to a kind of method of revising database, the method for the modification database that particularly a kind of server of the time carrying database of realizing data modification by the mode that adopts real-time inquiry formula and application system are mutual.
Background technology
In the existing application software systems, revise database, usually be the static parameter that not only needs to revise application software system, and need to revise the operational factor of an application software system.Especially for the large-scale database that the application software system of high reliability request is arranged, database as Large Scale Application Software System such as carrier class, bank's levels, have a large amount of operational factors, these systems must be month after month in running order throughout the year, and these parameters often change in the course of the work, and some data, may be in application software system each use submodule and all need to share these data, in must the real-time update associated application submodule of the variation of these data.
The prior art of revising database is separately the data in the server of carrying database to be operated by the control platform to finish modification, using submodule in this modification process and the application software system does not carry out alternately, the defective that exists is, the server and the application software system of carrying database do not carry out alternately, cause to guarantee the legitimacy of data, the completeness of reliability and data and real-time, thus can't satisfy carrier class, the database of Large Scale Application Software System such as bank's level must ensure the legitimacy of these data in the application corresponding submodule in the process of revising data, the requirement of reliability.
Summary of the invention
The objective of the invention is at above-mentioned the deficiencies in the prior art, a kind of method of revising database is provided, server and application system is mutual when realizing data modification, to guarantee legitimacy, reliability, completeness and the real-time of database update.
For achieving the above object, the present invention proposes a kind of method of revising database, this method may further comprise the steps:
After step 1, server receive the data modification order,, find the client of the data in the described data modification order of application according to the corresponding relation of the client of data and the application data of storage;
Step 2, described server send data operation commands to described client, order described client to revise data in the data mapping of storage;
After step 3, described client validation data operation commands are legal, revise data in the existing data mapping, create the data mapping copy according to described data modification order, and to the legal message of described server return command;
Step 4, described server send the more message of new data to described client after receiving the legal message of described order that all described clients return;
After step 5, described client receive the message of described more new data, replace existing data mapping, send the message of data modification success to described server with described data mapping copy;
After step 6, described server receive the message of the data modification success that all described clients send, revise data in the database according to described data modification order;
Step 7, end.
So have following function and advantage because the present invention has realized the operator of data and user's interaction of data:
1, guarantees legitimacy, the reliability of data: owing to modification process in data, revising the use of data all carries out mutual and affirmation, during this period, the use of data can be verified the data legitimacy of these modifications in conjunction with application scenarios separately, guarantee legitimacy, the reliability of data;
2, guarantee the completeness of data: data once are delivered to each application system by the relationship description table in batches with the data of its modification, application system can be checked the relation between these modification data, revise the relation between data and the raw data, also can guarantee revise between the data, revise between data and the raw data, revise the completeness between data and the operation scene in conjunction with the operation scene;
3, guarantee the real-time of data: data are in case revise, then the server by the carrying database initiatively is delivered to each application system according to using the relationship description table with data in real time, so each application system can be used amended data synchronously, guaranteed that data, services and service data are in full accord.
For in real time execution systems such as carrier class, bank's level by data care person's mandate, on-the-fly modify the operational factor of system, and the corresponding operational factor of real-time update related application data client, thereby the seamless update mechanism of data be provided.
Below by drawings and Examples, technical scheme of the present invention is described in further detail.
Description of drawings
Fig. 1 is the structural representation of applied database of the present invention and application system;
Fig. 2 revises the process flow diagram of the preferred embodiment of data base method for the present invention;
Fig. 3 is the process flow diagram based on the preferred embodiment of Fig. 2.
Embodiment
Revise database among the present invention, also comprise the operation of modification, increase and deleted data.
Fig. 1 is the structural representation of the applied database of the present invention and application system, and the server A 1 that is used to carry database is connected with customer end A 2 and other customer end A 3 of application data.
Suppose that customer end A 3 will revise the data in the server, specifically as shown in Figure 2, carry out following steps:
After step 101, server receive the data modification order that client sends over,, find the client of the data in the described data modification order of application according to the corresponding relation of data with the client of application data of storage; Among the present invention, database can support each applications client to carry out data query, the server that is used to store data simultaneously can provide real time modifying and real-time informing for applications client, and new data more, and can in revising data base procedure, obtain data consumer's modification approval, guaranteed the legitimacy and the reliability of data modification.
Among the present invention, the server of storage data provides the remote interface that can revise database for Terminal Server Client, and Terminal Server Client can be submitted the retouching operation order of modification, increase or deleted data by this interface to server.
Database provides a relationship description table, and this relationship description table has been described the use relation that each data and application system are client, is used for storing the corresponding relation of the client of data and application data.Behind the startup of server, the loading data file, and create database table, simultaneously the data relationship description document is read in, and the opening relationships description list.
Database can be revised system operational parameters, can find the client of these data of care according to the relationship description table and by the operational factor of these modifications, thereby in time these data is delivered to the application data client that each is concerned about these data respectively.
After step 103, described client validation data operation commands are legal, revise data in the existing data mapping, create the data mapping copy according to described data modification order, and to the legal message of described server return command;
After step 104, described server receive the legal message of order that the client of all application data B1 and data B2 returns, send the more message of new data to these clients, the blocked operation of notifying each application data client to carry out data, the copy of will videoing changes into the data mapping original;
After step 105, described client receive the message of described more new data, replace existing data mapping, send the message of data modification success to described server with described data mapping copy;
After step 106, described server receive the message of the data modification success that all described clients send, revise data in the database according to described data modification order;
Because the order of revising data not necessarily meets the requirement of the client of using these data, therefore, in the foregoing description, as shown in Figure 3, also further comprises step between step 102 and the step 103:
After the applications client of step 201, data B1 and data B2 receives described data operation commands, to judge earlier whether described data operation commands is legal, if, execution in step 103; Otherwise, execution in step 202;
In the foregoing description, know in order to make the client of sending the data modification order whether this data modification order is carried out, in the step 202, after the illegal message of return command, at first, described client-server is revised failure to the client return data that sends described data modification order, and execution in step 107 then.
Further comprise between described step 106 and the step 107: described server is revised successful message to the client return data that sends described data modification order.
If the applications client of data B1 and data B2 all judgment data modification order is legal, be that the decision data modification is legal, then authorization server carries out data manipulation, have only when server and receive these two applications client all after the legal message of return command, just two applications client are all authorized when passing through, server just can carry out data modification, then server sends update notification to these two applications client, applications client is replaced existing data mapping with the data mapping copy of creating, become the data mapping original of applications client, at this moment, the corresponding data in applications client and the server all upgrades simultaneously; As long as the illegal message of applications client return command is arranged, then the server refusal is carried out and is revised order, and this moment, the uniform data of server and data applications client remained unchanged.After should checking these modification data with client, determine whether authorization server is revised these data; After the equal authorization data server of all clients carried out data modification, server just can carry out the Data Update operation, upgrade the data of related application data client simultaneously, otherwise data server directly returned failure; The present invention also provides a kind of inquiry formula update mechanism, when the server of carrying database receives the request of revising data, at first inquire the data applications client, strive to such an extent that carry out Data Update again after agreeing, guaranteed the legitimacy of data increases, modification and deletion.Legitimacy, reliability, completeness and the real-time of whole application system data modification like this, have just further been guaranteed.
It should be noted last that, above embodiment is only unrestricted in order to technical scheme of the present invention to be described, although the present invention is had been described in detail with reference to preferred embodiment, those of ordinary skill in the art is to be understood that, can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and scope of technical solution of the present invention.
Claims (5)
1, a kind of method of revising database is characterized in that, carries out following steps:
After the server of step 1, carrying database receives the data modification order,, find the client of the data in the described data modification order of application according to the corresponding relation of the client of data and the application data of storage;
Step 2, described server send data operation commands to described client, order described client to revise data in the data mapping of storage;
After step 3, described client validation data operation commands are legal, revise data in the existing data mapping, create the data mapping copy according to described data modification order, and to the legal message of described server return command;
Step 4, described server send the more message of new data to described client after receiving the legal message of described order that all described clients return;
After step 5, described client receive the message of described more new data, replace existing data mapping, send the message of data modification success to described server with described data mapping copy;
After step 6, described server receive the message of the data modification success that all described clients send, revise data in the database according to described data modification order;
Step 7, end.
2, the method for modification database according to claim 1 is characterized in that, in the described step 1, described server receives described data modification order by the interface that the remotely modifying database is provided.
3, the method for modification database according to claim 1 and 2 is characterized in that, further comprises between described step 2 and the described step 3:
After step 11, described client receive described data operation commands, judge whether described data operation commands is legal, if, execution in step 3; Otherwise, execution in step 12;
Step 12, described client are to the illegal message of described server return command, and execution in step 7 then.
4, the method for modification database according to claim 3, it is characterized in that, in the described step 12, after the illegal message of described client return command, at first, described server is revised failure to the client return data that sends described data modification order, and execution in step 7 then.
5, the method for modification database according to claim 1 and 2 is characterized in that, further comprises between described step 6 and the step 7: described server is revised successful message to the client return data that sends described data modification order.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006100808131A CN100410947C (en) | 2006-05-16 | 2006-05-16 | Method for correcting database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNB2006100808131A CN100410947C (en) | 2006-05-16 | 2006-05-16 | Method for correcting database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN1983263A true CN1983263A (en) | 2007-06-20 |
| CN100410947C CN100410947C (en) | 2008-08-13 |
Family
ID=38165802
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNB2006100808131A Expired - Fee Related CN100410947C (en) | 2006-05-16 | 2006-05-16 | Method for correcting database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100410947C (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102013029A (en) * | 2010-12-25 | 2011-04-13 | 河南科技大学 | Safe card signing method for intelligent card database application system |
| CN104468773A (en) * | 2014-12-04 | 2015-03-25 | 北京国双科技有限公司 | Data processing method and server |
| CN105071975A (en) * | 2015-09-07 | 2015-11-18 | 北京瑞星信息技术有限公司 | Data transmission and distribution method and system |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB2308778B (en) * | 1995-12-28 | 1998-06-10 | Nokia Telecommunications Oy | Telecommunications network management system |
| US6898591B1 (en) * | 1997-11-05 | 2005-05-24 | Billy Gayle Moon | Method and apparatus for server responding to query to obtain information from second database wherein the server parses information to eliminate irrelevant information in updating databases |
| US6674450B1 (en) * | 2000-04-14 | 2004-01-06 | Trilogy Development Group, Inc. | Interactive data-bound control |
-
2006
- 2006-05-16 CN CNB2006100808131A patent/CN100410947C/en not_active Expired - Fee Related
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102013029A (en) * | 2010-12-25 | 2011-04-13 | 河南科技大学 | Safe card signing method for intelligent card database application system |
| CN102013029B (en) * | 2010-12-25 | 2013-01-23 | 河南科技大学 | Safe card signing method for intelligent card database application system |
| CN104468773A (en) * | 2014-12-04 | 2015-03-25 | 北京国双科技有限公司 | Data processing method and server |
| CN105071975A (en) * | 2015-09-07 | 2015-11-18 | 北京瑞星信息技术有限公司 | Data transmission and distribution method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100410947C (en) | 2008-08-13 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10042635B2 (en) | Method for wireless remote updating vehicle software | |
| US9836300B2 (en) | Method for updating vehicle ECUs using differential update packages | |
| US9841965B2 (en) | Centralized system for software updating vehicle components | |
| US6467088B1 (en) | Reconfiguration manager for controlling upgrades of electronic devices | |
| CN100407656C (en) | Method and system for managing terminal equipment | |
| JP3887564B2 (en) | Integrated database combination system | |
| CN110544097A (en) | Intelligent contract version control, calling and upgrading method, equipment and storage medium | |
| US20040068721A1 (en) | Network for updating firmware and / or software in wireless communication devices | |
| CN101730099B (en) | Terminal management method based on authority control and device | |
| US20060271553A1 (en) | Document management system and method | |
| CN102541941A (en) | Version management control method for multiple parties to co-operate file | |
| CN111596932B (en) | Mirror image file generation method and device and computer readable storage medium | |
| US20130346432A1 (en) | Shared data with relationship information | |
| CN100410947C (en) | Method for correcting database | |
| US20200327486A1 (en) | Asset Tracking System And Method | |
| CN102377590B (en) | Network device and data updating method thereof | |
| JPH07129407A (en) | Version managing method | |
| CN110908694A (en) | Hot updating system and method for electronic bidding client application | |
| US20090210453A1 (en) | Service for verifying consistency of replicated data | |
| US7739688B1 (en) | Techniques for managing distribution of well-defined objects in a client/server system | |
| CN111367840B (en) | Method and device for realizing plug and play | |
| CN114489711A (en) | Terminal upgrading method and device and storage medium | |
| CN111541918A (en) | System and method for centralized management of video transcoding state | |
| CN101364224A (en) | Information management system and method | |
| CN104753902A (en) | Service system verification method and device |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20080813 |