1 / 13

Database Management Systems 331 IT

Database Management Systems 331 IT. Semester II 1431/1432 Winter 2011. Your Instructors. Lab I. Rana Al-Murshed Office Location: Room 93 – 2 nd Floor - Building 20 Office Hours: to be announced on course site, or by appointment. e-mail: almurshed.r@ccis.edu.sa

vanig
Download Presentation

Database Management Systems 331 IT

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. Database Management Systems331 IT Semester II 1431/1432 Winter 2011

  2. Your Instructors Lab I. Rana Al-Murshed Office Location: Room 93 – 2nd Floor - Building 20 Office Hours: to be announced on course site, or by appointment. e-mail: almurshed.r@ccis.edu.sa Tutorial I. Abeer Al-Dayel Office Location: Room 813 – 3rd Floor - Building 9 Office Hours: XXXX e-mail: aabeer@ksu.edu.sa

  3. Textbook Database Systems A Practical Approach to Design, Implementation and Management. Thomas Connolly, Carolyn Begg 4th or 5th Edition

  4. Reference Books Fundamentals of Database Systems. Ramez Elmasri, Shamkant Navathe. 3rd Edition, 2000 Database systems, Design, Implementation, & Management Peter Rob, Carlos Coronel. 4th Edition. 2000

  5. Course Requirements 3 Quizzes (10%) Weekly Assignments (5%) DBA Lab (10%) Mini Project (5%) Final Lab Exam (5%) 2 Major Exams (25%) Final Exam (40%)

  6. Important Dates • Quiz1 Monday 21 March 2011 • Mid1 Monday 28 March 2011 • Quiz2 Monday 2 May 2011 • Mid2 Monday 9 May 2011 • Quiz3 Monday 23 May 2011

  7. Course Website http://331it.wordpress.com/

  8. Syllabus • Object-Oriented Databases and Object-Relational Databases. • Transaction Processing and Concurrency Control. • Recovery management. • Query Processing. • Distributed Databases. • Lab: DB Administrator skills.

  9. Our Work Most of the Semester Course Outcomes • You should learn how databases work internally by studying the different components of a database system: • Transaction Processing. • Recovery. • Query Processing. Select Name From Students Where Age>20 Nora Monira Hala ..

  10. Course Outcomes • You should be able to design a distributed database and decide on the best strategy for executing a query. • You should know about new database technologies such as Object-Oriented Databases and Object-Relational Databases. • You should be able to perform the basic tasks of a DB Administrator.

  11. Official Course Outcomes • Have knowledge of emerging database technologies such as Object-Oriented Databases and Object-Relational Databases. • Comprehend different techniques for concurrency control and recovery in both centralized and distributed database systems. • Apply different concurrency control and recovery techniques on the execution of databases. • Evaluate the different techniques used in concurrency control and find advantages and disadvantages of each. Also, propose improvements to them.

  12. Official Course Outcomes • Analyze and design a suitable fragmentation based on a given a set of demands and constraints. • Comprehend and apply query processing methodologies. • Be able to select from relational algebra transformation rules to achieve query optimization. • Learn and apply database administration techniques, taking Oracle as an example. Database Systems

  13. Teaching Philosophy • Absolutely NO memorizing: Cheat-sheets in exams. • No question is a stupid question: So if in doubt, just ask. • Don’t leave the lecture until you understand everything. Please. • Study from the book. Slides are just a guideline.

More Related