Mapping persistent data in multiple data sources into a single object-oriented component

• US 6,633,889 B2
• Filed: 01/17/2001
• Issued: 10/14/2003
• Est. Priority Date: 01/17/2001
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Dessloch, Stefan, Saracco, Cynthia Maro, Wolfson, Charles Daniel
• Primary Examiner(s): KINDRED, ALFORD W
• Application Number:
  US09/764,611
• Publication Number:
  US 20020095423A1
• Time in Patent Office: 1,000 Days
• Field of Search: 707/1-2, 707/10-103, 707/104.1, 707/513, 345/749, 717/100, 717/102, 717/108, 715/513
• US Class Current: 1/1
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 9/4493 Object persistence
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A method, apparatus and article of manufacture is provided for mapping persistent data objects residing in multiple data sources into a single, reusable software component accessible to an object-oriented programming language application performed by the computer, for multi-database access to data that may be physically distributed and stored in disparate DBMSs, each stored in an electronic storage device coupled to the computer. The method has steps for identifying data objects in multiple data sources, employing a multi-database software facility for connecting to the data sources containing the data objects, and registering the data objects with the multi-database software facility, creating a single virtual data object consolidating multiple attributes from the registered data objects, and establishing a connection to the multi-database software facility for referencing the virtual data object as though it was a single real data object. It also has a step for wrapping this virtual data object as a reusable software component accessible directly from object-oriented programming language applications.

Claims

1. A method for mapping persistent data objects residing in multiple data sources into a single, reusable software component accessible to an object-oriented programming language application performed by a computer, for multi-database access to DBMSs, each stored in an electronic storage device coupled to the computer, the method comprising the following steps:

(a) for object-oriented programming language application, identifying data objects in multiple data sources;

(b) employing a multi-database software facility for connecting to the data sources containing the data objects, and registering the data objects with the multi-database software facility;

(c) using the software multi-database facility for creating a single virtual data object consolidating multiple attributes from the registered data objects;

(d) for object-oriented programming language application, establishing a connection to the multi-database software facility for referencing the virtual data object; and

(e) wrapping access to the virtual data object into a reusable software component accessible directly from an object-oriented programming language application.

2. The method according to claim 1, wherein the multi-database software facility including a federated DBMS, having access to multiple data sources, physically distributed and disparate DBMSs, residing on different hardware systems and possibly storing data in a different format.

3. The method according to claim 1, wherein the multi-database software facility including a multi-database server.

4. The method according to claim 1, wherein the object oriented programming language application accessing the reusable software component within a single unit of work.

5. The method according to claim 1, wherein the virtual data object being mapped into an entity bean having attributes spanning multiple data sources.

6. The method according to claim 5, wherein the entity bean being a container-managed persistence entity bean.

7. The method according to claim 1, wherein the object-oriented programming language application including an Enterprise JavaBeans (EJB) application.

8. The method according to claim 1, wherein the virtual data object being accessed from Java servlets.

9. The method according to claim 1, wherein the virtual data object being accessed from Java Server Pages (JSPs).

10. An apparatus for mapping persistent data objects residing in multiple data sources into a single, reusable software component accessible to an object-oriented programming language application, comprising:

a computer coupled to multiple electronic storage devices, said computer having multi-database access to DBMSs for storing databases;

object-oriented programming means, performed by the computer, for identifying data objects in multiple data sources;

multi-database software means, performed by the computer, for connecting to the data sources containing the data objects, and registering the data objects with the multi-database software facility;

means, performed by the computer, for using the software multi-database facility for creating a single virtual data object consolidating multiple attributes from the registered data objects;

means, performed by the computer, for object-oriented programming means, for establishing a connection to the multi-database software facility for referencing the virtual data object; and

means, performed by the computer, for wrapping access to the virtual data object into a reusable software component accessible directly from an object-oriented programming language application.

11. The apparatus according to claim 10, wherein the multi-database software facility including a federated DBMS, having access to multiple data sources, physically distributed and disparate DBMSs, residing on different hardware systems and possibly storing data in a different format.

12. The apparatus according to claim 10, wherein the multi-database software facility including a multi-database server.

13. The apparatus according to claim 10, wherein the object oriented programming language application accessing the reusable software component within a single unit of work.

14. The apparatus according to claim 10, wherein the virtual data object being mapped into an entity bean having attributes spanning multiple data sources.

15. The apparatus according to claim 14, wherein the entity bean being a container-managed persistence entity bean.

16. The apparatus according to claim 10, wherein the object-oriented programming language application including an Enterprise JavaBeans (EJB) application.

17. The apparatus according to claim 10, wherein the virtual data object being accessed from Java servlets.

18. The apparatus according to claim 10, wherein the virtual data object being accessed from Java Server Pages (JSPs).

19. A program storage device readable by a computer tangibly embodying a program of instructions executable by the computer to perform method steps for mapping persistent data objects residing in multiple data sources into a single, reusable software component accessible to an object-oriented programming language application performed by the computer, for multi-database access to DBMSs, each stored in an electronic storage device coupled to the computer, the method comprising the following steps:

(a) for object-oriented programming language application, identifying data objects in multiple data sources;

(b) employing a multi-database software facility for connecting to the data sources containing the data objects, and registering the data objects with the multi-database software facility;

(c) using the software multi-database facility for creating a single virtual data object consolidating multiple attributes from the registered data objects;

(d) for object-oriented programming language application, establishing a connection to the multi-database software facility for referencing the virtual data object; and

(e) wrapping access to the virtual data object into a reusable software component accessible directly from an object-oriented programming language application.

20. The method according to claim 19, wherein the multi-database software facility including a federated DBMS, having access to multiple data sources, physically distributed and disparate DBMSs, residing on different hardware systems and possibly storing data in a different format.

21. The method according to claim 19, wherein the multi-database software facility including a multi-database server.

22. The method according to claim 19, wherein the object oriented programming language application accessing the reusable software component within a single unit of work.

23. The method according to claim 19, wherein the virtual data object being mapped into an entity bean having attributes spanning multiple data sources.

24. The method according to claim 23, wherein the entity bean being a container-managed persistence entity bean.

25. The method according to claim 19, wherein the object-oriented programming language application including an Enterprise JavaBeans (EJB) application.

26. The method according to claim 19, wherein the virtual data object being accessed from Java servlets.

27. The method according to claim 19, wherein the virtual data object being accessed from Java Server Pages (JSPs).