Fujitsu UDS/SQL V2.5 Manuale Utente
U929-J-Z125-9-76
183
D
ok
us
c
h
abl
on
en
1
9x
24 V
e
rs
ion
7
.3
us
f
ü
r F
ram
eM
ak
er
V
7
.x
v
o
m
1
4.
02
.2
00
7
©
c
o
gni
tas
Gm
b
H
20
01-
20
07
18
. Ok
tobe
r 20
07
S
ta
nd
1
1:
29
.4
9
P
fa
d:
G
:\
v
og
t\
fs
c
\ud
s
\M
anu
al
e
\e
n\
ud
s
e
nt
_e\
u
ds
ent
.k
0
6
6 Definition of the user interface to the database
6.1 Subschema DDL
6.1.1
Introduction
All data the database requires to perform its tasks must be defined in the UDS/SQL
schema. The UDS/SQL schema has no direct interface with the user, however; aspects of
user-oriented data editing must not be considered when designing the UDS/SQL schema.
schema. The UDS/SQL schema has no direct interface with the user, however; aspects of
user-oriented data editing must not be considered when designing the UDS/SQL schema.
The user interface is created when the subschema is defined. The subschema describes
that section of the schema which is adapted to the requirements of a particular application.
that section of the schema which is adapted to the requirements of a particular application.
This is advantageous in so far as the database programmer need know only that part of the
database required for a particular application. The subschema plays its part in data
protection as it prevents the user from becoming acquainted with the entire data resources
contained in the database.
database required for a particular application. The subschema plays its part in data
protection as it prevents the user from becoming acquainted with the entire data resources
contained in the database.
The following functions are available for changing the data structure of the schema to
produce a subschema data structure designed for a particular application:
produce a subschema data structure designed for a particular application:
–
exclusion of record types,
–
exclusion of sets,
–
exclusion of realms,
–
exclusion of record elements from a record type,
–
reduction of repetition factor of vectors and repeating groups,
–
grouping of record elements into new group items,
–
definition of conditions.
This chapter describes how these functions are implemented by the definition of a
subschema.
subschema.
The metalanguage used is described on
, and the general syntax rules are summa-
rized on