公开(公告)号：US10678761B2

公开(公告)日：2020-06-09

申请号：US15912861

申请日：2018-03-06

Applicant: Oracle International Corporation

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

IPC: G06F16/21 ,  G06F16/2455 ,  G06F16/958 ,  G06F1/30 ,  H04L29/08 ,  G06F16/25

Abstract: In accordance with an embodiment, described herein is a system and method for high availability and load balancing in a database environment. A transparency engine can be provided between client applications and a database, and 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 database features provided by the connection pool without code changes to the client applications. The transparency can keep track of session states, request boundaries and cursors to efficiently reuse the database connections across the client applications. The transparency engine can use the request boundaries and indicators from the database to detect safe places to drain database connections in the event of database outages.

公开(公告)号：US20170069020A1

公开(公告)日：2017-03-09

申请号：US15251992

申请日：2016-08-30

Applicant: Oracle International Corporation

Inventor： Amit Goyal ,  Saurabh Verma ,  Ramy Yanetz ,  Mahendra Kumar ,  Vijay Aggarwal

IPC: G06Q40/02

CPC classification number: G06Q40/02

Abstract: A comparative reporting system provides financial benchmarking and analytics. Integrating public reporting and enterprise software systems, raw financial information from external sources derived from a plurality of reporting sources can be ingested and processed to extract attributes and metrics. The extracted attributes and metrics can be data warehoused together with financial information from the enterprise software system. Analytics can be performed to generate a comparison between the enterprise and the plurality of reporting sources.

Abstract translation: 比较报告系统提供财务基准和分析。 集成公共报告和企业软件系统，可以摄取并处理来自多个报告源的外部源的原始财务信息，以提取属性和度量。 提取的属性和度量可以与企业软件系统的财务信息一起存储在数据库中。 可以执行分析以生成企业与多个报告来源之间的比较。

公开(公告)号：US11966409B2

公开(公告)日：2024-04-23

申请号：US16848632

申请日：2020-04-14

Applicant: Oracle International Corporation

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

IPC: G06F16/25

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.

公开(公告)号：US11609901B2

公开(公告)日：2023-03-21

申请号：US17473525

申请日：2021-09-13

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.

公开(公告)号：US20210073208A1

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

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

公开(公告)号：US10909088B2

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

申请号：US15912861

申请日：2018-03-06

Applicant: Oracle International Corporation

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

IPC: G06F16/21 ,  G06F16/2455 ,  G06F16/958 ,  G06F1/30 ,  H04L29/08 ,  G06F16/25

Abstract: In accordance with an embodiment, described herein is a system and method for high availability and load balancing in a database environment. A transparency engine can be provided between client applications and a database, and 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 database features provided by the connection pool without code changes to the client applications. The transparency can keep track of session states, request boundaries and cursors to efficiently reuse the database connections across the client applications. The transparency engine can use the request boundaries and indicators from the database to detect safe places to drain database connections in the event of database outages.

公开(公告)号：US20240232216A1

公开(公告)日：2024-07-11

申请号：US18614571

申请日：2024-03-22

Applicant: Oracle International Corporation

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

IPC: G06F16/25

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.

公开(公告)号：US11789964B2

公开(公告)日：2023-10-17

申请号：US16238290

申请日：2019-01-02

Applicant: Oracle International Corporation

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

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

CPC classification number: G06F16/254 ,  A61F2/0063 ,  A61L27/18 ,  A61L27/48 ,  A61L31/06 ,  B29C48/00 ,  B29C48/02 ,  B29C71/0072 ,  D01D5/088 ,  D01D5/098 ,  D01D5/16 ,  D01F6/62 ,  D01F6/625 ,  D01F6/84 ,  D02G3/02 ,  A61F2002/0068 ,  B29K2067/00 ,  B29L2031/753 ,  Y10T428/1362 ,  Y10T428/1369 ,  Y10T428/249922 ,  Y10T442/10 ,  Y10T442/183 ,  Y10T442/184 ,  Y10T442/2525 ,  A61L27/18 ,  C08L67/04 ,  A61L31/06 ,  C08L67/04

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.

公开(公告)号：US11100058B2

公开(公告)日：2021-08-24

申请号：US15912856

申请日：2018-03-06

Applicant: Oracle International Corporation

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

IPC: G06F15/16 ,  G06F16/21 ,  H04L29/08 ,  G06F16/958 ,  G06F16/25 ,  G06F1/30 ,  G06F16/2455

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.

公开(公告)号：US10909211B2

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

申请号：US15644504

申请日：2017-07-07

Applicant: Oracle International Corporation

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

IPC: G06F16/00 ,  G06F16/958 ,  G06F16/25 ,  G06F16/28 ,  G06F16/21 ,  G06F16/2453

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 limiting the maximum number of connections per tenant or per database shard. For example, when a tenant is associated with a service, configuring a maximum connections per service limit on a shared connection pool indicates to the system that the shared pool should not repurpose existing connections, or create new connections for a service, if the maximum connections per service limit has been reached for that particular service. The system can also maintain a parameter that keeps track of the total number of connections created to each shard of a sharded database. The connection pool can scan the sharded database topology, to determine which shard or sharded instance can satisfy the request, without exceeding the maximum limit for that shard.