Patent Number 10,440,089
Method to Replicate Complex Data Structures Using Multiple Queries
United States Patent 10,440,089 handles queries that exceed the maximum complexity or length of the source query or the ability of the receiving database to insert or update all the columns at once by breaking the query into a subset of fields.
A system and method enable the modification of software data queries for the purpose of overcoming the problem of large, cumbersome data queries. The method and system presented includes a client device, which may split a software data query into segments representing a fraction of the original query size, and submit the divided data query to a remote server. The division of the initial query may continue until the query size is usable by the remote server. The remote server may receive the segmented query, and transmit database records associated with the fields in the divided query to the client device. Further segments of the divided query may be transmitted until the full query has been transmitted to the remote server. The divided queries may include date time stamp bounds to determine the desired database records. A computing device created specifically for the above-listed tasks may be utilized.
United States Patent 10,440,089 covers a system and method for dynamically modifying database metadata and structures in a controlled and automated way. The invention enables systems to adjust database schemas, metadata definitions, and structural components without requiring disruptive manual redesign or extensive downtime. This is especially valuable in modern environments where data models evolve frequently due to new applications, integrations, and reporting requirements. By supporting automated structural updates, the patented approach reduces the risk of schema drift and improves the ability to maintain compatibility across connected systems. Organizations can use this innovation to support scalable ETL workflows, reduce operational overhead, and maintain reliable data synchronization even as database structures change over time.
This patent matters because modern data environments change constantly, and schema drift can break integrations and reporting. By enabling dynamic modification of database metadata and structures, the invention supports evolving data models, reduces downtime, and improves long-term stability for ETL, replication, and cross-system synchronization workflows.
Method for Multi-Query Data Replication
Awarded October 8, 2019