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: 20240037074Abstract: 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: ApplicationFiled: July 29, 2022Publication date: February 1, 2024Applicant: Oracle International CorporationInventors: Margaret Susairaj, Jose Antonio Lasa Gutierrez, Sumanta Chatterjee
-
Publication number: 20230021672Abstract: 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: ApplicationFiled: July 20, 2021Publication date: January 26, 2023Applicant: Oracle International CorporationInventors: Margaret SUSAIRAJ, Steven WERTHEIMER, Sibsankar HALDAR, Sumanta CHATTERJEE, Jose Antonio LASA GUTIERREZ
-
Patent number: 11550667Abstract: 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: GrantFiled: February 14, 2020Date of Patent: January 10, 2023Assignee: Oracle International CorporationInventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
-
Patent number: 11068437Abstract: 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: GrantFiled: September 15, 2016Date of Patent: July 20, 2021Assignee: Oracle Interntional CorporationInventors: Margaret Susairaj, Giridhar Ravipati, Kumar Rajamani, Yunrui Li, Jaebock Lee, Sanket Jain
-
Patent number: 10860237Abstract: 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: GrantFiled: June 24, 2014Date of Patent: December 8, 2020Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Margaret Susairaj, Sumanta Chatterjee, Kumar Rajamani
-
Publication number: 20200183792Abstract: 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: ApplicationFiled: February 14, 2020Publication date: June 11, 2020Inventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
-
Patent number: 10579478Abstract: 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: GrantFiled: August 23, 2016Date of Patent: March 3, 2020Assignee: Oracle International CorporationInventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
-
Publication number: 20200026774Abstract: 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: ApplicationFiled: September 15, 2016Publication date: January 23, 2020Inventors: Margaret Susairaj, Giridhar Ravipati, Kumar Rajamani, Yunrui Li, Jaebock Lee, Sanket Jain
-
Publication number: 20200026608Abstract: 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: ApplicationFiled: August 23, 2016Publication date: January 23, 2020Inventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
-
Patent number: 10318475Abstract: 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: GrantFiled: June 24, 2015Date of Patent: June 11, 2019Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Arun Kaimalettu, Margaret Susairaj, Sumanta Chatterjee, Joseph Francis Therrattil Koonen, Richard Frank
-
Publication number: 20180075041Abstract: 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: ApplicationFiled: September 15, 2016Publication date: March 15, 2018Inventors: Margaret Susairaj, Giridhar Ravipati, Kumar Rajamani, Yunrui Li, Jaebock Lee, Sanket Jain
-
Publication number: 20180060177Abstract: 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: ApplicationFiled: August 23, 2016Publication date: March 1, 2018Inventors: Prashanth Shanthaveerappa, Giridhar Ravipati, Margaret Susairaj, Kumar Rajamani
-
Publication number: 20160378713Abstract: 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: ApplicationFiled: June 24, 2015Publication date: December 29, 2016Inventors: ARUN KAIMALETTU, MARGARET SUSAIRAJ, SUMANTA CHATTERJEE, JOSEPH FRANCIS THERRATTIL KOONEN, RICHARD FRANK
-
Patent number: 9436389Abstract: 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: GrantFiled: October 31, 2014Date of Patent: September 6, 2016Assignee: Oracle International CorporationInventors: Sue-Kyoung Lee, Margaret Susairaj, Sumanta Chatterjee
-
Publication number: 20150370641Abstract: 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: ApplicationFiled: June 24, 2014Publication date: December 24, 2015Inventors: Margaret Susairaj, Sumanta Chatterjee, Kumar Rajamani
-
Publication number: 20150058498Abstract: 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: ApplicationFiled: October 31, 2014Publication date: February 26, 2015Inventors: Sue-Kyoung Lee, Margaret Susairaj, Sumanta Chatterjee
-
Patent number: 8892780Abstract: 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: GrantFiled: March 8, 2007Date of Patent: November 18, 2014Assignee: Oracle International CorporationInventors: Sue-Kyoung Lee, Margaret Susairaj, Sumanta Chatterjee
-
Patent number: 8874807Abstract: 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: GrantFiled: August 20, 2013Date of Patent: October 28, 2014Assignee: Oracle International CorporationInventors: Sue K. Lee, Vivekananda C. Kolla, Akshay D. Shah, Sumanta Chatterjee, Margaret Susairaj, Juan R. Loaiza, Alexander Tsukerman, Sridhar Subramaniam
-
Patent number: 8832028Abstract: 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: GrantFiled: August 25, 2011Date of Patent: September 9, 2014Assignee: Oracle International CorporationInventors: Margaret Susairaj, Sumanta K. Chatterjee
-
Publication number: 20130339636Abstract: 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: ApplicationFiled: August 20, 2013Publication date: December 19, 2013Applicant: Oracle International CorporationInventors: Sue K. Lee, Vivekananda C. Kolla, Akshay D. Shah, Sumanta Chatterjee, Margaret Susairaj, Juan R. Loaiza, Alexander Tsukerman, Sridhar Subramaniam