CN103150408A - System and method for finding and accessing database in real-time databases according to roll call - Google Patents
System and method for finding and accessing database in real-time databases according to roll call Download PDFInfo
- Publication number
- CN103150408A CN103150408A CN2013101135887A CN201310113588A CN103150408A CN 103150408 A CN103150408 A CN 103150408A CN 2013101135887 A CN2013101135887 A CN 2013101135887A CN 201310113588 A CN201310113588 A CN 201310113588A CN 103150408 A CN103150408 A CN 103150408A
- Authority
- CN
- China
- Prior art keywords
- real
- measuring point
- time data
- data base
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 18
- 239000000284 extract Substances 0.000 claims description 3
- 238000004064 recycling Methods 0.000 claims description 3
- 238000012217 deletion Methods 0.000 claims description 2
- 230000037430 deletion Effects 0.000 claims description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a system and a method for finding and accessing database in real-time databases according to roll call. The method is characterized by comprising the following steps of: after receiving a request of a user, traversing all real-time databases as required; during each traversing, transmitting known measuring points and unknown measuring points which belong to a certain real-time database to the real-time database; returning information according to the real-time database; deleting measuring points which belong to the database from the unknown measuring points; and performing a next cycle till all measuring points are read successfully or all real-time databases are traversed. The method comprises a configuration file reading module, a measuring point position storing library, a scheduling module, a real-time data access module and an error code module. Due to the adoption of the system and the method, the roll call of all databases can be searched and accessed under the condition of roll call and on the premise of not influencing the efficiency. Points in the real-time databases can be accessed according to roll call on the premise of not influencing the efficiency.
Description
Technical field
The present invention relates to find according to roll-call in a kind of a plurality of real-time data base the System and method for of database and access, after the roll-call of configuration real-time data base access, can search the method for this point value between a plurality of real-time data bases.
Background technology
During for the value of the roll-call correspondence of access in real-time data base, because a cover system may related multiple real-time data base, so when configuration is called the roll, also need to configure the database of concrete association.Brought so several drawbacks: one, due in on-site actual situations, the some quantity that need to read is huge, brings a lot of troubles so just for the on-site development personnel.Two, due to the database that needs configuration association and these two contents of calling the roll, cause increasing the risk of configuration error; Also may omit in the database of revising configuration association and these two contents of calling the roll when three, revising.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, when a kind of connection a plurality of real-time storehouse is provided, finds the System and method for of database and access according to roll-call.
The present invention is achieved through the following technical solutions:
Find the operation method of the system of database and access in a kind of real-time data base according to roll-call, it is characterized in that: after the request of accepting the user, need to travel through all real-time data bases, in each traversal, known measuring point and the unknown measuring point that belongs to this real-time data base all sent to real-time data base, according to the real-time data base return message, deletion belongs to the measuring point of this database from unknown measuring point, carries out circulation next time until all measuring points all read successfully or all real-time data base traversals are complete; The method comprises 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 writes the profile information that connects real-time data base, opens the configuration file that the user writes, and reads configuration file, extracts database linkage information, and preserves;
Described real-time data access module is set up and being connected of real-time data base according to configuration file, calls the API in current real-time storehouse, inputs roll-call accessing points value;
Described point position thesaurus module, the structure list structure, this list structure comprises, and calls the roll to be connected entity with real-time data base, and external object can arrange and the reading database entity object according to calling the roll;
Described error code module, the error code that each real-time data base is returned is automatically converted to unified error code;
Described scheduler module is called the configuration file read module and is read database linkage information in configuration file, the entity that the information that recycling reads and real-time data access module are set up a plurality of databases.1) user inputs the measuring point list that needs access.2) all measuring points in the list of traversal measuring point if according to real-time data base corresponding to measuring point, the grouping of the measuring point in measuring point list measuring point is not had corresponding real-time data base, are put into unknown group.3) take all real-time storehouses as circulation, it is 0 that the successful measuring point number of access is set, and at first that current real-time data base is corresponding measuring point group and unknown combination and be an interim measuring point group send to all measuring points of interim measuring point group in this real-time data base.After the real-time data base return data, the not wrong measuring point number of measuring point is not appearred in this request be added in the successful measuring point number of access, the measuring point that request is successful and the relation of this real-time data base are stored in the point position thesaurus.The not wrong measuring point rreturn value of measuring point to not occur copies in measuring point corresponding to rreturn value array.Then remove from the unknown group and the not wrong measuring point of measuring point do not occur.Continue subsequently to be recycled to next real-time data base.Until equaling the user, the successful measuring point number of access ask measuring point number or all real-time data bases to travel through complete.4) return to the measuring point value.
Configuration file read module of the present invention is used for reading the configuration information in connection data storehouse; The point position thesaurus is used for database corresponding to savepoint; Scheduler module is written into each real-time data base general-purpose accessing interface module used of configuration; The real-time data access module is according to the message reference point value of roll-call and each real-time data base; The error code module, the error code that the error code that each real-time data base is returned is unified.
Find the operation method of the system of database and access in described real-time data base according to roll-call, it is characterized in that the real-time data base traversal and set up a plurality of data base procedures being:
A) user inputs the measuring point list that needs access; B) all measuring points in the list of traversal measuring point, according to the information of point position thesaurus, the real-time data base corresponding according to measuring point divides into groups the measuring point in the measuring point list; If measuring point does not have corresponding real-time data base, put into unknown group; C) take all real-time storehouses as circulation, it is 0 that the successful measuring point number of access is set, and at first that current real-time data base is corresponding measuring point group and unknown combination and be an interim measuring point group send to all measuring points of interim measuring point group in this real-time data base; After the real-time data base return data, the not wrong measuring point number of measuring point is not appearred in this request be added in the successful measuring point number of access, the measuring point that request is successful and the relation of this real-time data base are stored in the point position thesaurus; The not wrong measuring point rreturn value of measuring point to not occur copies in measuring point corresponding to rreturn value array; Then remove from the unknown group and the not wrong measuring point of measuring point do not occur.Continue subsequently to be recycled to next real-time data base; Until equaling the user, the successful measuring point number of access ask measuring point number or all real-time data bases to travel through complete; D) return to the measuring point value.
The invention has the beneficial effects as follows: this invention can under the prerequisite that does not affect efficient, be searched the roll-call of all databases in the situation that only have roll-call, and access.Under the prerequisite that does not affect efficient, be only point in addressable real-time data base according to roll-call.
Description of drawings
The present invention is further illustrated below in conjunction with accompanying drawing.
Fig. 1 reading out data flow process of the present invention figure;
Fig. 2 frame diagram of the present invention.
Embodiment
The present invention is further illustrated below in conjunction with accompanying drawing.Accompanying drawing is process flow diagram of the present invention.。
1, configuration file read module, need the user to extract the link information of database, and according to the configuration file of the format writing real-time data base of this module appointment, when program start, open the configuration file that the user writes, read configuration file, extract database linkage information, and link information is kept in internal memory, so that other modules of confession are fast momentarily called;
2, real-time data access module, the configuration information that provides according to the configuration file read module are set up and being connected of real-time data base, and hold all the time this connection entity.When the user need to access measuring point in concrete certain real-time data base, the unified access real time data bank interface that calling this module provides obtained specifying information.This interface internal-internal visits the measuring point of concrete certain database by the API that calls current real-time storehouse.；
3, point position thesaurus module, the structure list structure, this list structure comprises the measuring point name and is connected entity with real-time data base, in order to arrive corresponding database entity by fast finding by the measuring point name, so utilize Map to store, key word is set to call the roll, and is worth to be the real-time data base entity.The outside interface that can provide by the ability module, input is called the roll and is obtained the reading database entity;
4, scheduler module is called the configuration file read module and is read database linkage information in configuration file, the entity that the information that recycling reads and real-time data access module are set up a plurality of databases.
1) user inputs the measuring point list that needs access.2) all measuring points in the list of traversal measuring point, the measuring point name information corresponding with the real-time data base entity that provides according to point position thesaurus module, the interface that calls point position thesaurus module obtains real-time data base entity corresponding to measuring point, and the measuring point that will belong to same real-time data base entity (for example is integrated in a measuring point group, the measuring point that first real-time data base entity is corresponding is all put into measuring point group 1, second measuring point corresponding to real-time data base entity all put into test group 2, by that analogy).If measuring point does not have corresponding real-time data base entity, measuring point is put into unknown group.
2) the successful measuring point number variable of newly-built statistics access, it is 0 that initialization of variable is set.Create the rreturn value array.
3) travel through the entity of all real-time data bases, circulation is inner to be operated each real-time data base entity: a) at first will calculate the current real-time data base that gets corresponding measuring point group and unknown combination in step 2 and be an interim measuring point group, all measuring points of interim measuring point group by the interface that the real-time data base entity provides, are sent in current real-time data base.B) after the real-time data base return data, the interface that call error code module provides is converted to unified error code with error code.C) quantity that the not wrong measuring point of measuring point do not occur is added to d in the successful measuring point number variable of access) in the unknown point group and ask successful measuring point and the relation of real-time data base entity, be stored in the point position thesaurus by the interface that calls point position thesaurus module and provide.E) the not wrong measuring point rreturn value of measuring point not occurring copies in measuring point corresponding to rreturn value array.F) remove from the unknown group and the wrong measuring point of measuring point do not occur.
4) continue to be recycled to next real-time data base.Until the variable of the successful measuring point number of access-equal the user to ask measuring point number or all real-time data bases to travel through complete.
5) the rreturn value array is returned to the user.
5, error code module, the error code that each real-time data base drives oneself is mapped on unified error code.
Claims (3)
1. find the system of database and access in a real-time data base according to roll-call, it is characterized in that: this system comprises configuration file read module, point position thesaurus, scheduler module, real-time data access module and error code module, wherein
Described configuration file read module, be used for the user according to the rules form write the profile information that connects real-time data base, open the configuration file of writing, read configuration file, extract database linkage information, and preserve;
Described real-time data access module is used for setting up and being connected of real-time data base according to configuration file, calls the API in current real-time storehouse, inputs roll-call accessing points value;
Described point position thesaurus module, being used for calling the roll is connected entity with real-time data base, and external object can arrange and the reading database entity object according to calling the roll;
Described error code module, the error code that each real-time data base is returned is automatically converted to unified error code;
Described scheduler module is called the configuration file read module and is read database linkage information in configuration file, the entity that the information that recycling reads and real-time data access module are set up a plurality of databases.
2. find the operation method of the system of database and access in real-time data base according to claim 1 according to roll-call, it is characterized in that comprising the following steps: after the request of accepting the user, all real-time data bases are traveled through, in each traversal, known measuring point and the unknown measuring point that belongs to this real-time data base all sent to real-time data base, according to the real-time data base return message, deletion belongs to the measuring point of this database from unknown measuring point, carries out circulation next time until all measuring points all read successfully or all real-time data base traversals are complete.
3. find the operation method of the system of database and access in real-time data base according to claim 2 according to roll-call, it is characterized in that the real-time data base traversal and set up a plurality of data base procedures being:
A) user inputs the measuring point list that needs access; B) all measuring points in the list of traversal measuring point, according to the information of point position thesaurus, the real-time data base corresponding according to measuring point divides into groups the measuring point in the measuring point list; If measuring point does not have corresponding real-time data base, put into unknown group; C) take all real-time storehouses as circulation, it is 0 that the successful measuring point number of access is set, and at first that current real-time data base is corresponding measuring point group and unknown combination and be an interim measuring point group send to all measuring points of interim measuring point group in this real-time data base; After the real-time data base return data, the not wrong measuring point number of measuring point is not appearred in this request be added in the successful measuring point number of access, the measuring point that request is successful and the relation of this real-time data base are stored in the point position thesaurus; The not wrong measuring point rreturn value of measuring point to not occur copies in measuring point corresponding to rreturn value array; Then remove from the unknown group and the not wrong measuring point of measuring point do not occur; Continue subsequently to be recycled to next real-time data base; Until equaling the user, the successful measuring point number of access ask measuring point number or all real-time data bases to travel through complete; D) return to the measuring point value.
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 true CN103150408A (en) | 2013-06-12 |
| CN103150408B 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) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112148270A (en) * | 2020-08-12 | 2020-12-29 | 珠海伟诚科技股份有限公司 | Real-time computing and data interaction method, system and medium |
| CN113434519A (en) * | 2021-08-26 | 2021-09-24 | 西安热工研究院有限公司 | 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 |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112148270A (en) * | 2020-08-12 | 2020-12-29 | 珠海伟诚科技股份有限公司 | Real-time computing and data interaction method, system and medium |
| CN112148270B (en) * | 2020-08-12 | 2024-05-14 | 珠海伟诚科技股份有限公司 | Real-time computing and data interaction method, system and medium |
| CN113434519A (en) * | 2021-08-26 | 2021-09-24 | 西安热工研究院有限公司 | Method, system and storage medium for updating label names of measuring points |
| CN113434519B (en) * | 2021-08-26 | 2021-12-10 | 西安热工研究院有限公司 | Method, system and storage medium for updating label names of measuring points |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103150408B (en) | 2016-08-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105589874B (en) | Detection method, device and the ETL tool of ETL task dependence | |
| CN103345469B (en) | The storage of set of numbers, querying method and device thereof | |
| CN104765731B (en) | Database inquiry optimization method and apparatus | |
| CN109254969A (en) | Tables of data processing method, device, equipment and storage medium | |
| CN104182484B (en) | A kind of method and apparatus for realizing HBase data and the mapping of Java field object | |
| CN103853718B (en) | Fragment data storehouse access method and Database Systems | |
| WO2019161645A1 (en) | Shell-based data table extraction method, terminal, device, and storage medium | |
| CN105183915B (en) | Reduce the multi version management method of index maintenance expense | |
| CN103136107A (en) | Variable debugging method of embedded program dynamic storage allocation | |
| CN104239377A (en) | Platform-crossing data retrieval method and device | |
| CN103778133A (en) | Database object changing method and device | |
| CN110175163A (en) | More library separation methods, system and medium based on business function intelligently parsing | |
| CN108595664A (en) | A kind of agricultural data monitoring method under hadoop environment | |
| CN106294128B (en) | A kind of automated testing method and device exporting report data | |
| CN103336828B (en) | Real-time data base is read and wiring method | |
| CN108241676A (en) | Realize the method and apparatus that data synchronize | |
| CN110175206A (en) | Intellectual analysis operational approach, system and medium for multiple database separation | |
| CN104166627B (en) | A kind of SCM Based NAND FLASH write operation methods | |
| CN103235757B (en) | Several apparatus and method that input domain tested object is tested are made based on robotization | |
| CN107609011A (en) | The maintaining method and device of a kind of data-base recording | |
| CN110019644A (en) | Searching method, device and computer readable storage medium in dialogue realization | |
| CN103150408A (en) | System and method for finding and accessing database in real-time databases according to roll call | |
| CN108427675A (en) | Build the method and apparatus of index | |
| CN105243020B (en) | A kind of automated testing method suitable for wide-area distribution type real-time data base | |
| CN103309888A (en) | Method and device for verifying data of electronic map |
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 |
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. |
|
| CP01 | Change in the name or title of a patent holder | ||
| 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 |