知搜-全球专利检索

  1. Login
  2. Sign Up

Search Results

22 records (took 0.038 seconds)

    LOB QUERY PERFORMANCE VIA AUTOMATIC INFERENCE OF LOCATOR-LESS LOB BY VALUE SEMANTICS
    11.
    发明申请
    LOB QUERY PERFORMANCE VIA AUTOMATIC INFERENCE OF LOCATOR-LESS LOB BY VALUE SEMANTICS 审中-公开

    公开(公告)号：US20190102450A1

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

    申请号：US15807336

    申请日：2017-11-08

    Applicant: Oracle International Corporation

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

    IPC: G06F17/30

    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
    15.
    发明授权
    Evaluating XML full text search 有权

    公开(公告)号：US11481439B2

    公开(公告)日：2022-10-25

    申请号：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).

    PREDICATE OFFLOAD OF LARGE OBJECTS
    16.
    发明申请
    PREDICATE OFFLOAD OF LARGE OBJECTS 审中-公开
    预测大型物品的卸载

    公开(公告)号：US20140280249A1

    公开(公告)日：2014-09-18

    申请号：US13831137

    申请日：2013-03-14

    Applicant: ORACLE INTERNATIONAL CORPORATION

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

    IPC: G06F17/30

    CPC classification number: G06F16/2219

    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.

    Abstract translation: 在一种方法中，数据库服务器产生表示表的行的数据的请求，该请求标识存储在存储系统上的一个或多个数据块。 数据库服务器然后生成描述要应用于行的一个或多个过滤条件的元数据，并将该元数据与请求一起发送到存储系统。 当对包含LOB的列应用过滤条件时，存储系统确定LOB是在线还是外线存储。 如果列包含行外LOB，则存储系统将跳过列上的过滤条件。 如果列包含行内LOB，存储系统将过滤条件应用于列。 在从存储系统获得经过过滤的数据后，数据库服务器检索用于外行LOB的数据块，并应用跳过的过滤条件以创建最终结果集。

Patent Agency Ranking