Patents by Inventor Toon Koppelaars

Toon Koppelaars 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).

  • Method for serializing transactions to enforce general-purpose integrity constraints
    Patent number: 11080268
    Abstract: Techniques are disclosed for serializing assertion-triggering transactions by locking special purpose resources (i.e. other than rows or tables), which enables a high level of concurrency for these transactions while at the same time ensuring correctness of the SQL assertion validation code. The techniques involve creating objects referred to therein as “Assertion-Locking Memory-Objects” or “ALMOs”. The database server causes each assertion-triggering transaction to obtain locks on one or more ALMOs prior to determining whether the changes made by assertion-triggering transaction violates the assertion. Because locks on the ALMOs are finer than the table locks, fewer transactions are blocked by ALMO locks.
    Type: Grant
    Filed: January 14, 2019
    Date of Patent: August 3, 2021
    Assignee: Oracle International Corporation
    Inventor: Toon Koppelaars
  • METHOD FOR SERIALIZING TRANSACTIONS TO ENFORCE GENERAL-PURPOSE INTEGRITY CONSTRAINTS
    Publication number: 20200226122
    Abstract: Techniques are disclosed for serializing assertion-triggering transactions by locking special purpose resources (i.e. other than rows or tables), which enables a high level of concurrency for these transactions while at the same time ensuring correctness of the SQL assertion validation code. The techniques involve creating objects referred to therein as “Assertion-Locking Memory-Objects” or “ALMOs”. The database server causes each assertion-triggering transaction to obtain locks on one or more ALMOs prior to determining whether the changes made by assertion-triggering transaction violates the assertion. Because locks on the ALMOs are finer than the table locks, fewer transactions are blocked by ALMO locks.
    Type: Application
    Filed: January 14, 2019
    Publication date: July 16, 2020
    Inventor: Toon Koppelaars