JP4748998B2 - Data collection system - Google Patents

Description

  The present invention relates to a data collection system. More specifically, the present invention relates to a data collection system in which two or more data collection slave units acquire measurement data, and the data collection master unit collects these measurement data. The present invention relates to a data collection system capable of browsing collected measurement data or performing operation settings of the system using a user terminal connected to a collection master.

  In recent production lines, production devices such as measuring instruments and processing machines arranged for each production process are operated under the control of a programmable controller. If data can be acquired and accumulated from such production equipment, the operating status of each production equipment can be grasped, and quality checks can be performed on products being produced. For this reason, a data collection device that is connected to a programmable controller (PLC), a measuring instrument, etc., and automatically acquires and accumulates measurement data is already known.

  Such conventional data collection devices are usually distributed and arranged for each production process. For this reason, measurement data stored in each data collection device is recorded on a portable storage medium such as a flexible disk or a memory card, and collected and processed by an user in an information processing device such as a personal computer. That is, the collection and collation of the measurement data accumulated in each data collection device has to be performed by the user himself and is complicated.

  Therefore, a data collection device arranged for each production process is connected to an information processing device via a network, and a plurality of measurement data acquired by each data collection device is automatically collected in one information processing device, A database can be considered. Here, the data collection device and the information processing device connected to the network will be referred to as a data collection slave device and a data collection master device, respectively, and a system including devices connected to the network will be referred to as a data collection system. If such a data collection system is used, the user can use the measurement data acquired by each data collection slave unit only by accessing the data collection master unit. In other words, it is not necessary to go to the place where each data collection slave is installed, which is considered convenient.

  The access method from the user to the database in the data collection parent device includes a method in which the data collection parent device is provided with a user interface and a method in which a user terminal composed of a general-purpose computer is connected to the data collection parent device. Although it is conceivable, the data collection master can be made smaller and can be realized at a lower cost by adopting the latter. That is, if a personal computer installed with browsing software is connected to the data collection master unit, desired measurement data can be extracted from the database in the data collection master unit and displayed on the screen.

  Various conditions using the date and time, the day of the week, the value of the measurement data, etc. can be considered as the extraction conditions of the measurement data. Various display methods such as table display and graph display can be considered as the screen display method. These extraction conditions and screen display methods are arbitrarily specified by the user, but if the previous specification is held in the user terminal, the same extraction conditions and screen display will be displayed each time the database is accessed. There is no need to repeat the operation of specifying the method.

  However, for example, when a data collection master is installed at a production site or the like, it is considered that a portable user terminal such as a notebook personal computer is often used by connecting to the data collection master when necessary. In such a case, if any of the plurality of user terminals is connected and the database can be accessed, it is considered that convenience is high. However, when a user terminal different from the previous one is connected to the data collection master unit, even if the extraction conditions and screen display method are the same as the previous one, the same designation operation must be repeated, which is complicated.

  In addition, the setting work of the data collection slave unit must be performed by the user at the installation location of each data collection slave unit, and it takes time when there are many data collection slave units accommodated in the data collection system. It becomes work. In addition, in a production line that performs multi-product and small-quantity production, the product type is often changed, and it is necessary to change the setting of each data collection slave unit each time. Therefore, it is convenient if the user terminal in which the setting software is installed is connected to the data collection master unit, and not only the operation settings of the data collection master unit but also the operation settings of each data collection slave unit can be performed from the user terminal. Is considered high.

  Also in this case, it is considered highly convenient if the operation setting can be performed by connecting any of the plurality of user terminals. However, if the setting data held in each user terminal is different from each other, if the setting data changed based on it is transmitted to the data collection master unit, the new setting data in the data collection master unit will be There is a possibility that old setting data in the user terminal may be overwritten. In addition, if a part of the setting data held in the data collection master unit is updated from the user terminal, there is a possibility that inconsistency occurs between the old and new setting data, and normal operation cannot be performed. If it is going to avoid such a problem, about the data collection main | base station and several user terminals, version management must be performed about the setting data which each hold | maintains, and it is complicated.

  The present invention has been made in view of the above circumstances, and a user when a user terminal arbitrarily selected from two or more user terminals is connected to a data collection master and a database in the data collection master is viewed. It is an object of the present invention to provide a data collection system that can simplify the operation. In particular, it is an object of the present invention to provide a highly convenient data collection system that does not require the same setting operation to be repeated even when different user terminals are used for browsing setting data that can be arbitrarily set by the user.

  In addition, the present invention provides a data collection system in which user terminals arbitrarily selected from two or more user terminals are connected to a data collection master unit and setting data of each data collection slave unit can be easily updated. For the purpose. In particular, an object of the present invention is to provide a data collection system capable of suppressing inconsistencies between setting data without performing complicated version management for the data collection master unit and each user terminal.

A data collection system according to a first aspect of the present invention includes a plurality of data collection slave units each for obtaining measurement data from an external device including a programmable controller, and a data collection parent for collecting the measurement data obtained by each of the data collection slave units. A data collection system in which a user terminal can be connected to the data collection master unit, wherein the data collection slave unit acquires the measurement data at an acquisition timing based on an instruction from the data collection master unit. And a data acquisition unit for adding the time information at which the measurement data is acquired and transmitting the time data to the data collection master unit, wherein the operation is prescribed based on the master unit setting data transmitted from the user terminal. machine is common setting data and the said data including a common system program to the data acquisition handset transmitted from the user terminal A slave unit setting storage unit for storing slave unit setting data including individual setting data including the type of measurement data and acquisition timing of the collection slave unit, and setting data for transmitting the slave unit setting data to each of the data collection slave units Acquired based on the individual setting data from the transmission unit, the system setting management unit that updates the slave unit setting data and transmits to the user terminal in response to a request from the user terminal, and the data collection slave unit first browsing setting that defines a data acquisition unit, a database and the measured data and the time information received is stored in association, the extraction conditions based on the time information for receiving the measurement data and the time information A browsing setting storage unit for holding second browsing setting data defining data and screen display of the user terminal, and the database according to the extraction condition A database management unit that creates extracted data from the measurement data, and a browsing setting management unit that updates the first and second browsing setting data in response to a request from the user terminal. Is configured to create a screen for dividing and displaying the extracted data in a graph format and a table format based on the second browsing setting data and transmit the screen to the user terminal.

The measurement data acquired in each data collection slave is collected by the data collection master and stored as a database in the data collection master. The user can extract the measurement data from the database using the user terminal connected to the data collection master and display it on the screen. The browsing setting data defining the operation at the time of browsing the database is specified at the user terminal and used at the user terminal, but is stored in the data collection master unit. For this reason, even when browsing a database using a user terminal different from the previous time, the operation based on the same browsing setting data as the previous time can be performed, and the user does not need to repeat the same setting operation. . Further, the slave setting data used in each data collection slave can be updated from the user terminal connected to the data collection master. In addition, since the user terminal can acquire the slave unit setting data held in the data collection master unit, it is possible to prevent new setting data from being overwritten by old setting data. Therefore, the data collection master unit and each user terminal do not need to perform complicated version management on the slave unit setting data held by each.

In addition to the above configuration, the data collection system according to the second aspect of the present invention is a computer program that can be executed on the user terminal by the data collection master, and the screen of the measurement data based on the second browsing setting data A terminal program storage unit that stores a browsing program for display and a terminal program management unit that transmits the browsing program to the user terminal in response to a request from the user terminal.

  With such a configuration, the user terminal does not need to have installed a browsing program for performing screen display based on the database of the data collection parent device in advance. That is, a general-purpose computer such as a personal computer can be used immediately as a user terminal.

  According to the present invention, data collection that can simplify operations when a user terminal arbitrarily selected from two or more user terminals is connected to a data collection master and a database in the data collection master is browsed. A system can be provided. In particular, for the browsing setting data that can be arbitrarily set by the user, even when different user terminals are used, it is not necessary to repeat the same setting operation, and a highly convenient data collection system can be realized.

  Further, according to the present invention, a user terminal arbitrarily selected from two or more user terminals is connected to the data collection master unit, and the setting data of each data collection slave unit connected to the data collection master unit is easily updated. A data collection system can be provided. In particular, it is possible to realize a data collection system that can suppress inconsistency between setting data without performing complicated version management for the data collection master unit and each user terminal.

  FIG. 1 is a diagram showing an example of a measurement system including a data collection system according to an embodiment of the present invention. This measurement system is a system that collects and accumulates measurement data measured in each process of the production line, and includes a user terminal 4, a data collection system 5, and an external device 6.

  The external device 6 is a programmable controller (PLC) or a measuring device that is arranged in each process on the production line where products are sequentially conveyed and holds measurement data in each process, for example, dimension data and temperature data. . Two or more external devices 6 are connected to the data collection system 5, and the measurement data held by these external devices 6 is collected by the data collection system 5, converted into a database, and stored in the data collection system 5. Accumulated in.

  The data collection system 5 includes a data collection master unit 1 and a data collection slave unit 2 connected via a network 3. Here, one data collection master unit 1 and two or more data collection slave units 2 are connected via Ethernet (registered trademark), and IP ( Internet Protocol) packet transmission / reception.

  Each data collection slave unit 2 is connected to one or more external devices 6 and acquires measurement data from these external devices 6. This data acquisition process is started based on an instruction from the data collection master unit 1, and the measurement data acquired from the external device 6 is temporarily stored in the data collection slave unit 2 and then collected via the network 3. It is transmitted to the base unit 1. Moreover, the slave unit setting data that defines the operation of each data collection slave unit 2 is held in the data collection master unit 1 and downloaded from the data collection master unit 1 to the data collection slave unit 2 as necessary. The

  The data collection master unit 1 collects the measurement data accumulated in the data collection slave unit 2, records these measurement data in association with each other, and stores them in a database in the data collection master unit 1. Base unit setting data defining the operation of the data collection base unit 1 is transmitted from the user terminal 4 to the data collection base unit 1. Similarly, the slave unit setting data is also transmitted from the user terminal 4 to the data collection master unit 1 and stored in the data collection master unit 1. The slave unit setting data is then automatically downloaded from the data collection master unit 1 to the data collection slave unit 2 as necessary, and the setting process of each data collection slave unit 2 is automatically performed.

  The user terminal 4 is a terminal device connected to the data collection base unit 1, and for example, a portable personal computer such as a notebook personal computer is used. The user can update the parent device setting data and the child device setting data held in the data collection parent device 1 by using the user terminal 4. In addition, a database in the data collection master unit 1 can be browsed. The data collection process can be executed even when the user terminal 4 is not connected to the data collection master unit 1, and the user terminal 4 is connected to the data collection master unit 1 only when the user needs a terminal device. Connect to

  FIG. 2 is a block diagram showing a configuration example of the data collection master device 1 of FIG. The subunit | mobile_unit setting memory | storage part 111 hold | maintains each subunit | mobile_unit setting data about all the data collection subunit | mobile_units 2 which may be connected to the network 3. FIG. Specifically, it consists of a system program common to each data collection slave unit 2 and individual setting data indicating the acquisition timing of measurement data different for each data collection slave unit 2. The base unit setting storage unit 112 stores base unit setting data.

  The browsing setting storage unit 113 stores browsing setting data, and the terminal program storage unit 115 stores a browsing program. The browsing program is a computer program that can be executed on the user terminal 4 and defines a processing procedure for extracting measurement data from the database storage unit 114 and displaying it on the screen. The browsing setting data is data that defines the extraction conditions of the measurement data, the screen display method, and the like, and is used by the browsing program.

  The slave unit setting transmission unit 121 monitors the data collection slave unit 2 connected to the network 3 and transmits the slave unit setting data to the data collection slave unit 2 based on the monitoring result. For example, when a new data collection slave unit 2 is detected or when a data collection slave unit 2 holding old slave unit setting data is detected, a slave unit setting is performed for the data collection slave unit 2. The slave unit setting data held in the storage unit 111 is transmitted.

  The data collection unit 122 collects measurement data from each data collection slave unit 2 and stores it in the database storage unit 114. This data collection process is started based on the operation signal of the start button 123. When the user operates the start button 123, the data collection unit 122 transmits a collection start packet to each data collection slave unit 2, and then a data packet including measurement data is transmitted from each data collection slave unit 2. The data collection unit 122 that has received this data packet organizes these measurement data and stores them in the database storage unit 114.

  Next, interface means with the user terminal 4 will be described. The system setting management unit 101, the user authentication unit 102, the browsing setting management unit 103, the database management unit 104, and the terminal program management unit 105 are all interface means that operate based on a request from the user terminal 4.

  The system setting management unit 101 accesses the child device setting storage unit 111 and the parent device setting storage unit 112 in response to a request from the user terminal 4. That is, when a read request is received from the user terminal 4, the slave unit setting data and the master unit setting data are read and transmitted to the user terminal 4. If an update request is received from the user terminal 4, the slave unit setting data and the master unit setting data are updated.

  This update process is realized as a batch update process or a differential update process. The batch update process is a process of updating all data in the slave unit setting storage unit 111 and the master unit setting storage unit 112 in a batch. In addition, when the difference update process is performed for only a part of data in the slave unit setting storage unit 111 and the master unit setting storage unit 112, data updated from the user terminal 4 to the data collection master unit 1 ( (Difference data) only, and only a part of the data is updated. By performing the batch update process, it is possible to suppress the occurrence of inconsistency problems between setting data. Further, by performing the difference update process, the amount of data transmitted from the user terminal 4 to the data collection parent device 1 can be suppressed.

  The browsing setting management unit 103 accesses the browsing setting storage unit 113 in response to a request from the user terminal 4. That is, when a read request is received from the user terminal 4, the browsing setting data is read and transmitted to the user terminal 4. Moreover, if an update request is received from the user terminal 4, browsing setting data will be updated. This update process can also be updated for only some data in the browsing setting storage unit 113.

  In response to a request from the user terminal 4, the database management unit 104 reads measurement data from the database storage unit 114 and transmits it to the user terminal 4. The reading request for the measurement data is generated by the browsing program being executed on the user terminal 4.

  In response to a request from the user terminal 4, the terminal program management unit 105 reads the browsing program from the terminal program storage unit 115 and transmits it to the user terminal 4. For this reason, if the user terminal 4 can execute the browsing program, the user terminal 4 can browse the database in the data collection parent device 1 without installing the browsing program in advance.

  The user authentication unit 102 performs authentication processing when there is an access request from the user terminal 4 to the browsing setting storage unit 113. If the authentication process is successful, a permission signal is output from the user authentication unit 102 to the browsing setting management unit 103 and the browsing setting storage unit 113 can be accessed. If the authentication process fails, the browsing setting storage unit 113 is accessed. I can't. For example, the user authentication unit 102 requests the user terminal 4 to transmit a password, and then authenticates the user by comparing the password received from the user terminal 4 with a pre-registered password. .

  Each user whose password is registered is pre-assigned either an authority that can only be read or an authority that can be read and updated. For this reason, when a registered user has succeeded in the authentication process, only the access type assigned in advance to the user is permitted. In other words, if authentication is successful as a user having the authority of only reading, the browsing setting data can be read but cannot be updated.

  FIG. 3 is a diagram showing an example of a database stored in the database storage unit 114 of FIG. This database includes a plurality of data records R1 to R4, and is updated in units of data records R1 to R4. Each data record R1 to R4 includes a plurality of data fields F1 to F4, and date and time data and measurement data acquired from the external device 6 are stored in the fields F1 to F4. In FIG. 3, each row corresponds to data records R1 to R4, and each column corresponds to data fields F1 to F4.

  The data collection master unit 1 associates the measurement data collected from the data collection slave unit 2 to generate data records R1 to R4 and adds them to the database. Here, the extraction date / time information is assigned in advance to the data field F1, and the types of measurement data are assigned in advance to the data fields F2 to F4, and the data collection unit 122 measures the measurement data for the same product from the collected measurement data. Are extracted and data records R1 to R4 are generated together with the date and time information for extraction, and are sequentially added to the database.

  The date and time information for extraction is date and time data associated with the data records R1 to R4, and is used when extracting measurement data in units of the data records R1 to R4. This extraction date / time information is, for example, date / time data collected from the data collection slave unit 2 together with the measurement data stored in the fields F2 to F4 of the same data record. It is determined based on data indicating the date and time when the measurement data was acquired.

  FIG. 4 is a block diagram showing a configuration example of the data collection slave unit 2 of FIG. The data collection slave device 2 includes an operation setting unit 201, a setting data storage unit 202, a data acquisition unit 203, a measurement data storage unit 204, and a data transmission unit 205.

  The setting data storage unit 202 holds setting data that defines the operation of the data collection slave unit 2. This setting data is slave unit setting data given from the data collection master unit 1 via the network 3, and is stored in the setting data storage unit 202 by the operation setting unit 201.

  The data acquisition unit 203 acquires measurement data from the external device 6 and stores it in the measurement data storage unit 204. The timing for acquiring the measurement data is determined by the setting data in the setting data storage unit 202. That is, the data acquisition unit 203 acquires measurement data from the external device 6 every time the data acquisition condition specified by the setting data is satisfied.

  The data transmission unit 205 transmits the measurement data held in the measurement data storage unit 204 to the data collection master unit 1 via the network 3. This data transmission is periodically performed based on a time-up signal from a timer unit (not shown). Further, data transmission is also performed when a predetermined amount or more of measurement data is accumulated in the measurement data storage unit 204 so that the measurement data storage unit 204 does not overflow.

  FIG. 5 is a block diagram showing a configuration example of the user terminal 4 of FIG. The user terminal 4 includes a display unit 401, an input unit 402, a program execution unit (CPU) 403, an I / F (interface) unit 404, a program storage unit 405, and a data storage unit 406.

  The display unit 401 is a display device such as an LCD (liquid crystal display device) or a CRT (cathode ray tube), and performs screen display based on an instruction from the program execution unit 403. The input unit 402 is an input unit such as a keyboard or a pointing device. When the user performs an input operation, an input signal is output to the program execution unit 403. The I / F unit 404 is an interface circuit for performing communication when connected to the data collection master unit 1.

  The program storage unit 405 holds a program executed by the program execution unit 403. Here, it is assumed that a browsing program and a setting update program are stored. The browsing program defines a processing procedure for extracting measurement data from the data collection master 1 and displaying it on the screen. Also included is a processing procedure for updating the browsing setting data. This browsing program may be stored in advance in the program storage unit 405, but can be downloaded from the data collection master unit 1 if it is not stored in advance. The setting update program defines a processing procedure for updating the parent device setting data and the child device setting data held in the data collection parent device 1.

  The data storage unit 406 holds browsing setting data, parent device setting data, and child device setting data. The browsing setting data is used by the browsing program, and the update is also performed by the browsing program. The parent device setting data and the child device setting data are updated by the setting update program.

  The browsing setting data consists of parameters that can be specified by the user. By changing the browsing setting data, the measurement data can be extracted under a desired extraction condition and displayed on the screen by a desired display method. In addition, by reading out and using this browsing setting data from the data collection master unit 1, even when a different user terminal 4 is used, it is possible to browse the database under the same conditions as at the previous database browsing. it can. Furthermore, even if the database is browsed under conditions different from the previous time, only the different conditions need to be changed, so that the user operation can be simplified. If the changed browsing setting data is transmitted to the data collection master unit 1 and stored in the browsing setting storage unit 113, the database can be browsed under the same conditions next time.

  When the slave unit setting data and the master unit setting data held in the data collection master unit 1 are collectively updated, the slave unit setting data and the master unit setting data held in the data storage unit 406 of the user terminal 4 are The data is transmitted to the data collection master unit 1 in a batch by the setting update program. When updating a part of the slave unit setting data and the master unit setting data, the setting data is downloaded from the data collection master unit 1 and stored in the data storage unit 406, which is necessary in the data storage unit 406. After updating, the data is again sent to the data collection master unit 1 again. On the other hand, in the case of differential update, only the data updated by the setting update program among the data in the data storage unit 406 downloaded from the data collection master unit 1 is transmitted to the data collection master unit 1.

  FIG. 6 is a diagram illustrating an example of a relationship between a plurality of display screens displayed by the browsing program. In the figure, (a) is a data display screen, (b) is an extraction condition setting dialog, (c) is a data display setting dialog, (d) is a graph setting dialog, and (e) is a graph customization dialog. The data display screen (a) is a display screen on which measurement data is displayed in a graph format and a table format based on the browsing setting data. Dialogs (b) to (e) are display screens for the user to specify or change the browsing setting data, and operations on the dialogs (b) to (e) are changed to the contents of the data display screen (a). Influence.

  These dialogs (b) to (e) are activated as modal dialogs based on button operations on the data display screen (a). A modal dialog means that when a dialog is opened, other operations are prohibited until the dialog is closed. That is, after the dialogs (b) to (e) are activated, the operation on the data display screen (a) is prohibited until the dialog is closed.

  FIG. 7 is a diagram showing an example of the data display screen (a) of FIG. The data display screen is divided into a graph display area a1 and a table display area a2. In these areas a1 and a2, the same measurement data is displayed in different formats. The measurement data used for these displays is measurement data extracted from the database according to the extraction conditions as browsing setting data.

  The extraction condition setting dialog (b) is a dialog for specifying an extraction condition for extracting the data records R1 to R4 from the database in the data collection master unit 1, and is extracted based on the extraction condition specified on the dialog. The measurement data of the data records R1 to R4 are displayed on the data display screen (a).

  The data display setting dialog (c) is a dialog for designating data fields F1 to F4 to be displayed on the data display screen (a). That is, only the designated data fields F1 to F4 of the data records R1 to R4 extracted based on the designated extraction condition are displayed on the data display screen (a).

  The graph setting dialog (d) is a dialog for designating basic matters for performing graph drawing in the graph display area a1 of the data display screen (a). For example, the type of graph is selected and specified from a line graph, bar graph, scatter diagram, histogram, and the like. In addition, a data series assigned to each axis of the graph is designated. Here, any of the database fields F1 to F4 is designated as the data series.

  The graph customization dialog (e) is a dialog for designating incidental items related to graph drawing. For example, the color of the graph, the display size of characters, the label display of each axis, etc. are specified.

  Next, the extraction process by a browsing program is demonstrated. The extraction process for extracting specific data records R1 to R4 from the database in the data collection master unit 1 is performed based on the extraction conditions in the browsing setting data. As the extraction condition, a period during which the measurement data is acquired and a range of the measurement data itself are used. Also, a logical expression using the logical product and logical sum of these extraction conditions can be used as the extraction condition.

  As the extraction condition, a period is designated for the date and time information for extraction, and a numerical range or a character string is designated for the measurement data. First, as the extraction condition for the extraction date / time information, the period is specified using the start point date / time and the end point date / time. The start date / time and the end date / time can be input by direct designation or relative designation. Direct designation is a method of directly designating date and time using year, month, day, hour, minute and second. Relative designation is a method of designating a period going back from a reference date and time such as the current date and time using year, month, day, hour, minute and second. Both the start point date and time and the end point date and time can be specified using any one of direct designation and relative designation, and may be a combination in which one is designated directly and the other is designated relative.

  In direct designation, it is also possible to periodically designate a period as an extraction condition. For example, if the start point date and time is designated as “January 1” and the end point date and time is designated as “January 31”, measurement data from January 1 to January 31 can be extracted every year. Similarly, if the start point date and time is designated as “9 o'clock” and the end point date and time is designated as “17:00”, measurement data from 9:00 to 17:00 every day can be extracted.

  FIG. 8 is an explanatory diagram showing an example of a method for designating extraction conditions by relative designation. FIG. 8A shows the relative specification of the data record extraction period using “time point”. Here, at the current time on January 20, 2005, 13:20:15, the period from the current date, which is the reference date, to “2 days” is designated as “2 days”. Similarly, for the end point date and time, the period going back from the “current” which is the reference date and time is designated as “one day”. By specifying in this way, data records R1 to R4 whose extraction date and time information is in the range from January 18, 2005, 13:20:15 to January 19, 2005, 13:20:15 are extracted. .

  On the other hand, FIG. 8B shows the relative designation of the data record extraction period using “period”. Here, at the current time on January 20, 2005, 13:20:15, the period from the current date, which is the reference date, to “2 days” is designated as “2 days”. Similarly, for the end point date and time, the period going back from the “current” which is the reference date and time is designated as “one day”. By specifying in this way, the date and time information for extraction is two days from January 18th to 19th, 2005, that is, January 18, 2005 0:00:00 to January 19, 2005 24:00:00. Data records R1 to R4 in the range of 0 second (January 20, 2005 0: 0: 0) are extracted.

  FIG. 9 is a diagram showing an example of the extraction condition setting dialog (b) in FIG. The input screen is easy for the user to input by using the GUI. In addition, the user can easily specify the specified item with the pointing device. Either the direct designation or relative designation can be selected as the start point date and end point date. In FIG. 9, “direct designation” is designated in the column 600 as the start point date designation method, and “relative designation” is designated in the column 700 as the end point date designation method.

  Here, direct designation is specified for the start date and time, and year, month, day, hour, minute, and second are entered in the fields 611 to 616. If the “Ignore setting” check box is checked, the specification in that part is ignored. Here, if a check is entered in 621, the designation of “year” is ignored, and the period entered below “month” is designated repeatedly every year. If a check is made in 616, designation of “second” is ignored, and designation is made in a period of “minute”.

  In addition, relative designation is designated for the end date and time, and periods dating back from the present are entered in the fields 701 and 702. A numerical value is input in 701 and a unit is input in 702, respectively. Here, if a check is entered in 703, units smaller than the specified unit are ignored. In FIG. 9, since “day before” is entered in the field 702, if the check is put in 703, the unit below “time” is ignored, and designation is made in a period of “day”.

  Also, the day of the week can be specified as the extraction condition for the extraction date / time information. At this time, when a plurality of days of the week are designated, a period obtained by performing a logical sum of the designated days of the week is an extraction condition. In this case, day-of-week data is calculated from the extraction date / time information in each of the data records R1 to R4, and compared with the day of the extraction condition.

  Next, the range of the measurement data itself can be specified as the extraction condition. At this time, data fields F2 to F4 to be compared with the extraction condition are designated, and the type of measurement data to be compared with the extraction condition is designated. In addition, about the range of measurement data, at least one of an upper limit value and a lower limit value is designated.

  The user can also specify a character string as the extraction condition. In this case, even if the data included in the measurement data is a numerical value, the numerical value is regarded as a character string and compared with the extraction condition. For this reason, the measurement data collected in the database may consist only of numerical values or may include character strings other than numerical values.

  Furthermore, when a character string is specified as the extraction condition, it can be specified using a so-called regular expression. That is, the extraction condition can be that the designated character string matches a part of the measurement data. The character string used as the extraction condition may be a plurality of characters or a single character.

  In addition, the extraction condition can be specified not only for date / time data and specific types of measurement data, but also a conditional expression combining them can be specified as the extraction condition. This conditional expression is a combination of individual conditions such as the period of extraction date information and the range of measurement data itself, such as logical product or logical sum.

It is the figure which showed an example of the measurement system containing the data collection system by embodiment of this invention. FIG. 2 is a block diagram illustrating a configuration example of a data collection parent device 1 in FIG. 1. It is the figure which showed an example of the database stored in the database memory | storage part 114 of FIG. It is the block diagram which showed one structural example of the data collection subunit | mobile_unit 2 of FIG. It is the block diagram which showed the example of 1 structure of the user terminal 4 of FIG. It is the figure which showed an example about the relationship between the some display screens displayed with a browsing program. It is the figure which showed an example of the data display screen (a) of FIG. It is explanatory drawing which showed an example of the designation | designated method of the extraction conditions by relative designation | designated. It is the figure which showed an example of the extraction condition setting dialog (b) of FIG.

Explanation of symbols

1 Data Collection Master Unit 2 Data Collection Slave Unit 4 User Terminal 5 Data Collection System 6 External Device 101 System Setting Management Unit 102 User Authentication Unit 103 Viewing Setting Management Unit 104 Database Management Unit 105 Terminal Program Management Unit 111 Slave Unit Setting Storage Unit 112 Base unit setting storage unit 113 Browsing setting storage unit 114 Database storage unit 115 Terminal program storage unit 121 Slave unit setting transmission unit 122 Data collection unit 123 Start button

Claims (2)

A plurality of data collection slave units each for acquiring measurement data from an external device including a programmable controller, and a data collection master unit for collecting the measurement data acquired by each of the data collection slave units, the data collection master unit Is a data collection system that can be connected to user terminals.
The data collection slave unit acquires the measurement data at an acquisition timing based on an instruction from the data collection master unit, adds the time information when the measurement data is acquired, and transmits the data to the data collection master unit With an acquisition unit,
The data collection parent device whose operation is defined based on the parent device setting data transmitted from the user terminal includes common setting data including a system program common to the data collection child device transmitted from the user terminal, A slave unit setting storage unit for holding slave unit setting data including individual setting data including the type of measurement data and acquisition timing of the data collection slave unit, and a setting for transmitting the slave unit setting data to each of the data collection slave units Based on a data transmission unit, a system setting management unit that updates the slave unit setting data and transmits it to the user terminal in response to a request from the user terminal, and based on the individual setting data from each of the data collection slave units de to a data acquisition unit for receiving acquired the measured data and time information, and the measurement data and the time information received is stored in association with A database, a browsing setting storage unit that holds first browsing setting data that defines an extraction condition based on the time information, and second browsing setting data that defines a screen display of the user terminal, and the database according to the extraction condition A database management unit that creates extracted data from the measurement data in the database, and a browsing setting management unit that updates the first and second browsing setting data in response to a request from the user terminal,
The browsing setting management unit creates a screen for dividing and displaying the extracted data in a graph format and a table format based on the second browsing setting data, and transmits the screen to the user terminal. The data collection master is a computer program that can be executed on the user terminal, and a terminal program storage unit that stores a browsing program for performing screen display of the measurement data based on second browsing setting data;
The data collection system according to claim 1, further comprising: a terminal program management unit that transmits the browsing program to the user terminal in response to a request from the user terminal.

Images