You are on page 1of 6

DOC/LP/01/28.02.

02

LP- CP7202

LESSON PLAN
Sub Code & Name: CP7202 – ADVANCED DATABASES
`
Unit syllabus:

Unit: I

Branch: M.E(CSN)

Semester: II

LP Rev. No: 00
Date: 10-01-14
Page 01 of 06

PARALLEL AND DISTRIBUTED DATABASES
Database System Architectures: Centralized and Client-Server Architectures – Server System
Architectures – Parallel Systems- Distributed Systems – Parallel Databases: I/O Parallelism – Inter and
Intra Query Parallelism – Inter and Intra operation Parallelism – Design of Parallel Systems- Distributed
Database Concepts - Distributed Data Storage – Distributed Transactions – Commit Protocols –
Concurrency Control – Distributed Query Processing – Case Studies
Objective:
To understand and learn the differences between distributed databases, parallel databases and centralized
databases, the architecture of distributed and parallel databases, query processing techniques, transaction
processing techniques and recovery of distributed databases.
Session
No

Topics to be covered

Time

Ref
(page numbers)

Teaching
Method

1

Database System Architectures: Centralized and
Client-Server Architectures – Server System
Architectures

50m

3 (683-690)

BB/LCD

2

Parallel Systems- Distributed Systems

50m

3 (691-700)

BB/LCD

50m

3(755-762)

BB/LCD

50m

3(762-773)

BB/LCD

100m

3(709-722)

BB/LCD

3
4
5,6

Parallel Databases: I/O Parallelism – Inter and
Intra Query Parallelism
Inter and Intra operation Parallelism – Design of
Parallel Systems
Distributed Database Concepts - Distributed
Data Storage – Distributed Transactions–
Commit Protocols

7

Concurrency Control

50m

3(722-730)

BB/LCD

8

Distributed Query Processing- Case Studies

50m

3(735-738)

BB/LCD

Objective: To understand and analyze the features of object oriented database systems. Languages and Design: ODMG Model 50m 1(385-398) BB/LCD 12 The Object Definition Language (ODL) 50m 1(399-404) BB/LCD The Object Query Language (OQL) 100m 15 Introduction to Object Relational and Extended – Relational Systems 50m 1(445-448) BB/LCD 16 Object Relational features in SQL/Oracle 50m 1(448-457) BB/LCD 17 Case Studies 50m 1(458-462) BB/LCD 13. object query language and object relational features in SQL/Oracle.E(CSN) Semester: II LP Rev. the ODMG data model.02 LP. No: 00 Date: 10-01-14 Page 02 of 06 Unit syllabus: OBJECT AND OBJECT RELATIONAL DATABASES Concepts for Object Databases: Object Identity – Object structure – Type Constructors – Encapsulation of Operations – Methods – Persistence – Type and Class Hierarchies – Inheritance – Complex Objects – Object Database Standards.CP7202 LESSON PLAN Sub Code & Name: CP7202 – ADVANCED DATABASES Unit: II ` Branch: M. the object definition language.14 1(404-413) BB/LCD . Session No Topics to be covered Time Ref (page numbers) Teaching Method 9 Concepts for Object Databases: Object Identity – Object structure – Type Constructors 50m 1(359-369) BB/LCD 10 Type and Class Hierarchies – Inheritance – Complex Objects 50m 1(369-379) BB/LCD 11 Object Database Standards.DOC/LP/01/28.02. Languages and Design: ODMG Model – ODL – OQL – Object Relational and Extended – Relational Systems: Object Relational features in SQL/Oracle – Case Studies.

Applications.Implementation of Rules and Recursion.Temporal Databases: Overview of Temporal Databases.02 LP.Taxonomy.TSQL2.Applications.Spatial Relationships Spatial Data Structures-Spatial Access Methods Spatial DB Implementation.Recursive Queries in SQL.DOC/LP/01/28. Oracle.Design Principles for Active Rules 50m 1(739-744) BB/LCD 20 Temporal Databases: Overview of Temporal Databases. Session No Topics to be covered Time Ref (page numbers) Teaching Method 18 Active Databases: Syntax and Semantics (Starburst. 50m 1(802-820) 5(817-829) BB/LCD 100m 1(820-836) 5(829-838) BB/LCD 50m 8(865-870) BB/LCD 50m 6(846-869) 8(842-849) 6(870-879) 8(842-849) 22.Spatial DatabasesSpatial Data Types.E(CSN) ` Unit syllabus: INTELLIGENT DATABASES Semester: II LP Rev. To gain knowledge on temporal and spatial databases and their implementation.Design Principles for Active Rules. DB2) 50m 1(734-739) BB/LCD 19 Taxonomy.Spatial Relationships.Spatial Data Structures-Spatial Access Methods. Oracle.Recursive Rules-Syntax and Semantics of Datalog Languages.Spatial DB Implementation.Deductive Databases: Logic of Query Languages – Datalog. No: 00 Date: 10-01-14 Page 03 of 06 Active Databases: Syntax and Semantics (Starburst.23 24 25 26 27 Deductive Databases: Logic of Query Languages – Datalog. DB2).Spatial Data Types. 50m 50m 8(886-890) BB/LCD BB/LCD BB/LCD .CP7202 LESSON PLAN Sub Code & Name: CP7202 – ADVANCED DATABASES Unit: III Branch: M.Recursive Rules Syntax and Semantics of Datalog LanguagesImplementation of Rules and RecursionRecursive Queries in SQL Spatial Databases.02.TSQL2. 50m 1(744-757) BB/LCD 21 Temporal Databases: TSQL2. Objective: To understand the basics of active and deductive databases.

Session No Topics to be covered Time Ref (page numbers) Teaching Method 28 Mobile Databases: Location and Handoff Management 50m 1(886-890) BB/LCD 29 Effect of Mobility on Data ManagementLocation Dependent Data Distribution 50m Internet BB/LCD 30 Mobile Transaction Models.Data Mining.Transaction Commit Protocols 50m Internet BB/LCD 31 Multimedia Databases 50m 1(880-886) 3(877-880) BB/LCD 32 Information Retrieval 50m 3(846-856) BB/LCD Data Warehousing 100m 1(842-855) 3(842-845) BB/LCD Data Mining 50m 1(855-870) 3(830-842) BB/LCD 50m 3(759-771) BB/LCD 33.Data Warehousing. .Multimedia Databases. multimedia databases.02 LP.02. Information retrieval and Text mining. To study about data warehousing and data mining and the differences between them.Information Retrieval. Objective: To attain exposure on mobile databases.Effect of Mobility on Data ManagementLocation Dependent Data Distribution .DOC/LP/01/28.CP7202 LESSON PLAN Sub Code & Name: CP7202 – ADVANCED DATABASES Unit: IV ` LP Rev.E(CSN) Unit syllabus: ADVANCED DATA MODELS Mobile Databases: Location and Handoff Management .Mobile Transaction Models -Concurrency Control .Concurrency Control . No: 00 Date: 10-01-14 Semester: II Page 04 of 06 Branch: M.Text Mining.Transaction Commit Protocols.34 35 36 Text Mining.

Biological Data Management 50m 5(998-999) 5(999-1000) BB/LCD 42 Cloud Based Databases: Data Storage Systems on the Cloud 50m Internet BB/LCD 43 Cloud Storage Architectures Internet BB/LCD 44 Cloud Data Models.Query Languages.Cloud Based Databases: Data Storage Systems on the Cloud.Web Databases. web databases. No: 00 Date: 10-01-14 Page 05 of 06 Unit syllabus: EMERGING TECHNOLOGIES XML Databases: XML-Related Technologies-XML Schema.02. cloud based databases and big data storage analysis.Cloud Storage Architectures-Cloud Data Models.Geographic Information SystemsBiological Data Management. GIS.XML Query Languages.Storing XML in Databases-XML and SQL.E(CSN) Semester: II LP Rev. Understanding of the current issues in the above listed databases would enable students to carry out research work in this domain.Introduction to Big Data-Storage-Analysis.DOC/LP/01/28. Objective: To learn about XML databases. Session No Topics to be covered Time Ref (page numbers) Teaching Method 37 XML Databases: XML-Related TechnologiesXML Schema 50m 3(367-372) BB/LCD 38 XML Query Languages 50m 5(948-952) BB/LCD 39 Storing XML in Databases-XML and SQLNative XML Databases 50m 4(811-819) 5(952-956) BB/LCD 40 Web Databases 50m 1(874-880) BB/LCD 41 Geographic Information Systems.02 LP.Query Languages 50m Internet BB/LCD 45 Introduction to Big Data-Storage-Analysis 50m Internet BB/LCD 50m .CP7202 LESSON PLAN Sub Code & Name: CP7202 – ADVANCED DATABASES Unit: V ` Branch: M.Native XML Databases.

Fifth Edition. “Database Systems.DOC/LP/01/28. Elmasri. A. McGraw Hill. Fifth Edition. Third Edition 2004. 2006. Third Edition. Eighth Edition. “Fundamentals of Database Systems”. B. Abraham Silberschatz. Sudharshan. Navathe. A Practical Approach to Design. Prepared by Approved by Ms. “Database Management Systems”. C. 2007. R.Swamynathan. Henry F Korth. Johannes Gehrke.Balasubramanian Assistant Professor / IT HOD / IT 10-01-14 10-01-14 Signature Name Designation Date .02.E(CSN) ` Date: 10-01-14 Page 06 of 06 Semester: II Course Delivery Plan: Week 1 I II 1 Units 2 3 4 5 6 7 8 I II I II I II 2 I II I II I II 3 I II 9 10 11 12 13 14 15 I II I II 4 I II 5 I II I II I II I II REFERENCES : 1. No: 00 Sub Code & Name: CP7202 – ADVANCED DATABASES Branch: M. ”An Introduction to Database Systems”. 2006.02 LP. S. Pearson Education. “Database System Concepts”.D.Date. 5. 3.Kannan and S. S.D.CP7202 LESSON PLAN LP Rev. Pearson Education / Addison Wesley.J. Raghu Ramakrishnan. Implementation and Management”. Pearson Education. 4. 2007. 2.Jayanthi Dr. McGraw Hill. Thomas Cannolly and Carolyn Begg.