Patents by Inventor Janaki Latha Lahorani

Janaki Latha Lahorani 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).

  • Efficient data retrieval in staged use of in-memory cursor duration temporary tables
    Patent number: 10783142
    Abstract: Techniques are presented herein for storing cursor duration temporary tables in memory of nodes in a clustered database system in association with iterations of an iterative query operation. The techniques involve associating a portion of memory with one or more iteration values. The iteration values indicate which iterations correspond to data that is stored in the portion of memory. When data is requested for a particular iteration, portions of memory are checked to determine if it stores the particular iteration.
    Type: Grant
    Filed: September 16, 2016
    Date of Patent: September 22, 2020
    Assignee: Oracle International Corporation
    Inventors: Janaki Latha Lahorani, Mohamed Ziauddin, You Jung Kim
  • In-memory cursor duration temp tables
    Patent number: 10452655
    Abstract: Techniques are provided herein for processing a query using in-memory cursor duration temporary tables. The techniques involve storing a part of the temporary table in memory of nodes in a database cluster. A part of the temporary table may be stored in disk segments of nodes in the database cluster. Writer threads running on a particular node writes data for the temporary table to the memory of the particular node. Excess data may be written to the disk segment of the particular node. Reader threads running on the particular node reads data for the temporary table from the memory of the particular node and the disk segment of the particular node.
    Type: Grant
    Filed: September 16, 2016
    Date of Patent: October 22, 2019
    Assignee: Oracle International Corporation
    Inventors: Janaki Latha Lahorani, You Jung Kim, Andrew Witkowski, Sankar Subramanian
  • EFFICIENT DATA RETRIEVAL IN STAGED USE OF IN-MEMORY CURSOR DURATION TEMPORARY TABLES
    Publication number: 20170116272
    Abstract: Techniques are presented herein for storing cursor duration temporary tables in memory of nodes in a clustered database system in association with iterations of an iterative query operation. The techniques involve associating a portion of memory with one or more iteration values. The iteration values indicate which iterations correspond to data that is stored in the portion of memory. When data is requested for a particular iteration, portions of memory are checked to determine if it stores the particular iteration.
    Type: Application
    Filed: September 16, 2016
    Publication date: April 27, 2017
    Inventors: Janaki Latha Lahorani, Mohamed Ziauddin, You Jung Kim
  • IN-MEMORY CURSOR DURATION TEMP TABLES
    Publication number: 20170116266
    Abstract: Techniques are provided herein for processing a query using in-memory cursor duration temporary tables. The techniques involve storing a part of the temporary table in memory of nodes in a database cluster. A part of the temporary table may be stored in disk segments of nodes in the database cluster. Writer threads running on a particular node writes data for the temporary table to the memory of the particular node. Excess data may be written to the disk segment of the particular node. Reader threads running on the particular node reads data for the temporary table from the memory of the particular node and the disk segment of the particular node.
    Type: Application
    Filed: September 16, 2016
    Publication date: April 27, 2017
    Inventors: Janaki Latha Lahorani, You Jung Kim, Andrew Witkowski, Sankar Subramanian