Database management systems

Databases are used within a medical context for many purposes. For example, they are used to hold patient details so they can be accessed from anywhere within a hospital or network of hospitals. With the recent improvements in image compression techniques, X-rays and scan output

5 can also be held in databases and accessed in the same way.

These multi-user databases are managed by a piece of software called a database management system (DBMS). It is this which differentiates a database from an ordinary computer file. Between the physical database itself (i.e. the data as actually stored) and the users of the system is the

10 DBMS. All requests for access to data from users — whether people at terminals or other programs running in batch — are handled by the DBMS.

One general function of the DBMS is the shielding of database users from machine code (in much the same way that COBOL shields programmers from machine code). In other words, the DBMS provides a view of the data

15 that is elevated above the hardware level, and supports user-requests such as 'Get the PATIENT record for patient Smith', written in a higher-level language.

The DBMS also determines the amount and type of information that each user can access from a database. For example, a surgeon and a hospital 20 administrator will require different views of a database.

When a user wishes to access a database, he makes an access request using a particular data-manipulation language understood by the DBMS. The DBMS receives the request, and checks it for syntax errors. The DBMS then inspects, in turn, the external schema, the conceptual schema, and

25 the mapping between the conceptual schema and the internal schema. It then performs the necessary operations on the stored data.

In general, fields may be required from several logical tables of data held in the database. Each logical record occurrence may, in turn, require data from more than one physical record held in the actual database. The

30 DBMS must retrieve each of the required physical records and construct the logical view of the data requested by the user. In this way, users are protected from having to know anything about the physical layout of the database, which may be altered, say, for performance reasons, without the users having their logical view of the data structures altered.


Task 13 The steps below show how a DBMS deals with an access request. Find the relevant section in the text, then put the steps in the correct order. The DBMS: 1 inspects the mapping between the conceptual schema and internal schema 2checks for syntax errors 3 inspects the external schema 4 receives the request 5performs operations on the stored data 6inspects the conceptual schema

 
 


Task 14 Speaking The diagram below represents a simplified database. In pairs, use the diagram to explain to your partner the following: Student A:what a DBMS is and how it works Student B:how an access request is processed Try not to refer to the text. Use your own words.


Word-play

Complete the puzzle and find the key word in 12 down.


Across

1and 11The creation of an artificial environment in the memory of a

computer in which the user can apparently exist. (7,7)

2and 3The user's permitted view of the data in a database. (8,6)

4The opposite of 2. (8)

5A surgical___ is a tool used for carrying out operations. (10)

6and 10A technique for reducing the amount of space that a graphics image will use when stored in computer memory. (5,11)

7A program must be converted into this before a computer will read and process

it. (7,4)

8Programs that run ______ do not involve any terminal or user interaction.
(2-5)

9Used to describe computer systems that allow access by more than one user simultaneously. (5-4)

See 6.

See 1.

Down

12A device for sending a radio message. (11)


Language focus J