Data Synchronization Between a Data Management System and an External System

• US 20110087632A1
• Filed: 10/09/2009
• Published: 04/14/2011
• Est. Priority Date: 10/09/2009
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Rao, Swetha, Subramanian, Manjunath B.
• Granted Patent: US 9,311,378 B2
• Time in Patent Office: Days
• US Class Current: 707/610
• CPC Class Codes: G06F 16/273 Asynchronous replication or reconciliation

Abstract

A method, a system and a computer program of synchronizing data between a data management system and an external system are disclosed. The method includes creating a first database instance and a second database instance using an integration data model. The method further includes synchronizing data between the second database instance and the external system. A services framework is created and the first database instance and the second database instance are interfaced using the services framework which includes an entity definition repository, a change tracking repository, and a data export element. Also disclosed are a system and a computer program for synchronizing data between a data management system and an external system.

Claims

1. A method for synchronizing data between a first system and a second system, wherein the first system includes a data management system, the method comprising:

creating a first database instance and a second database instance using an integration data model; and

synchronizing data between the second database instance and the second system.

2. The method of claim 1, wherein the integration data model is configured to use a pre-defined subset of entities of the first system.

3. The method of claim 1, wherein the second system is at least one selected from a set comprising a system configured to feed data to the first system and a system configured to receive data from the first system.

4. The method of claim 1, wherein the first system is configured to include the first database instance.

5. The method of claim 1, wherein the synchronizing data between the second database instance and the second system is enabled by a database connector comprising ODBC, ESB and JDBC.

6. The method of claim 1, further comprising:

creating a services framework; and

interfacing the first database instance and the second database instance using the services framework.

7. The method of claim 6, wherein the interfacing is enabled by a message brokering mechanism selected from a set comprising XML, a scheduled java process, and a data call to SQL call conversion mechanism.

8. The method of claim 6, wherein the services framework is communicatively coupled to the first system.

9. The method of claim 6, wherein the services framework comprises:

an entity definition repository;

a change tracking repository; and

a data export element.

10. The method of claim 9, wherein the entity definition repository includes metadata of a plurality of entities of the integration data model, wherein the metadata comprises attributes and relationships.

11. The method of claim 9, wherein the change tracking repository comprises a list of changed entities and corresponding metadata of the changed entities.

12. The method of claim 9, wherein the data export element uses the entity definition repository and the change tracking repository to export changes in entities identified in the change tracking repository.

13. A system for synchronizing data between a first system and a second system, wherein the first system includes a data management system, the system comprising:

a processor configured to create a first database instance and a second database instance using an integration data model, wherein the integration data model uses a pre-defined subset of entities of the first system; and

the processor configured to synchronize data between the second database instance and the second system.

14. The system of claim 13, wherein the second system is one selected from a set comprising a system configured to feed data to the first system and a system configured to receive data from the first system.

15. The system of claim 13, wherein the processor is further configured to:

create a services framework; and

interface the first database instance and the second database instance using the services framework.

16. The system of claim 15, wherein the interfacing is enabled by a message brokering mechanism selected from a set comprising XML, a scheduled java process, and a data call to SQL call conversion mechanism.

17. The system of claim 15, wherein the services framework comprises:

an entity definition repository;

a change tracking repository; and

a data export element.

18. A storage medium tangibly embodying a program of machine-readable instructions executable by a digital processing apparatus to carry out a method of synchronizing data between a first system and a second system, wherein the first system includes a data management system, the storage medium configured to:

create a first database instance and a second database instance using an integration data model; and

synchronize data between the second database instance and the second system.

19. The storage medium of claim 18, further configured to:

create a services framework; and

interface the first database instance and the second database instance using the services framework.

20. A method for synchronizing data between a centralized master repository and an external system, wherein the centralized master repository is functionally coupled to a data management system, the method comprising:

creating a first database instance and a second database instance using an integration data model, wherein the integration data model is configured to use a pre-defined subset of entities of the centralized master repository;

creating a services framework, wherein the services framework comprises an entity definition repository, a change tracking repository and a data export element;

interfacing the first database instance and the second database instance using the services framework; and

synchronizing data between the second database instance and the external system.