Patents by Inventor Kumar Rajamani

Kumar Rajamani 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).

  • 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: 11010540
    Abstract: Systems, methods, and software are disclosed herein for enhancing group collaboration in the context of productivity applications. In an implementation, a productivity application includes a user interface in which a document may be presented. In addition, a view of a groups feature provided by a social network service may be presented in the user interface to the productivity application. The view may include various options or interacting with the groups feature, such as the ability to create a new group, the ability to post comments to a group in the social network service, and the ability to upload documents to a group.
    Type: Grant
    Filed: June 23, 2016
    Date of Patent: May 18, 2021
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Stéphane Morichère-Matte, Michael Anthony Navarro, Om Krishna, Michael Andrew Griscom, Vidyaraman Sankaranarayanan, Roopesh Kumar Rajamani, Darron J. Stepanich, Peter John Daoud, Alvin Ji-Fung Lao, Gregory Iannacone, Ronald Nikolai Bartlett Savas, Grace Lam, Sumanth Pasupuleti
  • Publication number: 20210081355
    Abstract: Techniques described herein automatically check for persistently inactive instances, based on defined metrics, and auto-archive such instances to lower-cost cloud resources. An inactivity time threshold is dynamically adjustable to a longer or shorter time period based on current load running on limited/more expensive resources to more aggressively or less aggressively archive the inactive instances, thus enabling additional active instances to run on the limited/more expensive resources and supporting more total users.
    Type: Application
    Filed: August 26, 2020
    Publication date: March 18, 2021
    Inventors: Todd A. Bottger, Hochak Hung, Kumar Rajamani
  • Publication number: 20210056123
    Abstract: Embodiments minimize downtime involved in moving a PDB between CDBs by allowing read-write access to the PDB through most of the moving operation, and by transparently forwarding connection requests, for the PDB, from the source CDB to the destination CDB. The files of a source PDB are copied from a source CDB to a destination CDB, during which the source PDB may be in read-write mode. The source PDB is then closed to write operations so that changes to the source PDB cease. Another round of recovery is performed on the PDB clone, which applies all changes that have been performed on the source PDB during the copy operation and the PDB clone is opened for read and write operations. Forwarding information is registered with the source location, which information is used to automatically forward connection requests, received at the source location for the moved PDB, to the destination location.
    Type: Application
    Filed: November 5, 2020
    Publication date: February 25, 2021
    Inventors: Jaebock Lee, Kumar Rajamani, Sanket Jain, Giridhar Ravipati
  • Patent number: 10922331
    Abstract: Embodiments create a clone of a PDB while the PDB accepts write operations. While the PDB remains in read-write mode, the DBMS copies the data of the PDB and sends the data to a destination location. The DBMS performs data recovery on the PDB clone based on redo entries that record changes made to the source PDB while the DBMS copied the source PDB files. This data recovery makes all changes, to the PDB clone, that occurred to the source PDB during the copy operation. The redo information, on which the data recovery is based, is foreign to the PDB clone since the redo entries were recorded for a different PDB. In order to apply foreign redo information to perform recovery on the PDB clone, a DBMS managing the PDB clone maintains mapping information that maps PDB source reference information to corresponding information for the PDB clone.
    Type: Grant
    Filed: July 20, 2016
    Date of Patent: February 16, 2021
    Assignee: Oracle International Corporation
    Inventors: Giridhar Ravipati, Kumar Rajamani, Yunrui Li, Jaebock Lee, Sanket Jain
  • Patent number: 10915549
    Abstract: Embodiments incrementally refresh a clone of a source PDB while the source PDB accepts write operations. Specifically, refreshing the PDB clone incorporates changes made to the source PDB since a refresh reference time stamp, which marks the time at which the PDB clone was created or, if the PDB clone has been previously refreshed, the time at which the PDB clone was last refreshed. A PDB clone is incrementally refreshed by incorporating, into the PDB clone data, those source data blocks that have changed since the refresh reference time stamp. Recovery is performed on the PDB clone, once the blocks are copied, to apply any changes made to the source PDB while the blocks were being copied, which recovery makes the PDB clone files consistent. This recovery is based on redo entries recorded for the source PDB during the time it took to copy the blocks to the PDB clone.
    Type: Grant
    Filed: July 20, 2016
    Date of Patent: February 9, 2021
    Assignee: Oracle International Corporation
    Inventors: Giridhar Ravipati, Kumar Rajamani, Yunrui Li, Muthu Olagappan, Jaebock Lee, Sanket Jain
  • Patent number: 10891291
    Abstract: A refreshable PDB clone is associated with a PDB-specific logical timestamp (LT) service that continuously reflects the LT of the most recent changes that have fully committed within the PDB clone during a refresh operation. Such an LT service is used to perform queries over the changing data in the PDB clone while the PDB clone is undergoing a refresh operation. Furthermore, a PDB-specific LT service can facilitate write operations in a standby CDB, where the standby CDB is a physical standby of a source CDB. Specifically, a standby CDB is configured with a private read-write PDB that does not replicate data from the source CDB. This private PDB may accommodate a write operation required by a query over data in the standby CDB. A PDB-specific LT service provides LTs for such a private PDB where the PDB-specific LT service provides LTs to order changes made within the private PDB.
    Type: Grant
    Filed: October 31, 2016
    Date of Patent: January 12, 2021
    Assignee: Oracle International Corporation
    Inventors: Yunrui Li, Kumar Rajamani
  • 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
  • Patent number: 10860605
    Abstract: Embodiments minimize downtime involved in moving a PDB between CDBs by allowing read-write access to the PDB through most of the moving operation, and by transparently forwarding connection requests, for the PDB, from the source CDB to the destination CDB. The files of a source PDB are copied from a source CDB to a destination CDB, during which the source PDB may be in read-write mode. The source PDB is then closed to write operations so that changes to the source PDB cease. Another round of recovery is performed on the PDB clone, which applies all changes that have been performed on the source PDB during the copy operation and the PDB clone is opened for read and write operations. Forwarding information is registered with the source location, which information is used to automatically forward connection requests, received at the source location for the moved PDB, to the destination location.
    Type: Grant
    Filed: July 20, 2016
    Date of Patent: December 8, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Jaebock Lee, Kumar Rajamani, Sanket Jain, Giridhar Ravipati
  • Patent number: 10803078
    Abstract: In an approach, a database management system is configured in a manner that allows all pluggable databases within a cluster to be treated, from the perspective of a user, as though stored on a single container database, even when the pluggable databases are distributed across a plurality of container databases. When a command is received by a database server that is to be executed on all or a subset of the pluggable databases within the cluster, the database inspects mapping information replicated on all container databases within the cluster by a cluster synchronization server to determine which container databases store pluggable databases implicated by the command. The command is then forwarded to the database servers responsible for the determined container databases for execution. As a result, the commands issued by the user can be agnostic in regard to the actual location of the pluggable databases within the cluster.
    Type: Grant
    Filed: October 21, 2016
    Date of Patent: October 13, 2020
    Assignee: Oracle International Corporation
    Inventors: Sanket Jain, Kumar Rajamani, Giridhar Ravipati, Jaebock Lee
  • Patent number: 10789131
    Abstract: Techniques are provided for creating a backup of a source pluggable database (SPD) of a source container database and porting the backup for recovery into a different target container database. In an embodiment, a source database server retrieves metadata that describes backups of the SPD. The source database server inserts, into an unplugged pluggable database of the SPD, the metadata that describes each of the backups. For example, unplugging the SPD may automatically create the unplugged pluggable database. Eventually, the unplugged pluggable database may be plugged into the target container database. A target database server transfers the metadata that describes each of the backups from the unplugged pluggable database and into the target container database. Based on at least one backup and the metadata that describes backups of the SPD, the target database server restores a target pluggable database within the target container database.
    Type: Grant
    Filed: September 1, 2016
    Date of Patent: September 29, 2020
    Assignee: Oracle International Corporation
    Inventors: Kumar Rajamani, Muthu Olagappan, Yunrui Li, Giridhar Ravipati, Jing Zheng
  • Patent number: 10733316
    Abstract: Techniques are described herein for allowing a container DBMS to impose restrictions, on a per-pluggable-database basis, on operations based on the pluggable database to which the users that request the operations belong. In one embodiment, lockdown profiles can be created and mapped to pluggable databases. Lockdown profiles specify PDB-wide restrictions on operations. The restrictions may apply to all operations of a given type, may apply to specific features, may require use of specific parameter values, etc. All users that belong to a pluggable database are restricted by the restrictions specified in the lockdown profile to which their pluggable database is mapped, unless the lockdown profile has a user-specific exemption for them. Bitmaps and/or hash tables may be used to more quickly determine, at query runtime, whether a query violates any profile-specified restrictions. Execution of queries that violate any profile-specified restrictions is prevented.
    Type: Grant
    Filed: August 23, 2016
    Date of Patent: August 4, 2020
    Assignee: Oracle International Corporation
    Inventors: Prashanth Shanthaveerappa, Sanket Jain, Kumar Rajamani, Andre Kruglikov
  • 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: 10635658
    Abstract: Techniques are provided for diverting, to cloned metadata, live access to original metadata of an application container that is being concurrently upgraded. In an embodiment, a database server stores, within an application container of an application, original metadata that defines objects for use by pluggable databases of the application. The database server receives a maintenance request to adjust the original metadata. The database server creates, in response to receiving the maintenance request, a reference container that contains cloned metadata that is a copy of the original metadata. The database server receives, during or after creating the reference container, a read request to read one of the objects. The database server concurrently performs both of: executing the maintenance request upon the original metadata, and executing the read request upon the cloned metadata of the reference container.
    Type: Grant
    Filed: September 15, 2016
    Date of Patent: April 28, 2020
    Assignee: Oracle International Corporation
    Inventors: Philip Yam, Thomas Baby, Andre Kruglikov, Kumar Rajamani
  • Patent number: 10635674
    Abstract: Embodiments provide a migration instruction that effectuates the migration of a pluggable database from a source database server instance to a destination database server instance. Upon receiving the migration instruction, the migrating pluggable database is opened at the destination instance. Connections are terminated at the source instance at a rate that is determined based on statistics maintained for one or more of: the migrating pluggable database, the source instance, the destination instance, a container database, etc. Furthermore, once the migration instruction is received, a certain amount of time is provided before the source instance flushes the dirty buffers for the migrating pluggable database from the buffer cache of the source instance. The delay in flushing dirty buffers from buffer cache allows the source instance to provide data blocks, of the migrating pluggable database, directly to the destination database server instance from the cache.
    Type: Grant
    Filed: April 7, 2016
    Date of Patent: April 28, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Sanket Jain, Kumar Rajamani, Jaebock Lee, Nicolas Michael, Yixiao Shen, Giridhar Ravipati
  • Patent number: 10635675
    Abstract: A pluggable database (PDB) that is encoded using a particular character set (differing character set) may be plugged into a container database (CDB) and queried, even when the CDB in which the particular PDB resides is encoded using a different character set. The DBMS records what character set is used to encode the PDB. Any predicate that may prune results from a PDB that is encoded in a differing character set is converted to the differing character set as needed, such that the predicate may be applied within the PDB to prune results. At times, cross-container views will require data from a PDB that is encoded using a differing character set. The data returned from a recursive query over the PDB is converted to being encoded using the character set of the root database of the CDB.
    Type: Grant
    Filed: June 24, 2016
    Date of Patent: April 28, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Sanket Jain, Kumar Rajamani, Jaebock Lee, Giridhar Ravipati
  • Patent number: 10621176
    Abstract: A database server instance automatically detects configuration issues when a pluggable database (PDB) is plugged into a new destination container database (CDB). The database server instance identifies one or more update templates, within the destination CDB, that, when run over the relocated PDB, will update the configuration of the PDB to conform to the configuration of the destination CDB. Instead of requiring an administrator to initiate update scripts from a DBMS kernel to reconfigure a PDB, the DBMS creates the update templates by recording commands run within PDBs in connection with system updates. These recorded update templates may then be run over relocated PDBs, to configure the PDBs according to the configuration of the destination CDB. Further, the update templates may be pre-recorded update templates, which record commands to perform configuration updates, to PDBs, that have never before been performed within the CDB.
    Type: Grant
    Filed: September 15, 2016
    Date of Patent: April 14, 2020
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Philip Yam, Kumar Rajamani, Jaebock Lee
  • Patent number: 10606578
    Abstract: Techniques herein use rules automation and template pluggable databases to facilitate deployment into container databases. In an embodiment, a system of computers loads rules into a rules engine. Each rule associates a predicate with suitable container databases. The system receives a request to install a target pluggable database. The rules engine detects satisfied rules whose predicates match the request. Based on the suitable container databases of the satisfied rules, the rules engine selects a particular container database. The system installs the target pluggable database into the particular container database. In an embodiment, a system of computers stores a plurality of template pluggable databases in a repository. The repository receives an installation request. Based on the installation request, the system selects a particular template pluggable database. The system installs the particular template pluggable database into a container database.
    Type: Grant
    Filed: September 15, 2016
    Date of Patent: March 31, 2020
    Assignee: Oracle International Corporation
    Inventors: Andre Kruglikov, Kumar Rajamani, Debaditya Chatterjee
  • 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
  • Patent number: 10572551
    Abstract: In an approach, memory usage within a database management system is optimized by designating an application root which stores data and metadata for database objects that are common across pluggable databases which support the same application. In addition, the application root can be used to manage access to the pluggable databases by defining common users which are created at the application root, but can be used to access any of the member pluggable databases. Furthermore, different versions of the same application can be supported concurrently by maintaining separate application roots for each version. For instance, when an upgrade is applied to the application root, a clone can be created and the update can be applied to the clone. Then, the member pluggable databases which are to be upgraded can be synchronized to the clone, while leaving other pluggable databases servicing the previous version of the application.
    Type: Grant
    Filed: October 21, 2016
    Date of Patent: February 25, 2020
    Assignee: Oracle International Corporation
    Inventors: Andre Kruglikov, Kumar Rajamani, Thomas Baby, Philip Yam