Fujitsu UDS/SQL V2.5 User Manual
U929-J-Z125-9-76
9
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
24
. Ok
tobe
r 20
07
S
ta
nd
0
8:
47
.5
6
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
1
1 Preface
1.1 Brief product description
The Universal Database System UDS/SQL is a high-performance database system based
on the structural concept of CODASYL. Its capabilities, however, go far beyond those of
CODASYL as it also offers the features of the relational model. Both models can be used
in coexistence with each other on the same data resources.
on the structural concept of CODASYL. Its capabilities, however, go far beyond those of
CODASYL as it also offers the features of the relational model. Both models can be used
in coexistence with each other on the same data resources.
COBOL DML, CALL DML and (ISO standard) SQL are available for querying and updating
data. COBOL DML statements are integrated in the COBOL language; SQL statements can
be used in DRIVE programs or via an ODBC interface.
data. COBOL DML statements are integrated in the COBOL language; SQL statements can
be used in DRIVE programs or via an ODBC interface.
To ensure confidentiality, integrity and availability, UDS/SQL provides effective but flexible
protection mechanisms that control access to the database. These mechanisms are
compatible with the openUTM transaction monitor.
protection mechanisms that control access to the database. These mechanisms are
compatible with the openUTM transaction monitor.
The data security concept provided by UDS/SQL effectively protects data against
corruption and loss. This concept combines UDS/SQL-specific mechanisms such as
logging updated information with BS2000 functions such as DRV (Dual Recording by
Volume).
corruption and loss. This concept combines UDS/SQL-specific mechanisms such as
logging updated information with BS2000 functions such as DRV (Dual Recording by
Volume).
If the add-on product UDS-D is used, it is also possible to process data resources in
BS2000 computer networks. UDS/SQL ensures that the data remains consistent
throughout the network. Distributed transaction processing in both BS2000 computer
networks and networks of BS2000 and other operating systems can be implemented using
UDS/SQL together with openUTM-D or openUTM (Unix/Linux/Windows). UDS/SQL can
also be used as the database in client-server solutions via ODBC servers.
BS2000 computer networks. UDS/SQL ensures that the data remains consistent
throughout the network. Distributed transaction processing in both BS2000 computer
networks and networks of BS2000 and other operating systems can be implemented using
UDS/SQL together with openUTM-D or openUTM (Unix/Linux/Windows). UDS/SQL can
also be used as the database in client-server solutions via ODBC servers.
The architecture of UDS/SQL (e.g. multitasking, multithreading, DB cache) and its struc-
turing flexibility provide a very high level of throughput.
turing flexibility provide a very high level of throughput.