Approved For Release 2000/08/09 : ClA-RDP96-007WWWT?9Q9A*NMENT DATE: 15 November, 1990 memorandum REPLY TO ATTH OF. DT-S SG1J suBjEcT. SUN STREAK bibliographic database - interim report (U) SG1J TO: Chief , DT-S 1. (U) The programming +or the SUN STREA[.-.': bibliographic database is Complete through the first stage. a. The "shell" programming was completed on 5 NOV 90. This "shell" is only a translator, converting Simple user requests into the complex, DBase III+ language. It allows the bibliographic database to be used by anyone, whether or not they know all the hundreds of various commands required by DBase III+. It~does not input or retrieve dataj but does act as a "controller" for the programs which do (see below). b. The "data input" programming, which allows input of bibliographic data, was completed and tied into the "shell" programming on 7 NOV 90. C. By 9 NOV 90, more than 200 bibliographic references were entered into the database, to give an initial foundation, as well as to act as a test base for the programming. d. The "data retrieval" programming, which allows retrieval of bibliographic references was completed on 9 NOV 90. Testing of this program was completely on 13 NOV 90, and the program was tied into the "shell" on 14 NOV 90. 2. (U) The'second staqel The second stage of programming will enhance the database capabilities. a. At the present time, retrieval of references can be accomplished by requesting (in part or in whole): 1) Part or all of the author's name(s). 2) Part or all of the title. 3) Part or all of the Publisher's name. 4) Date of publication. 5) Whether or not the written work is in our library. b. Sufficient "tie-in points" were provided in the initial programming to allow an additional capability which will require future OMONAL FORM NO. 10 (REV. 1-60) GSAFPMR(41CFR) t01-11-4 Approved For Release 2000/08/09 : CIA-RDP96-00789R00370MT6005-8 * GPO - 1984 0 - 461-27S (272) Approved For Release 2000108109: CIA-RDP96-00789ROO3700720005-8 (2nd stage) programming. This future capability will allow a user to request bibliographic information by subject matter (i.e. "hypnotism", "research", etc.). In order to accomplish this, 1) A final decision must be made concerning which subjects will be included in Our database. n) 4 Additional programming must be written, tested, and tied in to the "shell" program. 3) All records entered into the database at the time of tie-in must be changed and updated according to the subject matter covered by each bibliographic entry. c . The third and final staqe: Programming will eventually provide alternate 1) The present method of data retrieval allows a user to enter known information into a blank (for example "Rhine" into the author field and "Psy" into the title field). The program will retrieve, in this case, all bibliographic references which have J.B. Rhine as an author or co- author, and the letters "Psy..." in the title. 2) In the final stage of programming, a "retrieval by index" capability will be provided, where the user can cursor down through an index of subject topics. When the cursor is on the desired line of the index, a button can be pressed, and the programming will retrieve all references dealing with that subject matter. 3) This is an entirely new concept in database retrieval and no known programming presently exists to allow for this capability. Therefore, all programming in this area must be original, and must be thoroughly tested before implementation on a back-up database for initial user-testing. Once completed, it should provide the user with a method of database retrieval which is far advanced over present methods. 4) Time requirements for final implementation on the SUN STREAK database cannot presently be projected with accuracy, but should require at least an estimated month. This time estimate includes consideration for other work loads. It does not take into consideration that, as of the present time, I am on orders to be transferred to another military unit. If this does occur, the third stage of programming will have to be scrapped, unless another programmer familiar with DBa5e III+ programming can be found. SG1J SFC, USA DIA, DT-S Approved For Release 2000/08/09 : CIA-RDP96-00789ROO3700720005-8