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

No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Unit: II Branch: CS Semester: VI Date: 02.CS2029 LESSON PLAN LP Rev. 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.DOC/LP/01/28.01.02 LP. 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 .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.02. Objective: This unit deals with distributed databases and its architecture.

Approaches .Transaction .Concurrency – Multi Version Locks – Recovery – POSTGRES – JASMINE – GEMSTONE .Persistence – Query Languages .CS2029 LESSON PLAN LP Rev.02. 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 .02 LP.Modeling and Design . No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Unit: III Branch: CS Semester: VI Date: 02.2014 Page 01 of 06 Unit syllabus: OBJECT ORIENTED DATABASES: Introduction to Object Oriented Data Bases .DOC/LP/01/28.01.ODMG Model. Objective: This unit describes about the object oriented databases and locks with POSTGRES.

Client/Server Model . Objective: In this Unit the students obtain knowledge about the emerging database models like clientserver models.34 LESSON PLAN LP.XML and Web Databases. 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. No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Unit: IV Branch: CS Semester: VI Date: 02.02 LP.2014 Page 04 of 06 Unit syllabus: EMERGING SYSTEMS: Enhanced Data Models .01.Data Warehousing and Data Mining . data warehousing and data mining.30 33.DOC/LP/01/28.02.Web Databases – Mobile Databases.CS2029 .CS2029 LESSON PLAN LP Rev.

DOC/LP/01/28.01.02. 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. 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.CS2029 .Knowledge Bases .2014 Unit: V Page 04 of 06 Branch: CS Semester: VI Unit syllabus: CURRENT ISSUES: Rules .Multimedia Databases– Multimedia Data Structures – Multimedia Query languages .Active and Deductive Databases .02 LP Rev.Spatial Databases.40 45 LESSON PLAN LP. Objective: This unit describes about the current issues while designing a different database systems.

Tata McGraw Hill. Henry F.Date. Prepared by Approved by Signature Name Mr. C. Sudharshan. R. Govindarajalu Designation Assistant Professor/ CS HOD/ CS Date 02. Pearson Education.Swamynathan. Navathe. A. Sakthivel Mr. Thomas Connolly and Carlolyn Begg. “An Introduction to Database Systems”. 2006. Abraham Silberschatz. “Database System Concepts”. Implementation and Management”. Pearson Education.DOC/LP/01/28. S.01.B. Pearson Education 2003. A Practical Approach to Design.V Branch: CS Semester: VI Date: 02. 3.III. Korth.01. S. Elmasri.E. B. 2006. 4. Fifth Edition.02 LP Rev. “Fundamentals of Database Systems”.01. No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Unit: I. Third Edition. S.J.II. REFERENCES: 2.2014 .02.2014 02. “Database Systems. Fifth Edition.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. Eighth Edition.Kannan. 2006.IV.