er Se es Cre Approved For Release 2000/08/08 : CIA-RDP96-067 ExRole bf; 80001-4 Final Report - we woe 7 on ae July 1984 ~ DATA BASE MANAGEMENT FACILITY (U) ~ By: EDWIN C. MAY “a Lye Prepared. for: re we ena ete DEFENSE” INTELLIGENCE AGENCY ™ a 4 _ WASHINGTON,,.D.C... 20304... ce. se net le . SG1J Attention: ewes came - co. ao so cone wee DT-5A CONTRACT MDA908-82~C-0034 re mm - SPECIAL ACCESS PROGRAM FOR GRILL FLAME. . RESTRICT. DISSEMINATION TO ONLY.-INDIVIDUALS WITH VERIFIED ACCESS. ~~ NOT RELEASABLE TO ~~ - , . FOREIGN NATIONALS 333. Ravenswood Avenue Menlo Park, California 94025 U.S.A. (415) 326-6200 Cable: SRI INTL MPK ed For Release 2000/SBICRACIA-RDPI6-00 SERCO Ls fo 0001-4
Annrove d For Release 2000/08/08 : CIA-RDP96-QOERERDS BPP 180001-4 Final Report July 1984 Covering the period October 1982 to September 1983 DATA BASE MANAGEMENT FACILITY (U) By: EDWIN C. MAY Prepared for: DEFENSE INTELLIGENCE AGENCY Contract No: MDA908-82-C-0034 WASHINGTON, D.C. 20301 Attention: ye _ SG1J SRI Project 4028 SPECIAL ACCESS PROGRAM FOR GRILL FLAME. RESTRICT DISSEMINATION TO ONLY INDIVIDUALS WITH VERIFIED ACCESS. (< © ——) QL) (< @ J iS a Ea WN Approved by: ROBERT S, LEONARD, Director Copy No. ..s.0108 § Radio Physics Laboratory DAVID D. ELLIOTT, Vice President Research and Analysis Division SRI/GF-0256 This document consists of 76 pages. CLASSIFIED BY: DT-5A REVIEW ON: 31 July 2004 NOT RELEASABLE TO 77 [1\N\N SECRET FOREIGN NATIONALS (SIRE) vc: For Rid@atea2006d08/08nu CIA HRP 9G00 ZBGROO4 800-8500 1.4.A. international (415) 326-6200 * Cable: SRI INTL MPK * TWX: 910-373-2046
Approved For Release 2000/08/08 : SECRE P788R001800180001-4 CONTENTS (U) I OBJECTIVE (U). . 2... we ee ee ee ee et es 1 II TECHNICAL WORK (U) . 2... 2 2 2 we we ee we we et 3 A. Hardware (U). . 2. 1 6 1 ee we ew we we tw et te 3 B. Software (U). . 2... 1 ee ew ee et et tt et tk te 3 C. Data Bases (U). . 2... 2 ee ew ew ew ew ee et te 4 SG1A SG1A III DISCUSSION (U) ........064424- wee ee ew ee 9 APPENDICES Cc EXAMPLE OF REMOTE VIEWING TRAINING DATA BASE (U). ... C~1 Lil Approved For Release 2000/08/08 : SEGRE Fs8R001800180001-4
Approved For Release SO OKINCLASSIFIED OO” THIS PAGE INTENTIONALLY LEFT BLANK iv Approved For Release 2000/0805 N¢G:RGAIS Si balfe £s00180001-4
Approved For Release 2000/9 REECE AOSSIFRED 800180001-4 I OBJECTIVE (U) (U) The objective of the work on this task was to provide a data base management facility for the storage and management of technical and admin- istrative data for the psychoenergetic program at SRI International. 1 Approved For Release 2000/06 N CLASSIFIED, 800180001-4
Approved For Release UNCLASSIFIED 800180001-4 THIS PAGE INTENTIONALLY LEFT BLANK 2 Approved For Release 2000/08(0B NPG-RAS SPpdfep}s00180001-4
Approved For Release 2000/06 R] CL ASSiFren' 800180001-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 ail 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). 3 Approved For Release 2000/4 dN GLASSIFABD: 800180001-4
Approved For Release 2000/08/08 : SOBER FT EERO 1800180001-4 Table 1 (U) DATA BASE ACTIVITY WITHIN INFORMIX INFORMIX Subprogram Data base creation dbbuild Data base status information dbstatus 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 design--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 SGIA (3) RV-Training--administrative details of client personnel training activities. SGIA 4 Approved For Release 2000/08/08 : CIS RIP 4Z fo 7B8R001800180001-4
SG1A Approved For Release 2000/08/08 : C/E CDP F9P788R001800180001-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 1 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 5 Approved For Release 2000/08/08 : SEGARA F28R001800180001-4
Approved For Release 2000/08/08 : SEC REP tao (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 21 July 1982 on Stage 1 Phase 1 under Glass 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. 6 Approved For Release 2000/08/08 : CIDE? RRqB7B8R001800180001-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 UNCLASSIFIED 800180001-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. 9 Approved For Release 200QG4NBE Gig S94 PB 400 1800180001-4
Approved For Release "UNCLASSIFIED 800180001-4 THIS PAGE INTENTIONALLY LEET BLANK 10 Approved For Release 2000/08/p§ NEC ROS STAB D00180001-4
SG1A Approved For Release 2000/08/08 : CIA-RDP96-00788R001800180001-4 Approved For Release 2000/08/08 : CIA-RDP96-00788R001800180001-4
Approved For Release 20000BRY CLASSIFIED” 800180001-4 REMOTE VIEWING SESSIONS FOR VIEWER 743 Session Type: stage 1 phase 1 Session Feedback Protocol: Class c Date Time Site Name Latitude Longitude dm s dm s 07/09/82 1014 Mt. Annapurna 28 34 00 n 083 50 00 07/09/82 1034 Pacific Ocean 45 20 00 n 140 11 00 07/09/82 1044 Indian Ocean 05 22 00 n 055 36 00 07/09/82 1310 Matterhorn 45 59 00 n 007 39 00 07/09/82 1400 Denver ; 39 45 00 n 105 00 00 07/09/82 1407 Bay of Biscay 47 15 00 n 004 24 00 07/12/82 0847 Timor Sea 10 42 00 s 127 16 00 07/13/82 1035 Tel Aviv 32 05 00 n 034 46 00 07/14/82 0840 Dhoulaqui 28 39 OO n 083 28 00 07/14/82 0844 Washington, D.C. 38 55 00 n 077 00 00 07/14/82 1311 Boston 42 20 00 n 071 05 00 07/15/82 0901 Seoul 37 30 00 n 127 00 00 07/16/82 0910 Anchorage 61 10 00 n 150 00 00 07/19/82 1016 Windy Gap 36 13 00 n 076 27 00 07/19/82 1020 Golden Throne 35 37 00 n 076 40 00 07/19/82 1031 Cincinnati 39 10 00 n 084 30 00 07/19/82 1054 Kyoto 35 02 00 n 135 45 00 07/19/82 1100 Atlantic Ocean 14 21 00 s 010 O01 00 07/19/82 1104 Pacific Ocean 45 20 00 n 140 11 00 07/19/82 1108 Guadalajara 20 40 00 n 103 20 00 07/19/82 1119 Mt. Gerlachovsky 49 09 00 n 020 05 00 07/20/82 1507 Ulan Bator 47 54 00 n 106 52 00 07/21/82 1317 Brussels 50 50 00 n 004 21 00 07/21/82 0836 Arabian Sea 19 42 0O n 070 31 00 07/21/82 0928 Mt. Kilimanjaro 03 04 50 s 037 20 00 07/21/82 0933 Mt. St. Helens 46 12 00 n 122 11 00 07/21/82 1318 Mt. Egmont 39 18 00 s 174 05 00 n 07/21/82 1509 Brussels 50 50 00 004 21 00 C-33 Approved For Release 2000/deK=N CLASSIF IED, 800180001-4 ODO DTODARKERHWMA*AKDARADECKAO@M@OD Ea COLO