Efficiently storing indented threads in a threaded discussion application

• US 7,653,660 B2
• Filed: 12/29/2006
• Issued: 01/26/2010
• Est. Priority Date: 02/28/2002
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: BEA Systems Incorporated (Oracle Corporation)
• Inventors: Frieden, Kurt, Srikhanta, Prasanna
• Primary Examiner(s): PANNALA, SATHYANARAYA R
• Application Number:
  US11/617,727
• Publication Number:
  US 20070106635A1
• Time in Patent Office: 1,124 Days
• Field of Search: None
• 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 method, apparatus, and computer-readable media 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, comprises identifying one of the records in the hierarchical set of the records; modifying the tag, thereby producing a key; indexing the hierarchical set of the records only once, thereby selecting one or more of the records within the hierarchical set of the records, wherein indexing the hierarchical set of the records only once comprises applying the key to the hierarchical set of the records; and retrieving the selected records.

Claims

1. A method of tagging a message or container in a hierarchical data set having a plurality of hierarchical levels and a plurality of hierarchical depths, the method comprising:

presenting with a data storage system a first message of an indented threaded discussion;

determining with the data storage system a hierarchical level of the first message within the indented threaded discussion;

determining with the data storage system a hierarchical depth of the first message within the indented threaded discussion;

assigning with the data storage system a first tag to the first message, comprising;

determining the immediate parent of the first message;

selecting a parent tag of the immediate parent of the first message, wherein the parent tag is a number having multiple digits each representing one of the hierarchical depths of the hierarchical data set;

selecting a digit of the selected parent tag that represents the hierarchical depth of the first message within the indented threaded discussion; and

assigning a value to the selected digit, the value representing the hierarchical level of the first message within the indented threaded discussion; and

storing an entry in a table of a database with the data storage system, said table entry including the assigned first tag, the selected digit representing the hierarchical depth within the indented threaded discussion, the assigned value representing the hierarchical level within the indented threaded discussion, and the first message.

2. The method of claim 1, further comprising:

receiving with the data storage system a command from a user requesting replying to the first message;

selecting the digit corresponding to the hierarchical depth immediately below the hierarchical depth of the first message with the data storage system;

incrementing the value of the selected digit with the data storage system, thereby producing a key; and

indexing the database with the data storage system by adding a record to the database having the key as its tag and corresponding to a reply message from the user.

3. The method of claim 1, wherein assigning a value to the selected digit comprises:

determining the number of children of the immediate parent of the first message that have already been tagged;

incrementing the number of children to obtain an incremented number; and

setting the value of the selected digit to equal the value of the incremented number.

4. At least one computer including a processor programmed to execute a process for tagging a message in a hierarchical data set having a plurality of hierarchical levels and a plurality of hierarchical depths, the process comprising:

presenting a first message of an indented threaded discussion;

determining a hierarchical level of the first message within the indented threaded discussion;

determining a hierarchical depth of the first message within the indented threaded discussion;

assigning a first tag to the first message, comprising;

determining the immediate parent of the first message;

selecting a parent tag of the immediate parent of the first message, wherein the parent tag is a number having multiple digits each representing one of the hierarchical depths of the hierarchical data set;

selecting a digit of the selected parent tag that represents the hierarchical depth of the first message within the indented threaded discussion; and

assigning a value to the selected digit, the value representing the hierarchical level of the first message within the indented threaded discussion; and

storing an entry in a table of a database, said table entry including the assigned first tag, the selected digit representing the hierarchical depth within the indented threaded discussion, the assigned value representing the hierarchical level within the indented threaded discussion, and the first message.

5. The at least one computer of claim 4, the process further comprising:

receiving a command from a user requesting replying to the first message;

selecting the digit corresponding to the hierarchical depth immediately below the hierarchical depth of the first message;

incrementing the value of the selected digit, thereby producing a key; and

indexing the database by adding a record to the database having the key as its tag and corresponding to a reply message from the user.

6. The computer of claim 4, wherein assigning a value to the selected digit comprises:

determining the number of children of the immediate parent of the first message that have already been tagged;

incrementing the number of children to obtain an incremented number; and

setting the value of the selected digit to equal the value of the incremented number.

7. An apparatus including a processor for tagging a message in a hierarchical data set having a plurality of hierarchical levels and a plurality of hierarchical depths, the apparatus further comprising

means for presenting a first message of an indented threaded discussion;

means for determining a hierarchical level of the first message within the indented threaded discussion;

means for determining a hierarchical depth of the first message within the indented threaded discussion;

means for assigning a first tag to the first message, comprising;

means for determining the immediate parent of the first message;

means for selecting a parent tag of the immediate parent of the first message, wherein the parent tag is a number having multiple digits each representing one of the hierarchical depths of the hierarchical data set;

means for selecting a digit of the selected parent tag that represents the hierarchical depth of the first message within the indented threaded discussion; and

means for assigning a value to the selected digit, the value representing the hierarchical level of the first message within the indented threaded discussion; and

means for storing an entry in a table of a database, said table entry including the assigned first tag, the selected digit representing the hierarchical depth within the indented threaded discussion, the assigned value representing the hierarchical level within the indented threaded discussion, and the first message.

8. The apparatus of claim 7, further comprising:

means for receiving a command from a user requesting replying to the first message;

means for selecting the digit corresponding to the hierarchical depth immediately below the hierarchical depth of the first message;

means for incrementing the value of the selected digit, thereby producing a key; and

means for indexing the database by adding a record to the database having the key as its tag and corresponding to a reply message from the user.

9. The apparatus of claim 7, wherein means for assigning a value to the selected digit comprises:

means for determining the number of children of the immediate parent of the first message that have already been tagged;

means for incrementing the number of children to obtain an incremented number; and

means for setting the value of the selected digit to equal the value of the incremented number.

10. Computer-readable media embodying instructions executable by a computer including a processor to perform a method for tagging a message in a hierarchical data set having a plurality of hierarchical levels and a plurality of hierarchical depths, the method comprising:

presenting a first message of an indented threaded discussion;

determining a hierarchical level of the first message within the indented threaded discussion;

determining a hierarchical depth of the first message within the indented threaded discussion;

assigning a first tag to the first message, comprising;

determining the immediate parent of the first message;

selecting a parent tag of the immediate parent of the first message, wherein the parent tag is a number having multiple digits each representing one of the hierarchical depths of the hierarchical data set;

selecting a digit of the selected parent tag that represents the hierarchical depth of the first message within the indented threaded discussion; and

assigning a value to the selected digit, the value representing the hierarchical level of the first message within the indented threaded discussion; and

storing an entry in a table of a database, said table entry including the assigned first tag, the selected digit representing the hierarchical depth within the indented threaded discussion, the assigned value representing the hierarchical level within the indented threaded discussion, and the first message.

11. The media of claim 10, the method further comprising:

receiving a command from a user requesting replying to the first message;

selecting the digit corresponding to the hierarchical depth immediately below the hierarchical depth of the first message;

incrementing the value of the selected digit, thereby producing a key; and

indexing the database by adding a record to the database having the key as its tag and corresponding to a reply message from the user.

12. The media of claim 10, wherein assigning a value to the selected digit comprises:

determining the number of children of the immediate parent of the first message that have already been tagged;

incrementing the number of children to obtain an incremented number; and

setting the value of the selected digit to equal the value of the incremented number.