CN101739733A - Substation inspection management system-based data interaction control method - Google Patents
Substation inspection management system-based data interaction control method Download PDFInfo
- Publication number
- CN101739733A CN101739733A CN200810195291A CN200810195291A CN101739733A CN 101739733 A CN101739733 A CN 101739733A CN 200810195291 A CN200810195291 A CN 200810195291A CN 200810195291 A CN200810195291 A CN 200810195291A CN 101739733 A CN101739733 A CN 101739733A
- Authority
- CN
- China
- Prior art keywords
- data
- logging
- terminal
- machine
- reference numeral
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a substation inspection management system-based data interaction control method, which belongs to the technical field of substation inspection management. The method mainly comprises the following steps: establishing a database containing a basic data sheet, a deletion record sheet and an inspection instrument sheet in a computer; establishing the database containing an inspection instrument data sheet in an inspection instrument terminal; when entering data interaction, filtering data which has not been interacted by comparing; writing the filtered data into an on-line inspection instrument terminal in a mode of adding or covering; simultaneously, filtering and deleting the data which has not been deleted in the on-line inspection instrument terminal; and ending the interaction until finishing transmitting all survival data filtered by the computer. The interaction control method completely avoids repeated interaction of the data through skilful and rational control processing, and only records effective, modified or deleted data into the inspection instrument terminal, thereby greatly reducing data transmission quantity, obviously shortening interaction time and improving the work efficiency of inspection.
Description
Technical field
The present invention relates to a kind of data interaction control method, especially a kind of data interaction control method based on substation inspection management system belongs to power transformation inspection management technical field.
Background technology
Carrying out data interaction between logging terminal and PC is important process in the substation inspection process.Understand according to the applicant, for a long time, the data interaction of substation inspection system is all carried out in the following way: the logging terminal is with after PC is connected, and system records all data messages (this information comprises Unit account of plant data in the power transformation cruising inspection system, personal information, teams and groups' information etc.) in the logging terminal.Along with the development of electric utility, this process time day by day prolongs, to such an extent as to " seemingly-dead " phenomenon usually occurs.
Summary of the invention
The present invention wants the technical solution problem to be: at the shortcoming that above prior art exists, propose a kind ofly can shorten the mutual time greatly, significantly improve the data interaction control method based on substation inspection management system of work efficiency.
The applicant is through careful close examination and in-depth analysis to the data interactive history, find that elongated basic reason of data interaction time is: computing machine is when carrying out data interaction, do not control judgement, take mode, therefore the repeated interaction phenomenon that exists workload day by day to increase to the renewal of logging terminal total data always.Therefore, the approach that addresses the above problem should be only effectively, modification is arranged, the data recording of deleting is in the logging terminal.
In order to solve above technical matters, the data interaction control method based on substation inspection management system of the present invention may further comprise the steps:
1), in as the computing machine (PC or workstation) of processing enter, set up the database that contains following each table:
---base data table is used to write down and contains every relevant information in deposit data reference numeral ID1 and final updating time T 1;
---the deletion record table is used to write down the relevant information that contains every deleted data reference numeral ID2 and deletion time T 2;
---patrol and examine instrument, be used to write down each logging terminal reference numeral and last data interaction time T 3 thereof;
2), in each logging terminal, set up the database that contains following table:
---the logging tables of data is used to write down and contains every relevant information at deposit data reference numeral ID3;
3), when logging terminal and computing machine being connected machine enter the data interaction state, computer filters goes out numbering at deposit data of final updating time T 1 in the base data table＞company's last data interaction time T 3 of machine logging terminal, and the deleted data of deletion time T 2＞last data interaction time T 3 of company's machine logging terminal is numbered in the deletion record table, by relatively discerning with the numbering of logging tables of data corresponding data, renewal or deletion connect the corresponding data in the machine logging terminal, until finishing the processing that all leaches data.
During concrete enforcement, in the above step 3), computing machine is pressed predefined procedure by following two groups of steps that are made of 4-1,4-2 and 4-1 ', 4-2 ' respectively, finishes the processing of filtering and leaching data:
4-1, transfer in the base data table in the final updating time T 1 of deposit data one by one and patrol and examine the corresponding last data interaction time T 3 that connects machine logging terminal number in the instrument, each bar that filters out whole final updating time T 1＞last data interaction time T 3 after comparing is at deposit data reference numeral ID1---and this batch data is the data that increase newly or revised after the data interaction time T the last time 3;
4-2, read the reference numeral ID1 that filters out one by one at deposit data, with its with connect every of logging tables of data in the machine logging terminal in the reference numeral ID3 of deposit data contrast; If there is not identical numbering in the logging tables of data, represent that then these data are that computing machine increases newly, directly will number corresponding data and when mutual, write even machine logging terminal, and its numbering will be increased in the logging tables of data to increase mode; If there is identical numbering in the logging tables of data, then expression connects existing these data of machine logging terminal, but is not up-to-date, directly it is write even machine logging terminal with coverage mode when mutual; Go out transmission until finishing whole computer filters at deposit data;
4-1 ', the last data interaction time T 3 of transferring the deletion time T 2 of deleted data correspondence in the deletion record table and connecting logging tables of data in the machine logging terminal one by one filter out the reference numeral ID2 of the deleted data of each bar of whole deleted time T 2＞last data interaction time T 3 after comparing---and this batch data is the data of deletion after the data interaction time T the last time 3;
4-2 ', read the reference numeral ID2 of the deleted data that filter out one by one, it is contrasted with every the reference numeral ID3 at deposit data of logging tables of data that connects in the machine logging terminal, if there is not identical numbering in the logging tables of data, represent that then these data do not exist, and keep present situation in connecting machine logging terminal; If there is identical numbering in the logging tables of data, then will connect this data deletion in the machine logging terminal; Until finishing the processing that whole computer filters go out deleted data.
Owing in the process operation data of computing machine, follow all the time: data that 1) increase newly and have the data association message of modification all to be stored in the base data table in the computing machine (PC or workstation); 2), the relevant information of deleted data all is stored in the deletion record table in the computing machine (PC or workstation), and no longer stores these data in the base data table in computing machine (PC or workstation); Therefore above-mentioned data interaction control method is by ingenious rational control and treatment, avoided the repeated interaction of data fully, only effectively, modification is arranged, the data recording of deleting is in the logging terminal, therefore significantly reduced volume of transmitted data, obviously shorten the mutual time, improved the work efficiency of patrolling and examining.
Description of drawings
The present invention is further illustrated below in conjunction with accompanying drawing.
Fig. 1 is the structural representation of one embodiment of the invention.
Fig. 2 is a schematic flow sheet of the present invention.
Embodiment
Embodiment one
The substation inspection management system data interaction of present embodiment is between PC shown in Figure 1 or workstation and logging terminal.The logging terminal has bar code scanning function, and PC can be connected by LAN (Local Area Network) with server.The personnel of patrolling and examining carry the logging terminal and read bar code information to each tour point, and it is mutual again all tour data to be passed through logging terminal and PC or workstation.
All the time follow in the process operation data of PC or workstation: data that 1) increase newly and have the data association message of modification all to be stored in the base data table in PC or the workstation; 2), the relevant information of deleted data all is stored in the deletion record table in PC or the workstation, and no longer stores these data in the base data table in PC or workstation.Concrete data interaction controlled step following (referring to Fig. 2):
1, in as the PC of processing enter or server, set up the database that contains following each table:
---base data table, be used to write down the information of every data, this information comprises the unique number ID1 and the final updating time T 1 of every data;
---the deletion record table, be used to write down the information of deleted data, this information comprises the unique number ID2 and the deletion time T 2 of every data;
---patrol and examine instrument, be used to write down reference numeral and its last data interaction time T 3 of each logging terminal.
2, in the logging terminal, set up the database that contains following table:
---the logging tables of data, be used to write down the information of every data, this information comprises the unique number ID3 of every data;
3, when the logging terminal is connected with computing machine, when entering the data interaction state, computing machine parallel processing step 4 and step 6 can make transfer efficiency higher like this.
4, computing machine is transferred the final updating time T 1 at the deposit data record in the base data table one by one, and patrol and examine in the instrument last data interaction time T 3, and compare, all the final updating time T 1＞data recording of last data interaction time T 3 is filtered from base data table and retrieved out, and this batch data that retrieval is come out then represents it is the data that data interaction time T the last time 3 increases newly or revised afterwards.
5, computing machine read one by one again that this batch retrieval comes out at deposit data unique number ID1, with the unique number ID3 contrast of every data in itself and the logging tables of data.If ID1 is not equal to ID3, represent that then these data not in the logging tables of data, are that computing machine increases newly, directly write the logging terminal alternately, in the logging tables of data, increase, finish the interworking of these data after, enter next bar data interaction state; If ID1 equals ID3, then represent in the logging tables of data existing these data but be not up-to-date, in the logging tables of data, delete this data recording when mutual earlier, again this data transmission in the base data table in the computing machine is increased in the logging tables of data to terminal, after finishing the interworking of these data, enter next bar data interaction state.Go out processing until finishing whole computer filters at deposit data.
6, computing machine is transferred the deletion time T 2 of the delete data record in the deletion record table one by one, and be recorded in last data interaction time T 3 in the logging terminal information table, and compare, the delete data record during all last deletion time T 2＞last data interaction time T 3 is filtered from base data table and is retrieved out.
7, read the reference numeral ID2 of the deleted data that filter out one by one, it is contrasted with every the reference numeral ID3 at deposit data of logging tables of data that connects in the machine logging terminal, if there is not identical numbering in the logging tables of data, represent that then these data do not exist, and keep present situation in connecting machine logging terminal; If there is identical numbering in the logging tables of data, then will connect this data deletion in the machine logging terminal, enter next bar data interaction state, until finishing the processing that whole computer filters go out deleted data.
Obviously, step 4 and 6 also can successively be carried out as required.Because in the interaction process process, latest data in the logging terminal directly uploads in the PC routinely, therefore after adopting the method for present embodiment, can avoid the ubiquitous for a long time data repeated interaction of prior art fully, improve work efficiency greatly, effectively eliminated " seemingly-dead " phenomenon.
In addition to the implementation, the present invention can also have other embodiments.All employings are equal to the technical scheme of replacement or equivalent transformation formation, all drop on the protection domain of requirement of the present invention.
Claims (3)
1. data interaction control method based on substation inspection management system is characterized in that may further comprise the steps:
1) in as the computing machine of processing enter, set up the database that contains following each table:
--base data table is used to write down and contains every in deposit data reference numeral and the relevant information of final updating time;
--the deletion record table, be used to write down contain every deleted data reference numeral and the deletion time relevant information;
--patrol and examine instrument, be used to write down each logging terminal reference numeral and last data interaction time thereof;
2) in each logging terminal, set up the database that contains following table:
--the logging tables of data is used to write down and contains every relevant information at the deposit data reference numeral;
3) when logging terminal and computing machine being connected machine enter the data interaction state, computer filters goes out final updating time in the base data table and is later than and connects numbering at deposit data of machine logging last data interaction time of terminal, and in the deletion record table deletion time be later than the deleted data numbering that connects the machine logging last data interaction time of terminal, by relatively discerning with the numbering of logging tables of data corresponding data, renewal or deletion connect the corresponding data in the machine logging terminal, until finishing the processing that all leaches data.
2. according to the described data interaction control method of claim 1 based on substation inspection management system, it is characterized in that: in the described step 3), computing machine is pressed predefined procedure by following two groups of steps that are made of 4-1,4-2 and 4-1 ', 4-2 ' respectively, finishes the processing of filtering and leaching data:
4-1, transfer in the base data table in final updating time of deposit data one by one and patrol and examine the corresponding last data interaction time that connects machine logging terminal number in the instrument, filter out whole final updating times after comparing to be later than each bar of last data interaction time at the deposit data reference numeral;
4-2, read the reference numeral that filters out one by one, with itself and every the reference numeral contrast of logging tables of data that connects in the machine logging terminal at deposit data at deposit data; If there is not identical numbering in described logging tables of data, then directly will numbers corresponding data and write even machine logging terminal, and its numbering will be increased in the described logging tables of data to increase mode; If there is identical numbering in the logging tables of data, then directly will numbers corresponding data and write even machine logging terminal with coverage mode; Go out transmission until finishing whole computer filters at deposit data;
4-1 ', the last data interaction time of transferring the deletion time of deleted data correspondence in the deletion record table and connecting logging tables of data in the machine logging terminal one by one, filter out whole deleted times after comparing to be later than the reference numeral of the deleted data of each bar of last data interaction time;
4-2 ', read the reference numeral of the deleted data that filter out one by one,,, then keep present situation if there is not identical numbering in the logging tables of data with itself and every the reference numeral contrast of logging tables of data that connects in the machine logging terminal at deposit data; If there is identical numbering in the logging tables of data, then will connect this data deletion in the machine logging terminal; Until finishing the processing that whole computer filters go out deleted data, finish mutual.
3. according to the described data interaction control method of claim 2, it is characterized in that: the parallel two groups of steps that constitute by 4-1,4-2 and 4-1 ', 4-2 ' respectively of finishing of computing machine in the described step 3) based on substation inspection management system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200810195291A CN101739733A (en) | 2008-11-10 | 2008-11-10 | Substation inspection management system-based data interaction control method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200810195291A CN101739733A (en) | 2008-11-10 | 2008-11-10 | Substation inspection management system-based data interaction control method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101739733A true CN101739733A (en) | 2010-06-16 |
Family
ID=42463179
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200810195291A Pending CN101739733A (en) | 2008-11-10 | 2008-11-10 | Substation inspection management system-based data interaction control method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101739733A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102063746A (en) * | 2010-11-21 | 2011-05-18 | 沈阳华岩电力技术有限公司 | Program-controlled patrol machine and program-controlled patrol method for transformer station |
| CN107993013A (en) * | 2017-12-05 | 2018-05-04 | 中国建筑第八工程局有限公司 | Concrete curing records supervisory systems and method |
-
2008
- 2008-11-10 CN CN200810195291A patent/CN101739733A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102063746A (en) * | 2010-11-21 | 2011-05-18 | 沈阳华岩电力技术有限公司 | Program-controlled patrol machine and program-controlled patrol method for transformer station |
| CN102063746B (en) * | 2010-11-21 | 2013-05-01 | 沈阳华岩电力技术有限公司 | Program-controlled patrol machine and program-controlled patrol method for transformer station |
| CN107993013A (en) * | 2017-12-05 | 2018-05-04 | 中国建筑第八工程局有限公司 | Concrete curing records supervisory systems and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP7074307B2 (en) | Multi-center medical data structure standardization system based on generic data model | |
| CN103514295B (en) | historical data archiving method and historical data archiving device | |
| CN103902653B (en) | A kind of method and apparatus for building data warehouse table genetic connection figure | |
| CN104021145B (en) | The method and apparatus that a kind of mixed service concurrently accesses | |
| CN104065521B (en) | A kind of collection, analysis and the delivery system and its method of electric power networks device log and configuration file | |
| CN102932195B (en) | A kind of business diagnosis method for supervising of protocal analysis Network Based and system | |
| CN103049815A (en) | Customer file information management system and method | |
| CN102385633B (en) | File management system using virtual storage directory | |
| CN101060436A (en) | A fault analyzing method and device for communication equipment | |
| CN101667309A (en) | Access management system based on access control and management method thereof | |
| CN102012896B (en) | Method and device for realizing bulk editing of file contents | |
| CN102591864B (en) | Data updating method and device in comparison system | |
| CN1859505B (en) | Bill checking system and method | |
| CN107016123A (en) | File management method and terminal device | |
| CN106815306A (en) | Daily record analysis method and device | |
| CN101727549A (en) | Computer system for fingerprint identification and fingerprint identification method thereof | |
| CN103684900A (en) | Business polling method and system | |
| CN1809108A (en) | Filter based call ticket memory repetition elimination method | |
| CN101739733A (en) | Substation inspection management system-based data interaction control method | |
| CN106528566A (en) | Log file output method, server and client | |
| CN106777265A (en) | A kind of processing method and processing device of business datum | |
| CN106506460A (en) | Digit Control Machine Tool system for managing program based on Dropbox | |
| CN110290226A (en) | A kind of general client and server-side mating interface protocol method | |
| CN112667736B (en) | Digital operation management system | |
| Salsabila et al. | Perancangan Sistem Informasi Retensi Rekam Medis Berbasis Web di Rumah Sakit Umum Bina Sehat |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20100616 |