In an Internet election system, each voter is sent a PIN in the mail. When that voter wants to vote at the election web site, she enters her PIN and her vote, and then a voting transaction is executed. In the voting transaction, first the PIN is checked to verify that it is valid and has not been used already, and then the vote tally for the appropriate candidate is incremented. Two tables are used: One contains the valid PINs together with an indication of whether or not each PIN has been used and the other contains the names of the candidates and the vote tally for each. Discuss the issues involved in selecting an appropriate isolation level for the voting transaction. Discuss the issues involved in selecting appropriate isolation levels if a new(read-only) transaction is introduced
that outputs the entire vote tally table.
What will be an ideal response?
The only SQL statements in the voting transaction will be an UPDATE statement that
checks and updates the PIN table and an UPDATE statement that updates the tally
table. Since write locks are always long duration at all isolation levels, schedules of
voting transactions will be serializable at any isolation level.
A transaction that outputs the tally table should run at READ COMMITTED and
use an insensitive cursor in order to output a consistent snapshot of the table.
You might also like to view...
Which of the following statements is false?
a. Path method isAbsolute returns a boolean indicating whether a Path represents an absolute path to a file or directory. b. Files static method getLastModifiedTime receives a Path and returns a FileTime (package java.nio.file.attribute) indicating when the file was last modified. c. Files static method size receives a Path and returns a long representing the number of bytes in the file or directory. For directories, the value returned is platform specific. d. All of the above are true.
Which of the following is true about free space optics?
A. primarily used for indoor applications B. speeds are comparable to fiber optic C. beams can be harmful to human eyes D. link heads must be mounted outdoors
If you have redundant data in your database, then you have duplicate data that should be corrected or deleted
Indicate whether the statement is true or false
?The pseudo-class:link is used to style a link that has been clicked.
Answer the following statement true (T) or false (F)