Patent Number 10,089,333
Method and system for dynamically modifying database metadata and structures
United States Patent 10,089,333 solves the problem of attempting to load text data to a data warehouse when the text content is wider than the database column by dynamically adjusting the column width to fit the data.
A system and method enable the selection of database records for editing and writing. A database record is queried for the size of the data fields contained therein. The size of the data field is compared to the field width limitation of a storage database. When it is determined that the data field displays a size greater than the size of the field width limitation of the storage database, a computing device extends the size of the limitation to accommodate the new database record data field. When the size of the limitation is expanded, the new database record is written to the storage database. The system and method may optionally include the input of a user at the final steps, wherein the user may optionally approve or disapprove the extension of the size of the field width limitation.
United States Patent 10,089,333 describes a system and method for revising record keys to coordinate record key changes across at least two databases. The invention solves a major challenge in replication and synchronization: ensuring that changes to primary keys or record identifiers remain consistent across connected systems. When keys change in one environment, downstream systems can lose referential integrity or create duplicates unless changes are coordinated correctly. This patented method enables controlled key revision across databases while maintaining alignment between source and target records. Organizations can use this innovation to improve cross-system synchronization, reduce integration failures, and support migrations where record identifiers must be normalized or updated without breaking relationships.
This patent matters because record key changes are one of the most common causes of replication errors and broken referential integrity. By coordinating record key revisions across multiple databases, the invention reduces duplicates, prevents orphaned relationships, and ensures reliable synchronization across integrated enterprise systems.
Method and System for Dynamic Database Metadata
Awarded July 27, 2017