AIM Database System

2002.3.16
Go Hibino
Fuji Research Institute Corporation

AIM Database System
1. Background
2. AIM Common Database
3. Prototype model
4. Future work

1. Background
Current Work System
Outputs
AIM-Trend

Outputs

Outputs

Datasets

AIM-CGE
Datasets

AIM-Local
Datasets- AIM-Local- AIM-Inventory- AIM-Country- AIM-Provincial- AIM-Inter provincial

Statistics

Datasets
AIM-Material
Outputs

Datasets
AIM-Impact
AIM-Water
Outputs

1. Background
Current Work System
AIM-Trend
Outputs
Outputs

Outputs
Datasets

AIM-CGE
Datasets

AIM-Local
Datasets

Statistics

Datasets
AIM-Material
Outputs

Datasets
AIM-Impact
AIM-Water
Outputs

1. Background
Current Work System
Outputs

AIM-Trend

Outputs

Outputs
AIM-Local

Datasets

AIM-CGE
Datasets

Datasets

Strategy

Statistics

Datasets
AIM-Material
Outputs

Datasets
AIM-Impact
AIM-Water
Outputs

1. Background
Innovational Work System
Outputs
Outputs

Outputs
AIM-Trend
AIM-CGE

AIM-Local

CommonDatabase

Strategy

AIM-Material

Outputs

Statistics

AIM-Impact

Outputs

2. AIM Common Database

AIM DatabaseAIM
Primary
Database

AIMCommonDatabase2. AIM Common Database
AIM DatabasePrimary Database

Common Database

Data

Raw Data

Process Data

FileVarious

MS Access

CodeVariousStandardization

Table

VariousStandardization

Coverage

WideWhat modelers need

2. AIM Common Database
AIM Primary Database
Statistics by international organization

IEA Energy Balances
UN World Population Prospect
UN Industrial Commodity Production
FAOSTAT Statistics Database･･････

Statistics by Country Government

Estimates by other projects

China

India

Korea

ThailandIndonesia

Malaysia

Philippines･････

IPCC SRES･･････

2. AIM Common Database
AIM Common Database
14 Database Groups
CODE

TRANSPORTWASTE

ENERGYRESIDENT

WATERGDPAGRICULTURE

EMISSIONPOPULATIONLANDUSEHEALTHINDUSTRY

TRADE

2. AIM Common Database
Structure of Database
Database

ImportCode Table

Link with CODE DB

Data Table

Core part of Database

Import File Table

Correspondence of files
to primary DB

Import Code Table

Correspondence of codes
between primary and common

Import Form

Interface to import

Import Module

Including programs to import2. AIM Common Database
Operating and Maintenance
AIM-***
AIM
AIM-***

ENERGYAIM
AIM Common
CommonDatabase
Database

AIM-***
AIM
AIM-***
Program
Program

EnergyEnergy Balances
Balances -- IEA
IEA
EnergyStatistics
UN
Energy Statistics - UNAIM
AIM TrendTrend 2002
2002
AIM
AIM Country
Country China
China 2002
2002
AIMCountryIndia
2002
AIM Country India 2002

Only
Only those
those who
who buy
buy original
original data
data cancan use
use thethe system.
system.

AIM-***
AIM
AIM-***
Database
Database

AIM-***
AIM
AIM-***AIM
AIM Common
CommonDatabase
Database

AIM-***
AIM
AIM-***
Database
Database
AIM-***
AIM
AIM-***
Program
Program

3. Prototype of AIM Common Database
GDP

Steel
PR

MF
GT

MF
PR

AIM-Trend

GT

FW

FW

1990

2010

1970

2030

Commodity_AIM-Trend

Commodity_UN
AIM
AIM Common
Common Database
Database

CO2FW

MF
GT
PR199019902010

2030

AIM-Country

2010

2030

UN Industrial
CommodityProducts

4. Future Work
Develop Import modules- UN (energy, GDP, trade ..)FAO, World BankCountry Gov. Statistics

Linkage AIM-Country with AIM-Trend via AIM common DB
for other countries
Linkage AIM-Country with energy balance statistics via
AIM common database
Develop user’s manualAIM Database Systemfin

2. AIM Common Database
CODE Database
CODE.mdb

Code_Country

Country CodeRegion CodeCode_InOut

Energy CodeMaterial Code
Service CodeCode_Sector

Energy conversion Sector
Industrial Sector
Transportation Sector
Other sector

Code_Reference

Data Source & Scenario2. AIM Common Database
Databases in ENERGY Group
ENERGY

Energy_EneFlw_IEA

IEA Energy Balances

Energy_EneFlw_UN

UN Energy Statistics

・・・・・・・・

Energy_CHN_ST

China Energy Statistics
Yearbook

・・・・・・・・

Energy_AIM-Trend

Energy Consumption
Estimated by AIM-Trend

Energy_AIM-Country

Energy Consumption
Estimated by AIM-Country････････

2. AIM Common Database
Design of Data Table
ENERGY_IEA

Energy_AIM-Trend

Commodity_UN

ITEM1“Energy Flow”“Energy Flow”

Industrial Commodities

ITEM2

Sector classification

Sector classification-ITEM3

Energy classification

Energy classification-COUTNRYCountries in the world Countries in Asia

Countries in the world

CITY---YEAR

1960-1999

1999-2032

1961-1999

VALUE

Energy flow

Energy flow

Commodity production

REFERENCE

IEA_99AIM_02_TR-A1

UN_CMM_01

2. AIM Common Database

Interface to convert IEA Energy Balances