中科微点-全球专利检索

  1. Login
  2. Sign Up

Search Results

10 records (took 0.015 seconds)

    Caching external data sources for SQL processing
    1.
    发明授权
    Caching external data sources for SQL processing 有权
    缓存外部数据源进行SQL处理

    公开(公告)号：US09251210B2

    公开(公告)日：2016-02-02

    申请号：US13866866

    申请日：2013-04-19

    Applicant: Oracle International Corporation

    Inventor： Atif Chaudhry ,  Chandrasekharan Iyer

    IPC: G06F17/30

    CPC classification number: G06F17/30457 ,  G06F17/3048

    Abstract: Techniques are provided for caching external data sources for SQL processing. According to an embodiment, a database system receives a query that requires foreign data from an external data source. In response to receiving the query, the database system determines whether the foreign data currently resides in a cache of the database system. In response to determining that the foreign does not currently reside in the cache, the database system retrieves the foreign data from the external data source, maps the foreign data to a column granule of a table, and stores the column granule in the cache. In another embodiment, the database system receives a second query that requires the foreign data. In response to determining that the foreign data is cached with the stored column granule, the database system retrieves the column granule from the cache.

    Abstract translation: 提供了缓存用于SQL处理的外部数据源的技术。 根据实施例，数据库系统从外部数据源接收需要外部数据的查询。 响应于接收到查询，数据库系统确定外部数据当前是否驻留在数据库系统的高速缓存中。 响应于确定外部当前不驻留在缓存中，数据库系统从外部数据源检索外部数据，将外部数据映射到表的列颗粒，并将列粒子存储在高速缓存中。 在另一个实施例中，数据库系统接收需要外部数据的第二查询。 响应于确定外部数据与存储的列粒子缓存，数据库系统从缓存中检索列粒子。

    Caching external data sources for SQL processing
    2.
    发明授权
    Caching external data sources for SQL processing 有权

    公开(公告)号：US09916352B2

    公开(公告)日：2018-03-13

    申请号：US15012742

    申请日：2016-02-01

    Applicant: Oracle International Corporation

    Inventor： Atif Chaudhry ,  Chandrasekharan Iyer

    IPC: G06F17/30

    CPC classification number: G06F17/30457 ,  G06F17/3048

    Abstract: Techniques are provided for caching external data sources for SQL processing. According to an embodiment, a database system receives a query that requires foreign data from an external data source. In response to receiving the query, the database system determines whether the foreign data currently resides in a cache of the database system. In response to determining that the foreign does not currently reside in the cache, the database system retrieves the foreign data from the external data source, maps the foreign data to a column granule of a table, and stores the column granule in the cache. In another embodiment, the database system receives a second query that requires the foreign data. In response to determining that the foreign data is cached with the stored column granule, the database system retrieves the column granule from the cache.

    Run-time SQL language translation
    3.
    发明授权
    Run-time SQL language translation 有权
    运行时SQL语言翻译

    公开(公告)号：US09582500B2

    公开(公告)日：2017-02-28

    申请号：US13831794

    申请日：2013-03-15

    Applicant: Oracle International Corporation

    Inventor： Barry McGillin ,  Dermot O'neill ,  Robert Pang ,  Chandrasekharan Iyer ,  Kristopher Rice

    IPC: G06F17/30 ,  G06F17/28

    CPC classification number: G06F17/2863 ,  G06F17/30427

    Abstract: A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes.

    Abstract translation: 用于数据库应用程序迁移的方法，系统和计算机程序产品。 该方法在执行外部应用程序时开始，外部应用程序发出与本地数据库系统的SQL方言不兼容的外部SQL方言的SQL语句。 在本地数据库系统的SQL解析器接收到外部SQL语句之前，该系统配置通信会话以拦截外部SQL语句; 而外国应用程序正在等待查询结果时，系统将外来方言查询语句转换为与本机数据库系统兼容的本地SQL。 该方法还执行将返回代码从本地数据库系统转换为与外部应用程序兼容的返回码。 配置数据库会话连接包括建立翻译配置文件，将外语方言SQL转换为本地SQL，并将本机SQL查询返回码转换为外来方言返回码。

    CACHING EXTERNAL DATA SOURCES FOR SQL PROCESSING
    5.
    发明申请
    CACHING EXTERNAL DATA SOURCES FOR SQL PROCESSING 审中-公开
    缓存用于SQL处理的外部数据源

    公开(公告)号：US20160147833A1

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

    申请号：US15012742

    申请日：2016-02-01

    Applicant: Oracle International Corporation

    Inventor： Atif Chaudhry ,  Chandrasekharan Iyer

    IPC: G06F17/30

    CPC classification number: G06F17/30457 ,  G06F17/3048

    Abstract: Techniques are provided for caching external data sources for SQL processing. According to an embodiment, a database system receives a query that requires foreign data from an external data source. In response to receiving the query, the database system determines whether the foreign data currently resides in a cache of the database system. In response to determining that the foreign does not currently reside in the cache, the database system retrieves the foreign data from the external data source, maps the foreign data to a column granule of a table, and stores the column granule in the cache. In another embodiment, the database system receives a second query that requires the foreign data. In response to determining that the foreign data is cached with the stored column granule, the database system retrieves the column granule from the cache.

    Abstract translation: 提供了缓存用于SQL处理的外部数据源的技术。 根据实施例，数据库系统从外部数据源接收需要外部数据的查询。 响应于接收到查询，数据库系统确定外部数据当前是否驻留在数据库系统的高速缓存中。 响应于确定外部当前不驻留在缓存中，数据库系统从外部数据源检索外部数据，将外部数据映射到表的列颗粒，并将列粒子存储在高速缓存中。 在另一个实施例中，数据库系统接收需要外部数据的第二查询。 响应于确定外部数据与存储的列粒子缓存，数据库系统从缓存中检索列粒子。

    CACHING EXTERNAL DATA SOURCES FOR SQL PROCESSING
    7.
    发明申请
    CACHING EXTERNAL DATA SOURCES FOR SQL PROCESSING 有权
    缓存用于SQL处理的外部数据源

    公开(公告)号：US20140317084A1

    公开(公告)日：2014-10-23

    申请号：US13866866

    申请日：2013-04-19

    Applicant: ORACLE INTERNATIONAL CORPORATION

    Inventor： Atif Chaudhry ,  Chandrasekharan Iyer

    IPC: G06F17/30

    CPC classification number: G06F17/30457 ,  G06F17/3048

    Abstract: Techniques are provided for caching external data sources for SQL processing. According to an embodiment, a database system receives a query that requires foreign data from an external data source. In response to receiving the query, the database system determines whether the foreign data currently resides in a cache of the database system. In response to determining that the foreign does not currently reside in the cache, the database system retrieves the foreign data from the external data source, maps the foreign data to a column granule of a table, and stores the column granule in the cache. In another embodiment, the database system receives a second query that requires the foreign data. In response to determining that the foreign data is cached with the stored column granule, the database system retrieves the column granule from the cache.

    Abstract translation: 提供了缓存用于SQL处理的外部数据源的技术。 根据实施例，数据库系统从外部数据源接收需要外部数据的查询。 响应于接收到查询，数据库系统确定外部数据当前是否驻留在数据库系统的高速缓存中。 响应于确定外部当前不驻留在缓存中，数据库系统从外部数据源检索外部数据，将外部数据映射到表的列颗粒，并将列粒子存储在高速缓存中。 在另一个实施例中，数据库系统接收需要外部数据的第二查询。 响应于确定外部数据与存储的列粒子缓存，数据库系统从缓存中检索列粒子。

    FLEXIBLE SCHEMA TABLES
    9.
    发明申请
    FLEXIBLE SCHEMA TABLES 有权

    公开(公告)号：US20210224287A1

    公开(公告)日：2021-07-22

    申请号：US16744834

    申请日：2020-01-16

    Applicant: Oracle International Corporation

    Inventor： Atif Chaudhry ,  Chandrasekharan Iyer ,  Beda Christoph Hammerschmidt

    IPC: G06F16/25 ,  G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2457

    Abstract: In an artificial neural network, integrality refers to the degree to which a neuron generates, for a given set of inputs, outputs that are near the border of the output range of a neuron. From each neural network of a pool of trained neural networks, a group of neurons with a higher integrality is selected to form a neural network tunnel (“tunnel”). The tunnel must include all input neurons and output neurons from the neural network, and some of the hidden neurons. Tunnels generated from each neural network in a pool are merged to form another neural network. The new network may then be trained.

    RUN-TIME SQL LANGUAGE TRANSLATION
    10.
    发明申请
    RUN-TIME SQL LANGUAGE TRANSLATION 有权
    运行时SQL语言翻译

    公开(公告)号：US20140280259A1

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

    申请号：US13831794

    申请日：2013-03-15

    Applicant: Oracle International Corporation

    Inventor： Barry McGillin ,  Dermot O'neill ,  Robert Pang ,  Chandrasekharan Iyer ,  Kristopher Rice

    IPC: G06F17/30 ,  G06F17/28

    CPC classification number: G06F17/2863 ,  G06F17/30427

    Abstract: A method, system, and computer program product for database application migration. The method commences upon executing a foreign application, the foreign application emits SQL statements of a foreign SQL dialect that is incompatible with the SQL dialect of a native database system. The system configures a communication session to intercept the foreign SQL statements before the foreign SQL statements are received by the SQL parser of the native database system; and, while the foreign application is waiting for query results, the system translates the foreign dialect query statements into native SQL compatible with the native database system. The method further performs translating a return code from the native database system into a return code compatible with the foreign application. Configuring the database session connection comprises establishing a translation profile to translate foreign dialect SQL into native SQL, and to translate native SQL query return codes into foreign dialect return codes.

    Abstract translation: 用于数据库应用程序迁移的方法，系统和计算机程序产品。 该方法在执行外部应用程序时开始，外部应用程序发出与本地数据库系统的SQL方言不兼容的外部SQL方言的SQL语句。 在本地数据库系统的SQL解析器接收到外部SQL语句之前，该系统配置通信会话以拦截外部SQL语句; 而外国应用程序正在等待查询结果时，系统将外来方言查询语句转换为与本机数据库系统兼容的本机SQL。 该方法还执行将返回代码从本地数据库系统转换为与外部应用程序兼容的返回码。 配置数据库会话连接包括建立翻译配置文件，将外语方言SQL转换为本地SQL，并将本机SQL查询返回码转换为外来方言返回码。

Patent Agency Ranking