公开(公告)号：US09569514B2

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

申请号：US14052531

申请日：2013-10-11

Applicant: Oracle International Corporation

Inventor： Edwina M. Lu ,  James W. Stamos ,  Nimar S. Arora ,  Lik Wong ,  Haobo Xu ,  Thuvan Hoang ,  Byron Wang ,  Lakshminarayanan Chidambaran

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F17/30578

Abstract: Techniques for replicating data in database systems are described. In an example embodiment, a set of changes is received at a destination database, where the set of changes has been applied at a source database and is being replicated from the source database to the destination database. The set of changes is analyzed and it is determined that the set of changes includes two or more of: a subset of row-level changes, a subset of statement-level changes, and a subset of procedure-level changes. A set of dependencies is determined at least between the changes that are included in the subsets of changes. The changes, in the subsets of changes, are assigned to two or more processing elements. The set of changes is applied to the destination database by executing the two or more processing elements in parallel to each other and based on the set of dependencies.

Abstract translation: 描述了在数据库系统中复制数据的技术。 在示例实施例中，在目的地数据库处接收一组改变，其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。 分析一组变化，并且确定该组更改包括以下两个或多个：行级更改的子集，语句级更改的子集以及过程级更改的子集。 至少在更改子集中包含的更改之间确定一组依赖关系。 更改子集中的更改分配给两个或多个处理元素。 通过相互并行并基于一组依赖关系执行两个或多个处理元件，将该组更改应用于目的地数据库。

公开(公告)号：US11947534B2

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

申请号：US16731100

申请日：2019-12-31

Applicant: Oracle International Corporation

Inventor： Sumit Sahu ,  Lakshminarayanan Chidambaran ,  Krishna Itikarlapalli ,  Srinath Krishnaswamy

IPC: G06F16/2453 ,  G06F9/48 ,  G06F9/52 ,  G06F16/27

CPC classification number: G06F16/24532 ,  G06F9/485 ,  G06F9/52 ,  G06F16/27

Abstract: A server system provided according to an aspect of the present disclosure provides a shared connection pool to parallel execution entities accessing database instances of a distributed database when processing requests. A shared connection pool implies that each pool connection of the connection pool may be used for serving different execution entities requiring access to different database instances. In an embodiment, the database instances correspond to shards together implementing a distributed database, and the parallel execution entities correspond to threads.

公开(公告)号：US09582375B2

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

申请号：US14272167

申请日：2014-05-07

Applicant: Oracle International Corporation

Inventor： Mehul Dilip Bastawala ,  Srinath Krishnaswamy ,  Nancy Reiko Ikeda ,  Lakshminarayanan Chidambaran

IPC: G06F11/00 ,  G06F11/20 ,  H04L29/06 ,  H04L29/08

CPC classification number: G06F11/20 ,  G06F11/203 ,  G06F11/2038 ,  G06F11/2046 ,  G06F2201/82 ,  G06F2201/83 ,  H04L67/1097 ,  H04L67/2814 ,  H04L67/42

Abstract: Some embodiments are directed to a method and apparatus for implementing an automatic failover mechanism for a resource. A client accesses a source through a first server using a first session. During the session, the client stores checksum information corresponding to data received via the session with the first server. When it is detected that the session between the first server and the client has failed, the client is automatically connected with second server that has access to the resource. The checksum information is transmitted from the client to the second server, where it is compared with checksum information calculated at the second server, so that a determination can be made as to whether the client can continue processing where it left off when connected to the second server.

Abstract translation: 一些实施例涉及用于实现资源的自动故障切换机制的方法和装置。 客户端通过第一个服务器使用第一个会话来访问源。 在会话期间，客户端存储与经由与第一服务器的会话接收的数据相对应的校验和信息。 当检测到第一台服务器和客户端之间的会话发生故障时，客户机将自动连接到可访问该资源的第二台服务器。 校验和信息从客户端发送到第二服务器，在第二服务器处与第二服务器计算的校验和信息进行比较，从而可以确定当连接到第二服务器时客户端是否可以继续处理 服务器。

公开(公告)号：US20140040203A1

公开(公告)日：2014-02-06

申请号：US14052531

申请日：2013-10-11

Applicant: Oracle International Corporation

Inventor： Edwina M. Lu ,  James W. Stamos ,  Nimar S. Arora ,  Lik Wong ,  Haobo Xu ,  Thuvan Hoang ,  Byron Wang ,  Lakshminarayanan Chidambaran

IPC: G06F17/30

CPC classification number: G06F17/30575 ,  G06F17/30578

Abstract: Techniques for replicating data in database systems are described. In an example embodiment, a set of changes is received at a destination database, where the set of changes has been applied at a source database and is being replicated from the source database to the destination database. The set of changes is analyzed and it is determined that the set of changes includes two or more of: a subset of row-level changes, a subset of statement-level changes, and a subset of procedure-level changes. A set of dependencies is determined at least between the changes that are included in the subsets of changes. The changes, in the subsets of changes, are assigned to two or more processing elements. The set of changes is applied to the destination database by executing the two or more processing elements in parallel to each other and based on the set of dependencies.

Abstract translation: 描述了在数据库系统中复制数据的技术。 在示例实施例中，在目的地数据库处接收一组改变，其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。 分析一组变化，并且确定该组更改包括以下两个或多个：行级更改的子集，语句级更改的子集以及过程级更改的子集。 至少在更改子集中包含的更改之间确定一组依赖关系。 更改子集中的更改分配给两个或多个处理元素。 通过相互并行并基于一组依赖关系执行两个或多个处理元件，将该组更改应用于目的地数据库。

公开(公告)号：US11907251B2

公开(公告)日：2024-02-20

申请号：US15690894

申请日：2017-08-30

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： Lakshminarayanan Chidambaran ,  Srividya Tata ,  Geeta Arora ,  Rajendra S. Pingte ,  Sneha Chandrababu ,  Ramkrishan Kanodia

IPC: G06F16/27 ,  G06F16/22

CPC classification number: G06F16/27 ,  G06F16/2219 ,  G06F16/2282

Abstract: Upon receiving a query at a local database server from a client directed to a LOB stored at a remote database server, a remote LOB locator is created comprising a local LOB locator indicating the LOB's location and a database link associated with the remote database server. The remote LOB locator is communicated to the client, which submits a request to the local database server to perform an operation directed to the LOB. The request is forwarded to the remote database server using the remote LOB locator, where the operation is performed. This mechanism is extended to work with sharded databases. Character set conversions are minimized when returning data to the client from the remote database server. Remote LOB locators may serve as bind variables for DML statements directed to local or remote tables. Local LOB locators may serve as bind variables for DML statements directed to remote tables.

公开(公告)号：US20210200765A1

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

申请号：US16731100

申请日：2019-12-31

Applicant: Oracle International Corporation

Inventor： Sumit Sahu ,  Lakshminarayanan Chidambaran ,  Krishna Itikarlapalli ,  Srinath Krishnaswamy

IPC: G06F16/2453 ,  G06F16/27 ,  G06F9/52 ,  G06F9/48

Abstract: A server system provided according to an aspect of the present disclosure provides a shared connection pool to parallel execution entities accessing database instances of a distributed database when processing requests. A shared connection pool implies that each pool connection of the connection pool may be used for serving different execution entities requiring access to different database instances. In an embodiment, the database instances correspond to shards together implementing a distributed database, and the parallel execution entities correspond to threads.

公开(公告)号：US11277435B2

公开(公告)日：2022-03-15

申请号：US15705113

申请日：2017-09-14

Applicant: Oracle International Corporation

Inventor： Krishna Mohan Itikarlapalli ,  Santanu Datta ,  Srinath Krishnaswamy ,  Lakshminarayanan Chidambaran ,  Rajesh Kumar ,  Sumit Sahu ,  Rajendra Pingte

IPC: H04L29/00 ,  H04L29/06 ,  G06F9/54 ,  G06F16/00

Abstract: Techniques described herein improve database security by reducing network attack surface area in conjunction with deep input validation. In an embodiment, a database session receives one or more network packets sent via a network, the database session including a database session state that specifies one or more database privileges. The database session reads said one or more network packets into one or more request-packet-buffers, wherein said one or more request-packet-buffers include an RPC op code for a database operation. Based on the one or more database privileges associated with the user associated with the database session, the database session determines whether the RPC op code may be executed. In response to determining that the RPC op code may be executed by said database session, the RPC op code is executed. In response to determining that the op code may not be executed by said database session, the execution of the RPC op code is prevented.

公开(公告)号：US20180077196A1

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

申请号：US15705113

申请日：2017-09-14

Applicant: Oracle International Corporation

Inventor： Krishna Mohan Itikarlapalli ,  Santanu Datta ,  Srinath Krishnaswamy ,  Lakshminarayanan Chidambaran ,  Rajesh Kumar ,  Sumit Sahu ,  Rajendra Pingte

IPC: H04L29/06

CPC classification number: H04L63/1441 ,  G06F9/547 ,  G06F16/00 ,  H04L63/0245 ,  H04L63/102

Abstract: Techniques described herein improve database security by reducing network attack surface area in conjunction with deep input validation. In an embodiment, a database session receives one or more network packets sent via a network, the database session including a database session state that specifies one or more database privileges. The database session reads said one or more network packets into one or more request-packet-buffers, wherein said one or more request-packet-buffers include an RPC op code for a database operation. Based on the one or more database privileges associated with the user associated with the database session, the database session determines whether the RPC op code may be executed. In response to determining that the RPC op code may be executed by said database session, the RPC op code is executed. In response to determining that the op code may not be executed by said database session, the execution of the RPC op code is prevented.