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

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

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

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

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

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