Roosevelt Platform Mound Study (RPMS): Access Database

The RMPS Database is the centralized database for project information and for excavation and laboratory results. This relational database stores two primary data types and the relationships among them. It houses RPMS provenience data (i.e., where artifacts and samples were located horizontally and vertically within the archaeological contexts). The database also contains information about the artifacts and sample collected during the archaeological investigation. The database structure centers on the specimen number and the corresponding specimen table. The specimen numbers link the provenience data to the artifact and sample data.

The database contains several principle data fields or identifiers, which are displayed in the specimen table as well as in appropriate provenience and artifact data tables. These principle identifiers are unique keys that designate specific archaeological contexts, and groups of artifacts or single artifacts associated with specific contexts.