Efficiently storing indented threads in a threaded discussion application

• US 7,031,977 B2
• Filed: 02/28/2002
• Issued: 04/18/2006
• Est. Priority Date: 02/28/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Plumtree Software, Inc. (Oracle Corporation)
• Inventors: Frieden, Kurt, Srikhanta, Prasanna
• Primary Examiner(s): Ali, Mohammad
• Assistant Examiner(s): PANNALA, SATHYANARAYA R
• Application Number:
  US10/085,780
• Publication Number:
  US 20030163446A1
• Time in Patent Office: 1,510 Days
• Field of Search: 707/7, 707100-102, 707/200
• US Class Current: 1/1
• CPC Class Codes: G06F 16/30 of unstructured textual data document management systems G06F16/93
• CPC Class Codes: G06F 16/81 Indexing, e.g. XML tags; Data structures therefor; Storage structures
• CPC Class Codes: G06Q 10/109 Time management, e.g. calendars, reminders, meetings or time accounting
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99944 Object-oriented database structure
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

Abstract

A hierarchical set of records has multiple hierarchical levels and depths. Each of the records has a tag that is unique within the hierarchical set of records. A method for retrieving a record includes identifying one of the records in the hierarchical set and modifying the tag, thereby producing a key. The hierarchical set of records is indexed only once. A record is selected and retrieved based on the indexing which applies the key to the hierarchical set of the records.

Claims

1. A computer implemented method for retrieving a record in a hierarchical set of records having a plurality of hierarchical levels and a plurality of hierarchical depths, each of the records having a tag that is unique within the hierarchical set of the records, the method comprising:

identifying one of the records in the hierarchical set of records;

selecting a second record by indicating a relational characteristic of the identified record that comprises a depth relationship or a level relationship or both;

modifying the tag based on the relational characteristic and a predetermined numeric mapping of related records, thereby producing a key corresponding to the second record that is related to the identified record by the relational characteristic;

indexing the hierarchical set of the records only once, thereby selecting the second record within the hierarchical set of records, wherein indexing the hierarchical set of records only once comprises applying the key to the hierarchical set of records; and

retrieving the selected records, and

wherein the key comprises a second tag uniquely identifying the second record,

wherein applying comprises selecting those of the records in the hierarchical set of the records having a tag that matches the key, and

wherein;

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels; and

modifying the tag comprises;

selecting at least one of the digits according to the command from the user; and

changing the value of the selected digits according to the command from the user.

2. The method of claim 1, wherein identifying one of the records comprises:

receiving a selection of the one of the records from a user; and

receiving a command from the user; and

wherein

modifying the tag is based on the command from the user.

3. The method of claim 2, wherein each of the records has one or more fields, further comprising:

displaying a field of each of the retrieved records on a display, wherein the position of each of the fields on the display represents the hierarchical depth and hierarchical level of the corresponding one of the retrieved records.

4. The method of claim 1, wherein:

each tag is a number having a plurality of digits;

the position of each of the digits representS one of the hierarchical depths;

the command from the user requests retrieving the children of the identified record; and

modifying the tag comprises;

selecting the digit corresponding to the hierarchical depth of the identified record; and

setting the value of each digit corresponding to a hierarchical depth below the hierarchical depth corresponding to the selected digit to a wildcard value.

5. The method of claim 1, wherein:

each tag is a number having a plurality of digits;

the position of each of the digits representS one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels;

the command from the user requests retrieving the parent of the identified record; and

modifying the tag comprises;

selecting the digit corresponding to the hierarchical depth of the identified record; and

setting the value of the selected digit to a null value.

6. The method of claim 1, wherein each of the records represents one of a message and a folder.

7. A computer implemented method for selecting a record in a hierarchical set of records having a plurality of hierarchical levels and a plurality of hierarchical depths, each of the records having a tag that is unique within the hierarchical set of records, the method comprising:

identifying one of the records in the hierarchical set of records;

selecting a second record by indicating a relational characteristic of the identified record that comprises a depth relationship or a level relationship or both;

modifying the tag based on the relational characteristic and a predetermined numeric mapping of related records;

indexing the hierarchical set of records only once, thereby selecting the second record within the hierarchical set of records, wherein indexing the hierarchical set of records only once comprises applying the modified tag to the hierarchical set of; and

retrieving the selected records, and

wherein the key comprises a second tag uniguely identifying the second record.

8. The method of claim 7, wherein:

each tag includes a plurality of digits;

the position of each of the digits represents one of the hierarchical depths; and

the value of each of the digits represents one of the hierarchical levels.

9. The method of claim 7, wherein applying comprises:

selecting those of the records in the hierarchical set of the records having a tag that matches the key.

10. At least one computer programmed to execute a process for retrieving records in a hierarchical set of the records having a plurality of hierarchical levels and a plurality of hierarchical depths, each of the records having a tag that is unique within the hierarchical set of the records, the process comprising:

identifying one of the records in the hierarchical set of records;

selecting a second record by indicating a relational characteristic of the identified record that comprises a depth relationship or a level relationship or both;

modifying the tag based on the relational characteristic and a predetermined numeric mapping of related records, thereby producing a key corresponding to the second record that is related to the identified record by the relational characteristic;

indexing the hierarchical set of the records only once, thereby selecting the second record within the hierarchical set of records, wherein indexing the hierarchical set of records only once comprises applying the key to the hierarchical set of records; and

retrieving the selected records, and

wherein the key comprises a second tag uniquely identifying the second record

wherein applying comprises selecting those of the records in the hierarchical set of the records having a tag that matches the key, and

wherein;

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels; and

modifying the tag comprises;

selecting at least one of the digits according to the command from the user; and

changing the value of the selected digits according to the command from the user.

11. The computer of claim 10, wherein identifying one of the records comprises:

receiving a selection of the one of the records from a user; and

receiving a command from the user; and

wherein

modifying the tag is based on the command from the user.

12. The computer of claim 11, wherein each of the records has one or more fields, and the process further comprises:

displaying a field of each of the retrieved records on a display, wherein the position of each of the fields on the display represents the hierarchical depth and hierarchical level of the corresponding one of the retrieved records.

13. The computer of claim 10, wherein:

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels;

the command from the user requests retrieving the children of the identified record; and

modifying the tag comprises;

selecting the digit corresponding to the hierarchical depth of the identified record; and

setting the value of each digit corresponding to a hierarchical depth below the hierarchical depth corresponding to the selected digit to a wildcard value.

14. The computer of claim 10, wherein:

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels;

the command from the user requests retrieving the parent of the identified record; and

modifying the tag comprises;

selecting the digit corresponding to the hierarchical depth of the identified record; and

setting the value of the selected digit to a null value.

15. The computer of claim 10, wherein each of the records represents one of a message and a folder.

16. At least one computer programmed to execute a process for selecting records in a hierarchical set of the records having a plurality of hierarchical levels and a plurality of hierarchical depths, each of the records having a tag that is unique within the hierarchical set of the records, the process comprising:

identifying one of the records in the hierarchical set of records;

selecting a second record by indicating a relational characteristic of the identified record that comprises a depth relationship or a level relationship or both;

modifying the tag based on the relational characteristic and a predetermined numeric mapping of related records;

indexing the hierarchical set of records only once, thereby selecting the second record within the hierarchical set of records, wherein indexing the hierarchical set of records only once comprises applying the modified tag to the hierarchical set of records; and

retrieving the selected records, and

wherein the key comprises a second tap uniquely identifying the second record.

17. The computer of claim 16, wherein:

each tag includes a plurality of digits;

the position of each of the digits represents one of the hierarchical depths; and

the value of each of the digits represents one of the hierarchical levels.

18. The computer of claim 16, wherein applying comprises:

selecting those of the records in the hierarchical set of the records having a tag that matches the modified tag.

19. An apparatus for retrieving records in a hierarchical set of the records having a plurality of hierarchical levels and a plurality of hierarchical depths, each of the records having a tag that is unique within the hierarchical set of the records, the apparatus comprising:

means for identifying one of the records in the hierarchical set of records;

means for selecting a second record by indicating a relational characteristic of the identified record, wherein the relational characteristic comprises a depth relationship or a level relationship or both;

means for modifying the tag based on the relational characteristic and a predetermined numeric mapping of related records, thereby producing a key corresponding to the second record that is related to the identified record by the relational characteristic;

means for indexing the hierarchical set of the records only once, thereby selecting the second record within the hierarchical set of records, wherein means for indexing the hierarchical set of the records only once comprises means for applying the key to the hierarchical set of records; and

means for retrieving the selected records, and

wherein the key comprises a second tag uniquely identifying the second record

wherein means for applying comprises means for selecting those of the records in the hierarchical set of the records having a tag that matches the key, and

wherein;

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels; and

means for modifying the tag comprises;

means for selecting at least one of the digits according to the command from the user; and

means for changing the value of the selected digits according to the command from the user.

20. The apparatus of claim 19, wherein means identifying one of the records comprises:

means for receiving a selection of the one of the records from a user; and

means for receiving a command from the user; and

wherein

means for modifying the tag is based on the command from the user.

21. The apparatus of claim 20, wherein each of the records has one or more fields, further comprising:

means for displaying a field of each of the retrieved records on a display, wherein the position of each of the fields on the display represents the hierarchical depth and hierarchical level of the corresponding one of the retrieved records.

22. The apparatus of claim 19, wherein:

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels;

the command from the user requests retrieving the children of the identified record; and

means for modifying the tag comprises;

means for selecting the digit corresponding to the hierarchical depth of the identified record; and

means for setting the value of each digit corresponding to a hierarchical depth below the hierarchical depth corresponding to the selected digit to a wildcard value.

23. The apparatus of claim 19, wherein:

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels;

the command from the user requests retrieving the parent of the identified records; and

means for modifying the tag comprises;

means for selecting the digit corresponding to the hierarchical depth of the identified record; and

means for setting the value of the selected digit to a null value.

24. The apparatus of claim 19, wherein each of the records represents one of a message and a folder.

25. An apparatus for selecting records in a hierarchical set of the records having a plurality of hierarchical levels and a plurality of hierarchical depths, each of the records having a tag that is unique within the hierarchical set of the records, the apparatus comprising:

means for identifying one of the records in the hierarchical set of the records;

means for selecting a second record by indicating a relational characteristic of the identified record, wherein the relational characteristic comprises a depth relationship or a level relationship or both;

means for modifying the tag based on the relational characteristic and a predetermined numeric mapping of related records;

means for indexing the hierarchical set of the records only once, thereby selecting the records within the hierarchical set of the records, wherein indexing the hierarchical set of the records only once comprises applying the modified tag to the hierarchical set of the record; and

means for retrieving the selected records, and

wherein the key comprises a second tag uniquely identifying the second record.

26. The apparatus of claim 25, wherein:

each tag includes a plurality of digits;

the position of each of the digits represents one of the hierarchical depths; and

the value of each of the digits represents one of the hierarchical levels.

27. The apparatus of claim 25, wherein means for applying comprises:

means for selecting those of the records in the hierarchical set of the records having a tag that matches the modified tag.

28. Computer-readable storage media embodying instructions executable by a computer to perform a method for retrieving records in a hierarchical set of the records having a plurality of hierarchical levels and a plurality of hierarchical depths, each of the records having a tag that is unique within the hierarchical set of the records, the method comprising:

identifying one of the records in the hierarchical set of the records;

selecting a second record by indicating a relational characteristic of the identified record that comprises a depth relationship or a level relationship or both;

modifying the tag based on the relational characteristic and a predetermined numeric mapping of related records, thereby producing a key corresponding to the second record that is related to the identified record by the relational characteristic;

indexing the hierarchical set of the records only once, thereby selecting the second record within the hierarchical set of records, wherein indexing the hierarchical set of records only once comprises applying the key to the hierarchical set of records; and

retrieving the selected records, and

wherein the key comprises a second tag uniquely identifying the second record

wherein applying comprises selecting those of the records in the hierarchical set of the records having a tag that matches the key, and

wherein;

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels; and

modifying the tag comprises;

selecting at least one of the digits according to the command from the user; and

changing the value of the selected digits according to the command from the user.

29. The media of claim 28, wherein identifying one of the records comprises:

receiving a selection of the one of the records from a user; and

receiving a command from the user; and

wherein

modifying the tag is based on the command from the user.

30. The media of claim 29, wherein each of the records has one or more fields, the method further comprising:

displaying a field of each of the retrieved records on a display, wherein the position of each of the fields on the display represents the hierarchical depth and hierarchical level of the corresponding one of the retrieved records.

31. The media of claim 28, wherein:

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels;

the command from the user requests retrieving the children of the identified record; and

modifying the tag comprises;

selecting the digit corresponding to the hierarchical depth of the identified record; and

setting the value of each digit corresponding to a hierarchical depth below the hierarchical depth corresponding to the selected digit to a wildcard value.

32. The media of claim 28, wherein:

each tag is a number having a plurality of digits;

the position of each of the digits represents one of the hierarchical depths;

the value of each of the digits represents one of the hierarchical levels;

the command from the user requests retrieving the parent of the identified record; and

modifying the tag comprises;

selecting the digit corresponding to the hierarchical depth of the identified record; and

setting the value of the selected digit to a null value.

33. The media of claim 28, wherein each of the records represents one of a message and a folder.

34. Computer-readable storage media embodying instructions executable by a computer to perform a method for selecting records in a hierarchical set of the records having a plurality of hierarchical levels and a plurality of hierarchical depths, each of the records having a tag that is unique within the hierarchical set of the records, the method comprising:

identifying one of the records in the hierarchical set of records;

selecting a second record by indicating a relational characteristic of the identified record that comprises a depth relationship or a level relationship or both;

modifying the tag based on the relational characteristic and a predetermined numeric mapping of related records;

indexing the hierarchical set of records only once, thereby selecting the second record within the hierarchical set of records, wherein indexing the hierarchical set of records only once comprises applying the modified tag to the hierarchical set of records; and

retrieving the selected records, and

wherein the key comprises a second tag uniquely identifying the second record.

35. The media of claim 34, wherein:

each tag includes a plurality of digits;

the position of each of the digits represents one of the hierarchical depths; and

the value of each of the digits represents one of the hierarchical levels.

36. The media of claim 34, wherein applying comprises:

selecting those of the records in the hierarchical set of the records having a tag that matches the key.