Page 239 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database Manmohan Sharma, Lovely Professional University

Notes Unit 14: Application Development and
Administration

CONTENTS
Objectives

Introduction
14.1 Database and the Web

14.2 Web Interface to Databases
14.2.1 Server Side Database Communication with CGI
14.2.2 Chains of Communication
14.2.3 Using Perl 5 and the DBI Module to Communicate with Databases

14.2.4 The DBI Module
14.2.5 The DBI API
14.2.6 Getting the Pieces

14.2.7 Running CGI Applications on a Single Station Local Area Network
14.3 Data Administrator’s Role and Functions
14.4 Accessing Database through Web

14.5 Performance Tuning
14.6 Summary
14.7 Keywords

14.8 Self Assessment
14.9 Review Questions
14.10 Further Readings

Objectives

After studying this unit, you will be able to:
 Discuss the web interface to databases
 Identify data administrator role and functions

 Know how to access database through web
 Explain performance tuning

Introduction

What is a Database?
Once upon a time, in the primitive and barbarian days before computers, the amount of
information shepherded by a group of people could be collected in the wisdom and the stories

232 LOVELY PROFESSIONAL UNIVERSITY