CN105046579A - Working condition information section reproducing system - Google Patents
Working condition information section reproducing system Download PDFInfo
- Publication number
- CN105046579A CN105046579A CN201510398068.4A CN201510398068A CN105046579A CN 105046579 A CN105046579 A CN 105046579A CN 201510398068 A CN201510398068 A CN 201510398068A CN 105046579 A CN105046579 A CN 105046579A
- Authority
- CN
- China
- Prior art keywords
- data
- timestamp
- section
- module
- work information
- 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.)
- Granted
Links
Abstract
The present invention discloses a working condition information section reproducing system which comprises a data collection module, a data storage module, an input module, a data retrieval module and a section reproducing module. According to the system provided by the invention, firstly obtained working condition information is inputted into a historical data table, and then the working condition information of a section time is selected from the historical data table according to a section time node. Due to the setting of a time stamp conversion model, different types of working condition information collection time nodes may be slightly different, through the conversion of a time stamp, substitute data can be used as section working condition data, the integrity of section working condition data reproduction can be ensured, and since the difference value between the time stamp of the substitute data and the section time node is very small, the accuracy of the section working condition data reproduction is not affected by the use of the substitute data.
Description
Technical field
The present invention relates to information playback technical field, particularly relate to a kind of work information section playback system.
Background technology
When doing event or crash analysis, need the information of checking section sometime, generally have following two kinds of modes: a kind of is stored in same historical data table the work information in this moment; Another kind of way is by PMU (PhasorMeasurementUnit, synchronous phase measuring in power system device) equipment collection, ensures that the timestamp of all image data is all point to synchronization.The object of these two kinds of modes is all the work information in that moment in order to search generation event or accident.The work information of synchronization, is just of practical significance for the event or fault analyzing this moment and is worth.But front a kind of mode increases along with the measuring point number of work information, needs the list structure in incremental data storehouse, change list structure needs to close database service, and this is definitely unallowed concerning the application put in production system; Rear a kind of mode needs to increase PMU equipment, adds the cost of whole system, and does not solve the drawback of front a kind of way.
Summary of the invention
Based on the technical matters that background technology exists, the present invention proposes a kind of work information section playback system.
A kind of work information section playback system that the present invention proposes, comprising: data acquisition module, data memory module, load module, data transfer module and section rendering module;
Data acquisition module is used for Real-time Collection work information;
Data memory module is connected with data acquisition module, and its internal preset has database, is provided with and is no less than two historical data tables in database, often opens tables of data for storing class data; Data memory module periodically obtains work information from data acquisition module and will be stored into after the work information annex timestamp of acquisition corresponding historical data table, and timestamp is floor data acquisition time nodal information;
Data are transferred module and are connected with load module and data memory module respectively, load module is for inputting section timing node, data are transferred module and from historical data table, are transferred data that timestamp overlaps with section timing node as section floor data according to section timing node, and never life period is stabbed in the historical data table overlapped with section timing node and transferred substitute data; Data are transferred module and the timing node information represented by the timestamp of substitute data are converted to according to the timestamp transformation model preset the timing node information overlapped with section timing node, and using the substitute data after timestamp conversion as section floor data;
Section rendering module and data transfer model calling, and it is transferred module from data and obtains section floor data, then reappear the operating mode corresponding with section timing node according to each section floor data.
Preferably, data acquisition module is at interval of very first time threshold acquisition work information, and data memory module obtains a work information at interval of the second time threshold from data acquisition module, and the second time threshold equals very first time threshold value.
Preferably, data are transferred in module to be preset with and are no less than a timestamp transformation model, data transfer module never life period stab in the historical data table overlapped with section timing node and transfer timestamp and the immediate floor data of section timing node as data of substituting, then to stab transformation model access time according to the difference of substitute data time stamp and section timing node and data time of substituting stabbed change.
Preferably, the second time threshold is 2s, the timestamp of floor data corresponding odd number second or even number second in multiple historical data tables.
Preferably, timestamp transformation model is:
Timestamp_new=Timestamp_orig-(Timestamp_orig%2); Timestamp_new is the timestamp after conversion, and Timestamp_orig is the timestamp before conversion.
Preferably, timestamp transformation model is:
Timestamp_new=Timestamp_orig+ (Timestamp_orig+1) %2; Timestamp_new is the timestamp after conversion, and Timestamp_orig is the timestamp before conversion.
Preferably, the database of data memory module internal preset is relevant database.
Work information section playback system provided by the invention, first inserts historical data table by the work information of acquisition, from historical data table, then selects the work information in section moment according to section timing node.And due to the setting of timestamp transformation model, may slightly discrepant situation at dissimilar work information acquisition time node, by the conversion of timestamp, substitute data can be substituted into section floor data, both the integrality that section floor data reappears can have been ensured, timestamp again due to data of substituting is very little with section timing node phase difference, and the use of substitute data can not affect the accuracy of section operating mode reproduction.
Work information section playback system provided by the invention, owing to supporting to be no less than two historical data tables, therefore in production environment, by dynamically increasing the mode of new table to expand measuring point quantity, not needing to close database, is a kind of mode of online upgrading.The setting of timestamp transformation model, can solve the timestamp consistency problem of data acquisition that precision is level second, owing to not needing to increase PMU equipment, greatly reduces cost.
Accompanying drawing explanation
Fig. 1 is a kind of work information section playback system structural drawing that the present invention proposes.
Embodiment
With reference to Fig. 1, a kind of work information section playback system that the present invention proposes, comprising: data acquisition module, data memory module, load module, data transfer module and section rendering module.Wherein, data memory module is connected with data acquisition module, and data are transferred module and are connected section rendering module with load module and data memory module respectively and data transfer model calling.
Data acquisition module is used for Real-time Collection work information.
Data memory module internal preset has database, is provided with and is no less than two historical data tables in database, often opens tables of data for storing class data.Data memory module periodically obtains work information from data acquisition module and will be stored into after the work information annex timestamp of acquisition corresponding historical data table, and timestamp is floor data acquisition time nodal information.In present embodiment, the database of data memory module internal preset is relevant database, to associate different historical data tables, conveniently calls.
In present embodiment, data acquisition module is at interval of very first time threshold acquisition work information, and data memory module obtains a work information at interval of the second time threshold from data acquisition module, and the second time threshold equals very first time threshold value.So, by arranging very first time threshold value and the second time threshold, data memory module both can be avoided to store overabundance of data, caused information redundancy, the direct image data of memory module can be avoided again to carry out storing the unreliability caused.In present embodiment, by twice collection to data, both can ensure the validity of image data, data storage can be reduced again and take up room.
Load module is for inputting section timing node, data are transferred module and from historical data table, are transferred data that timestamp overlaps with section timing node as section floor data according to section timing node, and never life period is stabbed in the historical data table overlapped with section timing node and transferred substitute data.Data are transferred module and the timing node information represented by the timestamp of substitute data are converted to according to the timestamp transformation model preset the timing node information overlapped with section timing node, and using the substitute data after timestamp conversion as section floor data.
Because the work information data in historical data table periodically screen, and dissimilar work information gathers in a different manner, so, different due to acquisition mode and instrument, even if the frequency acquisition of the work information in different historical data table is the same, also cannot ensure that the typing time of the work information in different historical data table is just the same.And, when carrying out the reproduction of operating mode section, need all work informations gathering this timing node and section timing node.
In present embodiment, can transfer in module to preset in data and be no less than a timestamp transformation model, data transfer module never life period stab in the historical data table overlapped with section timing node and transfer timestamp and the immediate floor data of section timing node as data of substituting, then to stab transformation model access time according to the difference of substitute data time stamp and section timing node and data time of substituting stabbed change.So, the section floor data of plugging a gap, to ensure the integrality of section floor data.And, by arranging the second time threshold, ensure that the time tolerance of adjacent two work informations in historical data table is less, so, the mobility scale of substitute data time stamp is less than the second time threshold, in time small like this cannot there is larger variation in work information, so the use of substitute data, the impact for the reproduction of section operating mode is almost negligible.
In present embodiment, the quantity of timestamp transformation model should be able to meet the needs timestamp of a work information being converted to any one time point between this work information and timestamp of next work information, concrete, the quantity of timestamp transformation model should be that the second time threshold subtracts one relative to the multiple of standard time value.Such as, second time threshold value three seconds, now the quantity of timestamp transformation model should be two, during with convenient section timing node for 1s, when timestamp does not overlap with section timing node, be that the floor data of 2s and 3s is as the conversion of substitute data respectively using timestamp by two timestamp transformation models.
In present embodiment, the second time threshold is 2s, the timestamp of floor data corresponding odd number second or even number second in multiple historical data tables.So, only need to arrange a timestamp transformation model, just can realize the conversion of data to section floor data of substituting.
Particularly, timestamp transformation model can be:
Timestamp_new=Timestamp_orig-(Timestamp_orig%2); Timestamp_new is the timestamp after conversion, and Timestamp_orig is the timestamp before conversion.Utilize this timestamp transformation model, odd number can be moved forward a standard time value and 1s second, such as, will represent that timing node information is that the timestamp of 3s is converted to the timestamp that timing node information is 2s, thus odd number is converted to even number second second.This timestamp transformation model can meet section timing node when being even number second, and in historical data table, timestamp is the timestamp conversion of the floor data of odd number second.
Particularly, timestamp transformation model can be:
Timestamp_new=Timestamp_orig+ (Timestamp_orig+1) %2; Timestamp_new is the timestamp after conversion, and Timestamp_orig is the timestamp before conversion.
Utilizing this timestamp transformation model, can, by the even number second of a mobile standard time value and 1s backward, such as, be that the timestamp of 2s is converted to the timestamp that timing node information is 3s by timing node information, thus even number is converted to odd number second second.This timestamp transformation model can meet section timing node when being odd number second, and in historical data table, timestamp is the timestamp conversion of the floor data of even number second.
Section rendering module is transferred module from data and is obtained section floor data, then reappears the operating mode corresponding with section timing node according to each section floor data.
The above; be only the present invention's preferably embodiment; but protection scope of the present invention is not limited thereto; anyly be familiar with those skilled in the art in the technical scope that the present invention discloses; be equal to according to technical scheme of the present invention and inventive concept thereof and replace or change, all should be encompassed within protection scope of the present invention.
Claims (7)
1. a work information section playback system, is characterized in that, comprising: data acquisition module, data memory module, load module, data transfer module and section rendering module;
Data acquisition module is used for Real-time Collection work information;
Data memory module is connected with data acquisition module, and its internal preset has database, is provided with and is no less than two historical data tables in database, often opens tables of data for storing class data; Data memory module periodically obtains work information from data acquisition module and will be stored into after the work information annex timestamp of acquisition corresponding historical data table, and timestamp is floor data acquisition time nodal information;
Data are transferred module and are connected with load module and data memory module respectively, load module is for inputting section timing node, data are transferred module and from historical data table, are transferred data that timestamp overlaps with section timing node as section floor data according to section timing node, and never life period is stabbed in the historical data table overlapped with section timing node and transferred substitute data; Data are transferred module and the timing node information represented by the timestamp of substitute data are converted to according to the timestamp transformation model preset the timing node information overlapped with section timing node, and using the substitute data after timestamp conversion as section floor data;
Section rendering module and data transfer model calling, and it is transferred module from data and obtains section floor data, then reappear the operating mode corresponding with section timing node according to each section floor data.
2. work information section playback system as claimed in claim 1, it is characterized in that, data acquisition module is at interval of very first time threshold acquisition work information, data memory module obtains a work information at interval of the second time threshold from data acquisition module, and the second time threshold equals very first time threshold value.
3. work information section playback system as claimed in claim 2, it is characterized in that, data are transferred in module to be preset with and are no less than a timestamp transformation model, data transfer module never life period stab in the historical data table overlapped with section timing node and transfer timestamp and the immediate floor data of section timing node as data of substituting, then to stab transformation model access time according to the difference of substitute data time stamp and section timing node and data time of substituting stabbed change.
4. work information section playback system as claimed in claim 2, it is characterized in that, the second time threshold is 2s, the timestamp of floor data corresponding odd number second or even number second in multiple historical data tables.
5. work information section playback system as claimed in claim 4, it is characterized in that, timestamp transformation model is:
Timestamp_new=Timestamp_orig-(Timestamp_orig%2); Timestamp_new is the timestamp after conversion, and Timestamp_orig is the timestamp before conversion.
6. work information section playback system as claimed in claim 4, it is characterized in that, timestamp transformation model is:
Timestamp_new=Timestamp_orig+ (Timestamp_orig+1) %2; Timestamp_new is the timestamp after conversion, and Timestamp_orig is the timestamp before conversion.
7. work information section playback system as claimed in claim 1, it is characterized in that, the database of data memory module internal preset is relevant database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510398068.4A CN105046579B (en) | 2015-07-08 | A kind of work information section playback system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510398068.4A CN105046579B (en) | 2015-07-08 | A kind of work information section playback system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105046579A true CN105046579A (en) | 2015-11-11 |
| CN105046579B CN105046579B (en) | 2018-08-31 |
Family
ID=
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101862199A (en) * | 2009-04-16 | 2010-10-20 | 株式会社东芝 | Positron ct apparatus and nuclear medical image generating method |
| US20110099199A1 (en) * | 2009-10-27 | 2011-04-28 | Thijs Stalenhoef | Method and System of Detecting Events in Image Collections |
| CN102611641A (en) * | 2012-01-20 | 2012-07-25 | 上海量明科技发展有限公司 | Method and system for acquiring and collecting instant messaging records |
| CN103078352A (en) * | 2012-12-31 | 2013-05-01 | 东南大学 | Method for measuring wind fire bundling configuration proportion on basis of power circle |
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101862199A (en) * | 2009-04-16 | 2010-10-20 | 株式会社东芝 | Positron ct apparatus and nuclear medical image generating method |
| US20110099199A1 (en) * | 2009-10-27 | 2011-04-28 | Thijs Stalenhoef | Method and System of Detecting Events in Image Collections |
| CN102611641A (en) * | 2012-01-20 | 2012-07-25 | 上海量明科技发展有限公司 | Method and system for acquiring and collecting instant messaging records |
| CN103078352A (en) * | 2012-12-31 | 2013-05-01 | 东南大学 | Method for measuring wind fire bundling configuration proportion on basis of power circle |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107766575B (en) | Read-write separation database access method and device | |
| CN103714097A (en) | Method and device for accessing database | |
| EP2648114A1 (en) | Method, system, token conreoller and memory database for implementing distribute-type main memory database system | |
| CN103428264B (en) | The method of data syn-chronization, equipment and system | |
| CN102890675B (en) | Method and device for storing and finding data | |
| CN106294776A (en) | A kind of data processing method and device | |
| CN101937435A (en) | Online synchronized method of distributed real-time database confronting power system | |
| CN101145896B (en) | Control system and method for clock synchronization between control stations | |
| CN103237075A (en) | Data synchronizing method, device and system | |
| CN102709888B (en) | Method and system of on-line fixed value operation of signal protection substation | |
| CN107391357A (en) | Application crashes replay method, device and mobile terminal | |
| CN101833513B (en) | Device and reading method for data frame | |
| CN103778120A (en) | Global file identification generation method, generation device and corresponding distributed file system | |
| CN109361777A (en) | Synchronous method, synchronization system and the relevant apparatus of distributed type assemblies node state | |
| CN103631947A (en) | List searching method and searching system | |
| CN100468260C (en) | Method for implementing working main station and standby main station synchronous recording | |
| CN103078946A (en) | Mass real-time data distributing method and mass real-time data access method | |
| CN107636627B (en) | Time synchronization device, time synchronization system, and time synchronization method | |
| CN105046579A (en) | Working condition information section reproducing system | |
| CN112131214A (en) | Method, system, equipment and storage medium for data writing and data query | |
| CN105512130A (en) | Method and device for data source fusion | |
| CN105046426A (en) | Database multiple-historical data table-based working condition information section reconstruction method | |
| CN103986601A (en) | Message transmission delay obtaining method and device | |
| CN104376093B (en) | A kind of video file searching method and device | |
| CN103605766A (en) | Method and device for accessing power transformation data to real-time or historical database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |