Web Based Hospital Management System-Documentation

Only available on StudyMode
  • Download(s) : 145
  • Published : October 26, 2012
Open Document
Text Preview
The Antelope Relational Database System

Datascope: A tutorial

The information in this document has been reviewed and is believed to be reliable. Boulder Real Time Technologies, Inc. reserves the right to make changes at any time and without notice to improve the reliability and function of the software product described herein. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without prior written permission of Boulder Real Time Technologies, Inc. Copyright © 2002 Boulder Real Time Technologies, Inc. All rights reserved. Printed in the United States of America. Boulder Real Time Technologies, Inc. 2045 Broadway, Suite 400 Boulder, CO 80302

CHAPTER 1

Overview
Datascope: What is it? ...............................................1 Datascope: Features ...................................................2 Datascope: What is it good for?.................................3

1

CHAPTER 2

Test Drive
What is a relational database? ...................................6 dbe: a window on a database .....................................6 Viewing a table ...........................................................7 Viewing schema information.......................................7 Performing a join........................................................9 What about the join conditions?...............................10 Arranging fields in a window....................................11 Viewing data in a record view...................................12 Other database operations .......................................13 Creating a subset view..............................................14 Using dbunjoin to create a subset database .............15 Editing a database ....................................................16 Simple graphing........................................................17 Summary ...................................................................19

5

CHAPTER 3

Schema and Data Representation
Database Descriptor Files........................................21 Representation of Fields ...........................................22 Schema Description File...........................................23 Schema Statement .....................................................23 Attribute Statement ...................................................24 Relation Statement....................................................25 Datascope Views.......................................................26 Reserved Names for Fields and Tables.....................27 A word of caution regarding id fields .......................29

21

CHAPTER 4

Basic Datascope Operations
Reading and Writing Fields and Records.................31 Deleting Records ......................................................31

31

Datascope: A Tutorial

iii

Subsets ......................................................................32 Sorts ..........................................................................32 Grouping...................................................................32 Joining Tables ...........................................................32 Inferring Join Keys ...................................................34 Inheritance of keys....................................................34 Specifying Join Keys .................................................35 Speed and efficiency..................................................35 Summary ...................................................................36

CHAPTER 5

Expression Calculator
Basic Operators and Database Fields......................38 Data Types ................................................................39 String Operations .....................................................39 Logical Operators.....................................................41 Assignments...
tracking img