Method, apparatus, system, and program product for attaching files and other objects to a partially replicated database

• US 7,539,704 B2
• Filed: 10/29/2003
• Issued: 05/26/2009
• Est. Priority Date: 03/03/1998
• Status: Active Grant

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Cohen, Jeffrey I., Sy Lim, Peter Siam III, Brodersen, Robert A., Chatterjee, Prashant
• Primary Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US10/696,523
• Publication Number:
  US 20040162853A1
• Time in Patent Office: 2,036 Days
• Field of Search: 707/100, 707/102, 707/101, 707/206, 707/104.1, 707/205, 707/1, 707/2, 707/200, 707/203, 707/204, 715/700, 715/513, 715/503, 705/700, 705/513, 709/230, 709/231, 709/232, 709/233, 709/234, 709/235
• US Class Current: 1/1
• CPC Class Codes: G06F 16/178 Techniques for file synchronisation in file systems
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99953 Recoverability
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

A method, system, and computer-readable medium are provided for displaying contents of a database table comprising a plurality of fields arranged in a plurality of rows and columns, selecting a field of the plurality of fields wherein the selected field comprises a reference to an attached file, and opening the attached file in response to the selecting. A row of the plurality of rows of the database table is associated with an attached file. A column of the plurality of columns comprises information about the attached files associated with the rows.

Claims

1. A method in a computing system for browsing a database table, comprising:

accessing a database table comprising a plurality of fields arranged into a plurality of rows and a plurality of columns, wherein each row of the plurality of rows is associated with an attached file, and

a column of the plurality of columns comprises information about the attached files associated with the rows wherein the information comprises one of a directory name of the associated attached file in a filesystem relative to a root directory of the filesystem and a source file name;

copying each attached file referenced in the database table from a file server providing the file system to a local storage unit, if, for each attached file, a corresponding defer indication is set to not defer a copy and a same version of the file is not already stored in the local storage unit;

selecting a selected field of the plurality of fields, wherein the selected field comprises a reference to a selected attached file; and

opening the selected attached file in response to said selecting if a copy of the selected attached file is stored in the local storage unit, wherein said opening is performed using the reference to the selected attached file.

2. The method of claim 1 wherein the database table whose contents are displayed is a relational database table.

3. The method of claim 1, further comprising constructing an index on the contents of a selected one of the columns of the database table whose contents are displayed.

4. The method of claim 1, further comprising joining the database table whose contents are displayed with a second database table.

5. The method of claim 1 wherein the database table whose contents are displayed corresponds to a business object.

6. The method of claim 1 wherein the database table whose contents are displayed corresponds to a database object, and the selected field is an attribute of the database object.

7. The method of claim 1 wherein the attached file is stored separately from the database table whose contents are displayed.

8. The method of claim 1 wherein the database table whose contents are displayed is stored in a database, and wherein the attached file is stored in a filesystem and not in the database.

9. The method of claim 1, further comprising, before opening the attached file, decompressing the attached file.

10. The method of claim 1 wherein a field in a second database table contains a reference to the same attached file as the selected field.

11. The method of claim 1, further comprising:

deleting the row of the database table containing the selected field; and

in response to deleting the row of the database table containing the selected field;

decrementing a reference count associated with the attached file, and

if the value of the decremented reference count is zero, deleting the attached file.

12. The method of claim 1 further comprising modifying the opened attached file in accordance with user input.

13. A computing system for accessing a database table comprising:

a database table comprising a plurality of fields arranged into a plurality of rows and a plurality of columns, wherein

each row of the plurality of rows is associated with an attached file, and

a column of the plurality of columns comprises information about the attached files associated with rows wherein the information comprises one of a directory name of the associated attached file in a filesystem relative to a root directory of the filesystem and a source file name;

a display device that displays contents of the database table;

a local storage device coupled to the computing system, wherein the local storage device stores each attached file referenced in the database table as copied from a file server providing the file system to the local storage device, if, for each attached file, a corresponding defer indication is set to not defer a copy and a same version of the file is not already stored in the local storage device;

an in put device via which the computing system receives user input selecting a selected field, wherein

the selected field comprises a reference to a selected attached file; and

an attachment opening subsystem that, in response to receiving the user input, uses the reference to the selected attached file to open the attached file, if a copy of the selected attached file is stored in the local storage device.

14. A computer-readable medium whose contents cause a computing system to browse a database table by:

accessing a database table comprising a plurality of fields arranged into a plurality of rows and a plurality of columns, wherein each row of the plurality of rows is associated with an attached file, and

a column of the plurality of columns comprises information about the attached files associated with the rows wherein the information comprises one of a directory name of the associated attached file in a filesystem relative to a root directory of the filesystem and a source file name;

copying each attached file referenced in the database table from a file server providing the file system to a local storage unit, if, for each attached file, a corresponding defer indication is set to not defer a copy and a same version of the file is not already stored in the local storage unit;

selecting a selected field of the plurality of fields, wherein the selected field comprises a reference to a selected attached file; and

opening the selected attached file in response to said selecting if a copy of the selected attached file is stored in the local storage unit, wherein said opening is performed using the reference to the selected attached file.

15. The computer-readable medium of claim 14 wherein the database table whose contents are displayed is a relational database table.

16. A computer-readable medium of claim 14 wherein the contents of the computer-readable medium further cause the computing system to construct an index on the contents of a selected one of the columns of the database table whose contents are displayed.

17. The computer-readable medium of claim 14 wherein the contents of the computer-readable medium further cause the computing system to join the database table whose contents are displayed with a second database table.

18. The computer-readable medium of claim 14 wherein the database table whose contents are displayed corresponds to a business object.

19. The computer-readable medium of claim 14 wherein the database table whose contents are displayed corresponds to a database object, and the selected field is an attribute of the database object.

20. The computer-readable medium of claim 14 wherein the attached object is stored separately from the database table whose contents are displayed.

21. The computer-readable medium of claim 14 wherein the database table whose contents are displayed is stored in a database, and wherein the attached object is stored in a file system and not in the database.

22. The computer-readable medium of claim 14 wherein the contents of the computer-readable medium further cause the computing system to decompress the attached object before activating the attached object.

23. The computer-readable medium of claim 14 wherein a field in a second database table contains a reference to the same attached object as the selected field.

24. The computer-readable medium of claim 14 wherein the contents of the computer-readable medium further cause the computing system to:

delete the row of the database table containing the selected field

decrement a reference count associated with the attached object; and

delete the attached object if the value of the decremented reference count is zero.