知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

22 records (took 0.018 seconds)

    Evaluating XML Full Text Search
    1.
    发明申请
    Evaluating XML Full Text Search 有权

    公开(公告)号：US20210109967A1

    公开(公告)日：2021-04-15

    申请号：US17129085

    申请日：2020-12-21

    Applicant: oracle international corporation

    Inventor： Zhen Hua Liu ,  Ying Lu ,  Hui Joe Chang

    IPC: G06F16/835

    Abstract: Techniques are described to improve query evaluation in computer systems. In an embodiment, a system receives a full text query for evaluation against a collection of hierarchically marked data object sets. The query specifies token(s) and context(s) which indicate hierarchical location(s) to match within a queried hierarchical data structure. To evaluate the query, the system determines a) data object set(s) that contain the query specified token(s) using token list(s), and/or b) data object set(s) that contain the query specified context(s) using label list(s).

    TECHNIQUE OF COMPREHENSIVELY SUPPORT AUTONOMOUS JSON DOCUMENT OBJECT (AJD) CLOUD SERVICE
    2.
    发明申请
    TECHNIQUE OF COMPREHENSIVELY SUPPORT AUTONOMOUS JSON DOCUMENT OBJECT (AJD) CLOUD SERVICE 审中-公开

    公开(公告)号：US20200210398A1

    公开(公告)日：2020-07-02

    申请号：US16690817

    申请日：2019-11-21

    Applicant: Oracle International Corporation

    Inventor： Zhen Hua Liu ,  Vikas Arora ,  Ying Lu ,  Sriram Krishnamurthy ,  Hui Joe Chang ,  Beda Christoph Hammerschmidt ,  Joshua Jeffrey Spiegel

    IPC: G06F16/22 ,  G06F16/2455 ,  G06F16/28

    Abstract: The present invention relates to autonomous tuning of a data grid of documents in a database. Herein are techniques for storage cells to autonomously maintain local indices and other optimization metadata and algorithms to accelerate selective access into a distributed collection of documents. In an embodiment, each storage cell persists a respective subset of documents. Each storage cell stores, in memory, respective index(s) that map each item to location(s), in one or more documents of the respective subset of documents, where the item occurs. One or more computers execute, based on at least a subset of the indices of the storage cells, a data access request from a database management system. In an embodiment, a cloud of JSON document services provides an easy-to-use, fully autonomous JSON document database that horizontally and elastically scales to deliver fast execution of document transactions and queries without needing tuning by a database administrator.

    Leveraging structured XML index data for evaluating database queries
    3.
    发明授权
    Leveraging structured XML index data for evaluating database queries 有权

    公开(公告)号：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.

    LOB query performance via automatic inference of locator-less LOB by value semantics
    8.
    发明授权
    LOB query performance via automatic inference of locator-less LOB by value semantics 有权

    公开(公告)号：US10942924B2

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

    申请号：US15807336

    申请日：2017-11-08

    Applicant: Oracle International Corporation

    Inventor： Zhen Hua Liu ,  Geeta Arora ,  Hui Joe Chang

    IPC: G06F16/00 ,  G06F16/2455 ,  G06F16/28 ,  G06F16/22 ,  G06F16/242

    Abstract: An approach for improving LOB query performance via automatic inference of locator-less LOB by value semantics in a relational database system is provided. A relational database management system (RDBMS) is implemented to perform operations on LOBs based on the semantics of a statement. During statement compilation, the RDBMS identifies inline LOB column(s) that are not required to be returned to a client. During execution, the identified column(s) are accessed via a shared buffer cache and fed to an operator for evaluation. For inline LOB column(s) that must be returned to the client, during execution, the inline LOB data is copied from the shared buffer cache to a temporary buffer area. Data in the temporary buffer area is fed to an operator for evaluation and is used to create a LOB locator for the inline LOB column(s) that must be returned to the client.

    Evaluating XML full text search
    9.
    发明授权
    Evaluating XML full text search 有权

    公开(公告)号：US10915575B2

    公开(公告)日：2021-02-09

    申请号：US13783141

    申请日：2013-03-01

    Applicant: Oracle International Corporation

    Inventor： Zhen Hua Liu ,  Ying Li ,  Hui Joe Chang

    IPC: G06F16/835

    Abstract: Methods and systems for improved query evaluation in computer systems are provided. A system receives a full text query for evaluation against a collection of XML documents. The query comprises specifies one or more tokens and one or more contexts. The contexts each represent a path within an XML expression. The query is used to make multiple determinations. First, determining, using token lists, first documents that contain the tokens included in the query. Second, determining, using tag lists, second documents that contain the contexts included in the query. Third, determining third documents by comparing the first documents and the second documents to determine which documents contain both the tokens and the contexts. The query is then evaluated in view of the third documents.

    Predicate offload of large objects
    10.
    发明授权
    Predicate offload of large objects 有权

    公开(公告)号：US10409795B2

    公开(公告)日：2019-09-10

    申请号：US13831137

    申请日：2013-03-14

    Applicant: ORACLE INTERNATIONAL CORPORATION

    Inventor： Vineet Marwah ,  Amit Ganesh ,  Teck Hua Lee ,  Hui Joe Chang ,  Zhen Hua Liu

    IPC: G06F16/22

    Abstract: In an approach, the database server generates a request for data representing rows of a table, the request identifying one or more data blocks stored on a storage system. The database server then generates metadata describing one or more filtering conditions to be applied to the rows and sends the metadata along with the request to the storage system. The storage system, when applying filtering conditions to a column containing a LOB, determines whether the LOB is stored in-line or out-of-line. If the column contains an out-of-line LOB, the storage system skips the filtering conditions on the column. If the column contains an in-line LOB, the storage system applies the filtering conditions to the column. Upon obtaining the filtered data from the storage system, the database server retrieves the data blocks for out-of-line LOBs and applies the skipped filtering conditions to create a final result set.

Patent Agency Ranking