公开(公告)号：US20150039642A1

公开(公告)日：2015-02-05

申请号：US14513176

申请日：2014-10-13

Applicant: Oracle International Corporation

Inventor： Hui Joe Chang ,  Thomas Baby ,  Zhen Hua Liu

IPC: G06F17/30

CPC classification number: G06F17/30932 ,  G06F17/30935

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.

Abstract translation: 可以重写查询以利用存储在结构化XML索引中的信息。 可以分析查询中的运算符以通过遍历运算符的操作符树来确定运算符的输入源数据库对象。 与运算符树相关联的路径表达式可以被融合在一起以形成操作者的有效路径表达式。 如果有效路径表达式直接匹配从索引导出的路径表达式，则可以使用对索引的引用来重写查询。 具有指向相同索引表中的数据的有效路径的查询中的运算符可以被分组在一起。 可以为一组运营商编写单个子查询。 此外，结构化XML索引可以用作索引XML数据的隐含模式。 此隐含模式可用于优化引用索引XML数据的查询。

公开(公告)号：US08725770B2

公开(公告)日：2014-05-13

申请号：US13676592

申请日：2012-11-14

Applicant: Oracle International Corporation

Inventor： Hiroshi Koide ,  Mark Ture ,  Muralidhar Krishnaprasad ,  Mark Davis ,  Cindy Hsin ,  Meeten Bhavsar ,  Steve Yang ,  Visar Nimani ,  Hui Ouyang ,  Sachin Bhatkar ,  Thomas Chang ,  Thomas Baby ,  David Liao

IPC: G06F17/30

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的搜索体验。 该架构允许在整个企业中爬行和搜索各种或各种源，而不管这些源是否符合常规用户角色模型。 该体系结构进一步允许在查询时提交安全属性，例如为了提供对企业资源的实时安全访问。 用户查询也可以被转换以提供动态查询，其提供比静态查询可获得的更多当前结果列表。

公开(公告)号：US11847110B2

公开(公告)日：2023-12-19

申请号：US17202024

申请日：2021-03-15

Applicant: Oracle International Corporation

Inventor： Sachin Vijaykumar Sonawane ,  Mahesh Baburao Girkar ,  Yunrui Li ,  Thomas Baby ,  Vivekanandhan Raja

IPC: G06F16/23 ,  G06F16/27 ,  G06F11/14

CPC classification number: G06F16/2365 ,  G06F16/2379 ,  G06F16/275 ,  G06F11/1458

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.

公开(公告)号：US09330124B2

公开(公告)日：2016-05-03

申请号：US14044982

申请日：2013-10-03

Applicant: Oracle International Corporation

Inventor： Beda Hammerschmidt ,  Zhen Hua Liu ,  Thomas Baby ,  Kongyi Zhou

IPC: G06F17/30

CPC classification number: G06F17/30312 ,  G06F17/30595

Abstract: A method, device, and non-transitory computer-readable storage medium are provided for efficiently registering a relational schema. In co-compilation and data guide approaches, a subset of entities from schema descriptions are selected for physical registration, and other entities from the schema descriptions are not physically registered. In the co-compilation approach, a first schema description references a second schema description, and the subset includes a set of entities from the second schema description that are used by the first schema description. In the data guide approach, the subset includes entities that are used by a set of structured documents. In a pay-as-you-go approach, schema registration includes logically registering entities without creating relational database structures corresponding to the entities. A database server may execute database commands that reference the logically registered entities. A request to store data for the entities may be executed by creating relational database structures to store the data.

公开(公告)号：US10963464B2

公开(公告)日：2021-03-30

申请号：US16163198

申请日：2018-10-17

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： George Eadon ,  Thomas Baby ,  Ramesh Kumar

IPC: G06F16/2455 ,  G06F16/2453

Abstract: Disclosed is a system, method, and computer program product that allows multiple partition schemes to be applied to a single object. Each scheme represents the same set of partitions, but the schemes may have different partition methods, different partition keys, and/or different partition bounds.

公开(公告)号：US20200311086A1

公开(公告)日：2020-10-01

申请号：US16370980

申请日：2019-03-30

Applicant: Oracle International Corporation

Inventor： Thomas Baby ,  Giridhar Ravipati

IPC: 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.

公开(公告)号：US20190102421A1

公开(公告)日：2019-04-04

申请号：US15885281

申请日：2018-01-31

Applicant: Oracle International Corporation

Inventor： Sachin Vijaykumar SONAWANE ,  Mahesh Baburao GIRKAR ,  Yunrui LI ,  Thomas Baby ,  Vivekanandhan Raja

IPC: G06F17/30

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.

公开(公告)号：US20170116278A1

公开(公告)日：2017-04-27

申请号：US15331540

申请日：2016-10-21

Applicant: Oracle International Corporation

Inventor： Thomas Baby

IPC: G06F17/30

CPC classification number: G06F16/24554 ,  G06F16/21 ,  G06F16/25 ,  G06F16/252 ,  G06F16/27 ,  G06F16/283

Abstract: In an approach, a database management system logically partitions a database object (such as a table) across multiple pluggable databases of a container database. When a database server receives a query at an application root, the database server consults a container map which provides a mapping between a set of partitioning criteria and a set of member pluggable databases of the application root. Using the container map, the database server identifies one or more pluggable databases of the set of member pluggable databases of the application root that contain records which potentially have the ability to match the predicates of the query. The database server then limits the execution of the query to the identified pluggable databases, effectively pruning away records contained by the other pluggable databases to increase the efficiency of executing the query.