ARI-NTC Mission Databases (Revised for 90-01 Forward Databases) (User's Guide).

摘要

This report demonstrates the use of the U.S. Army Research Institute for the Behavioral and Social Sciences (ARI) mission databases for the National Training Center at Fort Irwin, CA. It has a general discussion of the types of data that are included in the databases, as well as general principles of variable naming. The text also contains a series of examples that use the INGRES query language to extract, categorize, and summarize data contained in the databases. It is intended as a learning guide for users of the database who wish to construct their own set of database queries associated with specific research requirements. We shall explore the principal linkages between the INGRES tables in the data base, that is the Player Identification Number (PID), Logical Player Number (LPN), and the Time of an event. It should be noted that our data bases are 'event driven', because all the entries in the Fire Event Table (FET), the Pairing Event Table (PET), and the Indirect Fire Missions Fired (IFMF) result from actions initiated in the training exercise.