Oracle International Corporation

Shubha Bose

Aurosish Mishra

Juan R Loaiza

Zhen Hua Liu

Tirthankar Lahiri

Ananth Raghavan

Douglas James McMahon

Beda Christoph Hammerschmidt

Ajit Mylavarapu

Hui Joe Chang

Ying Lu

Sukhada Pendse

Sundeep Abraham

Parthasarathy Elangadu Raghunathan

Shishir Mathur

Teck Hua Lee

Shashank Gugnani

Sylvia Winters

Mukesh Jaiswal

Devendra Singh

A computer program product, system, and computer implemented method for automatic, repetitive, and gradual shrink of very large database object structures. The approach disclosed herein generally comprises an iterative best efforts approach to automatically shrink a large database object structure(s). The process may comprise identifying a large object (LOB) structure shrink event and LOB structure or LOB structure segment to be shrunk. And executing a shrink operation on the LOB structure or LOB structure segment without blocking access to other extents in the LOB structure or LOB segment structure. This process allows an extent to be shrunk and deallocated. As a result, the process can operate to continually clean a LOB structure or LOB structure segment to decrease fragmentation within the extents of the LOB structure or LOB segment structure.

Automatic, repetitive, and gradual shrink of very large database object structures

JSON Duality Views are object views that return JDV objects. JDV objects are virtual because they are not stored in a database as JSON objects. Rather, JDV objects are stored in shredded form across tables and table attributes (e.g. columns) and returned by a DBMS in response to database commands that request a JDV object from a JSON Duality View. Through JSON Duality Views, changes to the state of a JDV object may be specified at the level of a JDV object. JDV objects are updated in a database using optimistic lock.

Natively supporting JSON duality view in a database management system

A manager file system (MFS), implemented using an OS process, exposes a path in the native file system as the root of its file system (e.g., mount point). The MFS informs the OS kernel that any file system operation whose path contains the mount point as its prefix, should be handed over to the process by invoking an appropriate interface method that the process implements as part of its file system implementation. The MFS manages one or more applications and leverages the authentication mechanism of the OS to provide fined-grained access control of MFS managed applications.

Techniques for using an in-memory only file system as an interface for managing computer systems and user space file systems

A manager file system (MFS) runs as a user space file system. The MFS, implemented using an OS process, exposes a mount point as a communication endpoint to the single process. Mounting, unmounting, and changing configuration of individual database file systems (DBFSs) are done by overloading extended attributes on the mount point. The MFS services all DBFSs mounted at different mount points registered to the single process of the MFS and ensures optimal resource utilization among the DBFSs in the single process while guaranteeing resource isolation.

Scalable framework for managing concurrent accesses to database file systems

Growing community of inventors

Foster City, CA, United States of America

Shubha Bose