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

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

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

40 45 LESSON PLAN LP. 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. Objective: This unit describes about the current issues while designing a different database systems.Spatial Databases.44 Multimedia Query languages 50 m BB/LCD Spatial Databases 50 m BB/LCD 39.CS2029 .Multimedia Databases– Multimedia Data Structures – Multimedia Query languages .Knowledge Bases .DOC/LP/01/28.2014 Unit: V Page 04 of 06 Branch: CS Semester: VI Unit syllabus: CURRENT ISSUES: Rules .01.Active and Deductive Databases .02. No: 00 SubCode& Name : CS2029 ADVANCED DATABASE TECHNOLOGY Date: 02.02 LP Rev.

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