META TAGS:-RGPV BHOPAL SYLLABUS I RGPV IT 7TH SEM SYLLABUS I RGPV INFORMATION TECHNOLOGY SYLLABUS I RGPV UNIVERSITY IT SYLLABUS I IT 7TH SEM ADVANCE CONCEPT IN DATABASE SYSTEM SYLLABUS I IT-710 SYLLABUS I IT 7TH SEM ELECTIVE SUBJECT LIST I RGTU IT 7TH SEM SYLLABUS I RGPV INFORMATION TECHNOLOGY IT-710 SYLLABUS I RGPV IT 7TH SEM ELECTIVE I SUBJECT LIST I
ADVANCED CONCEPT IN DATABASE SYSTEMS IT-710
Branch : Information Technology, VII Semester
Course: Advanced Concept In Database Systems
UNIT I
An overview of database:The Extended Entity Relationship Model and Object Model: The ER model revisited, Motivation for complex data types, User defined abstract data types and structured types,Subclasses,Super classes,Inheritance,Specialization and Generalization, Constraints & characteristics of specialization and Generalization,Relationship types of degree higher than two.
UNIT II
Query Processing, Optimization & Database Tuning: Algorithms For Executing Query Operations. Heuristics For Query Optimizations, Estimations of Query Processing Cost, Join Strategies for Parallel Processors, Database Workloads, Tuning Decisions, DBMS Benchmarks, Clustering & Indexing, Multiple Attribute Search Keys, Query Evaluation Plans, Pipe lined Evaluations, System Catalogue in RDBMS.
UNIT III
Distributed Database System: Structure of Distributed Database, Data Fragmentation, Data Model,Query Processing, Semi Join, Parallel & Pipeline Join, Distributed Query Processing In R * System,Concurrency Control In Distributed Database System, Recovery In Distributed Database System, Distributed Deadlock Detection and Resolution, Commit Protocols.
UNIT IV
Enhanced Data Model For Advanced Applications: Database Operating System, Introduction toTemporal Database Concepts, Spatial And Multimedia Databases, Data Mining, Active Database System,Deductive Databases, Database Machines, Web Databases, Advanced Transaction Models, Issues in Real Time Database Design.
UNIT V
Accessing databases from Web:JavaScript, JDBC, Java Servlets , database technology to Web related areas such as semi-structured databases and data integration, XML, XQuery, XPath, XML Schemas, distributed database design, distributed database transactions, and distributed query processing
REFERENCE BOOKS:
- Elmasri, Navathe, “Fundamentals of Database Systems”, Addison Wesley.
- Korth, Silbertz, Sudarshan, “ Database Concepts”, McGraw Hill.
- David M. Croenke and David J. Auer “Database Processing” Eleventh Edition, PHI
- Ramakrishnan, Gehrke, “Database Management System”, McGraw Hill.
- Peter Rob and Coronel, “Database Systems, Design, Implementation and Management”, Cengage Learning
- Data C J,” An Introduction To Database System”, Addison Wesley.
- Bernstein, Hadzilacous, Goodman, “Concurrency Control & Recovery”, Addison Wesley.
0 comments