Generating a dynamic index for a file of user creatable cells

• US 5,483,651 A
• Filed: 12/03/1993
• Issued: 01/09/1996
• Est. Priority Date: 12/03/1993
• Status: Expired due to Term

• Current Assignee: Millenium Software Labs, Inc.
• Original Assignee: Millennium Software
• Inventors: Adams, Jayson L., Love, R. Scott
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): Lintz, Paul R.
• Application Number:
  US08/162,489
• Time in Patent Office: 767 Days
• Field of Search: 395/600, 395/425, 364/419.07, 364/419.11, 364/419.19
• US Class Current: 1/1
• CPC Class Codes: G06F 16/38 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A system and method of automatically indexing information to allow a user to view "cross sections" of the information as desired. Information in a document is divided into "cells". As the user adds or changes information in cells of a document, the system updates one or more indexes to reflect the new contents of the document. Thus, indexes are generated and maintained, using a variety of index criteria, without any user effort or intervention. Index criteria may include cell contents of data elements as well as cell attributes. The user may view indexes by means of special index pages that form part of the document. Cells in the index pages are linked to other cells within the document so that a user may access any document cell directly from the index, as desired.

Claims

1. A system for organizing data in a file and for generating and maintaining a dynamic index for the file, comprising:

a storage device for storing a file comprising a plurality of cells containing data elements, each cell having cell attributes;

an index generator, coupled to the storage device, for generating one or more index data structures for storing an index associated with the cells in the file;

an input device coupled to the storage device, for accepting the data for the cells and for accepting inputs representing events associated with the cells;

an event processor, coupled to the input device, for automatically processing events associated with the cells;

means, coupled to the storage device and the event processor, for dynamically updating an index responsive to an event associated with a cell;

an outline processor, coupled to the input device and the storage device, for hierarchically Organizing the cells in the file; and

a display device, coupled to the storage device, for selectively displaying the file and an index in a notebook metaphor format.

2. The system of claim 1, wherein the updating means comprises:

means, responsive to a cell event indicating addition of a data element to a cell, for creating in the index a new index entry comprising the data element and the cell;

means, responsive to a cell event indicating modification of a data element in a cell, for removing from the index an index entry corresponding to the data element and the cell, and for creating in the index a new index entry comprising the modified data element and the cell; and

means, responsive to a cell event indicating deletion of a data element, for removing from the index an index entry corresponding to the data element and the cell.

3. The system of claim 1, wherein the index structure comprises:

an index item list for storing a plurality of index items; and

for each of at least a subset of the index items, an occurrence list comprising a list of the cells in which the index item occurs.

4. The system of claim 3, wherein the index item list is maintained in a b-tree database.

5. The system of claim 3, wherein the index items correspond to data elements in the cells.

6. The system of claim 3, wherein the index items correspond to words in the cells.

7. The system of claim 3, wherein the index items correspond to numbers in the cells.

8. The system of claim 3, wherein the index items correspond to cell attributes.

9. The system of claim 1, wherein the display device selectively displays data elements responsive to user selection from the displayed index.

10. The system of claim 1, wherein events are generated via the input device by a user.

11. The system of claim 1, wherein events are generated via the input device by an on-line network.

12. The system of claim 1, wherein events are generated via the input device by a computer.

13. The system of claim 1 wherein the data contained in the cells are selected from the group consisting of electronic mail messages, documents, faxes, images, video, audio, spreadsheets, and, graphics.

14. A system for organizing and indexing data in a file, comprising:

a storage device for storing a file comprising a plurality of user creatable cells containing data;

an input device, coupled to the storage device, for accepting the data for the cells and for accepting commands for manipulating the data;

an outline processor, coupled to the input device and the storage device, for selectively organizing the cells in hierarchical form;

an event processor, coupled to the input device, for automatically processing events associated with the cells in the file;

an index generator, coupled to the storage device and the event processor, for initializing at least one dynamic index associated with the cells in the file, and for maintaining the index responsive to the events associated with the cells; and

an output devices, coupled to the outline processor and the index generator, for selectively displaying the data in the cells and the indexes as a notebook metaphor format.

15. A computer-implemented process for organizing data in a file and for generating a dynamic index for the file, comprising the steps of:

receiving a file comprising a plurality of user creatable cells containing data elements, each cell having cell attributes;

organizing the cells hierarchically;

generating at least one index associated with the cells of the file;

accepting an input representing an event on a cell;

dynamically updating the index responsive to the event represented by the input; and

displaying the file and an index in a notebook metaphor format.

16. The computer-implemented process of claim 15, wherein the event is an addition of a data element to a cell, and the updating step comprises:

storing in the index a new index entry comprising the data element and the cell.

17. The computer-implemented process of claim 15, wherein at least one of the indexes stores index data according to the content of the data elements in the cells.

18. The computer-implemented process of claim 17, wherein the data elements are words.

19. The computer-implemented process of claim 17, wherein the data elements are numbers.

20. The computer-implemented process of claim 16, wherein the step of storing further includes the step of:

determining whether a data element appears in a predefined stop list.

21. The computer-implemented process of claim 15, wherein at least one of the indexes stores index data according to a cell attribute.

22. The computer-implemented process of claim 15, wherein the event is a modification of a data element in a cell, and the updating step comprises the substeps of:

removing from the index an index entry corresponding to the data element and the cell; and

storing in the index a new index entry comprising the modified data element and the cell.

23. The computer-implemented process of claim 15, wherein the event is a deletion of a data element in a cell, and the updating step comprises:

removing from the index an index entry corresponding to the data element and the cell.

24. The computer-implemented process of claim 15, wherein the updating step comprises the substeps of:

determining the type of the event;

responsive to the event being an addition of a data element to a cell, storing in the index a new index entry corresponding to the data element and the cell;

responsive to the event being a modification of a data element of a cell, performing the steps of;

removing from the index an index entry corresponding to the data element and the cell; and

storing in the index a new index entry corresponding to the data element and the cell; and

responsive to the event being a deletion of a data element from a cell, removing from the index an index entry corresponding to the data element and the cell.

25. The process of claim 15 wherein the data elements contained in the cells are selected from the group consisting of electronic mail messages, documents, faxes, images, video, audio, spreadsheets, and, graphics.

26. The computer-implemented process of claim 15 further comprising the step of:

responsive to user input, selectively displaying one or more cells corresponding to a selected index entry.

27. A computer-implemented process for generating a dynamic index for a file, the file comprising a plurality of user creatable cells containing data, comprising the steps of:

(a) initializing at least one index associated with the cells;

(b) accepting an input representing an event on a cell;

(c) determining the type of the event;

(d) responsive to the event being an addition of data to a cell, storing in the index a new index entry corresponding to the cell;

(e) responsive to the event being a modification of a cell, performing the steps of;

(e.1) removing from the index an index entry corresponding to the cell; and

(e.2) storing in the index a new index entry corresponding to the cell;

(f) responsive to the event being a deletion of data from a cell, removing from the index an index entry corresponding to the cell;

(g) selectively displaying a representation of a selected index; and

(h) responsive to user input, selectively displaying one or more cells corresponding to a selected index entry.