Oracle International Corporation

Ilya Taranov

Mark Dilman

Leonid Novak

Jean De Lavarene

Wei-Ming Hu

Vidya Hegde

Zheng Zeng

Douglas N Surber

Ashok Shivarudraiah

Tong Zhou

Wei Ming Hu

Ghazi Nourdine Benadjaoud

Stephen Ball

Saurabh Kumar Verma

Aramvalarthanathan Namachivayam

Chandra Sekhar Krishna Mahidhara

Pablo Silberkasten

Michael McMahon

Ilesh Garish

Wei Hu

In accordance with an embodiment, described herein are systems and methods for providing direct access to a sharded database. A shard director provides access by software client applications to database shards. A connection pool (e.g., a Universal Connection Pool, UCP) and database driver (e.g., a Java Database Connectivity, JDBC, component) can be configured to allow a client application to provide a shard key, either during connection checkout or at a later time; recognize shard keys specified by the client application; and enable connection by the client application to a particular shard or chunk. The approach enables efficient re-use of connection resources, and faster access to appropriate shards.

System and method for providing direct access to a sharded database

In accordance with an embodiment, the system enables access to a sharded database using a cache and a shard topology. A shard-aware client application connecting to a sharded database can use a connection pool (e.g., a Universal Connection Pool, UCP), to store or access connections to different shards or chunks of the sharded database within a shared pool. As new connections are created, a shard topology layer can be built at the database driver layer, which learns and caches shard key ranges to locations of shards. The shard topology layer enables subsequent connection requests from a client application to use a fast key path access to the appropriate shard or chunk.

System and method for providing access to a sharded database using a cache and a shard technology

Described is a system, method, and computer program product is provided that implements high-volume data ingestion in a relational database system. A middle-tier structure is provided that sits between the IoT data producers and the back-end database system. Data records are gathered together and organized at the middle tier, and groups of those records are ingested on a group-basis into the database in a manner which bypasses standard SQL engine processing.

Fast ingestion of records in a database using data locality and queuing

Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used to route database requests and process queries in a sharded database.

Request routing and query processing in a sharded database

Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described provide improvements to load distribution, organization, query processing, and schema propagation in a sharded database.

Relational database organization for sharding

Techniques are provided for creating, organizing, and maintaining a sharded database. A sharded database can be created using user-defined sharding, system-managed sharding, or composite sharding. The sharded database is implemented with relational database techniques. The techniques described can be used for organizing a sharded database using composite sharding.

Composite sharding

Growing community of inventors

Redwood City, CA, United States of America

Ilya Taranov