Sunday, July 8, 2012

CS 9038-DATABASE TUNING-B.E -CSE-COMPUTER SCIENCE AND ENGINEERING SEVENTH-VII SEMESTER 2008 REGULATION ANNA UNIVERSITY SYLLABUS



CSE Computer Science And Engineering VII-Seventh Semester Syllabus 2008 Regulation Anna University


AIM:

To provide a strong foundation in database tuning an Query processing

OBJECTIVES:
·    On completion of the course each student trained in this course will develop effective query execution plans, tune the recovery sub system, tune nested queries, procedures and functions, identify where denormalization is required and tune the application interface.
·    In addition to the above the student will gain knowledge on tuning in the most popularly used Database Servers Oracle, SQL Server and DB2 UDB.  Tuning on distributed database implementation is also part of this course


UNIT I           FUNDAMENTALS OF TUNING                                                                  8
Review of Relational Databases Relational Algebra - Locking and Concurrency Control
Correctness Consideration Lock Tuning Logging and the Recovery Subsystem – Principles of Recovery – Tuning the Recovery Subsystem Operating Systems Considerations Hardware Tuning.

UNIT II          INDEX TUNING                                                                                           8
Types of Queries Data Structures B tree B+  Tree - Hash Structures Bit Map
Indexes Clustering Indexes Non Clustering Indexes Composite Indexes Hot
Tables Comparison of Indexing and Hashing Techniques.

UNIT III         QUERY OPTIMIZATION                                                                           10
Techniques - Tuning Relational Systems Normalization Tuning Denormalization Clustering Two Tables – Aggregate Maintenance Record Layout Query Tuning – Triggers Client Server Mechanisms Objects, Application Tools and Performance – Tuning the Application Interface Bulk Loading Data Accessing Multiple Databases.

UNIT IV        TROUBLESHOOTING                                                                              10
Query Plan Explainers Performance Monitors Event Monitors Finding Suspicious” Queries Analyzing a Querys Access Plan Profiling a Query Execution DBMS Subsystems.

UNIT V         CASE STUDIES                                                                                          9
Transaction Chopping Time Series Databases Understanding Access Plans Configuration Parameters: Oracle; SQL Server; DB2UDB Distributed Database - Implementation.




TEXT BOOK:


TOTAL: 45 PERIODS


1.    Dennis Shasha and Philippe Bonnet “Database Tuning, Principles, Experiments, and Troubleshooting Techniques, Morgan Kaufmann, An Imprint of Elsevier 2003.

REFERENCES:
1.  Thomas Connoly and Carlolyn Begg, “Database Systems, A Practical Approach to
Design, Implementation and Management, Third Edition, Pearson Education 2003.
2.  M.Tamer Ozsu, Patrick Valduriez and S.Sridhar Principles of Distributed Database
Systems, Pearson Education 2007.


7/08/2012 02:20:00 AM

0 comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...