ACCESSING ON-PREMISE AND OFF-PREMISE DATASTORES THAT ARE ORGANIZED USING DIFFERENT APPLICATION SCHEMAS

• US 20170177662A1
• Filed: 12/17/2015
• Published: 06/22/2017
• Est. Priority Date: 12/17/2015
• Status: Active Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Lam, Yu Jun, Busuioc, Laurentiu, Huang, Yongran, Maurya, Anand, Ondrejka, Peter, Nyakas, Laszlo, Parent, Kyle I., Juvara, Paolo, Park, Wansoo
• Granted Patent: US 10,289,617 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/2453 Query optimisation
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application

Abstract

Techniques are disclosed for accessing on-premise and off-premise datastores organized using different application schemas. An interface serves requests, from a tenant, by accessing either the on-premise datastore or the off-premise datastore. The interface receives a request for a particular data set. Based on the request itself, the interface selects either the on-premise datastore or the off-premise datastore to retrieve the particular data set. The interface retrieves the particular data set from the selected datastore without attempting to retrieve the particular data set from the non-selected datastore. The interface transmits and/or presents the particular data set.

Claims

1. A non-transitory computer readable medium comprising instructions which, when executed by one or more hardware processors, causes performance of operations comprising:

receiving, by an interface, a request for a particular data set;

selecting, based on the request, one of (a) an on-premise datastore organized using a first application schema or (b) an off-premise datastore organized using a second application schema to retrieve the particular data set, the second application schema being different than the first application schema;

retrieving the particular data set from the selected datastore without attempting to retrieve the particular data set from the non-selected datastore; and

transmitting or presenting the particular data set from the selected datastore.

2. The medium of claim 1, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying a tenant corresponding to a client device that transmitted the request to the interface; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the tenant.

3. The medium of claim 1, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying an application schema associated directly or indirectly with the request; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the application schema corresponding to the request.

4. The medium of claim 1, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying a service corresponding to the request; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the service corresponding to the request.

5. The medium of claim 1, wherein the request does not include a specification of whether to access the on-premise datastore or the off-premise datastore to retrieve the particular data set.

6. The medium of claim 1, wherein retrieving the particular data set from the selected datastore comprises receiving the particular data set from an application that accesses the selected datastore.

7. The medium of claim 1, wherein:

selecting the on-premise datastore to retrieve the particular data set comprises selecting a first application executing on-premise to retrieve the particular data set from the on-premise datastore; and

selecting the off-premise datastore to retrieve the particular data set comprises selecting a second application executing off-premise to retrieve the particular data set from the off-premise datastore.

8. The medium of claim 1, wherein retrieving the particular data set from the selected datastore comprises retrieving, by an application executing the interface, the particular data set from either (a) the on-premise datastore or (b) the off-premise datastore.

9. The medium of claim 1, wherein:

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises;

identifying an application schema associated directly or indirectly with the request;

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the application schema corresponding to the request;

selecting the on-premise datastore to retrieve the particular data set comprises selecting a first application executing on-premise to retrieve the particular data set from the on-premise datastore;

selecting the off-premise datastore to retrieve the particular data set comprises selecting a second application executing off-premise to retrieve the particular data set from the off-premise datastore; and

retrieving the particular data set from the selected datastore comprises receiving the particular data set from an application that accesses the selected datastore.

10. A system comprising:

at least one hardware processor including a processor; and

the system configured to perform operations comprising;

receiving, by an interface, a request for a particular data set;

selecting, based on the request, one of (a) an on-premise datastore organized using a first application schema or (b) an off-premise datastore organized using a second application schema to retrieve the particular data set, the second application schema being different than the first application schema;

retrieving the particular data set from the selected datastore without attempting to retrieve the particular data set from the non-selected datastore; and

transmitting or presenting the particular data set from the selected datastore.

11. The system of claim 10, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying a tenant corresponding to a client device that transmitted the request to the interface; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the tenant.

12. The system of claim 10, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying an application schema associated directly or indirectly with the request; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the application schema corresponding to the request.

13. The system of claim 10, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying a service corresponding to the request; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the service corresponding to the request.

14. The system of claim 10, wherein retrieving the particular data set from the selected datastore comprises receiving the particular data set from an application that accesses the selected datastore.

15. The system of claim 10, wherein:

selecting the on-premise datastore to retrieve the particular data set comprises selecting a first application executing on-premise to retrieve the particular data set from the on-premise datastore; and

selecting the off-premise datastore to retrieve the particular data set comprises selecting a second application executing off-premise to retrieve the particular data set from the off-premise datastore.

16. The system of claim 10, wherein retrieving the particular data set from the selected datastore comprises retrieving, by an application executing the interface, the particular data set from either (a) the on-premise datastore or (b) the off-premise datastore.

20. The method of claim 16, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying a service corresponding to the request; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the service corresponding to the request.

17. A method comprising:

receiving, by an interface, a request for a particular data set;

selecting, based on the request, one of (a) an on-premise datastore organized using a first application schema or (b) an off-premise datastore organized using a second application schema to retrieve the particular data set, the second application schema being different than the first application schema;

retrieving the particular data set from the selected datastore without attempting to retrieve the particular data set from the non-selected datastore; and

transmitting or presenting the particular data set from the selected datastore.

18. The method of claim 17, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying a tenant corresponding to a client device that transmitted the request to the interface; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the tenant.

19. The method of claim 17, wherein selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the request comprises:

identifying an application schema associated directly or indirectly with the request; and

selecting one of (a) the on-premise datastore or (b) the off-premise datastore based on the application schema corresponding to the request.