US 12,001,406 B2
Method and system to implement directory reads for a database file system
Margaret Susairaj, Sugar Land, TX (US); Jose Antonio Lasa Gutierrez, Zapopan (MX); and Sumanta Chatterjee, Menlo Park, CA (US)
Assigned to Oracle International Corporation, Redwood Shores, CA (US)
Filed by Oracle International Corporation, Redwood Shores, CA (US)
Filed on Jul. 29, 2022, as Appl. No. 17/877,689.
Prior Publication US 2024/0037074 A1, Feb. 1, 2024
Int. Cl. G06F 17/00 (2019.01); G06F 7/00 (2006.01); G06F 16/172 (2019.01); G06F 16/185 (2019.01)
CPC G06F 16/185 (2019.01) [G06F 16/172 (2019.01)] 25 Claims
OG exemplary drawing
 
1. A method, comprising:
implementing a database file system (DBFS) where a plurality of files in a file system are stored in a database backend;
receiving a first file system command to access a directory in the DBFS, the directory having multiple files of the plurality of files in the file system;
constructing a node tree for the multiple files in the directory in response to the first file system command, wherein the node tree is constructed based on a table for the directory in the database backend having columns that hold metadata associated with the files;
loading file contents for the files in the directory into a cache in response to the first file system command to access the directory, wherein the node tree references the file contents for the files in the cache;
receiving a second file system command to access a file of the multiple files in the directory; and
accessing, in response to the second file system command, the previously constructed node tree to identify file contents of the file in the cache based on a reference to the file contents for the file in the node tree.