Advanced Database Management System Diploma in Information Science & Engineering 6th sem

 

Govt. of Karnataka,   Department of Technical Education

Diploma in   Information Science & Engineering

Sixth Semester

Subject: Advanced Database Management System

 

Contact: Hrs / week: 4                                                                                      Total hrs: 64

Table of Contents

 

SN

Chapter

Hours

Marks

1

Distributed DBMS-Concepts & Designing

10

25

2

Replication and mobile database

8

20

3

Introduction to object DBMS

6

15

4

Object oriented DBMS Concepts

6

15

5

Web technology in DBMS

8

20

6

Data warehousing concepts

10

25

7

Data Mining

8

20

8

Seminars, Guest Lectures and other innovation interactions

5

 

9

Tests

3

 

Total

64

140

 

 

 

 

 

 

Detailed Contents

1

 

Distributed DBMS(DDBMS ) -Concepts & Designing

1.1

 

Introduction

 

1.1.1

Concepts

 

1.1.2

Advantages & dis advantages of DDBMSs

 

1.1.3

 Homogeneous & heterogeneous DDBMSs

1.2

 

Functions and architectures of a DDBMS

 

1.2.1

Functions of a DDBMS

 

1.2.2

Reference architecture for a DDBMS

 

1.2.3

Reference architecture for a federated MDBS

 

1.2.4

Component  architecture for a DDBMS

1.3

 

Distributed relational database Design

 

1.3.1

Data allocation

 

1.3.2

Fragmentation

1.4

 

Transparencies in a DDBMS

 

1.4.1

Distribution transparency

 

1.4.2

Transaction transparency

 

1.4.3

Performance transparency

 

1.4.4

DBMS transparency

2

 

Replication and mobile database

2.1

 

Introduction to database replication

2.2

 

Benefits of database replication

2.3

 

Applications of replication

2.4

 

Basic components  of database replication

2.5

 

database replication environment

 

2.5.1

Synchronous & Asynchronous  replication

 

2.5.2

Data ownership

2.6

 

 Replication servers

 

2.6.1

Replication  server  functionality

 

2.6.2

Implementation issues

2.7

 

Introduction to mobile databases

 

2.7.1

Mobile DBMS

3

 

Introduction to object DBMS

3.1

 

 Advanced database application

3.2

 

Weakness of RDBMS

3.3

 

Objected oriented concepts

 

3.3.1

Abstraction, encapsulation & Information ID

 

3.3.2

Objects & Attributes

 

3.3.3

Object identity

 

3.3.4

Methods & messages

 

3.3.5

Classes

 

3.3.6

Subclasses, super classes  & Inheritance

 

3.3.7

Overriding & overloading

 

3.3.8

Polymorphism & dynamic binding

 

3.3.9

Complex objects

3.4

 

Storing objects in a relational database

 

3.4.1

Mapping classes to relations

 

3.4.2

Accessing objects in the relational database

3.5

 

Object oriented database design

 

3.5.1

Comparison of object-oriented  data modeling & conceptual data modeling

 

3.5.2

Relationships & referential integrity

 

3.5.3

Behavioral design

4

 

Object oriented DBMS Concepts

4.1

 

 Introduction to Object oriented Data models & OODBMSs

 

4.1.1

Definition of objected oriented DBMSs

 

4.1.2

Functional data model

 

4.1.3

Persistence programming languages

 

4.1.4

Object oriented database system manifesto

4.2

 

Issues in OODBMS

 

4.2.1

Transactions

 

4.2.2

Versions

 

4.2.3

Schema evolution

 

4.2.4

Architecture

 

4.2.5

Benchmarking

4.3

 

Advantages & Disadvantages of OODBMS

 

4.3.1

Advantages

 

 

Dis-advantages

5

 

Web technology in DBMS

5.1

 

Introduction to the internet and web

 

5.1.1

Intranets & extranets

 

5.1.2

E-commerce & e-business

5.2

 

The Web

 

5.2.1

Hyper text transfer protocol

 

5.2.2

Hyper text markup languages

 

5.2.3

Uniform resource locators

 

5.2.4

Static & dynamic web pages

 

5.2.5

Webservers

 

5.2.6

Requirements for web DBMS integration

 

5.2.7

Advantages & disadvantages of the web DBMS approach

 

5.2.8

Approaches to integrating the web & DBMSs

6

 

Data warehousing concepts

6.1

 

Introduction to data warehousing

 

6.1.1

The evolution of data warehousing

 

6.1.2

Data warehousing concepts

 

6.1.3

Benefits of data warehousing

 

6.1.4

Problems of data warehousing

6.2

 

Data warehouse  architecture

 

6.2.1

Operational data

 

6.2.2

Operational data store

 

6.2.3

Load manager

 

6.2.4

Warehouse manager

 

6.2.5

Query manager

 

6.2.6

Detailed data

 

6.2.7

Lightly & highly summarized data

 

6.2.8

Archive /backup data

 

6.2.9

Meta data

 

6.2.10

End-User access  tools

6.3

 

Data warehouse data flows

 

6.3.1

Inflow

 

6.3.2

Up flow

 

6.3.3

Down flow

 

6.3.4

Out flow

 

6.3.5

Meta flow

6.4

 

data warehousing tools & technologies

 

6.4.1

Extraction, cleansing & transformation tools

 

6.4.2

Data warehouse DBMS

 

6.4.3

Data warehouse metadata

 

6.4.4

Administration & management tools

7

 

 Data Mining

7.1

 

Introduction to Data mining 

7.2

 

Data mining techniques

 

7.2.1

Predictive modeling

 

7.2.2

Data segmentation

 

7.2.3

Link analysis

 

7.2.4

Deviation detection

7.3

 

The data mining process

 

7.3.1

The CRISP-DM  Model

7.4

 

Data mining tools

7.5

 

Data mining & data warehousing

 

 

 

 

Text book:

  1. Database System , A practical approach to design, implementation & management  . 4th edition,  Thomas Connolly & Carolyn Begg , Pearson Publications  ISBN- 9788131720257

 

Reference Book:

1.   Fundamentals of Database Systems, 5th edition, Ramez Elmasri, Shamkan B.    Navathe, Pearson Education, ISBN- 9788131716250

           Refer :

 

Chapter No: 1

 (Page no:687-699,703-728)

Chapter No: 2

 (Page no:780-794)

Chapter No: 3

 (Page no:803-828,830-836)

Chapter No: 4

 (Page no:847-859, 871-885)

Chapter No: 5

 (Page no:993-1011)

Chapter No: 6

 (Page no:1149-1171)

Chapter No: 7

 (Page no:1233-1242)

 

 

 

 

 

 

 

 

 

General Objectives:

After the completion of the study of this subject students should be able to

1.                  Understand the concepts of Distributed DBMS(DDBMS )  & its  Design

2.                  Appreciate  the concepts of   Replication and  mobile database

3.                  Understand the concepts of object DBMS

4.                  Understand the concepts of  Object oriented DBMS Concepts

5.                  Understand the  concepts Web technology in DBMS

6.                  Understand the concepts of Data warehousing

7.                  Understand the concepts of Data Mining

 

Specific Objectives:

1

Distributed DBMS(DDBMS ) -Concepts & Designing

 

Learn the  concepts of  DDBMS, advantages and disadvantages of DDBMS  , Homogeneous & heterogeneous DDBMSs  ,its Functions & architecture.

 

Learn  the reference architecture for a DDBMS & federated MDBS, component architecture for a DDBMS

 

Under stand  the distributed relational database design , data location & fragmentation

 

Learn about Transparencies in a DDBMS like  Distribution transparency, Transaction transparency, Performance transparency,  DBMS transparency

2

Replication and mobile database

 

A brief knowledge of replication & mobile database

3

Introduction to object DBMS               

 

Know about  object DBMS & its application

4

Object oriented DBMS Concepts

 

Learn about objected oriented DBMS concepts

5

Web technology in DBMS

 

Brief Knowledge of  Internet and web.

 

Learn about  HTTP, HTML,  URL ,Static and Dynamic  web pages& web services 

 

Know about   requirement for web-DBMS Integration & its advantages and disadvantages

6

Data warehousing concepts

 

Know about data warehousing concepts & benefits

7.

Data Mining

7.1

Introduction to data mining & its techniques

 

 

Related Posts Plugin for WordPress, Blogger...