Patent Number 8,122,040
Method of Integrating Remote Databases by Automated Client Scoping of Update Requests
United States Patent 8,122,040 yields a major competitive advantage for Sesame Software’s Relational Junction data warehouse offering, which includes dozens of source applications and databases and all popular databases for the warehouse.
This patent describes a scalability technique that breaks down the replication process into smaller data sets by ranges of time stamps in the source data. This allows Relational Junction replication products to copy unlimited data sets by breaking them into discreet ranges and checkpointing the results for restartability. The time ranges are variable length, depending on how much data is queried in the previous time range, and adjusted to prevent attempting to download too much in any one interval. This prevents timeouts from the SaaS data source and also makes the process restartable at the point of failure rather than having to repeatedly truncate and reload a database table when failures occur.
Some of Sesame Software’s customers have terabytes of data in the cloud, and we are able to load it to the on-premise or cloud data warehouse despite numerous timeouts and restarts during the initial load.
A method for bi-directional data replication between a Web Service application and a relational database are provided. Techniques of Enterprise Application Integration (EAI) and Extract Transform Load (ETL) technology are employed to create a relational database schema, load the schema, synchronize the structure and the content of the schema, and replicate changes in the content of the schema to the web services application. Optional advanced techniques to support reporting, legacy data migration, and integration with other applications are also provided.
United States Patent 8,122,040 covers a method for client-scoped remote database updates designed to improve how remote systems request and retrieve updates. The invention focuses on selecting and narrowing update requests so systems can retrieve incremental changes more efficiently without overwhelming the network or the source database. This supports more stable synchronization cycles, especially when large datasets must be updated frequently. The patented approach reduces operational risk by improving fault tolerance and limiting unnecessary reprocessing during retries. In enterprise environments, this method enables more reliable database integration, incremental replication, and long-running data synchronization workflows across distributed systems.
This patent matters because incremental update synchronization is essential for keeping remote systems aligned without re-downloading full datasets. By scoping update requests at the client level, the invention reduces operational failures, improves fault tolerance, and enables more reliable long-running replication workflows across networked databases.
Method for Client-Scoped Remote Database Integration
Awarded February 21, 2012