The Data Base Extension to the Forest Vegetation Simulator

Download Report

Transcript The Data Base Extension to the Forest Vegetation Simulator

Slide 1

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator

Nicholas L. Crookston
Dennis Gammel
March 11, 2003

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator
Nicholas L. Crookston
Stephanie Rebain
many others
(and remember Dennis Gammel)
February 15, 2007

FVS Data Base Extension
Major features
• Allows FVS to get initial stand and tree level
data from ODBC-supported data bases.
• FVS predictions can be directly loaded into
data bases.
• Allows SQL commands to execute on data
bases during an FVS simulation, one or more
times during any one or all cycles.

FVS Data Base Extension
Major features - continued
• Event Monitor variables and their values can
be loaded into a data base during a simulation.
• Data from the data base can define FVS Event
Monitor variables during a simulation.
• Capabilities for Suppose to directly interact
with data bases are being built and will be
introduced in a pending release of Suppose.

FVS Data Base Extension
Summary:
• FVS interacts with the data bases providing
many of the benefits data bases provide to FVS
users.
• Technical issues remain for taking advantage of
these technologies within our organizations.
Some of these issues will be discussed in the
following papers.

FVS Data Base Extension
Future data sources:
• Field-sampled data is expensive to collect.
• We will hear two presentations on imputationbased methods that address this issue.
• Following the presentations, we will take
questions from the floor!


Slide 2

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator

Nicholas L. Crookston
Dennis Gammel
March 11, 2003

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator
Nicholas L. Crookston
Stephanie Rebain
many others
(and remember Dennis Gammel)
February 15, 2007

FVS Data Base Extension
Major features
• Allows FVS to get initial stand and tree level
data from ODBC-supported data bases.
• FVS predictions can be directly loaded into
data bases.
• Allows SQL commands to execute on data
bases during an FVS simulation, one or more
times during any one or all cycles.

FVS Data Base Extension
Major features - continued
• Event Monitor variables and their values can
be loaded into a data base during a simulation.
• Data from the data base can define FVS Event
Monitor variables during a simulation.
• Capabilities for Suppose to directly interact
with data bases are being built and will be
introduced in a pending release of Suppose.

FVS Data Base Extension
Summary:
• FVS interacts with the data bases providing
many of the benefits data bases provide to FVS
users.
• Technical issues remain for taking advantage of
these technologies within our organizations.
Some of these issues will be discussed in the
following papers.

FVS Data Base Extension
Future data sources:
• Field-sampled data is expensive to collect.
• We will hear two presentations on imputationbased methods that address this issue.
• Following the presentations, we will take
questions from the floor!


Slide 3

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator

Nicholas L. Crookston
Dennis Gammel
March 11, 2003

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator
Nicholas L. Crookston
Stephanie Rebain
many others
(and remember Dennis Gammel)
February 15, 2007

FVS Data Base Extension
Major features
• Allows FVS to get initial stand and tree level
data from ODBC-supported data bases.
• FVS predictions can be directly loaded into
data bases.
• Allows SQL commands to execute on data
bases during an FVS simulation, one or more
times during any one or all cycles.

FVS Data Base Extension
Major features - continued
• Event Monitor variables and their values can
be loaded into a data base during a simulation.
• Data from the data base can define FVS Event
Monitor variables during a simulation.
• Capabilities for Suppose to directly interact
with data bases are being built and will be
introduced in a pending release of Suppose.

FVS Data Base Extension
Summary:
• FVS interacts with the data bases providing
many of the benefits data bases provide to FVS
users.
• Technical issues remain for taking advantage of
these technologies within our organizations.
Some of these issues will be discussed in the
following papers.

FVS Data Base Extension
Future data sources:
• Field-sampled data is expensive to collect.
• We will hear two presentations on imputationbased methods that address this issue.
• Following the presentations, we will take
questions from the floor!


Slide 4

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator

Nicholas L. Crookston
Dennis Gammel
March 11, 2003

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator
Nicholas L. Crookston
Stephanie Rebain
many others
(and remember Dennis Gammel)
February 15, 2007

FVS Data Base Extension
Major features
• Allows FVS to get initial stand and tree level
data from ODBC-supported data bases.
• FVS predictions can be directly loaded into
data bases.
• Allows SQL commands to execute on data
bases during an FVS simulation, one or more
times during any one or all cycles.

FVS Data Base Extension
Major features - continued
• Event Monitor variables and their values can
be loaded into a data base during a simulation.
• Data from the data base can define FVS Event
Monitor variables during a simulation.
• Capabilities for Suppose to directly interact
with data bases are being built and will be
introduced in a pending release of Suppose.

FVS Data Base Extension
Summary:
• FVS interacts with the data bases providing
many of the benefits data bases provide to FVS
users.
• Technical issues remain for taking advantage of
these technologies within our organizations.
Some of these issues will be discussed in the
following papers.

FVS Data Base Extension
Future data sources:
• Field-sampled data is expensive to collect.
• We will hear two presentations on imputationbased methods that address this issue.
• Following the presentations, we will take
questions from the floor!


Slide 5

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator

Nicholas L. Crookston
Dennis Gammel
March 11, 2003

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator
Nicholas L. Crookston
Stephanie Rebain
many others
(and remember Dennis Gammel)
February 15, 2007

FVS Data Base Extension
Major features
• Allows FVS to get initial stand and tree level
data from ODBC-supported data bases.
• FVS predictions can be directly loaded into
data bases.
• Allows SQL commands to execute on data
bases during an FVS simulation, one or more
times during any one or all cycles.

FVS Data Base Extension
Major features - continued
• Event Monitor variables and their values can
be loaded into a data base during a simulation.
• Data from the data base can define FVS Event
Monitor variables during a simulation.
• Capabilities for Suppose to directly interact
with data bases are being built and will be
introduced in a pending release of Suppose.

FVS Data Base Extension
Summary:
• FVS interacts with the data bases providing
many of the benefits data bases provide to FVS
users.
• Technical issues remain for taking advantage of
these technologies within our organizations.
Some of these issues will be discussed in the
following papers.

FVS Data Base Extension
Future data sources:
• Field-sampled data is expensive to collect.
• We will hear two presentations on imputationbased methods that address this issue.
• Following the presentations, we will take
questions from the floor!


Slide 6

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator

Nicholas L. Crookston
Dennis Gammel
March 11, 2003

FVS Data Base Extension

The Database Extension to the
Forest Vegetation Simulator
Nicholas L. Crookston
Stephanie Rebain
many others
(and remember Dennis Gammel)
February 15, 2007

FVS Data Base Extension
Major features
• Allows FVS to get initial stand and tree level
data from ODBC-supported data bases.
• FVS predictions can be directly loaded into
data bases.
• Allows SQL commands to execute on data
bases during an FVS simulation, one or more
times during any one or all cycles.

FVS Data Base Extension
Major features - continued
• Event Monitor variables and their values can
be loaded into a data base during a simulation.
• Data from the data base can define FVS Event
Monitor variables during a simulation.
• Capabilities for Suppose to directly interact
with data bases are being built and will be
introduced in a pending release of Suppose.

FVS Data Base Extension
Summary:
• FVS interacts with the data bases providing
many of the benefits data bases provide to FVS
users.
• Technical issues remain for taking advantage of
these technologies within our organizations.
Some of these issues will be discussed in the
following papers.

FVS Data Base Extension
Future data sources:
• Field-sampled data is expensive to collect.
• We will hear two presentations on imputationbased methods that address this issue.
• Following the presentations, we will take
questions from the floor!