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

公开(公告)号：US11151134B2

公开(公告)日：2021-10-19

申请号：US16007777

申请日：2018-06-13

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Atif Chaudhry ,  Lei Sheng ,  Shashaanka Agrawal

IPC: G06F16/00 ,  G06F16/2453

Abstract: Described is an approach for performing an efficient processing of table functions/polymorphic table functions. The approach does not create additional cursors for processing a table or polymorphic table function invoked within a SQL statement. Instead, the approach handles the SQL statement that invokes the table/polymorphic table function as a single cursor.

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

公开(公告)号：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处理的外部数据源的技术。 根据实施例，数据库系统从外部数据源接收需要外部数据的查询。 响应于接收到查询，数据库系统确定外部数据当前是否驻留在数据库系统的高速缓存中。 响应于确定外部当前不驻留在缓存中，数据库系统从外部数据源检索外部数据，将外部数据映射到表的列颗粒，并将列粒子存储在高速缓存中。 在另一个实施例中，数据库系统接收需要外部数据的第二查询。 响应于确定外部数据与存储的列粒子缓存，数据库系统从缓存中检索列粒子。

公开(公告)号：US20190102426A1

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

申请号：US16007777

申请日：2018-06-13

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Atif Chaudhry ,  Lei Sheng ,  Shashaanka Agrawal

IPC: G06F17/30

Abstract: Described is an approach for performing an efficient processing of table functions/polymorphic table functions. The approach does not create additional cursors for processing a table or polymorphic table function invoked within a SQL statement. Instead, the approach handles the SQL statement that invokes the table/polymorphic table function as a single cursor.

公开(公告)号：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处理的外部数据源的技术。 根据实施例，数据库系统从外部数据源接收需要外部数据的查询。 响应于接收到查询，数据库系统确定外部数据当前是否驻留在数据库系统的高速缓存中。 响应于确定外部当前不驻留在缓存中，数据库系统从外部数据源检索外部数据，将外部数据映射到表的列颗粒，并将列粒子存储在高速缓存中。 在另一个实施例中，数据库系统接收需要外部数据的第二查询。 响应于确定外部数据与存储的列粒子缓存，数据库系统从缓存中检索列粒子。

公开(公告)号：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处理的外部数据源的技术。 根据实施例，数据库系统从外部数据源接收需要外部数据的查询。 响应于接收到查询，数据库系统确定外部数据当前是否驻留在数据库系统的高速缓存中。 响应于确定外部当前不驻留在缓存中，数据库系统从外部数据源检索外部数据，将外部数据映射到表的列颗粒，并将列粒子存储在高速缓存中。 在另一个实施例中，数据库系统接收需要外部数据的第二查询。 响应于确定外部数据与存储的列粒子缓存，数据库系统从缓存中检索列粒子。