Multi-model access to data

• US 7,418,435 B1
• Filed: 05/15/2000
• Issued: 08/26/2008
• Est. Priority Date: 08/05/1999
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Sedlar, Eric
• Primary Examiner(s): LE, DEBBIE M
• Application Number:
  US09/571,508
• Time in Patent Office: 3,025 Days
• Field of Search: 707 1- 3, 707/5, 707 8- 10, 707/100, 707102-1041, 707200-202, 707/204, 707/205, 710 1- 7, 710/22, 710/52, 711/100, 711/101, 711111-113, 711/117, 711/118, 711/154, 711/167, 711/200, 36518901-18905, 365/220, 365/221, 36523001-23009
• 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 accessing data stored in a database. According to one technique, an application makes one or more calls to an operating system to access a file. The operating system includes routines that implement an operating system file system. The one or more calls are made to the routines that implement the operating system file system. In response to the one or more calls, one or more database commands are issued to a database server that manages the database. The database server executes the database commands to retrieve the data from the database. The file is generated from the data, and provided to the application.

Claims

1. A method for accessing data stored in a database, the method comprising the steps of:

an application making one or more calls to an operating system to access a file;

wherein said operating system includes routines which implement an operating system file system;

wherein said one or more calls are made to said routines which implement said operating system file system;

in response to said one or more calls, issuing one or more database commands to a database server that manages said database;

said database server executing said database commands to retrieve said data from said database;

generating said file from said data; and

providing said file to said application.

2. The method of claim 1 wherein the step of providing said file to said application is performed by said routines that implement said operating system file system.

3. The method of claim 1 wherein the step of issuing one or more database commands in response to said one or more calls includes the steps of:

one or more of said routines that implement said operating system file system sending one or more I/O commands to a protocol server configured to operate with said operating system;

said protocol server translating said one or more I/O commands to one or more DB file system commands; and

issuing said one or more database commands in response to said one or more DB file system commands.

4. A computer-readable storage medium bearing instructions for accessing data stored in a database, the computer-readable medium comprising instructions for performing the steps of:

an application making one or more calls to an operating system to access a file;

wherein said operating system includes routines which implement an operating system file system;

wherein said one or more calls are made to said routines which implement said operating system file system;

in response to said one or more calls, issuing one or more database commands to a database server that manages said database;

said database server executing said database commands to retrieve said data from said database;

generating said file from said data; and

providing said file to said application.

5. The computer-readable storage medium of claim 4 wherein the step of providing said file to said application is performed by said routines that implement said operating system file system.

6. The computer-readable storage medium of claim 4 wherein the step of issuing one or more database commands in response to said one or more calls includes the steps of:

one or more of said routines that implement said operating system file system sending one or more I/O commands to a protocol server configured to operate with said operating system;

said protocol server translating said one or more I/O commands to one or more DB file system commands; and

issuing said one or more database commands in response to said one or more DB file system commands.