CN101739435A - Database access method, control device and control system - Google Patents
Database access method, control device and control system Download PDFInfo
- Publication number
- CN101739435A CN101739435A CN200910148566A CN200910148566A CN101739435A CN 101739435 A CN101739435 A CN 101739435A CN 200910148566 A CN200910148566 A CN 200910148566A CN 200910148566 A CN200910148566 A CN 200910148566A CN 101739435 A CN101739435 A CN 101739435A
- Authority
- CN
- China
- Prior art keywords
- information
- database
- synonym
- service database
- service
- 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
Abstract
The invention discloses a database access method, a control device and a control system. The method comprises the following steps of: receiving access request comprising an accessed service database and accessed service data information thereof; acquiring private synonym information of the accessed service data information according to the accessed service data information in the access request and the preset private synonym information relation corresponding to the service data information of each service database; and according to the private synonym information, accessing the to-be-accessed service database and returning an access result. The invention provides the stable and reliable database access method, which can overcome the defects of low system stability and reliability, the data call with errors and the like caused by the frequent switching among service databases in the prior art.
Description
Technical field
The present invention relates to a kind of data bank access method, control device and system, be specifically related to a kind of multi-databases access method, control device and system that is applied in the multi-service management platform system.
Background technology
In order to satisfy complicated service demand day by day, developed the multi-service management platform system that comprises a large amount of different business systems at present.Each operation system has independently Log Source, indicator-specific statistics method, report form showing and accounting management rule etc., and moves on different Service Databases, so that standardization, modular data query and storage to be provided.Please refer to Fig. 1, in the prior art, framework is in the foreground support system on the database (hereinafter to be referred as Service Database) of each operation system correspondence or background application system during at each Service Database of visit, for guaranteeing that management platform system does as a whole lasting operation, need between each Service Database, switch back and forth.
In the prior art foreground support system or background application system visit during each Service Database between each Service Database back and forth switching can have following technical matters:
1. be difficult to guarantee the stability and the reliability of management platform system in the database access process.
2. exist and visit the possibility that each Service Database is made mistakes, thereby cause the visit data mistake of foreground support system.
3. under many simultaneous situations of operation system, there is the defective that interferes with each other in each Service Database in access process.
Summary of the invention
First purpose of the present invention is the poor stability that exists at existing foreground support system or background application system access mode, the defective that the visit data accuracy is not high and each Service Database interferes with each other, propose a kind of data bank access method, realize stable, reliable database access.
Second purpose of the present invention is at the poor stability of existing access mode existence, the defective that the visit data accuracy is low, proposes a kind of database access control device, realizes stable, reliable database access control.
The 3rd purpose of the present invention is at the poor stability of existing access mode existence, the defective that the visit data accuracy is not high and each Service Database interferes with each other, and proposes a kind of data base access system, realizes stable, reliable visit between the multiple database.
For realizing above-mentioned first purpose, the invention provides a kind of data bank access method, this method comprises: receive the request of access comprise accessed Service Database and accessed service data information thereof; According to the accessed service data information in the request of access, and the privately owned synonym information relationship of the service data information correspondence of each default Service Database, obtain the privately owned synonym information of accessed service data information; According to the accessed Service Database of privately owned synonym message reference of accessed service data information, and return the visit result of accessed service data information.
For realizing above-mentioned second purpose, the invention provides a kind of database access control device, this device comprises:
Interface module is used to receive the request of access that comprises accessed Service Database and accessed service data information thereof, and the backward reference result;
Information storage module is used to store the privately owned synonym information relationship of the service data information correspondence of each Service Database;
The access process module, be used for according to accessed service data information, and the privately owned synonym information relationship of the service data information correspondence of each Service Database, obtain the privately owned synonym information of accessed service data information, and according to the accessed Service Database of privately owned synonym message reference, to interface module backward reference result.
For realizing above-mentioned the 3rd purpose, the present invention also provides a kind of data base access system, and this system comprises:
At least one business datum system, wherein, each business datum system comprises the Service Database that is used to deposit service data information;
Application interface unit comprises at least one application interface, is used to receive the request of access that comprises accessed Service Database and accessed service data information thereof;
The database access control device, be connected between application interface unit and each the business datum system, be used for accessed service data information according to request of access, and the privately owned synonym information relationship of the service data information correspondence of each default Service Database, obtain the privately owned synonym information of accessed service data information, and according to the accessed Service Database of privately owned synonym message reference of accessed service data information, and the visit result who returns accessed service data information is to application interface unit.
In each data bank access method of the present invention, control device and the system embodiment, set in advance the privately owned synonym corresponding relation of the service data information correspondence of each Service Database, when receiving request of access, can directly find the privately owned synonym of accessed service data information, thereby utilize privately owned synonym that Service Database is conducted interviews, the low defective of system stability of having avoided frequent switching the between each Service Database and having caused has improved the system stability in the access process of multi-service data storehouse.Simultaneously, the present invention utilizes the privately owned synonym of accessed database to visit uniquely and is stored in the interior service data information of accessed database, reduce the error rate of data call in the access process of multi-service data storehouse, improved the antijamming capability of reliability and each Service Database.
Description of drawings
Accompanying drawing is used to provide further understanding of the present invention, and constitutes the part of instructions, is used to explain the present invention in the lump with embodiments of the invention, is not construed as limiting the invention.In the accompanying drawings:
Fig. 1 is the synoptic diagram of data base access system in the prior art;
Fig. 2 is the parsing synoptic diagram of the embodiment one of data bank access method of the present invention;
Fig. 3 resolves synoptic diagram for the embodiment that communicates by letter based on synonym between each Service Database in the data bank access method of the present invention and the central database;
Fig. 4 is the process of analysis synoptic diagram of the embodiment two of data bank access method of the present invention;
Fig. 5 is the example structure synoptic diagram of data base access system of the present invention;
Fig. 6 is the example structure synoptic diagram of encapsulated data units among Fig. 5;
Fig. 7 is the example structure synoptic diagram of database access control device of the present invention.
Embodiment
Below in conjunction with accompanying drawing the preferred embodiments of the present invention are described, should be appreciated that preferred embodiment described herein only is used for description and interpretation the present invention, and be not used in qualification the present invention.
Method embodiment
Fig. 2 is the parsing synoptic diagram according to the embodiment one of data bank access method of the present invention.Between application interface and each Service Database, set up a central database in the present embodiment, and in central database, store the privately owned synonym clump of each Service Database.The privately owned synonym that present embodiment utilizes accessed Service Database conducts interviews to this Service Database and describes for example.As shown in Figure 2, the access process of present embodiment comprises:
Step 1: foreground support system or background application system (following foreground, backstage and other application platform systems are referred to as application platform) send to central database by foreground or background application interface with request of access respectively, wherein, this central database is between each Service Database and above-mentioned application interface, and this request of access comprises accessed Service Database and accessed service data information thereof;
Step 2: central database is according to accessed service data information, and the privately owned synonym information relationship of the service data information correspondence of each default Service Database, obtains the privately owned synonym information of accessed service data information;
Table 1 is that the privately owned synonym information relationship table of each service data information correspondence is given an example, understand privately owned synon visit in conjunction with Fig. 5 and table 1: if this request of access need be visited the daily sheet service data information R_DAILY that is stored in Service Database Z10, then central database obtains the privately owned synonym SYNONYM_Z1_R_D_AILY of the daily sheet service data information R_DAILY of Service Database Z10 according to table 1;
The privately owned synonym information relationship table of each service data information correspondence of table 1
| Central database | Privately owned synonym | The Service Database that points to | The service data information of pointing to |
| ??Z00 | ?SYNONYM_Z10_R_DAILY | ??Z10 | ??R_DAILY |
| ?SYNONYM_Z10_R_MONTHLY | ??Z10 | ??R_MONTHLY | |
| ?SYNONYM_Z20_R_DAILY | ??Z20 | ??R_DAILY | |
| ?SYNONYM_Z20_R_MONTHLY | ??Z20 | ??R_MONTHLY | |
| ?SYNONYM_Z30_R_DAILY | ??Z30 | ??R_DAILY | |
| ?SYNONYM_Z30_R_MONTHLY | ??Z30 | ??R_MONTHLY | |
| ?SYNONYM_Z40_R_DAILY | ??Z40 | ??R_DAILY | |
| ?SYNONYM_Z40_R_MONTHLY | ??Z40 | ??R_MONTHLY | |
| ?SYNONYM_Z50_R_DAILY | ??Z50 | ??R_DAILY | |
| ?SYNONYM_Z5_R_MONTHLY | ??Z50 | ??R_MONTHLY | |
| ?… | ??… | ??… |
Step 3: central database utilizes the privately owned synonym of step 2 identification and accessed Service Database to carry out point-to-point two-way communication, visits this accessed Service Database, and returns the visit result of accessed service data information;
Step 4: in access process, when needs call be stored in the central database be used for public assistance information that assistance information handles the time, according to the public assistance information of calling, and the publicly-owned synonym information relationship of the public assistance information correspondence of each default Service Database, the publicly-owned synonym information that obtains invoked public assistance information is to call invoked public assistance information, as, configuration data that each Service Database is general and code instrumentation etc.The publicly-owned synonym information relationship table of the public assistance information correspondence of each Service Database can be referring to table 2.
The publicly-owned synonym information relationship table of each public assistance information correspondence of table 2
| Service Database | Publicly-owned synonym | Central database | The public assistance information of pointing to |
| ??Z10 | ??SYNONYM_Z00_R_PROCESS_LOG | ??Z00 | ??R_PROCESS_LOG |
| ??Z20 | ??SYNONYM_Z00_R_PROCESS_LOG | ??Z00 | ??R_PROCESS_LOG |
| ??Z30 | ??SYNONYM_Z00_R_PROCESS_LOG | ??Z00 | ??R_PROCESS_LOG |
| ??Z40 | ??SYNONYM_Z00_R_PROCESS_LOG | ??Z00 | ??R_PROCESS_LOG |
| ??Z50 | ??SYNONYM_Z00_R_PROCESS_LOG | ??Z00 | ??R_PROCESS_LOG |
| ??… | ??… | ??… | ??… |
Wherein, central database is the newly-increased central database between each application interface and each Service Database of present embodiment, the publicly-owned synonym information that this central database can be stored the privately owned synonym information of each Service Database correspondence of setting up according to the title of each Service Database in advance, set up according to self title, and the common information repository of storage common information.
Privately owned synonym is used to indicate the private service data information that is stored in its corresponding service database; Publicly-owned synonym information is used to indicate the common information that is stored in the central database; Private service data information and public services data message all belong to service data information.
Common information comprises public assistance information and public services data message, and wherein, the public services data message comprises coding, title, description, on-line time, whether expired, the encode definition rule and the loading and unloading definition etc. of each Service Database; Public assistance information is used for assisting the information processing of access process, as Service Database in the step 4 by publicly-owned synonym to the public assistance information of central data library call.Form storages such as all common informations can routine package, tables of data, function bag and sequence.Certainly central database also can not stored the public services data message, only stores public assistance information, as handling daily record etc.
In the present embodiment, by between each Service Database and application interface, setting up central database, and utilize privately owned synonym that each Service Database is carried out point-to-point visit by central database, realize that application platform directly carries out information interaction with central database by application interface and promptly can reach the purpose of visiting each Service Database, avoid in the prior art application platform frequent and switch the low defective of system stability that causes between each Service Database, improved the stability of application platform in the access process of multi-service data storehouse.Simultaneously, utilize the privately owned synonym of accessed Service Database to visit the private service data message that is stored in the accessed Service Database uniquely, reduced the error rate of data call in the access process of multi-service data storehouse, improved reliability.
In addition, each Service Database separate, stored can make each service logic become clear, the storage of central database common information has reduced the degree of coupling between each business, makes each Service Database can select different optimisation strategy, is convenient to the maintenance of data base access system.
Fig. 3 resolves synoptic diagram for the embodiment that communicates by letter based on synonym between each Service Database in the data bank access method of the present invention and the central database.As shown in Figure 3,
Step 301: central database sends a request signal to accessed Service Database;
Wherein, this request signal comprises the privately owned synonym of an accessed Service Database; The privately owned synonym title of each Service Database is relevant with its title, and for example, all with its title Z10 beginning, privately owned synonym Z10_SN_TB_R_DAILY_D represents the daily sheet service data information of Service Database Z10 to the privately owned synonym of Service Database Z10;
Step 302: whether the privately owned synonym that accessed Service Database is differentiated in this request signal is the privately owned synonym of self; If then central database is visited this accessed Service Database;
Step 303: also can utilize publicly-owned synonym two-way communication between each Service Database and the central database to realize the mutual of public services data message; As table 3, each Service Database can utilize publicly-owned synonym SYNONYM_Z00_TB_CITYS to visit the general city list of each Service Database.It will be understood by those skilled in the art that in the specific implementation process, central database preferably can be stored public assistance information, as table 2.But can be stored in the central database for the public services data message, store, also can disperse to be stored in each Service Database, and not be stored in the central database as mode with table 3.
Public assistance information can be some routine packages that call etc., and the public services data information memory is the general service data information of each Service Database, when application interface is visited these public services data messages, can directly get from central database read.
The publicly-owned synonym information relationship table of each public services data message correspondence of table 3
| Service Database | Publicly-owned synonym | Central database | The public services data message that points to |
| ??Z10 | ??SYNONYM_Z00_TB_CITYS | ??Z00 | ??TB_CITYS |
| ??Z20 | ??SYNONYM_Z00_TB_CITYS | ??Z00 | ??TB_CITYS |
| ??Z30 | ??SYNONYM_Z00_TB_CITYS | ??Z00 | ??TB_CITYS |
| ??Z40 | ??SYNONYM_Z00_TB_CITYS | ??Z00 | ??TB_CITYS |
| ??Z50 | ??SYNONYM_Z00_TB_CITYS | ??Z00 | ??TB_CITYS |
| ??… | ??… | ??… | ??… |
The synonym of each service data information and common information are except can storing in advance when central database makes up, also by realizing encapsulation in the loading procedure of Service Database, as: when loading a Service Database, utilize storing process that the privately owned synonym information and the public services data information memory of Service Database correspondence to be loaded are got final product in central database.
Because each Service Database separate, stored, and its privately owned synonym clump is stored in the central database, then central database can unload management to each Service Database by the unload script of its storage, promptly by the operation unload script, deletion waits to unload the synonym clump of Service Database in central database can realize the logic unloading of central database to Service Database.In like manner, when needs load a Service Database, only need call the privately owned synonym clump that loading scripts that central database prestores utilizes storing process to write Service Database to be loaded and can realize that central database loads the logic of Service Database.This shows that logic links to each other and makes that the number of loaded with traffic database is unrestricted between central database and the Service Database.
In the present embodiment, privately owned synonym and the corresponding service database point-to-point communication of central database by utilizing each Service Database, can realize managing independently and visiting to each Service Database, as independent loads or unloading, and carry out the mutual of common information by publicly-owned synonym and each Service Database, each Service Database energy coordinative operation is realized sharing of common information, has reduced the redundance of data storage in each Service Database.
Fig. 4 is the process of analysis synoptic diagram of the embodiment two of data bank access method of the present invention.Present embodiment utilizes publicly-owned synonym to conduct interviews with the foreground application interface by central database, and the platform application interface utilizes privately owned synonym to conduct interviews by central database to describe for example.
As shown in Figure 4, the foreground support system comprises by the database access process that the foreground application interface accessing is stored in the service data information in the common information repository:
Step S401: the request of access that the foreground application interface sends the foreground support system is sent in the central database, and this request of access comprises accessed Service Database and accessed service data information thereof;
Step S402: central database is according to the accessed service data information of this request of access identification, and promptly the role to request of access discerns; And differentiate whether this request of access is that the application system platform that is authorized to sends, and be the application system platform that is authorized to when sending in this request of access, the access rights of this request of access differentiated, i.e. read right, write permission or access limit etc.;
Step S403: central database is according to service data information and privately owned synon corresponding relation (as table 1) in each Service Database of storage in advance, perhaps the public services data message of each Service Database and publicly-owned synon corresponding relation (as table 3), when accessed when being the public services data message, find corresponding publicly-owned synonym, execution in step S404 (utilizing privately owned synon access process to please refer to following description) to the background application system access process;
Step S404: central database is according to this publicly-owned synonym visit public services data message (as table 3);
Step S405: central database will be visited the result and will be sent to the foreground support system by the foreground application interface.
Those skilled in the art should understand, present embodiment is a kind of implementation, the public services data message of each Service Database directly is kept at this central database, therefore, when foreground or background application interface need be visited the public services data message of each Service Database, can directly return the public services data message by the visit central database, and not need to visit respectively again each Service Database, simplify browsing process, saved the access time.
But, simultaneously, also the public services data message of each Service Database directly can being kept in each Service Database, and not being stored in the central database, central database need not stored the publicly-owned synonym of public services data message correspondence.Like this, when foreground or background application interface need be visited the public services data message of each Service Database, can visit each Service Database by central database.
As shown in Figure 4, background application system sends request of access by the background application interface, and central database utilizes the process of privately owned synonym access service database to comprise:
Step S411: the request of access that the background application interface sends background application system is sent to central database, and this request of access comprises accessed Service Database and accessed service data information thereof;
Step S402 visits the step S402 of the database access process that is stored in the service data information in the common information repository with above-mentioned foreground support system;
Step S403, central database are according to service data information and privately owned synon corresponding relation (as table 1) in each database of storage in advance, and identification needs the privately owned synonym of the service data information correspondence of visit, execution in step S412;
Step S412: central database starts inner each module (specifically referring to inner each module among the structure embodiment among the embodiment of back plane system and device), send one to accessed Service Database and comprise this privately owned synon request signal, wherein, Fig. 6 is seen in the detailed explanation of each functional module, as, start alarm module 67 with the abnormal information in the monitoring business database access process;
Step S413: the privately owned synonym that accessed Service Database is differentiated in this request signal is the privately owned synonym of self;
Step S414: this accessed Service Database judges whether to call public assistance information, when not needing to call public assistance information, directly carries out inter access, and obtains visit result, execution in step 416;
Step S415: when needs call public assistance information, this accessed Service Database is according to the public assistance information of calling, and the publicly-owned synonym information relationship (as table 2) of the public assistance information correspondence of each default Service Database, the publicly-owned synonym information that obtains invoked public assistance information is to call public assistance information, and utilize storing process and public assistance information deal with data, obtain the visit result;
Step S416: will visit the result and return central database;
Step S417: when abnormal information occurring in the access process, display alarm information;
Step S418: successful recalls information is write accessed Service Database and central database self, particularly:
Central database utilizes the privately owned synonym of accessed Service Database to write and calls successful information to accessed Service Database; And central database utilize publicly-owned synonym to write to call successful information to the data dictionary module (referring to the data dictionary module 62 among Fig. 6) of central database to realize synchronous between central database and the accessed Service Database.
One of ordinary skill in the art will appreciate that: foreground support system and background application system all can be utilized the privately owned and/or publicly-owned synonym visit corresponding service data message of central data library storage.
Present embodiment is by setting up central database between each Service Database and application interface, and utilize privately owned synonym to conduct interviews to each Service Database is point-to-point by central database, avoided in the prior art foreground support system or background application system frequent and switch the low defective of system stability that causes between each Service Database, the stability of application platform in the access process of multi-service data storehouse and the reliability of visit data have been improved, and under the simultaneous situation of a plurality of Service Databases (in existence and the business datum system), realize that each Service Database does not disturb mutually, realize that by central database coordinative operation is engaged in and autonomous visit, management such as alarm.
System embodiment
Fig. 5 is the example structure synoptic diagram of data base access system of the present invention.Each embodiment of above-mentioned Fig. 2-Fig. 4 method invention all can realize in the database access control device Z0 shown in Fig. 5 structural drawing.
As shown in Figure 5, this system comprises an application interface unit 500 and an encapsulated data units 502.
Application interface unit 500 comprises: foreground application interface 50 and background application interface 52, and to receive the request of access of sending from foreground support system and background application system that comprises accessed Service Database and accessed service data information thereof respectively.
Encapsulated data units 502 comprises: database access control device Z0 and a plurality of business datum system of depositing service data information.As shown in Figure 5, each business datum system comprises a Service Database, and database access control device Z0 comprises a central database.Service Database shown in Figure 5 has 7, is respectively Z10-Z70.The number that it will be understood by those skilled in the art that the business datum system is unrestricted, and therefore, the intrasystem Service Database of consistent a plurality of business datum can be dispatched, be managed to the central database in the database access control device Z0.
It is specifically professional that each Service Database is used for a corresponding class, as, Service Database Z10-Z70 respectively corresponding Fetion business, mailbox service, reservation, lily business, mobile desktop assistant business, mobile phone security and one three nine-day periods after the winter solstice community etc.The equal separate, stored of each Service Database, and on physical store, use the file cutting technique to strengthen the collapse processing power of each Service Database.In addition, encapsulated data units 502 can adopt plug-in type to insert each Service Database.Like this, when only needing to reach the standard grade the partial service database, only need to insert the Service Database that needs, other Service Databases then can not insert.
In database access control device Z0, can prestore:
(1) definition of the sign of each Service Database and access rights is represented Service Database Z10 and Service Database Z20 respectively as 010 and 020, can certainly represent with Z10 and Z20 directly that R and W represent read right and write permission respectively.
(2) mapping table between the service data information of each Service Database and the privately owned synonym.
(3) the publicly-owned synonym information relationship table of the public assistance information correspondence of each Service Database.
(4) the publicly-owned synonym information relationship table of each public services data message correspondence.
Database access control device Z0 resolves request of access according to the above-mentioned information of its storage, discerning accessed service data information and corresponding privately owned synonym thereof and the authority of request of access, the public assistance information that can also the identification services database need call.
Database access control device Z0 according to the pairing privately owned synonym of accessed service data information and the accessed point-to-point two-way communication of Service Database with the accessed Service Database of visit in access rights.Database access control device Z0 also visits in common information repository according to the pairing publicly-owned synonym of accessed service data information, specifically can identical or similar content be repeated in this description at this referring to the related description about visiting among the said method embodiment.
Can adopt logic to be connected between database access control device Z0 and each Service Database, can isolate mutually on the physical store.The data base access system shown in Figure 5 data system that can also comprise other mutually arranged side by side with encapsulated data units (non-business datum system) is as: test data system (comprising test database) and analyze data system (comprising analytical database) etc.Correspondingly, set up application interface in the application interface unit 500 to connect above-mentioned database.
Present embodiment is by setting up the database access control device between each business datum system and application interface, and the business datum system is point-to-point conducts interviews to each to utilize privately owned synonym by the database access control device, so that foreground support system or background application system directly with between the database access control device are carried out information interaction and promptly can be reached the purpose of visiting each Service Database, the stability of application platform in the access process of multi-service data storehouse and the reliability of visit data have been improved, and realize that each Service Database does not disturb mutually, realize that by the database access control device coordinative operation is engaged in and autonomous visit, management such as alarm.
Fig. 6 is the example structure synoptic diagram of encapsulated data units among Fig. 5.As shown in Figure 6: encapsulated data units 502 comprises:
Interface management module 61, each interface of call request, management database application interface unit 500 that is used for receiving request of access and accessed Service Database is so that can proper communication and backward reference result between encapsulated data units 502 and each application platform; The application interface of present embodiment can be supported multiple application platform, as, JAVA routine interface business datum bank interface etc., wherein interface shape is various, as, publicly-owned and privately owned synonym etc., wherein, this call request comprise each Service Database that need call public be used for the public assistance information that assistance information is handled;
Subsystem management module 63, the management that is used for each Service Database coding and adds, unload, and according to the accessed service data information and the corresponding synonym of publicly-owned assitance data information of the identification of the corresponding relation between corresponding relation, publicly-owned assitance data information and the publicly-owned synonym between accessed service data information and privately owned synonym or the publicly-owned synonym, and the authority of identification request of access, as, the coding of each Service Database, title, description, on-line time, whether expired, encode definition rule and loading and unloading definition etc.;
Platform management module 64 is used to set up public assistance information and the public services data message of common information repository to store each Service Database;
Wherein, interface management module 61, data dictionary module 62, subsystem management module 63,64 of platform feature administration modules are stored in the central database, and 67 of alarm modules are present in each Service Database.System maintaining module 65, dispatching management module 66 are functional modules that central database and Service Database all have respectively, but are stored in respectively in central database and the Service Database.
Device embodiment
Fig. 7 is the embodiment synoptic diagram of database access control device of the present invention.As shown in Figure 7, database access control device Z0 comprises:
Interface module is used to receive the request of access that comprises accessed Service Database and accessed service data information thereof, and the backward reference result;
Information storage module is used for the privately owned synonym information relationship of the service data information correspondence of each Service Database;
The access process module, be used for according to accessed service data information, and the privately owned synonym information relationship of the service data information correspondence of each Service Database, obtain the privately owned synonym information of accessed service data information, and according to the accessed Service Database of privately owned synonym message reference, to interface module backward reference result.
Wherein, when specific implementation, interface module can be the interface management module 71 among Fig. 7; Information storage module can be the data dictionary module 72 among Fig. 7; The access process module can be the subsystem management module among Fig. 7 73.
Interface module (as interface management module 71) also is used to receive the call request of accessed Service Database, and this call request comprises the public public assistance information that is used for the assistance information processing of each Service Database that need call.
Information storage module (as data dictionary module 72) is also stored the publicly-owned synonym information relationship of the public assistance information correspondence of each Service Database.
Access process module (as subsystem management module 73), also be used for according to the public assistance information of calling, and the publicly-owned synonym information relationship of the public assistance information correspondence of each Service Database, the publicly-owned synonym information of the public assistance information that acquisition is called, and call public assistance information according to publicly-owned synonym information, return to accessed Service Database and call the result.
Database access control device Z0 can also comprise: platform management module 74, system maintaining module 75 and dispatching management module 76.
One of ordinary skill in the art will appreciate that: the effect of platform management module 74, system maintaining module 75 and dispatching management module 76 is to make database access control device Z0 more preferably control access process, can add according to actual needs or delete; Simultaneously, database access control device Z0 is not limited to the above-mentioned functions module, can increase other functional modules according to the demand of information interaction between each Service Database and the database access control device Z0.
It should be noted that at last: the above only is the preferred embodiments of the present invention, be not limited to the present invention, although the present invention is had been described in detail with reference to previous embodiment, for a person skilled in the art, it still can be made amendment to the technical scheme that aforementioned each embodiment put down in writing, and perhaps part technical characterictic wherein is equal to replacement.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (14)
1. a data bank access method is characterized in that, may further comprise the steps:
Reception comprises the request of access of accessed Service Database and accessed service data information thereof;
According to the described accessed service data information in the described request of access, and the privately owned synonym information relationship of the service data information correspondence of each default Service Database, obtain the privately owned synonym information of described accessed service data information;
According to the described accessed Service Database of privately owned synonym message reference of described accessed service data information, and return the visit result of described accessed service data information.
2. data bank access method according to claim 1 is characterized in that, after the operation of the Service Database that described visit is accessed, the operation of returning described visit result also comprises before:
Judge whether described accessed Service Database needs to call the public public assistance information that is used for the assistance information processing of each Service Database;
According to the described public assistance information of calling, and the publicly-owned synonym information relationship of the public assistance information correspondence of each default Service Database, obtain the publicly-owned synonym information of the described public assistance information of calling;
Call the described public assistance information of calling according to described publicly-owned synonym information, carry out the follow-up operation of returning described visit result.
3. data bank access method according to claim 1 is characterized in that, the operation that receives described request of access also comprises before:
Set up the privately owned synonym information of each Service Database correspondence; Wherein,
Described privately owned synonym information is used to indicate the service data information that is stored in its corresponding service database.
4. data bank access method according to claim 2 is characterized in that, the operation that receives described request of access also comprises before:
Set up the publicly-owned synonym information of each Service Database correspondence; Wherein,
Described publicly-owned synonym information is used to indicate the public assistance information of each Service Database.
5. data bank access method according to claim 1 is characterized in that, the operation of the described accessed Service Database of described privately owned synonym message reference according to described accessed service data information specifically comprises:
The privately owned synonym information of utilizing described accessed Service Database is carried out point-to-point two-way communication to described accessed Service Database and is stored in service data information in this Service Database with visit.
6. according to each described data bank access method among the claim 1-5, it is characterized in that the privately owned synonym information relationship of the service data information correspondence of described default each Service Database is stored in the central database between the transmit leg of described each Service Database and described request of access.
7. a database access control device is characterized in that, this device comprises:
Interface module is used to receive the request of access that comprises accessed Service Database and accessed service data information thereof, and the backward reference result;
Information storage module is used to store the privately owned synonym information relationship of the service data information correspondence of each Service Database;
The access process module, be used for according to described accessed service data information, and the privately owned synonym information relationship of the service data information correspondence of each Service Database, obtain the privately owned synonym information of described accessed service data information, and according to the described accessed Service Database of described privately owned synonym message reference, to described interface module backward reference result.
8. database access device according to claim 7 is characterized in that:
Described interface module also is used to receive the call request of described accessed Service Database, and described call request comprises the public assistance information of each Service Database that need call;
Described information storage module is also stored the publicly-owned synonym information relationship of the public assistance information correspondence of each Service Database;
Described access process module, also be used for the public assistance information called according to described, and the publicly-owned synonym information relationship of the public assistance information correspondence of described each Service Database, obtain the publicly-owned synonym information of the described public assistance information of calling, and call the described public assistance information of calling according to described publicly-owned synonym information, return to described accessed Service Database and call the result.
9. database access control device according to claim 8 is characterized in that, further comprises:
The platform management module, the public assistance information of described each Service Database of storage;
Dispatching management module is used to upgrade the public assistance information of described each Service Database;
System maintaining module is used to back up the corresponding publicly-owned synonym information relationship of the public assistance information of the privately owned synonym information relationship corresponding with the service data information of each Service Database that recovers described information storage module storage, each Service Database and the public assistance information of described each Service Database.
10. a data base access system is characterized in that, this system comprises:
At least one business datum system, wherein, each business datum system comprises the Service Database that is used to deposit service data information;
Application interface unit comprises at least one application interface, is used to receive the request of access that comprises accessed Service Database and accessed service data information thereof;
The database access control device, be connected between described application interface unit and each the business datum system, be used for described accessed service data information according to described request of access, and the privately owned synonym information relationship of the service data information correspondence of each default Service Database, obtain the privately owned synonym information of described accessed service data information, and according to the described accessed Service Database of privately owned synonym message reference of described accessed service data information, and will visit the result and be back to described application interface unit.
11. data base access system according to claim 10 is characterized in that, described business datum system comprises:
System maintaining module is used for backup and recovers service data information;
Alarm module is used for monitoring and alarming the abnormal information of access process.
12. data access system according to claim 11 is characterized in that, described database access control device comprises:
Interface module is used to receive the request of access that comprises accessed Service Database and accessed service data information thereof, and the backward reference result;
Information storage module is used to store the privately owned synonym information relationship of the service data information correspondence of each Service Database;
The access process module, be used for described accessed service data information according to described request of access, and the privately owned synonym information relationship of the service data information correspondence of each Service Database, obtain the privately owned synonym information of described accessed service data information, and according to the described accessed Service Database of described privately owned synonym message reference, to described interface module backward reference result.
13. data base access system according to claim 12 is characterized in that,
Described interface module also is used for, and receives the call request of described accessed Service Database, and described call request comprises the public public assistance information that is used for the assistance information processing of each Service Database that need call;
Described information storage module is also stored, the publicly-owned synonym information relationship of the public assistance information correspondence of each Service Database;
Described access process module, also be used for the public assistance information called according to described, and the publicly-owned synonym information relationship of the public assistance information correspondence of described each Service Database, obtain the publicly-owned synonym information of the described public assistance information of calling, and call the described public assistance information of calling according to described publicly-owned synonym information, return to described accessed Service Database and call the result.
14. data base access system according to claim 13 is characterized in that, described business datum system comprises that also one is used to call the dispatching management module of the described public assistance information of calling.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101485668A CN101739435B (en) | 2008-11-07 | 2009-06-29 | Database access method and control device |
Applications Claiming Priority (3)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200810175880.0 | 2008-11-07 | ||
| CN200810175880 | 2008-11-07 | ||
| CN2009101485668A CN101739435B (en) | 2008-11-07 | 2009-06-29 | Database access method and control device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101739435A true CN101739435A (en) | 2010-06-16 |
| CN101739435B CN101739435B (en) | 2012-05-09 |
Family
ID=42462925
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009101485668A Active CN101739435B (en) | 2008-11-07 | 2009-06-29 | Database access method and control device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101739435B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102207978A (en) * | 2011-06-30 | 2011-10-05 | 北京新媒传信科技有限公司 | Database access method and system |
| CN103577431A (en) * | 2012-07-27 | 2014-02-12 | 深圳市易通无限科技有限公司 | Method, device and system for performing system design through multiple databases |
| CN102999554B (en) * | 2012-10-15 | 2016-04-06 | 北京京东世纪贸易有限公司 | Business data processing method and device |
| CN107465653A (en) * | 2016-06-02 | 2017-12-12 | 北京京东尚科信息技术有限公司 | Rights Management System and method |
| CN109299125A (en) * | 2018-10-31 | 2019-02-01 | 中国银行股份有限公司 | Database update method and device |
| CN109360324A (en) * | 2018-09-26 | 2019-02-19 | 深圳怡化电脑股份有限公司 | Banknote detection method, banknote tester, finance device and computer readable storage medium |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1598814A (en) * | 2003-09-19 | 2005-03-23 | 鸿富锦精密工业（深圳）有限公司 | Classification retrieval system and method for synonym |
| CN100403315C (en) * | 2006-09-25 | 2008-07-16 | 华为技术有限公司 | System and method for database access for implementing load sharing |
| CN100561475C (en) * | 2006-10-19 | 2009-11-18 | 维豪信息技术有限公司 | The integration method of heterogeneous different source different platform data and switching method |
| CN101075929B (en) * | 2007-03-02 | 2010-11-24 | 腾讯科技（深圳）有限公司 | Method, system and server for inquiring information |
| CN101146155B (en) * | 2007-11-16 | 2011-10-05 | 中国电信股份有限公司 | An information query method and system based on keys on the voice platform |
-
2009
- 2009-06-29 CN CN2009101485668A patent/CN101739435B/en active Active
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102207978A (en) * | 2011-06-30 | 2011-10-05 | 北京新媒传信科技有限公司 | Database access method and system |
| CN103577431A (en) * | 2012-07-27 | 2014-02-12 | 深圳市易通无限科技有限公司 | Method, device and system for performing system design through multiple databases |
| CN103577431B (en) * | 2012-07-27 | 2017-02-22 | 东莞市嘉和会计有限公司 | Method, device and system for performing system design through multiple databases |
| CN102999554B (en) * | 2012-10-15 | 2016-04-06 | 北京京东世纪贸易有限公司 | Business data processing method and device |
| CN107465653A (en) * | 2016-06-02 | 2017-12-12 | 北京京东尚科信息技术有限公司 | Rights Management System and method |
| CN107465653B (en) * | 2016-06-02 | 2021-03-30 | 北京京东尚科信息技术有限公司 | Authority management system, device and method, computer readable storage medium |
| CN109360324A (en) * | 2018-09-26 | 2019-02-19 | 深圳怡化电脑股份有限公司 | Banknote detection method, banknote tester, finance device and computer readable storage medium |
| CN109299125A (en) * | 2018-10-31 | 2019-02-01 | 中国银行股份有限公司 | Database update method and device |
| CN109299125B (en) * | 2018-10-31 | 2021-05-28 | 中国银行股份有限公司 | Database updating method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101739435B (en) | 2012-05-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101739435B (en) | Database access method and control device | |
| CA1241765A (en) | Distributed information backup system | |
| CN102929220B (en) | Distributed monitoring system and database server, fault processing device and fault processing method thereof | |
| US5237681A (en) | Relational data base memory utilization analyzer | |
| CN103209429A (en) | Data auditing method and system for mobile communication services | |
| CN101071434B (en) | User distributing method, device and system for distributed database system | |
| CN110599093B (en) | Airport luggage whole-flow tracking method and system | |
| CN100456701C (en) | Apparatus and method for improving reliability of communication system and communication system thereof | |
| CN102402622A (en) | Memory page managing and scheduling method for embedded memory database | |
| CN114363142A (en) | Service management and control system based on micro-service architecture | |
| CN107066522A (en) | The access method and device of database | |
| EP2996318B1 (en) | Management device and computer program | |
| CN102243655A (en) | Method and device for managing database connections | |
| CN102243653A (en) | Method and device for managing database connections | |
| Meng et al. | An asset management system based on RFID, WebGIS and SMS | |
| CN102547815A (en) | Device and method for implementing black box of multi-mode base station | |
| CN102405465A (en) | Database device, database matching system, and database matching method | |
| CN108280097A (en) | A kind of fault handling method and device of Database Systems | |
| CN107807884B (en) | Method for modular management of error codes | |
| CN102420856B (en) | Data processing method and equipment | |
| CN102289476A (en) | Method for recording transaction log | |
| US9443206B2 (en) | Reconciling addresses | |
| CN100473009C (en) | Line card management method and system | |
| JP2973685B2 (en) | A common database duplication method for mobile communication systems | |
| CN109697514A (en) | A kind of provincial auto repair Electronic Health Record system |
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 |