last modified: 13-AUG-1985 | catalog | categories | new | search |

NESC9915 FRAMIS.

FRAMIS, Relational Data Base Management System

top ]
1. NAME OR DESIGNATION OF PROGRAM:  FRAMIS.
top ]
2. COMPUTERS
To submit a request, click below on the link of the version you wish to order. Only liaison officers are authorised to submit online requests. Rules for requesters are available here.
Program name Package id Status Status date
FRAMIS NESC9915/01 Tested 13-AUG-1985

Machines used:

Package ID Orig. computer Test computer
NESC9915/01 DEC VAX 11/780 DEC VAX 11/780
top ]
3. DESCRIPTION OF PROGRAM OR FUNCTION

FRAMIS is a relational database management tool that may be used to store, retrieve, and manipulate  data stored in a FRAMIS database. A FRAMIS database is a set of tables or relations. These tables normally contain information about a set of real-world entities (e.g., persons, buildings, or computers). Each table consists of one or more named columns and zero or more rows. It is sometimes convenient to think of the rows of a table as similar to records in a file and to think of the columns as fields. The columns represent attributes of the entity (e.g., for persons - name, address, and sex; or for buildings - number of rooms, year built, and location). The rows represent specific instances of the real-world entity (e.g., John Doe's name,  address, and sex or the characteristics of the house at 222 Maple Street). FRAMIS is intented to be particularly useful as an interactive management and analysis tool for scientific and engineering data.
top ]
4. METHOD OF SOLUTION:
top ]
5. RESTRICTIONS ON THE COMPLEXITY OF THE PROBLEM:
top ]
6. TYPICAL RUNNING TIME:
NESC9915/01
NEA-DB executed the test case included in this package  on a VAX-11/780 computer. The CPU time required for running the QAQA quality assurance test was 3 minutes 14 seconds.
top ]
7. UNUSUAL FEATURES OF THE PROGRAM

Relationships between tables are based on data values, not on physical connections between tables. This provides a great deal of flexibility and the ability to utilize relationships inherent within the data that may not have been known when the database was designed.
top ]
8. RELATED AND AUXILIARY PROGRAMS:
top ]
9. STATUS
Package ID Status date Status
NESC9915/01 13-AUG-1985 Tested at NEADB
top ]
10. REFERENCES

- FRAMIS, NESC No. 9915, FRAMIS Tape Directory,
  National Energy Software Center Note 83-85, August 26, 1983.
- Stephen E. Jones, Daniel R. Ries, Leonard Lyles, Ada L. Dittli,
  and Keith W. Johnson,
  FRAMIS Reference Manual,
  LCSD-554 Rec. 0, May 15, 1981.
- Stephen E. Jones, Daniel R. Ries, Leonard Lyles, Ada L. Dittli,
  Barbara L. Herron; Roger A. Skowlund, Karl Dusenbury, and Keith
  W. Johnson,
  FRAMIS Summary Sheets,
  LCSD-50 Rev. 1, May 15, 1981.
- Ada L. Dittli,
  Introduction to FRAMIS--A Tutorial,
  LCSD-555 Rev. 0, April 1, 1981.
- Daniel R. Ries, Roger A. Skowlund, and Barbara L. Herron,
  FRAMIS Report Writer,
  LCSD-556 Rev. 0, July 8, 1982.
- Daniel R. Ries, Roger A. Skowlund, and Barbara L. Herron,
  FRAMIS Report Writer Examples,
  LCSD-556a Rev. 0, July 8, 1982.
- Roger Showlund,
  FRAMIS Report Writer Tutorial,
  LCSD-557, May 11, 1982.
NESC9915/01, included references:
- Guide to Install FRAMIS on VAX.
top ]
11. MACHINE REQUIREMENTS:
NESC9915/01
Virtual memory requirements to execute the test case on a VAX-11/780 computer are 650 Kbytes.
top ]
12. PROGRAMMING LANGUAGE(S) USED
Package ID Computer language
NESC9915/01 FORTRAN+ASSEMBLER
top ]
13. OPERATING SYSTEM UNDER WHICH PROGRAM IS EXECUTED:
NESC9915/01
The test case was run on a VAX-11/780 under VAX/VMS V3.4.
top ]
14. OTHER PROGRAMMING OR OPERATING INFORMATION OR RESTRICTIONS

The design of a FRAMIS database is extremely important. One must carefully consider the entities being represented, the important attributes of those entities, and the relatioships between the entities. Information about separate entities should be stored in separate tables. Ralationships between distinct entities can be made explicit later by using FRAMIS to combine tables as required.
top ]
15. NAME AND ESTABLISHMENT OF AUTHORS

           S. Taylor, K.W. Johnson*
           Lawrence Livermore National Laboratory
           P.O. Box 808
           Livermore, California 94550
* Contact
top ]
16. MATERIAL AVAILABLE
NESC9915/01
File name File description Records
NESC9915_01.003 INFORMATION FILE 147
NESC9915_01.004 INFORMATION TO INSTALL FRAMIS ON VAX 287
NESC9915_01.005 FRAMIS REFERENCE MANUAL 4119
NESC9915_01.006 FRAMIS TUTORIAL 1801
NESC9915_01.007 FRAMIS SUMMARY 591
NESC9915_01.008 REPORT WRITER MANUAL 1276
NESC9915_01.009 REPORT WRITER TUTORIAL 1411
NESC9915_01.010 REPORT WRITER EXAMPLE 1436
NESC9915_01.011 INFORMATION ABOUT FRAMIS OUTPUT 447
NESC9915_01.012 MACRO TUTORIAL 752
NESC9915_01.013 INFORMATION ABOUT LAST MACROS IN FRAMIS 132
NESC9915_01.014 FRAMIS FORTRAN SOURCE PROGRAM 57558
NESC9915_01.015 INCLUDES FORTRAN SOURCE PROGRAM 2041
NESC9915_01.016 FRAMIS MACRO SOURCE 735
NESC9915_01.017 COMMAND TO INSTALL FRAMIS ON VAX 299
NESC9915_01.018 SPLIT1 FORTRAN SOURCE PROGRAM 47
NESC9915_01.019 SPLIT1 INPUT DATA 434
NESC9915_01.020 SPLIT2 FORTRAN SOURCE 53
NESC9915_01.021 SPLIT3 FORTRAN SOURCE 46
NESC9915_01.022 FRAMIS COMMAND TO CREATE A SAMPLE DATA BASE 64
NESC9915_01.023 ANALYSIS TABLE FILE 1079
NESC9915_01.024 SPECIMEN TABLE FILE 149
NESC9915_01.025 LOCATION TABLE FILE 29
NESC9915_01.026 CUANALY TABLE FILE 820
NESC9915_01.027 CUSPID TABLE FILE 215
NESC9915_01.028 COMMAND TO WRITE FRAMIS ON TAPE 139
NESC9915_01.029 COMMAND TO READ FRAMIS FROM TAPE 71
NESC9915_01.030 COMMAND TO DELETE FRAMIS FILES 18
NESC9915_01.031 COMMAND TO PRINT INFORMATION ON INSTALLING 22
NESC9915_01.032 COMMAND TO EXTRACT CLICHES FROM LIBRARY 21
NESC9915_01.033 COMMAND TO COMPILE 77
NESC9915_01.034 COMMAND TO EXTRACT SOURCE FROM LIBRARY 7
NESC9915_01.035 COMMAND TO RUN A TEST LINK 4
NESC9915_01.036 COMMAND TO RUN QAQA TEST 14
NESC9915_01.037 COMMAND TO RUN QAQA QUALITY ASSURANCE TEST 11
NESC9915_01.038 COMMAND TO EXTRACT QAQA TEST FILE 25
NESC9915_01.039 COMMAND TO REPLACE NEW FRAMIS EXECUTIVE 18
NESC9915_01.040 QAQA TEST FILE EX19.CMD 186
NESC9915_01.041 QAQA TEST FILE F000HSP.FRM 1218
NESC9915_01.042 QAQA TEST FILE F000LOG.FRM 1029
NESC9915_01.043 QAQA TEST FILE IOCK01.DAT 18
NESC9915_01.044 QAQA TEST FILE IOCK03.DAT 14
NESC9915_01.045 QAQA TEST FILE JELV.CMD 67
NESC9915_01.046 QAQA TEST FILE JFOR.CMD 89
NESC9915_01.047 QAQA TEST FILE JICR.CMD 17
NESC9915_01.048 QAQA TEST FILE JIII.CMD 11
NESC9915_01.049 QAQA TEST FILE JONE.CMD 134
NESC9915_01.050 QAQA TEST FILE JQAQA.CMD 110
NESC9915_01.051 QAQA TEST FILE JSVN.CMD 114
NESC9915_01.052 QAQA TEST FILE JTEN.CMD 168
NESC9915_01.053 QAQA TEST FILE JTRE.CMD 64
NESC9915_01.054 QAQA TEST FILE JTWO.CMD 70
NESC9915_01.055 QAQA TEST FILE JZERO.CMD 80
NESC9915_01.056 QAQA TEST FILE SVNCD.FMT 4
NESC9915_01.057 QAQA TEST FILE SVNFF.CMD 7
NESC9915_01.058 FRAMIS FORTRAN SOURCE WITH NO 'INCLUDE' 182597
top ]
17. CATEGORIES
  • M. Data Management

Keywords: data analysis, data base systems, data processing, information retrieval, information systems.