Accessing on-premise and off-premise datastores that are organized using different application schemas

• US 10,289,617 B2
• Filed: 12/17/2015
• Issued: 05/14/2019
• Est. Priority Date: 12/17/2015
• Status: Active Grant

• 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
• Primary Examiner(s): Hutton, Nan
• Application Number:
  US14/973,325
• Publication Number:
  US 20170177662A1
• Time in Patent Office: 1,244 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:

identifying a first set of services corresponding to an on-premise datastore organized using a first application schema;

identifying a second set of services corresponding to an off-premise datastore organized using a second application schema different than the first application schema;

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

identifying a first service to be used for responding to the first request;

responsive to determining that the first service is within the first set of services and not within the second set of services, selecting the on-premise datastore to retrieve the first data set;

retrieving the first data set from the on-premise datastore without attempting to retrieve the first data set from the off-premise datastore;

transmitting or presenting the first data set from the on-premise datastore;

receiving, by the interface, a second request for a second data set

identifying a second service to be used for responding to the second request

responsive to determining that the second service is within the second set of services and not within the first set of services, selecting the off-premise datastore to retrieve the second data set

retrieving the second data set from the off-premise datastore without attempting to retrieve the second data set from the on-premise datastore; and

transmitting or presenting the second data set from the off-premise datastore.

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

3. The medium of claim 1, wherein retrieving the first data set from the on-premise datastore comprises receiving the first data set from an application that accesses the on-premise datastore.

4. The medium of claim 1, wherein:

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

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

5. The medium of claim 1, wherein retrieving the first data set from the on-premise datastore comprises retrieving, by an application executing the interface, the first data set from the on-premise datastore.

6. The medium of claim 1, wherein:

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

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

retrieving the first data set from the on-premise datastore comprises receiving the first data set from an application that accesses the on-premise datastore.

7. The medium of claim 1, wherein the first set of services comprises services published prior to a particular date, and the second set of services comprises services published after the particular date.

8. A system comprising:

at least one hardware processor including a processor; and

the system configured to perform operations comprising;

identifying a first set of services corresponding to an on-premise datastore organized using a first application schema;

identifying a second set of services corresponding to an off-premise datastore organized using a second application schema different than the first application schema;

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

identifying a first service to be used for responding to the first request

responsive to determining that the first service is within the first set of services and not within the second set of services, selecting the on-premise datastore to retrieve the first data set;

retrieving the first data set from the on-premise datastore without attempting to retrieve the first data set from the off-premise datastore;

transmitting or presenting the first data set from the on-premise datastore;

receiving, by the interface, a second request for a second data set

identifying a second service to be used for responding to the second request

responsive to determining that the second service is within the second set of services and not within the first set of services, selecting the off-premise datastore to retrieve the second data set

retrieving the second data set from the off-premise datastore without attempting to retrieve the second data set from the on-premise datastore, and

transmitting or presenting the second data set from the off-premise datastore.

9. The system of claim 8, wherein retrieving the first data set from the on-premise datastore comprises receiving the first data set from an application that accesses the on-premise datastore.

10. The system of claim 8, wherein:

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

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

11. The system of claim 8, wherein retrieving the first data set from the on-premise datastore comprises retrieving, by an application executing the interface, the first data set from the on-premise datastore.

12. The system of claim 8, wherein the first request does not include a specification of whether to access the on-premise datastore or the off-premise datastore to retrieve the first data set.

13. The system of claim 8, wherein the first set of services comprises services published prior to a particular date, and the second set of services comprises services published after the particular date.

14. A method comprising:

identifying a first set of services corresponding to an on-premise datastore organized using a first application schema;

identifying a second set of services corresponding to an off-premise datastore organized using a second application schema different than the first application schema;

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

identifying a first service to be used for responding to the first request

responsive to determining that the first service is within the first set of services and not within the second set of services, selecting the on-premise datastore to retrieve the first data set;

retrieving the first data set from the on-premise datastore without attempting to retrieve the first data set from the off-premise datastore;

transmitting or presenting the first data set from the on-premise datastore;

receiving, by the interface, a second request for a second data set

identifying a second service to be used for responding to the second request

responsive to determining that the second service is within the second set of services and not within the first set of services, selecting the off-premise datastore to retrieve the second data set;

retrieving the second data set from the off-premise datastore without attempting to retrieve the second data set from the on-premise datastore; and

transmitting or presenting the second data set from the off-premise datastore.

15. The method of claim 14, wherein the first request does not include a specification of whether to access the on-premise datastore or the off-premise datastore to retrieve the first data set.

16. The method of claim 14, wherein retrieving the first data set from the on-premise datastore comprises receiving the first data set from an application that accesses the on-premise datastore.

17. The method of claim 14, wherein:

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

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

18. The method of claim 14, wherein the first set of services comprises services published prior to a particular date, and the second set of services comprises services published after the particular date.