Patents by Inventor Derek STRIDE

Derek STRIDE has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Optimized database system with updated materialized view
    Patent number: 12487993
    Abstract: 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.
    Type: Grant
    Filed: May 31, 2023
    Date of Patent: December 2, 2025
    Assignee: SHOPIFY INC.
    Inventors: Derek Stride, Oleksiy Kovyrin
  • OPTIMIZED DATABASE SYSTEM WITH UPDATED MATERIALIZED VIEW
    Publication number: 20240403288
    Abstract: 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.
    Type: Application
    Filed: May 31, 2023
    Publication date: December 5, 2024
    Applicant: Shopify, Inc.
    Inventors: Derek STRIDE, Oleksiy KOVYRIN