March 13, 2010

CS 5018 – ADVANCED DATABASES SYLLABUS M.E. COMPUTER SCIENCE AND ENGINEERING ANNA UNIVERSITY TIRUCHIRAPPALLI/TRICHY


Anna University Tiruchirappalli - 620 024
Regulations 2007 Sylllabus
M.E. COMPUTER SCIENCE AND ENGINEERING
ELECTIVES Cs 5018 – ADVANCED DATABASES


UNIT I DATABASE MANAGEMENT 9
Relational Data Model – SQL – Database Design – Entity Relationship Model – Relational
Normalization – Embedded SQL – Dynamic SQL – JDBC – ODBC.

UNIT II ADVANCED DATABASES 10
Object Databases – Conceptual Object Data Model – XML and Web Data – XML Schema –
Distributed Data bases – OLAP and Data Mining – ROLAP and MOLAP

UNIT III QUERY AND TRANSACTION PROCESSING 8
Query Processing Basics – Heuristic Optimization – Cost Size Estimation – Models of Transactions
– Architecture – Transaction Processing in a Centralized and Distributed System – TP Monitor.

UNIT IV IMPLEMENTING AND ISOLATION 9
Schedules – Concurrency Control – Objects and Semantic Commutativity – Locking – Crash –
Abort and Media Failure – Recovery – Atomic Termination – Distributed Deadlock – Global
Serialization – Replicated Databases – Distributed Transactions in Real World.

UNIT V DATABASE DESIGN ISSUES 9
Security – Encryption – Digital Signatures – Authorization – Authenticated RPC – Integrity –
Consistency – Database Tuning – Optimization and Research Issues.

Total: 45

TEXT BOOK
1. Philip M. Lewis, Arthur Bernstein, Michael Kifer, “Databases and Transaction
2. Processing An Application Oriented Approach”, Addison, Wesley, 2002.

REFERENCES
1. R.Elmasri and S.B. Navathe, “Fundamentals of Database Systems”, 3rd Edition,Addison
Wesley, 2004.
2. Abraham Silberschatz, Henry F. Korth, S. Sudharsan, “Database System Concepts”, 4th
Edition., Tata McGraw Hill, 2004.
3. Raghu Ramakrishnan & Johannes Gehrke, “Database Management Systems”, 3rd Edition,
TMH, 2003.

FEEL USEFUL PLEASE GIVE +1

0 comments :

Post a Comment

Get Syllabus in your Mail

Labels

Accenture Admission Notice - 2010 Admission Notification Anna University Anna University Chennai Anna University Question Papers Anna University Trichy Apparel Technology and Management Aptitude Questions Arts and Science Colleges Biomedical Engineering C and CPP Ebooks Calicut University CBSE Question papers Civil Engineering Civil Service Exams Colleges in India Colleges Result Computer Science Engineering Core Jobs CS R2008 CSE CSIR NET EBooks Download ECE EEE EIE Electives Electrical and Electronics Engineering Electronics and communication Electronics and Instrumentation Engineering Engineering Engineering Colleges in Maharashtra Engineering Colleges in TamilNadu Engineering Admissions Engineering Colleges Engineering Colleges in Karnataka Engineering Jobs Engineering Syllabus Entrance Exam Dates Entrance Exam Results Entrance Examination Exam Time Table Experiencer First Year Syllabus Freshers Full Time Jobs Government jobs in india Hardware and Networking Jobs Hotel Management and Catering Technology IGNOU Information Technology INTEVIEW QUESTIONS IT Jobs JNTU Question Papers Jobs in Bangalore Jobs in Chennai Jobs in Coimbatore Jobs in Delhi Jobs in Hyderabad Jobs in India Jobs in Kerala Jobs in Noida Jobs in Tamilnadu Jobs in TATA Karnataka Educations Lab Manuals Mechanical Engineering Medical Colleges Placement Papers Plus 2 Preparation for exams Private Jobs in India Question Papers Question Papers Download Results Announcement Semester 1 Semester 2 Semester 3 Semester 4 Semester 5 Semester 6 Semester 7 Semester 8 Syllabus Syllabus Download Tamil Movie TCS Placement Papers Teaching Jobs TECH MAHINDRA Textile Technology Top colleges University Results UPSC VICEVESVARAYA TECHNOLOGICAL UNIVERSITY waec Walk-in Interview Web Designers

Followers

Archive

 

Privacy Policy
http://topengineeringcollegesintamilnadu.blogspot.com use third-party advertising companies to serve ads when you visit our website. These companies may use information (not including your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice and to know your choices about not having this information used by these companies, click here.