Method and apparatus for validating a survey database

• US 7,054,827 B1
• Filed: 09/24/1997
• Issued: 05/30/2006
• Est. Priority Date: 09/24/1997
• Status: Expired due to Term

• Current Assignee: Unisys Corporation
• Original Assignee: Unisys Corporation
• Inventors: Austin, Thomas K., Lautzenheiser, Ted G., Peters, Thomas R.
• Primary Examiner(s): Myhre, James W.
• Application Number:
  US08/937,351
• Time in Patent Office: 3,170 Days
• Field of Search: 705/10, 705/7, 707/200, 707/206
• US Class Current: 705/7.32
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: G06Q 30/0203 Market surveys; Market polls
• CPC Class Codes: G06Q 30/0204 Market segmentation
• CPC Class Codes: G06Q 30/0205 Location or geographical consideration

Abstract

A method and apparatus for validating a survey database, preferably before any user requests are submitted to the survey database. This may be accomplished by analyzing the survey database and identifying those portions of the survey database that are potentially problematic, given the expected user request types. The present invention may then notify the user of any potential problems in the survey database, and/or warn the user to view certain results with caution.

Claims

1. A system for providing a user request to a survey database, wherein in response to the user request, the system accesses the survey database and generates a corresponding result, the improvement comprising a survey database checking module for checking the survey database, wherein said database checking module performs a number of checks on the survey database and provides a number of validation results;

wherein selected checks attempt to identify one or more portions of the survey database that are misrepresentative; and

wherein said database checking module reports the one or more portions of the survey database that are misrepresentative in a number of result caveats.

2. A system according to claim 1 wherein said database checking module performs the number of checks by executing a number of rules in a rules based expert system.

3. A system according to claim 1 wherein the survey database has a number of surveys, each of the surveys having a number of corresponding data elements wherein selected data elements represent a selected one of a number of responses to a number of corresponding survey questions.

4. A system according to claim 3 wherein selected ones of the number of checks determine a selected distribution of the responses represented by selected data elements.

5. A system according to claim 3 wherein the responses represented by selected data elements identify one of a number of geographical locations.

6. A system according to claim 5 wherein selected ones of the checks determine a selected distribution of the responses that correspond to the number of geographical locations.

7. A system according to claim 3 wherein the responses represented by selected data elements corresponds to one of a number of predetermined customer groups.

8. A system according to claim 7 wherein selected ones of the checks determine a selected distribution of the responses that correspond to the number of predetermined customer groups.

9. A system for providing a user request to a survey database, wherein in response to the user request, the system accesses the survey database and generates a corresponding result, the survey database having a number of surveys, each of the surveys having a number of corresponding data elements wherein selected data elements identify a selected one of a number of responses to a corresponding survey question, each of a number of selected surveys having a number of common categories wherein selected categories have a survey question that solicits least two responses from the respondents in each survey, the improvement comprising a database checking module for checking the database, wherein said database checking module performs a number of checks on the survey database and provides a number of validation results;

and

wherein said database checking module checks the survey database by checking if any of the survey questions have less than a predefined number of a selected response.

10. A system according to claim 9 wherein one of the number of categories is a product vendor category.

11. A system according to claim 9 wherein one of the number of categories is an industry sector category.

12. A system according to claim 9 wherein one of the number of categories is a product family category.

13. A system according to claim 9 wherein one of the number of categories is a product name category.

14. A system according to claim 9 wherein one of the number of categories is a geographic location category.

15. A system according to claim 9 wherein one of the number of categories is a data of purchase category.

16. A system according to claim 9 wherein a first response indicates the perceived importance of that category by a survey respondent.

17. A system according to claim 16 wherein a second response indicates the perceived satisfaction of that category by the survey respondent.

18. A system according to claim 17 wherein said database checking module checks the survey database by checking if a gap between the perceived importance and perceived satisfaction for a particular category exceeds a predetermined amount.

19. A system for providing a user request to a survey database, wherein in response to the user request, the system accesses the survey database and generates a corresponding result, the survey database having a number of surveys, each of the surveys having a number of corresponding data elements wherein selected data elements identify a selected one of a number of responses to a corresponding survey question, each of a number of selected surveys having a number of common categories wherein selected categories have a survey question that solicits least two responses from the respondents in each survey, the improvement comprising a database checking module for checking the database, wherein said database checking module performs a number of checks on the survey database and provides a number of validation results;

and

wherein said database checking module checks the survey database by checking if any of the survey questions have greater than a predefined number of a selected response.

20. A system for providing a user request to a survey database, wherein in response to the user request, the system accesses the survey database and generates a corresponding result, the survey database having a number of surveys, each of the surveys having a number of corresponding data elements wherein selected data elements identify a selected one of a number of responses to a corresponding survey question, each of a number of selected surveys having a number of common categories wherein selected categories have a survey question that solicits least two responses from the respondents in each survey, the improvement comprising a database checking module for checking the database, wherein said database checking module performs a number of checks on the survey database and provides a number of validation results;

and

wherein said database checking module checks the survey database by checking if the number of a first response exceeds the number of a second response, be a predetermined amount, for a particular survey question.

21. A system for providing a user request to a survey database, wherein in response to the user request, the system accesses the survey database and generates a corresponding result, the survey database having a number of surveys, each of the surveys having a number of corresponding data elements wherein selected data elements identify a selected one of a number of responses to a corresponding survey question, each of a number of selected surveys having a number of common categories wherein selected categories have a survey question that solicits least two responses from the respondents in each survey, the improvement comprising a database checking module for checking the database, wherein said database checking module performs a number of checks on the survey database and provides a number of validation results;

and

wherein said database checking module checks the survey database by checking if a selected survey question has a statistically insignificant number of responses associated therewith in the survey database.

22. A system for providing a user request to a survey database, wherein in response to the user request, the system accesses the survey database and generates a corresponding result, the survey database having a number of surveys, each of the surveys having a number of corresponding data elements wherein selected data elements identify a selected one of a number of responses to a corresponding survey question, each of a number of selected surveys having a number of common categories wherein selected categories have a survey question that solicits least two responses from the respondents in each survey, the improvement comprising a database checking module for checking the database, wherein said database checking module performs a number of checks on the survey database and provides a number of validation results;

and

wherein said database checking module checks the survey database by determining if a selected category does not have a response for selected survey questions that correspond to the selected category.

23. A method for analyzing a survey database in response to user requests, the method comprising the steps of:

a. validating the survey database by Performing a number of predetermined checks thereon;

b. executing a user request;

c. wherein said validating step is performed in response to a survey validation user request;

d. wherein said validating step includes the step of executing a number of predefined rules in a rules based expert system; and

e. wherein said validating step includes the steps of;

f. accessing the survey database via a survey analysis module;

g. generating a number of intermediate reports; and

h. processing the number of intermediate reports to provide a result.

24. A method according to claim 23 wherein said generating step 31(d) generates one or more distribution reports.

25. A method according the claim 24 wherein said processing step 31(e) analyzes the one or more distribution reports, and determines if the survey database would provide misrepresentative results in response to a user request.

26. A method according to claim 23 wherein said generating step 31(d) generates one or more MGAP reports.

27. A method according to claim 26 wherein said processing step 31(e) analyzes the one or more MGAP reports and determines if the survey database would provide misrepresentative results in response to a user request.

28. A method according to claim 23 wherein said generating step 31(d) generates one or more statistics reports.