CN103838827A - Correlation method of records in power grid control information management system - Google Patents
Correlation method of records in power grid control information management system Download PDFInfo
- Publication number
- CN103838827A CN103838827A CN201410035409.7A CN201410035409A CN103838827A CN 103838827 A CN103838827 A CN 103838827A CN 201410035409 A CN201410035409 A CN 201410035409A CN 103838827 A CN103838827 A CN 103838827A
- Authority
- CN
- China
- Prior art keywords
- record
- records
- event identifier
- management system
- information management
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a correlation method of records in a power grid control information management system. The method is used for managing the records in the power grid control information management system. Each record has a globally unique identifier and an event identification field, and the globally unique identifiers in the records are different. The method includes the following steps that firstly, all the records are sequenced according to the event identification fields, and then the records with the same event identification fields are continuously ranked; secondly, the records with the same event identification fields are secondarily sequenced; thirdly, all the event identification fields are sequenced; fourthly, the records with the same event identification fields are used as correlation units, and all the correlation units are ranked according to the sequencing result of the event identification fields. According to the method, the display mode of log information of an existing power grid control information management system can be improved, and the problem of discrete display of the records, belonging to the same events, in the power grid control information management system is solved.
Description
Technical field
The present invention relates to electrical network regulation and controlling of information management domain, be specifically related to a kind of electrical network regulation and controlling of information management system and record correlating method.
Background technology
At present, electrical network regulation and controlling of information management system has PI2000, PSMS, DPMS, the systems such as OMS, in these systems, the typing of information adopts running account form typing, the demonstration of record is according to certain column data ascending order or descending sort, each information does not possess correlativity in data plane, because regulation and controlling of information management system has recorded each event handler procedure of electrical network, each the record that reflects same event handler procedure shows with discrete state, belong to the discontinuous demonstration of recording of same event handler procedure, intersect demonstration with other logouts, in this case, check the event handler procedure of a discontinuous demonstration, this is more time-consuming also effort for the people of travel log.
Summary of the invention
Technical matters to be solved by this invention is to provide a kind of electrical network regulation and controlling of information management system to record correlating method, can improve the display mode of current electrical network regulation and controlling of information management system log information, solve in electrical network regulation and controlling of information management system and belong to the discrete demonstration problem of recording of same event.
For solving above-mentioned existing technical matters, the present invention adopts following scheme: a kind of electrical network regulation and controlling of information management system records correlating method, for managing the record of electrical network regulation and controlling of information management system, every record all has a Globally Unique Identifier and an event identifier field, the Globally Unique Identifier of every record is all not identical, comprise the following steps
Step 1, all records sort according to event identifier field, make to have the continuous arrangement that records of similar events identification field;
Step 2, the record with similar events identification field is carried out to two minor sorts;
Step 3, all event identifier fields are sorted;
Step 4, using the record with similar events identification field as an associative cell, all associative cells are arranged according to the ranking results of event identifier field.
As preferably, further comprising the steps of: step 5, the record with similar events identification field to be shown, shown with different colours having between the record of different event identification field with same color.
As preferably, described record comprises an objective record and a source record, the method that target record is associated with source record is as follows: first choose source record, obtain the event identifier field of source record, choose again target record, the event identifier field of target record is become to the event identifier field of obtained source record.
As preferably, described record comprises a source record, and the method for the typing new record associated with source record is as follows: first choose source record, the regeneration event identifier field new record identical with the event identifier field of source record.
As preferably, every record includes at least two information fields, and described event identifier field is one of them information field.
Beneficial effect:
The present invention adopts a kind of electrical network regulation and controlling of information management system that technique scheme provides to record correlating method, 1, the record that belongs to same event handler procedure originally disperseing is carried out to association, it is concentrated continuously shows, check that recording of certain event procedure is very clear, without searching in addition, alleviate the workload that records viewer; 2, record is operation associated easy, does not increase operator on duty's additional workload, has improved efficiency of inputting and the quality of record.
Accompanying drawing explanation
Fig. 1 is the sortord recording in existing electrical network regulation and controlling of information management system;
Fig. 2 be in the present invention, record 1, sortord after record 4, record 5 associations;
Fig. 3 be in the present invention, record 1, sortord after the associated and record 2 of record 4, record 5, record 6 associations;
Fig. 4 is the operational flowchart that in system of the present invention, other records are associated to a certain record in system;
Fig. 5 is the operational flowchart of the newly-increased record of the present invention.
Embodiment
A kind of electrical network regulation and controlling of information management system records correlating method, in the time that the typing of electrical network regulation and controlling of information management system is recorded, every record is its Globally Unique Identifier of coupling and event identifier field, Globally Unique Identifier is in order to the uniqueness of identification record, even difference is come between every record, Globally Unique Identifier can be a GUID field, also can be the compound fields of the identification record uniqueness that multiple field combination form, event identifier field is in order to the event ownership of identification record, as the reason of institute's recording events, place, personnel etc., there is the associated associated record that forms of record of similar events identification field.Certainly every record information field of other field informations in addition, as the start time information of writing time, end time information, account type, unit information, content information etc., event identifier field is one of them information field.
This correlating method is as follows,
Step 1, all records sort according to event identifier field, make to have the continuous arrangement that records of similar events identification field;
Step 2, the record with similar events identification field is carried out to two minor sorts according to ordering rule I, ordering rule I can be initial order, numerical values recited order, average size order and the time order and function order etc. that are recorded in information under certain information field according to all;
Step 3, all event identifier fields are sorted according to ordering rule II, ordering rule II can be initial order, numerical values recited order, average size order and the time order and function order etc. of event identifier field;
Step 4, using the record with similar events identification field as an associative cell, all associative cells are arranged according to the ranking results of event identifier field.
Wherein, the record that has a similar events identification field shows, has with same color between the record of different event identification field and shows with different colours.
As shown in Figure 4, record comprises an objective record and a source record, the method that target record is associated with source record is as follows: first choose source record, obtain the event identifier field of source record, choose again target record, the event identifier field of target record is become to the event identifier field of obtained source record.Record B and record A as, record comprises, by recording, the B method associated with recording A is as follows: first choose and record A, obtain the event identifier field that records A, then choose and record B, the event identifier field that records B is set to record the event identifier field of A.
As shown in Figure 5, record comprises a source record, and the method for the typing new record associated with source record is as follows: first choose source record, the regeneration event identifier field new record identical with the event identifier field of source record.As, record comprises and records A, need typing new record C, the typing method that record C associated with recording A is as follows: first choose and record A, carry out associated newly-increased operation (associated newly-increased, refer to that the event identifier information of this newly-increased record in increasing a record is set to the event identifier information of source record), what system generation event identifier field was identical with the event identifier field that records A records C.
For example, in electrical network regulation and controlling of information management system, store record 1, record 2, record 3, record 4, record 5, record 6, every record all records initial time, end time, account type, handler unit, the handler of event and the information fields such as content of keeping record, the arrangement mode recording in common electrical network regulation and controlling of information management system as shown in Figure 1, is the arrangement take the time as order.And in the present invention, common electrical network regulation and controlling of information management system is improved, by increase program or chip, make original electrical network regulation and controlling of information management system adopt control method of the present invention, the sortord shown in Fig. 1 can be changed into the sortord shown in Fig. 2.In Fig. 2, in the time that all records are all unconnected, all records are arranged take initial time as order, need to carry out when operation associated, as must be recorded 4, record 5 is associated to source record record 1 so that record 1, record 4, while recording 5 continuous arrangement, operator selects record 1 at operation interface, there is actions menu in system, selection copies related information, the event identifier field of system acquisition record 1, then select record 4, again there is actions menu in system, select to paste related information, the event identifier field of record 4 is the same with the event identifier field of record 1, now record 41 associated with record, record 4 is consistent with the background color of record 1, select again record 5, again there is actions menu in system, select to paste related information, the event identifier field of record 5 is the same with the event identifier field of record 1, now record 5 also 1 associated with record, record 5 is also consistent with the background color of record 1, choose again the refresh button of operation interface, system judges the event identifier field of all records in system, make event identifier field identical record continuous arrangement, now record 4, record 5 and record 1 continuous arrangement, simultaneously, system is to recording 4, record 5 with record 1 according to ordering rule I (as recorded 4, record 5 and the initial order that records certain information field first character in 1, numerical values recited, time sequencing etc.) sort, simultaneity factor will record 1, record 4, record 5 is as an associative cell, to record 2 as an associative cell, to record 3 as an associative cell, to record 6 as an associative cell, system (also can be the initial order of the first character of event identifier field by the event identifier field of all associative cells by ordering rule II, numerical values recited, time sequencing etc.) sort, all associative cells are arranged according to the ranking results of event identifier field.As must be recorded 2 again, record 6 associations and make to record 2, when record 6 shows continuously, while becoming sortord as shown in Figure 3 by the sortord shown in Fig. 2, operator selects record 2 at operation interface, there is actions menu in system, selection copies related information, the event identifier field of system acquisition record 2, then select record 6, again there is actions menu in system, select to paste related information, the event identifier field of record 6 is the same with the event identifier field of record 2, now record 62 associated with record, the background color of record 6 is consistent with the background color of record 2, choose again the refresh button of operation interface, now record 2, record 6 continuous arrangements, meanwhile, system just records 1, record 4, record 5 be as an associative cell, will record 2, and record 6 as an associative cell, will record 3 as an associative cell, sorts according to the event identifier field of each associative cell.Typing as new in need and record 3 records that are associated 7, choose record 3, there is actions menu in operation interface, select associated newly-increased operation, now system generates new record 7 automatically, the content of operator's typing relevant information field, after new record 7 typings complete, show together continuously with record 3 and show with identical background color with record 3, if no longer typing new record, exit operation, if also need typing new record 8, continue to select associated newly-increased operation, now system generates new record 8 automatically, the content of operator's typing relevant information field, now record 8 with record 3, record 7 show together continuously and with record 3, record 7 shows with identical background color, simultaneity factor will record 3, record 7, record 8 rearranges together with other associative cells as same associative cell.
In this embodiment, for convenience of showing, user can be seen more intuitively, the event identifier field of system using the content under each record account type information field as this record, what the content in type item of keeping record was identical is recorded as associated record.As record 1, content is " accident, obstacle and abnormal " in the account type item of record 4, record 5, its event identifier field is also " accident, obstacle and abnormal ".
Claims (5)
1. electrical network regulation and controlling of information management system records correlating method, for managing the record of electrical network regulation and controlling of information management system, every record all has a Globally Unique Identifier and an event identifier field, and the Globally Unique Identifier of every record is all not identical, it is characterized in that: comprise the following steps
Step 1, all records sort according to event identifier field, make to have the continuous arrangement that records of similar events identification field;
Step 2, the record with similar events identification field is carried out to two minor sorts;
Step 3, all event identifier fields are sorted;
Step 4, using the record with similar events identification field as an associative cell, all associative cells are arranged according to the ranking results of event identifier field.
2. electrical network regulation and controlling of information management system according to claim 1 records correlating method, it is characterized in that: further comprising the steps of: step 5, the record with similar events identification field is shown with same color, show with different colours having between the record of different event identification field.
3. electrical network regulation and controlling of information management system according to claim 1 and 2 records correlating method, it is characterized in that: described record comprises an objective record and a source record, the method that target record is associated with source record is as follows: first choose source record, obtain the event identifier field of source record, choose again target record, the event identifier field of target record is become to the event identifier field of obtained source record.
4. electrical network regulation and controlling of information management system according to claim 1 and 2 records correlating method, it is characterized in that: described record comprises a source record, the method of the typing new record associated with source record is as follows: first choose source record, the regeneration event identifier field new record identical with the event identifier field of source record.
5. electrical network regulation and controlling of information management system according to claim 1 and 2 records correlating method, it is characterized in that: every record includes at least two information fields, and described event identifier field is one of them information field.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410035409.7A CN103838827A (en) | 2014-01-24 | 2014-01-24 | Correlation method of records in power grid control information management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410035409.7A CN103838827A (en) | 2014-01-24 | 2014-01-24 | Correlation method of records in power grid control information management system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103838827A true CN103838827A (en) | 2014-06-04 |
Family
ID=50802324
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410035409.7A Pending CN103838827A (en) | 2014-01-24 | 2014-01-24 | Correlation method of records in power grid control information management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103838827A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105260464A (en) * | 2015-10-16 | 2016-01-20 | 北京奇虎科技有限公司 | Data storage structure conversion method and apparatus |
| CN108763363A (en) * | 2018-05-17 | 2018-11-06 | 阿里巴巴集团控股有限公司 | A kind of method and device for examining record to be written |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1472633A (en) * | 2002-07-30 | 2004-02-04 | 英业达股份有限公司 | Device and method for data classification |
| CN100426285C (en) * | 2002-07-12 | 2008-10-15 | 约翰·钟·李 | Method to organize and track information according to chronological and priority order |
| CN102572109A (en) * | 2005-04-01 | 2012-07-11 | 三星电子株式会社 | Device and method for managing event information in wireless terminal |
| CN102782679A (en) * | 2010-02-19 | 2012-11-14 | 日本电气株式会社 | Event information management system, event management method and program |
-
2014
- 2014-01-24 CN CN201410035409.7A patent/CN103838827A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100426285C (en) * | 2002-07-12 | 2008-10-15 | 约翰·钟·李 | Method to organize and track information according to chronological and priority order |
| CN1472633A (en) * | 2002-07-30 | 2004-02-04 | 英业达股份有限公司 | Device and method for data classification |
| CN102572109A (en) * | 2005-04-01 | 2012-07-11 | 三星电子株式会社 | Device and method for managing event information in wireless terminal |
| CN102782679A (en) * | 2010-02-19 | 2012-11-14 | 日本电气株式会社 | Event information management system, event management method and program |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105260464A (en) * | 2015-10-16 | 2016-01-20 | 北京奇虎科技有限公司 | Data storage structure conversion method and apparatus |
| CN105260464B (en) * | 2015-10-16 | 2018-09-07 | 北京奇虎科技有限公司 | The conversion method and device of data store organisation |
| CN108763363A (en) * | 2018-05-17 | 2018-11-06 | 阿里巴巴集团控股有限公司 | A kind of method and device for examining record to be written |
| CN108763363B (en) * | 2018-05-17 | 2022-02-18 | 创新先进技术有限公司 | Method and device for checking record to be written |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103220412B (en) | Mobile terminal schedule management method and system | |
| CN102270225A (en) | Data change log monitoring method and device | |
| CN102479223A (en) | Data query method and system | |
| CN111177556A (en) | Scientific and technological achievement transformation system and method | |
| CN203165012U (en) | Laboratory sample storage location management system | |
| CN105812175B (en) | Resource management method and resource management equipment | |
| CN103559317B (en) | Word mask method and system thereof are cut in a kind of mixing of comprehensive video metamessage | |
| CN103152416B (en) | A kind of dynamic management approach for improving online collection group high availability energy | |
| US20130218889A1 (en) | Supervisor history view wizard | |
| CN111966677A (en) | Data report processing method and device, electronic equipment and storage medium | |
| CN107451269A (en) | A kind of user behavior analysis method based on big data | |
| CN103455498B (en) | A kind of form keyword message localization method based on hypertext | |
| CN103235811A (en) | Data storage method and device | |
| CN104699857A (en) | Big data storage method based on knowledge engineering | |
| CN113612306A (en) | Distributed power distribution cabinet and control system thereof | |
| CN103838937A (en) | Energy consumption simulation modeling system | |
| CN113505265A (en) | Data query method and device, electronic equipment, storage medium and program product | |
| CN103838827A (en) | Correlation method of records in power grid control information management system | |
| CN103744880B (en) | A kind of DNA data managing methods and system based on cloud computing | |
| CN110389944B (en) | Metadata management system and method based on model | |
| CN104378239A (en) | Rapid reliability index statistical system and method based on cluster frame | |
| CN111858739A (en) | Mapreduce-based data aggregation method and system | |
| CN102855297B (en) | A kind of method of control data transmission and connector | |
| CN111666263A (en) | Method for realizing heterogeneous data management in data lake environment | |
| CN110826845A (en) | Multidimensional combination cost allocation device and method |
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: 20140604 |
|
| RJ01 | Rejection of invention patent application after publication |