Basing directory contents on a query that is associated with a file identifier

• US 7,620,620 B1
• Filed: 05/15/2000
• Issued: 11/17/2009
• Est. Priority Date: 08/05/1999
• Status: Expired due to Fees

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Sedlar, Eric
• Primary Examiner(s): Le; Miranda
• Application Number:
  US09/571,060
• Time in Patent Office: 3,473 Days
• Field of Search: 707/1, 707/2, 707/3, 707/100, 707/101, 707/10, 707/200, 107/200
• US Class Current: 1/1
• CPC Class Codes: G06F 16/176 Support for shared access to files; File sharing support
• CPC Class Codes: G06F 16/188 Virtual file systems
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

Techniques are provided for responding to file requests received through a file system interface. According to one technique, an association is established between a file identifier and a query. A request for a file associated with the file identifier is received through the file system interface. In response to the request, the following steps are performed: executing the query to generate a set of data; generating contents of the file based on the set of data; and providing the file through the file system interface.

Claims

1. A method for responding to file requests received through a hierarchical file system interface, the method comprising the steps of:

establishing a first association between a first file identifier and a first query;

establishing a second association between a second file identifier and a second query;

receiving through said hierarchical file system interface a request for a first listing of files within a first directory associated with said first file identifier;

executing said first query to generate a first set of data;

determining the first listing of files by determining which files are within said first directory based on said first set of data, wherein determining the first listing of files comprises determining one or more directories within said first directory; and

providing said first listing of files within said first directory through said hierarchical file system interface, wherein said first listing of files comprises a second directory associated with said second file identifier;

subsequently, executing said second query to generate a second set of data;

determining the contents of said second directory by determining which files are within said second directory based on said second set of data generated by executing the second query, wherein the contents of said second directory are not known before executing said second query; and

providing a second listing of files within said second directory through said hierarchical file system interface;

wherein the first query comprises a group by clause that specifies a group by key;

wherein the first listing of files correspond to values for said group by key.

2. The method of claim 1 wherein:

the first query selects a set of database records; and

the step of providing said first listing of files within said first directory includes presenting database records from said set of database records as files within said first directory.

3. The method of claim 1 wherein:

the step of receiving through said hierarchical file system interface the request for the first listing of files within the first directory associated with said first file identifier includes the steps of;

an operating system receiving said request from an application and sending a message in response to the request; and

a protocol server receiving the message from the operating system;

the step of executing said first query to generate the first set of data includes the step of issuing a database command to a database server in response to said message; and

the step of providing said first listing of files within said first directory through said hierarchical file system interface includes the steps of;

the protocol server providing said first listing of files within said directory to said operating system; and

said operating system providing said first listing of files within said first directory to said application.

4. A computer-readable storage medium, comprising volatile or non-volatile media, storing instructions for responding to file requests received through a hierarchical file system interface, the computer-readable medium comprising instructions for performing the steps of:

establishing a first association between a first file identifier and a first query;

establishing a second association between a second file identifier and a second query;

receiving through said hierarchical file system interface a request for a first listing of files within a first directory associated with said first file identifier;

executing said first query to generate a first set of data;

generating the first listing of files by determining which files are within said first directory based on said first set of data, wherein determining the first listing of files comprises determining one or more directories within said first directory; and

providing said first listing of files within said first directory through said hierarchical file system interface, wherein said first listing of files comprises a second directory associated with said second file identifier;

subsequently, executing said second query to generate a second set of data;

determining the contents of said second directory by determining which files are within said second directory based on said second set of data obtained by executing the second query, wherein the contents of said second directory are not known prior to executing said second query; and

providing a second listing of files within said second directory through said hierarchical file system interface;

wherein the first query comprises a group by clause that specifies a group by key;

wherein the first listing of files correspond to values for said group by key.

5. The computer-readable medium of claim 4 wherein:

the first query selects a set of database records; and

the step of providing said first listing of files within said first directory includes presenting database records from said set of database records as files within said first directory.

6. The computer-readable medium of claim 4 wherein:

the step of receiving through said hierarchical file system interface the request for the listing of files within the first directory associated with said first file identifier includes the steps of;

an operating system receiving said request from an application and sending a message in response to the request; and

a protocol server receiving the message from the operating system;

the step of executing said first query to generate the first set of data includes the step of issuing a database command to a database server in response to said message; and

the step of providing said first listing of files within said first directory through said hierarchical file system interface includes the steps of;

the protocol server providing said first listing of files within said directory to said operating system; and

said operating system providing said first listing of files within said first directory to said application.