CN103150408B - Real-time data base finds data base the System and method for accessed according to calling the roll - Google Patents
Real-time data base finds data base the System and method for accessed according to calling the roll Download PDFInfo
- Publication number
- CN103150408B CN103150408B CN201310113588.7A CN201310113588A CN103150408B CN 103150408 B CN103150408 B CN 103150408B CN 201310113588 A CN201310113588 A CN 201310113588A CN 103150408 B CN103150408 B CN 103150408B
- Authority
- CN
- China
- Prior art keywords
- real
- time data
- data base
- measuring point
- module
- 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
- 238000000034 method Methods 0.000 title claims abstract description 14
- 239000000284 extract Substances 0.000 claims description 3
- 238000004064 recycling Methods 0.000 claims description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001351 cycling effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of real-time data base finds data base the System and method for accessed according to calling the roll, it is characterized in that: when after the request accepting user, need all real-time data bases are traveled through, in traversal every time, the known measuring point belonging to this real-time data base and unknown measuring point are all sent to real-time data base, according to real-time data base return information, from unknown measuring point, delete the measuring point belonging to this data base, perform circulation next time until all of measuring point all reads successfully or all real-time data bases traversal is complete；The method includes configuration file read module, point position thesaurus, scheduler module, real-time data access module and error code module.This invention on the premise of not affecting efficiency, can be searched the roll-call of all data bases, and access in the case of only calling the roll.On the premise of not affecting efficiency, according only to the point that i.e. may have access in real-time data base of calling the roll.
Description
Technical field
The present invention relates to a kind of multiple real-time data base finds data base the System and method for accessed according to calling the roll, after configuring the roll-call that real-time data base accesses, the method that this point value can be searched between multiple real-time data bases.
Background technology
During for the value of the roll-call correspondence in access real-time data base, owing to set of system may associate multiple real-time data base, during so configuring roll-call, in addition it is also necessary to configure the data base of concrete association.So bring several drawback: one, owing to, in on-site actual situations, needing the some enormous amount read, bring a lot of trouble thus to on-site development personnel.；Two, owing to needing the data base of configuration association and these two contents of calling the roll, the risk increasing configuration error is caused；Three, one omitting the data base of amendment configuration association and calling the roll in these two contents it is likely to during amendment.The problems referred to above are badly in need of solving.
Summary of the invention
The present invention is in order to make up the deficiencies in the prior art, it is provided that during the multiple real-time database of a kind of connection, find data base the System and method for accessed according to calling the roll.
The present invention is achieved through the following technical solutions:
According to the operation method of system finding data base and access of calling the roll in a kind of real-time data base, it is characterized in that: when after the request accepting user, need all real-time data bases are traveled through, in traversal every time, the known measuring point belonging to this real-time data base and unknown measuring point are all sent to real-time data base, according to real-time data base return information, from unknown measuring point, delete the measuring point belonging to this data base, perform circulation next time until all of measuring point all reads successfully or all real-time data bases traversal is complete；The method includes configuration file read module, point position thesaurus, scheduler module, real-time data access module and error code module.
Described configuration file read module, user's form according to the rules is write the profile information connecting real-time data base, is opened the configuration file that user writes, read configuration file, extracts database linkage information, and preserve；
Described real-time data access module, sets up the connection with real-time data base according to configuration file, calls the API of current real-time database, inputs roll-call accessing points value；
Described point position thesaurus module, constructs list structure, and this list structure comprises, and calls the roll and real-time data base connects entity, and external object can be arranged and reading database entity object according to calling the roll；
Described error code module, is automatically converted to unified error code by the error code that each real-time data base returns；
Described scheduler module, calls configuration file read module and reads the database linkage information in configuration file, and the information of recycling reading and real-time data access module set up the entity of multiple data base.1) user inputs the measuring point list needing to access.2) all measuring points in traversal measuring point list, if measuring point in measuring point list being grouped measuring point according to the real-time data base that measuring point is corresponding do not have the real-time data base of correspondence, then put in unknown group.3) with all real-time database for circulation, arranging the successful measuring point number of access is 0, first by measuring point group corresponding for current real-time data storehouse and unknown combination and be an interim measuring point group, is sent in this real-time data base by all measuring points of interim measuring point group.After real-time data base returns data, this request is not occurred that the measuring point number of measuring point not mistake is added to access in successful measuring point number, by asking the relation of successful measuring point and this real-time data base, be stored in point position thesaurus.Measuring point return value measuring point not mistake do not occur is copied in the measuring point that return value array is corresponding.Then from unknown group, remove the measuring point that measuring point not mistake does not occur.Continue thereafter with and be recycled to next real-time data base.Ask measuring point number or all real-time data bases traversal complete until accessing successful measuring point number equal to user.4) measuring point value is returned.
The configuration file read module of the present invention, for reading the configuration information connecting data base；Point position thesaurus, for the data base that savepoint is corresponding；Scheduler module, is loaded into the general-purpose accessing interface module used by each real-time data base of configuration；Real-time data access module, according to calling the roll and the message reference point value of each real-time data base；Error code module, the error code that the error code that returned by each real-time data base is unified.
According to the operation method of system finding data base and access of calling the roll in described real-time data base, it is characterised in that to real-time data base traversal and set up multiple data base procedure and be:
A) user inputs the measuring point list needing to access；B) all measuring points in traversal measuring point list, according to the information of point position thesaurus, the measuring point in measuring point list is grouped by the real-time data base corresponding according to measuring point；If measuring point does not has the real-time data base of correspondence, then put in unknown group；C) with all real-time database for circulation, arranging the successful measuring point number of access is 0, first by measuring point group corresponding for current real-time data storehouse and unknown combination and be an interim measuring point group, is sent in this real-time data base by all measuring points of interim measuring point group；After real-time data base returns data, this request is not occurred that the measuring point number of measuring point not mistake is added to access in successful measuring point number, by asking the relation of successful measuring point and this real-time data base, be stored in point position thesaurus；Measuring point return value measuring point not mistake do not occur is copied in the measuring point that return value array is corresponding；Then from unknown group, remove the measuring point that measuring point not mistake does not occur.Continue thereafter with and be recycled to next real-time data base；Ask measuring point number or all real-time data bases traversal complete until accessing successful measuring point number equal to user；D) measuring point value is returned.
The invention has the beneficial effects as follows: this invention on the premise of not affecting efficiency, can be searched the roll-call of all data bases, and access in the case of only calling the roll.On the premise of not affecting efficiency, according only to the point that i.e. may have access in real-time data base of calling the roll.
Accompanying drawing explanation
The present invention is further illustrated below in conjunction with the accompanying drawings.
Fig. 1 reading data flow of the present invention journey figure；
The frame diagram of Fig. 2 present invention.
Detailed description of the invention
The present invention is further illustrated below in conjunction with the accompanying drawings.Accompanying drawing is the flow chart of the present invention..
1, configuration file read module, user is needed to extract the link information of data base, and the configuration file of the format writing real-time data base specified according to this module, when program starts, open the configuration file that user writes, read configuration file, extract database linkage information, and link information is saved in internal memory, in order to quickly calling for other modules the most momentarily；
2, real-time data access module, sets up the connection with real-time data base according to the configuration information that configuration file read module provides, and holds this connection entity all the time.When user needs to access the measuring point in certain real-time data base concrete, the unification that calling this module provides accesses real time data bank interface to obtain specifying information.Access the measuring point of certain data base concrete by calling the API of current real-time database inside this interface internal.；
3, point position thesaurus module, constructs list structure, and this list structure comprises measuring point name and real-time data base connects entity, in order to quickly be found the database entity of correspondence by measuring point name, so utilizing Map to store, being set to keyword call the roll, being worth for real-time data base entity.The outside interface that can be provided by ability module, input roll-call obtains reading database entity；
4, scheduler module, calls configuration file read module and reads the database linkage information in configuration file, and the information of recycling reading and real-time data access module set up the entity of multiple data base.
1) user inputs the measuring point list needing to access.2) all measuring points in traversal measuring point list, the measuring point name information corresponding with real-time data base entity provided according to point position thesaurus module, the interface calling point position thesaurus module obtains the real-time data base entity that measuring point is corresponding, and the measuring point belonging to same real-time data base entity is integrated in a measuring point group (such as, measuring point corresponding for first real-time data base entity is all put in measuring point group 1, measuring point corresponding for second real-time data base entity is all put in test group 2, by that analogy).If measuring point does not has the real-time data base entity of correspondence, then measuring point is put in unknown group.
2) newly-built statistics accesses successful measuring point number variable, and arranging initialization of variable is 0.Create return value array.
3) entity of all real-time data bases is traveled through, circulation is internal to be operated each real-time data base entity: a) first will calculate measuring point group corresponding to the current real-time data storehouse got and unknown combination in step 2 and is an interim measuring point group, the interface provided by real-time data base entity by all measuring points of interim measuring point group, is sent in current real-time data storehouse.B) after real-time data base returns data, the interface that call error code module provides, error code is converted to unified error code.C) not occurring that the quantity of the measuring point of measuring point not mistake is added to access in successful measuring point number variable d) in unknown point group and ask the relation of successful measuring point and real-time data base entity, the interface provided by calling point position thesaurus module is stored in point position thesaurus.E) do not occur that the measuring point return value of measuring point not mistake copies in the measuring point that return value array is corresponding.F) remove from unknown group the measuring point of measuring point not mistake does not occur.
4) next real-time data base is continued cycling through.Until the variable of the successful measuring point number of access-ask measuring point number or all real-time data bases traversal complete equal to user.
5) return is worth array and returns to user.
5, error code module, each real-time data base drives and is mapped on unified error code by the error code of oneself.
Claims (1)
1. according to the operation method of system finding real-time data base and access of calling the roll in a real-time data base, it is characterized in that: this system includes configuration file read module, point position thesaurus module, scheduler module, real-time data access module and error code module, wherein
Described configuration file read module, writes the profile information connecting real-time data base, opens the configuration file write, read configuration file, extract real-time data base link information, and preserve for user's form according to the rules；
Described real-time data access module, for setting up the connection with real-time data base according to configuration file, calls the API in current real-time data storehouse, inputs roll-call accessing points value；
Described point position thesaurus module, for calling the roll and real-time data base connection entity, external object can arrange according to calling the roll and read real-time data base entity object；
Described error code module, is automatically converted to unified error code by the error code that each real-time data base returns；
Described scheduler module, calls configuration file read module and reads the real-time data base link information in configuration file, and the information of recycling reading and real-time data access module set up the entity of multiple real-time data base；
ShouldThe operation method of system, to real-time data base ergodic process be i.e.:
1) user inputs the measuring point list needing to access；
2) all measuring points in traversal measuring point list, the measuring point name information corresponding with real-time data base entity provided according to point position thesaurus module, the interface calling point position thesaurus module obtains the real-time data base entity that measuring point is corresponding, and is integrated in a measuring point group by the measuring point belonging to same real-time data base entity；If measuring point does not has the real-time data base entity of correspondence, then measuring point is put in unknown group；
3) newly-built statistics accesses successful measuring point number variable, and arranging initialization of variable is 0, creates return value array；
4) entity of all real-time data bases is traveled through, each real-time data base entity is operated: first by measuring point group corresponding for current real-time data storehouse and unknown combination and be an interim measuring point group, all measuring points of interim measuring point group are sent in this real-time data base；After real-time data base returns data, the interface that call error code module provides, error code is converted to unified error code；This request is not occurred that the measuring point number of measuring point not mistake is added to access in successful measuring point number, by accessing the relation of successful measuring point and this real-time data base, is stored in point position thesaurus module；Measuring point return value measuring point not mistake do not occur is copied in the measuring point that return value array is corresponding；Then from unknown group, remove the measuring point that measuring point not mistake does not occur；
5) next real-time data base is continued to run until；Ask measuring point number or all real-time data bases traversal complete until accessing successful measuring point number equal to user；
6) return is worth array and returns to user.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310113588.7A CN103150408B (en) | 2013-04-02 | 2013-04-02 | Real-time data base finds data base the System and method for accessed according to calling the roll |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310113588.7A CN103150408B (en) | 2013-04-02 | 2013-04-02 | Real-time data base finds data base the System and method for accessed according to calling the roll |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103150408A CN103150408A (en) | 2013-06-12 |
| CN103150408B true CN103150408B (en) | 2016-08-03 |
Family
ID=48548485
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310113588.7A Expired - Fee Related CN103150408B (en) | 2013-04-02 | 2013-04-02 | Real-time data base finds data base the System and method for accessed according to calling the roll |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103150408B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112148270B (en) * | 2020-08-12 | 2024-05-14 | 珠海伟诚科技股份有限公司 | Real-time computing and data interaction method, system and medium |
| CN113434519B (en) * | 2021-08-26 | 2021-12-10 | 西安热工研究院有限公司 | Method, system and storage medium for updating label names of measuring points |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102110134A (en) * | 2010-12-28 | 2011-06-29 | 青岛海信网络科技股份有限公司 | Real-time database for rail transit, operating method and operating device |
| CN102129442A (en) * | 2010-09-20 | 2011-07-20 | 华为技术有限公司 | Distributed database system and data accessing method |
| CN102609463A (en) * | 2012-01-13 | 2012-07-25 | 广东电网公司电力科学研究院 | Data cluster management system based on quasi-realtime platform |
-
2013
- 2013-04-02 CN CN201310113588.7A patent/CN103150408B/en not_active Expired - Fee Related
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102129442A (en) * | 2010-09-20 | 2011-07-20 | 华为技术有限公司 | Distributed database system and data accessing method |
| CN102110134A (en) * | 2010-12-28 | 2011-06-29 | 青岛海信网络科技股份有限公司 | Real-time database for rail transit, operating method and operating device |
| CN102609463A (en) * | 2012-01-13 | 2012-07-25 | 广东电网公司电力科学研究院 | Data cluster management system based on quasi-realtime platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103150408A (en) | 2013-06-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106202207B (en) | HBase-ORM-based indexing and retrieval system | |
| WO2020233330A1 (en) | Batch testing method, apparatus, and computer-readable storage medium | |
| CN102254029B (en) | View-based data access system and method | |
| CN102323964B (en) | Digital circuit net list data processing method | |
| CN110941621A (en) | Method and device for synchronizing databases between internal network and external network | |
| KR20170019352A (en) | Data query method and apparatus | |
| CN110990390B (en) | Data cooperative processing method, device, computer equipment and storage medium | |
| CN104239377A (en) | Platform-crossing data retrieval method and device | |
| CN110175163A (en) | More library separation methods, system and medium based on business function intelligently parsing | |
| US20210191903A1 (en) | Generating hash trees for database schemas | |
| CN107171897A (en) | A kind of interface test method and data-interface test system | |
| CN107291471A (en) | A kind of Meta model framework system for supporting customizable data acquisition | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN110399089B (en) | Data storage method, device, equipment and medium | |
| CN103164335B (en) | The method and system of inspection unit test mass | |
| CN112698819A (en) | Method, device and storage medium for designing tree-oriented object programming program | |
| CN103150408B (en) | Real-time data base finds data base the System and method for accessed according to calling the roll | |
| US8131728B2 (en) | Processing large sized relationship-specifying markup language documents | |
| CN109902101A (en) | Transparent partition method and device based on SparkSQL | |
| CN117033249A (en) | Test case generation method and device, computer equipment and storage medium | |
| CN105243020A (en) | Automatic test method applicable for global distributed real-time database | |
| CN110471708B (en) | Method and device for acquiring configuration items based on reusable components | |
| CN113868138A (en) | Method, system, equipment and storage medium for acquiring test data | |
| CN113703777A (en) | Code generation method and device based on database table, storage medium and equipment | |
| CN108629012B (en) | Intelligent verification method and system for forensic data analysis accuracy |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| ASS | Succession or assignment of patent right |
Owner name: ELECTRIC POWER RESEARCH INSTITUTE, STATE GRID SHAN Effective date: 20141117 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20141117 Address after: Xinluo Avenue high tech Zone of Ji'nan City, Shandong province 250101 silver bearing No. 2008 building B block 5 layer Applicant after: SHANDONG LUNENG SOFTWARE TECHNOLOGY Co.,Ltd. Applicant after: ELECTRIC POWER RESEARCH INSTITUTE OF STATE GRID SHANDONG ELECTRIC POWER Co. Address before: Xinluo Avenue high tech Zone of Ji'nan City, Shandong province 250101 silver bearing No. 2008 building B block 5 layer Applicant before: SHANDONG LUNENG SOFTWARE TECHNOLOGY Co.,Ltd. |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CP01 | Change in the name or title of a patent holder | ||
| CP01 | Change in the name or title of a patent holder |
Address after: 250101 5th floor, block B, Yinhe building, 2008 Xinluo street, high tech Zone, Jinan City, Shandong Province Patentee after: Shandong luruan Digital Technology Co.,Ltd. Patentee after: ELECTRIC POWER RESEARCH INSTITUTE OF STATE GRID SHANDONG ELECTRIC POWER Co. Address before: 250101 5th floor, block B, Yinhe building, 2008 Xinluo street, high tech Zone, Jinan City, Shandong Province Patentee before: SHANDONG LUNENG SOFTWARE TECHNOLOGY Co.,Ltd. Patentee before: ELECTRIC POWER RESEARCH INSTITUTE OF STATE GRID SHANDONG ELECTRIC POWER Co. |
|
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20160803 |