CN101771594B - Data storage system and data storage method - Google Patents

Abstract

A data storage method, the method includes the following steps: providing a web server, the web server is connected to a database server and a plurality of measuring instruments through a network; the web server sends a collection instruction to the measuring instrument according to the stored route; the quantity The measuring instrument feeds back the collected data to the Web server; when the first network connecting the Web server and the database server works normally, send the data to the database server for storage; when the first network works abnormally, send the data to the database server The data is temporarily stored in the historical record file of the Web server; whether the first network is detected at regular intervals is working normally; when it is detected that the first network is working normally, the data is obtained from the historical record file and sent to the database server to save. In addition, the invention also provides a data storage system.

Description

Data storage system and method

technical field

The invention relates to a data storage system and method.

Background technique

At present, the computer network of enterprises has become an important means for enterprises to carry out technological transformation and improve enterprise management level. With the integration of our country and the world's information superhighway, the information obtained by enterprises through computer networks will definitely bring huge economic and social benefits to enterprises, and the office and management of enterprises will develop in the direction of high efficiency, rapidity and paperless .

When using a computer network to collect data, it usually fails to collect data due to the unsmooth network. After the data is collected successfully, the collected data needs to be stored in the database, often due to the abnormality of the network, the data storage fails, and the management personnel need to collect the data again. This wastes a lot of time and reduces work efficiency.

Contents of the invention

In view of the above, it is necessary to provide a data storage system. The system can efficiently collect data and store the data.

In view of the above, it is also necessary to provide a data storage method. The method can effectively collect data and store the data.

A data storage system, applied to a web server, the web server is connected to a database server and a plurality of measuring instruments through a network, the web server includes a data acquisition and monitoring controller, and the data acquisition and monitoring controller includes: a sending module , for sending the collection instruction to the measuring instrument according to the route stored in the web server, the route is the route used for the last communication between the data acquisition and monitoring controller and the measuring instrument, and the measuring instrument feeds back the collected Data to the Web server, when the first network connecting the Web server and the database server works normally, the sending module is also used to send the data to the database server for storage; the storage module is used to store the data when the first network is working When abnormal, the data is temporarily stored in the history file of the Web server; the judgment module is used to detect whether the first network is working normally at regular intervals; and the acquisition module is used to detect that the first network is working when the judgment module Normally, data is obtained from the historical record file, and the obtained data is sent to the database server through the sending module for storage.

A data storage method, the method includes the following steps: providing a web server, the web server is connected to a database server and a plurality of measuring instruments through a network; the web server sends a collection instruction to the measuring instrument according to a stored route, and the route That is, the route used for the last communication between the data acquisition and monitoring controller and the measuring instrument; the measuring instrument feeds back the collected data to the Web server; when the first network connecting the Web server and the database server works normally , sending the data to the database server for storage; when the first network is working abnormally, temporarily storing the data in the history file of the Web server; checking whether the first network is working normally at regular intervals; and when detecting When the first network works normally, the data is obtained from the historical record file and sent to the database server for storage.

Compared with the prior art, the data storage system and method can correct and replace the data transmission route in time to ensure that the data can be stored in the database server.

Description of drawings

FIG. 1 is a hardware architecture diagram of a preferred embodiment of the data storage system of the present invention.

Fig. 2 is a functional block diagram of SCADA in Fig. 1 .

Fig. 3 is a flow chart of the preferred embodiment of the data storage method of the present invention.

Fig. 4 is a flow chart of the preferred embodiment of changing the data collection path in the present invention.

Detailed ways

As shown in FIG. 1 , it is a hardware architecture diagram of a preferred embodiment of the data storage system of the present invention. The system is applied to a Web server 1, connected to a database server 2 through a first network 4, and connected to a plurality of measuring instruments 3 through a second network 5. The multiple measuring instruments 3 are used to measure the same measured object 6 . The measuring instrument 3 refers to measuring instruments such as a flow meter and an electric meter.

Wherein, the Web server 1 includes a data acquisition and monitoring controller (Supervisory Control And Data Acquisition, SCADA) 10, which is used to collect the data measured by the measuring instrument 3. In this preferred embodiment, the measuring instrument 3 is a flow meter, and the data collected by the SCADA 10 includes current, voltage and so on.

Specifically, the SCADA 10 sends a collection instruction to the measuring instrument 3, and the measuring instrument 3 feeds back the collected data to the SCADA 10, and then the SCADA 10 sends the data to the database server 2 for storage. In this embodiment, the database server 2 also stores multiple routes for communication between the SCADA 10 and the measuring instrument 3, and the Web server 1 stores the routes for the last communication between the SCADA 10 and the measuring instrument 3, such as route A. When the SCADA 10 sends a collection instruction to the measuring instrument 3, the route A is preferably used as the communication route between the SCADA 10 and the measuring instrument 3. The Web server 1 also stores a historical record file 12 . The historical record file 12 is used for storing all data that the SCADA 10 sends to the database server 2 when the first network 4 fails.

As shown in Figure 2, it is a functional block diagram of SCADA 10 in Figure 1. The module is a software program segment with specific functions. The software is stored in a computer-readable storage medium or other storage device, and can be executed by a computer or other computing device including a processor, thereby completing a series of processes of data storage. The SCADA 10 includes: a sending module 101, a judgment module 102, an acquisition module 103, an updating module 104 and a storage module 105.

Wherein, the sending module 101 is used to send the acquisition instruction to the measuring instrument 3 through the route A stored in the Web server 1

The judging module 102 is used to judge whether the web server 1 has received the data fed back by the measuring instrument 3 . When the data fed back by the measuring instrument 3 is not received, the judging module 102 is also used to detect whether the second network 5 works normally, that is, to judge whether the communication between the Web server 1 and the measuring instrument 3 is normal.

The obtaining module 103 is used to obtain another route, for example, route B from the database server 2 when the second network 5 is working normally, and the sending module 101 sends a collection instruction to the measuring instrument 3 through the route B. The update module 104 is used to replace the route A stored in the Web server 1 according to the route B.

The sending module 101 is further configured to send a collection instruction to another measuring instrument 3 connected to the Web server 1 according to the route A stored in the Web server 1 when the second network 5 is abnormal.

The sending module 101 is also used for sending the data to the database server 2 for storage when the web server 1 receives the data fed back by the measuring instrument 3 .

The storage module 105 is also configured to temporarily store the data in the history record file 12 when the sending module 101 fails to send the data to the database server 2 .

In addition, the judging module 102 is also configured to detect the first network 4 at regular intervals to determine whether the first network 4 can work normally. In this preferred embodiment, the certain time may be 10 minutes. If the first network 4 works normally, the acquisition module 103 acquires data from the historical record file 12, and sends the acquired data to the database server 2 through the sending module 101 for storage.

As shown in FIG. 3 , it is a flow chart of a preferred embodiment of the data storage method of the present invention.

Step S30, the sending module 101 sends the collection instruction to the measuring instrument 3 according to the route A stored in the Web server 1, and the route A is the route of the last communication between the SCADA 10 and the measuring instrument 3.

Step S31 , the measuring instrument 3 collects data according to the collection instruction, and feeds the collected data back to the Web server 1 through the route A.

In step S32, the judging module 102 judges whether the first network 4 is working normally. If the first network 4 works normally, go to step S33. If the first network 4 is working abnormally, go to step S34.

In step S33, the sending module 101 sends the data fed back by the measuring instrument 3 to the database server 2 for storage, and ends the process.

In step S34, the storage module 105 temporarily stores the data fed back by the measuring instrument 3 in the history record file 12 of the Web server 1, and then proceeds to step S35.

In step S35, the judging module 102 detects whether the first network 4 is still working normally at regular intervals. In this preferred embodiment, the certain time refers to 10 minutes.

If the first network 4 is able to work normally again after the abnormality occurs, then in step S36 , the obtaining module 103 obtains data from the historical record file 12 .

In step S37, the sending module 104 sends the data to the database server 2 for storage.

If the detection result of step S35 is that the first network 4 is still working abnormally, then the process goes to step S35 to continue to detect whether the first network 4 can still work normally.

In addition, in this embodiment, when the web server 1 does not receive the data fed back by the measuring instrument 3, the data collection path can be reselected. The specific operation process is shown in FIG. 4 .

Step S40 , the judging module 102 detects whether the second network 5 is working normally, that is, judging whether the web server 1 and the measuring instrument 3 can communicate normally.

When the judging module 102 judges that the second network 5 is working normally, in step S41, the obtaining module 103 obtains another route, such as route B, from the database server 2 .

In step S42, the update module 104 replaces the route A stored in the Web server 1 through the route B, and ends the process.

Conversely, when the judging module 102 detects that the second network 5 is working abnormally, in step S43, the sending module 101 sends a collection instruction to another measuring instrument 3 according to the route A, and ends the process.

Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention without limitation. Although the present invention has been described in detail with reference to the preferred embodiments, those of ordinary skill in the art should understand that the technical solutions of the present invention can be The scheme shall be modified or equivalently replaced without departing from the spirit and scope of the technical scheme of the present invention.

Claims (7)

1. data acquisition and supervisory controller are arranged in Web server, and this Web server is characterized in that through network connection data storehouse server and a plurality of measuring instrument said data acquisition and supervisory controller comprise:

Sending module; The route that is used for storing according to Web server is sent acquisition instructions to measuring instrument; This route is said data acquisition and the last employed route of communicating by letter of supervisory controller and measuring instrument; The data that said measuring instrument feedback collects are to this Web server, when first network work that connects Web server and database server just often, this sending module also is used for sending said data to database server and preserves;

Memory module is used for when said first network work is unusual, these data being temporary in the history document of Web server;

Judge module, whether be used for detecting first network at regular intervals in proper working order; And

Acquisition module is used for detecting this first network work just often when judge module, from said history document, obtains data, and through sending module these data that get access to is sent to said database server and preserves.

2. data acquisition as claimed in claim 1 and supervisory controller; It is characterized in that; Said judge module also is used for when Web server is not received said measuring instrument feedback data, judging whether second network that connects Web server and measuring instrument is in proper working order;

When said second network work just often, said acquisition module also is used for obtaining an other route from database server, sending module sends acquisition instructions to said measuring instrument through this route; And

When said second network work was unusual, the route that sending module also is used for storing according to Web server was sent acquisition instructions to another measuring instrument.

3. data acquisition as claimed in claim 2 and supervisory controller is characterized in that said data acquisition and supervisory controller also comprise update module, the route that the diversionary toute Web server that is used for obtaining according to acquisition module is stored.

4. data acquisition as claimed in claim 1 and supervisory controller is characterized in that, said certain hour is 10 minutes.

5. a date storage method is characterized in that, this method comprises the steps:

A Web server is provided, and this Web server is through network connection data storehouse server and a plurality of measuring instrument;

This Web server sends acquisition instructions according to the route of being stored and gives measuring instrument, and this route is data acquisition and the last employed route of communicating by letter of supervisory controller and measuring instrument;

This measuring instrument feeds back to said Web server with the data that collect;

When connecting the first network operate as normal of Web server and database server, send in said data to the database server and preserve;

When this first network work is unusual, these data are temporary in the history document of Web server;

Whether detect first network at regular intervals in proper working order; And

When detecting this first network work just often, from history document, obtain data and be sent to said database server and preserve.

6. date storage method as claimed in claim 5 is characterized in that, this method also comprises:

When Web server is not received said measuring instrument feedback data, judge whether second network that connects Web server and measuring instrument is in proper working order;

When this second network work just often, from database server, obtain an other route, send acquisition instructions to said measuring instrument through this route, and according to the route of storing in this diversionary toute Web server that obtains; And

When said second network work is unusual, send acquisition instructions to another measuring instrument according to the route of storing in the Web server.

7. date storage method as claimed in claim 5 is characterized in that, this method also comprises: said certain hour is 10 minutes.

Images