Configurable framework for storing and retrieving arbitrary information from a database

• US 7,613,723 B2
• Filed: 03/01/2007
• Issued: 11/03/2009
• Est. Priority Date: 11/06/2003
• Status: Expired due to Fees

• Current Assignee: Ryan Levacy
• Original Assignee: Ryan Levacy
• Inventors: Tully, Ricky Dale
• Primary Examiner(s): Chace; Christian P.
• Assistant Examiner(s): Syed; Farhan M
• Application Number:
  US11/681,029
• Publication Number:
  US 20070156662A1
• Time in Patent Office: 978 Days
• Field of Search: None
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/80 of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML content-based retrieval of web data G06F16/95
• 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

Abstract

A system, apparatus and method are provided that enable the receipt of answers to questions from users and to make those answers persistent within a generalized database schema. A set of one or more middleware entities and components are provided to process the user'"'"'s answers that are submitted to the system. The middleware entities differentiate one user from another user by use of a session. Different sets of questions are grouped into encounters, and the answers to the questions for a particular encounter are given a unique identifier. The unique identifier can be used to identify the user and/or the particular encounter. The answers to the questions can be retrieved and viewed in numerous ways, such as by user, by encounter, by question, by question type, by answer, by answer type, etc. The selection of database schema and the structure of the middleware enables the system to handle any answer to any question without requiring the restructuring of the database or database schema.

Claims

1. A computer program, stored on a tangible computer-readable medium for storing a set of user answers, the computer program including executable instructions that cause a computer to:

access a database that is characterized by a database schema, the database schema comprising;

at least one root comprising a root attribute;

one or more question nodes comprising a question attribute; and

one or more selection nodes comprising a selection type, the selection type indicating a location of a selection item;

one or more user encounter nodes; and

one or more user answer nodes;

wherein;

each root is associated with one or more predetermined encounters;

each root is linked to one or more of the question nodes;

one or more of the question nodes are linked to one or more of the selection nodes; and

each of the user answer nodes are linked to a user encounter node; and

execute a user interface, wherein the user interface is configured to;

initiate a user encounter node in the database;

select one or more first predetermined encounters;

for at least one of the first selected predetermined encounters;

for one or more roots associated with the first selected predetermined encounter;

for each question node associated with the root;

 

present the question attribute associated with the question node;

 

present the selection items associated with the selection nodes that are associated with the question node; and

 

receive a user selection; and

 

store the user selection as a first user answer in the database;

 

link the first user answer with the user encounter;

selecting one or more second predetermined encounters, based at least in part on a user selection received in response to a question attribute; and

for one or more of the second selected second predetermined encounters;

for one or more roots associated with the second predetermined encounter;

for each question node associated with the root;

 

present the question attribute associated with the question node;

 

receive a second user answer;

 

store the second user answer in the database; and

 

link the second user answer with the user encounter;

 

wherein the first user answer and second user answer have different data types.

2. The computer program of claim 1, wherein one or more predetermined encounters represents a unique topic.

3. The computer program of claim 1, wherein the executable instruction that cause the computer to selecting at least one predetermined encounter further cause the computer to:

present the user with the root attributes associated with one or more predetermined encounters; and

receive a user selection of one of the root attributes to select a predetermined encounters.

4. The computer program of claim 1, wherein the executable instruction that cause the computer to selecting at least one predetermined encounter further cause the computer to:

display a plurality of predetermined encounters to the user in one instance;

receive a user selection of one of the one or more predetermined encounters; and

query the database to retrieve each root attribute associated with the selected predetermined encounter.

5. The computer program of claim 4, comprising further executable instructions that cause the computer to:

display each root entity attribute retrieved from the root entity query;

receive a user selection of one root entity attribute; and

query of the database to retrieve each question node attribute associated with the question node identifier associated with the root entity attribute selected by the user; and

display in a predetermined sequential order each retrieved question node attribute; and

query the database to store answers to each of the question node attributes.

6. The computer program of claim 1, wherein each question node attribute is a unique question associated with the one or more predetermined encounters.

7. The computer program of claim 1, wherein at least one of the one or more of the predetermined encounters is associated with two or more root attributes.

8. The computer program of claim 1, wherein at least one selection type indicates image data.

9. The computer program of claim 1, wherein at least one selection type indicates character data.

10. An information handling system comprising:

one or more processors;

a memory storing executable instructions that cause at least one of the one or more processors to;

access a database that is characterized by a database schema, the database schema comprising;

at least one root comprising a root attribute;

one or more question nodes comprising a question attribute; and

one or more selection nodes comprising a selection type, the selection type indicating a location of a selection item;

one or more user encounter nodes; and

one or more user answer nodes;

wherein;

each root is associated with one or more predetermined encounters;

each root is linked to one or more of the question nodes;

one or more of the question nodes are linked to one or more of the selection nodes; and

each of the user answer nodes are linked to a user encounter node; and

execute a user interface, wherein the user interface is configured to;

initiate a user encounter node in the database;

select one or more first predetermined encounters;

for at least one of the first selected predetermined encounters;

for one or more roots associated with the first selected predetermined encounter;

for each question node associated with the root;

 

presenting the question attribute associated with the question node;

 

present the selection items associated with the selection nodes that are associated with the question node; and

 

receive a user selection; and

 

store the user selection as a first user answer in the database;

 

link the first user answer with the user encounter;

selecting one or more second predetermined encounters, based at least in part on a user selection received in response to a question attribute; and

for one or more of the second selected second predetermined encounters;

for one or more roots associated with the second predetermined encounter;

for each question node associated with the root;

 

present the question attribute associated with the question node;

 

receive a second user answer;

 

store the second user answer in the database; and

 

link the second user answer with the user encounter;

 

wherein the first user answer and second user answer have different data types.

11. The information handling system of claim 10, wherein one or more predetermined encounters represents a unique topic.

12. The information handling system of claim 10, wherein the executable instruction that cause the at least one of the one or more processors to select at least one predetermined encounter further cause the at least one of the one or more processors to:

present the user with the root attributes associated with one or more predetermined encounters; and

receive a user selection of one of the root attributes to select a predetermined encounters.

13. The information handling system of claim 10, wherein the user interface is a web interface.

14. The information handling system of claim 10, wherein the executable instruction that cause the at least one of the one or more processors to select at least one predetermined encounter further cause the at least one of the one or more processors to:

display a plurality of predetermined encounters to the user in one instance;

receive a user selection of one of the one or more predetermined encounters; and

query the database to retrieve each root attribute, associated with the selected predetermined encounter.

15. The information handling system of claim 14, the memory comprising further executable instructions that cause at least one of the one or more processors to:

display each root entity attribute retrieved from the root entity query;

receive a user selection of one root entity attribute; and

query of the database to retrieve each question node attribute associated with the question node identifier associated with the root entity attribute selected by the user; and

display in a predetermined sequential order each retrieved question node attribute; and

query the database to store answers to each of the question node attributes.

16. The information handling system of claim 10, wherein each question node attribute is a unique question associated with the one or more predetermined encounters.

17. The information handling system of claim 10, wherein at least one of the one or more of the predetermined encounters is associated with two or more root attributes.

18. The information handling system of claim 10, wherein at least one selection type indicates image data.

19. The information handling system of claim 10, wherein at least one selection type indicates character data.

20. A method for storing a set of user answers, comprising:

accessing a database that is characterized by a database schema, the database schema comprising;

at least one root comprising a root attribute;

one or more question nodes comprising a question attribute; and

one or more selection nodes comprising a selection type, the selection type indicating a location of a selection item;

one or more user encounter nodes; and

one or more user answer nodes;

wherein;

each root is associated with one or more predetermined encounters;

each root is linked to one or more of the question nodes;

one or more of the question nodes are linked to one or more of the selection nodes; and

each of the user answer nodes are linked to a user encounter node; and

executing a user interface, wherein the user interface is configured to;

initiate a user encounter node in the database;

select one or more first predetermined encounters;

for at least one of the first selected predetermined encounters;

for one or more roots associated with the first selected predetermined encounter;

for each question node associated with the root;

 

present the question attribute associated with the question node;

 

present the selection items associated with the selection nodes that are associated with the question node; and

 

receive a user selection; and

 

store the user selection as a first user answer in the database;

 

link the first user answer with the user encounter;

selecting one or more second predetermined encounters, based at least in part on a user selection received in response to a question attribute; and

for one or more of the second selected second predetermined encounters;

for one or more roots associated with the second predetermined encounter;

for each question node associated with the root;

 

present the question attribute associated with the question node;

 

receive a second user answer;

 

store the second user answer in the database; and

 

link the second user answer with the user encounter;

 

wherein the first user answer and second user answer have different data types.