| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

Spring 2014 COP4709 Assignment 5

Page history last edited by Dr. Ron Eaglin 10 years, 1 month ago

 Assignment 5 - Transactions

 

Objectives

 

Demonstrate understanding of ACID and transactions

 

Assignment

 

ACID is a set of rules, not an algorithm. For a database system to implement ACID requirements it must implement it using an algorithm 

 

You will submit a one page maximum limit paper with information comparing how databases implement transaction management to meet the ACID requirements. One of these databases must be SQL Server, you can select any other database for the comparison. You should specifically discuss the differences in algorithms used.

 

Be sure to cite references (this must be done on the one page) - you should have at least 2 references (since you are comparing 2 databases).

 

Submit the assignment in pdf or doc format.

 

Information

 

You will want to Google Search on implementing database ACID

 

Estimated Completion Time

 

5-10 hours to watch video, research requirements - and write the one page paper.

 

Supporting Lectures 

 

Lecture - Getting Started with Transactions in T-SQL

 

Questions and Answers

 

This will require some web research into the algorithms used.

 

External Resources

 

Web sources are sufficient for this assignment, you will need to do some product research (Post-Gre, Oracle, IBM Progress, MySQL, are all examples of database that you can use for comparison)

 

Grading Criteria

 

The paper should be a well written document with no grammar errors and represents your research and knowledge of ACID and specific implementations to meet the requirements of ACID in transaction management.

Comments (0)

You don't have permission to comment on this page.