CN105426516A - Power system data query method and system - Google Patents
Power system data query method and system Download PDFInfo
- Publication number
- CN105426516A CN105426516A CN201510870371.XA CN201510870371A CN105426516A CN 105426516 A CN105426516 A CN 105426516A CN 201510870371 A CN201510870371 A CN 201510870371A CN 105426516 A CN105426516 A CN 105426516A
- Authority
- CN
- China
- Prior art keywords
- data
- preset table
- table template
- template
- template profile
- 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
- 238000000034 method Methods 0.000 title claims abstract description 39
- 238000012216 screening Methods 0.000 claims abstract description 62
- 230000004044 response Effects 0.000 description 19
- 230000008569 process Effects 0.000 description 9
- 238000005259 measurement Methods 0.000 description 8
- 238000012544 monitoring process Methods 0.000 description 6
- 230000001360 synchronised effect Effects 0.000 description 5
- 230000008859 change Effects 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000001914 filtration Methods 0.000 description 4
- 230000008520 organization Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 230000008676 import Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 238000013507 mapping Methods 0.000 description 2
- 238000007796 conventional method Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000005684 electric field Effects 0.000 description 1
- 238000012812 general test Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000000241 respiratory effect Effects 0.000 description 1
- 230000035807 sensation Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/903—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Public Health (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a power system data query method and system. The method comprises: configuring an attribute name possibly required to be queried by a user in a preset form template configuration file; after receiving an actual data query request of the user, querying a corresponding preset form template configuration file; and according to the preset form template configuration file, screening preset public information model data of a power system to obtain a screening result, so that the content that the user wants to query currently can be obtained. Through the power system data query method and system, when data query of various attribute content is performed, the preset form template configuration file comprises the attribute name and an attribute expression required to be queried by the user, so that the user can obtain the content required for the user currently only through one-time data query access and does not need to perform multi-time query access for obtaining the content corresponding to the attribute name in the preset form template configuration file, the query access frequency is greatly reduced, and the data access efficiency is improved.
Description
Technical field
The present invention relates to electric field, particularly a kind of querying method of electric power system data and system.
Background technology
Improve the dirigibility of data access in the application in power system monitoring field based on the OSB service bus of IEC61968 standard, client can by carrying out message data query with server.The message in current power system monitoring field is all that data are described in units of class, make accessing operation become loaded down with trivial details while possessing dirigibility based on CIM (CommonInformationModel, common information model).Such as, user needs the equipment essential information of an acquisition main transformer, the real time data of the parameter such as oil gas monitoring information and management and running information and historical data, to carry out with service alternately several times, inquire about main transformer information, monitoring equipment information respectively, measure object information, real time data and historical data, again the result inquired is organized according to association value, very loaded down with trivial details, very large for the user's difficulty not understanding CIM.
Directly based on one of method that the hierarchical data view access of CIM is common, further way goes out tree-shaped level view according to the associated configuration of CIM class, be saved as tree-like template configuration, in order to support the data access of message exchange scenarios, can obtain at model the interaction times that the stage reduces client and server like this.When client is accessed using view as noun, the XML format data that can obtain hierarchy nesting describe, but this method shortcoming is that data that user has access to are not the data of form, also needing oneself to be organized into table-like structure could directly display or warehouse-in preserve.The data returned remain according to CIM class, attribute and association tissue, user fully must understand CIM, could resolve and usage data.Based on the level view configuration of CIM without real time data and historical data, user still will carry out the delta data that repeatedly just can get needs alternately with server, and data access efficiency is low.
Another kind of conventional method carries out message access based on database table structure, for the demand of subscriber's meter case form data, service end also carries out view design and storage with identical database table structure, when user's given filter condition conducts interviews, from table, filter out corresponding data.Real time data needs Timing Synchronization to data base view table, to prevent real time data asynchronous for a long time.Although the shortcoming of this method is that the data providing formula based on database table or view is direct, the needs of known business to model aspect can be met, but because historical data amount is large, access time point or the time period uncertain, database table cannot be synchronized to, also just can not support once to access to get model and historical data simultaneously, cause data access efficiency low.
Summary of the invention
Based on this, be necessary for the low problem of data access efficiency, a kind of querying method and the system that improve the electric power system data of data access efficiency are provided.
A querying method for electric power system data, comprises the following steps:
Obtain data inquiry request, wherein, described data inquiry request comprises the template name of requesting query;
According to the template name of requesting query described in described data inquiry request, inquiry preset table template profile, wherein, described preset table template profile comprises template name, main classes title, Property Name and Attribute expression;
According to the described preset table template profile inquired, screen the default common information model data of electric system, obtain the selection result, wherein, described the selection result is corresponding with described preset table template profile;
Send described the selection result.
The present invention also provides a kind of inquiry system of electric power system data, comprising:
Acquisition module, for obtaining data inquiry request, wherein, described data inquiry request comprises the template name of requesting query;
Enquiry module, for the template name according to requesting query described in described data inquiry request, inquiry preset table template profile, wherein, described preset table template profile comprises template name, main classes title, Property Name and Attribute expression;
First screening module, for according to the described preset table template profile inquired, screen the default common information model data of electric system, obtain the selection result, wherein, described the selection result is corresponding with described preset table template profile;
Sending module, for sending described the selection result.
The querying method of above-mentioned electric power system data and system, be configured in preset table template profile by user being needed the Property Name inquired about, after receiving user's real data inquiry request, inquire corresponding preset table template profile, according to preset table template profile, the default common information model data of electric system are screened, obtain the selection result, can obtain user this want inquire about content.By querying method and the system of above-mentioned electric power system data, when carrying out the data query of multiple property content, owing to including template name in preset table template profile, main classes title, Property Name and Attribute expression, namely Property Name and the Attribute expression of the required inquiry of user is included, therefore user only need can obtain the content of user needed for this by the access of data query, user is without the need to passing through repeatedly queried access to obtain the content that in preset table template profile, Property Name is corresponding, greatly reduce queried access number of times, improve data access efficiency.
Accompanying drawing explanation
Fig. 1 is a kind of process flow diagram of querying method of electric power system data of embodiment;
Fig. 2 is the process flow diagram of the querying method of the electric power system data of another kind of embodiment;
Fig. 3 is the process flow diagram of the querying method of the electric power system data of another kind of embodiment;
Fig. 4 is the sub-process figure of the querying method of the electric power system data of another kind of embodiment;
Fig. 5 is the process flow diagram of the querying method of the electric power system data of another kind of embodiment;
Fig. 6 is 500kv transformer station preset table template profile content description figure;
Fig. 7 is the XML language description figure of 500kV substation data inquiry request;
Fig. 8 is the XML language description figure of 500kV transformer station response message;
Fig. 9 is main transformer preset table template profile content description figure;
Figure 10 is the XML language description figure of main transformer data inquiry request;
Figure 11 is the XML language description figure of main transformer response message;
Figure 12 is gain merit preset table template profile content description figure in main transformer high-pressure side;
Figure 13 is gain merit the XML language description figure of data inquiry request in main transformer high-pressure side;
Figure 14 is gain merit the XML language description figure of response message in main transformer high-pressure side;
Figure 15 is gain merit preset table template profile content description figure in main transformer high-pressure side, Jiangmen, Foshan;
Figure 16 is gain merit the XML language description figure of data inquiry request in main transformer high-pressure side, Jiangmen, Foshan;
Figure 17 is gain merit the XML language description figure of response message in main transformer high-pressure side, Jiangmen, Foshan;
Figure 18 is that main transformer measures preset table template profile content description figure;
Figure 19 is the XML language description figure that main transformer measures data inquiry request;
Figure 20 is the XML language description figure that main transformer measures response message;
Figure 21 is the XML language description figure of the main transformer measurement data inquiry request carrying screening conditions;
Figure 22 is the XML language description figure of the main transformer measurement response message carrying screening conditions;
Figure 23 is a kind of module map of inquiry system of electric power system data of embodiment;
Figure 24 is the module map of the inquiry system of the electric power system data of another kind of embodiment;
Figure 25 is the submodule figure of the inquiry system of the electric power system data of another kind of embodiment;
Figure 26 is the module map of the inquiry system of the electric power system data of another kind of embodiment.
Embodiment
Refer to Fig. 1, a kind of querying method of electric power system data of embodiment is provided, comprises the steps:
S200: obtain data inquiry request.
Wherein, data inquiry request comprises the template name of requesting query.In actual application, different time or different user may need the data of inquiry different, and by sending data inquiry request, request server sends the data needed for user, and server responds after getting data inquiry request, returns corresponding data.
S400: according to the template name of requesting query in data inquiry request, inquiry preset table template profile.
Wherein, preset table template profile comprises template name, main classes title, Property Name and Attribute expression, and the template name of the preset table template profile inquired is corresponding with the template name of inquiry request in data inquiry request.
In actual applications, first, need to be configured form template, namely the content of inquiring about may be needed to be configured to user, obtain preset table template profile.There is in data inquiry request the template name of requesting query, after server obtains data inquiry request, resolve the template name of requesting query wherein, in actual applications, in order to meet consumers' demand, many preset table template profile can be configured, owing to containing template name in preset table template profile, namely many template names can be produced, each preset table template profile is to there being a template name, need the preset template configuration file that query template title is corresponding with the template name of requesting query in data inquiry request in many preset template configuration files, namely the preset table template profile that inquiry is corresponding with template name in data inquiry request, when there is the template name identical with template name in data inquiry request in preset table template profile, then successful inquiring, the Property Name needing to obtain is included in this data inquiry request in this preset table template profile.
S600: according to the preset table template profile inquired, screens the default common information model data of electric system, obtains the selection result.
Wherein, the selection result is corresponding with preset table template profile.After inquiring the preset table template profile corresponding with template name in data inquiry request, the Property Name that this data inquiry request needs can be known, namely user needs the content of inquiry, thus according to the preset table template profile inquired, the default common information model data of electric system are screened, thus acquisition the selection result, namely obtain the data of user needed for this.
Common information model (CIM) is a conceptual model for describing management information had nothing to do with specific implementation, by CIM modeling, the abstract of entity can be obtained and represent, providing the association between a kind of object class, attribute and object class to carry out the method for presentation-entity.By obtaining the common information model of electric system to the modeling of electric system, the common information model of this electric system illustrates all main object classes of electric system, association between attribute and object class, the common information model of electric system includes the object class describing each conductive equipment of electric system, such as, reactor, electric capacity, transformer, switch, the object class such as bus and generator, also the object class such as transformer station and power supply administration can be comprised, the integrated of the management system application of different businessmans different product stand-alone development is facilitated by common information model.In screening process, template name in data inquiry request is in preset table masterplate configuration file, represent that the content that user needs to inquire about is pre-configured in preset table configuration file, main classes title in preset table template profile is corresponding with CIM class, can screen the content that preset table masterplate configuration file needed for user is corresponding.
S800: send the selection result.
After data needed for acquisition, be back to user, with for reference.
The querying method of above-mentioned electric power system data, be configured in preset table template profile by user being needed the Property Name inquired about, after receiving user's real data inquiry request, inquire corresponding preset table template profile, according to preset table template profile, the default common information model data of electric system are screened, obtain the selection result, can obtain user this want inquire about content.By the querying method of above-mentioned electric power system data, when carrying out the data query of multiple property content, owing to including template name in preset table template profile, main classes title, Property Name and Attribute expression, namely Property Name and the Attribute expression of the required inquiry of user is included, therefore user only need can obtain the content of user needed for this by the access of data query, user is without the need to passing through repeatedly queried access to obtain the content that in preset table template profile, Property Name is corresponding, greatly reduce queried access number of times, improve data access efficiency.
Refer to Fig. 2, wherein in an embodiment, also comprise before obtaining the step S200 of data inquiry request:
S100: according to historical empirical data and default common information model data, configuration form template, obtains preset table template profile.
Preset the object class containing each power equipment in electric system in common information model data, the concrete data such as attribute and association, in actual applications, user needs the content of inquiry more, according to historical empirical data, for often needing the data of inquiring about electric system, thus historical empirical data and default common information model data can be had more, configuration form masterplate obtains preset table masterplate configuration file, to meet user data query demand, the corresponding different preset table masterplate configuration file of different configurations, by repeatedly different configuration, obtain multiple preset table masterplate configuration file, for user's query demand.
Refer to Fig. 3, wherein in an embodiment, according to historical empirical data and default common information model data, configuration form template, also comprises after obtaining the step S100 of preset table template profile:
S210: when receiving template renewal request, requires according to template renewal and presets common information model data, upgrading preset table template profile, obtains the preset table template profile after upgrading.
When user needs new form template, and when the data in new form template are inquired about, need to configure new form template to meet user data query demand, now, according to template renewal request and default common information model data, preset table template profile can be upgraded, obtain the preset table template profile after upgrading, according to the preset table template profile after renewal, default public information template data can be screened, inquire content needed for user.
S220: when receiving real time data update instruction, according to real time data update instruction, upgrades default common information model data.
When in electric system, the data of equipment upgrade, namely real time data there occurs change, by real time data update instruction, upgrades default common information model data, realizes real time data and keeps synchronous with equipment True Data.
In one of them embodiment, according to historical empirical data and default common information model data, configuration form template, also comprises after obtaining preset table template profile S100:
The default common information model Data import of the electric system supported by preset table template profile is in internal memory.
In order to improve the response speed of client user's data inquiry request, the data supported by preset table template profile, in units of object, are loaded in internal memory by CIM class.Each object comprises the attribute that defines in CIM and associates, and can be conducted interviews by attribute or associated name.All objects are inquired about, by object identity quick position object, by the attribute value of Property Name query object, by the function of the object of associated name query object association opposite end by class name.
Refer to Fig. 4, wherein in an embodiment, data inquiry request also comprises the Property Name of selection, and preset table template profile also comprises main filtercondition, and Attribute expression carries level filtercondition.
According to the preset table template profile inquired, the default common information model data of electric system are screened, obtain the selection result step S600 and comprise:
S610: according to the Property Name selected, screen Property Name in the preset table template profile inquired, obtains the preset table template profile after screening.
In preset table template profile, Property Name is pre-configured, when the Property Name selected in data inquiry request is corresponding with all properties title in preset table template profile, illustrate that user wants to inquire about the content of all properties title in preset table template profile, in preset table template profile, Property Name is not required for user entirely, namely when the Property Name selected in data inquiry request is also not exclusively corresponding with all properties title in preset table template profile, only with all properties name portion in preset table template profile to the time in of corresponding need the Property Name according to selecting, Property Name in the preset table template profile inquired is screened, obtain the preset table template profile after screening.
S620: the level filtercondition carried according to preset table template profile, main filtercondition and the Attribute expression after screening, the default common information model data of electric system are screened, obtains the selection result corresponding with the preset table template profile after screening.
Multiple screening conditions may be had in preset table template profile, according to the Property Name in the preset table template profile after screening and the plurality of screening conditions, default common information model data can be screened, obtain the selection result.
Refer to Fig. 5, wherein in an embodiment, data inquiry request also comprises screening conditions.According to the preset table template profile inquired, the default common information model data of electric system are screened, also comprise after obtaining the step S600 of the selection result:
S700: during the screening conditions of carrying according to data inquiry request, the selection result is screened again, obtains the selection result again.
In order to ensure the reusability of preset table template profile, or user does not want for less difference configures different form template, such as user needs the main transformer high-pressure side obtaining 19 districts and cities respectively to gain merit data, if only use the form template of configuration to filter, then needs configuration 19 templates.Therefore, provide the ability supporting combined filtration, namely under the screening prerequisite performing step S300, also support that user carries screening conditions again by data inquiry request, these screening conditions by with the main filtercondition phase in template with, jointly determine the selection result that will return, namely after carried out screening acquisition the selection result by step S300, then according to the screening conditions that data inquiry request carries, the selection result is screened again, obtains the selection result again.
Be illustrated with the querying method of a specific embodiment to above-mentioned electric power system data below.
If only relate to a CIM class in a preset table template profile, such as transformer (PowerTransformer), so only need the attribute or the association that configure transformer, value is object identity, as the title (name) of transformer.To obtain 500kV transformer station title and affiliated power supply administration, configuration form template is as follows:
Table 1 configuration form template
The preset table template profile obtained is by template name, main classes title, main filtercondition and Property Name and Attribute expression composition, user data query request is described by XML language, because XML label can not start with numeral, during configuration form template, underscore is increased before template name 500kv, when template name in template name in data inquiry request and preset table masterplate configuration file can to success, represent the preset table masterplate configuration file existed needed for user, wherein, the preset table template profile content of configuration as shown in Figure 6.Wherein, main classes name is called Substation, is corresponding with CIM class, when namely transformer station's class being described in CIM class, the class title used is Substation, and can find corresponding class fast like this in screening process, transformer station and power supply administration are the Property Name that user need search.
User sends and carries the data inquiry request of template name for " _ 500kV transformer station ", and the selection result that server returns is " transformer station " and " power supply administration " in preset table template profile.Particularly, the XML language of 500kV substation data inquiry request describes as shown in Figure 7.The response message obtained is according to the data structure organization of preset table template profile, and the XML language of 500kV transformer station response message describes as shown in Figure 8, is the selection result XML language description that server returns, without the need to carrying out extra mapping and processing again.
If relate to the attribute value of multiple class in preset table template profile, the preset table template profile that such as transformer is corresponding needs transformer station's title belonging to display, configuration transformer station attribute is then needed to be MemberOf_EquipmentContainer.MemberOf_Substation.name, namely by two-stage upwards coordinate interrelation to the object of affiliated transformer station, show its name attribute.Owing to being upwards associated as monodrome association, therefore do not need to use level filtercondition.Such as, user needs to obtain main transformer list, comprise main transformer title, place transformer station, the electric pressure of transformer station and the power supply administration belonging to transformer station, existing way inquires about all transformers, then inquires about the interval at every platform main transformer place according to the association of CIM class respectively, then inquire about the transformer station at place, each interval, finally obtain all information, process is loaded down with trivial details, and user needs repeatedly to carry out data query, search efficiency.The technical scheme provided by the present embodiment can be obtained by a data inquiry request.With " main transformer " for template name configuration form, the preset table template profile content of main transformer as shown in Figure 9, wherein, title is the attribute of main classes PowerTransformer, electric pressure, transformer station and power supply administration are then the attributes having been pointed to transformer station (Substation) class by the association of two-stage monodrome, and are mapped as the field in form.User sends and carries the data inquiry request of template name for " main transformer ", and the XML language of main transformer data inquiry request describes as shown in Figure 10.The response message obtained is according to the data structure organization of preset table template profile, and the XML language of main transformer response message describes as shown in figure 11, finally returns to user with the form of list data.
If need the attribute of special object in main object respiratory sensation in preset table template profile, then need to specify concrete object by level filtercondition.The preset table template profile that such as transformer is corresponding needs high-pressure side to gain merit measuring value, then configuration attribute expression formula is ContainsMeasurements [name=P_H] .AnalogValues.value.Transformer is also two-stage association to measuring value, and two-stage is all many-valued association.Owing to there is multiple measurement in the first order, level filtercondition must be specified to be name=P_H, namely the measurement being called " P_H " is only named, although the association that the second level measures measuring value is many-valued association, but determine that its value only has one, then can not filter, acquiescence gets first, as monodrome association process.Such as, user needs main transformer high-pressure side to gain merit, corresponding preset table template profile content is gained merit as shown in figure 12 in main transformer high-pressure side, user sends and carries template name for the main transformer high-pressure side of " main transformer " gaining merit data inquiry request, and the gain merit XML language of data inquiry request of main transformer high-pressure side describes as shown in figure 13.The response message obtained according to the data structure organization of preset table template profile, main transformer high-pressure side gain merit response message XML language describe as shown in figure 14, finally return to user with the form of list data.
The filtercondition supported in form template configuration is divided into two kinds, and one is main filtercondition, such as, only obtain the main transformer in Foshan and Jiangmen, the second is configured in attribute to reach level filtercondition in formula, for screening many-valued association opposite end object, such as, only gets that high-pressure side is meritorious to be measured.Such as, with " gaining merit in main transformer high-pressure side, Jiangmen, Foshan " for template name configuration form, form template configuration file content is gained merit as shown in figure 15 in main transformer high-pressure side, Jiangmen, Foshan, as noun, template name with filtercondition only need be thought that server carries out data inquiry request by user, the description of data inquiry request XML language is gained merit as shown in figure 16 in main transformer high-pressure side, Jiangmen, Foshan.Main transformer high-pressure side, Jiangmen, Foshan gain merit response message XML language describe as shown in figure 17, finally return to user with the form of list data.
Except support target attribute and level attributes are as except filtercondition, also support using object type as filtercondition, user screens the service needed such as equipment or the measurement belonging to specified type equipment of specified type.Such as, with " main transformer measurement " for template name configuration form, main transformer measures form template configuration file content as shown in figure 18, as noun, template name with filtercondition only need be thought that server carries out data inquiry request by user, main transformer measures data inquiry request XML language and describes as shown in figure 19.The XML language that main transformer measures response message describes as shown in figure 20, finally returns to user with the form of list data.
In order to ensure the reusability that form template configures, or user does not want that such as user needs the main transformer high-pressure side obtaining 19 districts and cities respectively to gain merit data for less difference configuration different templates, if only use template to filter, then needs configuration 19 templates.Therefore, provide the ability supporting combined filtration, namely under the prerequisite performing main filtercondition and level screening conditions, also support that the filtercondition that user is carried by data inquiry request screens again, this filtercondition by with the main filtercondition phase in template with, jointly determine the data that will return.Such as, when screening above-mentioned main transformer measurement, carrying the data that screening conditions are Zhi Xu Foshan power supply administration in data inquiry request, then forming combined filtration.Or with " main transformer measurement " for template name configuration form, main transformer measures form template configuration file content as shown in figure 18, as noun, template name with filtercondition only need be thought that server carries out data inquiry request by user, the main transformer carrying screening conditions measures data inquiry request XML language and describes as shown in figure 21.The main transformer carrying screening conditions measures the XML language description of response message as shown in figure 22, finally returns to user with the form of list data.
If the real-time or history value of requirement measured value object in preset table template profile, and time timestamp, can be then mea:value and mea:time by the attribute configuration of measuring value, the high-pressure side of such as transformer real time data value expression formula of gaining merit be: ContainsMeasurements [name=P_H] .AnalogValues.mea:value.
Cache manager timing scan preset table template profile catalogue, when finding that there is new form template file, resolving new form template file, setting up the mapping table of template name and preset table template profile internal storage structure.Generate while resolution file and the CRC check value of log file, when next scanning document catalogue, if find that the CRC check value of this file changes, then representation file upgrades, and reloads this file.
In order to improve the response speed of client user's data inquiry request, the default common information model Data import of the electric system supported by preset table template profile is in internal memory.The data supported by preset table template profile, in units of object, are loaded in internal memory by CIM class.Each object comprises the attribute that defines in CIM and associates, and can be conducted interviews by attribute or associated name.All objects are inquired about, by object identity quick position object, by the attribute value of Property Name query object, by the function of the object of associated name query object association opposite end by class name.
Cache manager relies on GDA (GenericDataAccess, general test platform) interface and HSDA (HighSpeedDataAccess, the high-speed data is accessed) interface of electric power monitoring platform.When program starts, the model data that the disposable loading of cache manager all needs, and the incidence relation in internal memory between organization object, when model data changes, the model change events notice of cache manager response GDA interface, carries out local data according to the object identity of change synchronous.Cache manager subscribes to the real time data of electric power monitoring simultaneously by HSDA interface, when real time data changes, delta data can push and come by data server, and real time data can keep synchronous with real equipment.
After receiving data inquiry request, according to the template name of data inquiry request to the corresponding form template configuration file of inquiry, if do not found, then directly return the error message of inquiry noun.After finding form template configuration file, all objects of this CIM class in internal memory are inquired according to the main classes of form template configuration file, according to the filtercondition of asking to carry, in conjunction with the main filtercondition of template self, filter out all objects that current data inquiry request needs.For each object, it is each row organising data of data inquiry request.Resolve according to Attribute expression, IF expression is simple attribute or association, then directly obtain the attribute of existing object or the mark of affiliated partner.If Attribute expression is multi-level representation, and with level filtercondition, then to resolve step by step.
Situation is provided to judge the data that will return according to the beginning and ending time in data inquiry request.If data inquiry request does not provide the beginning and ending time, then return current real-time data, if provide only initial time, then inquire about and return the time point data of this time, if the beginning and ending time provides, then inquire about and return the historical data of this period of time.
Refer to Figure 23, a kind of inquiry system of electric power system data of embodiment be provided, comprise:
Acquisition module 200, for obtaining data inquiry request.
Wherein, data inquiry request comprises the template name of inquiry request.In actual application, different time or different user may need the data of inquiry different, and by sending data inquiry request, request server sends the data needed for user, and server responds after getting data inquiry request, returns corresponding data.
Enquiry module 400, for the template name according to inquiry request in data inquiry request, inquiry preset table template profile.
Wherein, preset table template profile comprises template name, main classes title, Property Name and Attribute expression, and the template name of the preset table template profile inquired is corresponding with the template name of inquiry request in data inquiry request.
In actual applications, first, need to be configured form template, namely the content of inquiring about may be needed to be configured to user, obtain preset table template profile.There is in data inquiry request the template name of requesting query, after server obtains data inquiry request, resolve the template name of requesting query wherein, in actual applications, in order to meet consumers' demand, many preset table template profile can be configured, owing to containing template name in preset table template profile, namely many template names can be produced, each preset table template profile is to there being a template name, need the preset template configuration file that query template title is corresponding with the template name of requesting query in data inquiry request in many preset template configuration files, namely the preset table template profile that inquiry is corresponding with template name in data inquiry request, when there is the template name identical with template name in data inquiry request in preset table template profile, then successful inquiring, the Property Name needing to obtain is included in this data inquiry request in this preset table template profile.
First screening module 600, for according to the preset table template profile inquired, screen the default common information model data of electric system, obtain the selection result, wherein, the selection result is corresponding with preset table template profile.
After inquiring the preset table template profile corresponding with the template name of inquiry request in data inquiry request, the Property Name that this data inquiry request needs can be known, namely user needs the content of inquiry, thus according to the preset table template profile inquired, the default common information model data of electric system are screened, thus acquisition the selection result, namely obtain the data of user needed for this.
Common information model (CIM) is a conceptual model for describing management information had nothing to do with specific implementation, by CIM modeling, the abstract of entity can be obtained and represent, providing the association between a kind of object class, attribute and object class to carry out the method for presentation-entity.By obtaining the common information model of electric system to the modeling of electric system, the common information model of this electric system illustrates all main object classes of electric system, association between attribute and object class, the common information model of electric system includes the object class describing each conductive equipment of electric system, such as, reactor, electric capacity, transformer, switch, the object class such as bus and generator, also the object class such as transformer station and power supply administration can be comprised, the integrated of the management system application of different businessmans different product stand-alone development is facilitated by common information model.In screening process, template name in data inquiry request is in preset table masterplate configuration file, represent that the content that user needs to inquire about is pre-configured in preset table configuration file, main classes title in preset table template profile is corresponding with CIM class, can screen the content that preset table masterplate configuration file needed for user is corresponding.
Sending module 800, for sending the selection result.
After data needed for acquisition, be back to user, with for reference.
The inquiry system of above-mentioned electric power system data, be configured in preset table template profile by user being needed the Property Name inquired about, after receiving user's real data inquiry request, inquire corresponding preset table template profile, according to preset table template profile, the default common information model data of electric system are screened, obtain the selection result, can obtain user this want inquire about content.By the inquiry system of above-mentioned electric power system data, when carrying out the data query of multiple property content, owing to including template name in preset table template profile, main classes title, Property Name and Attribute expression, namely Property Name and the Attribute expression of the required inquiry of user is included, therefore user only need can obtain the content of user needed for this by the access of data query, user is without the need to passing through repeatedly queried access to obtain the content that in preset table template profile, Property Name is corresponding, greatly reduce queried access number of times, improve data access efficiency.
Refer to Figure 24, wherein in an embodiment, the inquiry system of above-mentioned electric power system data also comprises:
Configuration module 100, for according to historical empirical data and default common information model data, configuration form template, obtains preset table template profile.
Preset the object class containing each power equipment in electric system in common information model data, the concrete data such as attribute and association, in actual applications, user needs the content of inquiry more, according to historical empirical data, for often needing the data of inquiring about electric system, thus historical empirical data and default common information model data can be had more, configuration form masterplate obtains preset table masterplate configuration file, to meet user data query demand, the corresponding different preset table masterplate configuration file of different configurations, by repeatedly different configuration, obtain multiple preset table masterplate configuration file, for user's query demand.
Wherein in an embodiment, the inquiry system of above-mentioned electric power system data also comprises:
First update module 210, for when receiving template renewal request, requiring according to template renewal and presetting common information model data, upgrading preset table template profile, obtaining the preset table template profile after upgrading.
When user needs new form template, and when the data in new form template are inquired about, need to configure new form template to meet user data query demand, now, according to template renewal request and default common information model data, preset table template profile can be upgraded, obtain the preset table template profile after upgrading, according to the preset table template profile after renewal, default public information template data can be screened, inquire content needed for user.
Second update module 220, for when receiving real time data update instruction, according to real time data update instruction, upgrades default common information model data.
When in electric system, the data of equipment upgrade, namely real time data there occurs change, by real time data update instruction, upgrades default common information model data, realizes real time data and keeps synchronous with equipment True Data.
In one of them embodiment, the inquiry system of above-mentioned electric power system data also comprises:
Load-on module, for the default common information model Data import of electric system supported by preset table template profile in internal memory.
In order to improve the response speed of client user's data inquiry request, the data supported by preset table template profile, in units of object, are loaded in internal memory by CIM class.Each object comprises the attribute that defines in CIM and associates, and can be conducted interviews by attribute or associated name.All objects are inquired about, by object identity quick position object, by the attribute value of Property Name query object, by the function of the object of associated name query object association opposite end by class name.
Refer to Figure 25, wherein in an embodiment, data inquiry request also comprises the Property Name of selection, and preset table template profile also comprises main filtercondition, and Attribute expression carries level filtercondition.
First screening module 600 comprises:
First screening unit 610, for according to the Property Name selected, screens Property Name in the preset table template profile inquired, obtains the preset table template profile after screening.
In preset table template profile, Property Name is pre-configured, when the Property Name selected in data inquiry request is corresponding with all properties title in preset table template profile, illustrate that user wants to inquire about the content of all properties title in preset table template profile, in preset table template profile, Property Name is not required for user entirely, namely when the Property Name selected in data inquiry request is also not exclusively corresponding with all properties title in preset table template profile, only with all properties name portion in preset table template profile to the time in of corresponding need the Property Name according to selecting, Property Name in the preset table template profile inquired is screened, obtain the preset table template profile after screening.
Second screening unit 620, for the level filtercondition carried according to preset table template profile, main filtercondition and the Attribute expression after screening, the default common information model data of electric system are screened, obtains the selection result corresponding with the preset table template profile after screening.
Multiple screening conditions may be had in preset table template profile, according to the Property Name in the preset table template profile after screening and the plurality of screening conditions, default common information model data can be screened, obtain the selection result.
Refer to Figure 26, wherein in an embodiment, data inquiry request also comprises screening conditions.The inquiry system of above-mentioned electric power system data also comprises:
Second screening module 700, for the screening conditions of carrying according to data inquiry request, again screens the selection result, obtains the selection result again.
In order to ensure the reusability of preset table template profile, or user does not want for less difference configures different form template, such as user needs the main transformer high-pressure side obtaining 19 districts and cities respectively to gain merit data, if only use the form template of configuration to filter, then needs configuration 19 templates.Therefore, provide the ability supporting combined filtration, namely under the screening prerequisite performing step S300, also support that user carries screening conditions again by data inquiry request, these screening conditions by with the main filtercondition phase in template with, jointly determine the selection result that will return, namely after carried out screening acquisition the selection result by step S300, then according to the screening conditions that data inquiry request carries, the selection result is screened again, obtains the selection result again.
Each technical characteristic of above embodiment can combine arbitrarily, for making description succinct, all possible combination of each technical characteristic in above-described embodiment is not all described, but, as long as the combination of these technical characteristics does not exist contradiction, be all considered to be the scope that this instructions is recorded.
Above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but can not therefore be construed as limiting the scope of the patent.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (10)
1. a querying method for electric power system data, is characterized in that, comprises the following steps:
Obtain data inquiry request, wherein, described data inquiry request comprises the template name of requesting query;
According to the template name of requesting query described in described data inquiry request, inquiry preset table template profile, wherein, described preset table template profile comprises template name, main classes title, Property Name and Attribute expression;
According to the described preset table template profile inquired, screen the default common information model data of electric system, obtain the selection result, wherein, described the selection result is corresponding with described preset table template profile;
Send described the selection result.
2. the querying method of electric power system data according to claim 1, is characterized in that, also comprises before the step of described acquisition data inquiry request:
According to historical empirical data and described default common information model data, configuration form template, obtains described preset table template profile.
3. the querying method of electric power system data according to claim 2, it is characterized in that, described according to historical empirical data and described default common information model data, configuration form template, also comprises after obtaining the step of described preset table template profile:
When receiving template renewal request, requiring and described default common information model data according to described template renewal, described preset table template profile is upgraded, obtain the described preset table template profile after upgrading;
When receiving real time data update instruction, according to described real time data update instruction, described default common information model data are upgraded.
4. the querying method of electric power system data according to claim 1, it is characterized in that, described data inquiry request also comprises the Property Name of selection, and described preset table template profile also comprises main filtercondition, and described Attribute expression carries level filtercondition;
The described preset table template profile that described basis inquires, screens the default common information model data of electric system, and the step obtaining the selection result comprises:
According to the Property Name of described selection, Property Name described in the described preset table template profile inquired is screened, obtain the described preset table template profile after screening;
According to the described level filtercondition that the described preset table template profile after described screening, described main filtercondition and described Attribute expression carry, the described default common information model data of described electric system are screened, obtains the described the selection result corresponding with the described preset table template profile after described screening.
5. the querying method of electric power system data according to claim 1, it is characterized in that, described data inquiry request also comprises screening conditions, the described preset table template profile that described basis inquires, the default common information model data of electric system are screened, also comprise after obtaining the step of the selection result:
According to the screening conditions that described data inquiry request carries, described the selection result is screened again, obtain the selection result again.
6. an inquiry system for electric power system data, is characterized in that, comprising:
Acquisition module, for obtaining data inquiry request, wherein, described data inquiry request comprises the template name of requesting query;
Enquiry module, for the template name according to requesting query described in described data inquiry request, inquiry preset table template profile, wherein, described preset table template profile comprises template name, main classes title, Property Name and Attribute expression;
First screening module, for according to the described preset table template profile inquired, screen the default common information model data of electric system, obtain the selection result, wherein, described the selection result is corresponding with described preset table template profile;
Sending module, for sending described the selection result.
7. the inquiry system of electric power system data according to claim 6, is characterized in that, also comprises:
Configuration module, for according to historical empirical data and described default common information model data, configuration form template, obtains described preset table template profile.
8. the inquiry system of electric power system data according to claim 7, is characterized in that, also comprises:
First update module, for when receiving template renewal request, require and described default common information model data according to described template renewal, described preset table template profile is upgraded, obtain the described preset table template profile after upgrading;
Second update module, for when receiving real time data update instruction, according to described real time data update instruction, upgrades described default common information model data.
9. the inquiry system of electric power system data according to claim 6, it is characterized in that, described data inquiry request also comprises the Property Name of selection, and described preset table template profile also comprises main filtercondition, and described Attribute expression carries level filtercondition;
Described first screening module comprises:
First screening unit, for the Property Name according to described selection, screens Property Name described in the described preset table template profile inquired, obtains the described preset table template profile after screening;
Second screening unit, for the described level filtercondition carried according to the described preset table template profile after described screening, described main filtercondition and described Attribute expression, the described default common information model data of described electric system are screened, obtains the described the selection result corresponding with the described preset table template profile after described screening.
10. the inquiry system of electric power system data according to claim 6, is characterized in that, described data inquiry request also comprises screening conditions, and the inquiry system of described electric power system data also comprises:
Second screening module, for the screening conditions of carrying according to described data inquiry request, again screens described the selection result, obtains the selection result again.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510870371.XA CN105426516A (en) | 2015-11-30 | 2015-11-30 | Power system data query method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510870371.XA CN105426516A (en) | 2015-11-30 | 2015-11-30 | Power system data query method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105426516A true CN105426516A (en) | 2016-03-23 |
Family
ID=55504728
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510870371.XA Pending CN105426516A (en) | 2015-11-30 | 2015-11-30 | Power system data query method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105426516A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106776893A (en) * | 2016-11-30 | 2017-05-31 | 浪潮通信信息系统有限公司 | A kind of data output method and device |
| CN107346320A (en) * | 2016-05-06 | 2017-11-14 | 北京神州泰岳软件股份有限公司 | A kind of data calling method and device |
| CN107451188A (en) * | 2017-06-26 | 2017-12-08 | 中国电力科学研究院 | A kind of dissemination method and system of power grid regulation model data multistage combination of nodes |
| CN107885878A (en) * | 2017-11-29 | 2018-04-06 | 广东电网有限责任公司电力科学研究院 | A kind of power network CIM data query method, client, server and system |
| CN107908628A (en) * | 2017-06-12 | 2018-04-13 | 上海壹账通金融科技有限公司 | Electronic device, information inquiry control method and computer-readable recording medium |
| CN108345638A (en) * | 2018-01-08 | 2018-07-31 | 广东电网有限责任公司信息中心 | A kind of dissemination method, the apparatus and system of the associated measuring value of power system resource |
| CN108491448A (en) * | 2018-02-24 | 2018-09-04 | 北京天元创新科技有限公司 | A kind of method and apparatus of data-pushing |
| CN108509574A (en) * | 2018-03-27 | 2018-09-07 | 广州供电局有限公司 | Facility information search method, device and computer equipment |
| CN108829651A (en) * | 2018-04-17 | 2018-11-16 | 平安科技（深圳）有限公司 | A kind of method, apparatus of document treatment, terminal device and storage medium |
| CN109635350A (en) * | 2018-11-16 | 2019-04-16 | 海南电网有限责任公司电力科学研究院 | A kind of data replacement method that the trend section for emulation automatically generates and system |
| CN113220950A (en) * | 2021-05-19 | 2021-08-06 | 国网浙江省电力有限公司湖州供电公司 | Electricity price query system and electricity price query method |
| CN115203172A (en) * | 2022-06-30 | 2022-10-18 | 北京亚控科技发展有限公司 | Model construction method, model data subscription method, model construction device, model data subscription device, electronic equipment and medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2009082388A1 (en) * | 2007-12-20 | 2009-07-02 | Hewlett-Packard Development Company, L.P. | Modelling computer based business process for customisation and delivery |
| CN103617255A (en) * | 2013-11-29 | 2014-03-05 | 国网电网公司 | Service data exchange synchronizing system and method used for electric information system |
| CN104573960A (en) * | 2015-01-09 | 2015-04-29 | 云南电力调度控制中心 | Novel electric power dispatching statement solution |
-
2015
- 2015-11-30 CN CN201510870371.XA patent/CN105426516A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2009082388A1 (en) * | 2007-12-20 | 2009-07-02 | Hewlett-Packard Development Company, L.P. | Modelling computer based business process for customisation and delivery |
| CN103617255A (en) * | 2013-11-29 | 2014-03-05 | 国网电网公司 | Service data exchange synchronizing system and method used for electric information system |
| CN104573960A (en) * | 2015-01-09 | 2015-04-29 | 云南电力调度控制中心 | Novel electric power dispatching statement solution |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107346320B (en) * | 2016-05-06 | 2020-09-01 | 北京神州泰岳软件股份有限公司 | Data calling method and device |
| CN107346320A (en) * | 2016-05-06 | 2017-11-14 | 北京神州泰岳软件股份有限公司 | A kind of data calling method and device |
| CN106776893A (en) * | 2016-11-30 | 2017-05-31 | 浪潮通信信息系统有限公司 | A kind of data output method and device |
| CN107908628A (en) * | 2017-06-12 | 2018-04-13 | 上海壹账通金融科技有限公司 | Electronic device, information inquiry control method and computer-readable recording medium |
| CN107451188A (en) * | 2017-06-26 | 2017-12-08 | 中国电力科学研究院 | A kind of dissemination method and system of power grid regulation model data multistage combination of nodes |
| CN107885878A (en) * | 2017-11-29 | 2018-04-06 | 广东电网有限责任公司电力科学研究院 | A kind of power network CIM data query method, client, server and system |
| CN108345638A (en) * | 2018-01-08 | 2018-07-31 | 广东电网有限责任公司信息中心 | A kind of dissemination method, the apparatus and system of the associated measuring value of power system resource |
| CN108491448B (en) * | 2018-02-24 | 2021-06-04 | 北京天元创新科技有限公司 | Data pushing method and device |
| CN108491448A (en) * | 2018-02-24 | 2018-09-04 | 北京天元创新科技有限公司 | A kind of method and apparatus of data-pushing |
| CN108509574B (en) * | 2018-03-27 | 2019-12-10 | 广州供电局有限公司 | Equipment information retrieval method and device and computer equipment |
| CN108509574A (en) * | 2018-03-27 | 2018-09-07 | 广州供电局有限公司 | Facility information search method, device and computer equipment |
| CN108829651A (en) * | 2018-04-17 | 2018-11-16 | 平安科技（深圳）有限公司 | A kind of method, apparatus of document treatment, terminal device and storage medium |
| CN109635350A (en) * | 2018-11-16 | 2019-04-16 | 海南电网有限责任公司电力科学研究院 | A kind of data replacement method that the trend section for emulation automatically generates and system |
| CN109635350B (en) * | 2018-11-16 | 2024-01-05 | 海南电网有限责任公司电力科学研究院 | Data replacement method and system for automatically generating simulated power flow section |
| CN113220950A (en) * | 2021-05-19 | 2021-08-06 | 国网浙江省电力有限公司湖州供电公司 | Electricity price query system and electricity price query method |
| CN115203172A (en) * | 2022-06-30 | 2022-10-18 | 北京亚控科技发展有限公司 | Model construction method, model data subscription method, model construction device, model data subscription device, electronic equipment and medium |
| CN115203172B (en) * | 2022-06-30 | 2023-11-07 | 北京亚控科技发展有限公司 | Model construction and model data subscription method and device, electronic equipment and medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105426516A (en) | Power system data query method and system | |
| CN108090165B (en) | Method for acquiring map change difference based on embedded graph database | |
| CN110515522B (en) | Access method and device of equipment data, computer equipment and storage medium | |
| CN110310198B (en) | Enterprise quota information management method, device, equipment and readable storage medium | |
| CN110968629A (en) | Cross-hierarchy heterogeneous data aggregation-based unified information resource management method and system | |
| CN109327559A (en) | A kind of domain name analytic method and device based on mixing cloud platform | |
| CN105868170A (en) | Method for generating industrial data report in server | |
| CN111090803A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN102571427A (en) | Method for naming and analyzing CIM (common information model) resources in distributed systems | |
| CN102982034A (en) | Internet website information search method and search system | |
| CN104509029A (en) | Method and apparatus for updating personal information in communication system | |
| CN113435832A (en) | Instrument digital delivery system and method based on industrial internet identification analysis | |
| CN117527896A (en) | Method and system for interfacing multi-system data with third party electronic files | |
| CN115203709B (en) | Method and device for constructing safety index verification system, computer equipment and medium | |
| CN103713903A (en) | Hard disk dynamic loading method and device | |
| CN110737879A (en) | Website copyright time management method and device, storage medium and equipment | |
| CN110247989A (en) | The geographical position information acquisition method and system of smart home device | |
| CN109088779A (en) | Device service test method and radio testing systems | |
| CN109447844A (en) | A kind of management method of electronization test report | |
| CN102508926A (en) | Catalog data parsing method and system | |
| CN102571405A (en) | Method and device for acquiring resource information | |
| CN101330526A (en) | Method, system and WAP gateway server for dispatching web page | |
| CN101453692B (en) | Mobile data content processing method and system | |
| CN111338518A (en) | Software design system and method based on position automatic discovery | |
| CN108345638A (en) | A kind of dissemination method, the apparatus and system of the associated measuring value of power system resource |
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 |
Application publication date: 20160323 |
|
| RJ01 | Rejection of invention patent application after publication |