Storage and retrieval of variable data

• US 8,126,841 B2
• Filed: 02/20/2008
• Issued: 02/28/2012
• Est. Priority Date: 02/20/2008
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Gordon, Justin Harding, Pominville, Patrice
• Primary Examiner(s): MORRISON, JAY A
• Application Number:
  US12/034,475
• Publication Number:
  US 20090210434A1
• Time in Patent Office: 1,469 Days
• Field of Search: None
• US Class Current: 707/609
• CPC Class Codes: G06F 16/8358 Query translation

Abstract

Methods and apparatus, including computer program products, implementing and using techniques for managing data items. A data store includes at least two copies of each data item. Each copy of a data item is used for a unique set of operations performed on the data item. An application programming interface receives a request from a consumer to perform an operation on a data item in the data store. The application programming interface selects, based on the received request, which copy of the data item is to be used when performing the operation.

Claims

1. A master data management system for managing a plurality of data items, comprising:

a data store storing master data representing dynamic and variable data items, the data store including at least two concurrently stored copies of each data item in a homogeneous database, wherein each copy of a data item is operable to be used for a unique set of operations performed on the data item;

an application programming interface operable to;

receive a request from a consumer to perform an operation on a data item in the data store; and

select, based on the received request, which copy of the at least two copies of the data item is to be used when performing the operation;

and

a data item transformer that is operable to;

detect whether a change is made to a copy of a data item; and

in response to detecting that a change has been made to a copy of a data item, update at least one other copy of the data item to reflect the change.

2. The system of claim 1, wherein the application programming interface is further operable to perform the received operation on the selected copy of the data item.

3. The system of claim 1, wherein the at least two copies of each data item include:

a first copy of the data item in a binary format, and a second copy of the data item in an extensible markup language format.

4. The system of claim 3, wherein the binary format is used for operations including one or more of:

reading, writing and general runtime processing of individual data items.

5. The system of claim 3, wherein the extensible markup language format is used for operations including one or more of:

retrieving, searching and creating views of sets of data items.

6. The system of claim 3, wherein the data item transformer is a binary-to-XML transformer that is operable to:

detect whether a change is made to the first or the second copy of the data item;

in response to detecting that a change has been made to the first copy of the data item, update the second copy of the data item to reflect the change; and

in response to detecting that a change has been made to the second copy of the data item, update the first copy of the data item to reflect the change.

7. The system of claim 1, wherein the request from the consumer is received from one of:

a client program application and a web service.

8. The system of claim 1, wherein the system is a product information management system and the plurality of data items represent information about individual products.

9. A computer-implemented method in a master data management system for performing an operation on a data item in a data store, the method comprising:

storing master data for at least two concurrently stored copies of the data item in a homogeneous database in the data store, the data item representing dynamic and variable data, wherein each copy of the data item is operable to be used for a unique set of operations performed on the data item;

receiving a request from a consumer to perform an operation on the data item;

selecting, based on the received request, one of the at least two copies of the data item to use when performing the operation;

detecting whether a change is made to a copy of a data item; and

in response to detecting that a change has been made to a copy of a data item, updating at least one other copy of the data item to reflect the change.

10. The method of claim 9, further comprising:

performing the received operation on the selected copy of the data item.

11. The method of claim 9, wherein the at least two copies of each data item include:

a first copy of the data item in a binary format, and a second copy of the data item in an extensible markup language format.

12. The method of claim 11, wherein selecting one of the at least two copies includes:

selecting the binary format of the data item for operations including one or more of;

reading, writing, and general runtime processing of the data item.

13. The method of claim 11, wherein selecting one of the at least two copies includes:

selecting the extensible markup language format of the data item for operations including one or more of;

retrieving, searching and creating views of sets of data items.

14. The method of claim 9, wherein receiving a request includes receiving a request from one of:

a client program application a web service.

15. The method of claim 9, wherein the data item represents information about a product in a product information management system.

16. A computer program product comprising a computer useable tangible storage medium including a computer readable program, wherein the computer readable program when executed on a computer causes the computer to:

store master data for at least two concurrently stored copies of the data item in a homogeneous database in the data store that is part of a master data management system, the data item representing dynamic and variable data, wherein each copy of the data item is operable to be used for a unique set of operations performed on the data item;

receive a request from a consumer to perform an operation on the data item;

select, based on the received request, one of the at least two copies of the data item to use when performing the operation;

detect whether a change is made to a copy of a data item; and

in response to detecting that a change has been made to a copy of a data item, update at least one other copy of the data item to reflect the change.

17. The computer program product of claim 16, wherein the computer readable program when executed on a computer further causes the computer to

perform the received operation on the selected copy of the data item.

18. The computer program product of claim 16, wherein the at least two copies of each data item include:

a first copy of the data item in a binary format, and a second copy of the data item in an extensible markup language format.

19. The computer program product of claim 18, wherein selecting one of the at least two copies includes:

selecting the binary format of the data item for operations including one or more of;

reading, writing, and general runtime processing of the data item.

20. The computer program product of claim 18, wherein selecting one of the at least two copies includes:

selecting the extensible markup language format of the data item for operations including one or more of;

retrieving, searching and creating views of sets of data items.

21. The computer program product of claim 16, wherein receiving a request includes receiving a request from one of:

a client program application a web service.

22. The computer program product of claim 16, wherein the data item represents information about a product in a product information management system.