RAPIDS Data Model: Beginning Design

["Mark Young" <ravenhunter@qwest.net>]

Hello All,

 

I've put together an Access file containing a very basic set of core tables for beginning the RAPIDS data modelling process.  These tables are based on the NIF 3.0 hierarchy discussed at the Toronto meeting.  The design follows closely with Figure 6 in the discussion document from the meeting.

 

The link to the forum post is:

http://glin.net/forum/view.php?site=glad&bn=glad_rapids&key=1162248158

 

The contents of the tables can be seen in Design View by right clicking a table name and selecting Design View.

 

A rudimentary relationship diagram can be seen by selecting Tools/Relationships from the main menu bar.  You'll have to scroll to the right to see all the tables and relationships that are defined.

 

This is a very basic presentation of the idea.  There are many steps to this design process, and this is just the first.  The data element names in all caps are the fields that define primary key and unique key constraints.  Some of them add to or replace fields that exist in the NIF 3.0 formats.  The remaining fields are just copies of the data elements in the EPA's NIF 3.0 Access database.

 

This should give an idea of the core data model and a starting point for integrating existing RAPIDS data elements.

 

We can discuss at the next conference call.

 

Thanks,

Mark Young