CS606 ADVANCED DATABASE TECHNOLOGY

UNIT I                             RELATIONAL MODEL ISSUES                

ER Model - Normalization - Query Processing - Query Optimization - Transaction Processing - Concurrency Control - Recovery - Database Tuning.

UNIT II                           DISTRIBUTED DATABASES

Parallel Databases - Inter and Intra Query Parallelism - Distributed Database Features - Distributed Database Architecture - Fragmentation - Distributed Query Processing -Distributed Transactions Processing - Concurrency Control - Recovery - Commit Protocols.

UNIT III                         OBJECT ORIENTED DATABASES 
Introduction to Object Oriented Data Bases - Approaches - Modeling and Design - Persistence - Query Languages - Transaction - Concurrency - Multi Version Locks -Recovery - POSTGRES - JASMINE -GEMSTONE - ODMG Model.

UNIT IV                    EMERGING SYSTEMS

Enhanced Data Models - Client/Server Model - Data Warehousing and Data Mining - Web Databases - Mobile Databases- XML and Web Databases. 


UNIT V                           CURRENT ISSUES

Rules - Knowledge Bases - Active and Deductive Databases - Multimedia DatabasesMultimedia Data Structures - Multimedia Query languages - Spatial Databases. 

TEXT BOOKS:

1. Thomas Connolly and Carlolyn Begg, “Database Systems, A Practical Approach to Design, Implementation and Management”, Third Edition, Pearson Education 2003.
REFERENCES:

1. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Fifth Edition, Pearson Education, 2006.

2. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Fifth Edition, Tata McGraw Hill, 2006.

3. C.J.Date, A.Kannan, S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition, Pearson Education, 2006.

Anna university Syllabus 2008 Regulation [Computer Sciece - Embedded Systems] EMBEDDED SYSTEMS

UNIT I          EMBEDDED COMPUTING

Challenges of Embedded Systems - Embedded system design process. Embedded processors - 8051 Microcontroller, ARM processor - Architecture, Instruction sets and programming.

UNIT II                    MEMORY AND INPUT / OUTPUT MANAGEMENT

Programming Input and Output - Memory system mechanisms - Memory and I/O devices and interfacing - Interrupts handling.

UNIT III                 PROCESSES AND OPERATING SYSTEMS

Multiple tasks and processes - Context switching - Scheduling policies - Interprocess communication mechanisms - Performance issues.

UNIT IV                        EMBEDDED SOFTWARE

Programming embedded systems in assembly and C - Meeting real time constraints -Multi-state systems and function sequences. Embedded software development tools - Emulators and debuggers.

UNIT V                  EMBEDDED SYSTEM DEVELOPMENT

Design issues and techniques - Case studies - Complete design of example embedded systems.

TEXT BOOKS:

1. Wayne Wolf, “Computers as Components: Principles of Embedded Computer

          System Design”, Elsevier, 2006.

2. Michael J. Pont, “Embedded C”, Pearson Education , 2007.

REFERENCES:

1. Steve Heath, “Embedded System Design”, Elsevier, 2005.

2. Muhammed Ali Mazidi, Janice Gillispie Mazidi and Rolin D. McKinlay, The 8051

Microcontroller and Embedded Systems”, Pearson Education, Second edition,

2007.