Efficient SQL access to point data and relational data

• US 8,078,598 B2
• Filed: 01/08/2007
• Issued: 12/13/2011
• Est. Priority Date: 01/09/2006
• Status: Active Grant

• Current Assignee: Siemens AG
• Original Assignee: Siemens AG
• Inventors: Bell, Trevor, Milam, Christopher Patrick
• Primary Examiner(s): DANG, THANH HA T
• Application Number:
  US11/651,199
• Publication Number:
  US 20090327212A1
• Time in Patent Office: 1,800 Days
• Field of Search: 707/1, 707/2, 707/3, 707/999.001, 707/999.002, 707/999.003, 707/705, 707/706, 707/714, 707/754, 707/755, 707/756, 707/771, 707/772, 707/791, 707/802
• US Class Current: 707/705
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

Some embodiments include reception of a structured query language query, determination of at least one point data query and at least one relational data query based on the structured query language query, transmission of the at least one point data query to at least one point data server, transmission of the at least one relational data query to at least one relational data server, reception of point data and relational data in response to the point data query and the relational data query, and joining of the received point data and the received relational data into a result rowset.

Claims

1. A method comprising:

receiving, by a processor, a structured query language query;

determining, by the processor, at least one point data query and at least one relational data query based on the structured query language query;

transmitting the at least one point data query to at least one point data server;

transmitting the at least one relational data query to at least one relational data server;

receiving, by the processor, point data and relational data in response to the point data query and the relational data query; and

joining, by the processor, the received point data and the received relational data into a result rowset;

wherein the receiving point data and relational data in response to the point data query and the relational data query comprises;

receiving, from the at least one point data server in response to the at least one point data query that is based on the structured query language query, point data that has been collected from multiple heterogeneous sources based on components defined according to a class-based object model and encapsulated as object instantiations of the components;

wherein the at least one point data server is to receive the object instantiations of the components defined according to the class-based object model; and

wherein the point data is current, real-time or value data associated with one or more instruments, components, or portions of a manufacturing, industrial, commercial, or other system.

2. The method according to claim 1, wherein the point data is derived from an industrial process.

3. The method according to claim 2, wherein the industrial process comprises a continuous process.

4. The method according to claim 2, wherein the industrial process comprises operations of facilities involved in at least one of manufacturing, assembly, natural resource procurement, natural resource refinement, chemical synthesis, water treatment, power generation, power transmission, food processing, beverage processing, raw materials processing, agricultural processing, and materials processing.

5. The method according to claim 4, wherein the natural resource procurement comprises procurement of at least one of oil and natural gas, and wherein the natural resource refinement comprises refinement of at least one of oil and natural gas.

6. The method according to claim 1, wherein determining the at least one point data query and the at least one relational data query based on the structured query language query comprises:

determining a plurality of data tables associated with the structured query language query;

determining a data handling class associated with each of the plurality of data tables; and

executing each determined data handling class to determine a reader for each of the plurality of data tables.

7. The method according to claim 6, wherein transmitting the at least one point data query to at least one point data server comprises:

calling a determined point data reader for each of the plurality of data tables associated with point data, and

wherein transmitting the at least one relational data query to at least one relational data server comprises;

passing a second structured query language query for each of the plurality of data tables associated with relational data.

8. The method according to claim 1, wherein joining the received point data and the received relational data into a result rowset comprises:

synthesizing a first rowset based on the received point data;

synthesizing a second rowset based on the received relational data; and

combining the first rowset and the second rowset into the result rowset based on columns specified in the structured query language query.

9. The method according to claim 1, wherein the at least one point data query is separate from the at least one relational data query.

10. A non-transitory computer readable medium storing computer-executable program code, the program code comprising:

code to receive a structured query language query;

code to determine at least one point data query and at least one relational data query based on the structured query language query;

code to transmit the at least one point data query to at least one point data server;

code to transmit the at least one relational data query to at least one relational data server;

code to receive point data and relational data in response to the point data query and the relational data query; and

code to join the received point data and the received relational data into a result rowset;

wherein the code to receive point data and relational data in response to the point data query and the relational data query comprises;

code to receive, from the at least one point data server in response to the at least one point data query that is based on the structured query language query, point data that has been collected from multiple heterogeneous sources based on components defined according to a class-based object model and encapsulated as object instantiations of the components; and

wherein the at least one point data server is to receive the object instantiations of the components defined according to the class-based object model; and

wherein the point data is current, real-time or value data associated with one or more instruments, components, or portions of a manufacturing, industrial, commercial, or other system.

11. The non-transitory computer readable medium according to claim 10, wherein the point data is derived from an industrial process.

12. The non-transitory computer readable medium according to claim 11, wherein the industrial process comprises a continuous process.

13. The non-transitory computer readable medium according to claim 11, wherein the industrial process comprises operations of facilities involved in at least one of manufacturing, assembly, natural resource procurement, natural resource refinement, chemical synthesis, water treatment, power generation, power transmission, food processing, beverage processing, raw materials processing, agricultural processing, and materials processing.

14. The non-transitory computer readable medium according to claim 13, wherein the natural resource procurement comprises procurement of at least one of oil and natural gas, and wherein the natural resource refinement comprises refinement of at least one of oil and natural gas.

15. The non-transitory computer readable medium according to claim 10, wherein the code to determine the at least one point data query and the at least one relational data query based on the structured query language query comprises:

code to determine a plurality of data tables associated with the structured query language query;

code to determine a data handling class associated with each of the plurality of data tables; and

code to execute each determined data handling class to determine a reader for each of the plurality of data tables.

16. The non-transitory computer readable medium according to claim 15, wherein the code to transmit the at least one point data query to at least one point data server comprises:

code to call a determined point data reader for each of the plurality of data tables associated with point data, and

wherein the code to transmit the at least one relational data query to at least one relational data server comprises;

code to pass a second structured query language query for each of the plurality of data tables associated with relational data.

17. The non-transitory computer readable medium according to claim 10, wherein the code to join the received point data and the received relational data into a result rowset comprises:

code to synthesize a first rowset based on the received point data;

code to synthesize a second rowset based on the received relational data; and

code to combine the first rowset and the second rowset into the result rowset based on columns specified in the structured query language query.

18. The non-transitory computer readable medium according to claim 10, wherein the at least one point data query is separate from the at least one relational data query.

19. A system comprising:

a device to provide;

a data provider to receive a structured query language query, to determine at least one point data query and at least one relational data query based on the structured query language query, to transmit the at least one point data query, and to transmit the at least one relational data query;

one or more devices to provide;

at least one point data server to receive the at least one point data query and to transmit point data to the data provider in response; and

at least one relational data server to receive the at least one relational data query and to transmit relational data to the data provider in response,

wherein the data provider is further to join the point data and the relational data into a result rowset;

wherein the at least one point data server to receive the at least one point data query and to transmit point data to the data provider in response comprises;

at least one point data server to receive the at least one point data query that is based on the structured query language query and to transmit point data, to the data provider, that has been collected from multiple heterogeneous sources based on components defined according to a class-based object model and encapsulated as object instantiations of the components; and

wherein the at least one point data server is to receive the object instantiations of the components defined according to the class-based object model; and

wherein the point data is current, real-time or value data associated with one or more instruments, components, or portions of a manufacturing, industrial, commercial, or other system.

20. The system according to claim 19, wherein the point data is derived from a continuous industrial process.

21. The system according to claim 20, wherein the industrial process comprises operations of facilities involved in at least one of manufacturing, assembly, natural resource procurement, natural resource refinement, chemical synthesis, water treatment, power generation, power transmission, food processing, beverage processing, raw materials processing, agricultural processing, and materials processing.

22. The system according to claim 19, wherein determination of the at least one point data query and the at least one relational data query based on the structured query language query comprises:

determination of a plurality of data tables associated with the structured query language query;

determination of a data handling class associated with each of the plurality of data tables; and

execution of each determined data handling class to determine a reader for each of the plurality of data tables.

23. The system according to claim 22, wherein transmission of the at least one point data query to at least one point data server comprises:

calling of a determined point data reader for each of the plurality of data tables associated with point data, and

wherein transmission of the at least one relational data query to at least one relational data server comprises;

passage of a second structured query language query for each of the plurality of data tables associated with relational data.

24. The system according to claim 19, wherein joining of the received point data and the received relational data into a result rowset comprises:

synthesis of a first rowset based on the received point data;

synthesis of a second rowset based on the received relational data; and

combination of the first rowset and the second rowset into the result rowset based on columns specified in the structured query language query.

25. The system according to claim 19, wherein the at least one point data query is separate from the at least one relational data query.