Method for recording user interaction with a computer database to generate reports

• US 5,442,786 A
• Filed: 04/28/1994
• Issued: 08/15/1995
• Est. Priority Date: 04/28/1994
• Status: Expired due to Term

• Current Assignee: Robert E. Bowen
• Original Assignee: Robert E. Bowen
• Inventors: Bowen, Robert E.
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): WANG, PETER
• Application Number:
  US08/234,223
• Time in Patent Office: 474 Days
• Field of Search: 395/600
• US Class Current: 707/758
• CPC Class Codes: G06F 16/9027 Trees
• CPC Class Codes: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A method for creating a hierarchical data tree includes the initial step of providing a computer information processing system with a data base which interacts with user input to build the data tree based upon system responses. The user initially designates a source field and a next record field and the system searches the data base for records which have a target field matching the designated source field. The next record field of each record determines interaction with records, which have target fields matching the displayed record'"'"'s source field. If a response is expected from the user, the user may either accept the record displayed or provide a separate user response as a selection. If no response is expected, according to the next record field, the system automatically selects the first matching record found. The system records the selection, whether from the system or from the user, utilizing a block of computer memory. The system then utilizes the recorded node as the basis for further search and further interaction. The system first creates a vertical leg of the data tree, before creating horizontal branches, according to the rules of interaction.

Claims

1. A method for recording user interaction with a computer data base to generate reports, comprising the steps of:

providing a computer information processing system, including a data base which interacts with user data input to build a hierarchical data tree based upon system responses;

a user initially designating a source and a "next record" field in said system;

each said "next record" field comprising instructions to direct a response by the system upon identification of a record with the designated source field;

said system searching a plurality of records forming said data base for records which have a target field matching the inputted source field, and displaying an initial record found for viewing by the user;

the system reading the instructions of the initially designated "next record" field of the initial record and interacting with records matching the initial record'"'"'s source field according to those instructions;

said system responding to a "response expected" instruction in a "next record" field by prompting the user for one of two responses;

wherein the two responses consist of;

(1) requesting the user to select a record with a target field matching the displayed source field; and

(2) requesting the user to provide a separate response as a selection;

said system responding to a "no response expected" instruction in a "next record" field by finding all records with target fields matching the source field of the displayed record, and automatically selecting the first record found;

said system recording a selection from the user or system as a first node, utilizing a block of computer memory;

said computer system designating nodes in a predetermined hierarchical sequence, designating nodes with identical target fields as being on the same horizontal level, and designating a node with a source field matching a designated record'"'"'s target field as being on a higher level than the designated record, each said node containing references to a previously selected node on the same level, the next node to be selected on the same level, the next higher level node and the next lower level node;

said system searching said data base for records which have a target field matching the source field of a second selected source field inputted by the user or system, and displaying a first matching record found for viewing by the user or system;

said system recording a selection of a displayed record by the user or the system, as a second node, on a lower vertical level than the first node;

continuing the steps of searching records, displaying a record, and recording selections, until no matching target fields are found for a selected record source field, at which time a first vertical leg of a hierarchical data tree is terminated; and

said system generating a report of all recorded nodes.

4. The method of claim 1, 2 or 3, further comprising the steps of:

said system searching the next higher node above the last recorded node, after the step of terminating the first vertical leg of the data tree, and checking the "next record" field thereof;

said system searching the data base for a second record with a target field matching the source field of the next higher node, and said system moving vertically up a node level if no match is found;

continuing the steps of searching the next higher node, searching the data base for a second record, and moving vertically up a node level until all nodes in the vertical leg are searched.

5. The method of claims 1, 2 or 3, further comprising the steps of:

said system searching the next higher node, after the step of terminating the first vertical leg of the data tree, and checking the "next record" field thereof;

if the next higher node next record field calls for a user response, and an additional selection is needed, then said system searching the data base for a second record with a target field matching the source field of the next higher node and displaying a matching record to the user;

if the next higher node next record field calls for no user interaction, then said system searching the database for an unused record with a target field which matches the next higher node source field, and displaying a next match;

said user or system selecting the displayed record;

said system adding a node on the same horizontal level and designating the added node as horizontal node 1.

6. The method of claim 5, further comprising the steps of:

said system searching said data base for records which have a target field matching the source field of the horizontal node 1, and displaying a first matching record found for viewing by the user;

continuing the steps of recording selected records, searching records and displaying records until no matching source fields are found for a selected record source field at which time a vertical leg below the horizontal node is terminated.

2. A method for recording user interaction with a computer data base to generate reports, comprising the steps of:

providing a computer information processing system, including a data base which interacts with user data input to build a hierarchical data tree based upon system responses;

a user initially designating a source and a "next record" field in said system;

each said "next record" field comprising instructions to direct a response by the system upon identification of a record with the designated a sought source field;

said system searching a plurality of records forming said data base for records which have a target field matching the inputted source field, and displaying an initial record found for viewing by the user;

the system reading the instructions of the initially designated "next record" field of the displayed record and interacting with records matching the displayed record'"'"'s source field according to those instructions;

said system responding to a "response expected" instruction in a "next record" field by prompting the user for one of two responses;

wherein the two responses consist of;

(1) requesting the user to select a record with a target field matching the displayed source field; and

(2) requesting the user to provide a separate user response as a selection;

said system responding to a "no response expected" instruction in a "next record" field by finding all records with target fields matching the source field of the displayed record, and automatically selecting the first record found;

said system recording a selection from the user or system as a first node, utilizing a block of computer memory;

said computer system designating nodes in a predetermined hierarchical sequence, designating nodes with identical target fields as being on the same horizontal level, and designating a node with a source field matching a designated record'"'"'s target field as being on a higher level than the designated record, each said node containing references to a previously selected node on the same level, the next node to be selected on the same level, the next higher level node and the next lower level node;

said user selecting a first record displayed by the system, in response to a prompt from the computer system caused by a "response expected" instruction in the initially designated "next record" field;

said system searching said data base for records which have a target field matching the source field of a selected first record and displaying a first matching record found for viewing by the user;

said system recording a selection of a displayed record by the user or the system, as a second node, on a lower vertical level than the first node;

continuing the steps of searching records, displaying a record, and recording selections, until no matching target fields are found for a selected record source field, at which time a first vertical leg of a hierarchical data tree is terminated; and

said system generating a report of all recorded nodes.

3. A method for recording user interaction with a computer data base to generate reports, comprising the steps of:

providing a computer information processing system, including a data base which interacts with user data input to build a hierarchical data tree based upon system responses;

a user initially designating a source and a "next record" field in said system;

each said "next record" field comprising instructions to direct a response by the system upon identification of a record with the designated source field;

said system searching a plurality of records forming said data base for records which have a target field matching the inputted source field, and displaying an initial record found for viewing by the user;

the system reading the instructions of the initially designated "next record" field of the displayed record and interacting with records matching the displayed record'"'"'s source field according to those instructions;

said system responding to a "response expected" instruction in a "next record" field by prompting the user for one of two responses;

wherein the two responses consist of;

(1) requesting a user to select a record with a target field matching the displayed source field and

(2) requesting a user to provide a separate user response as a selection;

said system responding to a "no response expected" instruction in a "next record" field by finding all records with target fields matching the source field of the displayed record, and automatically selecting the first record found;

said system recording a selection from the user or system as a first node, utilizing a block of computer memory;

said computer system designating nodes in a predetermined hierarchical sequence, designating nodes with identical target fields as being on the same horizontal level, and designating a node with a source field matching a designated record'"'"'s target field as being on a higher level than the designated record, each said node containing references to a previously selected node on the same level, the next node to be selected on the same level, the next higher level node and the next lower level node;

said system searching said data base for records which have a target field matching the source field of a record automatically selected by the computer system caused by a "no response expected" instruction in the initially designated "next record" field, and displaying a first matching record found for viewing by the user;

said system recording a selection of a displayed record by the user or the system, as a second node, on a lower vertical level than the first node;

continuing the steps of searching records, displaying a record, and recording selections, until no matching source fields are found for a selected record source field, at which time a first vertical leg of a hierarchical data tree is terminated; and

said system generating a report of all recorded nodes.