Distributed queries on legacy systems and micro-services

Patent metadata

Field	Value
Publication number	US-2020175010-A1
Application number	US-201816203968-A
Country	US
Kind code	A1
Filing date	Nov 29, 2018
Priority date	Nov 29, 2018
Publication date	Jun 4, 2020
Grant date	—

Abstract

A distributed query engine is provided to aggregate data from and/or query a plurality of micro-services and legacy applications in multi-tenanted system in an extensible, flexible, and standards-compliant way. A plurality of dedicated connectors is provided in the distributed query engine, each providing a defined and dedicated access point to a corresponding micro-service or legacy application. A database store or database management system is associated with a corresponding one of the micro-services or the legacy applications. When a user communicates a query to the distributed query engine via a web user interface or gateway, the distributed query engine identifies one or more of the micro-services and/or legacy applications relevant to fulfilling the query, and converts the query into sub-queries, which are accordingly directed to the micro-services and/or the legacy applications to handle respective sub-queries.

First claim

What is claimed is:

1 . A computer-implemented method, comprising:
receiving, by a processing engine and from a user device in a multi-tenanted service environment, a query for execution, the processing engine comprising a plurality of dedicated connectors, each of the plurality of dedicated connectors connected to a respective one of a plurality of micro-services, wherein the query requires execution by the plurality of micro-services; converting, by the processing engine, the query into a plurality of sub-queries, wherein the conversion is based on data associated with the plurality of micro-services; providing, by the plurality of dedicated connectors of the processing engine, the plurality of sub-queries to corresponding ones of the plurality of micro-services; receiving, by the plurality of dedicated connectors of the processing engine and from the corresponding ones of the plurality of micro-services, a plurality of sub-results corresponding to the plurality of sub-queries; and compiling, by the processing engine, the plurality of sub-results into a resulting set to satisfy the query.

2 . The computer-implemented method of claim 1 , wherein the conversion into the plurality of sub-queries is further based on prefixes included in the query.

3 . The computer-implemented method of claim 1 , wherein the data associated with the plurality of micro-services is associated with the corresponding plurality of dedicated connectors, wherein the plurality of dedicated connectors are registered with the processing engine.

4 . The computer-implemented method of claim 1 , wherein providing the plurality of sub-queries comprises:
generating, by the plurality of dedicated connectors, an application program interface call based on a mapping of the plurality of sub-queries and the data associated with the plurality of micro-services.

5 . The computer-implemented method of claim 4 , wherein the mapping is based on metadata extracted from the plurality of micro-services.

6 . The computer-implemented method of claim 1 , wherein the plurality of micro-services obtain the plurality of sub-results through respective ones of a data access layer connection with a database store.

7 . The computer-implemented method of claim 1 , wherein compiling the plurality of sub-results into the resulting set comprises:
flattening each of the plurality of sub-results from a hierarchical representation into one or more records of rows with column values comprising required fields of data from the plurality of micro-services.

8 . The computer-implemented method of claim 7 , wherein flattening comprises:
generating a tree comprising a root node and one or more child nodes, wherein the root node and the one or more child nodes include the required fields of data.

9 . A system, comprising:
at least one data processor; and at least one memory storing instructions which, when executed by the at least one data processor, result in operations comprising:
receiving, from a user device in a multi-tenanted service environment, a query for execution, wherein the data processor comprises a plurality of dedicated connectors, each of the plurality of dedicated connectors connected to a respective one of a plurality of micro-services, wherein the query requires execution by the plurality of micro-services;
converting the query into a plurality of sub-queries, wherein the conversion is based on data associated with the plurality of micro-services;
providing, by the plurality of dedicated connectors, the plurality of sub-queries to corresponding ones of the plurality of micro-services;
receiving, by the plurality of dedicated connectors and from the corresponding ones of the plurality of micro-services, a plurality of sub-results corresponding to the plurality of sub-queries; and
compiling the plurality of sub-results into a resulting set to satisfy the query.

10 . The system of claim 9 , wherein the conversion into the plurality of sub-queries is further based on prefixes included in the query.

11 . The system of claim 9 , wherein the data associated with the plurality of micro-services is associated with the corresponding plurality of dedicated connectors, wherein the plurality of dedicated connectors are registered with the data processor.

12 . The system of claim 9 , wherein providing the plurality of sub-queries comprises:
generating, by the plurality of dedicated connectors, an application program interface call based on a mapping of the plurality of sub-queries and the data associated with the plurality of micro-services.

13 . The system of claim 12 , wherein the mapping is based on metadata extracted from the plurality of micro-services.

14 . The system of claim 9 , wherein the plurality of micro-services obtain the plurality of sub-results through respective ones of a data access layer connection with a database store.

15 . The system of claim 9 , wherein compiling the plurality of sub-results into the resulting set comprises:
flattening each of the plurality of sub-results from a hierarchical representation into one or more records of rows with column values comprising required fields of data from the plurality of micro-services.

16 . The system of claim 15 , wherein flattening comprises:
generating a tree comprising a root node and one or more child nodes, wherein the root node and the one or more child nodes include the required fields of data.

17 . A non-transitory computer-readable storage medium including program code, which when executed by at least one data processor, causes operations comprising:
receiving, from a user device in a multi-tenanted service environment, a query for execution, wherein the at least one data processor comprises a plurality of dedicated connectors, each of the plurality of dedicated connectors connected to a respective one of a plurality of micro-services, wherein the query requires execution by the plurality of micro-services; converting the query into a plurality of sub-queries, wherein the conversion is based on data associated with the plurality of micro-services; providing, by the plurality of dedicated connectors, the plurality of sub-queries to corresponding ones of the plurality of micro-services; receiving, by the plurality of dedicated connectors and from the corresponding ones of the plurality of micro-services, a plurality of sub-results corresponding to the plurality of sub-queries; and compiling the plurality of sub-results into a resulting set to satisfy the query.

18 . The non-transitory computer-readable storage medium of claim 17 , wherein providing the plurality of sub-queries comprises:
generating, by the plurality of dedicated connectors, an application program interface call based on a mapping of the plurality of sub-queries and the data associated with the plurality of micro-services.

19 . The non-transitory computer-readable storage medium of claim 17 , wherein the plurality of micro-services obtain the plurality of sub-results through respective ones of a data access layer connection with a database store.

20 . The non-transitory computer-readable storage medium of claim 17 , wherein compiling the plurality of sub-results into the resulting set comprises:
flattening each of the plurality of sub-results from a hierarchical representation into one or more records of rows with column values comprising required fields of data from the plurality of micro-services.

Assignees

• Sap Se

Inventors

• Vaghani Chintankumar
• Banerjee Rick

Classifications

• G06F16/2246

  Trees, e.g. B+trees · CPC title

• G06F16/2471 Primary

  Distributed queries · CPC title

• G06F16/2455

  Query execution · CPC title

• G06F16/248

  Presentation of query results · CPC title

• H04L67/32

  Electricity · mapped topic