中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

10 records (took 0.017 seconds)

    LOB query performance via automatic inference of locator-less LOB by value semantics
    1.
    发明授权
    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.

    LOB QUERY PERFORMANCE VIA AUTOMATIC INFERENCE OF LOCATOR-LESS LOB BY VALUE SEMANTICS
    2.
    发明申请
    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.

    Method and system for implementing distributed lobs
    3.
    发明授权
    Method and system for implementing distributed lobs 有权

    公开(公告)号：US11907251B2

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

    申请号：US15690894

    申请日：2017-08-30

    Applicant: ORACLE INTERNATIONAL CORPORATION

    Inventor： Lakshminarayanan Chidambaran ,  Srividya Tata ,  Geeta Arora ,  Rajendra S. Pingte ,  Sneha Chandrababu ,  Ramkrishan Kanodia

    IPC: G06F16/27 ,  G06F16/22

    CPC classification number: G06F16/27 ,  G06F16/2219 ,  G06F16/2282

    Abstract: Upon receiving a query at a local database server from a client directed to a LOB stored at a remote database server, a remote LOB locator is created comprising a local LOB locator indicating the LOB's location and a database link associated with the remote database server. The remote LOB locator is communicated to the client, which submits a request to the local database server to perform an operation directed to the LOB. The request is forwarded to the remote database server using the remote LOB locator, where the operation is performed. This mechanism is extended to work with sharded databases. Character set conversions are minimized when returning data to the client from the remote database server. Remote LOB locators may serve as bind variables for DML statements directed to local or remote tables. Local LOB locators may serve as bind variables for DML statements directed to remote tables.

Patent Agency Ranking