File system interface to a database

• US 5,937,406 A
• Filed: 01/31/1997
• Issued: 08/10/1999
• Est. Priority Date: 01/31/1997
• Status: Expired due to Term

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Informix Software, Inc. (International Business Machines Corporation)
• Inventors: Balabine, Igor V., Skier, John A., Kandasamy, Ramiah
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Alam, Hosain T.
• Application Number:
  US08/792,139
• Time in Patent Office: 921 Days
• Field of Search: 707/1-4, 707/100-104, 707/200-201
• US Class Current: 1/1
• CPC Class Codes: G06F 16/10 File systems; File servers
• 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

Information in a database is accessed with a computer system by transforming a file system request from an application into a database query and retrieving information corresponding to the database query from the database. The retrieved information is made available to the application as a file system object, for example, as a directory, a file, a link or a collection thereof.

Claims

1. A method, performed on a computer system, of accessing information in a database, the method comprising:

making information corresponding to a set of database objects available as a file system structure having one or more file system objects;

receiving from an application a file system request corresponding to the available one or more file system objects; and

transforming the file system request from the application into a database operation;

wherein making the information available as a file system structure having one or more file objects is performed transparently to the application.

2. The method of claim 1 further comprising performing the database operation on the database using a database engine.

3. The method of claim 1 further comprising retrieving information from the database in response to the database operation.

4. The method of claim 1 further comprising returning the information associated with the database object to the application as a file system object.

5. The method of claim 4 in which the returning comprises arranging the retrieved information in a format defined in an extension module.

6. The method of claim 5 further comprising displaying the formatted information on a display screen of a computer.

7. The method of claim 1 further comprising displaying information associated with the database object on a display screen of a computer.

8. The method of claim 7 in which the information associated with the database object is displayed as a graphical representation of a file system object.

9. The method of claim 1 in which the application that issued the file system request comprises a database-unaware application.

10. The method of claim 1 in which the database comprises a relational database.

11. The method of claim 1 in which the database comprises an object-relational database.

12. The method of claim 1 in which the database comprises an object-oriented database.

13. The method of claim 1 in which the transforming comprises converting the file system request into a database query.

14. The method of claim 13 in which the database query comprises an SQL-compliant query.

15. The method of claim 1 in which the transforming comprises converting the file system request into a database query based on information contained within an extension module.

16. The method of claim 1 further comprising determining whether the received file system request corresponds to information managed by a file system.

17. The method of claim 16 further comprising conveying the file system request to the file system if the file system request is determined to correspond to information managed by the file system.

18. The method of claim 16 in which the determining comprises identifying a namespace to which the file system request is directed.

19. The method of claim 16 in which the determining is performed by a method executing in a kernel address space of an operating system associated with the computer system.

20. The method of claim 16 in which the determining is performed by a method executing external to an operating system associated with the computer system.

21. The method of claim 1 in which the database object comprises a table.

22. The method of claim 1 in which the file system object comprises a directory, a file or a link.

23. The method of claim 1 in which making the information available as a file system structure comprises presenting the information as plural file system by objects in formats understandable by different applications.

24. The method of claim 1 further comprising, prior to making the information available, accessing an extension module that specifies the set of database objects or the file system structure or both.

25. A computer-based method of accessing information in a database, the method comprising:

retrieving information corresponding to a set of database objects from the database; and

presenting the retrieved information to an application as a file system structure having one or more file system objects;

accessing, prior to retrieving information, an extension module that specifies the sets of database objects or the file structure or both.

26. The method of claim 25 further comprising identifying the information to be retrieved from the database by specifying a database object from among database objects in the database.

27. The method of claim 26 in which the identifying comprises recording in an extension module information descriptive of a predetermined set of database objects.

28. The method of claim 27 in which the retrieving comprises selectively extracting information from the database based on information contained in the extension module.

29. The method of claim 27 in which the presenting comprises formatting the selectively extracted information into the file system structure having one or more file system objects based on information contained in the extension module.

30. The method of claim 25 in which the file system structure represents a hierarchial file system having directories, files, links or a combination thereof.

31. A computer-based data repository management system comprising;

a database of information organized into database objects;

a file system-based, database-unaware application program for manipulating data in the form of file system objects; and

a file system interface to the database which makes information corresponding to a set of database objects available to the file system-based application as a file system structure having one or more file system objects.

32. The system of claim 31 in which the file system-based application is database-unaware.

33. The system of claim 32 in which the database comprises an object-relational database.

34. The system of claim 32 in which the database comprises a relational database.

35. The system of claim 32 in which the database comprises an object-oriented database.

36. The system of claim 33 further comprising a database management system for managing information in the database.

37. The system of claim 31 further comprising a database engine for performing database operations on the database, the file system interface receiving file system requests and transforming the received requests into a form understandable by the database engine.

38. The system of claim 31 further comprising a module for differentiating file system requests directed to the file system from file system requests directed to the file system interface.

39. The system of claim 31 in which the file system interface further comprises an extension module that includes a file object.

40. The system of claim 39 in which the file object comprises information for converting database objects into file system objects.

41. The system of claim 31 in which the file system interface comprises a plurality of extension modules each of which includes information for converting a different set of database objects into file system objects.

42. The system of claim 31 in which the file system interface comprises a plurality of extension modules each of which includes information for converting a single database object into multiple file system objects.

43. The system of claim 31 further comprising an extension module that specifics the set of database objects or the file system structure or both.

44. A computer program, residing on a computer readable medium, for a data repository management system comprising a file system-based, database-unaware application and a database, the computer program comprising instructions to cause a computer system to perform the following operations:

receive a file system request issued by the file system-based application;

convert the file system request into a database operation;

retrieve information corresponding to a set of database objects from the database by performing the database operation on the database;

transform the retrieved information into a file system structure having one or more file system objects according to predetermined criteria; and

present the one or more file system objects to the file system-based application.

45. The software of claim 44 further comprising instructions that access an extension module that specifies the set of database objects or the file system structure or both.

46. A method, performed on a computer system, of accessing information in a database, the method comprising:

making information corresponding to a set of database objects available to a database-unaware application as a file system structure having one or more file system objects;

receiving from the database-unaware application a file system request corresponding to the available file system structure having one or more file system objects;

transforming the file system request from the database-unaware application into a database operation;

performing the database operation on the database using a database engine;

retrieving information from the database in response to the database operation; and

returning the information associated with the database object to the database-unaware application as one or more file system objects.

47. The method of claim 46 further comprising, prior to making the information available, accessing an extension module that specifies the set of database objects or the file system structure or both.

48. A computer-based method of accessing information in a database, the method comprising:

encoding a file handle with information that specifies a set of database objects in a database;

transmitting the encoded file handle in response to a file system request issued by a database-unaware application; and

decoding the received file handle to identify the set of database objects associated with the file system request.

49. The method of claim 48 in which the encoding is based on the NFS protocol.

50. The method of claim 48 in which the encoding comprises including information in the file handle that identifies an extension module that corresponds to the issued file system request.

51. The method of claim 48 in which the encoding comprises including information in the file handle that identifies a database table and row that correspond to the issued file system request.

52. The method of claim 48 in which the encoding comprises including information in the file handle that identifies metadata that corresponds to the issued file system request.

53. The method of claim 48 in which the encoding comprises including information in the file handle that points to the set of database objects that correspond to the issued file system request.

54. The method of claim 48 further comprising, prior to encoding the file handle, accessing an extension module that specifies the set of database objects.