Page 148 - DMGT505_MANAGEMENT_INFORMATION_SYSTEM

Pooja, Lovely Professional University Unit 8: Databases and Data Warehouses

Unit 8: Databases and Data Warehouses Notes

CONTENTS
Objectives
Introduction
8.1 Database
8.2 Traditional vs Database Approach
8.2.1 Files: The Traditional Approach
8.2.2 Database – The Modern Approach
8.3 Database Models
8.3.1 Relational Model
8.3.2 Object-oriented Model
8.3.3 Relational Operations SQL
8.3.4 Data Modelling
8.3.5 Hierarchical Model
8.3.6 Network Model
8.4 Database on the Web
8.4.1 Web Database
8.4.2 Daffodil DB: A Web Database
8.4.3 PHP
8.4.4 PHP and Daffodil DB: Together?
8.5 Data Warehousing
8.5.1 Characteristics of Data Warehouse
8.5.2 What is a Data Warehouse?
8.5.3 Use of Data Warehouses in Organizations
8.5.4 Need to Build a Data Warehouse
8.6 Summary
8.7 Keywords
8.8 Review Questions
8.9 Further Readings

Objectives

After studying this unit, you will be able to:
 Understand the concept of databases
 Differentiate between Traditional and Database Approach

 Explain Database Model and Relational Model
 Discuss Object Oriented Model
 Recognize Relational Operations SQL
 Understand Data Modelling
 Discuss Database on the Web
 Explain Data Warehousing

LOVELY PROFESSIONAL UNIVERSITY 143