Patents by Inventor Amit PATHAK

Amit PATHAK 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).

  • Publication number: 20250139015
    Abstract: In some implementations, there is provided a method that includes configuring a first threshold for page-loadable data at a buffer cache associated with a database; checking the buffer cache to determine usage of the buffer cache by the page-loadable data; in response to the usage of the buffer cache being more than the first threshold, causing a background job to release one or more buffers in the buffer cache; checking, after releasing at least one buffer of the buffer cache, the buffer cache to determine whether usage by the page-loadable data is below the first threshold; in response to the usage being below the first threshold, stopping the release of additional one or more buffers in the buffer cache; and in response to the usage being above the first threshold, continuing the release of the additional one or more buffers in the buffer cache.
    Type: Application
    Filed: October 26, 2023
    Publication date: May 1, 2025
    Inventors: Nishant Vijayvergiya, Amit Pathak, Sebastian Seifert, Thomas Peh, Sergej Hardock
  • Patent number: 12282494
    Abstract: A primary database system loads database objects into a primary in-memory store according to a given format. The primary database captures, in replay logs, the loading of the database objects according to the given format. The primary database sends the replay logs to a secondary database system. In response to receiving a replay log, the secondary database checks the value of a log replay configuration parameter. If the configuration parameter is a first value, the secondary database replays the replay log to load the corresponding database objects into a secondary in-memory store according to a first format. If the configuration parameter is a second value, the secondary database replays the log to load the objects according to a second format, and if the configuration parameter is a third value, the secondary database replays the log to load the objects in a same format which was used by the primary database.
    Type: Grant
    Filed: December 5, 2023
    Date of Patent: April 22, 2025
    Assignee: SAP SE
    Inventors: Janardhan Hungund, Neha Shikha Kachhap, Jagadeesha Kanihal, Sebastian Seifert, Bernhard Scheirle, Amit Pathak, Werner Thesing, Thomas Peh
  • Patent number: 12242497
    Abstract: A database system detects a query targeting a first database object stored in a unified persistence format in a persistence store. In response to detecting the query, the database system determines whether to load the first database object in column-loadable format or page-loadable format into an in-memory store. In response to determining to load the first database object in the column-loadable format, the database system determines if a first bit representation of one or more corresponding primitives in the persistence store is compatible with a second bit representation used for storing the primitives in the in-memory store. The database system performs a native copy operation to copy the primitives from the persistence store to the in-memory store if the bit representations are compatible, where the native copy operation involves copying the primitives on a page-by-page basis without decoding and encoding values of the one or more primitives.
    Type: Grant
    Filed: November 8, 2023
    Date of Patent: March 4, 2025
    Assignee: SAP SE
    Inventors: Anish Maniyar, Santhosh T Kumar, Guo Gang Ye, Amit Pathak, Sebastian Seifert, Souvik Pal
  • Patent number: 12067003
    Abstract: A system and method including receiving a request to update a timestamp associated with database pages of a database instance logically organized into at least one page set, each of the at least one page set including a plurality of the database pages; updating the timestamp associated with each database page in each respective at least one page set; issuing, in response to updating the timestamp associated with a last database page in each of the at least one page set, a write request to write the plurality of database pages in each of the respective at least one page set to a persistent data store; and writing the plurality of database pages in each of the respective at least one page set to a persistent data store, the plurality of database pages written to the persistent data store having an updated timestamp associated therewith.
    Type: Grant
    Filed: November 28, 2022
    Date of Patent: August 20, 2024
    Assignee: SAP SE
    Inventors: Padmaja Dhairyasheel Thorat, Amit Pathak, Mukundakrishnan Parthasarathy
  • Publication number: 20240176772
    Abstract: A system and method including receiving a request to update a timestamp associated with database pages of a database instance logically organized into at least one page set, each of the at least one page set including a plurality of the database pages; updating the timestamp associated with each database page in each respective at least one page set; issuing, in response to updating the timestamp associated with a last database page in each of the at least one page set, a write request to write the plurality of database pages in each of the respective at least one page set to a persistent data store; and writing the plurality of database pages in each of the respective at least one page set to a persistent data store, the plurality of database pages written to the persistent data store having an updated timestamp associated therewith.
    Type: Application
    Filed: November 28, 2022
    Publication date: May 30, 2024
    Inventors: Padmaja Dhairyasheel THORAT, Amit PATHAK, Mukundakrishnan PARTHASARATHY
  • Patent number: 11884934
    Abstract: Among the various aspects of the present disclosure is the provision of methods, synthetic DC, and compositions for T cell activation. The present disclosure provides for synthetic dendritic cells (DCs), methods of generating synthetic dendritic cells (DCs), methods of generating T cell-encapsulated gelatin microspheres and microcapsules, methods of activating T cells using synthetic DCs, methods for expanding T cells against individualized antigen-specific mutational antigens using synthetic DCs, and methods of treating a chronic disease (e.g., HIV, HPV) or cancer using the synthetic DCs.
    Type: Grant
    Filed: July 20, 2018
    Date of Patent: January 30, 2024
    Assignee: Washington University
    Inventors: Eynav Klechevsky, Amit Pathak, Bapi Sarker
  • Patent number: 11886723
    Abstract: According to some embodiments, a system, method and non-transitory, computer readable medium are provided comprising a memory storing processor-executable program code; and a processing unit to cause the system to: receive a range of persistent volume disk size values from a cloud service provider; receive a value for an upper bound of a number of persistent volume disks attachable to a virtual machine per the cloud service; determine a number of persistent volume disks based on the upper bound, wherein the number is at least two; generate a plurality of configurations of the determined number of persistent volume disks, wherein a configuration is provided for each persistent volume disk size value, and each configuration divides the persistent volume disk size value between two or more persistent volume disks; and aggregate the generated plurality of configurations in a decision table. Numerous other aspects are provided.
    Type: Grant
    Filed: November 19, 2021
    Date of Patent: January 30, 2024
    Assignee: SAP SE
    Inventors: Prateek Agarwal, Paresh Rathod, Samar Desai, Shrikant Awate, Amit Pathak, Dheren Gala, Mitali Yadav
  • Patent number: 11755565
    Abstract: Disclosed herein are system, method, and computer-program product embodiments for generating a paged and in-memory representation of a database object. An embodiment operates by maintaining in-memory and paged form primitives unique to the database object or a substructure thereof in a database such that the in-memory and paged form primitives are capable of providing the in-memory and paged representations of the database objects, respectively. Thereafter, a load configuration for the database object is determined. Based on the load configuration, the in-memory and/or paged representations of the database object are generated using the in-memory form primitive or the paged form primitive unique to the database object, respectively. Subsequently, the in-memory and/or paged representations of the database object are stored in the database.
    Type: Grant
    Filed: October 7, 2021
    Date of Patent: September 12, 2023
    Assignee: SAP SE
    Inventors: Colin Florendo, Mihnea Andrei, Amit Pathak, Robert Schulze, Adrian Dragusanu, Reza Sherkat, Sebastian Seifert, Christian Lemke
  • Patent number: 11697793
    Abstract: Among the various aspects of the present disclosure is the provision of a hydrogel-based substrate comprising an aldehyde-containing component, such as N-ethanal acrylamide. The hydrogel component allows for functionalization of a hydrogel through conjugation of proteins (e.g., collagen) to the hydrogel in the absence of a post hoc crosslinking component.
    Type: Grant
    Filed: October 10, 2019
    Date of Patent: July 11, 2023
    Assignee: Washington University
    Inventors: Amit Pathak, Bapi Sarker
  • Patent number: 11663200
    Abstract: Disclosed herein are system, method, and computer program product embodiments for storing an object onto a first or second page. An embodiment operates by receiving the object and determining that the first page has sufficient unused space for storing at least one byte of the object. Thereafter, a data block of the object is created to comprise at least one byte of the object. The data block is then stored on the first page or the second page, and a location of the object's first data block is recorded. Thereafter, a pointer corresponding to the location of the object's first data block for loading the object is provided.
    Type: Grant
    Filed: December 2, 2021
    Date of Patent: May 30, 2023
    Assignee: SAP SE
    Inventors: Pushkar Khadilkar, Colin Florendo, Amit Pathak
  • Patent number: 11544246
    Abstract: Techniques of implementing partition level operations with concurrent activities are disclosed. A first operation can be performed on a first partition of a table of data. The first partition can be one of a plurality of partitions of the table, where each partition has a plurality of rows. A first partition level lock can be applied to the first partition for a period in which the first operation is being performed on the first partition, thereby preventing any operation other than the first operation from being performed on the first partition during the period the first partition level lock is being applied to the first partition. A second operation can be performed on a second partition of the table at a point in time during which the first operation is being performed on the first partition.
    Type: Grant
    Filed: September 23, 2020
    Date of Patent: January 3, 2023
    Assignee: SYBASE, INC.
    Inventors: Amit Pathak, Paresh Rathod, Swati Sharma, Nikhil Jamadagni
  • Patent number: 11514028
    Abstract: System, method, and various embodiments for providing a hybrid data storage and load system are described herein. An embodiment operates by receiving a lookup request comprising a row identifier (ROWID) corresponding to a row of a table of a database. Which of a first set of pages corresponds to a sorted position of the ROWID is identified. The identified page of the first set of pages is loaded from the disk storage to the memory storage. A sorted row position of the ROWID is identified from a memory block of the loaded page from the first set of pages. One of a second set of pages that includes the sorted row position is identified. The identified one of the second set of pages is loaded from the disk storage into memory. The loaded identified one of the second set of pages is searched for the unsorted position of the ROWID.
    Type: Grant
    Filed: April 30, 2020
    Date of Patent: November 29, 2022
    Assignee: SAP SE
    Inventors: Amit Pathak, Colin Florendo, Pushkar Khadilkar, Robert Schulze
  • Patent number: 11468028
    Abstract: A system for an in-memory row storage architecture can be provided. In some implementations, the system performs operations comprising monitoring access to a plurality of rows in a database partition, a first portion of the plurality of rows stored in a persistent page store and a second portion of the plurality of rows stored in an in-memory row store. The operations can further comprise determining workload parameters based on the monitoring, selecting a location for performing a database operation on the database partition based on the workload parameters, and performing the database operation on the database partition within the selected location (e.g., the persistent page store or the in-memory row store). Related systems, methods, and articles of manufacture are also described.
    Type: Grant
    Filed: February 28, 2018
    Date of Patent: October 11, 2022
    Assignee: SAP SE
    Inventors: Aditya Gurajada, Amit Pathak, Pushkar Khadilkar
  • Patent number: 11386082
    Abstract: Disclosed herein are system, method, and computer program product embodiments for providing paged and compressed storage for column data, while maintaining existing access mechanisms for the data. In order to reduce an in-memory footprint for column data, columns may be stored in pageable format using page chains, and only those pages of the column data needed to resolve a query will be placed in memory, and evicted from memory when no longer needed. In order to further reduce the footprint for these columns, compression can be applied, and the compressed column data stored in the same pageable format using page chains. The compressed data includes a plurality of vectors, each of which is converted into pages and stored on the page chain with the others so that they can be efficiently retrieved during database retrieval operations.
    Type: Grant
    Filed: June 5, 2020
    Date of Patent: July 12, 2022
    Assignee: SAP SE
    Inventors: Mehul Wagle, Colin Florendo, Pushkar Khadilkar, Robert Schulze, Reza Sherkat, Amit Pathak
  • Publication number: 20220092057
    Abstract: Disclosed herein are system, method, and computer program product embodiments for storing an object onto a first or second page. An embodiment operates by receiving the object and determining that the first page has sufficient unused space for storing at least one byte of the object. Thereafter, a data block of the object is created to comprise at least one byte of the object. The data block is then stored on the first page or the second page, and a location of the object's first data block is recorded. Thereafter, a pointer corresponding to the location of the object's first data block for loading the object is provided.
    Type: Application
    Filed: December 2, 2021
    Publication date: March 24, 2022
    Inventors: Pushkar KHADILKAR, Colin FLORENDO, Amit PATHAK
  • Patent number: 11256680
    Abstract: Systems and methods may include execution of a database workload on a plurality of database tables, collection of execution statistics associated with execution of the database workload, determination of an in-memory row storage cache size for multi-version concurrency control based on the collected execution statistics, and configuration of a database system to allocate the in-memory row storage cache size for multi-version concurrency control.
    Type: Grant
    Filed: May 14, 2019
    Date of Patent: February 22, 2022
    Assignee: SAP SE
    Inventors: Nilesh Gohad, Amit Pathak, Dheren Gala
  • Publication number: 20220027354
    Abstract: Disclosed herein are system, method, and computer-program product embodiments for generating a paged and in-memory representation of a database object. An embodiment operates by maintaining in-memory and paged form primitives unique to the database object or a substructure thereof in a database such that the in-memory and paged form primitives are capable of providing the in-memory and paged representations of the database objects, respectively. Thereafter, a load configuration for the database object is determined. Based on the load configuration, the in-memory and/or paged representations of the database object are generated using the in-memory form primitive or the paged form primitive unique to the database object, respectively. Subsequently, the in-memory and/or paged representations of the database object are stored in the database.
    Type: Application
    Filed: October 7, 2021
    Publication date: January 27, 2022
    Inventors: Colin FLORENDO, Mihnea ANDREI, Amit PATHAK, Robert SCHULZE, Adrian DRAGUSANU, Reza SHERKAT, Sebastian SEIFERT, Christian LEMKE
  • Patent number: 11194789
    Abstract: Disclosed herein are system, method, and computer program product embodiments for storing an object onto a first or second page. An embodiment operates by receiving the object and determining that the first page has sufficient unused space for storing at least one byte of the object. Thereafter, a data block of the object is created to comprise at least one byte of the object. The data block is then stored on the first page or the second page, and a location of the object's first data block is recorded. Thereafter, a pointer corresponding to the location of the object's first data block for loading the object is provided.
    Type: Grant
    Filed: April 24, 2020
    Date of Patent: December 7, 2021
    Assignee: SAP SE
    Inventors: Pushkar Khadilkar, Colin Florendo, Amit Pathak
  • Patent number: 11151126
    Abstract: Disclosed herein are system, method, and computer-program product embodiments for generating a paged and in-memory representation of a database object. An embodiment operates by maintaining in-memory and paged form primitives unique to the database object or a substructure thereof in a database such that the in-memory and paged form primitives are capable of providing the in-memory and paged representations of the database objects, respectively. Thereafter, a load configuration for the database object is determined. Based on the load configuration, the in-memory and/or paged representations of the database object are generated using the in-memory form primitive or the paged form primitive unique to the database object, respectively. Subsequently, the in-memory and/or paged representations of the database object are stored in the database.
    Type: Grant
    Filed: May 5, 2020
    Date of Patent: October 19, 2021
    Assignee: SAP SE
    Inventors: Colin Florendo, Mihnea Andrei, Amit Pathak, Robert Schulze, Adrian Dragusanu, Reza Sherkat, Sebastian Seifert, Christian Lemke
  • Publication number: 20210163894
    Abstract: Among the various aspects of the present disclosure is the provision of methods, synthetic DC, and compositions for T cell activation. The present disclosure provides for synthetic dendritic cells (DCs), methods of generating synthetic dendritic cells (DCs), methods of generating T cell-encapsulated gelatin microspheres and microcapsules, methods of activating T cells using synthetic DCs, methods for expanding T cells against individualized antigen-specific mutational antigens using synthetic DCs, and methods of treating a chronic disease (e.g., HIV, HPV) or cancer using the synthetic DCs.
    Type: Application
    Filed: July 20, 2018
    Publication date: June 3, 2021
    Applicant: Washington University
    Inventors: Eynav KLECHEVSKY, Amit PATHAK, Bapi SARKER