-
1.
公开(公告)号:US12265546B2
公开(公告)日:2025-04-01
申请号:US17180385
申请日:2021-02-19
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Saurabh Verma , Balaji Krishnan
IPC: G06F16/25 , G06F16/2458 , G06F16/28 , G06N5/022
Abstract: In accordance with an embodiment, described herein are systems and methods for automatic generation of business intelligence (BI) data models using data introspection and curation, as may be used, for example, with enterprise resource planning (ERP) or other enterprise computing or data analytics environments. The described approach uses a combination of manually-curated artifacts, and automatic generation of a model through data introspection, of a source data environment, to derive a target BI data model. For example, a pipeline generator framework can evaluate the dimensionality of a transaction type, degenerate attributes, and application measures; and use the output of this process to create an output target model and pipeline or load plan. The systems and methods described herein provide a technical improvement in the building of new subject areas or a BI data model within much shorter periods of time.
-
2.
公开(公告)号:US11290540B2
公开(公告)日:2022-03-29
申请号:US15644508
申请日:2017-07-07
Applicant: Oracle International Corporation
Inventor: Jean De Lavarene , Vidya Hegde , Saurabh Verma , Chandra Sekhar Krishna Mahidhara , Aramvalarthanathan Namachivayam
IPC: H04L29/08 , H04L67/141 , H04L67/01
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 server-side connection pool multiple tagging. For example, the system can provide a capability to associate multiple connection properties with a particular server-side connection in, e.g., an Oracle Database Resident Connection Pooling (DRCP) environment; look up a connection with one or multiple properties; and provide information about a returned connection so that a requesting application can review the properties associated with the returned connection, in order to determine how best to “fix-up” or otherwise use that connection.
-
3.
公开(公告)号:US20210406252A1
公开(公告)日:2021-12-30
申请号: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.
-
4.
公开(公告)号:US10742748B2
公开(公告)日:2020-08-11
申请号:US15644502
申请日:2017-07-07
Applicant: Oracle International Corporation
Inventor: Jean De Lavarene , Saurabh Verma , Vidya Hegde , Chandra Sekhar Krishna Mahidhara , Aramvalarthanathan Namachivayam
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 live addition of a tenant. When a pluggable database (PDB), for use by a tenant, is added to a multi-tenant database, it can generate an event to notify the connection pool. The connection pool environment consumes this PDB-add event, and dynamically configures a new tenant to access the shared pool. Since the new tenant addition is based on receipt of an event from the database, the connection pool does not require manual configuration for that tenant. Once a tenant is added, it can borrow connections from the pool in the same manner as existing tenants, and can also share existing pool properties, such as, for example a maximum pool size, or maximum number of connections per tenant.
-
公开(公告)号:US20190075170A1
公开(公告)日:2019-03-07
申请号:US15912861
申请日:2018-03-06
Applicant: Oracle International Corporation
Inventor: Carol Colrain , Kevin Neel , Pablo Silberkasten , Michael McMahon , Saurabh Verma , Douglas Surber , Jean De Lavarene
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.
-
6.
公开(公告)号:US20180039628A1
公开(公告)日:2018-02-08
申请号:US15227897
申请日:2016-08-03
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Jean de Lavarene , Saurabh Verma , Vidya Hegde , Krishna Chandra , Aramvalarthanathan Namachivayam
CPC classification number: G06F16/214 , G06F9/5061 , H04L67/1002 , H04L67/148 , H04L67/16
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 dynamic relocation of tenants. In accordance with an embodiment, a software application can obtain a connection from the connection pool, on behalf of a tenant, which enables the software application or tenant to access the database. A relocation process enables a tenant which is associated with a multi-tenant or other client application, to be relocated within the database environment, for example across a plurality of container databases, with near-zero downtime to the client application, including managing the draining of existing connections, and the migrating of new connections, without requiring changes to the underlying application.
-
公开(公告)号:US20220310268A1
公开(公告)日:2022-09-29
申请号:US17214659
申请日:2021-03-26
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Saurabh Verma , Shailendra Mishra , Rebecca Laborde
Abstract: In accordance with an embodiment, described herein are systems and methods for use of data analytics in medical applications, including the use of pattern detection in assessing self- reported participant symptom data indicative of possible illness. A patient monitoring system or service can be provided, for example at an analytics cloud environment. The system is adapted to capture self-reported participant symptom data from individual participants, and track changes in their reported symptoms over time. The system performs data queries against the received participant symptom data, to identify patterns in the data indicative of participant clusters and episodes indicative of possible illness, which information can then be provided, for example, to a medical organization system and used to respond to investigative queries. The approach can accommodate voluntary and/or intermittent reporting, including sparsity or gaps in the input stream of symptom data received from the participants.
-
8.
公开(公告)号:US20210173846A1
公开(公告)日:2021-06-10
申请号:US17180385
申请日:2021-02-19
Applicant: ORACLE INTERNATIONAL CORPORATION
Inventor: Saurabh Verma , Balaji Krishnan
IPC: G06F16/25 , G06F16/28 , G06F16/2458 , G06N5/02
Abstract: In accordance with an embodiment, described herein are systems and methods for automatic generation of business intelligence (BI) data models using data introspection and curation, as may be used, for example, with enterprise resource planning (ERP) or other enterprise computing or data analytics environments. The described approach uses a combination of manually-curated artifacts, and automatic generation of a model through data introspection, of a source data environment, to derive a target BI data model. For example, a pipeline generator framework can evaluate the dimensionality of a transaction type, degenerate attributes, and application measures; and use the output of this process to create an output target model and pipeline or load plan. The systems and methods described herein provide a technical improvement in the building of new subject areas or a BI data model within much shorter periods of time.
-
公开(公告)号:US10915506B2
公开(公告)日:2021-02-09
申请号:US15912866
申请日:2018-03-06
Applicant: Oracle International Corporation
Inventor: Pablo Silberkasten , 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 row buffering 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 engine can maintain a plurality of local row buffers to store rows fetched from a database. The local buffers can be filled by rows pre-fetched from the database. When a client application requests rows from the database, the transparency engine can first check whether the rows exist in a local buffer. If the rows are present in the local buffer, the transparency engine sends the rows to the requesting client application, without going to the database.
-
公开(公告)号:US20200272635A1
公开(公告)日:2020-08-27
申请号: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
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.
-
-
-
-
-
-
-
-
-