You are on page 1of 6

DOC/LP/01/28.02.

02

LP- CS2029

LESSON PLAN

LP Rev. No: 00
SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY
Unit: I

Branch: CS

Date: 02.01.2014
Page 01 of 06

Semester: VI

Unit syllabus:
RELATIONAL MODEL ISSUES
ER Model - Normalization – Query Processing – Query Optimization – Transaction Processing Concurrency Control – Recovery - Database Tuning.

Objective:
This unit deals with the fundamentals of database management systems.
Session
No

Time

References

Teaching
Method

ER Model

50 m

3

BB/LCD

Normalization

50 m

3

BB/LCD

4

Query Processing

50 m

2

BB/LCD

5

Query Optimization

50 m

3

BB

6

Transaction Processing

50 m

3

BB

7

Concurrency Control

50 m

4

BB

8

Recovery

50 m

3

BB/LCD

9

Database Tuning

50 m

3

BB

1
2,3

Topics to be covered

2014 Page 01 of 06 Unit syllabus: 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. Objective: This unit deals with distributed databases and its architecture. No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Unit: II Branch: CS Semester: VI Date: 02. Session No Topics to be covered Time References Teaching Method 10 Parallel Databases 50 m BB 11 Inter and Intra Query Parallelism 50 m BB/LCD 12 Distributed Database Features.01.CS2029 LESSON PLAN LP Rev. Distributed Database Architecture 50 m BB 13 Fragmentation 50 m BB 14 Distributed Query Processing 50 m BB 15 Distributed Transactions Processing 50 m BB/LCD 16 Concurrency Control 50 m BB 17 Recovery 50 m BB/LCD 18 Commit Protocols 50 m BB .02.DOC/LP/01/28.02 LP.

ODMG Model.DOC/LP/01/28.01.02.02 LP.Concurrency – Multi Version Locks – Recovery – POSTGRES – JASMINE – GEMSTONE . No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Unit: III Branch: CS Semester: VI Date: 02.Modeling and Design .CS2029 LESSON PLAN LP Rev. Session No Topics to be covered Time References Teaching Method 19 Introduction to Object Oriented Data Bases 50 m BB 20 Approaches Modeling and Design 50 m BB/LCD 21 Persistence 50 m BB 22 Query Languages 50 m BB/LCD 23 Transaction Concurrency 50 m BB 24 Multi Version Locks Recovery 50 m BB/LCD 25 POSTGRES 50 m BB 26 JASMINE 50 m BB 27 GEMSTONE ODMG Model 50 m BB/LCD . Objective: This unit describes about the object oriented databases and locks with POSTGRES.Transaction .2014 Page 01 of 06 Unit syllabus: OBJECT ORIENTED DATABASES: Introduction to Object Oriented Data Bases .Approaches .Persistence – Query Languages .

Data Warehousing and Data Mining . No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Unit: IV Branch: CS Semester: VI Date: 02.34 LESSON PLAN LP.DOC/LP/01/28.Client/Server Model .CS2029 LESSON PLAN LP Rev.02.XML and Web Databases.01.Web Databases – Mobile Databases. Objective: In this Unit the students obtain knowledge about the emerging database models like clientserver models.2014 Page 04 of 06 Unit syllabus: EMERGING SYSTEMS: Enhanced Data Models .30 33.02 LP. Session No 28 Topics to be covered Time References Teaching Method Enhanced Data Models 50 m BB Client/Server Model 50m BB/LCD 31 Data Warehousing and Data Mining 50 m BB/LCD 32 Web Databases 50 m BB Mobile Databases 50 m BB 35 XML Databases 50 m BB/LCD 36 Web Databases 50 m BB 29. data warehousing and data mining.CS2029 .

02 LP Rev.Knowledge Bases .01. Objective: This unit describes about the current issues while designing a different database systems.40 45 LESSON PLAN LP. No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Date: 02.44 Multimedia Query languages 50 m BB/LCD Spatial Databases 50 m BB/LCD 39.DOC/LP/01/28.2014 Unit: V Page 04 of 06 Branch: CS Semester: VI Unit syllabus: CURRENT ISSUES: Rules .CS2029 .Multimedia Databases– Multimedia Data Structures – Multimedia Query languages .Active and Deductive Databases .Spatial Databases.02. Session No Topics to be covered Time References Teaching Method 37 Rules 50 m BB/LCD 38 Knowledge Bases 50 m BB Active and Deductive Databases 50 m BB/LCD 41 Multimedia Databases 50 m BB 42 Multimedia Data Structures 50 m BB/LCD 43.

Fifth Edition. Pearson Education 2003.2014 Page 06 of 06 Course Delivery Plan: Week 1 I II Units 2 3 4 5 I II I II I II 2 I II 1 6 7 I II I II 3 8 9 I II I II 4 10 11 12 13 14 15 I II I II 5 I II I II I II I II CAT-II CAT-III TEXT BOOKS: 1. 2006. Pearson Education.E. Implementation and Management”.II. Navathe. Elmasri.DOC/LP/01/28.IV.J.III. A. “Fundamentals of Database Systems”. B. R. Henry F.V Branch: CS Semester: VI Date: 02. 3.2014 . “An Introduction to Database Systems”. Prepared by Approved by Signature Name Mr. Third Edition. REFERENCES: 2. A Practical Approach to Design.01. S. 2006. Pearson Education. Tata McGraw Hill. Abraham Silberschatz.02 LP Rev. C. 2006.2014 02. “Database System Concepts”. Govindarajalu Designation Assistant Professor/ CS HOD/ CS Date 02. Korth. Sakthivel Mr. S.01. No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Unit: I.Date. S.B.02.Swamynathan.01. “Database Systems. Thomas Connolly and Carlolyn Begg. 4. Fifth Edition.Kannan. Eighth Edition. Sudharshan.