1 / 12

ICS 223: Transaction Processing and Distributed Data Management Winter 2008

ICS 223: Transaction Processing and Distributed Data Management Winter 2008. Professor Sharad Mehrotra Information and Computer Science University of California, Irvine Notes 01. This Lecture. Course introduction Transactions ACID Crash recovery (review) Concurrency control

kendis
Download Presentation

ICS 223: Transaction Processing and Distributed Data Management Winter 2008

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ICS 223: Transaction Processing and Distributed Data ManagementWinter 2008 Professor Sharad Mehrotra Information and Computer Science University of California, Irvine Notes 01

  2. This Lecture • Course introduction • Transactions • ACID • Crash recovery (review) • Concurrency control • Serializability Notes 01

  3. Course General Info • URL: http://www.ics.uci.edu/~cs223/ • All course info will be posted online • Lecture times: Tues and Thurs 5 to 6.20 pm • Instructor: Sharad Mehrotra, sharad@ics.uci.edu • Newsgroup: ics.223 Notes 01

  4. Prerequisites • Either ICS148 ("Distributed Computing") or ICS153 ("Computer Networks”) • Programming skills (C, C++, or Java) Notes 01

  5. Why take ICS 223? • Covers fundamental principles underlying transaction processing • database consistency, • concurrency control, • database recovery and fault-tolerance. • Covers distributed database systems. • A prerequisite for: • further advanced data management courses • research principles of data management. Notes 01

  6. Text Books No required textbooks. The following are commended: • Database System Implementation, by Hector Garcia-Molina, Jeffrey Ullman, and Jennifer Widom, Prentice Hall, 1999. Or Database Systems: The Complete Book, by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom, Prentice Hall, 2001. • Principles of Transaction Processing, by Philip A. Bernstein and Eric Newcomer, Morgan Kaufmann, 1997. • Transaction Processing: Concepts and Techniques Jim Gray and Andreas Reuter Morgan Kaufman Publishers 1993 • Research papers may be made available whenever possible to supplement the textbook. Notes 01

  7. Course Requirements • Assignments: 20 • Programming Projects: 30 • Final: 30 • Mid Term Exam: 20 Notes 01

  8. Grading For all the graded assignments and projects, if you disagree with the grading, you can discuss with the instructor within two weeks after they are returned. After that, all the grades will be finalized. Notes 01

  9. Simplified DBMS Architecture Application Queries Schema changes compilers optimizer Query processor Metadata and data dictionary evaluator Buffer manager Storage manager Transaction Manager File system Database and Indices Notes 01

  10. DBMS Goals • Efficient data management (faster than files) • Large amount of data • High reliability • Information sharing (multiple users) • DBMS Users: • E-commerce companies, banks, airlines, transportation companies, corporate databases, government agencies, … • Anyone you can think of! Notes 01

  11. Key Database Technologies ICS222 • File Management • provides a file abstraction as a collection of records stored in disk • Index Management and Access Methods • implements techniques for associative access to data • Query Optimization and Processing • given a query and data storage structures, determines an efficient strategy to evaluate the query. • Transaction management • ensures consistency of the database in presence of concurrent transactions and various types of failures • Catalog Management • maintains database schema information • Authorization and Integrity Management • tests for integrity constraints and user authorization ICS223 Notes 01

  12. Structure of DB courses @ UCI Intro Project-oriented ICS185 ICS184 undergrad grad ICS215 DB Seminar ICS223 ICS222 Transaction Processing and Distributed Data Management DB Principles Advanced Topics Notes 01

More Related