Back to results
US 10,474,676 B2Granted
Database query language gateway
AssigneeInternational Business Machines Corporation
InventorArthur G. Ryman
Life of this patent
Estimating the term…
Abstract
The disclosed herein relates to a database endpoint device, a database, and a gateway. The database is external to and communicatively coupled to the database endpoint device. The database includes a memory storing data. The gateway is external to and communicatively coupled to the database endpoint device. The gateway includes a controller. A data service is provided to at least one program. The data is provided via the data service as requested by the at least one program.
Claims12
A system comprising:
- a database endpoint device;
- a database, external to and communicatively coupled to the database endpoint device, comprising a memory storing data;
- a reporting engine not configured to communicate with the database;
- and
- a gateway, external to and communicatively coupled to the database endpoint device, comprising a controller, the gateway being configured to include a plurality of pre-stored SPARQL queries that are modifiable by query requests,
- wherein the controller of the gateway, on behalf of the system:
- receives from at least one program a query request including query parameters and locator of a data service,
- in response to the query request, provides the data service to the at least one program by
- retrieving from a query resource unit of the gateway a pre-stored SPARQL query of the plurality of pre-stored SPARQL queries and modifying the pre-stored SPARQL query to generate a modified query comprising the query parameters from the query request translated into a database query language,
- transmitting the modified query to the database endpoint device, the modified query being a SPARQL query,
- receiving query results in the database query language in response to the modified query,
- converting the query results from the database query language to a format including a Reportable Representational State Transfer data source accessible and executable by the reporting engine,
- transmitting the converted query results to the reporting engine, the converted query results being in the format accessible and executable by the reporting engine, and
- wherein the database, on behalf of the system, provides the data via the data service of the gateway as requested by the at least one program,
- wherein the database endpoint device, on behalf of the system, receives the modified query from the gateway, and
- wherein the reporting engine obtains the converted query results via the transmitting by the gateway and generates a report in direct correspondence with the converted query results and format thereof.
13 more elements
A method comprising:
- communicatively coupling a database endpoint device and a database comprising a memory storing data, wherein the database is external to the database endpoint device;
- communicatively coupling the database endpoint device and a gateway comprising a controller, wherein the gateway is external to the database endpoint device, the gateway being configured to include a plurality of pre-stored SPARQL queries that are modifiable by query requests;
- communicatively coupling the gateway and a reporting engine not configured to communicate with the database;
- receiving, by the controller of the gateway from at least one program, a query request including query parameters and locator of a data service;
- providing, by the controller of the gateway in response to the query request, the data service to the at least one program by
- retrieving from a query resource unit of the gateway a pre-stored SPARQL query of the plurality of pre-stored SPARQL queries and modifying the pre-stored SPARQL query to generate a modified query comprising the query parameters from the query request translated into a database query language,
- transmitting, by the gateway, the modified query to the database endpoint device, the modified query being a SPARQL query,
- receiving, by the gateway, query results in the database query language in response to the modified query,
- converting, by the controller of the gateway, the query results from the database query language to a format including a Reportable Representational State Transfer data source accessible and executable by the reporting engine,
- transmitting the converted query results to the reporting engine, the convened query results being in the format accessible and executable by the reporting engine;
- providing, by the database, the data via the data service as requested by the at least one program;
- receiving, by the database endpoint device, the modified query from the gateway;
- obtaining, by the reporting engine, the converted query results via the transmitting by the gateway;
- and
- generating, by the reporting engine, a report in direct correspondence with the converted query results and format thereof.
12 more elements
Dependencies are inferred from the claim text.