Richard Banister is a notable inventor based in Vista, California, with a remarkable portfolio of 15 patents. His work primarily focuses on systems and methods that enhance database management and synchronization, addressing critical challenges in data consistency and record maintenance.

Latest Patents

Among his latest patents, Richard has developed a "System and method for re-synchronizing a portion of or an entire source database and a target database." This invention ensures the consistency of a data warehouse or backup database with a source database. The method alleviates issues of comparing two sets of the same data on disparate network systems and eliminates the need to reload the entire target database or compare every field to ensure reasonable consistency of the contents. The process involves loading a unique record identifier, an optional record change timestamp, and an optional record archive field of a source database into a work file or temporary database table. Records that do not exist in the target database or have timestamp mismatches are retrieved from the source database and added to or updated in the target database. Additionally, target database records that are archived or missing in the work file or temporary database table are archived or deleted from the target database.

Another significant patent is the "System and method for revising record keys to coordinate record key changes within at least two databases." This invention coordinates the changing of identifiers, such as primary keys and foreign keys, of new records generated by a first system. It improves upon prior art transactional methods that maintain relationships among records when updating records of a first database with replacement of primary and foreign keys provided by another database management system. The new method teaches how to batch update relationship fields in the first database with fewer database updates, providing large savings for columnar databases and speeding up record key maintenance across multiple databases.

Career Highlights

Richard has worked with various companies throughout his career, including Sesame Software. His contributions to the field of database management have been significant, showcasing his expertise in developing innovative solutions that address complex data challenges.

Collaborations

Richard has collaborated with notable individuals in the industry, including William Dubberley and Thomas Hawkes. Their combined efforts have contributed to advancements in database technology and synchronization methods.

Conclusion

Richard Banister's innovative work in database synchronization and management has made a lasting impact on the field. His patents reflect a deep understanding of the complexities involved

This text is generated by artificial intelligence and may not be accurate.

Please report any incorrect information to support@idiyas.com