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

• US 6,732,111 B2
• Filed: 04/04/2003
• Issued: 05/04/2004
• Est. Priority Date: 03/03/1998
• Status: Active Grant

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Lim, Peter Siam Sy III, Brodersen, Robert A., Chatterjee, Prashant, Cohen, Jeffrey I.
• Primary Examiner(s): ROBINSON, GRETA LEE
• Application Number:
  US10/407,483
• Publication Number:
  US 20030191743A1
• Time in Patent Office: 396 Days
• Field of Search: 707/101, 707/100, 715/512
• 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

Attaching files and other objects in a distributed computing environment. This includes adding file attachments and non-database objects, such as, text file data, web file data, image file data, and other file attachment objects to databases. These objects may be retrieved at the convenience of a node to which the objects are sent. Visibility rules can be set to determine which attachments and objects are seen by a node. Distribution rules for an object determine whether a node must request the object or whether the node is forced to receive the object.

Claims

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

displaying the database table, the database table comprising a plurality of fields arranged into rows and columns;

receiving user input selecting a field in the database table;

receiving user input specifying a non-database file stored outside the database table to attach to the selected field; and

attaching the specified non-database file to the selected field.

2. The method of claim 1 wherein the attaching includes storing in the selected field a reference to the specified non-database file usable to retrieve the specified non-database file.

3. The method of claim 1 wherein the displayed database table is a relational database table.

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

5. The method of claim 1, further comprising joining the displayed database table with a second database table.

6. The method of claim 1, further comprising:

replicating a portion of the displayed database table containing the selected field; and

in response to replicating a portion of the displayed database table containing the selected field, replicating the attached non-database file in conjunction with the replicated portion of the displayed database table.

7. The method of claim 6 wherein the attached non-database file is replicated automatically, irrespective of further user input.

8. The method of claim 6, further comprising receiving user input specifying whether the attached non-database file is to be replicated in conjunction with the replicated portion of the displayed database table,

and wherein the attached non-database file is replicated only where the received user input specifies that the attached non-database file is to be replicated in conjunction with the replicated portion of the displayed database table.

9. The method of claim 1, wherein a portion of the fields of the displayed database are shared among a group of users,

the method further comprising sending the attached non-database file to at least a subset of the group of users.

10. A computer memory whose contents cause a computing system to augment a database table by:

displaying the database table, the database table comprising a plurality of fields arranged into rows and columns;

receiving user input selecting a field in the database table;

receiving user input specifying a non-database object stored outside the database table to attach to the selected field; and

attaching the specified non-database object to the selected field.

11. The memory of claim 10 wherein the attaching includes storing in the selected field a reference to the specified non-database file usable to retrieve the specified non-database file.

12. The memory of claim 10 wherein the displayed database table is a relational database table.

13. The memory of claim 10 wherein the contents of the memory further cause the computing system to construct an index on the contents of a selected one of the columns of the displayed database table.

14. The memory of claim 10 wherein the contents of the memory further cause the computing system to join the displayed database table with a second database table.

15. The memory of claim 10 wherein the contents of the memory further cause the computing system to:

replicate a portion of the displayed database table containing the selected field; and

replicate the attached non-database file in conjunction with the replicated portion of the displayed database table in response to replicating a portion of the displayed database table containing the selected field.

16. The memory of claim 15 wherein the attached non-database file is replicated automatically, irrespective of further user input.

17. The memory of claim 15 wherein the contents of the memory further cause the computing system to receive user input specifying whether the attached non-database file is to be replicated in conjunction with the replicated portion of the displayed database table,

and wherein the attached non-database file is replicated only where the received user input specifies that the attached non-database file is to be replicated in conjunction with the replicated portion of the displayed database table.

18. The memory of claim 10 wherein a portion of the fields of the displayed database are shared among a group of users,

wherein the contents of the memory further cause the computing system to send the attached non-database file to at least a subset of the group of users.

19. A computing system for augmenting a database table, comprising:

a display device that displays the database table, the database table comprising a plurality of fields arranged into rows and columns;

a user input subsystem that receives input selecting a field in the database table, and receives input specifying a non-database file stored outside the database table to attach to the selected field; and

an attachment subsystem that attaches the specified non-database file to the selected field.