Fast refresh of snapshots
May 30, 2017. Estimated Expiration Date is calculated based on simple USPTO term provisions. It does not account for terminal disclaimers, term adjustments, failure to pay maintenance fees, or other factors which might affect the term of a patent.Patent ReferencesMethod for refreshing multicolumn tables in a relational data base using minimal information Capturing data of a database system Dynamic, finite versioning for concurrent transaction and query processing Distributed multi-version commitment ordering protocols for guaranteeing serializability during transaction processing Configurable conflict resolution in a computer implemented distributed database Method and apparatus for peer-to-peer data replication Patent #: 5806075 InventorsApplicationNo. 865645 filed on 05/30/1997US Classes:707/200, FILE OR DATABASE MAINTENANCE707/2, Access augmentation or optimizing707/100, DATABASE SCHEMA OR DATA STRUCTURE707/102, Generating database or data structure (e.g., via user interface)707/104.1, Application of database or data structure (e.g., distributed, multimedia, image)707/201Coherency (e.g., same view to multiple users)ExaminersPrimary: Fetting, Anton W.Assistant: Corrielus, Jean B. Attorney, Agent or FirmInternational ClassG06F 017/30AbstractA method and apparatus employs primary key values stored in a master table to drive a fast refresh mechanism for a snapshot defined on the master table. A primary key is a set of columns in the master table having a combined value that uniquely identifies each row in the master table. When rows of the master table are modified, the primary key values of the modified rows are recorded in a master log. In response to a fresh command, differences between the master table and snapshot are reconciled based on primary key values stored in the master table, the master log, and the snapshot. | |
