主权项 |
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. |