Deprecated: add_custom_background is deprecated since version 3.4.0! Use add_theme_support( 'custom-background', $args ) instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5084

Deprecated: add_custom_image_header is deprecated since version 3.4.0! Use add_theme_support( 'custom-header', $args ) instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5084

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. This notice was triggered by the jquery handle. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5536

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. This notice was triggered by the smoothscroll handle. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5536

Deprecated: The called constructor method for WP_Widget in Yoko_SocialLinks_Widget is deprecated since version 4.3.0! Use __construct() instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5177
Intro to Databases: Transactions, Isolation Levels | Megan Taylor

Megan Taylor

front-end dev, volunteacher, news & data junkie, bibliophile, Flyers fan, sci-fi geek and kitteh servant

Intro to Databases: Transactions, Isolation Levels

Serializability
Operations may be interleaved, but execution must be equivalent to some sequential order of all transactions.
Overhead, reduces concurrency

Weaker Isolation Levels (lower overhead, more concurrency, lower concurrency guarantees)
Read Uncommitted
Read Committed
Repeatable Read

Isolation level is per transaction
“In the eye of the beholder”

Dirty Reads
“Dirty” data item: written by an uncommitted transaction

Read Uncommitted
A transaction may perform dirty reads

Read Committed
A transaction may NOT perform dirty reads
Still does not guarantee global serializability

Repeatable Read
A transaction may NOT perform dirty reads
An item read multiple times cannot change value
Still does not guarantee global serializability
But a relation can change: “phantom tuples”

December 2, 2011 | Comments Off on Intro to Databases: Transactions, Isolation Levels | Categories: Posts | Permalink

Comments are closed.


Notice: Undefined index: host in /home/pqmz7qzy9yt5/public_html/wp-content/plugins/jetpack/modules/stats.php on line 209