Management of different database systems and/or environments

• US 9,805,121 B2
• Filed: 02/18/2014
• Issued: 10/31/2017
• Est. Priority Date: 03/15/2013
• Status: Active Grant

• Current Assignee: Teradata Corporation
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Brown, Douglas P., Coutts, Michael G., Ferragut, Sergio
• Primary Examiner(s): Vo, Truong
• Application Number:
  US14/183,029
• Publication Number:
  US 20140280333A1
• Time in Patent Office: 1,351 Days
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques

Abstract

A database request can be processed at least partly based on one or more differences between multiple database systems and/or environments. The differences can, for example, include differences between one or more database capabilities respectively provided by the multiple database systems, differences between the representation of data in the multiple database systems, and differences in the interfaces for accessing the multiple database systems.

Claims

1. A method, implemented at least partly by a device, for processing one or more database requests in a database environment that includes multiple database systems that differ with respect to at least one of:

one or more database capabilities, one or more representations of data, and one or more interfaces provided for accessing the database systems, the method comprising;

receiving at least one database request associated with data of one or more of the multiple database systems; and

processing the at least one database request by at least one of the database systems in consideration of at least one of the differences between the multiple database systems by performing at least the following;

determining whether the at least one database request can be independently processed by at least one the database systems; and

creating a link between two or more of the database systems in order to process the least one database request when the determining determines that none of the database systems can independently process the at least one database request.

2. The method of claim 1, wherein the differences between the one or more database capabilities include at least one database function provided by a first one of the multiple database systems but not provided by a second one of the multiple database systems.

3. The method of claim 1, wherein the differences between the one or more database capabilities include at least one database function provided by a first one of the multiple database systems in a different manner and/or different version than it is provided by a second one of the multiple database systems.

4. The method of claim 1, wherein the at least one database query requires data stored in one of the multiple database systems that cannot directly process the database request.

5. The method of claim 1, wherein the processing of the at least one database request comprises using stored data that includes the least one of the differences between the multiple database systems.

6. The method of claim 1, wherein the processing of the database request further comprises:

determining that none of the multiple database systems can independently process the database request; and

using one or more links between the multiple database systems.

7. The method of claim 6, wherein the links at least allow data stored in a first one of the multiple database systems to be accessed by a second one of the multiple database systems.

8. The method of claim 1, wherein the database request is associated with a client or system with no direct access or interface for accessing data needed to process the database request.

9. The method of claim 1, wherein the method further comprises:

generating links that effectively allow functions in a first one the multiple database systems to access data stored in a second one the multiple database.

10. The method of claim 1, wherein the method further comprises:

generating links that effectively allow result data obtained by executing one or more functions of a first one of the multiple database systems to be provided to a second one of the multiple database systems.

11. The method of claim 1, wherein the method further comprises:

dynamically creating one or more links between the multiple database systems as needed for processing the database request.

12. The method of claim 11, wherein the method further comprises:

storing at least one of the links for processing one or more other databases requests.

13. The method of claim 1, wherein the method further comprises:

determining that the processing of the database request requires a distinct function that exists in only a first one of the database systems; and

thereafter, executing the distinct function in the first database system.

14. The method of claim 1, wherein the method further comprises:

determining that the processing of the database request by a first one of the database systems requires data in a second one of the database systems; and

thereafter, effectively providing the data to the second database system.

15. The method of claim 1, wherein the method further comprises:

selecting a first version of a function provided by a first one of the multiple database systems over a second version of the function provided by a second one of the multiple database systems for the processing of the database request.

16. The method of claim 1, wherein the method further comprises:

selecting a first version of a data stored in a first one of the multiple database systems over a second version of the data provided by a second one of the multiple database systems for the processing of the database request.

17. The method of claim 1, wherein the processing of the database request further comprises:

using a data dictionary that stores information associated with capabilities of each one of the multiple database systems and how the capabilities relate to each other.

18. The method of claim 1, wherein the processing of the database request further comprises:

determining which one of the database systems is to process the base request based on one or more of the following;

access rights, security, cost of execution, cost of transfer, representation of data, database indexes, database system utilization.

19. The method of claim 1, wherein the processing of the database request further comprises:

using an external view of first data of one of the multiple database systems to effectively provide the first data to another one of the multiple database systems.

20. A device that includes one or more processor configured to:

process one or more database requests in a database environment that includes multiple database systems that differ with respect to at least one of;

one or more database capabilities, one or more representations of data, and one or more interfaces provided for accessing the database systems;

receive at least one database request associated with data of one or more of the multiple database systems;

process the at least database request by at least one of the database systems in consideration of at least one of the differences between the multiple database systems; and

determine whether the at least one database request can be independently processed by at least one the database systems; and

create a link between two or more of the database systems in order to process the least one database request when the determining determines that none of the database systems can independently process the at least one database request.

21. A non-transitory computer readable storage medium storing at least executable code for processing one or more database requests in a database environment that includes multiple database systems that differ with respect to at least one of:

one or more database capabilities, one or more representations of data, and one or more interfaces provided for accessing the database systems, wherein the executable code when executed;

receives at least one database request associated with data of one or more of the multiple database systems;

processes the at least one database request by at least one of the database systems in consideration of at least one of the differences between the multiple database systems; and

determine whether the at least one database request can be independently processed by at least one the database systems; and

create a link between two or more of the database systems in order to process the least one database request when the determining determines that none of the database systems can independently process the at least one database request.