Database search and record retrieval system which continuously displays category names during scrolling and selection of individually displayed search terms

• US 5,206,949 A
• Filed: 08/07/1989
• Issued: 04/27/1993
• Est. Priority Date: 09/19/1986
• Status: Expired due to Fees

• Current Assignee: Nancy P. Cochran
• Original Assignee: Nancy P. Cochran
• Inventors: Cochran, Nancy P., Byrnes, Susan
• Primary Examiner(s): Lee, Thomas C.
• Assistant Examiner(s): Coleman, Eric
• Application Number:
  US07/390,524
• Time in Patent Office: 1,359 Days
• Field of Search: 395/100, 395/600, 340/721, 340/723, 340/712, 340/720, 366/200 MS File, 366/900 MS File
• US Class Current: 707/752
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

The method of variably displaying search terms includes continuously displaying the names of categories on a video terminal screen. When the cursor is adjacent a category, one data set or search term is displayed, that search term being one of a plurality of terms in a list associated with the particular category. The user displays another term from the list by actuating a scrolling control key input. To select a desired term and move to the next category, the user actuates a select control key input. Therefore, the display system utilizes only two control inputs to select a plurality of terms for a plurality of categories. One list of terms represents control commands that control, among other things, the output of data from the system. One technique of formulating the list is to obtain the data fields from a particular field, corresponding to the category, from all records in a data base. The retrieved data fields are then used as search terms in this dynamically formed list. The terms can also be grouped in fixed or static lists. A routine is used to segment or subdivide the data base search for the dynamic list or to subdivide the static list.

Claims

1. A method of retrieving information from a database, comprising the steps of:

accessing a database containing records each having data fields searchable by using data sets that are categorized by categorical identifiers and sequentially ordered into a plurality of lists with each data set being one selectable data set entity in a list of a respective one of the categorical identifiers;

continuously displaying a plurality of said categorical identifiers at respective coordinates on a display medium, at least some of said categorical identifiers being displayed simultaneously during at least a portion of the displaying of said categorical identifiers, and each of said categorical identifiers corresponding to at least one of said plurality of lists;

sequentially displaying data sets in one list corresponding to a respective one of said displayed categorical identifiers upon sequential application of a scrolling control, so that said selectable data set entities in said one list are displayed in a respective one of a plurality of preselected locations on said display medium, one at a time;

selecting a desired data set entity from said one list when said desired data set entity is displayed in said one preselected location;

searching for records having data fields corresponding to said selected data set entity;

selecting at least one additional one of said displayed categorical identifiers corresponding to another one of said plurality of lists;

sequentially displaying sequential data sets of respective additional lists corresponding to said at least one additional displayed categorical identifier and any desired additional displayed categorical identifiers, upon sequential application of a scrolling control, so that said selectable data set entities in said additional lists are displayed in respective ones of said preselected locations on said display medium, one at a time;

selecting respective desired data set entities of said at least one additional displayed categorical identifier and each of said desired additional displayed categorical identifiers, when each of said desired data set entities is displayed in its respective preselected location; and

searching for and retrieving records having data fields corresponding to each additional selected data set entity using only those records which were found to have data field-data set entity correspondence in preceding searches.

2. A method as claimed in claim 1, wherein the selectable data set entities are displayed in their respective preselected locations on the display medium, one at a time, next to their respective displayed categorical identifiers.

3. A method as claimed in claim 1, wherein only one of said selectable data set entities in each of said lists id displayed on said display medium at one time, to conserve space.

4. A method as claimed in claim 1, wherein the selection of each of said data set entities when said data set entity is displayed in its preselected location, is accomplished solely by operation of a select control key means.

5. A method as claimed in claim 4, wherein:

said selectable data set entities are displayed in their respective preselected locations on the display medium next to their respective displayed categorical identifiers, with only one of said selectable data set entities in each list being displayed on said display medium at one time, to conserve space.

6. A system for retrieving information from a database, comprising:

a database containing records each having data fields searchable by using data sets that are categorized by categorical identifiers and sequentially ordered into a plurality of lists with each data set representing one selectable data set entity in a list of a respective one of said categorical identifiers;

display means for continuously displaying a plurality of categorical identifiers at respective coordinates on a display medium, at least some of said categorical identifiers being displayed simultaneously during at least a portion of the displaying of said categorical identifiers, and each of said categorical identifiers corresponding to at least one of said plurality of lists;

means for sequentially displaying data sets of one list corresponding to a respective one of said displayed categorical identifiers upon sequential application of a scrolling control input, so that said selectable data set entities in said one list are displayed in a respective one of a plurality of preselected locations on said display medium, one at a time;

means for selecting a desired data set entity from said one list when said desired data set entity is displayed in said one preselected location; and

means for selecting at least one additional one of said displayed categorical identifiers corresponding to another one of said plurality of lists;

said sequential displaying means also sequentially displaying data sets of respective additional lists corresponding to said at least one additional displayed categorical identifier and any desired additional displayed categorical identifiers, upon sequential application of a scrolling control input, so that said selectable data set entities in said additional lists are displayed in respective ones of said preselected locations on said display medium, one at a time; and

said data set selecting means selecting each of said desired additional data set entities of said at least one additional displayed categorical identifier and each of said desired additional displayed categorical identifiers, when each of said desired data set entities is in its respective preselected location;

means for searching for and retrieving records having data fields corresponding to said selected data set entities; and

means for limiting records available to said searching means to only those records previously obtained via previously selected ones of said data set entities.

7. A method as claimed in claim 6, wherein said data set displaying means sequentially displays said selectable data set entities in their respective preselected locations on said display medium, one at a time, next to their respective displayed categorical identifiers.

8. A system as claimed in claim 6, wherein said displaying means displays only one of said selectable data set entities in each of said lists on said display medium at one time, to conserve space.

9. A system as claimed in claim 6, wherein said selecting means comprises select control key means for selecting said data set entities, and each of said data set entities is selected when said data set entity is displayed in its preselected location, solely in response to operation of said select control key means.

10. A method of selecting desired data sets as claimed in claim 9, wherein said sequential displaying means displays said selectable data set entities in their respective preselected locations on said display medium next to their respective displayed categorical identifiers, with only one of said selectable data set entities in each list being displayed on said display medium at one time, to conserve space.

11. A method of retrieving information from a database, comprising the steps of:

accessing a database containing records each having data fields searchable by using data sets that are categorized and sequentially ordered into a plurality of lists;

continuously displaying a plurality of categorical identifiers at respective coordinates on a display medium so that at least some of said categorical identifiers are displayed simultaneously, each of said categorical identifiers corresponding to at least one of said plurality of lists;

sequentially displaying, one at a time in a preselected location, data sets in one list corresponding to a respective one of said displayed categorical identifiers upon sequential application of a scrolling control;

selecting a desired data set that is currently displayed;

searching for records having data fields corresponding to said selected data set;

selecting at least one additional one of said displayed categorical identifiers corresponding to another one of said plurality of lists;

sequentially displaying, one at a time in a preselected location, data sets of respective additional lists corresponding to said at least one additional one of said displayed categorical identifiers and any additional selected ones of said displayed categorical identifiers, upon application of a scrolling control;

selecting respective data sets of each of said selected additional displayed categorical identifiers; and

searching for and retrieving records having data fields corresponding to each additional selected data set using only those records which were found to have data field-data set correspondence in preceding searches.

12. A method as claimed in claim 11, wherein the data sets for each displayed categorical identifier are sequentially displayed, one at a time, next to said displayed categorical identifier, upon sequential application of a scrolling control.

13. A method as claimed in claim 12, wherein said categorical identifiers and data sets are displayed at their respective coordinates on a computer screen which forms the display medium, and the scrolling and selecting steps are accomplished by operating respective keys of a computer terminal keyboard.

14. A method as claimed in claim 13, further comprising providing reverse scrolling control using a third key of the computer terminal keyboard.

15. A method as claimed in claim 11, wherein the selecting of each desired data set is accomplished, as said data set is being displayed, solely by operation of a select control key means.

16. A system for retrieving information form a database, comprising:

a database containing records each having data fields searchable by using data sets that are categorized and sequentially ordered into a plurality of lists;

display means for continuously displaying a plurality of categorical identifiers at respective coordinates on a display medium, each of said categorical identifiers corresponding to at least one of said plurality of lists;

means for sequentially displaying, one at a time, data sets of one list corresponding to a respective one of said displayed categorical identifiers upon sequential application of a scrolling control input;

means for selecting the currently displayed data set from said one list;

means for selecting at least one additional one of said displayed categorical identifiers corresponding to another one of said plurality of lists;

means for sequentially displaying, one at a time, data sets of respective additional lists corresponding to said at least one additional one of said displayed categorical identifiers and any additional selected displayed categorical identifiers upon application of a scrolling control input;

means for selecting respective data sets of each of said selected additional displayed categorical identifiers;

means for searching for and retrieving records having data fields corresponding to said selected data sets; and

means for limiting the records available to said searching means to only those records previously obtained via previously selected ones of said data sets.

17. A system as claimed in claim 16, wherein said data set displaying means sequentially displays said data sets on said display medium, one at a time, next to their respective displayed categorical identifiers.

18. A system as claimed in claim 17, further comprising a computer having a terminal keyboard and a computer screen which forms said display medium and upon which said categorical identifiers and data sets are displayed by their respective displaying means at their respective coordinates, and wherein said scrolling control inputs and said selecting means are respective keys of the terminal keyboard.

19. A system as claimed in claim 18, further comprising a reverse scrolling control responsive to operation of a third key of the computer terminal keyboard.

20. A system as claimed in claim 16, wherein said selecting means comprises select control key means for selecting said data sets, and each desired data set is selected as it is being displayed by said sequential displaying means, solely in response to operation of said select control key means.

21. A system as claimed in claim 16, which further comprises:

means for selecting a second list related to said one displayed categorical identifier after selecting the currently displayed data set from said one list and before selecting another of said displayed categorical identifiers; and

means for sequentially displaying data sets from said second list and selecting one of said data sets.

22. A method of retrieving information from a database, comprising the steps of:

accessing a database containing records each having data fields searchable by using data terms that are categorized by category names and sequentially ordered into a plurality of lists with the terms in each list arranged in sequence;

continuously displaying a plurality of said category names at respective coordinates on a display medium, said category names being displayed so that at least some of said category names are displayed simultaneously, each of said category names corresponding to at least one of said lists;

establishing a plurality of data term display locations on said display medium;

sequentially displaying data terms in one of said lists which corresponds to a respective one of said displayed category names using a scrolling control, so that said selectable data terms in said one list are displayed in a respective preselected one of said plurality of data term display locations on said display medium, one at a time;

selecting a desired data term from said one list when said desired data term is displayed in said one preselected location;

searching for records having data fields corresponding to said selected data term;

selecting at least one additional one of said displayed category names corresponding to another one of said lists;

sequentially displaying the data terms of respective additional ones of said lists which correspond to said at least one additional displayed category name and any additional selected ones of said displayed category names, using a scrolling control, so that said selectable data set terms in said additional lists also are displayed in respective preselected ones of said data term display locations on said display medium, one at a time;

selecting respective data set terms of each of said desired selected additional displayed category names, when each of said desired selected data terms is displayed in its respective preselected location on said display medium; and

searching for and retrieving records having data fields corresponding to each additional selected data term using only those records which were found to have data field-data term correspondence in preceding searches.

23. A method as claimed in claim 22, wherein said selectable data terms are displayed in their respective preselected locations on the display medium, one at a time, next to their respective displayed category names.

24. A method as claimed in claim 22, wherein only one of said selectable data set terms in each of said lists is displayed on said display medium at one time, to conserve space.

25. A method as claimed in claim 22, wherein the selection of each of said data terms when said data term is displayed in its preselected location, is accomplished solely by operation of a select control key means.

26. A method as claimed in claim 25, wherein:

said selectable data terms are displayed in their respective preselected locations on the display medium next to their respective displayed category names, with only one of said selectable data terms in each list being displayed on said display medium at one time, to conserve space.

27. A system for retrieving information from a database, comprising:

a database containing records each having data fields searchable by using data terms that are categorized by category names and sequentially ordered into a plurality of lists with the terms in each list arranged in sequence;

display means for continuously displaying a plurality of category names at respective coordinates on a display medium, said category names being displayed so that at least some of said category names are displayed simultaneously, each of said category names corresponding to at least one of said plurality of lists, and said display means also including a plurality of data term display locations;

scrolling means for sequentially displaying data terms of one of said lists which corresponds to a respective one of said displayed category names upon sequential application of a scrolling control input, so that said selectable data terms in said one list are displayed in a respective preselected one of said plurality of data term display locations on said display medium, one at a time;

means for selecting a desired data term from said one list when said desired data term is displayed in said one preselected location; and

means for selecting at least one additional one of said displayed category names corresponding to another one of said lists;

said scrolling means also sequentially displaying data terms of respective additional ones of said lists which correspond to said at least one additional displayed category name and any additional selected ones of said displayed category names, upon sequential application of a scrolling control input, so that said selectable data terms in said additional lists also are displayed in respective preselected ones of said data term display locations on said display medium, one at a time; and

said data term selecting means selecting each of said desired additional data terms of selected additional displayed category names, when each of said desired data terms is in its respective preselected location on said display medium;

means for searching for and retrieving records having data fields corresponding to said selected data terms; and

means for limiting the records available to said searching means to only those records previously obtained via previously selected ones of said data terms.

28. A system as claimed in claim 27, wherein said data term displaying means sequentially displays said selectable data terms in their respective preselected locations on said display medium, one at a time, next to their respective displayed category names.

29. A system as claimed in claim 27, wherein said displaying means displays only one of said selectable data terms in each of said groups on said display medium at one time, to conserve space.

30. A system as claimed in claim 27, wherein said selecting means comprises select control key means for selecting said data terms, and each of said data set terms is selected when said data term is displayed in its preselected location, solely in response to operation of said select control key means.

31. A system as claimed in claim 30, wherein said sequential displaying means displays said selectable data terms in their respective preselected locations on said display medium next to their respective displayed category names, with only one of said selectable data terms in each list being displayed on said display medium at one time, to conserve space.

32. A method of selecting at least one record from a data base having a plurality of records, each record having data fields in predetermined categories, comprising the steps of:

continuously displaying a plurality of categorical identifiers at respective coordinates on a display medium, at least some of said categorical identifiers being displayed simultaneously during at least a portion of the displaying of said categorical identifiers, and at least one of said categorical identifiers corresponding to a respective one of said predetermined categories;

obtaining data fields from records out of a selected category corresponding to a respective one of said displayed categorical identifiers and forming a dynamic list with said data fields, said data fields being converted into search terms;

discarding all duplicate search terms from said dynamic list;

sequentially displaying, one at a time, said search terms in said dynamic list upon sequential application of a scrolling control;

selecting a desired first search term that is currently displayed and selecting another of said displayed categorical identifiers;

selecting at least one additional search term by essentially repeating the sequential display and selecting steps used to select said first search term;

using the displayed and selected search terms as a search request; and

retrieving from said data base one or more records matching said search request.

33. A system for selecting at least one record from a data base having a plurality of records, each record having data fields in predetermined categories, comprising:

display means for continuously displaying a plurality of categorical identifiers at respective coordinates on a display medium, at least some of said categorical identifiers being displayed simultaneously during at least a portion of the displaying of said categorical identifiers, and at least one of said categorical identifiers corresponding to a respective one of said predetermined categories;

means for compiling a dynamic list by obtaining data fields from records out of one predetermined category corresponding to a respective one of said displayed categorical identifiers and for converting the obtained data fields into search terms;

means for discarding duplicate search terms from said dynamic list;

means for sequentially displaying, one at a time, search terms of one dynamic list corresponding to a respective one of said displayed categorical identifiers upon sequential application of a scrolling control input;

means for selecting the currently displayed search term from said one dynamic list;

means for selecting another of said displayed categorical identifiers, said scrolling control input and said selecting means then being operable to select at least one additional search term for a search request; and

means for retrieving from said data base one or more records matching said search request.

34. A method of selecting at least one record from a data base having a plurality of records, wherein each record has data fields in predetermined categories, comprising the steps of:

continuously displaying a plurality of category names at respective coordinates on a display medium so that at least some of said category names are displayed simultaneously, each of said category names corresponding to at least one of said predetermined categories;

forming dynamic lists for respective ones of a plurality of said displayed category names by converting the corresponding data fields in the records in the data base into search terms;

discarding all duplicate search terms from said dynamic lists;

establishing a plurality of search term display locations on said display medium for respective ones of said displayed category names and said formed dynamic lists;

sequentially displaying said search terms in one of said dynamic lists at their search term display location on said display medium, one at a time, upon sequential application of a scrolling control;

selecting a desired first search term for a search request from said one dynamic list when the search term is displayed in its search term display location on said display medium;

selecting at least one additional one of said displayed category names corresponding to another one of said predetermined categories;

sequentially displaying said search terms in at least one additional one of said dynamic lists which corresponds to said at least one additional selected one of said displayed category names, and also sequentially displaying said search terms in any additional dynamic lists which have been formed and which correspond to any additional selected ones of said displayed category names, at their respective search term display locations on said display medium, one at time, upon sequential application of the scrolling control;

selecting a desired search term for said search request from at least said one additional dynamic list when the search term is displayed in its respective search term display location on said display medium; and

retrieving from said data base one or more records matching said search request.

35. A system for selecting at least one record from a data base having a plurality of records, wherein each record has data fields in predetermined categories, comprising:

display means for continuously displaying a plurality of category names at respective coordinates on a display medium so that at least some of said category names are displayed simultaneously, each of said category names corresponding to at least one of said predetermined categories;

means for compiling dynamic lists for respective ones of a plurality of said displayed category names by converting the corresponding data fields in the records in the data base into search terms, said display means also including a plurality of search term display locations for respective ones of said displayed category names and said compiled dynamic lists;

means for discarding duplicate search terms from said dynamic lists;

scrolling means for sequentially displaying said search terms of one of said dynamic lists corresponding to a respective one of said displayed category names in their search term display location on said display medium, one at a time, upon sequential application of a scrolling control input;

means for selecting a desired first search term for a search request from said one dynamic list when the search term is displayed in its search term display location on said display medium;

means for selecting at least one additional one of said displayed category names corresponding to a second one of said dynamic lists, said scrolling means and said selecting means then being operable to display and select at least one additional search term for said search request from said second dynamic list, and search terms in any additional dynamic lists which have been formed and which correspond to any additional selected ones of said displayed category names, to form said search request; and

means for retrieving from said data base one or more records matching said search request.