CN104200402A - Publishing method and system of source data of multiple data sources in power grid - Google Patents
Publishing method and system of source data of multiple data sources in power grid Download PDFInfo
- Publication number
- CN104200402A CN104200402A CN201410461245.4A CN201410461245A CN104200402A CN 104200402 A CN104200402 A CN 104200402A CN 201410461245 A CN201410461245 A CN 201410461245A CN 104200402 A CN104200402 A CN 104200402A
- Authority
- CN
- China
- Prior art keywords
- data
- source
- metadata schema
- model
- electrical network
- 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
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a publishing method and system of source data of multiple data sources in a power grid. The publishing method includes acquiring the source data of the multiple data sources in the power grid, respectively; processing the source data according to a same data processing rule, and saving the processed source data in a preset relational database; on the basis of the relational database, establishing metadata models of the source data, and corresponding report templates in the metadata models to mapping relations of object data in the relational database; publishing the metadata models in a preset report server, so that users can log in the report server and gain access to the data of the metadata models.
Description
Technical field
The present invention relates to data interaction technical field, particularly source data dissemination method and the system of the multiple data sources of a kind of electrical network.
Background technology
Along with developing rapidly of national economy, the scale of electrical network becomes increasing.In electrical network, set up the basic service system taking energy management system EMS (Energy Management System), scheduling information management system DMIS (Dispatching Management Information System), electricity market operational system etc. as representative.In order to meet concrete need of work, each department of electric system also need to be on the basis of above basic service system, set up comparatively senior application system for particular demands, as visual monitor system, Analog Simulation System, data analysis system, reporting system, data digging system etc.The required data of these advanced application system, are derived from multiple basic service systems conventionally.
Operation of power networks basic data in basic business system mainly comprises the parts such as model, parameter, metric data, each basic service system all can be set up independently model parameter storehouse and independently safeguard separately, the parameter of different business systems is with the document form storage dissimilar, different coding is regular, and the data source of each basic service system does not have consistance.
Therefore, data layout disunity between the data source that multiple basic service systems provide separately, in the process of setting up advanced application system, user visits the source data of multiple data sources conventionally by the data-driven program of configuration disparate databases type, and the obvious occupying system resources of data-driven program of these separate configurations increases system burden.
Summary of the invention
Source data dissemination method and the system of the multiple data sources of a kind of electrical network provided by the invention, need to be by the scheme of data in data-driven routine access data source in order to solve user in prior art, occupying system resources, the technical matters of increase system burden.
The source data dissemination method that the invention provides the multiple data sources of a kind of electrical network, comprising:
Obtain respectively the source data of multiple data sources in described electrical network;
Each described source data is operated according to same data processing rule respectively, and the source data after operation is all stored in default relevant database;
According to described relevant database, set up the metadata schema of each described source data, the mapping relations in the reports model in described metadata schema and described relevant database between each object data are corresponding;
Described metadata schema is distributed to respectively in default report server, so that obtain user's login to described report server, the data in described metadata schema is conducted interviews.
Said method, preferred, the described relevant database of described foundation, sets up the metadata schema of each described source data, comprising:
Create data source by default framework instrument and connect guide, utilize described data source to connect guide and be connected to respectively the each described data source in described relevant database;
According to the user's operational order receiving, in described relevant database, choose the database object corresponding with described user's operational order as physical model, between the each object data in described physical model, there are mapping relations;
According to the mapping relations between each object data in described physical model, generate the reports model of described physical model, described physical model is described metadata schema, and each described metadata schema is corresponding with the use object of an electric system in described electrical network.
Said method, preferred, described obtain respectively described electrical network in before the source data of multiple data sources, described method also comprises:
Create the data-interface corresponding with each described data source;
Accordingly, the described source data of obtaining respectively multiple data sources in described electrical network, comprising:
Obtain respectively the source data of each described data source in described electrical network by corresponding data interface;
According to the source data of the default each described data source of Unified coding rule identification.
Said method, preferred, described metadata schema is form-public information COGNOS-CIM model, described report server is COGNOS server.
Said method, preferred, described method also comprises:
Described metadata schema is set up to data directory, form data directory object, in described metadata schema, search and locate the data object in described relevant database so that obtain user by described data directory object.
The present invention also provides the source data delivery system of the multiple data sources of a kind of electrical network, comprising:
Source data acquiring unit, for obtaining respectively the source data of the multiple data sources of described electrical network;
Data storage cell, for each described source data is operated according to same data processing rule respectively, and is all stored to the source data after operation in default relevant database;
Model is set up unit, for according to described relevant database, sets up the metadata schema of each described source data, and the mapping relations in the report data in described metadata schema and described relevant database between each object data are corresponding;
Model publish unit, for described metadata schema being distributed to respectively to default report data server, conducts interviews to the data in described metadata schema so that obtain user's login to described report server.
Said system, preferred, described model is set up unit and is comprised:
Data source connexon unit, creates data source for the framework instrument by default and connects guide, utilizes described data source to connect guide and is connected to respectively the each described data source in described relevant database;
Model is chosen subelement, for the user's operational order according to receiving, in described relevant database, choose the database object corresponding with described user's operational order as physical model, between the each object data in described physical model, there are mapping relations;
Report generation subelement, for the mapping relations according between the each object data of described physical model, generate the reports model of described physical model, described physical model is described metadata schema, and each described metadata schema is corresponding with the use object of an electric system in described electrical network.
Said system, preferred, also comprise:
Interface creating unit, before obtaining source data at described source data acquiring unit, creates the data-interface corresponding with each described data source;
Accordingly, described source data acquiring unit comprises:
Interface data obtains subelement, for obtain respectively the source data of the each described data source of described electrical network by corresponding data interface;
Code identification subelement, for the source data of the each described data source of Unified coding rule identification according to default.
Said system, preferred, described metadata schema is form-public information COGNOS-CIM model, described report server is COGNOS server.
Said system, preferred, also comprise:
Unit set up in index, for described metadata schema is set up to data directory, forms data directory object, searches and locate the data object in described relevant database so that obtain user by described data directory object in described metadata schema.
From such scheme, source data dissemination method and the system of the multiple data sources of a kind of electrical network provided by the invention, by opening relationships type database, the source data of the multiple data sources in electrical network is carried out being stored in wherein after standardization processing, and set up metadata schema, determine the mapping relations between the each object data in described relevant database, data layout and Treatment Analysis flow process between unified multiple data sources, thus, metadata schema is published on report server, make the different objects that use access the data in metadata schema as different departments or with logining per family to report server, as data customized to issue etc. according to business demand, meet the different objects that use to the data access scheduling between multiple data sources of electrical network, not only avoid system resource waste that development data driver brings to increase the problem of system burden, also ensure consistance and the accuracy of different electric power parameter, reduce the collection of electrical network multi-source data, transmission, the impact on running efficiency of system and stability of the too many levels such as processing, improve the quality of operation of power networks data.
Brief description of the drawings
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only embodiments of the invention, for those of ordinary skill in the art, do not paying under the prerequisite of creative work, other accompanying drawing can also be provided according to the accompanying drawing providing.
Fig. 1 is the process flow diagram of the source data dissemination method embodiment mono-of the multiple data sources of a kind of electrical network provided by the invention;
Fig. 2 is the part process flow diagram of the source data dissemination method embodiment bis-of the multiple data sources of a kind of electrical network provided by the invention;
Fig. 3 is the process flow diagram of the source data dissemination method embodiment tri-of the multiple data sources of a kind of electrical network provided by the invention;
Fig. 4 and Fig. 5 are respectively the application example figure of the embodiment of the present invention;
Fig. 6 is the process flow diagram of the source data dissemination method embodiment tetra-of the multiple data sources of a kind of electrical network provided by the invention;
Fig. 7 is the structural representation of the source data delivery system embodiment five of the multiple data sources of a kind of electrical network provided by the invention;
Fig. 8 is the part-structure schematic diagram of the source data delivery system embodiment six of the multiple data sources of a kind of electrical network provided by the invention;
Fig. 9 is the structural representation of the source data delivery system embodiment seven of the multiple data sources of a kind of electrical network provided by the invention;
Figure 10 is the part-structure schematic diagram of the embodiment of the present invention seven;
Figure 11 is the structural representation of the source data delivery system embodiment eight of the multiple data sources of a kind of electrical network provided by the invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiment.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
With reference to figure 1, be the process flow diagram of the source data dissemination method embodiment mono-of the multiple data sources of a kind of electrical network provided by the invention, wherein, described method can comprise the following steps:
Step 101: the source data of obtaining respectively multiple data sources in described electrical network.
Wherein, described data source can be understood as the data source of the basic business system of power department in electrical network.
Step 102: each described source data is operated according to same data processing rule respectively, and the source data after operation is all stored in default relevant database.
Wherein, described relevant database is the database being based upon on relational model basis, carrys out the data in process database by means of the mathematical concepts such as algebra of sets and method.Relevant database is with the form storage data of row and column, so that user understands.A series of row and column is called as table, and one group of table has formed database.User utilizes inquiry (Query) to carry out the data in searching database, and a Query is a SELECT statement that is used to specify row and column in database.Relevant database comprises following assembly conventionally: client application (Client), database server (Server), database (Database).
In the present embodiment, can set up integrated data platform by the J2EE standard architecture based on B/S pattern (Browser/Server, Browser/Server Mode), on described integrated data platform, set up described relevant database.Wherein, B/S pattern has been unified the client that the electric network model of each department electric system splices, it is described integrated data platform, it can make to focus on the server of integrated data platform carrying out the needed systemic-function of grid model splicing core, has simplified exploitation, maintenance and the use of splicing system.User only need to install a browser (Browser), as Internet Explorer browser, can realize with integrated data platform on database carry out data interaction.And J2EE core is one group of technical manual and guide, its various components comprising, service architecture and the hierarchy of skill, all there are common standard and specification, allow and on described integrated data platform, have good compatibility between the different electric power of the various J2EE of following frameworks, solving the information products that the electric network model rear end of electric system in the past uses each other cannot compatibility or enterprises or the outside awkward situation that is difficult to intercommunication.
It should be noted that, the database itself of setting up based on described integrated data platform is the accessible data source with Types Below also, include but not limited to various relevant databases, Excel file, CSV (Comma Separated Value, comma separated value) file, the COGNOS servers such as PowerCube can identification data source, the file data source of support XML/TXT/Excel etc., by general ODBC (Open Database Connectivity, Open Database Connection) interface obtains data, system is by XML metadata schema data of description source, therefore, the reporting system of setting up based on described integrated data platform can freely access variant categorical data source data, there is extremely strong extensibility.
The present embodiment can be based on described integrated data platform, set up integrated data platform scheduling advanced application system, this system can be from described integrated data platform all data sources, comprise previously described relevant database (for example IBM DB28.x, Oracle 9i/10g, Sybase 11.x, 12.x, SQL Server2000, My SQL 4.x, Web Services), and by configuring the database of the direct access service system of JDBC Data Source and accessing by the loose coupling mode of Web Services the data file that other system obtains, application system can also be accessed and be contained XML (Extensible Markup Language, extend markup language) text of data, by SQL (Structured Query Language, Structured Query Language (SQL)) method of calling, storing process and SQL query are called as data source, utilize database store process can give full play to the performance of database, and make full use of the resource of existing business system, directly call based on IEC61970-40X interface definition series and generate all kinds of corresponding informations or the access to various unit databases, comprise Access, Excel, Foxpro etc.
It should be noted that, described data processing rule can be understood as the processing operations such as data structure restructuring, and thus, the source data in described relevant database has unified data layout and processes shrimps flow process.
Step 103: according to described relevant database, set up the metadata schema of each described source data, the mapping relations in the reports model in described metadata schema and described relevant database between each object data are corresponding.
For example, can pass through described integrated data platform, as required Physical data model is organized into the model suiting the requirements, standardization data, services, changes into physical model the data model that meets certain specification, i.e. described metadata schema.
For another example, county adjusts, adjust or data that power plant reports, each sections provide reporting parameters list and specification can see longitudinal data source as; Senior application builds on integrated data platform basis, and the standard interface that system provides by integrated data platform accesses the sharing data of each system or can be referred to as horizontal data source by the data of J2EE bus access other system.All data are carried out unified standard storage, and are sent to integrated data platform as shared data.Data source management realizes effectively management from the data of homology not, to obtain from integrated data platform the sharing data that are positioned at each security partitioning on the one hand, can and obtain private data from each system acquisition data source on the other hand, for report making provides the data help function of maximum possible.Data source management provides the metadata description of each application and system simultaneously, and the dirigibility that greatly improves data configuration ensures the relationship map between physical data and application.
Step 104: described metadata schema is distributed to respectively in default report server, so that obtain user's login to described report server, the data in described metadata schema is conducted interviews.
Concrete, user can use the login of IE (Internet Explorer) browser to described report server, the multi-source data in described metadata schema is conducted interviews, as customized according to demand issue etc.
From such scheme, the source data dissemination method embodiment mono-of the multiple data sources of a kind of electrical network provided by the invention, by opening relationships type database, the source data of the multiple data sources in electrical network is carried out being stored in wherein after standardization processing, and set up metadata schema, determine the mapping relations between the each object data in described relevant database, data layout and Treatment Analysis flow process between unified multiple data sources, thus, metadata schema is published on report server, make the different objects that use access the data in metadata schema as different departments or with logining per family to report server, as data customized to issue etc. according to business demand, meet the different objects that use to the data access scheduling between multiple data sources of electrical network, not only avoid system resource waste that development data driver brings to increase the problem of system burden, also ensure consistance and the accuracy of different electric power parameter, reduce the collection of electrical network multi-source data, transmission, the impact on running efficiency of system and stability of the too many levels such as processing, improve the quality of operation of power networks data.
With reference to figure 2, be the process flow diagram of step 103 described in the source data dissemination method embodiment bis-of the multiple data sources of a kind of electrical network provided by the invention, wherein, described step 103 can comprise the following steps:
Step 131: create data source by default framework (Framework) instrument and connect guide, utilize described data source to connect guide and be connected to respectively the each described data source in described relevant database.
Step 132: according to the user's operational order receiving, choose the database object corresponding with described user's operational order as physical model in described relevant database, there are mapping relations between the each object data in described physical model.
Wherein, above-mentioned referring to, is used each use object that described framework instrument is each electric system in electrical network to choose separately physical model separately.
When concrete enforcement, system modelling in described report server uses COGNOS modeling tool Framework, this instrument is the database of access service system directly, the main database of supporting comprises: IBM DB28.x, Oracle 9i/10g, Sybase 11.x, 12.x, SQL Server 2000 and My SQL 4.x.Framework instrument is realized and being provided by COGNOS server, for C/S (Client/Server, client/server) structure, major function is to realize establishment and the issuing function of metadata schema, all parameters deposit COGNOS content library (Content Store) in.Each use object is its corresponding physical model as each department or user can create separately data model project, creates data source and metadata schema, and issues respectively, does not affect each other.Wherein, Framework instrument can also create with management data source and be connected, and usage data source connects guide and is connected to specific data source, and the management to data source authority is provided.In establishment data source process, user can select specific database object as physical model with Framework, comprises table, view and storing process.
Step 133: according to the mapping relations between each object data in described physical model, generate the reports model of described physical model, described physical model is described metadata schema, and each described metadata schema is corresponding with the use object of an electric system in described electrical network.
With reference to figure 3, be the process flow diagram of the source data dissemination method embodiment tri-of the multiple data sources of a kind of electrical network provided by the invention, wherein, before described step 101, described method can also comprise the following steps:
Step 100: create the data-interface corresponding with each described data source.
Wherein, described data-interface in order to electrical network in the data source data of each electric system connect.
Accordingly, described step 101 can realize in the following manner:
Obtain respectively the source data of each described data source in described electrical network by corresponding data interface, according to the source data of the default each described data source of Unified coding rule identification.
When concrete enforcement, described data-interface includes but not limited to FTP (File Transfer Protocol, file transfer protocol (FTP)) service interface, database interface, network service (Web Services) interface, Corba (Common Object Request Broker Architecture, Common Object Request Broker Architecture) interface, CIS (Component Interface Specification, component interface specification) interface.Particularly, the present invention can develop the interface being connected with communication resource management system, and access communications class is shared data; Develop the interface being connected with relay protection statistical study and operation management system, access power transformation relay protection class is shared data.
In above-mentioned each embodiment, described report server can be COGNOS server, and corresponding, described metadata schema can be form-public information COGNOS-CIM model.
As shown in Figure 4, be the data shelf composition of the model of COGNOS-CIM described in the present embodiment.
Wherein, the present embodiment can merge by COGNOS-CIM model the electric network model data of each electric system of the superior and the subordinate.
It should be noted that, COGNOS server carries out framework taking service as guiding, a kind ofly can and on single reliable framework, provide the solution of complete business intelligence function by single product, comprise that final user inquires about form, multidimensional analysis, data mining, the Software tools such as packing data warehouse, wherein, multidimensional analysis is according to the data characteristics of power industry model, by considering that multiple dimensions are as system, area, electric pressures etc. are entered multiaspect analysis to data, from multiple angle display datas, for user carries out power scheduling and decision support provides strong data basis.And CIM (Common Information Model, common information model) be the technological core of CCAPI (control center's application programming interfaces), define the basic structure of electric power system model, for shared information between application provides a public language, greatly reduced the number of data format converter required between application, and the new application consistent with CIM of development data structure is also without carrying out format conversion future.
In technical field of power systems, CIM embodies the physical logic between electric network information, and no matter the setting of the attribute in inheritance or the model class of model class, is all applied as center with EMS, and its information semantic and EMS apply direct coupling.But, although there is protection package in CIM, obviously, for DTS application arranges, can not intactly embody data relationship and the functional cohesion of protective device inside; And the modeling method of CIM is also not necessarily applicable to other application.Particularly; the modeling process of CIM is object oriented analysis and construction process; focus on setting up the relation such as association, polymerization between information; for other application examples as protection information management system; conventional information expresses possibility does not need so complicated modeling process and the cooperation logic of complicated logic between for example protecting, neither be associated, paradigmatic relation can represent.
In the present embodiment, the data model of COGNOS server has logically divided sandwich construction, comprising: represent layer, Web layer, application layer, data Layer.Various electric system can be called the middleware of COGNOS, as called SDK (the Software Development Kit of COGNOS by Gateway (gateway), SDK (Software Development Kit)), the various interfaces such as JAVA .NET, COM are provided, can call the service in COGNOS and content, other application well and in enterprise realize closely integrated, adapt to the needs of secondary development.User is based on B/S pattern, and (derivation) edited, customizes and issued to the multi-source data that only need to both can realize coming from each electric system by IE browser login report server.
Therefore, for different application systems, should be using different application message models as with reference to model, the consistent semanteme infologic relevant with application that provides information to call, build API (the Application Programming Interface on component model basis with CIS simultaneously, application programming interface), thus interoperability and plug and play between supported application system and application component.
Because the present embodiment can carry out combination to COGNOS and CIM, adopt COGNOS-CIM model as metadata schema, described by the effectively each Data Source of identification of Unified coding, be specially: merge the data of each electric system the superior and the subordinate by described COGNOS-CIM model; Adopt Unified coding system to identify the data of each electric system.Wherein, adopt Unified coding system the data of each electric system to be identified and can be adopted following process realize, comprising:
Based on the hierarchical structure of IEC 61970 standards, adopt GB or self-documenting code to determine the data encoding of each electric system to be accessed;
By the data of each department electric system are encoded in order, each electric power system data is carried out within the scope of whole electrical network to unique identification.
As shown in Figure 5, for multi-source data in the present embodiment customizes the data shelf composition of issuing.
According to user to the customization issuing process of electrical network multi-source data in, need to give metadata schema form is made.In report form template manufacturing process, be first stored in the each data source data on integrated data platform by the access of IE browser, comprise relevant database, as SQL Server, Oracle and DB2 etc.; Secondly on COGNOS server, realize the mapping between physical data and application REPORT-OBJECT by metadata schema; The 3rd, by report making worktable, in UI (User Interface, user interface), the definition of mode service data and the page layout such as to pull, realize efficiently, easily report making process according to report form template; Be finally configuration form customize association attributes, as the name to model etc., ensure that form meets user's request.
Wherein, in the time that multi-data source accesses, related data, through standardization, unitized and through means access integrated data platforms such as correctness verifications, is set up and adjusted logical other data directory item of centre grade.The object that need to access comprises: data reporting system related data; Scheduling office's existing system and interface data; Mailing address's existing system and interface data; Robotization place existing system and interface data; Relay protection place existing system and interface data; The existing each system of technical office and interface data; The existing each system of planning department and interface data; The existing each system in system place and interface data; Other existing each system and interface data.And metadata schema has been set up report form template, this report form template is made up of data definition and mapping relations, is the tie between data source and form.System is by effective tissue of COGNOS-CIM model realization data.
In report form template manufacturing process, user can directly access COGNOS server by IE browser, and the demand according to user to form can be selected different worktable, mainly contain three class worktable, i.e. Query Studio, Report Studio and Analysis Studio.
Query Studio, i.e. self-help type form, according to the metadata schema of issuing, realizes the manufacturing process of simple form through simple drag function.
Report Studio, professional report making.Use same data model with Query Studio, difference is that it provides more professional report making method and means, can make the form of complicated type.
Analysis Studio, multidimensional analysis report making, the data cube (Power Cube) that mainly can realize organizing is realized multidimensional analysis, can carry out multi-faceted displaying to available data from multiple dimensions.
And based on data framework as shown in Figure 5, described step 104 in above-mentioned each embodiment is distributed on report server at described metadata schema, user uses IE browser login to the multi-source data in described metadata schema being conducted interviews while issuing as customization in described report server, specifically can realize in the following manner:
User logins to described report server by IE browser; Utilize described metadata schema that multiple data source data are cleaned, filtered and reorganize, carry out the data analysis of various dimensions; Configuration report generation strategy; Generate self-defined report according to described report generation strategy and described report form template, determine Data Source and the Show Styles of described self-defined report; Production plan to described self-defined report is dispatched, and determines generating mode, send mode and the transmission task of described self-defined report, guarantees the user that described self-defined report sends to customization to issue in the correct time in correct mode.
Wherein, in above-mentioned implementation procedure, can realize in the following manner at configuration report generation strategy:
Judge the current demand whether report form template meets user of calling; If current report form template meets user's demand, the current report form template calling is saved to content library; Report form template is classified and preserved and issue, define the operating right of each user to described report form template, and guarantee that different user can carry out the operation in authority to report form template; Adopt corresponding plan operation, generating mode, send mode and the statement form of dispatch report template according to user's request.
Particularly, form layoutprocedure mainly comprises that report form template configuration, form are issued configuration, form task configures.Wherein, report form template configuration, after referring to that report form template has been set up, can check by preview function the form of generation.If form meets user's request, can be saved to content library when front template, determine the authorities such as the inquiry of other users to this template, amendment, execution, determine that form is sent to each user's mode etc.Form is issued configuration, after being included in report form template and completing, this template can be used to copy, the function such as mobile, form classify and preserve and issue, guarantees that the related personnel of different user, different user groups can carry out the operation in authority to form.The configuration of form task, after comprising that each report form template completes, can adopt different plan job schedulings according to user's request, guarantees that form is sent to specific user in the correct time with correct mode and form.
In the present embodiment, self-defined report send mode mainly contains several as follows: FTP, EMAIL and IE download.The form of self-defined report includes but not limited to these several forms of XML, HTML, WORD, EXCEL, EFILE and PDF.
Further, in the present embodiment, can adopt multi-source data customization issue authority and displaying navigation process are controlled based on different user.
Wherein, issue in authority and be mainly reflected in user's authority is arranged in multi-source data customization.System is by SDK (Software Development Kit, SDK (Software Development Kit)) realize the combination of J2EE bus and COGNOS bus, realize single-sign-on function, realize unified login and the rights management of reporting system and integrated data platform system, effectively ensure the security of system, and reduced the complexity of process of user login.Particularly, the present invention mainly comprises aspect following four in the user right control to different.
1) data source rights management
A series of functions such as the inquiry of data source, newly-built, amendment, deletion, test; The authority that each user, each user's group are checked data source data is provided simultaneously.
2) bag (Packet) rights management
User need to make form on " bag " basis, and therefore for different users, the bag difference that can operate, need to distribute different authorities.
3) form rights management
User makes report form template, simultaneously can be according to demand, adjust the associative operation authority of each user to this form, and comprise the authorities such as inquiry, execution, editor, deletion.By the distribution to authority, can guarantee that the form that user makes can be by correct processing.
4) System Privileges
The authority of reporting system and the permission system of integrated data platform combine, and distributing user possesses certain function.By the combination of form authority and System Privileges, system can effectively ensure, in report form template making and form issuing process, to realize safety and the confidentiality of data, determines that specific user sees other data of a specific order, model and form.In form rights management process, can realize the security of Data Source, the security that data model is issued and the security of report form showing.
In addition, the displaying of the advanced application system data message that customization is issued to different user is browsed and has been done unified and standard control, mainly comprises information display and browses with form displaying and browse.
(1) information display with browse
The external display data in report data center, need to provide to user in effective mode, need to carry out following work:
1) create list.System made on integrated data platform basis, the sharing data access integrated data platform that first each sections produce each system and data-interface; After next while various places tune, county's tune and power plant report related data, after standardization, unification deposits integrated data platform in; Again each sections report by data after through standardization storage integrated data platform, effectively ensured the integrality of system data
2) set up metadata schema.In conjunction with list, reporting system passes through metadata schema, the data that exist in integrated data platform are effectively organized, by the organizational principle of COGNOS-CIM model, provided data message with Tree structure OO, easy-to-search to user by all data.
3) create data directory.Along with the growth of data, metadata schema constantly increases, and need to set up data directory to metadata schema, effectively searches and locator data object, forms center rank data directory service, and unified information display and administration page is externally provided.
(2) form is shown and is browsed
User can, according to the authority login report server distributing, only need IE browser, does not need download client or plug-in unit, also report capability can be embedded in integrated data platform and concentrate displaying simultaneously, avoids secondary login problem.User is to the form that can check in own authority, can show homepage faces by self-defined all forms, all form exhibition methods, facilitate user according to the demand of oneself to the form displaying of classifying.
The present embodiment has been realized COGNOS and has been connected the combination that represents function with integrated data platform WEB.Integrated data platform WEB provides single-sign-on function, in integrated data platform, after login once, does not need again to login COGNOS server and can browse relevant report form template.
In the present embodiment, can show form by IE, by the secondary development to COGNOS form, can directly realize with report server and intercoming mutually, complete following work: user authority management, report query are browsed, report generation management, form production plan, form log query are browsed.
Further, the source data distribution technology scheme of the electrical network multi-data source in the present embodiment also comprises the comprehensive checkschema to data.Particularly, report in process in data, service end inspection and client verification duplication check function are provided.Client verification provides data layout verification, precision checking, the verification of data limit value, data formula verification etc.; Service end verification provides data check interface, supports complicated logical operation verification mode, guarantees integrality and the correctness of user submit data.Each application system data are carried out to verification at integrated data platform, guarantee correctness and the uniqueness of data source.
And, the present embodiment can be based on COGNOS server the development platform as form middleware, different types of service is carried out to the exploitation of intelligent report forms middleware, metadata schema carries out data display, full Chinese interface support, there is report making simple (only needing simple towing), OO report making mode, can carry out complicated plan, self-defined report template to form, and support the features such as form derivation such as XML, HTML, EXCEL, PDF, EFILE.
With reference to figure 6, be the process flow diagram of the source data dissemination method embodiment tetra-of the multiple data sources of a kind of electrical network provided by the invention, wherein, described method can also comprise the following steps:
Step 105: described metadata schema is set up to data directory, form data directory object, search and locate the data object in described relevant database so that obtain user by described data directory object in described metadata schema.
Wherein, in the present embodiment, described metadata schema is set up to data directory, to search and to locate the data object in described relevant database, the rank data directory service of formation center is described data directory object, and unified information display and administration page is externally provided.
With reference to figure 7, be the structural representation of the source data delivery system embodiment five of the multiple data sources of a kind of electrical network provided by the invention, wherein, described system can comprise following structural unit:
Source data acquiring unit 701, for obtaining respectively the source data of the multiple data sources of described electrical network.
Wherein, described data source can be understood as the data source of the basic business system of power department in electrical network.
Data storage cell 702, for each described source data is operated according to same data processing rule respectively, and is all stored to the source data after operation in default relevant database.
Wherein, the specific implementation of described data storage cell 702 can, with reference to content described in correlation method embodiment in above, no longer describe in detail herein.
Model is set up unit 703, for according to described relevant database, sets up the metadata schema of each described source data, and the mapping relations in the report data in described metadata schema and described relevant database between each object data are corresponding.
Wherein, the specific implementation that described model is set up unit 703 can, with reference to content described in correlation method embodiment in above, no longer describe in detail herein.
Model publish unit 704, for described metadata schema being distributed to respectively to default report data server, conducts interviews to the data in described metadata schema so that obtain user's login to described report server.
Wherein, the specific implementation of described Model publish unit 704 can, with reference to content described in correlation method embodiment in above, no longer describe in detail herein.
From such scheme, the source data delivery system embodiment five of the multiple data sources of a kind of electrical network provided by the invention, by opening relationships type database, the source data of the multiple data sources in electrical network is carried out being stored in wherein after standardization processing, and set up metadata schema, determine the mapping relations between the each object data in described relevant database, data layout and Treatment Analysis flow process between unified multiple data sources, thus, metadata schema is published on report server, make the different objects that use access the data in metadata schema as different departments or with logining per family to report server, as data customized to issue etc. according to business demand, meet the different objects that use to the data access scheduling between multiple data sources of electrical network, not only avoid system resource waste that development data driver brings to increase the problem of system burden, also ensure consistance and the accuracy of different electric power parameter, reduce the collection of electrical network multi-source data, transmission, the impact on running efficiency of system and stability of the too many levels such as processing, improve the quality of operation of power networks data.
With reference to figure 8, set up the structural representation of unit 703 for model described in the source data delivery system embodiment six of the multiple data sources of a kind of electrical network provided by the invention, wherein, described model is set up unit 703 can comprise following structure:
Data source connexon unit 731, creates data source for the framework instrument by default and connects guide, utilizes described data source to connect guide and is connected to respectively the each described data source in described relevant database.
Model is chosen subelement 732, for the user's operational order according to receiving, in described relevant database, choose the database object corresponding with described user's operational order as physical model, between the each object data in described physical model, there are mapping relations.
Wherein, above-mentioned referring to, is used each use object that described framework instrument is each electric system in electrical network to choose separately physical model separately.
When concrete enforcement, system modelling in described report server uses COGNOS modeling tool Framework, this instrument is the database of access service system directly, the main database of supporting comprises: IBM DB28.x, Oracle 9i/10g, Sybase 11.x, 12.x, SQL Server 2000 and My SQL 4.x.Framework instrument is realized and being provided by COGNOS server, for C/S (Client/Server, client/server) structure, major function is to realize establishment and the issuing function of metadata schema, all parameters deposit COGNOS content library (Content Store) in.Each use object is its corresponding physical model as each department or user can create separately data model project, creates data source and metadata schema, and issues respectively, does not affect each other.Wherein, Framework instrument can also create with management data source and be connected, and usage data source connects guide and is connected to specific data source, and the management to data source authority is provided.In establishment data source process, user can select specific database object as physical model with Framework, comprises table, view and storing process.
Report generation subelement 733, for the mapping relations according between the each object data of described physical model, generate the reports model of described physical model, described physical model is described metadata schema, and each described metadata schema is corresponding with the use object of an electric system in described electrical network.
With reference to figure 9, be the structural representation of the source data delivery system embodiment seven of the multiple data sources of a kind of electrical network provided by the invention, wherein, described system can also comprise following structure:
Interface creating unit 700, before obtaining source data at described source data acquiring unit 701, creates the data-interface corresponding with each described data source.
Wherein, described data-interface in order to electrical network in the data source data of each electric system connect.
Accordingly, as shown in Figure 10, be the structural representation of described source data acquiring unit 701, wherein, described source data acquiring unit 701 can comprise following structure:
Interface data obtains subelement 711, for obtain respectively the source data of the each described data source of described electrical network by corresponding data interface.
Code identification subelement 712, for the source data of the each described data source of Unified coding rule identification according to default.
When concrete enforcement, described data-interface includes but not limited to FTP (File Transfer Protocol, file transfer protocol (FTP)) service interface, database interface, network service (Web Services) interface, Corba (Common Object Request Broker Architecture, Common Object Request Broker Architecture) interface, CIS (Component Interface Specification, component interface specification) interface.Particularly, the present invention can develop the interface being connected with communication resource management system, and access communications class is shared data; Develop the interface being connected with relay protection statistical study and operation management system, access power transformation relay protection class is shared data.
In above-mentioned each embodiment, described report server can be COGNOS server, and corresponding, described metadata schema can be form-public information COGNOS-CIM model.
As shown in Figure 4, be the data shelf composition of the model of COGNOS-CIM described in the present embodiment.As shown in Figure 5, be the data shelf composition that in the present embodiment, multi-source data customization is issued, based on data framework as shown in Figure 5, the described Model publish unit 704 in above-described embodiment can be realized in the following manner:
User logins to described report server by IE browser; Utilize described metadata schema that multiple data source data are cleaned, filtered and reorganize, carry out the data analysis of various dimensions; Configuration report generation strategy; Generate self-defined report according to described report generation strategy and described report form template, determine Data Source and the Show Styles of described self-defined report; Production plan to described self-defined report is dispatched, and determines generating mode, send mode and the transmission task of described self-defined report, guarantees the user that described self-defined report sends to customization to issue in the correct time in correct mode.
The specific implementation of above-mentioned implementation procedure can, referring to corresponding contents in embodiment of the method above, no longer describe in detail herein.
With reference to Figure 11, be the structural representation of the source data delivery system embodiment eight of the multiple data sources of a kind of electrical network provided by the invention, wherein, described system can also comprise following structure:
Unit 705 set up in index, for described metadata schema is set up to data directory, forms data directory object, searches and locate the data object in described relevant database so that obtain user by described data directory object in described metadata schema.
Wherein, in the present embodiment, described metadata schema is set up to data directory, to search and to locate the data object in described relevant database, the rank data directory service of formation center is described data directory object, and unified information display and administration page is externally provided.
Above source data dissemination method and the system of the multiple data sources of a kind of electrical network provided by the present invention are described in detail, applied specific case herein principle of the present invention and embodiment are set forth, the explanation of above embodiment is just for helping to understand core concept of the present invention; , for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention meanwhile.
Claims (10)
1. a source data dissemination method for the multiple data sources of electrical network, is characterized in that, comprising:
Obtain respectively the source data of multiple data sources in described electrical network;
Each described source data is operated according to same data processing rule respectively, and the source data after operation is all stored in default relevant database;
According to described relevant database, set up the metadata schema of each described source data, the mapping relations in the reports model in described metadata schema and described relevant database between each object data are corresponding;
Described metadata schema is distributed to respectively in default report server, so that obtain user's login to described report server, the data in described metadata schema is conducted interviews.
2. method according to claim 1, is characterized in that, the described relevant database of described foundation is set up the metadata schema of each described source data, comprising:
Create data source by default framework instrument and connect guide, utilize described data source to connect guide and be connected to respectively the each described data source in described relevant database;
According to the user's operational order receiving, in described relevant database, choose the database object corresponding with described user's operational order as physical model, between the each object data in described physical model, there are mapping relations;
According to the mapping relations between each object data in described physical model, generate the reports model of described physical model, described physical model is described metadata schema, and each described metadata schema is corresponding with the use object of an electric system in described electrical network.
3. method according to claim 1, is characterized in that, described obtain respectively described electrical network in before the source data of multiple data sources, described method also comprises:
Create the data-interface corresponding with each described data source;
Accordingly, the described source data of obtaining respectively multiple data sources in described electrical network, comprising:
Obtain respectively the source data of each described data source in described electrical network by corresponding data interface;
According to the source data of the default each described data source of Unified coding rule identification.
4. method according to claim 3, is characterized in that, described metadata schema is form-public information COGNOS-CIM model, and described report server is COGNOS server.
5. method according to claim 1, is characterized in that, described method also comprises:
Described metadata schema is set up to data directory, form data directory object, in described metadata schema, search and locate the data object in described relevant database so that obtain user by described data directory object.
6. a source data delivery system for the multiple data sources of electrical network, is characterized in that, comprising:
Source data acquiring unit, for obtaining respectively the source data of the multiple data sources of described electrical network;
Data storage cell, for each described source data is operated according to same data processing rule respectively, and is all stored to the source data after operation in default relevant database;
Model is set up unit, for according to described relevant database, sets up the metadata schema of each described source data, and the mapping relations in the report data in described metadata schema and described relevant database between each object data are corresponding;
Model publish unit, for described metadata schema being distributed to respectively to default report data server, conducts interviews to the data in described metadata schema so that obtain user's login to described report server.
7. system according to claim 6, is characterized in that, described model is set up unit and comprised:
Data source connexon unit, creates data source for the framework instrument by default and connects guide, utilizes described data source to connect guide and is connected to respectively the each described data source in described relevant database;
Model is chosen subelement, for the user's operational order according to receiving, in described relevant database, choose the database object corresponding with described user's operational order as physical model, between the each object data in described physical model, there are mapping relations;
Report generation subelement, for the mapping relations according between the each object data of described physical model, generate the reports model of described physical model, described physical model is described metadata schema, and each described metadata schema is corresponding with the use object of an electric system in described electrical network.
8. system according to claim 6, is characterized in that, also comprises:
Interface creating unit, before obtaining source data at described source data acquiring unit, creates the data-interface corresponding with each described data source;
Accordingly, described source data acquiring unit comprises:
Interface data obtains subelement, for obtain respectively the source data of the each described data source of described electrical network by corresponding data interface;
Code identification subelement, for the source data of the each described data source of Unified coding rule identification according to default.
9. system according to claim 8, is characterized in that, described metadata schema is form-public information COGNOS-CIM model, and described report server is COGNOS server.
10. system according to claim 6, is characterized in that, also comprises:
Unit set up in index, for described metadata schema is set up to data directory, forms data directory object, searches and locate the data object in described relevant database so that obtain user by described data directory object in described metadata schema.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410461245.4A CN104200402A (en) | 2014-09-11 | 2014-09-11 | Publishing method and system of source data of multiple data sources in power grid |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410461245.4A CN104200402A (en) | 2014-09-11 | 2014-09-11 | Publishing method and system of source data of multiple data sources in power grid |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104200402A true CN104200402A (en) | 2014-12-10 |
Family
ID=52085688
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410461245.4A Pending CN104200402A (en) | 2014-09-11 | 2014-09-11 | Publishing method and system of source data of multiple data sources in power grid |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104200402A (en) |
Cited By (34)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104834985A (en) * | 2015-02-15 | 2015-08-12 | 杭州智光一创科技有限公司 | Synthetic data active information service method for electric power dispatching |
| CN105279802A (en) * | 2015-08-27 | 2016-01-27 | 深圳市慧川科技发展有限公司 | Parking lot information interconnection supervision system and method |
| CN105843821A (en) * | 2015-01-16 | 2016-08-10 | 腾讯科技（深圳）有限公司 | Data processing method and system capable of configuring reports |
| CN106326488A (en) * | 2016-09-07 | 2017-01-11 | 国家电网公司 | XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof |
| CN106339512A (en) * | 2016-11-21 | 2017-01-18 | 北京恒华伟业科技股份有限公司 | Information analysis method based on power grid geographic information system |
| CN106354707A (en) * | 2015-10-29 | 2017-01-25 | 云南电力调度控制中心 | Province class power grid energy-saving power generation dispatching report dynamic generation system |
| CN106529827A (en) * | 2016-11-30 | 2017-03-22 | 中国南方电网有限责任公司 | Metadata-based indicator descent analysis method and analysis system |
| CN106776918A (en) * | 2016-11-30 | 2017-05-31 | 中国南方电网有限责任公司 | The management method and management system of the index map based on data lineage analysis |
| CN106980925A (en) * | 2017-03-09 | 2017-07-25 | 上海海能信息科技有限公司 | A kind of regional power grid dispatching method based on big data |
| CN107276791A (en) * | 2017-05-27 | 2017-10-20 | 南京南瑞继保电气有限公司 | A kind of method and apparatus of the information of sending node |
| CN107357856A (en) * | 2017-06-29 | 2017-11-17 | 广西电网有限责任公司 | Implementation method based on power network panorama business model data integration and data, services |
| CN107515866A (en) * | 2016-06-15 | 2017-12-26 | 阿里巴巴集团控股有限公司 | A kind of data manipulation method, device and system |
| CN107577767A (en) * | 2017-09-05 | 2018-01-12 | 江苏电力信息技术有限公司 | A kind of uniform service layer method for building up based on big data |
| CN108733662A (en) * | 2017-04-13 | 2018-11-02 | 北京京东尚科信息技术有限公司 | Method, apparatus, electronic equipment and the readable storage medium storing program for executing of comparison of data consistency |
| CN109241351A (en) * | 2018-07-19 | 2019-01-18 | 佛山科学技术学院 | A kind of multi-source heterogeneous data preparation method of board production |
| CN109426597A (en) * | 2017-12-21 | 2019-03-05 | 中国平安人寿保险股份有限公司 | Application performance monitoring method, device, equipment, system and storage medium |
| CN109710653A (en) * | 2018-12-29 | 2019-05-03 | 北京航天数据股份有限公司 | A kind of test data source configuration method and device |
| CN109766708A (en) * | 2017-11-09 | 2019-05-17 | 北京京东尚科信息技术有限公司 | Access method, system, computer system and the storage medium of data resource |
| CN110019228A (en) * | 2017-12-25 | 2019-07-16 | 北京金风科创风电设备有限公司 | Multi-source data integration method and device based on fan data |
| CN110113257A (en) * | 2019-05-14 | 2019-08-09 | 北京京投亿雅捷交通科技有限公司 | A kind of uniform data access gateway and implementation method based on big data |
| CN110309442A (en) * | 2019-06-27 | 2019-10-08 | 百度在线网络技术（北京）有限公司 | Show mapping method, device, equipment and the medium of end data |
| CN110377568A (en) * | 2019-07-26 | 2019-10-25 | 北京明略软件系统有限公司 | A kind of metadata acquisition method and device |
| CN110413662A (en) * | 2019-08-05 | 2019-11-05 | 中国地质大学（北京） | A kind of multi-channel type economic data input system, acquisition system and method |
| CN110795487A (en) * | 2019-11-04 | 2020-02-14 | 浪潮通用软件有限公司 | Service publishing method |
| CN111177177A (en) * | 2019-12-02 | 2020-05-19 | 国网吉林省电力有限公司吉林供电公司 | Automatic reporting system and method based on multi-source heterogeneous data fusion |
| CN111198873A (en) * | 2020-01-08 | 2020-05-26 | 中国建设银行股份有限公司 | Data processing method and device |
| CN111767117A (en) * | 2020-06-22 | 2020-10-13 | 博易智软(北京)技术有限公司 | Mobile-end BI middleware technology based on application container |
| CN112055065A (en) * | 2020-08-27 | 2020-12-08 | 国电南瑞科技股份有限公司 | Relay protection SaaS layer application data processing method based on regulation and control cloud |
| CN112256988A (en) * | 2020-10-19 | 2021-01-22 | 中国互联网金融协会 | Method and device for monitoring cross-border house-buying website, electronic equipment and storage medium |
| CN113190408A (en) * | 2021-05-07 | 2021-07-30 | 北京金融资产交易所有限公司 | Data operation and maintenance system |
| CN113628066A (en) * | 2021-06-28 | 2021-11-09 | 南京南瑞继保电气有限公司 | Method for extracting multidimensional feature vector data of wind generating set in loose coupling mode |
| CN113688116A (en) * | 2020-05-19 | 2021-11-23 | 长鑫存储技术有限公司 | Data presentation system, method, device and computer readable storage medium |
| CN114706918A (en) * | 2022-06-01 | 2022-07-05 | 杭州安恒信息技术股份有限公司 | Multi-type database compatibility method, device, equipment and storage medium |
| US11983224B2 (en) | 2020-05-19 | 2024-05-14 | Changxin Memory Technologies, Inc. | Data presentation system, method and device, and computer-readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101242408A (en) * | 2008-01-18 | 2008-08-13 | 南京邮电大学 | A construction method for open multi-source data packet capturing |
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN102903063A (en) * | 2012-09-19 | 2013-01-30 | 中国电力科学研究院 | Integral electricity market operation system |
| CN103902671A (en) * | 2014-03-19 | 2014-07-02 | 北京科技大学 | Dynamic integration method and system of multi-source heterogeneous data |
-
2014
- 2014-09-11 CN CN201410461245.4A patent/CN104200402A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101452450A (en) * | 2007-11-30 | 2009-06-10 | 上海市电力公司 | Multiple source data conversion service method and apparatus thereof |
| CN101242408A (en) * | 2008-01-18 | 2008-08-13 | 南京邮电大学 | A construction method for open multi-source data packet capturing |
| CN102903063A (en) * | 2012-09-19 | 2013-01-30 | 中国电力科学研究院 | Integral electricity market operation system |
| CN103902671A (en) * | 2014-03-19 | 2014-07-02 | 北京科技大学 | Dynamic integration method and system of multi-source heterogeneous data |
Non-Patent Citations (1)
| Title |
|---|
| 高峰: "基于综合数据平台的电力智能报表系统研究", 《中国优秀硕士学位论文全文数据库 工程科技Ⅱ辑》 * |
Cited By (52)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105843821B (en) * | 2015-01-16 | 2019-09-06 | 腾讯科技（深圳）有限公司 | A kind of data processing method and system of configurable report |
| CN105843821A (en) * | 2015-01-16 | 2016-08-10 | 腾讯科技（深圳）有限公司 | Data processing method and system capable of configuring reports |
| CN104834985A (en) * | 2015-02-15 | 2015-08-12 | 杭州智光一创科技有限公司 | Synthetic data active information service method for electric power dispatching |
| CN105279802A (en) * | 2015-08-27 | 2016-01-27 | 深圳市慧川科技发展有限公司 | Parking lot information interconnection supervision system and method |
| CN105279802B (en) * | 2015-08-27 | 2018-11-06 | 深圳市慧川科技发展有限公司 | Parking lot information interconnects supervisory systems and method |
| CN106354707B (en) * | 2015-10-29 | 2019-04-19 | 云南电力调度控制中心 | A kind of provincial power network energy-saving power generation dispatching report dynamic generating system |
| CN106354707A (en) * | 2015-10-29 | 2017-01-25 | 云南电力调度控制中心 | Province class power grid energy-saving power generation dispatching report dynamic generation system |
| CN107515866B (en) * | 2016-06-15 | 2021-01-29 | 阿里巴巴集团控股有限公司 | Data operation method, device and system |
| CN107515866A (en) * | 2016-06-15 | 2017-12-26 | 阿里巴巴集团控股有限公司 | A kind of data manipulation method, device and system |
| CN106326488A (en) * | 2016-09-07 | 2017-01-11 | 国家电网公司 | XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof |
| CN106339512A (en) * | 2016-11-21 | 2017-01-18 | 北京恒华伟业科技股份有限公司 | Information analysis method based on power grid geographic information system |
| CN106776918A (en) * | 2016-11-30 | 2017-05-31 | 中国南方电网有限责任公司 | The management method and management system of the index map based on data lineage analysis |
| CN106529827A (en) * | 2016-11-30 | 2017-03-22 | 中国南方电网有限责任公司 | Metadata-based indicator descent analysis method and analysis system |
| CN106980925A (en) * | 2017-03-09 | 2017-07-25 | 上海海能信息科技有限公司 | A kind of regional power grid dispatching method based on big data |
| CN106980925B (en) * | 2017-03-09 | 2020-11-17 | 上海海能信息科技有限公司 | Regional power grid dispatching method based on big data |
| CN108733662A (en) * | 2017-04-13 | 2018-11-02 | 北京京东尚科信息技术有限公司 | Method, apparatus, electronic equipment and the readable storage medium storing program for executing of comparison of data consistency |
| CN107276791A (en) * | 2017-05-27 | 2017-10-20 | 南京南瑞继保电气有限公司 | A kind of method and apparatus of the information of sending node |
| CN107357856A (en) * | 2017-06-29 | 2017-11-17 | 广西电网有限责任公司 | Implementation method based on power network panorama business model data integration and data, services |
| CN107357856B (en) * | 2017-06-29 | 2020-07-14 | 广西电网有限责任公司 | Method for realizing data integration and data service based on power grid panoramic service model |
| CN107577767A (en) * | 2017-09-05 | 2018-01-12 | 江苏电力信息技术有限公司 | A kind of uniform service layer method for building up based on big data |
| CN109766708B (en) * | 2017-11-09 | 2021-04-30 | 北京京东尚科信息技术有限公司 | Data resource access method, system, computer system and storage medium |
| CN109766708A (en) * | 2017-11-09 | 2019-05-17 | 北京京东尚科信息技术有限公司 | Access method, system, computer system and the storage medium of data resource |
| CN109426597A (en) * | 2017-12-21 | 2019-03-05 | 中国平安人寿保险股份有限公司 | Application performance monitoring method, device, equipment, system and storage medium |
| CN109426597B (en) * | 2017-12-21 | 2022-04-12 | 中国平安人寿保险股份有限公司 | Application performance monitoring method, device, equipment, system and storage medium |
| CN110019228A (en) * | 2017-12-25 | 2019-07-16 | 北京金风科创风电设备有限公司 | Multi-source data integration method and device based on fan data |
| CN109241351A (en) * | 2018-07-19 | 2019-01-18 | 佛山科学技术学院 | A kind of multi-source heterogeneous data preparation method of board production |
| CN109710653A (en) * | 2018-12-29 | 2019-05-03 | 北京航天数据股份有限公司 | A kind of test data source configuration method and device |
| CN110113257A (en) * | 2019-05-14 | 2019-08-09 | 北京京投亿雅捷交通科技有限公司 | A kind of uniform data access gateway and implementation method based on big data |
| CN110113257B (en) * | 2019-05-14 | 2021-06-08 | 北京京投亿雅捷交通科技有限公司 | Unified data access gateway based on big data and implementation method |
| CN110309442A (en) * | 2019-06-27 | 2019-10-08 | 百度在线网络技术（北京）有限公司 | Show mapping method, device, equipment and the medium of end data |
| CN110309442B (en) * | 2019-06-27 | 2023-02-17 | 百度在线网络技术（北京）有限公司 | Mapping method, device, equipment and medium for displaying end data |
| CN110377568A (en) * | 2019-07-26 | 2019-10-25 | 北京明略软件系统有限公司 | A kind of metadata acquisition method and device |
| CN110413662A (en) * | 2019-08-05 | 2019-11-05 | 中国地质大学（北京） | A kind of multi-channel type economic data input system, acquisition system and method |
| CN110413662B (en) * | 2019-08-05 | 2021-11-26 | 中国地质大学（北京） | Multichannel economic data input system, acquisition system and method |
| CN110795487A (en) * | 2019-11-04 | 2020-02-14 | 浪潮通用软件有限公司 | Service publishing method |
| CN111177177B (en) * | 2019-12-02 | 2023-06-16 | 国网吉林省电力有限公司吉林供电公司 | Automatic reporting system based on multi-source heterogeneous data fusion and method thereof |
| CN111177177A (en) * | 2019-12-02 | 2020-05-19 | 国网吉林省电力有限公司吉林供电公司 | Automatic reporting system and method based on multi-source heterogeneous data fusion |
| CN111198873A (en) * | 2020-01-08 | 2020-05-26 | 中国建设银行股份有限公司 | Data processing method and device |
| CN111198873B (en) * | 2020-01-08 | 2023-07-07 | 中国建设银行股份有限公司 | Data processing method and device |
| CN113688116A (en) * | 2020-05-19 | 2021-11-23 | 长鑫存储技术有限公司 | Data presentation system, method, device and computer readable storage medium |
| WO2021233160A1 (en) * | 2020-05-19 | 2021-11-25 | 长鑫存储技术有限公司 | Data presentation system, method and device, and computer-readable storage medium |
| US11983224B2 (en) | 2020-05-19 | 2024-05-14 | Changxin Memory Technologies, Inc. | Data presentation system, method and device, and computer-readable storage medium |
| CN111767117A (en) * | 2020-06-22 | 2020-10-13 | 博易智软(北京)技术有限公司 | Mobile-end BI middleware technology based on application container |
| CN111767117B (en) * | 2020-06-22 | 2024-02-20 | 中兴智慧(北京)技术有限公司 | Mobile end BI middleware technology based on application container |
| CN112055065A (en) * | 2020-08-27 | 2020-12-08 | 国电南瑞科技股份有限公司 | Relay protection SaaS layer application data processing method based on regulation and control cloud |
| CN112256988A (en) * | 2020-10-19 | 2021-01-22 | 中国互联网金融协会 | Method and device for monitoring cross-border house-buying website, electronic equipment and storage medium |
| CN113190408A (en) * | 2021-05-07 | 2021-07-30 | 北京金融资产交易所有限公司 | Data operation and maintenance system |
| CN113190408B (en) * | 2021-05-07 | 2024-03-26 | 北京金融资产交易所有限公司 | Data operation and maintenance system |
| CN113628066A (en) * | 2021-06-28 | 2021-11-09 | 南京南瑞继保电气有限公司 | Method for extracting multidimensional feature vector data of wind generating set in loose coupling mode |
| CN113628066B (en) * | 2021-06-28 | 2024-03-19 | 南京南瑞继保电气有限公司 | Multi-dimensional feature vector data loose coupling extraction method for wind generating set |
| CN114706918A (en) * | 2022-06-01 | 2022-07-05 | 杭州安恒信息技术股份有限公司 | Multi-type database compatibility method, device, equipment and storage medium |
| CN114706918B (en) * | 2022-06-01 | 2022-09-16 | 杭州安恒信息技术股份有限公司 | Multi-type database compatibility method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104200402A (en) | Publishing method and system of source data of multiple data sources in power grid | |
| CN104767813B (en) | Public's row big data service platform based on openstack | |
| US10769165B2 (en) | Computing data lineage across a network of heterogeneous systems | |
| CN103530354B (en) | geographic information data fusion system | |
| CN110837492B (en) | Method for providing data service by multi-source data unified SQL | |
| CN102054025B (en) | Traffic information resource integration processing method and system | |
| CN105224631B (en) | The method built the system of the open cloud of industry and work out XBRL financial statement | |
| US20140188845A1 (en) | Interoperable shared query based on heterogeneous data sources | |
| US9201700B2 (en) | Provisioning computer resources on a network | |
| CN104346377A (en) | Method for integrating and exchanging data on basis of unique identification | |
| CN110807015A (en) | Big data asset value delivery management method and system | |
| CN101201842A (en) | Digital museum gridding and construction method thereof | |
| CN103902286A (en) | Hierarchy type multi-source data fusion method based on SOA | |
| US11100098B2 (en) | Systems and methods for providing multilingual support for data used with a business intelligence server | |
| US20140229223A1 (en) | Integrated erp based planning | |
| CN104200331A (en) | Power grid model joining method and system of power system | |
| CN103559189A (en) | Power simulation training resource management system and method based on metadata integration model | |
| CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
| CN102306355A (en) | Management system for IT (Information Technology) operation and maintenance configuration | |
| CN103927185A (en) | Network topology modeling device based on energy management and guiding method thereof | |
| CN115617776A (en) | Data management system and method | |
| CN103646093A (en) | Data processing method and platform for search engines | |
| US10242037B2 (en) | Index suggestion engine for relational databases | |
| Brambilla et al. | Model-driven design of service-enabled web applications | |
| Hua et al. | Architectural support for business intelligence: a push‐pull mechanism |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20141210 |