Unlock instant, AI-driven research and patent intelligence for your innovation.

Systems and methods for providing access to sharded databases using cache and shard topologies

A database and fragmentation technology, applied in the field of application servers and databases, can solve the problem of increasing the size of database tables, and achieve the effect of efficient reuse

Active Publication Date: 2020-12-08
ORACLE INT CORP
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

For example, within a mobile chat system, the database tables required to process messages have grown significantly in size, such that the size of a single table can become the limiting factor in the scalability of a particular application

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Systems and methods for providing access to sharded databases using cache and shard topologies
  • Systems and methods for providing access to sharded databases using cache and shard topologies
  • Systems and methods for providing access to sharded databases using cache and shard topologies

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] As mentioned above, modern web-oriented software applications face increasing challenges in scalability, including the need to handle extremely large amounts of data, so that the capacity of a single table may become the limiting factor in the scalability of a particular application. A common approach to solving this type of problem is to use sharding, where data is presented as multiple smaller databases or shards. To provide support for such an environment, described herein, according to various embodiments, are systems and methods for providing access to sharded databases.

[0024] Sharded database

[0025] According to an embodiment, sharding is a database scaling technique that uses horizontal partitioning of data across multiple independent physical databases. The portion of data stored in each physical database is called a shard. From the perspective of a software client application, the collection of all physical databases appears as a single logical database....

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

According to an embodiment, the system enables access to a shard database. A shard-aware client application connecting to a shard database can use a connection pool (eg, Universal Connection Pool (UCP)) to store or access connections within a shared pool to different shards or chunks of the shard database. When a new connection is created, a shard topology layer can be built at the database driver layer that knows the shard key ranges of the shard's location and caches them, and enables subsequent connection requests from client applications to use the appropriate shard or fast keypath access to blocks. The connection pool and database driver can be configured to allow the client application to provide a shard key during connection checkout or at a later time; to recognize the shard key specified by the client application; and to enable Connection.

Description

[0001] Copyright Notice [0002] Portions of the disclosure of this patent document contain material that is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure as it appears in the Patent and Trademark Office's patent files or records, but otherwise reserves all copyrights in all instances. [0003] Priority claims: [0004] This application requires the application number 62 / 150,191 filed on April 20, 2015 and titled "SYSTEM ANDMETHOD FOR PROVIDING DIRECT ACCESS TO A SHARDED DATABASE"; the application number 62 / 191 filed on July 30, 2015 198,958, titled "SYSTEM AND METHOD FOR PROVIDING DIRECT ACCESS TOA SHARDED DATABASE"; and Application No. 62 / 150,188, filed April 20, 2015, titled "SYSTEM AND METHOD FOR PROVIDING ACCESS TO A SHARDED DATABASE USING A CACHEAND A SHARD TOPOLOGY", each of which is hereby incorporated by reference. technical field [0005] Embodiments of ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/2455
CPCG06F16/24557G06F16/2282G06F16/27G06F16/22G06F16/252G06F16/24552
Inventor V·赫格德J·德拉瓦瑞恩D·萨博M·迪尔曼L·诺瓦克胡维A·施瓦鲁德拉艾哈周彤I·塔拉努维
Owner ORACLE INT CORP