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

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.E(CSN) Semester: II LP Rev. Languages and Design: ODMG Model – ODL – OQL – Object Relational and Extended – Relational Systems: Object Relational features in SQL/Oracle – Case Studies. 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.DOC/LP/01/28.02 LP. the ODMG data model. 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.14 1(404-413) BB/LCD .02. Objective: To understand and analyze the features of object oriented database systems. object query language and object relational features in SQL/Oracle. the object definition language.

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

02 LP. multimedia databases.02.Multimedia Databases.34 35 36 Text Mining. .Information Retrieval.Transaction Commit Protocols. To study about data warehousing and data mining and the differences between them.Concurrency Control . Objective: To attain exposure on mobile databases.Mobile Transaction Models -Concurrency Control .Data Mining.E(CSN) Unit syllabus: ADVANCED DATA MODELS Mobile Databases: Location and Handoff Management . No: 00 Date: 10-01-14 Semester: II Page 04 of 06 Branch: M. Information retrieval and Text mining.CP7202 LESSON PLAN Sub Code & Name: CP7202 – ADVANCED DATABASES Unit: IV ` LP Rev. 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.Text Mining.Data Warehousing.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.DOC/LP/01/28.Effect of Mobility on Data ManagementLocation Dependent Data Distribution .

02 LP.Query Languages.Cloud Based Databases: Data Storage Systems on the Cloud.CP7202 LESSON PLAN Sub Code & Name: CP7202 – ADVANCED DATABASES Unit: V ` Branch: M.Introduction to Big Data-Storage-Analysis.Web Databases. GIS. 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. Objective: To learn about XML databases.Native XML Databases. cloud based databases and big data storage analysis.Geographic Information SystemsBiological Data Management.E(CSN) Semester: II LP Rev.XML Query Languages. web databases.Query Languages 50m Internet BB/LCD 45 Introduction to Big Data-Storage-Analysis 50m Internet BB/LCD 50m .02. Understanding of the current issues in the above listed databases would enable students to carry out research work in this domain.Cloud Storage Architectures-Cloud Data Models.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. No: 00 Date: 10-01-14 Page 05 of 06 Unit syllabus: EMERGING TECHNOLOGIES XML Databases: XML-Related Technologies-XML Schema.Storing XML in Databases-XML and SQL.DOC/LP/01/28.

“Database Management Systems”. Third Edition 2004.Balasubramanian Assistant Professor / IT HOD / IT 10-01-14 10-01-14 Signature Name Designation Date .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. Henry F Korth. Prepared by Approved by Ms.J. 4.Kannan and S. No: 00 Sub Code & Name: CP7202 – ADVANCED DATABASES Branch: M. R. “Database Systems.02. Raghu Ramakrishnan. 5. Pearson Education.02 LP. S. 3. A Practical Approach to Design. Thomas Cannolly and Carolyn Begg. 2007. Fifth Edition. McGraw Hill. Elmasri.DOC/LP/01/28. C. 2006. 2007. S. Third Edition. Pearson Education / Addison Wesley. Implementation and Management”. Abraham Silberschatz.D. “Database System Concepts”. B. 2. A. Sudharshan. 2006. Pearson Education.Jayanthi Dr. ”An Introduction to Database Systems”.CP7202 LESSON PLAN LP Rev. McGraw Hill.D. Johannes Gehrke. Eighth Edition.Swamynathan. Navathe. Fifth Edition. “Fundamentals of Database Systems”.Date.