title: A design for a relational database for the calculation and storage of greenhouse gas emissions.
abstract: The Intergovernmental Panel on Climate Change (IPCC) has published guidelines for the development of national greenhouse gas-emissions inventories and recommendations for collecting data necessary to calculate greenhouse gas emissions. Many regional and local jurisdictions will be performing inventories of greenhouse gas emissions and estimating the benefits of mitigation strategies to reduce emissions. This article advocates the development of relational databases to calculate and store emissions estimates based on IPCC guidelines and quantities of precursors of greenhouse gases. Specific examples of tables and queries are used to illustrate calculation methods and formulae, the choice of database keys, and the choice of methods for joining tables to construct queries.
authors.forename: T M
authors.initials: TM
authors.lastname: Newcomb
mesh_terms: D002245:Carbon Dioxide / Q000032:analysis*; D003625:Data Collection; D003628:Database Management Systems; D016208:Databases, Factual; D005579:Fossil Fuels; D017752:Greenhouse Effect; D006801:Humans; D016247:Information Storage and Retrieval; D011210:Power Plants; D012037:Refuse Disposal; D012984:Software; D014481:United States; D014584:User-Computer Interface; D001335:Vehicle Emissions / Q000032:analysis*; D014861:Washington
chemical_list: D005579:Fossil Fuels; D001335:Vehicle Emissions; D002245:Carbon Dioxide