Managing Environmental Data

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