Red Alder Database Project

1
Red Alder Database Project

• Progress as of September 15, 2003

2
Steps for Database Assembly

• Define Logical Data Model
• Assemble Various Datasets and Documentation
• Reconcile Dataset Structure with Logical Data
  Model
• Load Data into Database
• Define and Test Standard Recoveries
• Distribute Database

3
Define Logical Data Model

• SMC Data Model to Serve as Template
• Any Modifications to Data Model will Depend on
  the Data and Documentation

4
SMC Database Model

• Project
• Installation
• Plot Description
• Plot Measurement / Treatment Dates
• Tree Description
• Tree Measurements

5
Dataset Assembly

• Documented Datasets Received From Weyerhaeuser,
  Rayonier, and Hardwood Siviculture Cooperative.
• Documented Datasets enroute from BC MOF and USFS.
• Currently Reconciling Dataset Documentation with
  Datasets

6
Reconciling Data Structure with Model

• Reviewing Datasets and Documentation
• Underway Completion depends on final arrival of
  datasets and response time to any queries

7
Loading Data

• Will take 2-3 weeks after Datasets / Data Model
  Reconciled

8
Testing / Documentation

• Basic Information Recoveries will be used to test
  database performance
• This step could take up to a month once all Data
  loaded
• Documentation Data Dictionary and Users Manual
  for any Canned Procedures will take a week to
  prepare.

9
Security Issues

• Some Agencies Have Data Security Issues
• Database development will be restricted to a
  stand alone system No networking to be done.

10
Distribution

• Database, Data Dictionary, and Manual to be burnt
  onto CD and Distributed to the Participants
• Further Distribution Depends on Committee
  Directions