Approved For Release 2000/0^^^lA|R^>^||8|gjy 8001 80001 -4
THIS PAGE INTENTIONALLY LEFT BLANK
Approved For Release 2000/08ys^^^g^§-§jfi(g|)800180001-4
Approved For Release 2000/(|3J^g£
8001 80001-4
II
TECHNICAL WORK
(U)
A.
(U)
Hardware
(U)
The hardware
for
the Data Base Management System
(DBMS)
consists
of
a Digital Equipment Corporation LSI/23 microcomputer
(18-bit addressing)
with 256K
of
RAM,
30 Mbyte
of Winchester hard disk,
and
8 RS-232c
serial
ports.
Connected
to
these ports
are
4 VDTs
,
a dot matrix printer
(120
cps)
,
and
a letter quality printer
(30 cps).
The
system also contains
1 double-
density,
double-sided
floppy disk drive.
B.
(U)
Software
(U)
The DBMS
system software
is UNIX Version
7 under
software
license
from Santa Cruz
Operations.
The data base management software
itself
is
INFORMIX Version 3.05
from Relational Database Systems,
Inc.
(U)
In
a relational
data base,
it
is conceptually convenient
to
think
of
the data existing
in simple
tabular
form.
Each
table
and
all
columns
within that table
are assigned unique names.
Each row
in
the
table rep-
resents
a new set of data.
A collection
of
tables
containing related data
is defined
as
the data base.
(U)
How
the data
are
to be distributed among
the various
tables
is
decided during
a design phase
of
the data base creation process.
There
are
a number
of data-dependent guidelines
on
the optimal
techniques
to
accomplish
this,
which have been published
in
the general
DBMS
literature.
(U)
By
linking tables
together,
it
is
possible
to
select any
(or
all)
rows
from as many tables
as necessary
to
satisfy possibly very complex
queries
of
the data base.
It
is beyond
the
scope
of
this
report
to describe
in detail
the query formulation procedure.
(U)
INFORMIX consists
of
a number of
software packages
to allow for
the various
DBMS activities
(shown
in Table
1).
Approved For Release 2000/<U<NGLAS&llnlEDbl 8001 80001 -4
Approved For Release 2000/08/08
: CJ^^^P^^88R001 8001 80001 -4
SG1A
SG1A
Table
(U)
DATA BASE ACTIVITY WITHIN INFORMIX
Action
INFORMIX Subprogram
Data base creation
dbbuild
Data base
status
information
dbs tatus
User-friendly data base query
informer
Report generator /formatter
ace
|
Input/output screen design
perform
C
language
interface
C-callable procedures
UNCLASSIFIED
(U)
The implementation of
a DBMS
is
a 6-step procedure;
Data base des ign--logical representation of data
Implementation of design--create data base
Debug design--use test data
-
User-friendly input design-screen
input for nontechnical
personnel
Data input-load data base with all data
Report design—manipulate data
and create.
C.
(U)
Data Bases
(3)
RV-Training—administrative details
of client personnel
training activities.
Approved For Release 2000/08/08
: c£®g^-g^58R001 8001 80001 -4
SG1A
Approved For Release 2000/08/08
: qC-KDB3CCD788R001 8001 80001 -4
3.
(U)
RV-Training Data Base
(S)
The RV-Training Data Base contains
the training record
of
the
instructor and
three client-supplied
students.
The data are organized
around
the training
session.
For
each
session,
data about
the viewer,
monitor,
target
site,
session date,
and
session
time are stored.
Also,
data
are maintained
for
the feedback conditions,
the number
of observers,
the training stage,
an indication
if redirection was used during
the
session,
and
the declared
inclemency
if any.
(U)
The name,
coordinates,
location,
and source
information are
stored
for each
site.
A given
site
is also described
by
an unlimited
number
of
stage attributes,
i.e.,
a site may have
a single Stage
1 Phase
attribute
and
a
large number of
Stage
2 attributes.
(S)
Appendix
C contains
a report on
the current training status
for Viewers
2,
59,
326,
and
743.
For
each viewer,
the report displays
Approved For Release 2000/08/08
: <SfififisEJ788R001 8001 80001 -4
Approved For Release 2000/08/08
: C^I^R|^-g)|68R001 8001 80001 -4
(S)
session and site information as
a function of
session type and feedback
protocol.
For example,
Viewer
59 had
28 sessions between
9 July
1982
and
July 1982 on Stage
1 Phase
1 under Class
C conditions.
He had no
sessions
for Stage
1 Phase
1 under Class
B conditions.
Viewer
2,
however,
had
92 sessions across
a number of
stages under Class
B conditions.
Approved For Release 2000/08/08
: CI>S®6R(i7p8R001 8001 80001 -4
SG1A Approved For Release 2000/08/08 : CIA-RDP96-00788R001800180001-4 Next 1 Page(s) In Document Exempt Approved For Release 2000/08/08 : CIA-RDP96-00788R001800180001-4
Approved For Release 200'
L001 8001 80001 -4
III
DISCUSSION
(U)
(U)
The examples
that are shown
in
the appendices represent
a small
fraction of
the data contained
for
a particular data base.
As new data
are added,
a new report that reflects
the addition can be generated
in
a
matter of hours.
It requires
only
a day or
so
to design and
test new
reports
that display different aspects
of
the data for
the simpler data
bases
and correspondingly longer
for
the more complex ones.
Approved For Release 2OO(yE|^0|j
i^g
:§4|<tE0001 8001 80001^
Approved For Release 2000/0|Jj^l^F^^gj>p^<j£y 8001 80001 -4
THIS PAGE INTENTIONALLY LEFT BLANK
Approved For Release 2000/08^ NCfc^SSfPfEO6001 80001
SG1A Approved For Release 2000/08/08 : CIA-RDP96-00788R001800180001-4 Approved For Release 2000/08/08 : CIA-RDP96-00788R001800180001-4
Approved For Release 2000/08/08
: CIA-RDP96-00788R001 8001 80001 -4
UNCLASSIFIED
REMOTE
VIEWING
SESSIONS
FOR
VIEWER
Session Type
:
post-op
Session Feedback Protocol:
Class
b
Date
Time
Site
Name
Latitude
d
m
s
12/14/81
1309
Mauritius
Island
12 00
s
12/14/81
1313
Hango,
Finland
59 50 00 n
C-&
Approved For Release 2OOO/O80i|^£j*l^^^|i^lg|J8OO18OOO1-4
Longitude
d
m
s
057 33 00
023 00 00