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

• US 20050120342A1
• Filed: 11/06/2004
• Published: 06/02/2005
• Est. Priority Date: 01/17/2001
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Wolfson, Charles Daniel, Saracco, Cynthia Maro
• Granted Patent: US 7,412,457 B2
• Time in Patent Office: Days
• US Class Current: 717/162
• 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 is provided 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. The method has steps for identifying data objects in multiple data sources, employing an information integration software facility for connecting to the data sources containing the data objects and registering the data objects, creating at least one virtual data object having at least one attribute from the selected registered data objects, and a step for wrapping 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 software application performed by a computer, for integrated access to the disparate data objects generated dynamically by or contained in 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 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 a 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 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 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 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 JavaBeans (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. An apparatus for mapping disparate data objects from multiple data sources into a single or multiple, reusable software components accessible to software application performed by a computer, comprising:

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

programming means, performed by the computer, for identifying 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 a 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 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 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 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 JavaBeans (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 software application performed by a computer, for integrated access to the disparate data objects generated dynamically by or contained in 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 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 a 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 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 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 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 JavaBeans (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.