发明名称 Database query language gateway
摘要 A method includes receiving a query request, generating a modified query in a database query language by modifying a stored query in the database query language based on the query request, and transmitting the modified query to a database endpoint. The method includes receiving query results in the database query language and converting by the processor the query results from the database query language to a format usable by a reporting engine.
申请公布号 US9384248(B2) 申请公布日期 2016.07.05
申请号 US201313914107 申请日期 2013.06.10
申请人 INTERNATIONAL BUSINESS MACHINES CORPORATION 发明人 Ryman Arthur G.
分类号 G06F17/30 主分类号 G06F17/30
代理机构 Cantor Colburn LLP 代理人 Cantor Colburn LLP ;Lewis Ryan
主权项 1. A method of corresponding by a database endpoint and a gateway, comprising: receiving, by the gateway, a query request based on a user input, wherein the query request includes query parameters and a data service uniform resource locator; extracting, by the gateway, the query parameters from the query request; translating, by the gateway, the query parameters from the query request into a database query language; generating, by the gateway, a modified query including the query parameters in the database query language; transmitting, by the gateway, the modified query to the database endpoint; receiving, by the database endpoint, the modified query from the gateway; accessing, by the database endpoint in response to receiving the modified query from the gateway, data of a database based on the modified query; generating, by the database endpoint, query results in the database query language in accordance with the accessing of the data, wherein the database endpoint is external to the gateway and the database, wherein the database is external to the gateway; receiving, by the gateway, the query results in the database query language in response to the modified query; converting, by the gateway, the query results from the database query language to a format executable by a reporting engine; transmitting, by the gateway, the query results in the format executable by the reporting engine to the reporting engine; and generating, by the reporting engine, a report in direct correspondence with the query request, based on the query results, and in response to receiving the query results from the gateway, wherein the format is a reporting engine compatible format that enables the report to be generated by the reporting engine, wherein the receiving of the query request includes parsing, with a processor of the gateway, the query parameters, wherein the query parameters are defined by a Reportable Representational State Transfer (Reportable REST) specification, wherein the query parameters specify filtering conditions, wherein the generating of the modified query includes transforming the query parameters into SPARQL Protocol and RDF Query Language (SPARQL) graph patterns, retrieving a SPARQL query associated with the data service uniform resource locator, and adding the SPARQL graph patterns to the SPARQL query to generate a modified SPARQL query, and wherein the reporting engine, which is not configured to communicate with the database, obtains the query results via the gateway.
地址 Armonk NY US