Patent Number 10,990,586
System and method for revising record keys to coordinate record key changes within at least two databases
United States Patent 10,990,586 describes a method of handling parent-child relationships when new parent records are created in an application. The new technique handles the relationship updates when parent keys are created by the application system must be maintained in the child record in a mass update mode instead of record-by-record. This improves efficiency in conventional row-organized database management systems, but also enables this on column-organized databases with good performance.
A system and method to coordinate the changing of identifiers, i.e., primary keys and foreign keys, of new records generated by a first system by revision of these new records with alternate primary keys and foreign keys as generated and/or established by a second database system. The invention is an improvement over prior art transactional methods that maintain relationships among records when updating records of a first data base with replacement of primary and foreign keys provided by another database management system, and an improvement over prior art approaches to non-indexed schemas. Thus, the new method teaches how to batch update relationship fields in the first database with fewer database updates. The invention provides large savings for columnar databases, which are generally not indexed, and speeds up record key maintenance and harmonizing across two or more row-oriented databases.
United States Patent 10,990,586 describes a method to replicate complex data structures using multiple queries, addressing challenges that arise when large or interrelated datasets must be transferred reliably. The invention improves how systems replicate structured records that may have dependencies, relationships, or hierarchical data patterns that cannot be captured in a single query. By using coordinated multi-query replication logic, the method ensures completeness, consistency, and improved performance during replication and synchronization. This is particularly relevant for enterprise platforms and SaaS systems where data is stored in complex relational structures. Organizations benefit from more reliable migrations, more accurate analytics replication, and improved synchronization across distributed systems and cloud environments.
This patent matters because complex enterprise datasets often cannot be replicated accurately using a single query or a simple extraction method. By supporting replication of complex structures through coordinated multi-query logic, the invention improves completeness, reduces data loss risk, and enables reliable migration and synchronization for interrelated records and relational systems.
System and Method for Coordinated Record Keys
Awarded April 27, 2021