Database data replication tool
Inventors
Baumert, Yoann • Delaunay, Clement • Chis, Daniel-Florin
Assignees
Interested in licensing this patent?
MTEC can help explore whether this patent might be available for licensing for your application.
Publication Number
US-12450254-B2
Publication Date
2025-10-21
Expiration Date
Abstract
Data replication between databases is provided. The method comprises receiving, through an API integrated into a data replication tool, a request from a system of record (SoR) application for a replication setup and initialization. A number of data instances are imported through the API from a source database associated with the SoR. A manager engine integrated into the data replication tool initiates a separate replication process for each data instance. The manager engine is configured to support multiple data instances on a single virtual machine instance. If a difference between a data description language (DDL) of the replicated data instances and a DDL of a target database is detected, the DDL of the replicated data instances is automatically changed to the DDL of the target database. The replicated data instances are then exported to the target database.
Core Innovation
The described data replication tool integrates an application programming interface (API) and a user interface (UI) to receive replication setup requests from a system of record (SoR) application and import multiple data instances from a source database. The tool supports filtering of the first plurality of data instances based on a scope defined by a user to generate a second plurality of data instances. A manager engine automatically executes an individual data replication process for each data instance of the second plurality of data instances at a scheduled time slot to generate a plurality of replicated data instances.
During execution, the tool pushes status of each data instance of the second plurality of data instances to a live stream chat integrated with the data replication tool. The tool also detects a difference between a first data description language (DDL) defining a structure of a first replicated data instance and a second DDL defining a structure of a target database. Responsive to the detection, the tool identifies a model stored as a query language, built to translate the first DDL to the second DDL.
Using the identified model, the tool translates the first DDL of the first replicated data instance to match the second DDL of the target database, and exports the replicated data instance to the target database based on the translation. The tool persists database configuration information in a non-relational database, using the API responsive to exporting, where the database configuration information comprises at least one of a status of the target database, an owner of the target database, a last time a last action has been performed with the target database, and an indication of a user that performed the last action. The documented system supports multiple data instances on a single virtual machine (VM) or container that emulates a computer system, and forwards replication logs to data analytics.
Claims Coverage
The independent claims (clm-00001, clm-00009, and clm-00017) cover a data replication system/method/computer readable medium with 10 inventive features: API-based import, user-scope filtering, scheduled per-instance replication, live stream chat status pushing, DDL difference detection, a query-language model for translation, DDL translation and export to target database, persistence of target database configuration information, UI/API start-stop control, and execution on a container that emulates a computer system.
Api-integrated import of data instances from a source database tied to a system of record (SoR)
Import, through an application programming interface (API), a first plurality of data instances from a source database associated with a system of record (SoR) application.
User-scope filtering to generate a second plurality of data instances
Filter, based on a scope defined by a user, the first plurality of data instances to generate a second plurality of data instances.
Individual replication process per filtered data instance at a scheduled time slot
Automatically execute, using a data replication tool, responsive to filtering the first plurality of data instances based on the scope defined by the user, an individual data replication process for each data instance of the second plurality of data instances at a scheduled time slot to generate a plurality of replicated data instances.
Live stream chat status pushing for replication instances
Push, responsive to the automatic execution of the individual data replication process for each data instance of the second plurality of data instances at the scheduled time slot, a status of each data instance of the second plurality of data instances to a live stream chat integrated with the data replication tool.
Ddl difference detection between replicated instance structure and target database structure
Detect, responsive to pushing the status of each data instance of the second plurality of data instances to the live stream chat, a difference between a first data description language (DDL) that defines a structure of a first replicated data instance of the plurality of replicated data instances and a second DDL that defines a structure of a target database.
Model stored as a query language to translate first DDL to second DDL
Identify, responsive to detection of the difference between the first DDL and the second DDL, a model, stored as a query language, built to translate the first DDL to the second DDL.
Ddl translation to match target database DDL and export replicated data
Translate, using the identified model, the first DDL of the first replicated data instance to match the second DDL of the target database; Export, based on the translation of the first DDL to match the second DDL, the first replicated data instance to the target database.
Persisting target database configuration information in a non-relational database
Persist, using the API responsive to exporting the first replicated data instance to the target database, database configuration information in a non-relational database, wherein the database configuration information comprises at least one of a status of the target database, an owner of the target database, a last time a last action has been performed with the target database, an indication of a user that performed the last action.
Ui-integrated api interaction for managing databases and replication controls
Display, through a user interface, multiple databases (including a source database and a target database) alongside multiple control buttons, where each database is linked to a corresponding control button; Receive, via one or more processors through an API from a SoR, a replication start or replication stop request responsive to user input selecting a corresponding control button.
Api execution on a container that emulates a computer system
The API executes on a container that emulates a computer system; Run multiple instances of a first plurality of data instances on the container that emulates a computer system.
Across clm-00001, clm-00009, and clm-00017, the claims center on an API-integrated replication workflow that filters data instances, executes separate replication processes per instance at scheduled time slots, reports instance status to a live stream chat, detects DDL differences, uses a query-language model to translate DDL to match a target database, exports the replicated instance, and persists target database configuration information in a non-relational database. Dependent claims add UI/API control integration for replication start/stop and constrain API execution to a container emulating a computer system with support for multiple data instances.
Stated Advantages
Automatically aligns replicated data instance structure to match target DDL based on detected DDL differences.
Persists target database configuration information, including status, owner, last action time, and the user that performed the last action.
Provides replication status updates by pushing status to a live stream chat integrated with the data replication tool.
Enables replication processes for multiple data instances at scheduled time slots.
Documented Applications
Data replication of multiple data instances from a source database associated with a system of record (SoR) application to a target database, including filtering by a user-defined scope and translating structures between DDLs.
Status reporting for data replication by pushing replication status to a live stream chat integrated with the data replication tool.
Support for multiple data instances on a single VM/container and forwarding replication logs to data analytics.
Interested in licensing this patent?