SYSTEMS AND METHODS FOR ACCESSING A NoSQL DATABASE USING BUSINESS INTELLIGENCE TOOLS

• US 20140214897A1
• Filed: 01/31/2013
• Published: 07/31/2014
• Est. Priority Date: 01/31/2013
• Status: Abandoned Application

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Zhu, Yuankai, Aouad, Mohamed Badreddine, Lutter, Steffen
• Application Number:
  US13/755,203
• Publication Number:
  US 20140214897A1
• Time in Patent Office: Days
• US Class Current: 707/771
• CPC Class Codes: G06F 16/2455 Query execution

Abstract

A method for querying an NoSQL provider includes a server receiving a relational database query from an application running on a client computer that is coupled to the server via an electronic communication network, parsing the relational database query, creating an execution plan based on the results of the parsing step, transmitting a NoSQL query to the NoSQL provider, the NoSQL query including at least a portion of the execution plan, transforming at the server a response from the NoSQL provider into a relational format, and providing the transformed response to the client computer application. A system for implementing the method and a non-transitory computer readable medium are also disclosed.

Claims

1. A computer-implemented method for querying an NoSQL provider in communication with a server via an electronic communication network, the method comprising:

receiving at the server a relational database query from an application running on a client computer coupled to the electronic communication network;

parsing by a parsing engine the relational database query;

creating an execution plan based on the results of the parsing step;

transmitting a NoSQL query to the NoSQL provider, the NoSQL query including at least a portion of the execution plan;

transforming at the server a response from the NoSQL provider into a relational format; and

providing the transformed response to the client computer application.

2. The method of claim 1, wherein the parsing step further includes creating an abstract syntax tree based on objects of the relational database query.

3. The method of claim 1, wherein the execution plan contains NoSQL supported operations that correspond to operations included in the relational database query.

4. The method of claim 1, further including mapping the relational database query to one or more NoSQL application program interface requests.

5. The method of claim 1, further including:

processing at least a portion of the execution plan by an NoSQL driver implemented at the server;

transforming at least one result of the processing step into a relational format; and

providing the transformed at least one result to the client computer application.

6. The method of claim 5, wherein the NoSQL driver processes portions of the execution plan containing operations unsupported at the NoSQL provider.

7. The method of claim 5, wherein the at least one result is in a relational format.

8. The method of claim 5, wherein the processing step includes accessing content of at least one relational model catalog, wherein the content of the at least one relational model catalog has a correspondence with content received from the NoSQL provider.

9. The method of claim 1, further including:

retrieving, at the server, table list metadata from the NoSQL provider;

building in server local cache an internal meta model of the table list metadata; and

responding to a client computer application metadata request based on the internal meta model.

10. The method of claim 9, further including:

mapping a request for tables available from the NoSQL provider to the data in the internal meta model; and

generating a table list response.

11. A non-transitory computer readable medium having stored thereon instructions which when executed by a processor cause the processor to perform the method of:

receiving a relational database query from an application;

parsing the relational database query;

creating an execution plan based on the results of the parsing step;

transmitting a NoSQL query to a NoSQL provider, the NoSQL query including at least a portion of the execution plan;

transforming a response from the NoSQL provider into a relational format; and

providing the transformed response to the application.

12. The non-transitory computer readable medium of claim 11, further including executable instructions to cause a processor to control a NoSQL driver to perform the step of processing portions of the execution plan containing operations unsupported at the NoSQL provider.

13. The non-transitory computer readable medium of claim 11, further including executable instructions to cause a processor to perform the steps of:

processing at least a portion of the execution plan by an NoSQL driver;

transforming at least one result of the processing step into a relational format; and

providing the transformed at least one result to application.

14. The non-transitory computer readable medium of claim 13, further including executable instructions to cause a processor to perform the step of mapping the relational database query to one or more NoSQL application program interface requests.

15. The non-transitory computer readable medium of claim 11, further including executable instructions to cause a processor to perform the steps of:

retrieving table list metadata from the NoSQL provider;

building in local cache an internal meta model of the table list metadata; and

responding to an application metadata request based on the internal meta model.

16. The non-transitory computer readable medium of claim 15, further including executable instructions to cause a processor to perform the steps of:

mapping a request for tables available from the NoSQL provider to the data in the internal meta model; and

generating a table list response.

17. The non-transitory computer readable medium of claim 11, wherein the parsing step includes executable instructions to cause a processor to perform the step of creating an abstract syntax tree based on objects of the relational database query.

18. A system comprising:

a server connected to an electronic communication network, the server including a control processor, wherein a parsing engine, a mapping engine, and a NoSQL driver are coupled to the control processor;

the server being in communication with a data store over at least one of the electronic communication network and a dedicated communication path; and

the system is configured to transform a relational database query received by the server into an execution plan having at least one of a supported NoSQL operation and an unsupported NoSQL operation, and the NoSQL operation driver is configured to process the unsupported NoSQL operation at the server.

19. The system of claim 18, further including the system configured to map the relational database query to one or more corresponding NoSQL application program interface requests.

20. The system of claim 18, further including the system configured to access content of at least one relational model catalog, wherein the content of the at least one relational model catalog has a correspondence with content received from the NoSQL provider.