CN102033871B - Method and system for sharing public resource data by multiple information systems - Google Patents
Method and system for sharing public resource data by multiple information systems Download PDFInfo
- Publication number
- CN102033871B CN102033871B CN 200910092985 CN200910092985A CN102033871B CN 102033871 B CN102033871 B CN 102033871B CN 200910092985 CN200910092985 CN 200910092985 CN 200910092985 A CN200910092985 A CN 200910092985A CN 102033871 B CN102033871 B CN 102033871B
- Authority
- CN
- China
- Prior art keywords
- masterplate
- general polling
- management system
- resource data
- resource
- 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.)
- Active
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Computer And Data Communications (AREA)
Abstract
The invention provides a method and a system for sharing public resource data by multiple information systems. The method comprises that: a universal query template is defined, wherein the universal query template comprises a universal query template identifier, an inlet parameter and an outlet parameter; a unified resource management system stores the universal query template; and an upper application system of any information system transmits the universal query template identifier and the inlet parameter to the unified resource management system, and the unified resource management system calls the universal query template to query public resource data and feeds back the public resource data according to the outlet parameter. The invention can guarantee that the upper application system of the information system simply, reliably and efficiently share the public resource data.
Description
Technical field
The present invention relates to database technical field, particularly a plurality of infosystems are shared the method and system of public resource data.
Background technology
For the supporting business development, the infosystem that every profession and trade is set up is more and more, and the demand that a plurality of infosystems need to be shared the public resource data is also more and more general.For satisfying this demand, usually set up the unified resource management system, by its unified public resource data of safeguarding, share for a plurality of infosystems.
Yet different resource datas is not uncorrelatedly to isolate existence, has complicated incidence relation between them.Generally need to adopt complex query condition, related many class resources object just can obtain the service logic desired data; Also need the resource data of a plurality of associations is upgraded synchronously, to guarantee the resource data consistance.Each infosystem respectively, during the resource data of independent maintenance oneself, the demand generally is the SQL (SQL) of the multistage complexity that provides of the data base management system (DBMS) (DBMS) by each infosystem or storing process, by the realization of affairs controlling mechanism.
At present, when a plurality of infosystems are shared the public resource data, usually adopt following method:
Each infosystem is not safeguarded the public resource data trnascription, but the resource sharing interface that provides of real-time calling unified resource management system when needed, obtains or upgrades the public resource data, realizes sharing of public resource data.Referring to Fig. 1, Fig. 1 is the operator scheme synoptic diagram that existing a plurality of infosystem is shared the public resource data, comprising:
In the development phase of infosystem upper layer application, development and Design personnel are analyzing business demand and are understanding under the prerequisite of resource model (being public resource data storage logical view), and coding is realized the operation logic to the public resource data.
In the operation phase of infosystem upper layer application, inquire about or renewal public resource data by the resource sharing interface that the unified resource management system provides.Because the resource sharing interface that provides of present unified resource management system is just for the single kind resource data, therefore, when needs inquiry multiclass resource data, the upper layer application of infosystem need to repeatedly be called the resource sharing interface and (obtain intermediate result according to initial query condition calling interface, analyze intermediate result and form next querying condition and calling interface again, the rest may be inferred, obtains final Query Result through calling interface repeatedly); When needs upgraded resource data, the infosystem upper layer application need to adopt similar process repeatedly to call the resource sharing interface equally, and controls voluntarily submission or the rollback of affairs.
Can be found out that by the aforesaid operations pattern owing to need repeatedly to call in real time the resource sharing interface, there is following defective in the method that existing a plurality of infosystems are shared the public resource data:
The mechanism such as the storing process that 1, DBMS can finish under the traditional mode, affairs control all need to be realized voluntarily by the upper layer application system of each infosystem, not only performance and the stability of system have been brought adverse effect, and greatly increased the complicacy of the upper layer application system logic of infosystem, cause the unified resource management system to be difficult to the performance practical function.
2, the data volume that exchanges between infosystem, unified resource management system and the database is excessive, affects the System and Network performance.
3, the control of the affairs of the upper layer application system of infosystem can't really guarantee atomicity, and before submission or rollback, other infosystems may have access to inconsistent resource data, cause logical miss.
Summary of the invention
The present invention proposes the method and system that a kind of a plurality of infosystem is shared the public resource data, can take full advantage of the technical advantage of DBMS, and the upper layer application system of guarantee information system shares the public resource data simply, reliably, efficiently.
Technical scheme of the present invention is achieved in that
A kind of a plurality of infosystem is shared the method for public resource data, comprising:
Definition general polling masterplate, described general polling masterplate comprises: the relation between the title of the resource object that comprises in general polling masterplate sign, suction parameter and outlet parameter, the public resource data, attribute and each resource object;
The described general polling masterplate of unified resource management system storage; The mode of described unified resource management system storage general polling masterplate is: adopt the expandable mark language XML form to store; Described unified resource management system further is translated as SQL statement or storing process with described general polling masterplate;
The upper layer application system of infosystem is sent to the unified resource management system with sign and the suction parameter of described general polling masterplate arbitrarily, the described general polling masterplate of unified resource management system call, according to the described public resource data of relational query between title, attribute and each resource object of described resource object, according to described outlet parameter feedback public resource data;
The mode of the described general polling masterplate of described unified resource management system call is:
Described general polling masterplate corresponding SQL statement or storing process are located according to the sign of general polling masterplate by described unified resource management system; The suction parameter of general polling masterplate is passed to described SQL statement or storing process, calls described general polling masterplate.
A kind of a plurality of infosystem is shared the system of public resource data, comprising:
The unified resource management system, be used for storage general polling masterplate, described general polling masterplate comprises: the relation between the title of the resource object that comprises in general polling masterplate sign, suction parameter, outlet parameter and the public resource data, attribute and each resource object; The mode of described storage general polling masterplate is: adopt the expandable mark language XML form to store; Also be used for described general polling masterplate is translated as SQL statement or storing process; The sign and the suction parameter that also are used for the general polling masterplate that the upper layer application system according to infosystem sends are called described general polling masterplate, according to the described public resource data of relational query between title, attribute and each resource object of described resource object, according to the upper layer application system feedback public resource data of described outlet parameter to infosystem; The described mode of calling described general polling masterplate is: described general polling masterplate corresponding SQL statement or storing process are located according to the sign of general polling masterplate by described unified resource management system; The suction parameter of general polling masterplate is passed to described SQL statement or storing process, calls described general polling masterplate;
The upper layer application system of infosystem is used for to sign and the suction parameter of unified resource management system transmission general polling masterplate.
As fully visible, a plurality of infosystems that the present invention proposes are shared the method and system of public resource data, at the definition of the development phase of infosystem upper layer application system and preservation general polling masterplate (UQT, Universal Query Template); In the operation phase, the upper layer application system of infosystem is sent to the unified resource management system with sign and the suction parameter of UQT, and the unified resource management system carries out this UQT in DBMS; According to the outlet parameter of UQT, from the result that implementation obtains, select information needed, and feed back to the upper layer application system of infosystem.In this way, overcome the defective that the upper layer application system of infosystem is repeatedly inquired about, can take full advantage of the mechanism such as the storing process of DBMS and affairs control, the upper layer application system of guarantee information system shares the public resource data simply, reliably, efficiently.
Description of drawings
Fig. 1 is the operator scheme synoptic diagram that existing a plurality of infosystem is shared the public resource data;
Fig. 2 is the method flow diagram that a plurality of infosystems of embodiment of the present invention are shared the public resource data;
Fig. 3 is embodiment of the present invention UQT implementation process flow diagram;
Fig. 4 is the operator scheme synoptic diagram that a plurality of infosystems of embodiment of the present invention are shared the public resource data.
Embodiment
The present invention proposes the method that a kind of a plurality of infosystem is shared the public resource data, by definition general polling masterplate (UQT, Universal Query Template), public resource data manipulation conditional definition is separated with public resource data manipulation execution, realize a plurality of infosystems effectively sharing the public resource data.
Referring to Fig. 2, Fig. 2 is the method flow diagram that a plurality of infosystems of embodiment of the present invention are shared the public resource data, comprising:
Step 201:UQT definition.Development and Design personnel are analyzing business demand and are understanding under the prerequisite of resource model (being public resource data storage logical view), with resource model abstract be resource object, attribute and relation.Wherein, resource object and attribute can be regarded as Virtual table and field thereof, and relation can be regarded as the relation by multi-to-multi between the resource object of relation table record.
The UQT of definition comprises three partial contents:
(1) relation between the attribute of the title of resource object, resource object and each resource object.Resource object, the community set that meets certain relation defined the either large or small simple or complicated subset in the whole resource model.
For example, define a UQT, it is designated UQT1.Among the UQT1, server and switch are respectively the titles of 2 resource objects.
Wherein, the server resource attribute comprises: title, IP address, physical location, port numbers etc.; The switch resource attribute comprises: title, IP address, physical location, port numbers, responsible official etc.
The pass of server resource object and switch resource object is: the network connection relation.
(2) suction parameter.Define the suction parameter which attribute can be used as UQT1.
For example, for the UQT1 of above-mentioned definition, with the physical location attribute of the server resource object suction parameter as UQT1.
(3) outlet parameter.Define the suction parameter which attribute can be used as UQT1.
For example, for the UQT1 of above-mentioned definition, with the title of switch resource object, port numbers, the responsible official outlet parameter as UQT1.
Step 202:UQT storage.
The UQT of definition in the step 201 is stored in the unified resource management system, generally can adopts extend markup language (XML) form to store.Simultaneously, the unified resource management system is translated as UQT SQL statement or storing process automatically.
Above-mentioned steps 201 and step 202 are all finished in the upper layer application system development stage of infosystem, can test the UQT that defines at any time, to determine whether operating result meets expection.
Step 203:UQT carries out.In the upper layer application system operation phase of infosystem, during the upper layer application system call UQT of infosystem, with the delivery of content of UQT sign and suction parameter to the unified resource management system; SQL statement or storing process that the unified resource management system is corresponding according to the UQT mark location, the delivery of content of suction parameter is entered, and start execution, according to the relational query public resource data between title, attribute and each resource object of the resource object that defines among this UQT; Select information needed according to the outlet parameter that defines among the UQT in the intermediate result that obtains in the process of implementation and the net result, return to the upper layer application system of infosystem, finish the execution of UQT.
Below the UQT1 of definition in the above-mentioned steps 201 as example, introduce in detail the UQT implementation, referring to Fig. 3, Fig. 3 is embodiment of the present invention UQT implementation process flow diagram, comprising:
Step 301: when infosystem need to be inquired about the association attributes of switch when (comprising title, port numbers, responsible official) that has network connection relation with the server that is positioned at No. 101 machine rooms, the upper layer application system of infosystem passes to the unified resource management system by the resource sharing interface with the content (being the physical location attribute=101 machine rooms of server resource object) that UQT identifies (being UQT1) and suction parameter.
Step 302: the unified resource management system is according to UQT sign (being UQT1), corresponding SQL statement or the storing process of location UQT1, the content of suction parameter (being the physical location attribute=101 machine rooms of server resource object) is transmitted, and UQT1 is carried out in startup, according to the relation between title, attribute and each resource object of the resource object that defines among the UQT1, inquire all properties (comprising IP address, physical location, port numbers, responsible official) that has the switch of network connection relation with the server of No. 101 machine rooms.
Step 303: the unified resource management system is according to the outlet parameter (being title, port numbers, the responsible official of switch resource object) of UQT1, from the Query Result of step 302, pick out title, port numbers and the responsible official of all satisfactory switches, and the information of picking out is returned to the upper layer application system of infosystem.
Can be found out by above-mentioned UQT implementation, it is to carry out in the upper layer application system operation phase of infosystem that UQT carries out, the database of operation phase complexity is mutual to be handled and gives database itself by the unified resource management system and carry out, and has guaranteed that UQT carries out efficient and effective session control.
In addition, being shared the method for public resource data can find out by a plurality of infosystems shown in Figure 2, the present invention is under the prerequisite of understanding public resource data resource model (being public resource data storage logical view), according to the business demand definition UQT of each infosystem when reality is used.For example, when the server of finding a certain physical location broke down, infosystem need to be inquired about title, port numbers and the responsible official who has the switch of network connection relation with this server usually, in order to carry out respective handling; According to this business demand, the system development designer defines above-mentioned UQT1 in conjunction with public resource data storage logic.In the upper layer application system operation phase of infosystem, directly input the physical location attribute of UQT1 and server resource object, just can inquire required relevant information.Those skilled in the art are readily appreciated that, the UQT1 of above-mentioned definition only is an embodiment, in the development phase of infosystem upper layer application system, development and Design personnel can also define according to other business demand other UQT, and use this UQT to carry out data manipulation in the operation phase of infosystem upper layer application system; Definition and manner of execution are identical with UQT1, differ one for example at this.
The method of sharing the public resource data by above-mentioned a plurality of infosystems as seen, the present invention has realized separating of data manipulation conditional definition and data manipulation action executing, can reach a plurality of infosystems effectively sharing the public resource data.And, the upper layer application system of infosystem only need call first resource and share interface, overcome the defective that the upper layer application system is repeatedly inquired about, can take full advantage of storing process and the affairs controlling mechanism of existing DBMS, the upper layer application system of guarantee information system handles the public resource data simply, reliably, efficiently.
Referring to Fig. 4, Fig. 4 is the operator scheme synoptic diagram that a plurality of infosystems of embodiment of the present invention are shared the public resource data, is mainly reflected in following several aspect with the difference of traditional approach:
The data manipulation conditional definition separates with the data manipulation action executing.The upper layer application system developer of infosystem understands after resource model (data storage logic view) and the business demand, it or not direct coding, but according to the business demand of infosystem, at first in the unified resource management system, decide general polling masterplate (UQT), comprise complicated incidence relation, suction parameter and outlet parameter between the multiclass resource object.The unified resource management system can unify to store the UQT of definition; Then, in the upper layer application system operation phase of infosystem, upper layer application system coding is realized calling UQT.
The lifting of development efficiency.Because complex conditions inquiry, the control of renewal affairs all realize by UQT, upper layer application developer only need call UQT, need not understand data storage details, therefore developing complicacy reduces greatly, development efficiency gets a promotion, and this becomes relatively more real so that the public resource data are shared by the upper layer application system of a plurality of infosystems.
Carry out the lifting of efficient.Parameter call UQT provides access when the upper layer application system of infosystem moves, the unified resource management system is converted to complicated SQL or storing process to UQT, in DBMS, move, intermediate result is not transmitted between the upper layer application system of DBMS, unified resource management system and infosystem, also can directly utilize the Optimization Mechanism of DBMS, execution efficient and system performance are all got a promotion.
Embodiment of the present invention also proposes the system that a kind of a plurality of infosystem is shared the public resource data, comprising:
The unified resource management system is used for storage general polling masterplate, and described general polling masterplate comprises: general polling masterplate sign, suction parameter and outlet parameter; The sign and the suction parameter that also are used for the general polling masterplate that the upper layer application system according to infosystem sends are called described general polling masterplate inquiry public resource data, according to the upper layer application system feedback public resource data of described outlet parameter to infosystem;
The upper layer application system of infosystem is used for to sign and the suction parameter of unified resource management system transmission general polling masterplate.
Above-mentioned general polling masterplate can also comprise: the relation between the title of the resource object that comprises in the public resource data, attribute and each resource object.
The above only is preferred embodiments of the present invention, and is in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of making, is equal to replacement, improvement etc., all should be included within the scope of protection of the invention.
Claims (5)
1. a plurality of infosystems are shared the method for public resource data, it is characterized in that described method comprises:
Definition general polling masterplate, described general polling masterplate comprises: the relation between the title of the resource object that comprises in general polling masterplate sign, suction parameter, outlet parameter, the public resource data, attribute and each resource object;
The described general polling masterplate of unified resource management system storage; The mode of described unified resource management system storage general polling masterplate is: adopt the expandable mark language XML form to store; Described unified resource management system further is translated as SQL statement or storing process with described general polling masterplate;
The upper layer application system of infosystem is sent to the unified resource management system with sign and the suction parameter of described general polling masterplate arbitrarily, the described general polling masterplate of unified resource management system call, according to the described public resource data of relational query between title, attribute and each resource object of described resource object, according to described outlet parameter feedback public resource data;
The mode of the described general polling masterplate of described unified resource management system call is:
Described general polling masterplate corresponding SQL statement or storing process are located according to the sign of general polling masterplate by described unified resource management system; The suction parameter of general polling masterplate is passed to described SQL statement or storing process, calls described general polling masterplate.
2. method according to claim 1 is characterized in that, the mode of described definition general polling masterplate is: define according to the business demand of described a plurality of infosystems and the resource model of described public resource data.
3. method according to claim 1, it is characterized in that the upper layer application system of described infosystem with the mode that sign and the suction parameter of general polling masterplate is sent to the unified resource management system is: the upper layer application system of infosystem sends by the resource sharing interface that described unified resource management system provides.
4. method according to claim 1 is characterized in that, described unified resource management system according to the mode of described outlet parameter feedback public resource data is:
According to described outlet parameter, from the described public resource data that inquire, pick out and meet the public resource data that outlet parameter requires, with the upper layer application system of the described public resource data feedback of picking out to described infosystem.
5. a plurality of infosystems are shared the system of public resource data, it is characterized in that described system comprises:
The unified resource management system, be used for storage general polling masterplate, described general polling masterplate comprises: the relation between the title of the resource object that comprises in general polling masterplate sign, suction parameter, outlet parameter, the public resource data, attribute and each resource object; The mode of described storage general polling masterplate is: adopt the expandable mark language XML form to store; Also be used for described general polling masterplate is translated as SQL statement or storing process; The sign and the suction parameter that also are used for the general polling masterplate that the upper layer application system according to infosystem sends are called described general polling masterplate, according to the described public resource data of relational query between title, attribute and each resource object of described resource object, according to the upper layer application system feedback public resource data of described outlet parameter to infosystem; The described mode of calling described general polling masterplate is: described general polling masterplate corresponding SQL statement or storing process are located according to the sign of general polling masterplate by described unified resource management system; The suction parameter of general polling masterplate is passed to described SQL statement or storing process, calls described general polling masterplate;
The upper layer application system of infosystem is used for to sign and the suction parameter of unified resource management system transmission general polling masterplate.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910092985 CN102033871B (en) | 2009-09-25 | 2009-09-25 | Method and system for sharing public resource data by multiple information systems |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200910092985 CN102033871B (en) | 2009-09-25 | 2009-09-25 | Method and system for sharing public resource data by multiple information systems |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102033871A CN102033871A (en) | 2011-04-27 |
| CN102033871B true CN102033871B (en) | 2013-01-02 |
Family
ID=43886785
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200910092985 Active CN102033871B (en) | 2009-09-25 | 2009-09-25 | Method and system for sharing public resource data by multiple information systems |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102033871B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106657683A (en) * | 2016-11-04 | 2017-05-10 | 上海携程商务有限公司 | Unified management method and system for more communication systems |
| CN113515603A (en) * | 2021-04-27 | 2021-10-19 | 深圳力维智联技术有限公司 | Method, system and equipment for processing operation and maintenance monitoring data of machine room |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6327629B1 (en) * | 1996-05-31 | 2001-12-04 | International Business Machines Corporation | Stored procedure universal calling interface |
| CN101408899A (en) * | 2008-11-21 | 2009-04-15 | 北京中企开源信息技术有限公司 | Method and apparatus for switching website multiple data sources |
| CN101477596A (en) * | 2009-02-02 | 2009-07-08 | 中国网络通信集团公司 | Medical data center system |
| CN101604338A (en) * | 2009-07-23 | 2009-12-16 | 杭州华三通信技术有限公司 | User-defined information query method of a kind of realization and device |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2001306371A (en) * | 2000-04-20 | 2001-11-02 | Ntt Data Corp | Data base construction system and its method |
| CN101042751A (en) * | 2007-01-18 | 2007-09-26 | 北京佳讯飞鸿电气有限责任公司 | Implementing method and system for flexible and expandable dynamic statistics |
| CN101196926A (en) * | 2007-12-29 | 2008-06-11 | 中国建设银行股份有限公司 | Database access platform and access method thereof |
| CN101256650B (en) * | 2008-03-21 | 2012-02-15 | 中国科学院软件研究所 | Method and system for extracting enterprise data based on service entity |
-
2009
- 2009-09-25 CN CN 200910092985 patent/CN102033871B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6327629B1 (en) * | 1996-05-31 | 2001-12-04 | International Business Machines Corporation | Stored procedure universal calling interface |
| CN101408899A (en) * | 2008-11-21 | 2009-04-15 | 北京中企开源信息技术有限公司 | Method and apparatus for switching website multiple data sources |
| CN101477596A (en) * | 2009-02-02 | 2009-07-08 | 中国网络通信集团公司 | Medical data center system |
| CN101604338A (en) * | 2009-07-23 | 2009-12-16 | 杭州华三通信技术有限公司 | User-defined information query method of a kind of realization and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102033871A (en) | 2011-04-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103377289B (en) | Unified table query processing | |
| CN103377148B (en) | The method and system that executable portion merges in a kind of unified dial framework structure | |
| US7096231B2 (en) | Export engine which builds relational database directly from object model | |
| CN109670089A (en) | Knowledge mapping system and its figure server | |
| CN109087004B (en) | Public workflow engine system based on domain model | |
| US7596550B2 (en) | System and method for query planning and execution | |
| CN109144994A (en) | Index updating method, system and relevant apparatus | |
| US5987452A (en) | Query translation system | |
| CN102255752A (en) | Configuration management system and method of server cluster | |
| WO2020135613A1 (en) | Data query processing method, device and system, and computer-readable storage medium | |
| US20110010379A1 (en) | Database system with query interception and redirection | |
| CN1959676B (en) | Apparatus and method for materialized query table journaling in a computer database system | |
| WO2016123921A1 (en) | Http protocol-based multiple data resource data processing method and system | |
| US6748393B1 (en) | Transparent updates to partitioned views in a federated database system | |
| CN102033912A (en) | Distributed-type database access method and system | |
| CN106462575A (en) | Design and implementation of clustered in-memory database | |
| CA2627270A1 (en) | System and method for displaying data on a thin client | |
| CA2493269A1 (en) | Method and system of unifying data | |
| CN109241054A (en) | A kind of multimodal data library system, implementation method and server | |
| CN110019314B (en) | Dynamic data packaging method based on data item analysis, client and server | |
| US20130055235A1 (en) | Custom code innovation management | |
| CN104111958A (en) | Data query method and device | |
| US11893026B2 (en) | Advanced multiprovider optimization | |
| US7640238B2 (en) | Query planning for execution using conditional operators | |
| CN103336782A (en) | Relational distributed database 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 |