The Development of a Virtual Database and an Evaluation of Techniques to Improve the Performance of a Virtual Database

Page 8

CONTENTS ABSTRACT ................................................................................................................... iv LIST OF FIGURES........................................................................................................ix ACKNOWLEDGMENTS ............................................................................................ x 1. INTRODUCTION............................................................................................ 1 1.1 Background.................................................................................................. 1 1.2 The HELP Hospital Information System .............................................. 6 2. VIRTUAL DATABASE SYSTEMS .......................................................... 12 2.1 The Virtual-Database Concept ............................................................. 12 2.2 Previous W o rk ......................................................................................... 15 2.3 Data Storage in a Virtual Database....................................................... 17 3. A VIRTUAL DATABASE FOR HELP .................................................... 20 3.1 Overview .................................................................................................. 20 3.2 The HELP Database .............................................................................. 21 3.2 A Virtual Database for H E L P ............................................................. 23 3.3 The Components of the Virtual Database S y s tem ............................. 28 3.4 The Size of the Virtual Database Files .............................................. 30 3.5 The Operation of the Virtual Database .............................................. 32 4. THE DESIGN OF A VIRTUAL DATABASE SYSTEM....................... 35 4.1 The Physical Database Management S y s tem ..........................................36 4.2 The Backbone LAN at LDS Hospital ................................................. ....39 4.3 The VAM Process....................................................................................... 40 4.4 The PAM P ro c e ss ....................................................................................... 48 4.5 The HELP Database-Access R o u tin e s................................................. ....52 4.6 The ARZAP Process ..................................................................................54 4.7 The ARCHRC F i l e .................................................................................... 55