MT 9315 ADVANCED DATABASE TECHNOLOGY SYLLABUS | ANNA UNIVERSITY MTECH MAIN FRAME TECHNOLOGY 1ST SEM SYLLABUS REGULATION 2009 2011 2012-2013 BELOW IS THE ANNA UNIVERSITY FIRST SEMESTER M.TECH MAIN FRAME TECHNOLOGY DEPARTMENT SYLLABUS, TEXTBOOKS, REFERENCE BOOKS,EXAM PORTIONS,QUESTION BANK,PREVIOUS YEAR QUESTION PAPERS,MODEL QUESTION PAPERS, CLASS NOTES, IMPORTANT 2 MARKS, 8 MARKS, 16 MARKS TOPICS. IT IS APPLICABLE FOR ALL STUDENTS ADMITTED IN THE YEAR 2011 2012-2013 (ANNA UNIVERSITY CHENNAI,TRICHY,MADURAI, TIRUNELVELI,COIMBATORE), 2009 REGULATION OF ANNA UNIVERSITY CHENNAI AND STUDENTS ADMITTED IN ANNA UNIVERSITY CHENNAI DURING 2009
MT 9315 ADVANCED DATABASE TECHNOLOGY L T P C
3 1 0 4
UNIT I INTRODUCTION 9
Review of the formal relational data model - Database architecture, Components of
database management system – DDL, DML. Database Security and Database recovery,
Creating SQL Databases and Tables, Defining tables and views, Specifying integrity
constraints, Selecting Data, Queries – stored procedures and functions - triggers and
active databases
UNIT II DATABASE DESIGN ISSUES: 9
ER Model - Normalization - Security - Integrity - Consistency - Database Tuning --
Optimization and Research Issues – Design of active databases - spatio-temporal
databases - multi-media databases
UNIT III TRANSACTION PROCESSING: 9
Introduction – Properties of transaction – Serializability – Concurrency control – Locking
mechanisms – two-phase comMMF protocol – dead locks – Database recovery
UNIT IV DISTRIBUTED DATABASES: 9
Architecture- Design considerations-Interoperability Query processing - semi-joins -
query optimization - Concurrency control – transactions and Heterogeneity issues –
schema translation and schema integration
UNIT V OBJECT ORIENTED DATABASES: 9
Object-oriented data models - Object Identity and its implementation – Supporting object
modeling in database systems--Database programming and querying in object-oriented
databases - ODMG standard, including ODL, OQL – Comparing RDBMS with
OODBMS
L – 45 T – 15 Total – 60
REFERENCES:
1. Raghu Ramakrishnan, Johannes Gehrke, “Database Management Systems”, Tata
Mc- Graw Hill, New Delhi, 2004
2. Barry, Eaglestone and Mick, Ridley, ”Object Databases: An Introduction”, Tata
Mc-Graw Hill, New Delhi., 1998.
3. Mario Piattini, Oscar Diaz, “Advanced database Technology and Design”, Artech
House Publishers, Massachusetts, 2000.
4. Ozsu M. T. & Valduriez P., “Principles of Distributed Database Systems”. , Prentice
Hall, New Delhi, 1999.
MT 9315 ADVANCED DATABASE TECHNOLOGY L T P C
3 1 0 4
UNIT I INTRODUCTION 9
Review of the formal relational data model - Database architecture, Components of
database management system – DDL, DML. Database Security and Database recovery,
Creating SQL Databases and Tables, Defining tables and views, Specifying integrity
constraints, Selecting Data, Queries – stored procedures and functions - triggers and
active databases
UNIT II DATABASE DESIGN ISSUES: 9
ER Model - Normalization - Security - Integrity - Consistency - Database Tuning --
Optimization and Research Issues – Design of active databases - spatio-temporal
databases - multi-media databases
UNIT III TRANSACTION PROCESSING: 9
Introduction – Properties of transaction – Serializability – Concurrency control – Locking
mechanisms – two-phase comMMF protocol – dead locks – Database recovery
UNIT IV DISTRIBUTED DATABASES: 9
Architecture- Design considerations-Interoperability Query processing - semi-joins -
query optimization - Concurrency control – transactions and Heterogeneity issues –
schema translation and schema integration
UNIT V OBJECT ORIENTED DATABASES: 9
Object-oriented data models - Object Identity and its implementation – Supporting object
modeling in database systems--Database programming and querying in object-oriented
databases - ODMG standard, including ODL, OQL – Comparing RDBMS with
OODBMS
L – 45 T – 15 Total – 60
REFERENCES:
1. Raghu Ramakrishnan, Johannes Gehrke, “Database Management Systems”, Tata
Mc- Graw Hill, New Delhi, 2004
2. Barry, Eaglestone and Mick, Ridley, ”Object Databases: An Introduction”, Tata
Mc-Graw Hill, New Delhi., 1998.
3. Mario Piattini, Oscar Diaz, “Advanced database Technology and Design”, Artech
House Publishers, Massachusetts, 2000.
4. Ozsu M. T. & Valduriez P., “Principles of Distributed Database Systems”. , Prentice
Hall, New Delhi, 1999.
No comments:
Post a Comment
Any doubt ??? Just throw it Here...