System and method for providing near real time data synchronization
OwnerMarcelo Ochoa, Vanesa Dell'Acqua +1inventors
InventorsMarcelo Ochoa, Vanesa Dell'Acqua, Maximiliano Keen
Life of this patent
Estimating the term…
Abstract
A system and method enable the synchronization between a Relational Database Management System (RDBMS) and an external repository in Near Real Time (NRT) in an asynchronous mode. The external repository can be a data storage, as other database, where specific processes or tools (like Business Intelligence) run; or a set of tools to add to the database new features. For example, the system and method may be used to extend basic text search features provided by the database with the newest and complete Full Text Search (FTS) functionalities, such as faceting, geospatial, highlighting among others, natively into the SQL.
Claims15
A system for data synchronization, comprising:
- a data storage component having a relational database hosted on a computer with ACID transaction support that stores data in one or more rows, the data storage component having a change detector that detects changes in the one or more rows;
- a separate layer hosted on a computer having a queue, coupled to the data storage component, having one or more elements wherein each element stores only a row identifier that identifies the row that changed and an operation that caused the row to change for each row that changed in the data storage component based on a notifier message from the change detector, the one or more elements of the queue being used to update a repository;
- and
- a separate layer hosted on a computer having the repository that is different than the relational database, coupled to the data storage component and the queue, that stores an index of the data in the one or more rows of the data storage component, wherein the repository is updated with the changes to the one or more rows in the data storage component using the one or more elements from the queue when a commit operation is performed in the data storage component.
(canceled)
A method for data synchronization, comprising:
- storing, on a data storage component having a relational database hosted on a server with ACID transaction support, data in one or more rows;
- detecting, by the data storage component, changes in the one or more rows in the data storage component;
- storing, in a queue hosted on a server in a separate layer that is coupled to the data storage component, a change in one or more elements to the one or more rows in the data storage component based on a notifier message, wherein each element stores only a row identifier that identifies the row that changed and an operation that caused the row to change, the one or more elements of the queue being used to update a repository;
- and
- storing, in the repository that is different than the relational database hosted on a server in a separate layer that is coupled to the data storage component and the queue, an index of the data in the one or more rows in the data storage component;
- and
- updating the repository with the changes to the one or more rows in the data storage component using the one or more elements of the queue when a commit operation is performed in the data storage component.
(canceled)
Dependencies are inferred from the claim text.