公开(公告)号：US20190073399A1

公开(公告)日：2019-03-07

申请号：US16147280

申请日：2018-09-28

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Ravi Murthy ,  Muralidhar Krishnaprasad ,  Sivasankaran Chandrasekar ,  Nipun Agarwal

IPC: G06F17/30

Abstract: A method and apparatus for managing hierarchical relationships in a relational database system is provided. An “orderkey” data type, which is native within a relational database system, is disclosed. The orderkey type is designed to contain values that represent the position of an entity relative to the positions of other entities within a hierarchy. Such values represent hierarchical relationships between those entities. Values that are of the orderkey type have properties that allow hierarchy-oriented functions to be performed in an especially efficient manner. Database functions, which operate on and/or produce values that are of the orderkey type, are also disclosed. Such functions can be placed within SQL statements that a database server executes, for example. In response to executing SQL statements that contain such functions, the database server performs hierarchy-oriented operations in a highly efficient manner.

公开(公告)号：US11416577B2

公开(公告)日：2022-08-16

申请号：US16862951

申请日：2020-04-30

Applicant: Oracle International Corporation

Inventor： Ravi Murthy

IPC: G06F40/131 ,  G06F40/134 ,  G06F40/154 ,  G06F40/143 ,  G06F16/958 ,  G06F16/93 ,  G06F16/835 ,  G06F16/955 ,  G06F16/23 ,  G06F16/957

Abstract: A declarative mechanism is used to manage large documents within a repository. The large documents are sectioned into subdocuments that are linked together by a parent document. The combination of the parent document and subdocument is referred to as a compound document. There are multiple options for configuring rules to break up a source document into a compound document and naming the subdocuments. The compound documents may be queried using statements that treat the compound document as a single XML document, or the parent document of a subdocument may be queried and treated independently. Access control and versioning can be applied at the finer granularity of the subdocument.

公开(公告)号：US20200342044A1

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

申请号：US16862951

申请日：2020-04-30

Applicant: Oracle International Corporation

Inventor： Ravi Murthy

IPC: G06F16/958 ,  G06F16/93 ,  G06F16/835 ,  G06F16/955 ,  G06F40/14 ,  G06F40/131

Abstract: A declarative mechanism is used to manage large documents within a repository. The large documents are sectioned into subdocuments that are linked together by a parent document. The combination of the parent document and subdocument is referred to as a compound document. There are multiple options for configuring rules to break up a source document into a compound document and naming the subdocuments. The compound documents may be queried using statements that treat the compound document as a single XML document, or the parent document of a subdocument may be queried and treated independently. Access control and versioning can be applied at the finer granularity of the subdocument.

公开(公告)号：US09898545B2

公开(公告)日：2018-02-20

申请号：US14608029

申请日：2015-01-28

Applicant: Oracle International Corporation

Inventor： Sam Idicula ,  Nipun Agarwal ,  Ravi Murthy ,  Eric Sedlar

IPC: G06F15/173 ,  G06F17/30 ,  G06F12/02 ,  G06F12/0817 ,  G06F12/0831

CPC classification number: G06F17/30893 ,  G06F12/0246 ,  G06F12/0817 ,  G06F12/0833 ,  G06F17/30091 ,  G06F17/30595 ,  G06F2212/62 ,  G06F2212/622 ,  G06F2212/7204

Abstract: A method and apparatus for processing path-based database operations is provided. According to one aspect, a path cache is maintained. For each hierarchical node that is traversed during a path-determining operation, it is determined whether a cache entry corresponding to that node is already contained in the path cache. If such a cache entry is already contained in the path cache, then the path indicated in that cache entry is used to complete the pathname for the node for which the operation is being performed. As a result, hierarchically higher nodes do not need to be traversed to complete the operation. Alternatively, if such a cache entry is not already contained in the path cache, then a cache entry for the node currently being traversed is generated and inserted into the path cache for use in subsequent path-determining operations.

公开(公告)号：US09015150B2

公开(公告)日：2015-04-21

申请号：US13923072

申请日：2013-06-20

Applicant: Oracle International Corporation

Inventor： Nikhil Raghavan ,  Ravi Murthy ,  Aman Naimat

IPC: G06F17/30 ,  G06F7/00

CPC classification number: G06F17/30554 ,  G06F17/30941

Abstract: Techniques are disclosed for presenting semi-structured sets of search results comprising two or more differently-structured subsets of search results. The search results are divided into two or more groups of similarly-structured results. The search results are displayed in their respective groups rather than as a single set. Each group is displayed using a different display structure, in an order determined by a group ranking mechanism. The search results within a group ordered by a result ranking mechanism. Techniques are also disclosed for enhancing a display of similarly structured data by emphasizing highly relevant result fields. The highly relevant result fields may be identified based on metadata ranking mechanisms, uniqueness of their constituent values, historical feedback, keyword location, and/or other mechanisms. The fields are emphasized using, without limitation, highlighting, reordering, and filtering of unemphasized fields from the display.

Abstract translation: 公开了用于呈现包括搜索结果的两个或多个不同结构的子集的搜索结果的半结构化集合的技术。 搜索结果分为两组或多组相似结构的结果。 搜索结果显示在它们各自的组中而不是单个集合中。 使用不同的显示结构显示每个组，按照组排名机制确定的顺序。 由结果排序机制排序的组内的搜索结果。 还公开了通过强调高度相关的结果字段来增强类似结构化数据的显示的技术。 高度相关的结果字段可以基于元数据排名机制，其组成值的唯一性，历史反馈，关键词位置和/或其他机制来识别。 使用而不是限制从显示中突出显示，重新排序和过滤未强调的字段来强调这些字段。

公开(公告)号：US10650080B2

公开(公告)日：2020-05-12

申请号：US14873748

申请日：2015-10-02

Applicant: Oracle International Corporation

Inventor： Ravi Murthy

IPC: G06F16/958 ,  G06F16/93 ,  G06F16/835 ,  G06F16/955 ,  G06F40/14 ,  G06F40/131

Abstract: A declarative mechanism is used to manage large documents within a repository. The large documents are sectioned into subdocuments that are linked together by a parent document. The combination of the parent document and subdocument is referred to as a compound document. There are multiple options for configuring rules to break up a source document into a compound document and naming the subdocuments. The compound documents may be queried using statements that treat the compound document as a single XML document, or the parent document of a subdocument may be queried and treated independently. Access control and versioning can be applied at the finer granularity of the subdocument.

公开(公告)号：US09171065B2

公开(公告)日：2015-10-27

申请号：US14222521

申请日：2014-03-21

Applicant: Oracle International Corporation

Inventor： Nikhil Raghavan ,  Ravi Murthy ,  Aman Naimat

IPC: G06F7/00 ,  G06F17/30

CPC classification number: G06F17/30651 ,  G06F17/30112 ,  G06F17/30958

Abstract: Highly relevant search results for unstructured queries are efficiently identified from normalized data. A server graphs relationships between each of the data objects. For each search term, the server identifies a candidate set of data objects mapped to the term. The server calculates priority scores for the candidate data objects based at least in part on one or more of: a link analysis of the graph; or an analysis of metadata describing structural constraints upon the candidate data objects. Based on the graph, the server identifies one or more search result subgraphs, each comprising at least one data object from each of the candidate sets. The server looks for subgraphs in an order that is based on the priority scores for the candidate data objects. The server may terminate its search early, in part because prioritizing the candidate data objects increases the likelihood of receiving relevant search results first.

Abstract translation: 从规范化数据有效地识别非结构化查询的高度相关的搜索结果。 服务器显示每个数据对象之间的关系。 对于每个搜索项，服务器识别映射到该术语的候选数据对象集合。 服务器至少部分地基于图形的链接分析中的一个或多个来计算候选数据对象的优先级分数; 或描述对候选数据对象的结构约束的元数据的分析。 基于该图，服务器识别一个或多个搜索结果子图，每个包括来自每个候选集的至少一个数据对象。 服务器按照候选数据对象的优先级得分的顺序查找子图。 服务器可以提前终止其搜索，部分原因是优先级候选数据对象增加了首先接收相关搜索结果的可能性。

公开(公告)号：US08930348B2

公开(公告)日：2015-01-06

申请号：US13953582

申请日：2013-07-29

Applicant: Oracle International Corporation

Inventor： Asha Tarachandani ,  Sivasankaran Chandrasekar ,  Man-Hay Tam ,  Anh-Tuan Tran ,  Ravi Murthy ,  Nipun Agarwal ,  Eric Sedlar

IPC: G06F7/00 ,  G06F17/30 ,  G06F17/22

CPC classification number: G06F17/30011 ,  G06F17/2229 ,  G06F17/2247 ,  G06F17/30908

Abstract: A mechanism is provided for detecting and disregarding application specific nodes contained in shared XML documents. The techniques described involve determining one or more application specific nodes within XML documents and performing path expression evaluations of the XML documents as if the nodes are not present. In one embodiment, a mechanism is provided by which a user may specify the criterion that determine which subset of node in XML documents are to be ignored from path expression evaluations and evaluating a query that specifies a path operation based on a path and ignoring said identified nodes when evaluating said path operation.

Abstract translation: 提供了一种用于检测和忽略包含在共享XML文档中的应用程序特定节点的机制。 所描述的技术涉及确定XML文档内的一个或多个应用特定节点，并且如同节点不存在一样执行XML文档的路径表达式评估。 在一个实施例中，提供了一种机制，用户可以通过该机制指定确定XML文档中的节点的哪个子集将被从路径表达式评估中忽略的标准，并且基于路径评估指定路径操作的查询，并忽略所述标识的 节点在评估所述路径操作时。

公开(公告)号：US08924416B2

公开(公告)日：2014-12-30

申请号：US13923033

申请日：2013-06-20

Applicant: Oracle International Corporation

Inventor： Eric Sedlar ,  Aman Naimat ,  Ravi Murthy ,  Doug McMahon

IPC: G06F17/30

CPC classification number: G06F17/30424 ,  G06F17/30923

Abstract: A platform (referred to herein as Extensible Application Platform, or XAP) for developing extensible business applications. In one set of embodiments, XAP can include an Extensible Markup Language (XML) based application model that is designed to support a high degree of application extensibility. For example, the XAP application model can support declarative definition of application semantics, separation of application data and metadata, and a flexible type system that allows constraints and calculations (e.g., XQuery constraints and calculations) for a data object instance (e.g., an XML document) to change over time. In certain embodiments, the XAP application model can be implemented via a server-side database/application engine that is configured to interoperate with a spreadsheet-like, client-side user interface. Using the spreadsheet-like UI, a non-programmer can build, customize, and run an application workflow that operates on top of a shared database like a traditional business application.

Abstract translation: 用于开发可扩展业务应用程序的平台（在此称为可扩展应用程序平台或XAP）。 在一组实施例中，XAP可以包括基于可扩展标记语言（XML）的应用模型，其被设计为支持高度的应用可扩展性。 例如，XAP应用程序模型可以支持应用程序语义的声明性定义，应用程序数据和元数据的分离以及允许数据对象实例的约束和计算（例如，XQuery约束和计算）的灵活类型系统（例如，XML 文件）随时间变化。 在某些实施例中，XAP应用模型可以经由服务器端数据库/应用引擎来实现，其被配置为与电子表格样的客户端用户界面进行互操作。 使用类似电子表格的UI，非程序员可以构建，自定义和运行在诸如传统业务应用程序的共享数据库之上运行的应用程序工作流。

公开(公告)号：US20130346438A1

公开(公告)日：2013-12-26

申请号：US13923033

申请日：2013-06-20

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Eric SEDLAR ,  Aman Naimat ,  Ravi Murthy ,  Doug McMahon

IPC: G06F17/30

CPC classification number: G06F17/30424 ,  G06F17/30923

Abstract: A platform (referred to herein as Extensible Application Platform, or XAP) for developing extensible business applications. In one set of embodiments, XAP can include an Extensible Markup Language (XML) based application model that is designed to support a high degree of application extensibility. For example, the XAP application model can support declarative definition of application semantics, separation of application data and metadata, and a flexible type system that allows constraints and calculations (e.g., XQuery constraints and calculations) for a data object instance (e.g., an XML document) to change over time. In certain embodiments, the XAP application model can be implemented via a server-side database/application engine that is configured to interoperate with a spreadsheet-like, client-side user interface. Using the spreadsheet-like UI, a non-programmer can build, customize, and run an application workflow that operates on top of a shared database like a traditional business application.

Abstract translation: 用于开发可扩展业务应用程序的平台（在此称为可扩展应用程序平台或XAP）。 在一组实施例中，XAP可以包括基于可扩展标记语言（XML）的应用模型，其被设计为支持高度的应用可扩展性。 例如，XAP应用程序模型可以支持应用程序语义的声明性定义，应用程序数据和元数据的分离以及允许数据对象实例的约束和计算（例如，XQuery约束和计算）的灵活类型系统（例如，XML 文件）随时间变化。 在某些实施例中，XAP应用模型可以经由服务器端数据库/应用引擎来实现，其被配置为与电子表格样的客户端用户界面进行互操作。 使用类似电子表格的UI，非程序员可以构建，自定义和运行在诸如传统业务应用程序的共享数据库之上运行的应用程序工作流。