1st Edition
Managing Environmental Data Principles, Techniques, and Best Practices
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
Biography
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.
