Patents by Inventor Margaret Susairaj

Margaret Susairaj 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: 20240037074
    Abstract: Disclosed is an improved approach to access the contents of database file system. The contents of the database file system can be acquired and stored in a directory buffer. A parallel tree structure is used to retrieve directory contents quickly and in a consistent fashion.
    Type: Application
    Filed: July 29, 2022
    Publication date: February 1, 2024
    Applicant: Oracle International Corporation
    Inventors: Margaret Susairaj, Jose Antonio Lasa Gutierrez, Sumanta Chatterjee
  • Publication number: 20230021672
    Abstract: A computer program product, system, and computer implemented method for rapid database restoration using a database restore and recovery process that leverages one or more sparse data files and/or blocks by restoring one or more sparse data files and/or blocks and providing a mechanism to redirect requests to the one or more sparse data files and/or blocks to a backup copy of the actual data files and/or blocks and a process to populate the one or more sparse data files and/or blocks while the database is operational for servicing user requests. The approach includes the creation and population of one or more sparse data files and/or blocks, a redirection mechanism to service read operations where necessary, and a process to restore the data to one or more sparse data files and/or blocks over time, while the database maintains operability.
    Type: Application
    Filed: July 20, 2021
    Publication date: January 26, 2023
    Applicant: Oracle International Corporation
    Inventors: Margaret SUSAIRAJ, Steven WERTHEIMER, Sibsankar HALDAR, Sumanta CHATTERJEE, Jose Antonio LASA GUTIERREZ
  • Patent number: 11550667
    Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.
    Type: Grant
    Filed: February 14, 2020
    Date of Patent: January 10, 2023
    Assignee: Oracle International Corporation
    Inventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
  • Patent number: 11068437
    Abstract: Techniques are provided for using a sparse file to create a hot archive of a pluggable database of a container database. In an embodiment and while a source pluggable database is in service, a source database server creates a clone of the source pluggable database. Also while the source pluggable database is in service, the source database server creates an archive of the source pluggable database that is based on the clone. Eventually, a need arises to consume the archive. A target database server (which may also be the source database server) creates a target pluggable database based on the archive.
    Type: Grant
    Filed: September 15, 2016
    Date of Patent: July 20, 2021
    Assignee: Oracle Interntional Corporation
    Inventors: Margaret Susairaj, Giridhar Ravipati, Kumar Rajamani, Yunrui Li, Jaebock Lee, Sanket Jain
  • Patent number: 10860237
    Abstract: Techniques are described herein for cloning a database. According to some embodiments, a database server receives a request to clone a source database. In response to receiving the request, the database server retrieves a set of one or more storage credentials for a set of one or more respective storage systems on which a set of files of the source database are stored. The set of storage credentials grant permission to the database server to create snapshot copies on the set of storage systems. The database server generates, for a target database using the set of storage credentials, a snapshot copy of each respective file in the set of files of the source database. The snapshot copy of the respective file points to the same set of one or more data blocks as the respective file until at least one of the data blocks is modified.
    Type: Grant
    Filed: June 24, 2014
    Date of Patent: December 8, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Margaret Susairaj, Sumanta Chatterjee, Kumar Rajamani
  • Publication number: 20200183792
    Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.
    Type: Application
    Filed: February 14, 2020
    Publication date: June 11, 2020
    Inventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
  • Patent number: 10579478
    Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.
    Type: Grant
    Filed: August 23, 2016
    Date of Patent: March 3, 2020
    Assignee: Oracle International Corporation
    Inventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
  • Publication number: 20200026774
    Abstract: Techniques are provided for using a sparse file to create a hot archive of a pluggable database of a container database. In an embodiment and while a source pluggable database is in service, a source database server creates a clone of the source pluggable database. Also while the source pluggable database is in service, the source database server creates an archive of the source pluggable database that is based on the clone. Eventually, a need arises to consume the archive. A target database server (which may also be the source database server) creates a target pluggable database based on the archive.
    Type: Application
    Filed: September 15, 2016
    Publication date: January 23, 2020
    Inventors: Margaret Susairaj, Giridhar Ravipati, Kumar Rajamani, Yunrui Li, Jaebock Lee, Sanket Jain
  • Publication number: 20200026608
    Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.
    Type: Application
    Filed: August 23, 2016
    Publication date: January 23, 2020
    Inventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
  • Patent number: 10318475
    Abstract: In accordance with an embodiment, described herein is a system and method for enabling persistence of application data, using replication over a remote direct memory access (RDMA) network. In an enterprise application server or other environment having a plurality of processing nodes, a replicated store enables application data to be written using remote direct memory access to the random access memory (RAM) of a set of nodes, which avoids single points of failure. Replicated store daemons allocate and expose memory to client applications via network endpoints, at which data operations such as reads and writes can be performed, in a manner similar to a block storage device. Resilvering can be used to copy data from one node to another, if it is determined that the number of data replicas within a particular set of nodes is not sufficient to meet the persistence requirements of a particular client application.
    Type: Grant
    Filed: June 24, 2015
    Date of Patent: June 11, 2019
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Arun Kaimalettu, Margaret Susairaj, Sumanta Chatterjee, Joseph Francis Therrattil Koonen, Richard Frank
  • Publication number: 20180075041
    Abstract: Techniques are provided for using a sparse file to create a hot archive of a pluggable database of a container database. In an embodiment and while a source pluggable database is in service, a source database server creates a clone of the source pluggable database. Also while the source pluggable database is in service, the source database server creates an archive of the source pluggable database that is based on the clone. Eventually, a need arises to consume the archive. A target database server (which may also be the source database server) creates a target pluggable database based on the archive.
    Type: Application
    Filed: September 15, 2016
    Publication date: March 15, 2018
    Inventors: Margaret Susairaj, Giridhar Ravipati, Kumar Rajamani, Yunrui Li, Jaebock Lee, Sanket Jain
  • Publication number: 20180060177
    Abstract: Techniques herein make and use a pluggable database archive file (AF). In an embodiment, a source database server of a source container database (SCD) inserts contents into an AF from a source pluggable database (SPD). The contents include data files from the SPD, a listing of the data files, rollback scripts, and a list of patches applied to the SPD. A target database server (TDS) of a target container database (TCD) creates a target pluggable database (TPD) based on the AF. If a patch on the list of patches does not exist in the TCD, the TDS executes the rollback scripts to adjust the TPD. In an embodiment, the TDS receives a request to access a block of a particular data file. The TDS detects, based on the listing of the data files, a position of the block within the AF. The TDS retrieves the block based on the position.
    Type: Application
    Filed: August 23, 2016
    Publication date: March 1, 2018
    Inventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
  • Publication number: 20160378713
    Abstract: In accordance with an embodiment, described herein is a system and method for enabling persistence of application data, using replication over a remote direct memory access (RDMA) network. In an enterprise application server or other environment having a plurality of processing nodes, a replicated store enables application data to be written using remote direct memory access to the random access memory (RAM) of a set of nodes, which avoids single points of failure. Replicated store daemons allocate and expose memory to client applications via network endpoints, at which data operations such as reads and writes can be performed, in a manner similar to a block storage device. Resilvering can be used to copy data from one node to another, if it is determined that the number of data replicas within a particular set of nodes is not sufficient to meet the persistence requirements of a particular client application.
    Type: Application
    Filed: June 24, 2015
    Publication date: December 29, 2016
    Inventors: ARUN KAIMALETTU, MARGARET SUSAIRAJ, SUMANTA CHATTERJEE, JOSEPH FRANCIS THERRATTIL KOONEN, RICHARD FRANK
  • Patent number: 9436389
    Abstract: Automated management of shared I/O resources involves use of a policy engine for implementing I/O scheduling group I/O policies. The I/O policies are used for determining whether corresponding I/O requests should be issued to a shared storage system immediately or should be delayed via corresponding policy-based queues. In the context of database systems, a database administrator can specify policies regarding how I/O resources should be used and the database system itself enforces the policies, rather than requiring the database administrator enforce the I/O usage of the database and of the individual users.
    Type: Grant
    Filed: October 31, 2014
    Date of Patent: September 6, 2016
    Assignee: Oracle International Corporation
    Inventors: Sue-Kyoung Lee, Margaret Susairaj, Sumanta Chatterjee
  • Publication number: 20150370641
    Abstract: Techniques are described herein for cloning a database. According to some embodiments, a database server receives a request to clone a source database. In response to receiving the request, the database server retrieves a set of one or more storage credentials for a set of one or more respective storage systems on which a set of files of the source database are stored. The set of storage credentials grant permission to the database server to create snapshot copies on the set of storage systems. The database server generates, for a target database using the set of storage credentials, a snapshot copy of each respective file in the set of files of the source database. The snapshot copy of the respective file points to the same set of one or more data blocks as the respective file until at least one of the data blocks is modified.
    Type: Application
    Filed: June 24, 2014
    Publication date: December 24, 2015
    Inventors: Margaret Susairaj, Sumanta Chatterjee, Kumar Rajamani
  • Publication number: 20150058498
    Abstract: Automated management of shared I/O resources involves use of a policy engine for implementing I/O scheduling group I/O policies. The I/O policies are used for determining whether corresponding I/O requests should be issued to a shared storage system immediately or should be delayed via corresponding policy-based queues. In the context of database systems, a database administrator can specify policies regarding how I/O resources should be used and the database system itself enforces the policies, rather than requiring the database administrator enforce the I/O usage of the database and of the individual users.
    Type: Application
    Filed: October 31, 2014
    Publication date: February 26, 2015
    Inventors: Sue-Kyoung Lee, Margaret Susairaj, Sumanta Chatterjee
  • Patent number: 8892780
    Abstract: Automated management of shared I/O resources involves use of a policy engine for implementing I/O scheduling group I/O policies. The I/O policies are used for determining whether corresponding I/O requests should be issued to a shared storage system immediately or should be delayed via corresponding policy-based queues. In the context of database systems, a database administrator can specify policies regarding how I/O resources should be used and the database system itself enforces the policies, rather than requiring the database administrator enforce the I/O usage of the database and of the individual users.
    Type: Grant
    Filed: March 8, 2007
    Date of Patent: November 18, 2014
    Assignee: Oracle International Corporation
    Inventors: Sue-Kyoung Lee, Margaret Susairaj, Sumanta Chatterjee
  • Patent number: 8874807
    Abstract: Techniques are provided for managing, within a storage system, the sequence in which I/O requests are processed by the storage system based, at least in part, on one or more logical characteristics of the I/O requests. The logical characteristics may include, for example, the identity of the user for whom the I/O request was submitted, the service that submitted the I/O request, the database targeted by the I/O request, an indication of a consumer group to which the I/O request maps, the reason why the I/O request was issued, a priority category of the I/O request, etc. Techniques are also provided for automatically establishing a scheduling policy within a storage system, and for dynamically changing the scheduling policy in response to changes in workload.
    Type: Grant
    Filed: August 20, 2013
    Date of Patent: October 28, 2014
    Assignee: Oracle International Corporation
    Inventors: Sue K. Lee, Vivekananda C. Kolla, Akshay D. Shah, Sumanta Chatterjee, Margaret Susairaj, Juan R. Loaiza, Alexander Tsukerman, Sridhar Subramaniam
  • Patent number: 8832028
    Abstract: A database management system (DBMS) maintains a clone database in a clone space without storing an entire copy of the database and without requiring a snapshot function from an underlying storage device. This DBMS may receive a database command to access a data block of the clone database, and may determine whether the data block is stored in the clone space. If the data block is not stored in the local clone space, the DBMS may receive the data block from a backup copy of the database. If the database command comprises a write operation, the DBMS may perform the write operation to update the data block, and may store the updated data block in the clone space. Also, if the database command comprises a read operation, the DBMS may perform the read operation on the data block received from the backup copy of the database.
    Type: Grant
    Filed: August 25, 2011
    Date of Patent: September 9, 2014
    Assignee: Oracle International Corporation
    Inventors: Margaret Susairaj, Sumanta K. Chatterjee
  • Publication number: 20130339636
    Abstract: Techniques are provided for managing, within a storage system, the sequence in which I/O requests are processed by the storage system based, at least in part, on one or more logical characteristics of the I/O requests. The logical characteristics may include, for example, the identity of the user for whom the I/O request was submitted, the service that submitted the I/O request, the database targeted by the I/O request, an indication of a consumer group to which the I/O request maps, the reason why the I/O request was issued, a priority category of the I/O request, etc. Techniques are also provided for automatically establishing a scheduling policy within a storage system, and for dynamically changing the scheduling policy in response to changes in workload.
    Type: Application
    Filed: August 20, 2013
    Publication date: December 19, 2013
    Applicant: Oracle International Corporation
    Inventors: Sue K. Lee, Vivekananda C. Kolla, Akshay D. Shah, Sumanta Chatterjee, Margaret Susairaj, Juan R. Loaiza, Alexander Tsukerman, Sridhar Subramaniam