Patents by Inventor Andre Hernich

Andre Hernich 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).

  • Stored procedures for incremental updates to internal tables for materialized views
    Patent number: 11841848
    Abstract: Stored procedures are generated to perform incremental updates to a materialized view for a database. When a request to create a materialized view is received, one or more internal tables are created from the database. A stored procedure is generated that when executed will update the materialized view of the database. The stored procedure may obtain changes to the database that were not included in the internal tables and update the internal tables to include the obtained changes. The stored procedure may be performed automatically and in response to requests.
    Type: Grant
    Filed: June 6, 2022
    Date of Patent: December 12, 2023
    Assignee: Amazon Technologies, Inc.
    Inventors: Yannis Papakonstantinou, Vuk Ercegovac, Andre Hernich, Enrico Siragusa, Gaurav Saxena
  • Dynamic generation of match rules for rewriting queries to use materialized views
    Patent number: 11550787
    Abstract: Match rules for rewriting queries to use materialized views may be dynamically generated by a database system. A database system may generate rules that indicate whether a given query can use a materialized view and how to rewrite the given query to use the materialized view. A query may be received and the rules may be applied to the query to determine that the query can use the materialized view and to rewrite the query to use the materialized view. The rewritten query can then be executed.
    Type: Grant
    Filed: December 10, 2020
    Date of Patent: January 10, 2023
    Assignee: Amazon Technologies, Inc.
    Inventors: Andre Hernich, Vuk Ercegovac, Gaurav Saxena, Panagiotis Parchas, Yannis Papakonstantinou, Balakrishnan Narayanaswamy, Enrico Siragusa
  • STORED PROCEDURES FOR INCREMENTAL UPDATES TO INTERNAL TABLES FOR MATERIALIZED VIEWS
    Publication number: 20220300492
    Abstract: Stored procedures are generated to perform incremental updates to a materialized view for a database. When a request to create a materialized view is received, one or more internal tables are created from the database. A stored procedure is generated that when executed will update the materialized view of the database. The stored procedure may obtain changes to the database that were not included in the internal tables and update the internal tables to include the obtained changes. The stored procedure may be performed automatically and in response to requests.
    Type: Application
    Filed: June 6, 2022
    Publication date: September 22, 2022
    Applicant: Amazon Technologies, Inc.
    Inventors: Yannis Papakonstantinou, Vuk Ercegovac, Andre Hernich, Enrico Siragusa, Gaurav Saxena
  • Stored procedures for incremental updates to internal tables for materialized views
    Patent number: 11354304
    Abstract: Stored procedures are generated to perform incremental updates to a materialized view for a database. When a request to create a materialized view is received, one or more internal tables are created from the database. A stored procedure is generated that when executed will update the materialized view of the database. The stored procedure may obtain changes to the database that were not included in the internal tables and update the internal tables to include the obtained changes. The stored procedure may be performed automatically and in response to requests.
    Type: Grant
    Filed: November 27, 2019
    Date of Patent: June 7, 2022
    Assignee: Amazon Technologies, Inc.
    Inventors: Yannis Papakonstantinou, Vuk Ercegovac, Andre Hernich, Enrico Siragusa, Gaurav Saxena
  • Applying relational algebraic operations to change result sets of source tables to update a materialized view
    Patent number: 11256684
    Abstract: Algebraic operations are applied to change result sets for source tables to update a materialized view of a database incrementally. A procedure is determined for updating a materialized view that generates result sets for changes to source tables for a materialized view. The procedure performs one or more operations to update the materialized view using the result sets as operands in a relational algebra operator in the procedure to include the changes in the result sets in the materialized view.
    Type: Grant
    Filed: November 27, 2019
    Date of Patent: February 22, 2022
    Assignee: Amazon Technologies, Inc.
    Inventors: Yannis Papakonstantinou, Vuk Ercegovac, Andre Hernich, Enrico Siragusa, Gaurav Saxena