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:
- 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 |
Comments