Managing Environmental Data: Principles, Techniques, and Best Practices

by Gerald A. Burnette

Overview

Focused on the mechanics of managing environmental data, this book provides guidelines on how to evaluate data requirements, assess tools and techniques, and implement an effective system. Moving beyond the hypothetical, Gerald Burnette illustrates the decision-making processes and the compromises required when applying environmental principles and practices to actual data.

Managing Environmental Data explains the basic principles of relational databases, discusses database design, explores user interface options, and examines the process of implementation. Best practices are identified during each portion of the process. The discussion is summarized via the development of a hypothetical environmental data management system. Details of the design help establish a common framework that bridges the gap between data managers, users, and software developers.

It is an ideal text for environmental professionals and students. The growth in both volume and complexity of environmental data presents challenges to environmental professionals. Developing better data management skills offers an excellent opportunity to meet these challenges. Gaining knowledge of and experience with data management best practices complements students’ more traditional science education, providing them with the skills required to address complex data requirements.

Product Details

ISBN-13:	9780367675929
Publisher:	CRC Press
Publication date:	05/27/2024
Series:	Applied Ecology and Environmental Management
Pages:	354
Product dimensions:	6.12(w) x 9.19(h) x (d)

About the Author

Gerald Burnette is a Senior Project Manager with Civil and Environmental

Consultants, Inc. He earned a Bachelor of Arts in Mathematics (with a minor

in Physics) from Maryville College in 1983. He has over 35 years experience in

developing analytical and management applications related to land, ecosystem, and

natural resources issues. He specializes in developing complex database management

systems, including desktop and web interfaces. In addition to performing these services

for numerous private clients, he has a long history of working for numerous

state, local, and federal government clients. Notable examples include the US Army

Corps of Engineers, the US Department of Energy, and NASA.

Table of Contents

Contents

Acknowledgments ..................................................................................................... xi

About the Author ..................................................................................................... xiii

Chapter 1 About This Book .................................................................................. 1

Chapter 2 Data Management Concepts ................................................................. 5

PART 1 Environmental Data Management Principles

Chapter 3 Techniques for Data Management and Their Effectiveness ............... 17

Chapter 4 Relational Database Management System Basics .............................. 43

Chapter 5 Buy, Borrow, or Build: A Decision Guide for Choosing

between an Existing Solution and Creating Something New ................................. 97

Chapter 6 Designing and Building a Database ................................................. 111

Chapter 7 Creating the User Interface(s) .......................................................... 123

Chapter 8 Applying What We’ve Learned ........................................................ 147

PART 2 Environmental Data Management Realities

Chapter 9 Prolog ............................................................................................... 215

Chapter 10 Origins .............................................................................................. 217

Chapter 11 Birth .................................................................................................. 233

Chapter 12 Growth .............................................................................................. 245

Chapter 13 Maturity ............................................................................................ 267

Chapter 14 Rejuvenation ..................................................................................... 283

Appendix A Data Dictionary for the Database Developed in Chapter 8 ......... 303

Appendix B SQL Commands for Creating the Database and

Inserting Data ................................................................................................... 313

Appendix C Bibliography: References and Recommended Reading .............. 337

Index ...................................................................................................................... 339