Patents by Inventor Dhrubajyoti Roy

Dhrubajyoti Roy 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).

  • Control versioning of temporal tables to reduce data redundancy
    Patent number: 11874811
    Abstract: Control versioning of records in a temporal table is provided to reduce data redundancy. New Data Definition Language (DDL) syntax is provided to make individual columns within a table sensitive or insensitive to whether new row versions are generated when Database Manipulation Language (DML) statements operate on the table. The database parser and back-end data processors are configured to create the table with the user-defined versioning attributes and to manage versioning of the rows without requiring additional programming.
    Type: Grant
    Filed: December 28, 2018
    Date of Patent: January 16, 2024
    Assignee: Teradata US, Inc.
    Inventors: Stephen Molini, Bhashyam Ramesh, Jaiprakash Ganpatrao Chimanchode, Sai Pavan Kumar Pakala, Pratik Patodi, Dhrubajyoti Roy, Todd Walter
  • Join elimination enhancement for real world temporal applications
    Patent number: 11567941
    Abstract: A database system receives a query and determines that the query includes an inner join between a parent table and a child table. The database system determines that the following relationships exists between the parent table and the child table: referential integrity (“RI”) between a primary key attribute (pk) in the parent table and a foreign key attribute (fk) in the child table and a temporal relationship constraint (“TRC”) between a period attribute in the parent table and a TRC-attribute in the child table. The database system determines that the query satisfies non-temporal join elimination conditions and temporal join elimination conditions and that the query contains no other qualification conditions on the parent table's period attribute and eliminates the inner join when planning execution of the query.
    Type: Grant
    Filed: October 23, 2020
    Date of Patent: January 31, 2023
    Assignee: Teradata US, Inc.
    Inventors: Jaiprakash G Chimanchode, Bhashyam Ramesh, Stephen A Brobst, Pratik Patodi, Dhrubajyoti Roy, Sai Pavan Kumar Pakala
  • Control Versioning of Temporal Tables to Reduce Data Redundancy
    Publication number: 20200210395
    Abstract: Control versioning of records in a temporal table is provided to reduce data redundancy. New Data Definition Language (DDL) syntax is provided to make individual columns within a table sensitive or insensitive to whether new row versions are generated when Database Manipulation Language (DML) statements operate on the table. The database parser and back-end data processors are configured to create the table with the user-defined versioning attributes and to manage versioning of the rows without requiring additional programming.
    Type: Application
    Filed: December 28, 2018
    Publication date: July 2, 2020
    Inventors: Stephen Molini, Bhashyam Ramesh, Jaiprakash Ganpatrao Chimanchode, Sai Pavan Kumar Pakala, Pratik Patodi, Dhrubajyoti Roy, Todd Walter