SQL Query Translation for Industrial Point and Relational Data Integration
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional industrial systems face difficulties in integrating Application Programming Interfaces (APIs) to access both real-time/historic point data and relational data using existing client applications, which limits their ability to provide comprehensive data retrieval and analysis.
Innovation Solution
A system and method that receives a Structured Query Language (SQL) query, determines point data and relational data queries, transmits them to respective servers, and joins the received data into a result rowset, enabling seamless integration of point data from industrial processes with relational data stored in databases.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If standard or proprietary APIs are used to acquire point data from point data sources and data historians, then point data can be accessed, but the APIs are difficult to integrate into existing applications
Solution Approach 1:
The patent introduces an intermediary component that translates between standard SQL queries and proprietary point data API calls. This mediator layer allows existing SQL-based applications to access point data without direct integration of complex proprietary APIs, resolving the contradiction by hiding integration complexity behind a standardized interface.
Solution Approach 2:
The patent creates a universal access mechanism that allows a single SQL-based interface to access multiple data sources (point data, relational data, historical data) through a common protocol. This multi-functional approach eliminates the need for application-specific integration code for each data source type.
2Adaptability or versatility
If existing client applications are designed to issue queries that comply with a standardized query language to access relational data, then relational data access is simplified, but the ability to access point data is limited
Solution Approach 1:
The patent merges point data access and relational data access into a unified SQL query processing system. The system combines previously separate code paths for accessing point data (via proprietary APIs) and relational data (via SQL) into a single integrated architecture that handles both through standardized SQL interfaces.
Solution Approach 2:
The patent adds a new dimension to data access by introducing a translation layer that maps SQL query operations to point data API operations. This dimensional addition allows the system to maintain SQL standard compliance while extending capability to point data sources that previously required proprietary access methods.
Data Source
AI summary
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.