Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-04-22
2001-01-16
Black, Thomas G. (Department: 2771)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C705S026640, C434S323000
Reexamination Certificate
active
06175833
ABSTRACT:
TECHNICAL FIELD
This invention relates to online voting systems. More particularly, this invention relates to a database system that tracks votes cast by voters online over a network such as the Internet in response to interactive polls, and returns poll results to the voters.
BACKGROUND OF THE INVENTION
The Internet provides a wonderful forum for mass distribution of news and other current information. Increasingly, more and more people are using the World Wide Web (or simply “WWW” or “Web”) as their primary, or secondary, source of news and current events. Web sites from MSNBC, CNN, ESPN, and ABC News are experiencing rapidly increasing viewership.
One reason for the growing popularity is that the online forum offers the user an interactive experience, something that conventional television and newspapers cannot. Users can go directly to stories that interest them most. Content editors can also take advantage of the interactive environment by encouraging users to engage in further dialog or react in some manner to the content. For example, the MSNBC Web site found at www.msnbe.com offers readers the opportunity rate stories on an individual basis. The site then tallies the results and compiles a “Top 10” list of the most enjoyed stories.
Another opportunity for online content providers is to conduct live voting polls. Online providers insert survey questions as part of their content and invite readers to respond to the survey by submitting online votes. The impromptu polls typically coincide with current topics of interest featured in the story running beside the poll. As an example, a sports-related Web site, such as the ESPN site www.espn.sportzone.com might run an article on Michael Jordan. The content editors might ask the following question in conjunction with the story:
Do you think Michael Jordan will return to Chicago for another season?
Yes
No
Readers respond by clicking one of the two options. This action sends a response from the user's computer to the Web server at the site. The Web server adds the votes to other votes and compiles the results. The Web server downloads the results to the reader during a subsequent interaction with the user's computer. The poll results are posted as part of the story for the reader to observe how other people voted in comparison to his/her own vote. These real-time polls are very popular.
One problem with live online surveys concerns the underlying production framework for creating real-tine interactive polls. Production of online surveys requires a substantial amount of programming and quality-assurance testing. Typically, an editorial staff writes one or more survey questions in any manner they choose, and to derive what ever kind of response they desire. The questions may be drafted as multiple choice, open ended, essay, and so forth.
After the questions are written, a production group writes a dedicated software program and constructs a special database infrastructure to support the automated survey. For instance, the production group might create one or more database structures to hold votes cast by the readers and to relate those votes to the particular question(s). To support the MSNBC “Top 10” survey, for example, the MSNBC producers defined a table with fields to hold a story ID, a voter ID, a date that the vote is cast, and a response. The producers also defined a second table with fields for the story ID and vote totals. When a reader voted on a particular story, the vote was recorded in the first table in correlation with that story and the totals for that story were adjusted accordingly in the second table. These totals were then used to construct the “Top 10” list, which was presented back to the user.
Unfortunately, the program and data structures are usually built from scratch for each set of questions. The program and data structures are not portable from one survey to another. Moreover, since the database structures are rebuilt for each survey, the production group must test the entire polling process in an offline environment each time a new survey is produced. These tests ensure that the votes are collected properly, stored in the correct data locations, and tallied correctly, and that the results are returned in the desired format to the reader's computer. If the tests prove successful, the production group releases the content and survey for live presentation on the Web site. This testing process takes time, thereby increasing production costs for online content providers.
Accordingly, there is a need for a uniform approach that integrates the editorial process with the production process to standardize and streamline creation of online surveys.
SUMMARY OF THE INVENTION
An online voting system for facilitating live interactive online voting provides a standardized database architecture that integrates the editorial and production processes. The voting system has a survey database to store multiple surveys and a server to serve the surveys over a network (e.g., the Internet) to readers. Each survey consists of one or more questions and multiple answer options per question. For instance, the survey might consist of the survey question “Do you think the Chicago Bulls will win the NBA title?” and the two answer options “yes” and “no”.
The voting system includes an authoring tool to permit an editor to construct the surveys. The surveys are stored in a predefined database structure, referred to as the “survey index table”. The survey index table includes fields to hold the survey identifier, question number, the question text as drafted by the editor (e.g., “Do you think the Chicago Bulls will win the NBA title?”), and option text as drafted by the editor (e.g., “yes” and “no”). The survey index table is replicated onto a live site periodically, allowing editors time to preview their surveys, and served by the site server to interested readers over the network.
The online voting system has a vote handler to process votes cast by the readers in response to the surveys. Unique identifiers of voters who respond to the surveys are collected in a second database structure, known as the “votes table”. The votes table has fields to hold survey IDs, the voters'unique identifiers, and time stamps indicating when the voters cast their votes. This table is checked when each vote is received to prevent readers from voting multiple times for a single survey question.
The vote handler tallies the votes cast for the answer options in a third database structure referred to as the “totals table”. The totals table has fields to hold the survey IDs, the question numbers, the answer options for the questions, and the total votes cast per answer option.
The survey index table also has fields to hold voting results for corresponding survey questions and answer options. The vote handler periodically updates these fields with the totals kept in the totals table. This update is automatic without intervention from the editors.
In this manner, the same index table holds the information to present the survey questions and to show the results to the survey. The online voting system presents the survey form to first time readers. However, once the reader has cast a vote, the online voting system returns the survey with the voting tallies (but without an opportunity to vote again) so the reader can view the survey results.
Over time, as the survey becomes stale, the editor may remove one or more questions or the entire survey from the survey index table. The removed surveys are automatically archived, along with their vote totals and percentages, in persistent storage. After archival, the voting data for the removed surveys is automatically deleted from the votes and totals tables.
REFERENCES:
patent: 5180309 (1993-01-01), Egnor
patent: 5893098 (1999-04-01), Peters et al.
patent: 5950172 (1999-09-01), Klingman
patent: 5950213 (1999-09-01), Iida et al.
MSNBC Website (“Live Vote”, http:www.msnbc.com
ews/308310.asp), Oct. 28, 1999, pp 1-2).
Anderson Sean
West Brenden
Black Thomas G.
Lee & Hayes PLLC
Microsoft Corporation
Trinh William
LandOfFree
System and method for interactive live online voting with... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with System and method for interactive live online voting with..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for interactive live online voting with... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2443692