International Business Machines Corporation

Jordan S Simpson

Anthony Castrati

Adrian Vrouwenvelder

Gregory Chatham

Thatta V Premnath

Thomas J Reedy

Balakrisna Kolla

Walker Bradham

Mechanisms are provided for integrating a legacy static data storage system with an event based data storage system. Catch-up logic generates, for pre-existing legacy data in the legacy static data storage system, catch-up events for integrating the legacy data in the event based data storage system. A trigger processor generates, at approximately a same time that the catch-up events are generated, triggered events in response to one or more database triggers of the event based data storage system being activated. Both the catch-up events and the one or more triggered events are stored in an event log data structure. An event log monitor processes the catch-up events in the event log data structure to integrate the pre-existing legacy data into the event based data storage system. The event log monitor processes the one or more triggered events after all catch-up events in the event log data structure have been processed.

Integrating a legacy static system with an event-based system

An embodiment of the present invention migrates data between source and target systems. Retrieved source data is mapped to corresponding data elements of a data design for a computer implemented scenario on a target system. One or more of the data elements of the data design are stored on the target system in a format different than a format of the retrieved data. Filters and transformations are generated based on the mapping and data design, and the retrieved data are converted to the format of the target system. One or more from a group of the mapping, filters, and transformations is adjusted in response to detecting at least one from a group of modifications to the data design and non-conforming data received from the one or more source systems. The converted data is stored for the corresponding data elements on the target system for use by the computer implemented scenario.

Data migration from a source system to a data schema of a medical study on a target system

Growing community of inventors

Raleigh, NC, United States of America

Jordan S Simpson