CN114500675A - Protocol conversion method with cache database and related device - Google Patents
Protocol conversion method with cache database and related device Download PDFInfo
- Publication number
- CN114500675A CN114500675A CN202111584333.XA CN202111584333A CN114500675A CN 114500675 A CN114500675 A CN 114500675A CN 202111584333 A CN202111584333 A CN 202111584333A CN 114500675 A CN114500675 A CN 114500675A
- Authority
- CN
- China
- Prior art keywords
- cache database
- data
- monitoring
- communication interface
- monitoring 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.)
- Pending
Links
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/08—Protocols for interworking; Protocol conversion
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F12/00—Accessing, addressing or allocating within memory systems or architectures
- G06F12/02—Addressing or allocation; Relocation
- G06F12/08—Addressing or allocation; Relocation in hierarchically structured memory systems, e.g. virtual memory systems
- G06F12/0802—Addressing of a memory level in which the access to the desired data or data block requires associative addressing means, e.g. caches
- G06F12/0866—Addressing of a memory level in which the access to the desired data or data block requires associative addressing means, e.g. caches for peripheral storage systems, e.g. disk cache
- G06F12/0868—Data transfer between cache memory and other subsystems, e.g. storage devices or host systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F13/00—Interconnection of, or transfer of information or other signals between, memories, input/output devices or central processing units
- G06F13/14—Handling requests for interconnection or transfer
- G06F13/20—Handling requests for interconnection or transfer for access to input/output bus
- G06F13/22—Handling requests for interconnection or transfer for access to input/output bus using successive scanning, e.g. polling
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F13/00—Interconnection of, or transfer of information or other signals between, memories, input/output devices or central processing units
- G06F13/38—Information transfer, e.g. on bus
- G06F13/382—Information transfer, e.g. on bus using universal interface adapter
-
- 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
- G06F16/258—Data format conversion from or to a database
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/06—Protocols specially adapted for file transfer, e.g. file transfer protocol [FTP]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2212/00—Indexing scheme relating to accessing, addressing or allocation within memory systems or architectures
- G06F2212/10—Providing a specific technical effect
- G06F2212/1032—Reliability improvement, data loss prevention, degraded operation etc
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2212/00—Indexing scheme relating to accessing, addressing or allocation within memory systems or architectures
- G06F2212/16—General purpose computing application
- G06F2212/163—Server or database system
Abstract
The application discloses a protocol conversion method with a cache database and a related device, wherein the method comprises the following steps: the monitoring protocol converter is provided with another program which uploads the data of the database to a server in a timing manner after the data of the database is not processed or is processed. When the network oscillation is unstable or the network is temporarily disconnected and the like, the data are stored in the cache database, so that the data cannot be lost. And processing the local site data through the protocol converter relieves the multi-process burden of the server. The server only needs to store the uploaded data into a database of the server. Thereby the technical problem of poor reliability in the prior art is solved.
Description
Technical Field
The present application relates to the field of communications technologies, and in particular, to a protocol conversion method with a cache database and a related device.
Background
Most of the existing monitoring protocol converter devices adopt a virtual serial port technology, serial port monitoring signals are directly converted into IP signals, and a front-end processor or a server background of a background acquires monitoring data by continuously polling the protocol converter devices. When network oscillation and unstable connection occur, phenomena such as data acquisition loss and data acquisition insufficiency occur. The device can be halted and the like. Meanwhile, the burden of starting a plurality of processes for high-density polling by the front-end processor or the server is too heavy, the frequency of dead halt is increased, and the reliability is reduced.
Disclosure of Invention
The application provides a protocol conversion method with a cache database and a related device, which are used for solving the technical problem of poor reliability in the prior art.
In view of this, a first aspect of the present application provides a protocol conversion method with a cache database, where the method includes:
establishing a cache database in a monitoring protocol converter;
collecting data through the monitoring protocol converter, and storing the collected data into the cache database;
and the cache database uploads the data which does not need to be processed or the processed data to a background to a server periodically.
Optionally, the method further comprises: and polling the monitoring equipment through the monitoring protocol converter.
Optionally, the method further comprises: and when the network is in oscillation or temporary interruption, the cache database returns corresponding data after responding to the data request instruction.
Optionally, the collecting data by the monitoring protocol converter further includes: and after the collected data are processed, storing the data into the cache database.
A second aspect of the present application provides a monitoring gateway with a cache database, the gateway comprising:
the system comprises a cache database, a first communication interface and a first communication processing module;
the first communication interface is used for receiving monitoring information acquired by the acquisition equipment and sending the monitoring information to the first communication processing module;
the first communication processing module is used for performing format conversion on the monitoring information and then sending the monitoring information to the cache database;
and the cache database is used for storing the monitoring information and periodically uploading data which does not need to be processed or processed data to a background to a server.
Optionally, the method further comprises: a second communication interface;
the second communication interface is used for connecting and connecting a backbone network or a public network communication network.
Optionally, the method further comprises: a data processing unit;
the data processing unit is used for receiving the monitoring information after format conversion, processing or logically controlling the monitoring information, and then sending the monitoring information to the cache database, so that the cache database stores the monitoring information.
Optionally, the first communication interface is: an RS232 communication interface or an RS485 communication interface.
Optionally, the second communication interface is: RJ45 communication interface.
Optionally, the first communication interface and the second communication interface are both: a wireless communication interface.
According to the technical scheme, the method has the following advantages:
the protocol conversion method comprises the steps of establishing a cache database at a monitoring protocol converter, handing responsibility of data acquisition from equipment to the protocol converter, enabling the protocol converter to be responsible for high-density data acquisition and polling, storing the acquired data into the cache database, enabling the protocol converter to have another program, and uploading the unprocessed or processed data of the database to a server at regular time. When the network oscillation is unstable or the network is temporarily disconnected and the like, the data are stored in the cache database, so that the data cannot be lost. And processing the local site data through the protocol converter relieves the multi-process burden of the server. The server only needs to store the uploaded data into a database of the server. Thereby the technical problem of poor reliability in the prior art is solved.
Drawings
Fig. 1 is a schematic flowchart of a first embodiment of a protocol conversion method with a cache database provided in an embodiment of the present application;
fig. 2 is a schematic flowchart of a second embodiment of a protocol conversion method with a cache database provided in an embodiment of the present application;
fig. 3 is a schematic structural diagram of an embodiment of a monitoring gateway with a cache database provided in the embodiment of the present application.
Detailed Description
In order to make those skilled in the art better understand the technical solutions of the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
Referring to fig. 1, fig. 1 is a schematic flowchart of a protocol conversion method with a cache database according to an embodiment of the present disclosure.
The protocol conversion method with the cache database provided by the embodiment of the application comprises the following steps:
it should be noted that a cache database is established at the monitoring protocol converter, and the responsibility for collecting data from the device is handed over to the protocol converter.
102, acquiring data through a monitoring protocol converter, and storing the acquired data into a cache database;
it should be noted that the monitoring protocol converter is responsible for high-density data acquisition, and then stores the acquired data into the cache database. Therefore, the data reliability is improved, the burden of the monitoring host is reduced, and the reliability and the robustness of the monitoring network are enhanced.
And 103, uploading the data which does not need to be processed or the processed data to a background to a server by the cache database periodically.
It should be noted that the cache database periodically uploads the data that does not need to be processed or the processed data to the server, and the background server stores the data sent from the gateway into the background database after monitoring the data, thereby completing the whole monitoring process.
The protocol conversion method comprises the steps of establishing a cache database at a monitoring protocol converter, handing responsibility of data acquisition from equipment to the protocol converter, enabling the protocol converter to be responsible for high-density data acquisition and polling, storing the acquired data into the cache database, enabling the protocol converter to have another program, and uploading the unprocessed or processed data of the database to a server at regular time. When the network oscillation is unstable or the network is temporarily disconnected and the like, the data are stored in the cache database, so that the data cannot be lost. And processing the local site data through the protocol converter relieves the multi-process burden of the server. The server only needs to store the uploaded data into a database of the server. Thereby the technical problem of poor reliability in the prior art is solved.
The foregoing is a first embodiment of a protocol conversion method with a cache database provided in the embodiment of the present application, and the following is a second embodiment of a protocol conversion method with a cache database provided in the embodiment of the present application.
Referring to fig. 2, fig. 2 is a flowchart illustrating a protocol conversion method with a cache database according to a second embodiment of the present disclosure.
The protocol conversion method with the cache database provided by the embodiment of the application comprises the following steps:
it should be noted that step 201 is the same as the description of step 101 in the embodiment, please refer to the description of step 101, and the description is not repeated herein.
Step 202, collecting data through a monitoring protocol converter, polling monitoring equipment, and processing the collected data;
it should be noted that Polling (Polling) is a way for the CPU to decide how to provide services for peripheral devices, and is also called "Programmed input/output" (Programmed I/O). The concept of the polling method is: the CPU sends out inquiry at regular time to inquire each peripheral equipment whether it needs its service or not in sequence, if so, the peripheral equipment gives service, and after the service is over, the peripheral equipment asks the next peripheral equipment, and then the process is repeated. It can be understood that the present embodiment polls a plurality of monitoring devices by the monitoring protocol converter, and whether a service for collecting data is required.
it should be noted that the data collected by the monitoring protocol converter may be directly sent to the cache database for storage, or the collected data may be sent to other processing units for processing, and then sent to the cache database for storage.
And step 204, when the network is vibrated or temporarily interrupted, the cache database returns corresponding data after responding to the data request instruction.
It should be noted that, if the network is in a shock or is temporarily interrupted, the recent data is stored in the gateway cache database, so that no data is lost. In addition, when the cache database uploads the data, the data can be simply preprocessed according to needs and then uploaded.
It should be noted that step 205 is the same as the description of step 103 in the embodiment, please refer to the description of step 103, and the description thereof is omitted here.
The foregoing is a second embodiment of a protocol conversion method with a cache database provided in this embodiment of the present application, and the following is an embodiment of a monitoring gateway with a cache database provided in this embodiment of the present application.
Referring to fig. 3, fig. 3 is a schematic structural diagram of an embodiment of a monitoring gateway with a cache database according to the present application.
The monitoring gateway with the cache database provided in the embodiment of the application comprises:
the system comprises a cache database, a first communication interface and a first communication processing module;
the first communication interface 301 is configured to receive monitoring information acquired by the acquisition device and send the monitoring information to the first communication processing module;
it should be noted that, the first communication interface is: and the RS232 communication interface or the RS485 communication interface or other communication interfaces are communicated with the acquisition equipment.
The first communication processing module 302 is configured to perform format conversion on the monitoring information and send the format converted monitoring information to the cache database;
it should be noted that the first communication interface is connected to the first communication processing module, for example, when the first communication interface is an RS232 communication interface, the first communication processing module is an RS232 communication processing module.
And the cache database 303 is used for storing the monitoring information and periodically uploading data which does not need to be processed or processed data to the server.
Caching a database: for caching the collected data and extracting data at different times in response to the request for uploading.
Further, the monitoring gateway according to the embodiment of the present application further includes: a second communication interface;
and the second communication interface is used for connecting and connecting a backbone network or a public network communication network.
It should be noted that the second communication interface is an RJ45 communication module interface, is used to connect to a backbone network or a public network communication network, and may be replaced by a wireless communication interface or another communication module interface.
Further, the monitoring gateway according to the embodiment of the present application further includes: a data processing unit;
and the data processing unit is used for receiving the monitoring information after format conversion, processing or logically controlling the monitoring information and then sending the monitoring information to the cache database so that the cache database stores the monitoring information.
It should be noted that, the data processing unit: for processing received data and for logic control and storage functions. On one hand, the collected data is processed and then stored in a cache database; on the other hand, another program uploads the data stored in the gateway cache database to the background server at regular time.
The invention designs a monitoring gateway with a cache database, the device uses an RS232 interface or an RS485 interface or other communication interfaces to communicate with acquisition equipment, acquires monitoring information, acquires data through an RS232 or other communication processing modules in the device, and stores the data in the gateway cache database in a certain format. And the other program uploads the data stored in the gateway cache database to the background server at regular time, and the background server stores the data into the background database after monitoring the data sent by the gateway, so that the whole monitoring process is completed. Thus, if the network is in a shock or temporary outage, no data is lost because recent data is stored in the gateway cache database. In addition, when the cache database uploads the data, the data can be simply preprocessed according to needs and then uploaded.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
The terms "first," "second," "third," "fourth," and the like in the description and in the drawings are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the application described herein are, for example, capable of operation in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It should be understood that in the present application, "at least one" means one or more, "a plurality" means two or more. "and/or" for describing an association relationship of associated objects, indicating that there may be three relationships, e.g., "a and/or B" may indicate: only A, only B and both A and B are present, wherein A and B may be singular or plural. The character "/" generally indicates that the former and latter associated objects are in an "or" relationship. "at least one of the following" or similar expressions refer to any combination of these items, including any combination of single item(s) or plural items. For example, at least one (one) of a, b, or c, may represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", wherein a, b, c may be single or plural.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present application may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be substantially implemented or contributed to by the prior art, or all or part of the technical solution may be embodied in a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a portable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above embodiments are only used for illustrating the technical solutions of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions in the embodiments of the present application.
Claims (10)
1. A protocol conversion method with a cache database is characterized by comprising the following steps:
establishing a cache database in a monitoring protocol converter;
collecting data through the monitoring protocol converter, and storing the collected data into the cache database;
and the cache database uploads the data which does not need to be processed or the processed data to a background to a server periodically.
2. The method for protocol conversion with a cache database according to claim 1, further comprising: and polling the monitoring equipment through the monitoring protocol converter.
3. The method for protocol conversion with a cache database according to claim 1, further comprising: and when the network is in oscillation or temporary interruption, the cache database returns corresponding data after responding to the data request instruction.
4. The method for protocol conversion with a cache database according to claim 1, wherein the collecting data by the monitoring protocol converter further comprises: and after the collected data are processed, storing the data into the cache database.
5. A monitoring gateway with a cache database, comprising: the system comprises a cache database, a first communication interface and a first communication processing module;
the first communication interface is used for receiving monitoring information acquired by the acquisition equipment and sending the monitoring information to the first communication processing module;
the first communication processing module is used for performing format conversion on the monitoring information and then sending the monitoring information to the cache database;
and the cache database is used for storing the monitoring information and periodically uploading data which does not need to be processed or processed data to a background to a server.
6. The monitoring gateway with cache database according to claim 5, further comprising: a second communication interface;
and the second communication interface is used for connecting and connecting a backbone network or a public network communication network.
7. The monitoring gateway with cache database according to claim 5, further comprising: a data processing unit;
and the data processing unit is used for receiving the monitoring information after format conversion, processing or logically controlling the monitoring information, and then sending the monitoring information to the cache database, so that the cache database stores the monitoring information.
8. The monitoring gateway with the cache database according to claim 5, wherein the first communication interface is: an RS232 communication interface or an RS485 communication interface.
9. The monitoring gateway with the cache database according to claim 6, wherein the second communication interface is: RJ45 communication interface.
10. The monitoring gateway with cache database according to claim 5, wherein said first communication interface and said second communication interface are both: a wireless communication interface.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111584333.XA CN114500675A (en) | 2021-12-22 | 2021-12-22 | Protocol conversion method with cache database and related device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202111584333.XA CN114500675A (en) | 2021-12-22 | 2021-12-22 | Protocol conversion method with cache database and related device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN114500675A true CN114500675A (en) | 2022-05-13 |
Family
ID=81493281
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202111584333.XA Pending CN114500675A (en) | 2021-12-22 | 2021-12-22 | Protocol conversion method with cache database and related device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN114500675A (en) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1420315A1 (en) * | 2002-11-18 | 2004-05-19 | Rockwell Automation Technologies, Inc. | Embedded database in an industrial controller environment |
US20080144627A1 (en) * | 2006-12-19 | 2008-06-19 | Andrew Ballantyne | Route monitoring in a network management system |
US20140362712A1 (en) * | 2013-06-06 | 2014-12-11 | Seven Networks, Inc. | Radio or network evaluation for selection based on measurements using application layer protocols at a mobile device |
CN111030923A (en) * | 2019-11-18 | 2020-04-17 | 重庆邮电大学 | Hospital patient oral administration monitoring gateway |
-
2021
- 2021-12-22 CN CN202111584333.XA patent/CN114500675A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1420315A1 (en) * | 2002-11-18 | 2004-05-19 | Rockwell Automation Technologies, Inc. | Embedded database in an industrial controller environment |
US20080144627A1 (en) * | 2006-12-19 | 2008-06-19 | Andrew Ballantyne | Route monitoring in a network management system |
US20140362712A1 (en) * | 2013-06-06 | 2014-12-11 | Seven Networks, Inc. | Radio or network evaluation for selection based on measurements using application layer protocols at a mobile device |
CN111030923A (en) * | 2019-11-18 | 2020-04-17 | 重庆邮电大学 | Hospital patient oral administration monitoring gateway |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107357571A (en) | Maintaining method, system and the component server of apparatus assembly program | |
CN101350834A (en) | Information acquisition system capable of asynchronously implementing information acquisition and information transmission | |
CN110493770A (en) | Obtain method, card pool equipment and the cloud server with management cloud SIM card data | |
CN101800712A (en) | Gateway apparatus, information communication method, information communication program, and information communication system | |
CN108123826B (en) | Cross-region data interaction system and method | |
CN102916987A (en) | Data acquisition and management system based on cloud computing framework | |
JP2007288579A (en) | Base station log collection apparatus, collection method of log of base station, and computer program | |
CN104883470A (en) | Image Forming System, Relay Server, Communication Controlling Method And Non-transitory Computer Readable Recording Medium | |
CN100353712C (en) | Managing method for transmission equipment | |
CN104572838A (en) | Improved system and method for writing data to database | |
CN103024023A (en) | Electronic reading room network auditing method | |
CN114500675A (en) | Protocol conversion method with cache database and related device | |
CN102413247A (en) | Method and device for recovering crash site of terminal | |
CN106341433A (en) | Service system, signal server and intercom server | |
CN101159972A (en) | Traffic processing method and system and traffic control point | |
CN105117898A (en) | Cloud attendance management method and system for supporting access of attendance terminals of multiple manufacturers | |
CN100455059C (en) | Short message gateway bridging system, method and short message gateway bridge module | |
CN202268912U (en) | Data management system based on cloud computation structure | |
CN103138850B (en) | The adjusting, measuring method of communication terminal and device | |
CN110505648A (en) | A kind of anti-lost line method of wireless device | |
CN115729164A (en) | Industrial communication system management method and device and industrial communication system | |
CN112787868B (en) | Information synchronization method and device | |
CN104852935B (en) | Date storage method and system | |
CN201467453U (en) | Bluetooth information transmitting system based on network control | |
CN112270536A (en) | POS-based aggregated payment method, system and related device |
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 |