Interface for providing access to external data sources/sinks

• US 5,475,836 A
• Filed: 12/20/1993
• Issued: 12/12/1995
• Est. Priority Date: 04/01/1987
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: Lotus Development Corporation (International Business Machines Corporation)
• Inventors: Reed, David P., Young, Carl J., Harris, Peter O.
• Primary Examiner(s): Kulik, Paul V.
• Application Number:
  US08/170,458
• Time in Patent Office: 722 Days
• Field of Search: 395/600, 395/500, 395/650, 395/700
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

An interface for enabling an application program to connect to a selected one or more of a plurality of external data sources/sinks, the application program running on a computer having active memory, the interface including a plurality of driver means, each of said drivers corresponding to a different subgroup of the plurality of external data sources/sinks; a name manager for identifying the drivers to the application; a selector for selecting one of the identified external data sources/sinks; a loader for loading the drivers corresponding to the selected external data source/sink into active memory; and an identifier for identifying a first plurality of entry points to a first plurality of function calls that said application can make to the loaded drivers, the plurality of function calls including function calls for establishing and/or terminating connectivity to the loaded drivers.

Claims

1. A computer-implemented method for enabling an application program to connect to a selected one or more of a plurality of external data sources/sinks, said application program running on a computer having active memory, the method comprising:

providing a plurality of driver means, each of said driver means corresponding to a different subgroup of said plurality of external data sources/sinks;

in response to an inquiry from said application program, reporting to the application program the identity of each of the driver means of said plurality of driver means;

in response to the application program, selecting one of the plurality of driver means previously identified to the application program;

loading the selected driver means into active memory; and

reporting to the application program a first plurality of entry points in said loaded driver means for a first plurality of function calls that said application program can make to said loaded driver means, said first plurality of entry points for use by said application program to make said first plurality of function calls directly to said loaded driver means, said first plurality of function calls including function calls for establishing and/or terminating connectivity to said loaded driver means.

2. The computer-implemented method of claim 1 wherein said first plurality of function calls includes browsing function calls which enable the application program to discover the external data sources/sinks.

3. The computer-implemented method of claim 1 wherein said first plurality of function calls includes function calls for establishing and/or terminating connectivity to a selected one of the external data sources/sinks associated with said loaded driver means.

4. The computer-implemented method of claim 3 further comprising reporting to said application program a second plurality of entry points in said loaded driver means for a second plurality of function calls that said application program can make to said loaded driver means, said second plurality of entry points for use by said application program to make said second plurality of function calls directly to said loaded driver means, said second plurality of function calls relating to accessing data in said selected external data source/sink.

5. The computer-implemented method of claim 4 wherein said second plurality of function calls includes catalog browsing function calls which enable the application program to discover tables of data that are available through said selected external data source/sink.

6. The computer-implemented method of claim 5 wherein said catalog browsing function calls are also for enabling the application program to discover columns within said tables.

7. The computer-implemented method of claim 6 wherein said second plurality of function calls includes a function call for returning a capability array for said data source/sink to the application program, said capability array identifying the capabilities of other of said second plurality of function calls.

8. The computer-implemented method of claim 7 wherein said capability array comprises a plurality of masks, each of said masks associated with a different logical group of capabilities.

9. The computer-implemented method of claim 8 wherein said capability array comprises a summary mask, said summary mask including an entry corresponding to each of the other masks of said plurality of masks, each entry indicating whether any of the capabilities of the corresponding logical group of capabilities is present.

10. The computer-implemented method of claim 1 wherein the step of reporting to the application program the identify of each of the driver means of said plurality of driver means comprises creating and establishing in memory a registration data structure that identifies to said application program the plurality of drivers and the plurality of external data sources/sinks available to said application program.

11. The computer-implemented method of claim 10 wherein the step of reporting to the application program the identity of each of the driver means of said plurality of driver means further comprises searching through said registration data structure so as to identify to the application program the drivers of said plurality of drivers.

12. A computer-implemented method for enabling an application program to access functionality of a selected external data source/sink, the method comprising:

in response to a connectivity request from said application program, establishing connectivity of the application program to said selected external data source/sink; and

after said application program establishes connectivity with said external data source/sink, causing said selected external data source/sink to make available to said application program a browsing function for use by said application program to discover information about capabilities of said external data source/sink;

in response to use of said browsing function by the application program, reporting to the application program an array of capabilities that are supported by said external data source/sink, said capabilities being available to be directly utilized by said application program.

13. The computer-implemented method of claim 12 further comprising reporting to said application program a plurality of entry points to a plurality of function calls that said application program may make to said selected external data source/sink, said plurality of function calls including a function call for returning the capability array for said data source/sink, said capability array identifying the capabilities of other of said plurality of function calls.

14. The computer-implemented method of claim 13 wherein said capability array comprises a plurality of masks, each of said masks associated with a different logical group of capabilities.

15. The computer-implemented method of claim 14 wherein said capability array comprises a summary mask, said summary mask including an entry corresponding to each of the other masks of said plurality of masks, each entry indicating whether any of the capabilities of the corresponding logical group of capabilities is present.

16. The computer-implemented method of claim 14 wherein at least one of said masks corresponds to data definition capabilities that are supported by said plurality of function calls.

17. A computer-implemented method for enabling an application program to connect to an external data source/sink, said application program supporting a first plurality of data types, said external data source/sink supporting a second plurality of data types, the method comprising:

establishing connectivity of said application program to said data source/sink through a driver;

once connectivity between said application program and said data source/sink is established, negotiating a mutually supported data type for transferring data between said application and said external data source/sink, said negotiating taking place between the application program and said driver; and

adopting the mutually supported data type for transferring data between said application and said external data source/sink.

18. The computer-implemented method of claim 17 wherein the step of negotiating comprises reporting to said application program which of said second plurality of data types said external data source/sink proposes to use to transfer data to said application program, and wherein said adopting step comprises changing from said proposed data type to said mutually supported data type.

19. The computer-implemented method of claim 18 wherein said negotiating step further comprises reporting to the application program the data types included among said second plurality of data types.

20. The computer-implemented method of claim 19 wherein said changing step comprises selecting one of said second plurality of data types as said mutually supported data type.