SYSTEM AND METHOD FOR CONVERSION OF JMS MESSAGE DATA INTO DATABASE TRANSACTIONS FOR APPLICATION TO MULTIPLE HETEROGENEOUS DATABASES

摘要

A system and method for performing real-time conversion of data which is present in the form of messages on JMS-compliant or other messaging systems into database transactions; which can then subsequently be applied to multiple heterogeneous databases or other systems. In accordance with an embodiment, the invention provides a means by which data can be read from messages in a messaging system, and converted to a set of database operations that are then stored as a persistent trail file. The operations can then be routed via a network and applied to target systems as required, for example to maintain a replicated set of information at one or more different or heterogeneous systems. The data in the message can be formatted in a variety of ways, for example, as fixed width, delimited, or XML data, and the system can be configured to convert this data as appropriate.

主权项

1. A system for integrating a message-based system with a database-based system, comprising:
a computer including a microprocessor; a data parsing component, which includes a plurality of parsers, wherein each of the plurality of parsers is configured to parse messages received from a message-based system having a particular message format, and a properties file which indicates properties and data definitions that define how the system is to parse messages from a source format of a source system, to a target format of a target system; wherein the data parsing component operates to
read a message from a messaging topic at the source system,present values read from a header of the message to the properties file,select, using the properties file, a parser from the plurality of parsers to parse the message,parse, using the selected parser and the properties file, the message to determine transaction boundaries and operation types, andapply the parsed data as database operations at a database at the target system.