Control system, control device, coupling method, and computer program

• US 10,831,170 B2
• Filed: 05/18/2018
• Issued: 11/10/2020
• Est. Priority Date: 06/28/2017
• Status: Active Grant

• Current Assignee: Omron Corporation
• Original Assignee: Omron Corporation
• Inventors: Kawanoue, Shinsuke
• Primary Examiner(s): Cao, Phuong Thao
• Application Number:
  US15/983,744
• Publication Number:
  US 20190004493A1
• Time in Patent Office: 907 Days
• Field of Search: 707722
• CPC Class Codes: G05B 19/0428 Safety, monitoring G05B19/0423 takes precedence
• CPC Class Codes: G05B 19/054 Input/output
• CPC Class Codes: G05B 2219/1101 Remote I-O
• CPC Class Codes: G05B 2219/13144 GUI graphical user interface, icon, function bloc editor, OI operator interface
• CPC Class Codes: G06F 16/2465 Query processing support for facilitating data mining operations in structured databases
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 16/2474 Sequence data queries, e.g. querying versioned data
• CPC Class Codes: G06F 16/2477 Temporal data queries
• CPC Class Codes: G06F 16/248 Presentation of query results

Abstract

An item for designating a time stamp accuracy is added to an inquiry syntax of a query. At the time of table coupling, a query designating the desired accuracy in the item is transmitted. This query is analyzed by a query parser, and individual queries are created for each database targeted for inquiry and transmitted. At the time of coupling acquired tables, the number of digits of the time stamps is adjusted to be the same in accordance with the designated accuracy, and the tables are coupled in chronological order of the time stamps.

Claims

1. A control system comprising:

a first database configured to store records, each record comprising data and a time stamp; and

a control device comprising;

a second database configured to store records, each record comprising data and a time stamp; and

a processor configured with a program to perform operations comprising;

operation as a creation unit configured to create a common query comprising a designated time range for retrieving records from the first database and the second database having time stamps within the designated time range, and a designated time stamp accuracy value;

operation as a query parser configured to analyze the common query and create;

a first individual query addressed to the first database; and

a second individual query addressed to the second database;

operation as a transmission unit configured to transmit the first individual query to the first database and the second individual query to the second database; and

operation as a coupling unit configured to generate a coupled table comprising records in which data of records returned from the first database within the designated time range and data of records returned from the second database within the designated time range are coupled, each record of the coupled table comprising a common time stamp of the designated time stamp accuracy value, wherein at least one of;

time stamps of the records returned from the first database in response to the first individual query; and

time stamps of the records returned from the second database in response to the second individual query are processed based on the designated time stamp accuracy value of the common query.

2. The control system according to claim 1, wherein the designated time stamp accuracy value comprises a number of digits away from a decimal point;

and

the processor is configured with the program such that operation as the coupling unit comprises rounding down or rounding up a number of digits of the time stamps of the records returned from the first database and the time stamps of the records returned from the second database, based on a distance from the decimal point as compared to the designated time stamp accuracy value.

3. The control system according to claim 1,

wherein the processor is configured with the program such that operation as the coupling unit comprises:

converting the records returned from one of the first database and the second database, whichever returns the largest number of records, into converted records comprising data having an average value per unit of time such that the number of the converted records equals the number of records returned from the other of the first database and the second database; and

coupling the converted records and the records returned from the other of the first database and the second database.

4. The control system according to claim 1,

wherein the processor is configured with the program such that operation as the coupling unit comprises:

converts converting the records returned from one of the first database and the second database, whichever returns the largest number of records, into converted records comprising data having one of a largest value and a smallest value within a unit of time such that the number of the converted records equals the number of records returned from the other of the first database and the second database; and

coupling the converted records and the records returned from the other of the first database and the second database.

5. The control system according to claim 1, wherein the processor is configured with the program to perform operations further comprising:

operation as a setting unit configured to set the designated time stamp accuracy value, based on the time stamps of the records returned from the first database and the time stamps of the records returned from the second database,

wherein the processor is configured with the program such that operation as the coupling unit comprises generating the coupled table based on the designated time stamp accuracy value set by the setting unit.

6. A control device applicable to a control system comprising a first database configured to store records, each record comprising data and a time stamp and a second database configured to store records, each record comprising data and a time stamp, the control device comprising a processor configured with a program to perform operations comprising:

operation as a creation unit configured to create a common query comprising a designated time range for retrieving records from the first database and the second database having time stamps within the designated time range, and a designated time stamp accuracy value;

operation as a query parser configured to analyze the common query and create;

a first individual query addressed to the first database; and

a second individual query addressed to the second database;

operation as a transmission unit configured to transmit the first individual query to the first database and the second individual query to the second database; and

operation as a coupling unit configured to generate a coupled table comprising records in which data of records returned from the first database within the designated time range and data of records returned from the second database within the designated time range are coupled, each record of the coupled table comprising a common time stamp of the designated time stamp accuracy value, wherein

at least one of;

time stamps of the records returned from the first database in response to the first individual query; and

time stamps of the records returned from the second database in response to the second individual query are processed based on the designated time stamp accuracy value of the common query.

7. The control device according to claim 6, wherein the designated time stamp accuracy value comprises a number of digits away from a decimal point;

and

the processor is configured with the program such that operation as the coupling unit comprises rounding down or rounding up a number of digits of the time stamps of the records returned from the first database and the time stamps of the records returned from the second database based on a distance from the decimal point as compared to the designated time stamp accuracy value.

8. The control device according to claim 6,

wherein the processor is configured with the program such that operation as the coupling unit comprises

converting the records returned from one of the first database and the second database, whichever returns the largest number of records, into converted records comprising data having an average value per unit of time such that the number of the converted records equals the number of records returned from the other of the first database and the second database;

and

coupling the converted records and the records returned from the other of the first database and the second database.

9. The control device according to claim 6, wherein the processor is configured with the program such that operation as the coupling unit comprises:

converting the records returned from one of the first database and the second database, whichever returns the largest number of records, into converted records comprising data having one of a largest value and a smallest value within a unit of time such that the number of the converted records equals the number of records returned from the other of the first database and the second database; and

coupling the converted records and the records returned from the other of the first database and the second database.

10. The control device according to claim 6, wherein the processor is configured with the program to perform operations further comprising:

operation as a setting unit configured to set the designated time stamp accuracy value, based on the time stamps of the records returned from the first database and the time stamps of the records returned from the second database,

wherein the processor is configured with the program such that operation as the coupling unit comprises generating the coupled table based on the designated time stamp accuracy value set by the setting unit.

11. A coupling method that is executed by a control device applicable to a control system comprising a first database configured to store records, each record comprising data and a time stamp, and a second database configured to store records, each record comprising data and a time stamp, the coupling method comprising:

creating a common query comprising a designated time range, for retrieving records from the first database and the second database having time stamps within the designated time range, and a designated time stamp accuracy value;

analyzing the common query and creating a first individual query addressed to the first database and a second individual query addressed to the second database;

transmitting the first individual query to the first database and the second individual query to the second database; and

generating a coupled table comprising records in which data of records returned from the first database within the designated time range and data of records returned from the second database within the designated time range are coupled, each record of the coupled table comprising a common time stamp of the designated time stamp accuracy value, wherein

at least one of;

time stamps of the records returned from the first database in response to the first individual query; and

time stamps of the records returned from the second database in response to the second individual query are processed based on the designated time stamp accuracy value of the common query.

12. The method according to claim 11, wherein the designated time stamp accuracy value comprises a number of digits away from a decimal point;

and

generating the coupled table comprises rounding down or rounding up a number of digits of the time stamps of the records returned from the first database and the time stamps of the records returned from the second database, based on a distance from the decimal point as compared to the designated time stamp accuracy value.

13. The method according to claim 11, wherein generating the coupled table comprises converting the records returned from one of the first database and the second database, whichever returns the largest number of records, into converted records comprising data having an average value per unit of time such that the number of the converted records equals the number of records returned from the other of the first database and the second database;

and

coupling the converted records and the records returned from the other of the first database and the second database.

14. The method according to claim 11, wherein generating the coupled table comprises converting the records returned from one of the first database and the second database, whichever returns the largest number of records, into converted records comprising data having one of a largest value and a smallest value within a unit of time such that the number of the converted records equals the number of records returned from the other of the first database and the second database;

and

coupling the converted records and the records returned from the other of the first database and the second database.

15. The method according to claim 11, further comprising setting the designated time stamp accuracy value based on the time stamps of the records returned from the first database and the time stamps of the records returned from the second database.

16. A non-transitory computer-readable storage medium storing a computer program for causing a computer provided in a control device applicable to a control system comprising a first database configured to store records, each record comprising data and a time stamp, and a second database configured to store records, each record comprising data and a time stamp, to perform operations comprising:

creating a common query comprising a designated time range, for retrieving records from the first database and the second database having time stamps within the designated time range, and a designated time stamp accuracy value;

analyzing the common query and creating a first individual query addressed to the first database and a second individual query addressed to the second database;

transmitting the first individual query to the first database and the second individual query to the second database; and

generating a coupled table comprising records in which data of records returned from the first database within the designated time range and data of records returned from the second database within the designated time range are coupled, each record of the coupled table comprising a common time stamp of the designated time stamp accuracy value, wherein

at least one of;

time stamps of the records returned from the first database in response to the first individual query; and

time stamps of the records returned from the second database in response to the second individual query, are processed based on the designated time stamp accuracy value of the common query.