CN102708110A - Data access method based on quasi-real time data platform - Google Patents
Data access method based on quasi-real time data platform Download PDFInfo
- Publication number
- CN102708110A CN102708110A CN2012100113636A CN201210011363A CN102708110A CN 102708110 A CN102708110 A CN 102708110A CN 2012100113636 A CN2012100113636 A CN 2012100113636A CN 201210011363 A CN201210011363 A CN 201210011363A CN 102708110 A CN102708110 A CN 102708110A
- Authority
- CN
- China
- Prior art keywords
- data
- interface
- real time
- request
- data platform
- 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.)
- Pending
Links
Images
Abstract
The invention discloses a data access method based on a quasi-real time data platform. The data access method based on the quasi-real time data platform comprises a query process and a subscription process, wherein the query process comprises the steps of providing a synchronous request, providing an answer mode or the synchronous request and providing the answer mode sequentially; and the subscription process comprises the following steps of: the quasi-real time data platform provides a subscription request interface, a user realizes data subscription by calling the subscription request interface and provides a delivery interface; and data according with the subscription conditions exists, the quasi-real time data platform calls the delivery interface to push the data to the user. According to the method, data sharing access is provided in a unified and standard mode, and various technological disparity in using links of system communication, storage, identification, expression, technical infrastructure and other real-time information are shielded.
Description
Technical field
The present invention relates to a kind of real-time data processing method, relate in particular to a kind of based on the data access method of platform quasi real time.
Background technology
Continuous development along with power informatization; The construction of intelligent grid pilot is progressively carried out; Produced a large amount of, quasi real time data closely-related in real time, precipitated into the historical data of magnanimity then, produced the data that real time datas such as the large regional grid method of operation, critical point electric weight, protection, thunder and lightning have formed magnanimity together with scheduling with the company production run; These data all are the treasures of company, are the bases of realizing the lean management.Simultaneously; Along with intelligent grid further develops; Deepening constantly of novel service application, units at different levels and each business department to magnanimity quasi real time the centralized stores and the visit of data have higher requirement, therefore; Under such background, power grid enterprises have proposed the quasi real time platform construction of enterprise-level magnanimity.
Quasi real time the data platform mode that adopts real-time data base and relational database and file to combine realizes the storage of data, and database access technology research will be divided into that the relational database access technique is studied and the real-time data base access technique is studied.The relational database product of main flow is all supported general-purpose accessing interface and private access interface at present, and the conventional data access interface comprises ODBC, DAO and OLEDB and ADO.Quasi real time data platform is as the enterprise real-time data center, provide operation of power networks, monitoring of equipment, electricity consumption metering, environmental information etc. in real time, the inquiry and the statistics access function of historical data.Quasi real time data platform provides data access service, for enterprise-level analytical applications and overview display provide real time data.Quasi real time the data platform data access is followed the business data exchange specification, and supporting provides data access service through enterprises service/data bus.
Quasi real time each operation system real time data of data platform integrating enterprise forms the data that make things convenient for the service application visit through integration, classification.Quasi real time data platform provides the data owner of visit will be divided into like more than 1 types of following tables:
Table 1
Requirements for access for above-mentioned real time data mainly comprises the following aspects:
1) the real time data model view of following the ECIM of Guangdong Power Grid company standard and IEC61970/61968 standard is provided
2) support is based on the data access of enterprises service/data bus
3) support multiple access mode
4) support real-time, historical data section inquiry
5) support the inquiry of historical data sequence
6) support the inquiry of historical data statistic analysis result
But lack a kind of quasi real time active data access method of data platform that is exclusively used at present.
Summary of the invention
The object of the present invention is to provide a kind of based on the data access method of data platform quasi real time; This method provides the share and access of data through the mode of unified standard, has shielded real-time information such as system communication, storage, sign, expression, Technical Architecture and has used the various technological disparities in the link.
The object of the invention can be realized through following technical measures:
A kind of based on the data access method of data platform quasi real time, comprise query script and subscription procedure;
Said query script is synchronization request-answer-mode or asynchronous request-answer-mode;
Wherein, Said synchronization request-answer-mode is: quasi real time data platform provides the request-reply interface; The user is quasi real time waited for return results behind the data platform through the request of sending of request-reply interface, and quasi real time data platform is carried out request and the result is returned to service requester through the request-reply interface;
Said asynchronous request-answer-mode is: asynchronous request interface and interface as a result are provided, and the user sends the request back then other tasks of execution through asynchronous request interface, and quasi real time data platform is carried out request and the result is returned to the user through interface as a result;
Said subscription procedure is: quasi real time data platform provides the subscribe request interface, and the user realizes the data subscription through calling the subscribe request interface, and the payment interface is provided; When quasi real time data platform has the data of satisfied subscription condition, call the payment interface and give the user data push.
Described request is replied the interface real time data platform that is as the criterion UAPI is provided data access interface.
Said UAPI data access interface is supported data query, data write and measuring point is managed, user management.
The present invention contrasts prior art, and following advantage is arranged: invent the share and access that data are provided through inquiry and subscribing manner, shielded real-time information such as system communication, storage, sign, expression, Technical Architecture and used the various technological disparities in the link.
Description of drawings
Fig. 1 is that the module of the inventive method is formed structural representation;
Fig. 2 is the process flow diagram that the data query process adopts the synchronization request answer-mode in the inventive method;
Fig. 3 is the process flow diagram that the data query process adopts the asynchronous request response pattern in the inventive method;
Fig. 4 is a subscription procedure process flow diagram in the inventive method.
Embodiment
Fig. 1 shows the module based on the data access method of data platform quasi real time of the present invention and forms synoptic diagram, comprises enquiry module and subscribing module, and wherein, the query script of enquiry module can adopt synchronization request-answer-mode or asynchronous request-answer-mode; Data query side is the user of data, services, and quasi real time data platform is a service providers.
Wherein, As shown in Figure 2; Synchronization request-answer-mode is: quasi real time data platform provides the request-reply interface; The user is quasi real time waited for return results behind the data platform through the request of sending of request-reply interface, and quasi real time data platform is carried out request and the result is returned to service requester through the request-reply interface.
Interface is described: the ISP provides synchronization request to reply interface.
Invoked procedure: service user's invoke synchronous request-reply interface, the ISP carries out services request and returns Query Result.
As shown in Figure 3; Asynchronous request-answer-mode is: asynchronous request interface and interface as a result are provided; The user sends request back then other tasks of execution through asynchronous request interface, and quasi real time data platform is carried out request and the result is returned to the user through interface as a result.
Interface is described: the ISP provides asynchronous request interface, and the service user provides interface as a result.
Invoked procedure: the service user calls asynchronous request interface, submits data query and interface as a result to, and the ISP carries out services request and returns Query Result.
Quasi real time data platform provides UAPI data access interface, has shielded the concrete realization details and the difference of underlying database, and unified access interface externally is provided, and has realized the transparency and distributed access.Through the UAPI interface, not only can carry out visit, and can pass through the apparatus information acquiring measurement information based on the measuring point mode.
The UAPI interface is the general-purpose accessing interface of quasi real time data platform, supports data query, data write and measuring point management, user management etc.Not only can realize the queried access of big data quantity can also realizing the real-time data access that frequency is higher through UAPI.
Be that example is introduced with " electric power supply " with the reciprocal process of platform quasi real time below.
Electric power supply need obtain the load maximal value in the operation of power networks historical time section in the data platform quasi real time, carries out overview display through visualization technique.Reciprocal process comprises:
1. connect
Call SCSG_Connect, set up the agency and be connected with communication between the server.
If(SCSG_Connect(”192.168.80.1”，7001，”admin”，”******”，0，1，1000，5000)＝＝0)
// successful connection;
Else
// connection failure.
2. obtain the historical series data
Call SCSG_GetArchivedValues, obtain the historical series data.
TAGVAL*pTagVals；
SCSG_INT32count；
If(SCSG_GetArchivedValues(100001，20111115090000，20111115100000，&pTagValues，&count)＝＝0)
// obtain success;
Else
// failure.
Delete[]pTagVals；
3. call the statistical study function
Call SCSG_GetSummary, obtain maximum value data in the historical time section.
SCSG_FLOAT32?fRetVals；
If(SCSG_GetSummary(100001，20111115090000，20111115100000，3，&fRetVals)＝＝0)
// obtain success;
Else
// failure.
4. break off and connecting
Call SCSG_Disconnect, break off server and connect.
SCSG_Disconnect()；
Subscription refer to data platform quasi real time to service subscription side the data by the frequency of agreement, mode, place, transmission agreement.As shown in Figure 4, subscription procedure is: quasi real time data platform provides the subscribe request interface, and the user realizes the data subscription through calling the subscribe request interface, and the payment interface is provided; When quasi real time data platform has the data of satisfied subscription condition, call the payment interface and give the user data push.
Interface is described: the ISP provides the subscribe request interface to supply the user to call, and the service user provides and pays interface confession ISP propelling data.
Invoked procedure: the service user realizes the data subscription through the subscribe request interface that calls the ISP, and the payment interface is provided; The ISP calls the service user and pays the propelling movement that interface is realized data when satisfying the subscription condition data.
Through the integrated SOA of the enterprise framework standard that meets of Web Service, quasi real time data platform is as the provider of service, and platform application realizes data subscription access services as the access side of service through ESB.
The step that realizes subscription service is following:
1) when carrying out initial designs, mainly considers between the different application demand of message and data transfer between system's disparate modules; 2) according to real needs corresponding interface is set, describes interface features; 3) to the platform selecting relevant Web Service assembly of different application, carry out relative set; 4) interface of realization different application carries out corresponding debugging; 5) actual motion is worked in coordination with debugging between application program.
Is example with the same trade to the mark application scenarios: application need obtains quasi real time average power off time of user and statisticss such as personal severe injury and above accident number of times in the data platform, carries out overview display through visualization technique.Reciprocal process comprises:
1. the same trade is written as the xml file layout to the mark scene with the data of needs, and is as follows:
2. call the getStatsData service interface, RequestStatsData is for going into ginseng;
3. server returns Query Result, and Query Result is the xml form, and is as follows:
Compare with inquiry mode, subscribing manner has reduced the frequently operation of inquiry of application end, lowers because of the influence of frequent query manipulation to the network bandwidth, and owing to data variation and incident meeting proactive notification, compares inquiry service and have higher real-time.But, increased service end work of treatment amount because subscription service has increased operations such as monitoring and the active push of service end data variation, incident.Therefore, two mutual coordinated operations that realize helping total system of data processing procedure.
Embodiment of the present invention is not limited thereto; Under the above-mentioned basic fundamental thought of the present invention prerequisite;, all drop within the rights protection scope of the present invention modification, replacement or the change of other various ways that content of the present invention is made according to the ordinary skill knowledge of this area and customary means.
Claims (3)
1. one kind based on the data access method of data platform quasi real time, it is characterized in that: comprise query script and subscription procedure;
Said query script is synchronization request-answer-mode or asynchronous request-answer-mode;
Wherein, Said synchronization request-answer-mode is: quasi real time data platform provides the request-reply interface; The user is quasi real time waited for return results behind the data platform through the request of sending of request-reply interface, and quasi real time data platform is carried out request and the result is returned to service requester through the request-reply interface;
Said asynchronous request-answer-mode is: asynchronous request interface and interface as a result are provided, and the user sends the request back then other tasks of execution through asynchronous request interface, and quasi real time data platform is carried out request and the result is returned to the user through interface as a result;
Said subscription procedure is: quasi real time data platform provides the subscribe request interface, and the user realizes the data subscription through calling the subscribe request interface, and the payment interface is provided; When quasi real time data platform has the data of satisfied subscription condition, call the payment interface and give the user data push.
2. according to claim 1 based on the data access method of data platform quasi real time, it is characterized in that: described request is replied the interface UAPI data access interface that the real time data platform provides that is as the criterion.
3. according to claim 1 based on the data access method of data platform quasi real time, it is characterized in that: said UAPI data access interface is supported data query, data write and measuring point management, user management.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012100113636A CN102708110A (en) | 2012-01-13 | 2012-01-13 | Data access method based on quasi-real time data platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012100113636A CN102708110A (en) | 2012-01-13 | 2012-01-13 | Data access method based on quasi-real time data platform |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102708110A true CN102708110A (en) | 2012-10-03 |
Family
ID=46900903
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012100113636A Pending CN102708110A (en) | 2012-01-13 | 2012-01-13 | Data access method based on quasi-real time data platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102708110A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110071945A (en) * | 2018-01-22 | 2019-07-30 | 中国移动通信有限公司研究院 | A kind of method for subscribing of user data, device and computer readable storage medium |
| CN111611286A (en) * | 2020-06-10 | 2020-09-01 | 北京许继电气有限公司 | Streaming data processing method for industrial Internet of things scene |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070192325A1 (en) * | 2006-02-01 | 2007-08-16 | Morris Robert P | HTTP publish/subscribe communication protocol |
| CN101621463A (en) * | 2009-07-17 | 2010-01-06 | 中国民航大学 | Flight-information data-sharing switching exchanger and processing method thereof |
| CN101964739A (en) * | 2009-07-22 | 2011-02-02 | 中国移动通信集团公司 | Data transmission method, device and system |
-
2012
- 2012-01-13 CN CN2012100113636A patent/CN102708110A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20070192325A1 (en) * | 2006-02-01 | 2007-08-16 | Morris Robert P | HTTP publish/subscribe communication protocol |
| CN101621463A (en) * | 2009-07-17 | 2010-01-06 | 中国民航大学 | Flight-information data-sharing switching exchanger and processing method thereof |
| CN101964739A (en) * | 2009-07-22 | 2011-02-02 | 中国移动通信集团公司 | Data transmission method, device and system |
Non-Patent Citations (1)
| Title |
|---|
| 陈兴渝等: "基于Web的告警实时显示系统的设计与实现", 《北京邮电大学学报》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110071945A (en) * | 2018-01-22 | 2019-07-30 | 中国移动通信有限公司研究院 | A kind of method for subscribing of user data, device and computer readable storage medium |
| CN111611286A (en) * | 2020-06-10 | 2020-09-01 | 北京许继电气有限公司 | Streaming data processing method for industrial Internet of things scene |
| CN111611286B (en) * | 2020-06-10 | 2024-03-08 | 北京许继电气有限公司 | Streaming data processing method of industrial Internet of things scene |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Feng et al. | Joint service pricing and cooperative relay communication for federated learning | |
| CN106651633A (en) | Power utilization information acquisition system and method based on big data technology | |
| CN106339829A (en) | Big data, Cloud, IoT and mobile internet technologies based active maintenance panorama monitoring system of power distribution network | |
| CN105809356A (en) | Information system resource management method based on application integrated cloud platform | |
| CN108052634A (en) | A kind of power grid production control great Qu and the integrated approach of asset management great Qu multi information systems | |
| CN103078920B (en) | A kind of message on-line testing system based on IEC61968 ESB | |
| Rathnayaka et al. | Formation of virtual community groups to manage prosumers in smart grids | |
| CN105574640A (en) | Method for constructing unified and comprehensive management platform of application | |
| CN103489139A (en) | Comprehensive analysis and management system for urban distribution network planning | |
| CN106469149A (en) | A kind of distribution automation planning and designing associated data extracts and collecting method | |
| CN105320498A (en) | Configurable multi-layer production tracking visualization method based on graphs | |
| CN102708110A (en) | Data access method based on quasi-real time data platform | |
| Dai et al. | Research hotspots and evolution of energy prosumer: A literature review and bibliometric analysis | |
| CN110827172A (en) | Wisdom water affairs cloud service platform | |
| CN209250688U (en) | A kind of agent's workflow engine equipment | |
| CN108416538A (en) | A kind of enterprise informationization management system | |
| CN208273027U (en) | A kind of Internet of Things intelligent electric meter monitoring analysis management system based on Hadoop | |
| CN103870989A (en) | Electric power resource collaborative application method and system | |
| CN113159721A (en) | Internet of things platform based on full life cycle of equipment | |
| Tang et al. | Research and application of improving the field service ability of electric power marketing measuring mobile operating based on cloud computing technology | |
| CN101673367A (en) | Comprehensive office communicating and training platform system | |
| CN107291766A (en) | Laterally specialty fusion, longitudinal province ground power network panoramic information display systems for running through of county | |
| CN105117486A (en) | Power distribution network data processing method and device | |
| Miu et al. | A Real-time Detection Framework for Abnormal Devices in the Power Internet of Things | |
| CN115619063B (en) | Community common distribution method, system, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20121003 |