-
公开(公告)号:US20190278856A9
公开(公告)日:2019-09-12
申请号:US15266917
申请日:2016-09-15
Applicant: Oracle International Corporation
Inventor: Philip Yam , Thomas Baby , Andre Kruglikov , Kumar Rajamani
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.
-
公开(公告)号:US10360269B2
公开(公告)日:2019-07-23
申请号:US15331657
申请日:2016-10-21
Applicant: Oracle International Corporation
Inventor: Thomas Baby
Abstract: In an approach, when a pluggable database within a container database is transported to a new container database, the pluggable database is replaced with a proxy pluggable database storing forwarding information for the pluggable database. When a command is received that is to be executed on the proxy pluggable database, the database server handling the command uses the forwarding information stored within the proxy pluggable database to forward the command to a second database receiver responsible for the new container database for execution on the pluggable database. The result of executing the command is then returned to the first database server. Thus, application code which references the pluggable database within the original container database does not have to be rewritten to reference the new location and can remain agnostic as to the actual location of the pluggable database.
-
公开(公告)号:US10262076B2
公开(公告)日:2019-04-16
申请号:US14513176
申请日:2014-10-13
Applicant: Oracle International Corporation
Inventor: Hui Joe Chang , Thomas Baby , Zhen Hua Liu
IPC: G06F17/30
Abstract: A query may be rewritten to leverage information stored in a structured XML index. An operator in the query may be analyzed to determine an input source database object for the operator by traversing an operator tree rooted at the operator. The path expressions associated with the operator tree may be fused together to form an effective path expression for the operator. If the effective path expression directly matches a path expression derived from the index, the query may be rewritten using references to the index. Operators in a query that have effective paths that refer to data in the same index table may be grouped together. A single subquery may be written for a group of operators. Also, a structured XML index may be used as an implied schema for indexed XML data. This implied schema may be used to optimize queries that refer to the indexed XML data.
-
公开(公告)号:US10949413B2
公开(公告)日:2021-03-16
申请号:US15885281
申请日:2018-01-31
Applicant: Oracle International Corporation
Inventor: Sachin Vijaykumar Sonawane , Mahesh Baburao Girkar , Yunrui Li , Thomas Baby , Vivekanandhan Raja
Abstract: A database session in an active standby server on which an active standby database resides receives a DML statement. The session is suspended while the statement is redirected over a database link to a primary database on which the statement is executed. Information associated with execution of the statement is communicated to the session in the active standby server. Redo records describing changes to the contents of the primary database are applied to the active standby database and control is returned to the session. Prior to commitment of a transaction including the statement, a query directed to data to which the statement was directed is received at the active standby server from a client and executed on the active standby database absent use of a database link based on whether information associated with a database session associated with the client matches the information associated with execution of the statement.
-
公开(公告)号:US20180075086A1
公开(公告)日:2018-03-15
申请号:US15266917
申请日:2016-09-15
Applicant: Oracle International Corporation
Inventor: Philip Yam , Thomas Baby , Andre Kruglikov , Kumar Rajamani
CPC classification number: G06F16/2379 , G06F8/65 , G06F11/1474 , G06F2201/87
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.
-
公开(公告)号:US20170116335A1
公开(公告)日:2017-04-27
申请号:US15331657
申请日:2016-10-21
Applicant: Oracle International Corporation
Inventor: Thomas Baby
CPC classification number: G06F16/951 , G06F8/65 , G06F16/21 , G06F16/252 , G06F16/27 , H04L67/2814
Abstract: In an approach, when a pluggable database within a container database is transported to a new container database, the pluggable database is replaced with a proxy pluggable database storing forwarding information for the pluggable database. When a command is received that is to be executed on the proxy pluggable database, the database server handling the command uses the forwarding information stored within the proxy pluggable database to forward the command to a second database receiver responsible for the new container database for execution on the pluggable database. The result of executing the command is then returned to the first database server. Thus, application code which references the pluggable database within the original container database does not have to be rewritten to reference the new location and can remain agnostic as to the actual location of the pluggable database.
-
公开(公告)号:US20130185332A1
公开(公告)日:2013-07-18
申请号:US13676592
申请日:2012-11-14
Applicant: Oracle International Corporation
Inventor: Hiroshi Koide , Mark Ture , Mauralidhar Krishnaprasad , Mark Davis , Cindy Hsin , Meeten Bhavsar , Steve Yang , Visar Nimani , Hui Ouyang , Sachin Bhatkar , Thomas Chang , Thomas Baby , David Liao
IPC: G06F21/62
CPC classification number: G06F21/6218 , G06F21/6236 , H04L63/0815
Abstract: A flexible and extensible architecture allows for secure searching across an enterprise. Such an architecture can provide a simple Internet-like search experience to users searching secure content inside (and outside) the enterprise. The architecture allows for the crawling and searching of a variety or of sources across an enterprise, regardless of whether any of these sources conform to a conventional user role model. The architecture further allows for security attributes to be submitted at query time, for example, in order to provide real-time secure access to enterprise resources. The user query also can be transformed to provide for dynamic querying that provides for a more current result list than can be obtained for static queries.
Abstract translation: 灵活可扩展的架构允许跨企业进行安全搜索。 这样的架构可以为在企业内部(和外部)搜索安全内容的用户提供简单的类似Internet的搜索体验。 该架构允许在整个企业中爬行和搜索各种或各种源,而不管这些源是否符合常规用户角色模型。 该体系结构进一步允许在查询时提交安全属性,例如为了提供对企业资源的实时安全访问。 用户查询也可以被转换以提供动态查询,其提供比静态查询可获得的更多当前结果列表。
-
8.
公开(公告)号:US11281670B2
公开(公告)日:2022-03-22
申请号:US16370980
申请日:2019-03-30
Applicant: Oracle International Corporation
Inventor: Thomas Baby , Giridhar Ravipati
IPC: G06F16/00 , G06F16/2455 , G06F12/0813 , G06F16/25
Abstract: A container is a collection of schemas, objects, and related structures in a multitenant container database (CDB) that appears logically to an application as a separate database. Within a CDB, each container has a unique ID and name. The root database and every PDB is considered a container. PDBs isolate data and operations so that from the perspective of a user or application, each PDB appears as if it were a traditional non-CDB. A database management system that manages a container database is a container database management system (CDBMS). Data and metadata in the root database may include common schemas that make the functionality that users will often use available CDB-wide. To execute a query accessing a common schema, the common schemas may be accessed by sessions of a PDB without switching database contexts.
-
公开(公告)号:US10572551B2
公开(公告)日:2020-02-25
申请号:US15331525
申请日:2016-10-21
Applicant: Oracle International Corporation
Inventor: Andre Kruglikov , Kumar Rajamani , Thomas Baby , Philip Yam
IPC: G06F16/00 , G06F16/951 , G06F16/22
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.
-
公开(公告)号:US20170116334A1
公开(公告)日:2017-04-27
申请号:US15331525
申请日:2016-10-21
Applicant: Oracle International Corporation
Inventor: Andre Kruglikov , Kumar Rajamani , Thomas Baby , Philip Yam
IPC: G06F17/30
CPC classification number: G06F16/951 , G06F16/21 , G06F16/22 , G06F16/25
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.
-
-
-
-
-
-
-
-
-