Interoperable shared query based on heterogeneous data sources

• US 9,275,121 B2
• Filed: 01/03/2013
• Issued: 03/01/2016
• Est. Priority Date: 01/03/2013
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Ah-Soon, Christian, Tsoungui, Olivier
• Primary Examiner(s): TRUONG, CAM Y T
• Application Number:
  US13/733,531
• Publication Number:
  US 20140188845A1
• Time in Patent Office: 1,153 Days
• Field of Search: 707/722
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases

Abstract

The disclosure generally describes computer-implemented methods, software, and systems for creating and using shared queries based on heterogeneous data sources. One example method includes receiving a request to execute a shared query, identifying at least one data source and a query specification associated with the shared query, generating a native query for each identified data source based on the identified query specification, executing the generated native queries at the respective data sources to collect a set of query results from the respective data sources, and formatting the set of query results from the respective data sources into a unified set of query results.

Claims

1. A computer-implemented method executed by at least one processor, the method comprising:

receiving, by a computer system, a request to execute a shared query, wherein the shared query comprises one of a plurality of pre-defined shared queries, and the shared query comprises a pre-defined query specification associated with the shared query, the query specification comprising pre-defined connections to a first and a second data sources associated with the shared query, the query specification specifying the shared query on a semantic layer and including search terms, parameters, filters, and aspects of the shared query to be used at runtime upon execution of the shared query, where each pre-defined shared query of the plurality of pre-defined shared queries is associated with a corresponding set of access rights, and wherein the request to execute the shared query represents a specific request to execute a particular shared query from the plurality of pre-defined shared queries from a particular application or user;

in response to receiving the request, determining whether the particular application or user is allowed to access the shared query based on the set of access rights associated with the shared query;

allowing execution of the shared query upon a determination that the particular application or user is allowed to access the shared query, wherein allowing execution of the share query includes;

identifying the pre-defined query specification associated with the shared query;

in response to the identifying the pre-defined query specification, identifying the first data source and the second data source based on the identified query specification;

generating a native query for each respective data source of the identified first and second data sources based on the identified query specification;

executing the generated native queries at the respective data sources to collect a set of query results from the respective data sources; and

formatting the set of query results from the respective data sources into a unified set of query results; and

rejecting the execution request upon a determination that the particular application or user is not allowed to access the shared query.

2. The method of claim 1, wherein the request to execute the shared query is received from a reporting tool.

3. The method of claim 1, wherein the at least one of the first data source or the second data source includes at least one business object universe.

4. The method of claim 1, wherein the at least one of the first data source and the second data source includes at least one of a text file, a web service, an extensible markup language (XML) file, and an excel file.

5. The method of claim 1, wherein the plurality of pre-defined shared queries are stored in an enterprise repository.

6. The method of claim 1, wherein generating the native query for each of the first and second data sources based on the identified query specification includes:

generating a first native query associated with the first data source based on the identified query specification, the first native query corresponding to a first format associated with the first data source; and

generating a second native query associated with the second data source based on the identified query specification, the second native query corresponding to a second format different than the first format, the second format associated with the second data source.

7. The method of claim 6, wherein executing the generated native queries at the respective data sources to collect a set of query results from the respective data sources includes:

executing the first generated native query at the first data source to collect a first set of query results; and

executing the second generated native query at the second data source to collect a second set of query results.

8. The method of claim 7, wherein formatting the set of query results from the respective data sources into a unified set of query results includes:

combining the first set of query results and the second set of query results into the unified set of query results;

generating a homogeneous set of search results based on the unified set of search results; and

providing the homogeneous set of search results for presentation in response to the request to execute the shared query.

9. The method of claim 1, wherein the shared query is originally created by a first application, and wherein the request to execute the shared query is received from a second application different from the first application.

10. A computer program product encoded on a tangible, non-transitory storage medium, the product comprising computer readable instructions for causing one or more processors to perform operations comprising:

receiving, by a computer system, a request to execute a shared query, wherein the shared query comprises one of a plurality of pre-defined shared queries, and the shared query comprises a pre-defined query specification associated with the shared query, the query specification comprising pre-defined connections to a first and a second data sources associated with the shared query, the query specification specifying the shared query on a semantic layer and including search terms, parameters, filters, and aspects of the shared query to be used at runtime upon execution of the shared query, where each pre-defined shared query of the plurality of pre-defined shared queries is associated with a corresponding set of access rights, and wherein the request to execute the shared query represents a specific request to execute a particular shared query from the plurality of pre-defined shared queries from a particular application or user;

in response to receiving the request, determining whether the particular application or user is allowed to access the shared query based on the set of access rights associated with the shared query;

allowing execution of the shared query upon a determination that the particular application or user is allowed to access the shared query, wherein allowing execution of the share query includes;

identifying the pre-defined query specification associated with the shared query;

in response to the identifying the pre-defined query specification, identifying the first data source and the second data source based on the identified query specification;

generating a native query for each respective data source of the identified first and second data sources based on the identified query specification;

executing the generated native queries at the respective data sources to collect a set of query results from the respective data sources; and

formatting the set of query results from the respective data sources into a unified set of query results; and

rejecting the execution request upon a determination that the particular application or user is not allowed to access the shared query.

11. The computer program product of claim 10, wherein the at least one of the first data source and the second data source includes at least one business object universe and at least one of a text file, a web service, an extensible markup language (XML) file, and a spreadsheet file.

12. The computer program product of claim 10, wherein the plurality of pre-defined shared queries are stored in an enterprise repository.

13. The computer program product of claim 10, wherein generating the native query for each of the first and second data sources based on the identified query specification includes:

generating a first native query associated with the first data source based on the identified query specification, the first native query corresponding to a first format associated with the first data source; and

generating a second native query associated with the second data source based on the identified query specification, the second native query corresponding to a second format different than the first format, the second format associated with the second data source.

14. The computer program product of claim 13, wherein executing the generated native queries at the respective data sources to collect a set of query results from the respective data sources includes:

executing the first generated native query at the first data source to collect a first set of query results; and

executing the second generated native query at the second data source to collect a second set of query results.

15. The computer program product of claim 14, wherein formatting the set of query results from the respective data sources into a unified set of query results includes:

combining the first set of query results and the second set of query results into the unified set of query results;

generating a homogeneous set of search results based on the unified set of search results; and

providing the homogeneous set of search results for presentation in response to the request to execute the shared query.

16. A system, comprising:

one or more processors;

memory storing one or more programs for execution by the one or more processors, the one or more programs operable when executed to;

receive a request to execute a shared query, wherein the shared query comprises one of a plurality of pre-defined shared queries, and the shared query comprises a pre-defined query specification associated with the shared query, the query specification comprising pre-defined connections to a first and a second data sources associated with the shared query, the query specification specifying the shared query on a semantic layer and including search terms, parameters, filters, and aspects of the shared query to be used at runtime upon execution of the shared query, where each pre-defined query of the plurality of pre-defined shared queries is associated with a corresponding set of access rights, and wherein the request to execute the shared query represents a specific request to execute a particular shared query from the plurality of pre-defined shared queries from a particular application or user;

in response to receiving the request, determining whether the particular application or user is allowed to access the shared query based on the set of access rights associated with the shared query;

allow execution of the shared query upon a determination that the particular application or user is allowed to access the shared query, wherein allowing execution of the share query includes;

identify the pre-defined query specification associated with the shared query;

in response to the identifying the query specification, identify the first data source and the second data source based on the identified query specification;

generate a native query for each respective data source of the identified first and second data sources based on the identified query specification;

execute the generated native queries at the respective data sources to collect a set of query results from the respective data sources; and

format the set of query results from the respective data sources into a unified set of query results; and

reject the execution request upon a determination that the particular application or user is not allowed to access the shared query.

17. The system of claim 16, the system further comprising an enterprise repository storing the plurality of pre-defined shared queries.