Multi-model access to data

• US 8,065,320 B2
• Filed: 05/16/2008
• Issued: 11/22/2011
• Est. Priority Date: 08/05/1999
• Status: Expired due to Term

• 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:
  US12/122,517
• Publication Number:
  US 20080215528A1
• Time in Patent Office: 1,285 Days
• Field of Search: 707/769, 707/812, 707/825
• US Class Current: 707/769
• 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:

in response to one or more calls made by an application to a file system API to perform a file operation on a file, generating one or more database commands; and

issuing said one or more database commands to a database server that manages said database, to cause said database server to perform said file operation on said file;

wherein the method is performed by one or more computing devices.

2. The method of claim 1 wherein the step of generating one or more database commands includes the steps of:

receiving one or more I/O commands at a protocol server configured to operate with an 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.

3. The method of claim 1 wherein the one or more calls include an open file command, and the one or more database commands include a begin transaction command and a command to resolve a pathname to locate one or more rows that contain data for said file.

4. The method of claim 1 wherein the one or more calls include a write to file command, and the one or more database commands include an update command.

5. The method of claim 1 wherein the one or more calls include a seek in file command, and the one or more database commands include an update counter command.

6. The method of claim 1 wherein the one or more calls include a read from file command, and the one or more database commands include a select command.

7. The method of claim 1 wherein the one or more calls include a lock command, and the one or more database commands include a lock row command.

8. The method of claim 1 wherein the one or more calls include a close file command, and the one or more database commands include a commit transaction command.

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

receiving, at a database server, one or more database commands that were issued in response to a call made by an application to retrieve a file;

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

wherein said data is not said file, but includes information from which said file may be constructed; and

within said database server, constructing said file from said data retrieved from said database.

10. The method of claim 9 wherein the call is made by said application to a file system API.

11. The method of claim 9 wherein the step of constructing said file includes formatting said file with a file format that is selected based on said application.

12. The method of claim 9 wherein said data is retrieved from one or more rows of one or more tables contained in said database managed by said database server.

13. A non-transitory computer-readable storage medium storing instructions, which when executed by one or more processors, cause the one or more processors to perform:

in response to one or more calls made by an application to a file system API to perform a file operation on a file, generating one or more database commands; and

issuing said one or more database commands to a database server that manages said database, to cause said database server to perform said file operation on said file.

14. The non-transitory computer-readable storage medium of claim 13, wherein generating one or more database commands includes:

receiving one or more I/O commands at a protocol server configured to operate with an 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.

15. The non-transitory computer-readable storage medium of claim 13, wherein the one or more calls include an open file command, and the one or more database commands include a begin transaction command and a command to resolve a pathname to locate one or more rows that contain data for said file.

16. The non-transitory computer-readable storage medium of claim 13, wherein the one or more calls include a write to file command, and the one or more database commands include an update command.

17. The non-transitory computer-readable storage medium of claim 13, wherein the one or more calls include a seek in file command, and the one or more database commands include an update counter command.

18. The non-transitory computer-readable storage medium of claim 13, wherein the one or more calls include a read from file command, and the one or more database commands include a select command.

19. The non-transitory computer-readable storage medium of claim 13, wherein the one or more calls include a lock command, and the one or more database commands include a lock row command.

20. The non-transitory computer-readable storage medium of claim 13, wherein the one or more calls include a close file command, and the one or more database commands include a commit transaction command.

21. A non-transitory computer-readable storage medium storing instructions, which when executed by one or more processors, cause the one or more processors to perform:

receiving, at a database server, one or more database commands that were issued in response to a call made by an application to retrieve a file;

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

wherein said data is not said file, but includes information from which said file may be constructed; and

within said database server, constructing said file from said data retrieved from said database.

22. The non-transitory computer-readable storage medium of claim 21, wherein the call is made by said application to a file system API.

23. The non-transitory computer-readable storage medium of claim 21, wherein the step of constructing said file includes formatting said file with a file format that is selected based on said application.

24. The non-transitory computer-readable storage medium of claim 21, wherein said data is retrieved from one or more rows of one or more tables contained in said database managed by said database server.