CN107451268B - Real-time database-oriented method for continuous transmission in disconnected network - Google Patents
Real-time database-oriented method for continuous transmission in disconnected network Download PDFInfo
- Publication number
- CN107451268B CN107451268B CN201710653712.7A CN201710653712A CN107451268B CN 107451268 B CN107451268 B CN 107451268B CN 201710653712 A CN201710653712 A CN 201710653712A CN 107451268 B CN107451268 B CN 107451268B
- Authority
- CN
- China
- Prior art keywords
- data
- time
- real
- detection unit
- transmission
- 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.)
- Active
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/245—Query processing
- G06F16/2455—Query execution
- G06F16/24552—Database cache management
-
- 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/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention provides a method for continuous transmission of a broken network facing a real-time database, which monitors whether a transmission network of a communication interface for extracting real-time data in the real-time database is normal or not in real time; when the transmission network is abnormal, the current real-time data is automatically cached in the memory area as historical data, and after the transmission network is recovered to be normal, the current real-time data is transmitted and the cached historical data is transmitted. According to the invention, through the functions of data transmission detection and historical data caching, the data acquired during the communication abnormal state is stored in the caching space, and after the communication abnormal recovery is detected, on one hand, the communication interface acquires and pushes the real-time data, and on the other hand, the cached historical data is pushed, so that the safety and reliability of the real-time data in the production process are greatly improved.
Description
Technical Field
The invention relates to a real-time database-oriented method for continuous transmission in a disconnected network, and belongs to the technical field of industrial automation control.
Background
The real-time database is the supporting software for developing a real-time control system, a data acquisition system, a computer integrated manufacturing system and the like. In the process industry, a large number of real-time databases are used for monitoring and controlling production automation systems, and real-time data services and various data management functions are provided for management scheduling, data analysis, decision support and remote monitoring of enterprises. The real-time database becomes an enterprise informatization basic data platform, can directly acquire and acquire various data in the operation process of an enterprise in real time and convert the data into effective public information of various services, meets the requirements of integrity, consistency and safety sharing of the real-time information among enterprise production management, enterprise process monitoring and enterprise operation management, and establishes a bridge of information communication between an enterprise automation system and a management information system. And each professional management department of an enterprise is helped to utilize the key real-time information, and the production and sales operation efficiency is improved. The accumulated real-time data can reflect the generation and development processes of the manufacturing system, so that the accumulated real-time data also has important reference value for management personnel, and the accumulated real-time data is usually stored according to time and categories, namely historical data.
Among various resources concerned by enterprises, production process information is an important resource, and if the problem of real-time and effective uploading of the production process information cannot be solved, the investment of a manufacturing enterprise production process execution management system MES and an enterprise resource planning management system ERP cannot be fully utilized and guaranteed. However, due to the complexity of the entire network of the industrial control system, it often causes the interruption of network communication within a certain local area for a certain period of time, and data loss occurs if the network communication is not processed properly.
The technology of the application is based on the defects of the prior art, and the functions of data transmission detection and data caching are added to the communication interface. And when the data transmission interruption is detected, the real-time data is stored in the cache space, and when the network recovery is detected, on one hand, the communication interface collects and pushes the real-time data, and on the other hand, the cache data is pushed, so that the network interruption continuous transmission of the historical data is realized.
Disclosure of Invention
The technical problem to be solved by the invention is to provide a method for continuous transmission of a broken network facing a real-time database, which stores data acquired during an abnormal communication state into a cache space through data transmission detection and historical data caching functions, and when recovery of abnormal communication is detected, a communication interface acquires and pushes real-time data on one hand and pushes cached historical data on the other hand.
The invention is realized by the following steps: a method for continuous transmission of a broken network facing a real-time database monitors whether a transmission network of a communication interface for extracting real-time data in the real-time database is normal or not in real time; when the transmission network is abnormal, the current real-time data is automatically cached in the memory area as historical data, and after the transmission network is recovered to be normal, the current real-time data is transmitted and the cached historical data is transmitted.
Further, the caching method is to encapsulate the current real-time data into data packets according to a fixed acquisition period, add corresponding time tags to the data packets, and arrange and cache the data packets according to a time sequence.
The real-time monitoring is realized by the following steps: the data transmission method comprises the steps that a data transmission detection module is arranged at a data sending end of a communication interface and comprises a first detection unit and a second detection unit, wherein the first detection unit is always in a working state, and the second detection unit is activated only after a transmission network is abnormal and returns to be normal.
Before a data sending end and a data receiving end of the communication interface establish connection, a value of a first detection unit is 0, and after the connection is established and a first data packet is successfully sent, the value of the first detection unit is 1; if the data receiving end returns a signal of successfully receiving the data packet within the set time, the value of the first detection unit is reset to 0, and the data packet to be received by the next receiving end is continuously transmitted; if the data receiving end does not return a signal of successfully receiving the data packet within the set time period, the value of the first detection unit is kept unchanged, the time tags corresponding to the data packets which are not successfully transmitted currently are stored, and meanwhile, the unsent data packets are sequentially stored in the cache space.
When the transmission network is recovered to be normal, the data sending end sends a data packet which is generated by newly acquired real-time data and provided with a latest time tag, and calls a second detection unit to monitor, wherein the value of the second detection unit is 0, and the value of the second detection unit is 1 after the first data packet which is recovered to be normal is successfully sent; if the data receiving end returns a signal of successfully receiving the data packet within the set time, the value of the second detection unit is reset to 0, and the data packet to be received by the next receiving end is continuously transmitted; and meanwhile, the data sending end calls the stored time labels and sequentially sends the data packets stored in the cache space to the data receiving end according to the sequence of the time labels, wherein the process of sequentially sending the data packets to the data receiving end according to the sequence of the time labels is monitored by the first detection unit.
The data receiving end of the communication interface is provided with a data transmission monitoring module, the data transmission monitoring module returns a receiving affirmation signal after receiving the data packet, and the receiving affirmation signal comprises: a received data packet time tag and a positive identification; conversely, if the data receiving end does not receive the corresponding data packet, or the received data packet is incomplete, the data transmission monitoring module returns a negative reception signal, which includes: a non-received data packet time tag and a negative identification; if the data transmission monitoring module does not return any corresponding signal within the specified time period, the data packet is considered lost.
The invention has the following advantages: the method can sequentially store the real-time data in the cache space in time under the condition of abnormal communication network, and can simultaneously transmit the real-time data and the historical data after the communication is recovered to be normal, thereby providing reliable and complete real-time data information service for the final user, greatly improving the safety and reliability of the real-time data in the production process, simultaneously improving the monitoring capability of managers on the field production process, and enhancing the centralized processing capability and the sharing capability of the data in the production process.
Drawings
The invention will be further described with reference to the following examples with reference to the accompanying drawings.
FIG. 1 is a flow chart of the method of the present invention.
Detailed Description
The invention relates to a method for continuous transmission of a broken network facing a real-time database, which monitors whether a transmission network of a communication interface for extracting real-time data in the real-time database is normal or not in real time; when the transmission network is abnormal, the current real-time data is automatically cached in the memory area as historical data, and after the transmission network is recovered to be normal, the current real-time data is transmitted and the cached historical data is transmitted.
The caching method comprises the steps of encapsulating current real-time data into data packets according to a fixed acquisition period, adding corresponding time tags to the data packets, and arranging and caching the data packets according to a time sequence.
The real-time monitoring is realized by the following steps: the data transmission method comprises the steps that a data transmission detection module is arranged at a data sending end of a communication interface and comprises a first detection unit and a second detection unit, wherein the first detection unit is always in a working state, and the second detection unit is activated only after a transmission network is abnormal and returns to be normal.
The data receiving end of the communication interface is provided with a data transmission monitoring module, the data transmission monitoring module returns a receiving affirmation signal after receiving the data packet, and the receiving affirmation signal comprises: a received data packet time tag and a positive identification; conversely, if the data receiving end does not receive the corresponding data packet, or the received data packet is incomplete, the data transmission monitoring module returns a negative reception signal, which includes: a non-received data packet time tag and a negative identification; if the data transmission monitoring module does not return any corresponding signal within the specified time period, the data packet is considered lost.
As shown in fig. 1, the upper process of the method of the present invention is:
before a data sending end and a data receiving end of the communication interface establish connection, the sum of a first detection unit is 0, and after the connection is established and a first data packet is successfully sent, the sum of a first detection unit is 1;
judging whether a data packet is received in a set time period:
(1) if the data receiving end returns a signal of successfully receiving the data packet within the set time, the value of the first detection unit is reset to 0, and the data packet to be received by the next receiving end is continuously transmitted.
(2) If the data receiving end does not return a signal of successfully receiving the data packet within a set time period, the value of the first detection unit is kept unchanged, the time tags corresponding to the data packets which are not successfully transmitted currently are stored, and meanwhile, the unsent data packets are sequentially stored in the cache space;
when the transmission network is recovered to be normal, the data sending end sends a data packet with a latest time tag generated by newly acquired real-time data and calls a second detection unit to monitor; and meanwhile, the data sending end calls the stored time labels and sequentially sends the data packets stored in the cache space to the data receiving end according to the sequence of the time labels, wherein the process of sequentially sending the data packets to the data receiving end according to the sequence of the time labels is monitored by the first detection unit. Wherein, the monitoring process of the second detection unit is as follows: the value of the second detection unit is 0, and the value of the second detection unit is 1 after the first data packet is successfully sent after the transmission network recovers to be normal; if the data receiving end returns a signal of successfully receiving the data packet within the set time, the value of the second detection unit is reset to 0, and the data packet to be received by the next receiving end is continuously transmitted. The monitoring process of the first detection unit is as follows: the value of the first detection unit is 0, and after the connection is established and the first data packet is successfully sent, the value of the first detection unit is 1; if the data receiving end returns a signal of successfully receiving the data packet within the set time, the value of the first detection unit is reset to 0, and the data packet to be received by the next receiving end is continuously transmitted; if the data receiving end does not return a signal of successfully receiving the data packet within the set time period, the value of the first detection unit is kept unchanged, the time tags corresponding to the data packets which are not successfully transmitted currently are stored, and meanwhile, the unsent data packets are sequentially stored in the cache space.
The method can sequentially store the real-time data in the cache space in time under the condition of abnormal communication network, and can simultaneously transmit the real-time data and the historical data after the communication is recovered to be normal, thereby providing reliable and complete real-time data information service for the final user, greatly improving the safety and reliability of the real-time data in the production process, simultaneously improving the monitoring capability of managers on the field production process, and enhancing the centralized processing capability and the sharing capability of the data in the production process.
Although specific embodiments of the invention have been described above, it will be understood by those skilled in the art that the specific embodiments described are illustrative only and are not limiting upon the scope of the invention, and that equivalent modifications and variations can be made by those skilled in the art without departing from the spirit of the invention, which is to be limited only by the appended claims.
Claims (4)
1. A real-time database-oriented method for continuous transmission in a disconnected network is characterized in that: monitoring whether a transmission network of a communication interface for extracting real-time data in a real-time database is normal or not in real time; when the transmission network is abnormal, the current real-time data is automatically cached in the memory area as historical data, and after the transmission network is recovered to be normal, the current real-time data is transmitted and the cached historical data is transmitted;
the real-time monitoring is realized by the following steps: a data transmission detection module is arranged at a data transmitting end of a communication interface, and comprises a first detection unit and a second detection unit, wherein the first detection unit is always in a working state, and the second detection unit is activated only after a transmission network is abnormal and returns to normal;
before a data sending end and a data receiving end of the communication interface establish connection, a value of a first detection unit is 0, and after the connection is established and a first data packet is successfully sent, the value of the first detection unit is 1; if the data receiving end returns a signal of successfully receiving the data packet within the set time, the value of the first detection unit is reset to 0, and the data packet to be received by the next receiving end is continuously transmitted; if the data receiving end does not return a signal of successfully receiving the data packet within a set time period, the value of the first detection unit is kept unchanged, the time tags corresponding to the data packets which are not successfully transmitted currently are stored, and meanwhile, the unsent data packets are sequentially stored in the cache space;
when the transmission network is recovered to be normal, the data sending end sends a data packet which is generated by newly acquired real-time data and provided with a latest time tag, and calls a second detection unit to monitor, wherein the value of the second detection unit is 0, and the value of the second detection unit is 1 after the first data packet which is recovered to be normal is successfully sent; if the data receiving end returns a signal of successfully receiving the data packet within the set time, the value of the second detection unit is reset to 0, and the data packet to be received by the next receiving end is continuously transmitted; and meanwhile, the data sending end calls the stored time labels and sequentially sends the data packets stored in the cache space to the data receiving end according to the sequence of the time labels, wherein the process of sequentially sending the data packets to the data receiving end according to the sequence of the time labels is monitored by the first detection unit.
2. The method for discontinuous network continuous transmission facing to the real-time database, according to claim 1, is characterized in that: the caching method is to encapsulate the current real-time data into data packets according to a fixed acquisition period, add corresponding time tags on the data packets, and arrange and cache the data packets according to a time sequence.
3. The method for discontinuous network continuous transmission facing to the real-time database, according to claim 1, is characterized in that: a data receiving end of the communication interface is provided with a data transmission monitoring module, and the data transmission monitoring module returns a receiving positive signal after receiving a data packet; on the contrary, if the data receiving end does not receive the corresponding data packet or the received data packet is incomplete, the data transmission monitoring module correspondingly returns a receiving negative signal; if the data transmission monitoring module does not return any corresponding signal within the specified time period, the data packet is considered lost.
4. The method for discontinuous network continuous transmission facing to the real-time database, according to claim 3, is characterized in that: the receiving a positive signal comprises: a received data packet time tag and a positive identification; the receiving a negative signal comprises: a non-received packet time tag and a negative identification.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710653712.7A CN107451268B (en) | 2017-08-03 | 2017-08-03 | Real-time database-oriented method for continuous transmission in disconnected network |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710653712.7A CN107451268B (en) | 2017-08-03 | 2017-08-03 | Real-time database-oriented method for continuous transmission in disconnected network |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107451268A CN107451268A (en) | 2017-12-08 |
| CN107451268B true CN107451268B (en) | 2020-12-15 |
Family
ID=60490205
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710653712.7A Active CN107451268B (en) | 2017-08-03 | 2017-08-03 | Real-time database-oriented method for continuous transmission in disconnected network |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107451268B (en) |
Families Citing this family (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111107123B (en) * | 2018-10-29 | 2022-10-04 | 杭州海康威视数字技术股份有限公司 | Method and device for continuous transmission in broken network |
| CN111385332A (en) * | 2018-12-29 | 2020-07-07 | 顺丰科技有限公司 | Internet of things equipment, Internet of things platform access method and equipment |
| CN109922490B (en) * | 2019-01-28 | 2022-01-28 | 广东中视信息科技有限公司 | Data interruption-proof continuous transmission management system |
| CN110399224A (en) * | 2019-07-29 | 2019-11-01 | 联想(北京)有限公司 | Information processing method and electronic equipment |
| CN113516422A (en) * | 2020-04-09 | 2021-10-19 | 王浩锴 | A containing box for commodity circulation storage |
| CN112702427A (en) * | 2020-12-23 | 2021-04-23 | 武汉湖江科技有限公司 | Industrial internet data synchronization system |
| CN112565463A (en) * | 2021-01-15 | 2021-03-26 | 江苏米塔网络科技服务有限公司 | Data breakpoint continuous transmission method |
| CN112968815B (en) * | 2021-03-11 | 2022-08-09 | 福州大学 | Method for realizing continuous transmission in broken network |
| CN113377815B (en) * | 2021-06-10 | 2023-03-14 | 西安热工研究院有限公司 | Method for continuously transmitting write snapshot breakpoint facing real-time database |
| CN114697267B (en) * | 2022-03-06 | 2024-02-02 | 道莅智远科技(青岛)有限公司 | Intermittent transmission optimization method in industrial control PLC real-time data communication |
| CN115102911A (en) * | 2022-07-29 | 2022-09-23 | 上海电气风电集团股份有限公司 | Data acquisition method and device, electronic equipment and readable storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101047598A (en) * | 2006-03-31 | 2007-10-03 | 日本电气株式会社 | Rpr ring network, communication device and method. |
| JP2009182723A (en) * | 2008-01-30 | 2009-08-13 | Duaxes Corp | Monitoring device |
| KR20120103119A (en) * | 2011-03-10 | 2012-09-19 | (주)보성전자 | Apparatus and method for controlling network failure status of supervisory unit |
| CN104754641A (en) * | 2013-12-27 | 2015-07-01 | 中国移动通信集团公司 | Data transmission control method and data transmission control device |
| CN106685764A (en) * | 2016-12-30 | 2017-05-17 | 新控技术（北京）有限公司 | Communication system and communication method based on data acquisition transmission |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4460867B2 (en) * | 2003-09-26 | 2010-05-12 | 東芝ストレージデバイス株式会社 | Interface device and packet transfer method |
| CN101692249B (en) * | 2009-09-18 | 2012-11-14 | 深圳市科陆电子科技股份有限公司 | Method for performing data access on power demand side system |
| CN104219259B (en) * | 2013-05-30 | 2017-09-12 | 中国电信股份有限公司 | A kind for the treatment of method and apparatus of transmission abnormality event |
| CN105357302B (en) * | 2015-11-12 | 2019-01-11 | 成都科来软件有限公司 | A kind of network packet breaker point continuous transmission method and device |
| CN105974836B (en) * | 2016-04-29 | 2019-05-10 | 郑州宇通客车股份有限公司 | A kind of car monitoring host computer collecting method and system |
-
2017
- 2017-08-03 CN CN201710653712.7A patent/CN107451268B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101047598A (en) * | 2006-03-31 | 2007-10-03 | 日本电气株式会社 | Rpr ring network, communication device and method. |
| JP2009182723A (en) * | 2008-01-30 | 2009-08-13 | Duaxes Corp | Monitoring device |
| KR20120103119A (en) * | 2011-03-10 | 2012-09-19 | (주)보성전자 | Apparatus and method for controlling network failure status of supervisory unit |
| CN104754641A (en) * | 2013-12-27 | 2015-07-01 | 中国移动通信集团公司 | Data transmission control method and data transmission control device |
| CN106685764A (en) * | 2016-12-30 | 2017-05-17 | 新控技术（北京）有限公司 | Communication system and communication method based on data acquisition transmission |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107451268A (en) | 2017-12-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107451268B (en) | Real-time database-oriented method for continuous transmission in disconnected network | |
| CN100536403C (en) | Method and equipment of intelligent patrol detection for communication network | |
| CN101631040B (en) | Real-time monitoring warning system and method of unified management multi-business system | |
| CN103067230A (en) | Method for achieving hyper text transport protocol (http) service monitoring through embedding monitoring code | |
| CN110688280B (en) | Management system, method, equipment and storage medium for alarm event | |
| CN102694871A (en) | Server long-distance monitoring and fault processing device and method based on short message of mobile phone | |
| CN105159964A (en) | Log monitoring method and system | |
| US9092958B2 (en) | Alarm processing systems and methods | |
| CN101651556A (en) | System and method for monitoring server | |
| CN101877618A (en) | Monitoring method, server and system based on proxy-free mode | |
| CN104821900B (en) | Power telecom network emergency first-aid repair whole process managing and control system based on mobile platform application | |
| CN103150324A (en) | Chained processing-based data collecting system and method | |
| CN105049223A (en) | Electric power communication network defect and fault processing decision-aided analysis method | |
| CN110569988B (en) | Payment machine fault processing system and processing method | |
| CN104598241A (en) | Window monitoring method and system | |
| US20240056463A1 (en) | Method and system to detect abnormal message transactions on a network | |
| CN111444146A (en) | Nuclear power unit DCS data acquisition and storage method | |
| CN105743695A (en) | Monitoring method and system based on IEC 104 protocol | |
| CN104683145A (en) | Warning monitoring system server, client and warning information processing and querying method | |
| US8402308B2 (en) | Apparatus and method for failure management of RFID middleware management system | |
| CN112947364A (en) | System and method for early warning of equipment faults of power distribution station based on big data | |
| TW201303753A (en) | Dispersing-type algorithm system applicable to image monitoring platform | |
| CN112486776A (en) | Cluster member node availability monitoring equipment and method | |
| CN109951313B (en) | Monitoring device and method for Hadoop cloud platform | |
| KR101536350B1 (en) | Self-management system of production resources based wired and wireless sensor network |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |