Jump to main content.


CREM Logo

Model Report

Regional Air Impact Modeling Initiative Data Miner

Last Revision Date: 08/31/2009 View as PDF
General Information Back to Top
Model Abbreviated Name:

RAIMI Data Miner
Model Extended Name:

Regional Air Impact Modeling Initiative Data Miner
Model Overview/Abstract:
Data Miner is a large client-server database processing system that provides access to large and complex databases and facilitates the assembly of multi-source emissions inventories to support air dispersion modeling and risk modeling. U.S. EPA developed Data Miner under the Regional Air Impact Modeling Initiative (RAIMI) to meet the functional need of accessing large regulatory air emissions databases, such as the Texas Point Source Database (PSDB). Other database examples include the Toxics Release Inventory (TRI) and National Emission Inventory (NEI).

Modeling and risk-assessment projects require inspection and analysis of large databases. Due to the complexity and size of emission databases, it can be difficult or impossible to access critical data and can take significant time to track down particular details embedded in this mass of information.

To overcome these limitations, EPA developed Data Miner. The server consists of a Relational DataBase Management System (RDBMS) and is designed to prepare datasets by linking existing databases from which information must be extracted. The client-side application queries and modifies datasets to generate custom databases or database outputs.

With Data Miner, you can:

  • Create and edit database table relationships and views for complete access to all attributes maintained in the database;
  • link source-specific parameters necessary for air and risk modeling from multiple database tables through the Data Organizer component;
  • and extract the source-specific data sets by constructing and executing simple or complex data queries in the Query Builder component.
RAIMI Background

The U.S. Environmental Protection Agency (EPA), Region 6, established the Regional Air Impact Modeling Initiative (RAIMI) Program as a risk-based prioritization tool and project platform designed to develop, implement, and track multi-media solutions to environmental problems. RAIMI allows for region-wide prioritization of the potential for health risks, on a community level of resolution, associated with exposure from multiple contaminants from multiple sources and through multiple exposure pathways. The RAIMI platform is a combination of flexible exposure/risk methodologies which depend on the integrated use of a number of components supported by advanced modeling/software tools. Specifically these include the following components and supporting software tools:

  • Emission Characterization - Data Miner Air Dispersion Modeling - Air Modeling Preprocessor (AMP) Risk Modeling - Risk Management and Analysis Platform (Risk-MAP)

Keywords: Emissions Inventory, Air Toxics, RAIMI, Air Modeling, Cumulative Risk Assessment, Community Risk Assessment
Model Technical Contact Information:
Agency Contact
Jeffrey Yurk
U.S. EPA, Region 6 (Mail Code: 6PD-O)
Enforcement Division
(214) 665-8309
yurk.jeffrey@epa.gov

Developer Contact
Jeffrey T. Ayers
Air Management Group
San Antonio Texas
Office: 830.229.5346
Cell: 210.215.2460

Model Homepage: http://www.epa.gov/earth1r6/6pd/rcra_c/raimi/index.htm

User Information Back to Top
Technical Requirements
Computer Hardware
Minimum:
  • PC - Intel
  • 56 MB RAM
  • 20 MB Disk Space
Recommended:
  • 128 MB RAM
  • 10 GB Disk Space,
Compatible Operating Systems
Windows 98, 2000, XP, ME
Download Information
This model is available for download at http://www.epa.gov/earth1r6/6pd/rcra_c/raimi/index.htm
Using the Model
Basic Model Inputs
The Data Miner requires databases to be in an InterBase RDBMS (*.gdb) format.

The following databases have been successfully converted to .gdb format and accessed with Data Miner:

  • Louisiana Toxic Emissions Data Inventory (TEDI)
  • Texas Point Source Database (PSDB)
  • Federal Toxic Release Inventory (TRI)
Basic Model Outputs
Data Miner generates standard database output formats including comma-delimited text files (.txt) or Microsoft Access files (.mdb).
User Support
User's Guide Available?
Available at:
http://www.epa.gov/earth1r6/6pd/rcra_c/raimi/index.htm
Other User Documents
Validation Report http://www.epa.gov/earth1r6/6pd/rcra_c/raimi/index.htm
Availability of User Support
Jeffrey Yurk
U.S. EPA, Region 6 (Mail Code: 6PD-O)
(214) 665-8309
yurk.jeffrey@epa.gov
User Qualifications
Experience with database queries helpful.

Model Science Back to Top
Problem Identification
Modeling and cumulative-type risk assessment projects require inspection and analysis of large databases. Because there are numerous relational databases, each having many fields, it can take significant time to track down particular details embedded in this mass of information.
In addition to the complexity of the information, many applications are unable to handle the massive volumes of data. For example, common desktop software such as Microsoft Excel cannot handle more than 65,600 rows of data. Data Miner was developed to overcome these limitations.
Summary of Model Structure and Methods
The Data Miner consists of two main components:

The Data Organizer Editor -

Is designed to create or delete custom data views of individual tables contained in the database. In addition, the Editor is useful for adding and removing tables and database fields.

The Query Builder -

Is designed to compose SQL queries, generate reports, and perform data export functions

Model Evaluation
See Validation Report at:
http://www.epa.gov/earth1r6/6pd/rcra_c/raimi/index.htm See Peer Review at:
http://www.epa.gov/earth1r6/6pd/rcra_c/raimi/index.htm

Key Limitations to Model Scope
Need knowledge of imported database to utilize queried data effectively.

Case Studies
See Case Study at: http://www.epa.gov/earth1r6/6pd/rcra_c/raimi/index.htm


Local Navigation


Jump to main content.