公开(公告)号：US20250094384A1

公开(公告)日：2025-03-20

申请号：US18885231

申请日：2024-09-13

Applicant: Oracle International Corporation

Inventor： Nilesh Choudhury ,  Krishnan Meiyyappan ,  Semen Ustimenko ,  Boris Erlikhman ,  Siddharth Choudhary ,  Scott Martin

IPC: G06F16/11 ,  G06F16/174 ,  G06F16/22 ,  G06F16/27

Abstract: A database-aware storage server provides instant creation of snapshots without the need to create an intermediate test master database. During the snapshot creation time, the source database stays read-write and completes ongoing reads and writes. The database-aware storage server allows creation of layers of writable snapshots in a hierarchy. All these multiple databases share common data blocks. Any new writes performed by the database post snapshot are stored in blocks of sparse files. This promotes space sharing and reduces the total amount of space used by all these related databases. The allocations for the source and all new snapshot databases share the same common pool of storage. The newly created snapshot databases can access the data store directly without going through an intermediate layer.

公开(公告)号：US20250094385A1

公开(公告)日：2025-03-20

申请号：US18885394

申请日：2024-09-13

Applicant: Oracle International Corporation

Inventor： Nilesh Choudhury ,  Juan R. Loaiza ,  Kothanda Umamageswaran ,  Jia Shi ,  Vijay Sridharan ,  Alexander Tsukerman ,  Siddharth Choudhary

IPC: G06F16/13

Abstract: Herein is an accelerated interface between a database server and a storage area network (SAN). Persistent torage being managed for a database is spread across a number of storage buckets. Global distributed storage metadata is used only for tracking the location of storage buckets on different storage servers. With this approach, a very small amount of memory is needed at a global distributed level to maintain the map. Each storage bucket can have any number of mirrored replicas for further increasing speed and reliability. A database server contains a storage bucket map in memory, and uses the map to do database online transaction processing (OLTP) I/O and smart (i.e. offloaded) database operations on storage. This allows for direct I/O between database server and storage server with lower latency and without using slow and remote middleware such as a logical unit number (LUN) metadata server on a separate network element.