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.

Get full access to this article

View all access options for this article.

References

Elliott, R. N. 1994. Carbon reduction potential from recycling in primary materials manufacturing. Washington, DC: American Council for an Energy Efficient Economy.

Energy Information Administration . 1998. Emissions of greenhouse gases in the United States 1997. Washington, DC: U.S. Department of Energy.

Environmental Protection Agency . 2000. Inventory of U.S. greenhouse gas emissions and sinks: 1990-1998, EPA-236-R-00-001. Washington, DC: U.S. Environmental Protection Agency.

Gummer, J. , and R. Moreland . 2000. The European union and global climate change: A review of five national programmes. Arlington, VA: The Pew Center on Global Climate Change.

Heisler, S. I. , ed. 1998. Wiley engineer's desk reference, second edition. New York: John Wiley.

Houghton, J. T. , L. G. Meira Filho , B. Lim , K. Treanton , I. Marnaty , Y. Banduki , D. J. Griggs , and B. A. Callender . 1996. Revised 1996 IPCC guidelines for national greenhouse gas inventories. Bracknell: IPCC, OECD, IEA, UK Meteorological Office.

Kerstetter, J. D. 1994a. Greenhouse gas emissions inventory for Washington State 1990. Olympia: Washington State Energy Office.

Kerstetter, J. D. 1994b. Projected greenhouse gas emissions for Washington State in 2010. Olympia: Washington State Energy Office.

Newcomb, T. M. 1998. Assessing data for precursors of CO2 and methane in King County, Washington 1990. Evaluation Review 22 (6): 792-815.

10.

New Jersey Department of Environmental Protection . 1999. New Jersey sustainability greenhouse gas action plan. Trenton: New Jersey Department of Environmental Protection.

11.

Oregon Department of Energy . 1990. Oregon task force on global warming report to the governor and legislature. Salem: Oregon Department of Energy.

12.

Penman, J. , D. Kruger , I. Galbally , T. Hiraishi , B. Nyenzi , S. Emmanuel , L. Buendia , R. Hoppaus , T. Martinsen , J. Meijer , K. Miwa , and K. Tanabe , eds. 2000. Good practice guidance and uncertainty management in national greenhouse gas inventories. Kanagawa, Japan: Intergovernmental Panel on Climate Change.

13.

Roman, S. 1999. Access database design and programming. Cambridge, UK: O'Reilly & Associates.

14.

Seattle City Light. 2000. Unpublished climate challenge report for 1999 to the energy information administration, Form 1605.

15.

U.S. Department of Energy . 2000. State energy information at a glance [Online]. Available from URL http://www.eia.doe.gov/emeu/states/