Mapping data from multiple data sources into a single or multiple reusable software components

• US 7,412,457 B2
• Filed: 11/06/2004
• Issued: 08/12/2008
• Est. Priority Date: 01/17/2001
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Saracco, Cynthia Maro, Wolfson, Charles Daniel
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): Choi, Michele C
• Application Number:
  US10/983,842
• Publication Number:
  US 20050120342A1
• Time in Patent Office: 1,375 Days
• Field of Search: 707/104.1, 707/103.Y, 707/103.R, 707/103.Z
• US Class Current: 1/1
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• 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 program storage device for mapping data objects, residing in multiple data sources or generated dynamically, into a single or multiple reusable software components, for integrated information access to multiple disparate data sources, residing on or generating the data dynamically on different hardware systems and possibly in different data formats. A user identifies selected data objects from multiple data sources and registers them with an information integration software facility, in order to create at least one virtual data object having at least one attribute from the selected registered data objects, and to wrap access to the at least one virtual data object into a reusable software component, as though it was a single real data object, accessible directly from software applications.

Claims

1. A method for mapping disparate data objects from multiple data sources into a single, or multiple;

reusable software components accessible to a software application performed by a computer, for integrated access to the disparate data objects generated dynamically by or contained in the multiple data sources stored in at least one electronic storage device coupled to the computer, the method comprising the following steps;

(a) for a software application, identifying the disparate data objects for mapping;

(b) employing an information integration software facility for registering the data objects;

(c) using the information integration software facility for creating at least one virtual data object having at least one attribute from the selected registered data objects; and

(d) wrapping access to the at least one virtual data object into the reusable software component accessible directly from the software application.

2. The method according to claim 1, wherein the information integration software facility having access to the multiple data sources, being chosen from a group comprising databases, files and spreadsheets, containing or dynamically generating data from different hardware systems and possibly storing the data in different formats.

3. The method according to claim 1, wherein the information integration software facility being chosen from a group comprising a multi-database server, a federated data server and an information integration server.

4. The method according to claim 1, wherein the software 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 the 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 software application including an Enterprise JavaBean (EJB) application.

8. The method according to claim 1, wherein the virtual data object being accessed from a group comprising Java servlets, Java Server Pages (JSPs), Web Services, Service Data Objects (SDO) and persistence frameworks.

9. Art apparatus for mapping disparate data objects from multiple data sources into a single, or multiple reusable software components accessible to a software application performed by a computer, comprising:

the computer coupled to at least one electronic storage device for integrated access to the disparate data objects generated dynamically by or contained in the multiple data sources;

programming means, performed by the computer, for identifying the disparate data objects for mapping;

an information integration software facility for registering the data objects;

means, performed by the computer, for using the information integration software facility for creating at least one virtual data object having at least one attribute from the selected registered data objects; and

means, performed by the computer, for wrapping access to the at least one virtual data object into the reusable software component accessible directly from the software application.

10. The apparatus according to claim 9, wherein the information integration software facility having access to the multiple data sources, being chosen from a group comprising databases, files and spreadsheets, containing or dynamically generating data from different hardware systems and possibly storing the data in different formats.

11. The apparatus according to claim 9, wherein the information integration software facility being chosen from a group comprising a multi-database server, a federated data server and an information integration server.

12. The apparatus according to claim 9, wherein the software application accessing the reusable software component within a single unit of work.

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

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

15. The apparatus according to claim 9, wherein the software application including an Enterprise JavaBean (EJB) application.

16. The apparatus according to claim 9, wherein the virtual data object being accessed from a group comprising Java servlets, Java Server Pages (JSPs), Web Services, Service Data Objects (SDO) and persistence frameworks.

17. A program storage device usable by a computer tangibly embodying a program of instructions executable by the computer to perform method steps for mapping disparate data objects from multiple data sources into a single, or multiple, reusable software components accessible to a software application performed by a computer, for integrated access to the disparate data objects generated dynamically by or contained in the multiple data sources stored in at least one electronic storage device coupled to the computer, the method comprising the following steps:

(a) for a software application, identifying the disparate data objects for mapping;

(b) employing an information integration software facility for registering the data objects;

(c) using the information integration software facility for creating at least one virtual data object having at least one attribute from the selected registered data objects; and

(d) wrapping access to the at least one virtual data object into the reusable software component accessible directly from the software application.

18. The method according to claim 17, wherein the information integration software facility having access to the multiple data sources, being chosen from a group comprising databases, files and spreadsheets, containing or dynamically generating data from different hardware systems and possibly storing the data in different formats.

19. The method according to claim 17, wherein the information integration software facility being chosen from a group comprising a multi-database server, a federated data server and an information integration server.

20. The method according to claim 17, wherein the software application accessing the reusable software component within a single unit of work.

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

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

23. The method according to claim 17, wherein the software application including an Enterprise JavaBean (EJB) application.

24. The method according to claim 17, wherein the virtual data object being accessed from a group comprising Java servlets, Java Server Pages (JSPs), Web Services, Service Data Objects (SDO) and persistence frameworks.