Patents by Inventor Sofoklis Floratos

Sofoklis Floratos 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).

  • Processing iterative query constructs in relational databases
    Patent number: 11960479
    Abstract: A method for functionally rewriting iterative queries for a relational database management system (RDBMS) is provided. The method comprises receiving a first iterative query, the first iterative query having a first non-iterative part that defines a first main table and a first iterative part that generates values in rows of a first working table based on values in rows of the first main table, determining that the first iterative part modifies all of the rows of the first working table, and rewriting the first iterative part, including: adding a renaming operation to rename the first working table to a new first main table and to rename the first main table to a new first working table, adding a first Delete operation to delete each row of the new first working table, and adding a first loop operation to repeat the first iterative part until a first termination condition is met.
    Type: Grant
    Filed: October 28, 2022
    Date of Patent: April 16, 2024
    Assignee: Huawei Technologies Co., Ltd.
    Inventors: Yang Sun, Sofoklis Floratos, Ahmad Ghazal, Jianjun Chen, Xiaodong Zhang
  • PROCESSING ITERATIVE QUERY CONSTRUCTS IN RELATIONAL DATABASES
    Publication number: 20230083420
    Abstract: A method for functionally rewriting iterative queries for a relational database management system (RDBMS) is provided. The method comprises receiving a first iterative query, the first iterative query having a first non-iterative part that defines a first main table and a first iterative part that generates values in rows of a first working table based on values in rows of the first main table, determining that the first iterative part modifies all of the rows of the first working table, and rewriting the first iterative part, including: adding a renaming operation to rename the first working table to a new first main table and to rename the first main table to a new first working table, adding a first Delete operation to delete each row of the new first working table, and adding a first loop operation to repeat the first iterative part until a first termination condition is met.
    Type: Application
    Filed: October 28, 2022
    Publication date: March 16, 2023
    Applicant: Huawei Technologies Co., Ltd.
    Inventors: Yang Sun, Sofoklis Floratos, Ahmad Ghazal, Jianjun CHEN, Xiaodong Zhang