CN1192308C - Method for quickly eliminating different information in database - Google Patents
Method for quickly eliminating different information in database Download PDFInfo
- Publication number
- CN1192308C CN1192308C CNB011295910A CN01129591A CN1192308C CN 1192308 C CN1192308 C CN 1192308C CN B011295910 A CNB011295910 A CN B011295910A CN 01129591 A CN01129591 A CN 01129591A CN 1192308 C CN1192308 C CN 1192308C
- Authority
- CN
- China
- Prior art keywords
- different information
- database
- management
- retry
- foreground
- 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.)
- Expired - Fee Related
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a method for quickly eliminating difference information in a multidatabase application system. In the present invention, when difference information is generated in the process of database operation, the difference information is recorded into a difference information memory table and a difference information file by a manage background in a configuration management module; a retry request is received from a management foreground, a mark in the difference information, database SQL instructions or a storage process are fetched out based on received retry identification code, and the SQL instructions or the storage process is executed again by a corresponding database; when the retry operation is successful, the difference information records in the difference information memory table and difference information physical files are deleted; when the retry operation is partially successful, the difference information in the difference information memory table and the difference information physical files are updated.
Description
Technical field
The present invention relates to eliminate fast the method for different information in database.Particularly a kind of method of eliminating the different information in database that produces in a plurality of Relational databases of parallel processing in the large-scale distribution system is to ensure the consistance to a plurality of database manipulations.
Background technology
Along with development of computer and universal, large database enters into industry-by-industries such as telecommunications, finance rapidly.In the age of current information explosion, the individual data storehouse more and more is difficult to satisfy the needs of performance and quantity of information in a lot of occasions, and therefore, distributed data base comes into operation more.
With Call Management Center (CMC) is example, and the topmost business of Call Management Center is the authentication business that dials up on the telephone.A dial user's dialing request arrives certain access server (NAS), and access server sends to Call Management Center to this request, is decided according to certain certification policy by Call Management Center and accepts or refuse this request.The authentication business that dials up on the telephone of Call Management Center is specifically implemented by protocol process module, monitors the message that access server is sent after the protocol process module operation always, and it is correspondingly processed, and message as a result is sent back to access server.
Protocol process module depends on the storing process that database provides to the processing of the message that access server is sent.Be the storing process that database provides various messages to handle, protocol process module with the mutual process of access server in constantly call the storing process of database, a large amount of dial users' that reciprocal process produces internet information also deposits database in.
Therefore, the authentication business that dials up on the telephone of Call Management Center is by the enforcement (these two modules can be moved on same machine, also can respectively account for a machine run) that cooperatively interacts of protocol process module and database module.Along with the quick growth of portfolio, the function mode of individual call administrative center can not be met consumers' demand.Adopt a plurality of distributed Call Management Centers (DCMC) for improving the wholesale processing power of system port.The IP that distributed call administrative center adopts distributed parallel to handle inserts the common platform system, has realized the mechanism of a plurality of database independent operatings.The corresponding Call Management Center of each database, the calling control of the different access codes of different pieces of information library management.Therefore, same port, the Router Management Center the whole network resource informations such as (RMC) of the essential configuration of each database.In multi-database application system, turnkey console software often needs a plurality of databases are carried out synchronous operation, calls same storing process, is responsible for the configuration querying work of all databases in the system.When the whole network resource being configured (increase, delete, revise), need be to the same storing process of all data base calls in the system.Because a variety of causes (for example network failure) may cause some database to carry out the storing process success, and some database is carried out the storing process failure, different information in database at this moment just occurred.Different information in database can influence the port wholesale processing power of total system, causes unnecessary call drop.Therefore, how different information in database is eliminated on fast and reliable ground is the essential problem that solves of multi-database application system.
In multi-database application system, eliminate the method that different information in database generally adopts rollback.In case the strategy that the rollback method adopts is to produce different information, promptly the database of configuration successful is carried out backward storing process.Consider that each database had all been carried out the storing process that is over when different information produced, therefore can't utilize the rollback mechanism of database self.In addition, rollback method also has following defective:
1. increased the expense of writing contrary direction storing process, and some storing process be need upgrade a plurality of table the time, it is relatively more difficult to write corresponding contrary direction storing process;
2. contrary direction storing process can not guarantee successful execution, may cause eliminating the different information failure.
Summary of the invention
Therefore, at the problems referred to above of multi-database application system, the object of the present invention is to provide a kind of method that can quickly and reliably eliminate different information in database.
The method of elimination different information in database provided by the invention adopts retry mechanism.Retry mechanism is exactly in case produce different information in database, note this different information (sign that comprises storing process order and operation failure database), and the database that regularly triggers or manually control operation failure re-executes the storing process of once carrying out failure.
According to an aspect of the present invention, provide a kind of method of utilizing management configuration module to eliminate different information in database in the multi-database application system, this management configuration module comprises management backstage and management foreground, it is characterized in that this method comprises the following steps:
(a) the management backstage of management configuration module is set, generates different information memory table and different information file,
(b) execution architecture query language (SQL) instruction or storing process in the database of correspondence,
(c) check the Structured Query Language (SQL) instruction of database or the result of storing process, whether the operation of judgment data storehouse is successful,
(d) if in the success of step (c) judgment data storehouse operation part, then the database at operation failure produces a different information that has the retry identification code, and described different information is recorded in described different information memory table and the different information file, indication to management foreground returning part success, if database manipulation is success all, then return whole successful indications, if database manipulation is all failed to the management foreground, then return the indication of whole failures to the management foreground
(e) the retry order that carries the retry identification code of management receiving management foreground, backstage transmission is found the different information corresponding with this retry identification code according to the retry identification code of receiving in the different information file,
(f) from the different information of correspondence, obtain the tag field of this different information record and the storing process that will carry out or Structured Query Language (SQL) instruction, and according to the pointer of these different informations to certain or some this storing process of data base call or Structured Query Language (SQL) instruction and carry out retry operation
(g) whether all the result of inspection retry operation judges retry operation success,
(h) if judge all successes of retry operation, then delete the different information that writes down in different information memory table and the different information file, and return all successfully indication to the management foreground in step (g),
(i) if judge not all successes of retry operation in step (g), judge that then retry operation is that part successfully or is all failed,
(j) if in step (i), judge the success of retry operation part, then upgrade the different information that writes down in different information memory table and the different information file, and to the indication of managing foreground returning part success,
(k), further comprise to the management foreground and return all steps of the indications of failure of retry operation if all fail at step (i) judgement retry operation.
In addition, the step of execution architecture query language instructions or storing process (b) further comprises command request that receives the foreground and the step that described command request is changed into corresponding storing process or Structured Query Language (SQL) instruction before in the database of correspondence.
In addition, further comprise the different information that deletion is corresponding with the database of retry operation success in the step (i) of the different information that in upgrading different information memory table and different information file, writes down.
Different information among the present invention comprises retry identification code field, database is carried out when tag field and this different information of generation query statement or storing process.
Description of drawings
Below in conjunction with accompanying drawing the method that the present invention eliminates different information in database is described in detail, so that understand purpose of the present invention, characteristic and advantage better.
Fig. 1 is the overall block-diagram of distributed call administrative center;
Fig. 2 is the process flow diagram that database produces different information;
Fig. 3 is according to different information record format of the present invention;
Fig. 4 is the process flow diagram according to elimination different information in database of the present invention.
Embodiment
Structure and principle of work with reference to figure 1 explanation distributed call administrative center.Be that example is formed distributed call administrative center with three Call Management Centers among the figure.Distributed call administrative center mainly is made up of protocol process module 2, database 3 and management configuration module 4.In the operation, the dialing request that access server (NAS) 1 receives from dial user's visit data, and this request of access sent to Call Management Center, the message that the storing process that the protocol process module 2 of Call Management Center provides according to database 3 is sent access server 1 is analyzed, and request of access is done validity checking.Decide acceptance or refuse this request of access according to specific authentication mode.Monitor the message that access server 1 is sent after protocol process module 2 operation always, with access server 1 reciprocal process in constantly call the storing process of database, and this message is carried out respective handling, message is as a result sent back to access server 1.
The effect of management configuration module 4 is to provide a connection interface to the system manager, so that configuration data library information (as which access server etc. is arranged in the system) and internet information inquiry.Management configuration module 4 is divided into management backstage and management foreground again, and the management backstage is to handle core, and whole Call Management Center system only disposes portion, and the management foreground provides human-computer interaction interface, can have a plurality of management foreground programs to move at the same time in the system.Communicate by letter with IIOP agreement (agreement between the Internet target request broker) by CORBA (public object request broker architecture) standard with the management backstage in the management foreground.The IIOP agreement can realize the interoperability between the Internet client and the CORBA server, on the other hand, can realize the interoperability between CORBA client computer and the Internet server, even as long as the object that dissimilar computing machine that make to connect or various program language are write as meet the CORPA standard can be at the object intercommunication.The configuration or the query requests of management foreground response user input change into this configuration or query requests to managing the command request on backstage.After command request is received on the management backstage, carry out relevant database store process or querying command, give corresponding management foreground final process result.The management foreground is presented at the result who receives on the interface at last.The operating personnel on management foreground only come into contacts with the existence on imperceptible management backstage with the management foreground.
In the management backstage, corresponding with each database 3 in the system, the database work thread (abbreviation worker thread) of a correspondence is all arranged, a worker thread is appreciated that the connection of paired corresponding database.Three databases are arranged in the system shown in Figure 1, and just there are three worker threads on the management backstage.The all working thread is all by the main thread control in the management backstage, and when not receiving the command request of sending on the management foreground on the management backstage, all working thread on management backstage all is in waiting status;
Production process below in conjunction with Fig. 2 descriptive data base different information.At first,, the management backstage of management configuration module is set, generates different information memory table and different information file at step S200.Different information memory table and different information file are used to write down all differences information of the current existence of multi-database application system.Like this, even (as power down) withdrawed from the management backstage unusually, different information still can recover from the physical file of different information.At step S201, the command request that send on the receiving management foreground, management backstage of the management configuration module in the Call Management Center, this command request comprises the proprietary database identification code (DBID) of each database of expression, this request is analyzed on the management backstage, and this command request is changed into corresponding database SQL (Structured Query Language (SQL)) order or storing process.At step S202, DBID is therefrom extracted on the management backstage.DBID indication is operated that database, for example, three databases is arranged in the system, and its sequence number is 0,1,2 respectively just, and DBID=2 just represents that this subcommand is that 2 database is operated to sequence number only.In addition, set a kind of situation, just represent that when DBID=-1 all databases are operated during this command request is to system.At step S203, the management backstage is provided with the initial environment of the worker thread of this DBID correspondence according to the value of the DBID that extracts.After this, at step S204, or the mutual exclusion lock of all working thread of this DBID correspondence untied on the management backstage.Worker thread after the release just enters duty, carries out the sql command or the storing process of correspondence database.The management backstage waits for that at step S205 all working thread process finishes, and after worker thread executed database SQL order or storing process, mutual exclusion lock was pinned by main thread again, and worker thread is got back to waiting status.At step S206, check the sql command of database or the result of storing process, all whether the operation of judgment data storehouse success.If, then return all successfully indication to the management foreground at step S207 in all successes of step S206 judgment data storehouse operation.If do not have all successes in the operation of step S206 judgment data storehouse, then whether part is successful in the operation of step S208 judgment data storehouse.If in the success of step S208 judgment data storehouse operation part, then in different information memory table and different information file, produce a different information record at the database of operation failure at step S209, database was carried out when record produced this different information query statement or storing process, and in the indication of step S210 to management foreground returning part success.If in the operation of step S208 judgment data storehouse is not the part success, then return the indication of whole failures to the management foreground at step S211.
The structure of different information file is described below with reference to Fig. 3.The different information file is stored with binary format.Every corresponding record of different information for guaranteeing the record fast reading and writing, is made as length-fixed structure with the different information record.In the different information file which of uniquely identified retry identification code (RedoID) field that comprises expression different information record in the different information, retry identification code indication management backstage partly removes to extract relevant different information.After the retry identification code field is mark (Flag) field, and which database is tag field identify need be carried out retry to this different information.The length of tag field can be four bytes for example, totally 32, and each corresponding database.Be set in the present invention: if the value of a certain position of this mark is " 1 ", represent that then this pairing database has produced different information, if the value of a certain position of this mark is " 0 ", represent that then this pairing database does not produce different information, promptly this database runs succeeded.The tag field back is command string (CommandString).Command string is meant query statement or the storing process that database is carried out when producing this different information.When in a single day the management backstage found that the part success appears in certain bar order, it knew it specifically is which or some databases are carried out failure, knows also what order at that time specifically is.Therefore, the management backstage can be added to a different information record in internal memory different information memory table and the different information file exactly.Successfully indicate for then the foreground returning part, carry retry identification code field during this part is successfully indicated.
After the management foreground receives that the part on management backstage is successfully indicated, the different information that output produces owing to the part success, and remind the operator.By the operator database that produces different information is positioned.Whether operator's judgment data storehouse normally operation, connect whether normal, or the like.If the operator finds the netting twine of certain database place main frame and has fallen, again connect, get back to the management foreground then, the instruction of input retry, the operator has just sent one " retry " order to the management foreground, and the management foreground sends to the management backstage to the order of carrying the retry identification code again.
With reference to figure 4 process of eliminating different information in database is described.At step S401, the retry order that carries the retry identification code that management receiving management foreground, backstage sends, the management backstage is found the concrete different information corresponding with this retry identification code according to the retry identification code of receiving at step S402 in the different information file, from the different information of correspondence, obtain the tag field of different information record and storing process or the sql command that will carry out, and which or which database need be carried out the information of this storing process or sql command.Then, at step S403, the management backstage is provided with the initial environment of corresponding work thread according to the indication of tag field.At step S404, give the release of corresponding work thread according to tag field, according to the pointer of this different information to certain or some this storing process of data base call or sql command and carry out retry operation.At step S405, wait for that all working thread process finishes to get back to waiting status.At step S406, check the result of database, judge whether all success of retry operation.If judge all successes of retry operation, delete the different information that writes down in different information memory table and the different information file at step S408, and return all successfully indication to the management foreground at step S408 at step S406.If judge not all successes of retry operation, then judge whether partly success of retry operation at step S407 at step S406.If judge the success of retry operation part at step S407, then upgrade the different information that writes down in different information memory table and the different information file at step S409, delete the different information corresponding with the database of retry operation success, and in the indication of step S410 to management foreground returning part success.If all fail, then return the indication of whole failures to the management foreground at step S411 at step S407 judgement retry operation.
According to the present invention, on the management backstage taking turn thread is set, this taking turn thread can not imported under the situation of retry order on the management foreground, regularly all differences information in the system is done retry one time, prevents the cumulative growth of different information.
In multi-database application system of the present invention, turnkey console provides the interactive operation interface, and when different information of new appearance, the management foreground can be in time notified on the management backstage, be convenient to operator's fault location problem full out, and this different information is carried out retry.
The different information unification that a plurality of databases produce is by unique management back-stage management, and management foreground just input is implemented retry operation to the retry request of certain bar different information by the management backstage, and operating result is returned to the management foreground; A management foreground can obtain the different information that is produced by all databases in the system, is convenient to the operator fast all sidedly to positioning problems, eliminates different information as early as possible.
Specific implementation process of the present invention so far has been described in conjunction with the embodiments.The method of elimination different information in database of the present invention operation in distributed multi-database application system has obtained satisfied result, for distributed multi-database application system provide a kind of general, eliminate the method for different information in database apace.
Claims (4)
1. method of utilizing management configuration module to eliminate different information in database in the multi-database application system, described management configuration module comprises management backstage and management foreground, it is characterized in that this method comprises the following steps:
(a) the management backstage of management configuration module is set, generates different information memory table and different information file,
(b) execution architecture query language (SQL) instruction or storing process in the database of correspondence,
(c) check the Structured Query Language (SQL) instruction of database or the result of storing process, whether the operation of judgment data storehouse is successful,
(d) if in the success of step (c) judgment data storehouse operation part, then the database at operation failure produces a different information that has the retry identification code, and described different information is recorded in described different information memory table and the different information file, indication to management foreground returning part success, if database manipulation is success all, then return whole successful indications, if database manipulation is all failed to the management foreground, then return the indication of whole failures to the management foreground
(e) the retry order that carries the retry identification code of management receiving management foreground, backstage transmission is found the different information corresponding with this retry identification code according to the retry identification code of receiving in the different information file,
(f) from the different information of correspondence, obtain the tag field of this different information record and the storing process that will carry out or Structured Query Language (SQL) instruction, and according to the pointer of these different informations to certain or some this storing process of data base call or Structured Query Language (SQL) instruction and carry out retry operation
(g) whether all the result of inspection retry operation judges retry operation success,
(h) if judge all successes of retry operation, then delete the different information that writes down in different information memory table and the different information file, and return all successfully indication to the management foreground in step (g),
(i) if judge not all successes of retry operation in step (g), judge that then retry operation is that part successfully or is all failed,
(j) if in step (i), judge the success of retry operation part, then upgrade the different information that writes down in different information memory table and the different information file, and to the indication of managing foreground returning part success,
(k), further comprise to the management foreground and return all steps of the indications of failure of retry operation if all fail at step (i) judgement retry operation.
2. the method for elimination different information in database according to claim 1, it is characterized in that, the step of execution architecture query language instructions or storing process (b) further comprises command request that receives the foreground and the step that described command request is changed into corresponding storing process or Structured Query Language (SQL) instruction before in the database of correspondence.
3. the method for elimination different information in database according to claim 1, it is characterized in that, further comprise the different information that deletion is corresponding with the database of retry operation success in the step (i) of the different information that in upgrading different information memory table and different information file, writes down.
4. according to the method for any one described elimination different information in database in the claim 1 to 3, it is characterized in that, the described different information of record comprises retry identification code field, tag field and database is carried out when producing described different information Structured Query Language (SQL) instruction or storing process.
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB011295910A CN1192308C (en) | 2001-06-28 | 2001-06-28 | Method for quickly eliminating different information in database |
PCT/CN2002/000248 WO2003003244A1 (en) | 2001-06-28 | 2002-04-09 | Method of rapidly eliminating different information in databases |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNB011295910A CN1192308C (en) | 2001-06-28 | 2001-06-28 | Method for quickly eliminating different information in database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN1393771A CN1393771A (en) | 2003-01-29 |
CN1192308C true CN1192308C (en) | 2005-03-09 |
Family
ID=4669291
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB011295910A Expired - Fee Related CN1192308C (en) | 2001-06-28 | 2001-06-28 | Method for quickly eliminating different information in database |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN1192308C (en) |
WO (1) | WO2003003244A1 (en) |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1307585C (en) * | 2003-12-31 | 2007-03-28 | 中兴通讯股份有限公司 | Data processing method for realizing data base multitable inguiry |
CN100357943C (en) * | 2004-03-17 | 2007-12-26 | 联想(北京)有限公司 | A method for inspecting garbage files in cluster file system |
CN102096664B (en) * | 2009-12-09 | 2015-06-17 | 新奥特(北京)视频技术有限公司 | Report generating method |
CN102289340A (en) * | 2010-06-21 | 2011-12-21 | 中国电信股份有限公司 | Data auditing platform and method |
CN106407398A (en) * | 2016-09-21 | 2017-02-15 | 福建中金在线信息科技有限公司 | A data storage method and system |
CN111324668B (en) * | 2020-02-18 | 2023-11-21 | 中国联合网络通信集团有限公司 | Database data synchronous processing method, device and storage medium |
CN114037255A (en) * | 2021-11-05 | 2022-02-11 | 江苏徐工信息技术股份有限公司 | Crane risk management method based on webservice |
Family Cites Families (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP3526474B2 (en) * | 1994-07-06 | 2004-05-17 | 富士通株式会社 | Distribution information management system in network |
JPH0844760A (en) * | 1994-07-28 | 1996-02-16 | Canon Inc | System and method for data base retrieval |
JP2000132435A (en) * | 1998-10-29 | 2000-05-12 | Hitachi Ltd | Data consistency processor between different kind of data base management systems |
-
2001
- 2001-06-28 CN CNB011295910A patent/CN1192308C/en not_active Expired - Fee Related
-
2002
- 2002-04-09 WO PCT/CN2002/000248 patent/WO2003003244A1/en not_active Application Discontinuation
Also Published As
Publication number | Publication date |
---|---|
WO2003003244A1 (en) | 2003-01-09 |
CN1393771A (en) | 2003-01-29 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
RU2421803C2 (en) | Notices of data modification | |
US7680793B2 (en) | Commit-time ordered message queue supporting arbitrary read and dequeue patterns from multiple subscribers | |
US6738775B2 (en) | Database communication system and method for communicating with a database | |
KR100243717B1 (en) | Method and apparatus for enabling a persistent metastate for objects in an object-oriented environment | |
US6078955A (en) | Method for controlling a computer system including a plurality of computers and a network processed as a user resource | |
CN111324610A (en) | Data synchronization method and device | |
CN1848849A (en) | Method and device for replicating modifications of a directory | |
US7542963B2 (en) | Method and system for journaling and accessing sensor and configuration data | |
EP1577776B1 (en) | Method and apparatus for data synchronization in a distributed data base system | |
US8830831B1 (en) | Architecture for balancing workload | |
CN1192308C (en) | Method for quickly eliminating different information in database | |
US8566292B2 (en) | Method and system for journaling and accessing sensor and configuration data | |
CN1126054C (en) | Protocol for synchronizing parallel processors in mobile communiacation system | |
US7415458B2 (en) | Computer systems and methods for operating a computer system | |
CN110717130B (en) | Dotting method, dotting device, dotting terminal and storage medium | |
CN1152338C (en) | Parallel distributed-data base processing method and device | |
AU2002351296B2 (en) | System and method for processing a request using multiple database units | |
CN116028505A (en) | Method for realizing high available sequence in distributed database | |
CN111061719A (en) | Data collection method, device, equipment and storage medium | |
US6804339B1 (en) | Real-time object-oriented database for TAPI service providers | |
CN113515532B (en) | Change processing method, device, equipment and storage medium based on data exchange | |
CN112860780A (en) | Data export method and device and terminal equipment | |
CN117667885A (en) | Data migration method, device, terminal equipment and storage medium | |
CN113157645A (en) | Cluster data migration method, device, equipment and storage medium | |
KR950010485B1 (en) | Db skima management method |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
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 | ||
C17 | Cessation of patent right | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20050309 Termination date: 20110628 |