SRI KRISHNA COLLEGE OF TECHNOLOGY

(An Autonomous Institution)

Kovaipudur, Coimbatore-641 042
DEPARTMENT OF COMPUTER SCIENCE ENGINEERING

COURSE INFORMATION

1. Academic Year : 2017-2018 (EVEN)

2. Name of faculty : Ms. P.Kalpana
3. Department : Computer Science and Engineering
4. Programme : M.E., Computer Science and Engineering
5. Class and semester : I ME CSE and Second Semester
6. Course code and title : 15PCS305 and Advanced Databases
7. Regulations : R2015
8. Core / Elective : Core
9. Contact hours : 60
10. Type of course :Conceptual and Creative
11. Number of credits :4
12. Course pre-requisites:
i. Database Management
13. Course learning objectives:
 To understand the system architecture of distributed and parallel databases
 To have a thorough knowledge about object and object relational databases
 To gain knowledge about the XML databases and multimedia databases
 To have an introductory knowledge about mobile databases and the emerging trends in the area of Data
mining and Data Warehousing.

14. Course Syllabus:

UNIT I PARALLEL AND DISTRIBUTED DATABASES 14

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 – Distributed Database Concepts - Distributed Data Storage – Distributed
Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing – Three Tier Client
Server Architecture-Case Studies

12
UNIT II 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, Languages and Design: ODMG Model – ODL – OQL – Object Relational and Extended –
Relational Systems : Object Relational features in SQL/Oracle – Case Studies.

UNIT III XML DATABASES 10

XML Databases: XML Data Model – DTD - XML Schema - XML Querying – Web Databases – JDBC –
Information Retrieval – Data Warehousing – Data Mining –Database Tuning

UNIT IV MOBILE DATABASES 12

Mobile Databases: Location and Handoff Management - Effect of Mobility on Data Management -Location
Dependent Data Distribution - Mobile Transaction Models - Concurrency Control – Transaction Commit
Protocols-Mobile Database Recovery Schemes

UNIT V MULTIMEDIA DATABASES 12

Multidimensional Data Structures – Image Databases – Text/Document Databases- Video Databases – Audio
Databases – Multimedia Database Design.

STATE OF ART (NOT FOR EXAMINATION)

JSON - Complex Event Processing - Data Stream Management System -No SQL -In memory database

TOTAL:
1.Text books and Reference book
1. R. Elmasri, S.B. Navathe, “Fundamentals of Database Systems”, Sixth Edition, Pearson
Education/Addison Wesley, 2011.

2. Thomas Cannolly and Carolyn Begg, “ Database Systems, A Practical Approach to Design,
Implementation and Management”, 5th Edition, Pearson Education, 2009.
3. Henry F Korth, Abraham Silberschatz, S. Sudharshan, “Database System Concepts”, McGraw Hill, 2010.
4. C.J.Date, A.Kannan and S.Swamynathan, “An Introduction to Database Systems”, Eighth Edition,Pearson
Education, 2006.

5. V.S.Subramanian, “Principles of Multimedia Database Systems”, Second Edition, Harcourt India Pvt Ltd., 2013.
6. Vijay Kumar, “Mobile Database Systems”, John Wiley & Sons, 2006.

2.Web References:

1. nptel.ac.in/courses/Web course.../databasemanagement%20Systems

2. http://geeksforgeeks.org/Databasemanagement/
3. https://www.coursera.org/learn/ Databasemanagement

3.Course plan:
 Text/ Video
No of cum
S. No Name of the topic Reference Lecture Ref
Hours Hours
books No
UNIT I – PARALLEL AND DISTRIBUTED DATABASES

Database System Architectures:

1 Centralized and Client-Server 1 1 1 1,2
Architectures
Server System Architectures – Parallel
2 Systems- Distributed Systems 1 2 1 1,2

Parallel Databases: I/O Parallelism – Inter

3 and Intra Query Parallelism 1 3 1 1,2

Inter and Intra operation Parallelism –

4 Distributed Database Concepts - 1 4 1 1,2

Distributed Data Storage – Distributed

5 Transactions – Commit Protocols 1 5 1 1,2

Concurrency Control – Distributed

6 1 6 1 1,2
Query Processing
7 Three Tier Client Server Architecture- 1 7 1
Case Studies
UNIT II – OBJECT AND OBJECT RELATIONAL DATABASES
Concepts for Object Databases: Object
8 Identity – Object structure 1 8 1 1,2

9 Type Constructors 1 9 1 1,2

10 Encapsulation of Operations 1 10 1 1,2

11 Methods – Persistence – Type and Class 1 11 1 1,2

12 Hierarchies – Inheritance 1 12 1 1,2

Complex Objects – Object Database

13 1 13 1 1,2
Standards.
Languages and Design: ODMG Model –
14 1 14 1 1,2
ODL

15 OQL – Object Relational and Extended 1 15 1 1,2

16 Relational Systems 1 16 1 1,2

17 Object Relational features in SQL/Oracle 17 1 1,2

18 Case Studies 1 18

UNIT III – XML DATABASES

20 XML Databases: XML Data Model 1 20 1 1,2

21 DTD - XML Schema 1 21 1 1,2

22 XML Querying 1 22 1 1,2

23 Web Databases 1 23 1 1,2

24 JDBC 1 24 1 1,2

25 Information Retrieval 1 25 1 1,2

26 Data Warehousing 1 26 1 1,2

27 Directory Structure –File Protection 1 27 1 1,2

28 Data Mining 1 28 1 1,2

29 Database Tuning 1 29 1 1,2

30 Revision and mind mapping 1 30

UNIT IV MOBILE DATABASES

Mobile Databases: Location and Handoff
31 Management 1 31 2 3

32 Effect of Mobility on Data Management 1 32 2 3

33 Location Dependent Data 1 33 2 3

34 Distribution 34
1 2 3

35 Mobile Transaction Models 1 35 2 3

36 Concurrency Control 1 36 2 3

37 Transaction Commit Protocols 1 37 2 3

38 Mobile Database Recovery Schemes 1 38 2 3

39 Revision and mind mapping 1 39

UNIT V – MULTIMEDIA DATABASES

40 Multidimensional Data Structures 1 40 2 3

41 Image Databases 1 41 2 3
 42 Text/Document Databases 1 42 2 3

43 Video Databases. 1 43 2 3

44 Audio Databases 1 44 2 3

45 Processes and Threads 1 45 2 3

46 Memory Management 1 46 2 3

47 Multimedia Database Design 1 47 2 3

48 Revision and mind mapping 1 48

Total No. of lecture hours: 60

1. Course assessment methods:

Monthly test: 20 Marks
Objective To Identify What Students Have Learned and also to identify students strength and weakness
Product Answer scripts
Frequency Monthly
Format Part –A 6 x 2 ═12 marks
Part –B 16 x 3 ═ 48 marks
Total marks ═ 60
Duration : 2 HOURS
Evaluation Based on answer given in the scripts
Criteria Pass mark – 50%
Minimum pass percentage: 80%
If not, remedial action will be taken.

Technical Assignment: 10 marks

Objective To enhance students' understanding of a particular reading
Product Hand written assignment sheets
Frequency After completing four unit
Format Logics for particular scenario
Evaluation Based on rubrics
Criteria No. of assignments: 1
Submit on or before the date of submission

Technical Presentation: 5 marks

Objective To enhance students' understanding of a particular reading
Product Presentation by students
Frequency After completing each internal test
Format Technical topics related to working of network components
Evaluation Based on Presentation given by students
Criteria No. of Evaluations: 1

Technical Quiz: 5 marks

Objective To measure and enhance knowledge of a particular reading
Product Answers of Online Test
Frequency After completing five units
Format Objective type questions
Evaluation Based on answer given by students
 Criteria No. of Evaluations: 2

End semester exam: 60 marks

Objective To assess the each student’s knowledge of the course
Product Result analysis
Frequency Semester
Format Part –A 10 x 2 ═20 marks
Part –B 5 x 16 ═ 80 marks
Total marks ═ 100
Duration : 3 Hours
Evaluation Based on answer given in the scripts
Criteria Minimum pass percentage: 80%
If not, remedial action will be taken.

2. CourseOutcomes

At the end of the course the student should be able to

 Be familiar with basic concepts and applications of database systems

 Develop a XML database
 Understand the concepts of mobile databases and its recovery schemes
 Differentiate various types of multimedia databases

Staff in-charge HOD/CSE Principal