公开(公告)号：US10824750B2

公开(公告)日：2020-11-03

申请号：US15644505

申请日：2017-07-07

Applicant: Oracle International Corporation

Inventor： Jean De Lavarene ,  Aramvalarthanathan Namachivayam ,  Vidya Hegde ,  Saurabh Verma ,  Chandra Sekhar Krishna Mahidhara

IPC: G06F16/00 ,  G06F21/62 ,  H04L29/06 ,  G06F16/951 ,  H04L29/08

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, and support for efficient connection validation. For example, the system can support a “seconds to trust idle connection” functionality, which enables lazy validation of connections in the connection pool. The seconds to trust idle connection is the time period, expressed, for example, as a number of seconds, within a particular connection usage, that the connection pool trusts that the connection is still viable, and if so will skip a connection validation test before delivering the connection to a requesting application.

公开(公告)号：US20190138532A1

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

申请号：US16238290

申请日：2019-01-02

Applicant: Oracle International Corporation

Inventor： Terrel Co Seng ,  Saurabh Verma ,  Peter Songwen Xu

IPC: G06F16/25

Abstract: Load Plan Generator (LPG) is a BIAPPS utility for generating ODI load plans based on desired subset of fact tables for loading BIAPPS Data Warehouse. The tool simplifies the configurations process by minimizing the manual steps and configurations and provides a guided list of configurations steps and checklists. The load plan components can include different sets of load plans that will be stitched together by the load plan generator to create one load plan for loading chosen fact groups in the warehouse sourcing from different transaction systems.

公开(公告)号：US20170116295A1

公开(公告)日：2017-04-27

申请号：US15299273

申请日：2016-10-20

Applicant: Oracle International Corporation

Inventor： Dylan Wan ,  Francoise J. Lawrence ,  Justin Hyde ,  Amit Goyal ,  Saurabh Verma ,  John D. Poole

IPC: G06F17/30

CPC classification number: G06F16/254

Abstract: Systems and methods for implementing extensible attributes in ETL are disclosed. In some examples, attributes configured at a source file may be extracted from the source file. The extracted attributes can be mapped to a target column of a data warehouse table, and then a dynamic ETL script may be generated. The dynamic script may be executed to move data associated with the attributes to an appropriate new column of the data warehouse.

公开(公告)号：US12072851B2

公开(公告)日：2024-08-27

申请号：US17409203

申请日：2021-08-23

Applicant: Oracle International Corporation

Inventor： Pablo Silberkasten ,  Carol Colrain ,  Kevin Neel ,  Michael McMahon ,  Saurabh Verma ,  Jean De Lavarene

IPC: G06F15/16 ,  G06F1/30 ,  G06F16/21 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/958 ,  H04L67/1004 ,  H04L67/14 ,  H04L67/141 ,  H04L67/142 ,  H04L67/145 ,  H04L67/5681

CPC classification number: G06F16/21 ,  G06F1/30 ,  G06F16/2455 ,  G06F16/252 ,  G06F16/972 ,  H04L67/1004 ,  H04L67/14 ,  H04L67/141 ,  H04L67/142 ,  H04L67/145 ,  H04L67/5681

Abstract: In accordance with an embodiment, described herein is a system and method for connection concentration in a database environment. A transparency engine provided between client applications and a database can include a connection pool (e.g., UCP connection pool). The transparency engine can operate as a proxy engine for the database and as a session abstraction layer for the client applications, to enable the client applications to utilize features provided by the connection pool without code changes. The transparency engine can receive application connections from the client applications, and concentrate the application connections on a smaller number of database connections maintained in the connection pool.

公开(公告)号：US11151124B2

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

申请号：US16565273

申请日：2019-09-09

Applicant: Oracle International Corporation

Inventor： Lik Wong ,  Leonid Novak ,  Douglas N. Surber ,  Ilesh Garish ,  Saurabh Verma ,  Wei Ming Hu ,  Mark Dilman ,  Jean de Lavarene

IPC: G06F16/23 ,  G06F16/2455

Abstract: Techniques are provided for processing a database command in a sharded database. The processing of the database command may include generating or otherwise accessing a shard key expression, and evaluating the shard key expression to identify one or more target shards that contain data used to execute the database command.

公开(公告)号：US11120036B2

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

申请号：US15227899

申请日：2016-08-03

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jean de Lavarene ,  Yuri Dolgov ,  Vidya Hegde ,  Saurabh Verma ,  Krishna Chandra ,  Aramvalarthanathan Namachivayam

IPC: G06F16/25 ,  G06F16/2455 ,  G06F9/50 ,  H04L29/06

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, with support for efficient repurposing of connections. In accordance with an embodiment, a software application can request that a connection be provided, to enable access to the database. In response to receiving the request, the connection pool can first determine if a particular connection with the exact desired attributes already exists within the pool, but is borrowed at the time of the request. If such a connection exists, then the connection pool can wait a period of time for that particular connection to become available, referred to herein as a double-wait. Subsequently, if the particular connection is not made available within the double-wait time period, the connection pool resumes its usual operation, for example by repurposing other connections.

公开(公告)号：US10206770B2

公开(公告)日：2019-02-19

申请号：US14194472

申请日：2014-02-28

Applicant: Oracle International Corporation

Inventor： Terrel Co Seng ,  Saurabh Verma ,  Peter Songwen Xu

IPC: A61F2/00 ,  A61L27/18 ,  A61L31/06 ,  D01F6/62 ,  D01F6/84 ,  D01D5/088 ,  D01D5/16 ,  D02G3/02 ,  A61L27/48 ,  D01D5/098 ,  B29C47/00 ,  B29C71/00 ,  B29K67/00 ,  B29L31/00

Abstract: Load Plan Generator (LPG) is a BIAPPS utility for generating ODI load plans based on desired subset of fact tables for loading BIAPPS Data Warehouse. The tool simplifies the configurations process by minimizing the manual steps and configurations and provides a guided list of configurations steps and checklists. The load plan components are basically different sets of load plans that will be stitched together by the load plan generator to create one load plan for loading chosen fact groups in the warehouse sourcing from different transaction systems.

公开(公告)号：US20180039678A1

公开(公告)日：2018-02-08

申请号：US15227899

申请日：2016-08-03

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Jean de Lavarene ,  Yuri Dolgov ,  Vidya Hegde ,  Saurabh Verma ,  Krishna Chandra ,  Aramvalarthanathan Namachivayam

IPC: G06F17/30 ,  H04L29/06

CPC classification number: G06F16/25 ,  G06F9/5061 ,  G06F16/24552 ,  H04L67/42

Abstract: Described herein are systems and methods for providing access to a database in a multi-tenant environment, including the use of a connection pool, with support for efficient repurposing of connections. In accordance with an embodiment, a software application can request that a connection be provided, to enable access to the database. In response to receiving the request, the connection pool can first determine if a particular connection with the exact desired attributes already exists within the pool, but is borrowed at the time of the request. If such a connection exists, then the connection pool can wait a period of time for that particular connection to become available, referred to herein as a double-wait. Subsequently, if the particular connection is not made available within the double-wait time period, the connection pool resumes its usual operation, for example by repurposing other connections.

公开(公告)号：US20150012476A1

公开(公告)日：2015-01-08

申请号：US14194472

申请日：2014-02-28

Applicant: Oracle International Corporation

Inventor： Terrel Co Seng ,  Saurabh Verma

IPC: G06F17/30

CPC classification number: G06F17/30563

Abstract: Load Plan Generator (LPG) is a BIAPPS utility for generating ODI load plans based on desired subset of fact tables for loading BIAPPS Data Warehouse. The tool simplifies the configurations process by minimizing the manual steps and configurations and provides a guided list of configurations steps and checklists. The load plan components are basically different sets of load plans that will be stitched together by the load plan generator to create one load plan for loading chosen fact groups in the warehouse sourcing from different transaction systems.

Abstract translation: 负载计划生成器（LPG）是一种BIAPPS实用程序，用于基于用于加载BIAPPS数据仓库的事实表的所需子集生成ODI负载计划。 该工具通过最小化手动步骤和配置来简化配置过程，并提供配置步骤和清单的指导列表。 负载计划组件基本上是不同的负载计划集合，将由负载计划生成器缝合在一起，以创建一个负载计划，用于在从不同的事务系统采购的仓库中加载选定的事实组。