Back to results
US 2024/0403288 A1Published application
Optimized database system with updated materialized view
AssigneeShopify Inc.
InventorsDerek STRIDE, Oleksiy KOVYRIN
Life of this patent
Estimating the term…
Loading patent…
Loading patent…
AssigneeShopify Inc.
InventorsDerek STRIDE, Oleksiy KOVYRIN
Estimating the term…
The server hosting the database scans a binlog for database change events. When a log consumer identifies a change event indicating that certain database records were modified, the consumer pulls only the identifiers of the modified records from the binlog. The log consumer then populates and pushes only the identifiers of the modified records into a non-transitory storage location that is accessible to a database streaming bus. The streaming bus publishes the identifiers for consumption by instances of materialization workers. The hosting server invokes parallel processor threads to execute the materialization workers. The materialization worker rewrites a query script for constructing a materialized view of certain database records, including the modified database records indicated by the identifiers. The materialization worker executes the query script to construct the materialized view, which contains only the modified database records used for generating the database updates to commit to the database.
A processor-implemented method comprising:
A system comprising:
A non-transitory machine-readable storage medium having computer-executable instructions stored thereon that, when executed by one or more processors, cause the one or more processors to perform operations comprising:
Dependencies are inferred from the claim text.