Muutke küpsiste eelistusi

Managing Environmental Data: Principles, Techniques, and Best Practices [Kõva köide]

  • Formaat: Hardback, 340 pages, kõrgus x laius: 234x156 mm, kaal: 689 g, 20 Tables, black and white; 39 Line drawings, black and white; 39 Illustrations, black and white
  • Sari: Applied Ecology and Environmental Management
  • Ilmumisaeg: 22-Dec-2021
  • Kirjastus: CRC Press
  • ISBN-10: 0367654407
  • ISBN-13: 9780367654405
  • Formaat: Hardback, 340 pages, kõrgus x laius: 234x156 mm, kaal: 689 g, 20 Tables, black and white; 39 Line drawings, black and white; 39 Illustrations, black and white
  • Sari: Applied Ecology and Environmental Management
  • Ilmumisaeg: 22-Dec-2021
  • Kirjastus: CRC Press
  • ISBN-10: 0367654407
  • ISBN-13: 9780367654405
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.
Acknowledgments xi
About the Author xiii
Chapter 1 About This Book
1(4)
1.1 The Purpose and Objectives of This Book
1(1)
1.2 Structure of the Book
1(1)
1.3 Who Should Read This Book
2(1)
1.4 What This Book Is Not
3(2)
Chapter 2 Data Management Concepts
5(12)
2.1 What Does It Mean to "Manage Data?"
5(4)
2.2 Other Functions of a Data Management System
9(1)
2.3 Is Managing Environmental Data Different from Managing Other Types of Data?
10(1)
2.4 Data Management Planning
11(6)
PART 1 Environmental Data Management Principles
Chapter 3 Techniques for Data Management and Their Effectiveness
17(26)
3.1 The Framework for This
Chapter
17(2)
3.2 The Filing Cabinet System
19(2)
3.3 Management of Electronic Copies of the Data
21(3)
3.4 Using Spreadsheets
24(10)
3.5 Database Management Systems
34(5)
3.6 Additional Considerations
39(2)
3.7 Summary
41(2)
Chapter 4 Relational Database Management System Basics
43(54)
4.1 Components of a Relational Database Management Solution
43(4)
4.1.1 The Database Management Software
43(1)
4.1.1.1 Oracle (Oracle Corporation)
44(1)
4.1.1.2 SQL Server (Microsoft Corporation)
45(1)
4.1.1.3 Jet (Microsoft Corporation)
45(1)
4.1.1.4 MySQL (Open Source)
45(1)
4.1.1.5 PostgreSQL (Open Source)
45(1)
4.1.1.6 Conclusion
45(1)
4.1.2 The Database
46(1)
4.1.3 The User Interface
46(1)
4.2 Elements of a Relational Database System
47(40)
4.2.1 Structured Query Language (SQL)
47(2)
4.2.2 Users
49(1)
4.2.3 Roles and Privileges
50(1)
4.2.4 Schema
51(1)
4.2.5 Columns
52(7)
4.2.6 Tables
59(12)
4.2.7 Indexes
71(1)
4.2.8 Constraints
72(8)
4.2.9 Queries
80(4)
4.2.10 Views
84(1)
4.2.11 Stored Procedures and Triggers
85(2)
4.2.12 Forms
87(1)
4.3 Other Relational Database Concepts
87(10)
4.3.1 Data Normalization
87(7)
4.3.2 Data Validation
94(1)
4.3.3 Transactions
95(2)
Chapter 5 Buy, Borrow, or Build: A Decision Guide for Choosing between an Existing Solution and Creating Something New
97(14)
5.1 Options for a Comprehensive Data Management Program
97(1)
5.2 Using Commercial Software
98(3)
5.3 Adapting an Existing Solution
101(2)
5.4 Building a Custom Application
103(1)
5.5 Advantages and Disadvantages of Each Option
104(3)
5.6 Guidance: Deciding on the Best Option
107(4)
Chapter 6 Designing and Building a Database
111(12)
6.1 Preliminary Steps
111(1)
6.2 Designing the Data Model
112(3)
6.3 Other Data Considerations
115(2)
6.4 Creating the Database
117(2)
6.5 Loading Data
119(2)
6.6 Database Creation Summary
121(2)
Chapter 7 Creating the User Interface(s)
123(24)
7.1 The Purpose of the User Interface
123(1)
7.2 Identifying User Interface Requirements
124(2)
7.3 Interface Development Tools
126(5)
7.3.1 Integrated Tools
126(2)
7.3.2 Third-Party Options
128(1)
7.3.3 Traditional Programming Languages
129(2)
7.4 User Interface Functions
131(11)
7.4.1 User Access and Privileges
131(1)
7.4.2 Entering, Updating, and Deleting Data
132(1)
7.4.3 Importing and Exporting Data
133(1)
7.4.4 Data Review and Validation
134(1)
7.4.5 Querying and Reporting
135(6)
7.4.6 Database Cleanup and Maintenance
141(1)
7.5 User Interface Platforms and Components
142(1)
7.6 Finalizing the Interface Plan
143(1)
7.7 Testing
144(1)
7.8 Summary
145(2)
Chapter 8 Applying What We've Learned
147(68)
8.1 Preliminary Comments
147(2)
8.2 The Business Model and the Data Model
149(3)
8.3 Implementing the Data Model in the Database
152(11)
8.4 The User Interface
163(41)
8.4.1 Preliminary Information about Writing a Program in VB.NET
163(2)
8.4.2 modChapter8
165(1)
8.4.3 The Login Process
166(1)
8.4.4 Main Form and Menu Options
166(2)
8.4.5 Lookup Tables
168(16)
8.4.6 Project and Site Information
184(1)
8.4.7 Location Information
185(2)
8.4.8 Sampling Events
187(4)
8.4.9 Entering and Importing Results
191(7)
8.4.10 Analyses and Reports
198(5)
8.4.11 Data Maintenance
203(1)
8.5 Moving Beyond the Basics
204(7)
8.6 Summary and Conclusions for Part 1
211(4)
PART 2 Environmental Data Management Realities
Chapter 9 Prolog
215(2)
9.1 Purpose
215(1)
9.2 Structure
215(2)
Chapter 10 Origins
217(16)
10.1 Context
217(7)
10.2 Setback
224(1)
10.3 Midnight
225(8)
Chapter 11 Birth
233(12)
11.1 Dawn
233(2)
11.2 Morning
235(2)
11.3 Upheaval
237(4)
11.4 Delivery
241(4)
Chapter 12 Growth
245(22)
12.1 Diversification
245(1)
12.2 Exile
246(4)
12.3 Reunion
250(5)
12.4 Travels
255(12)
Chapter 13 Maturity
267(16)
13.1 Plateau
267(4)
13.2 Stasis
271(4)
13.3 Evolution
275(8)
Chapter 14 Rejuvenation
283(20)
14.1 Connections
283(9)
14.2 Acme
292(7)
14.3 Reprise
299(4)
Appendix A Data Dictionary for the Database Developed in
Chapter 8
303(10)
A.1 Data Dictionary
303(1)
A.2 Entity Relationship Diagrams
303(10)
Appendix B SQL Commands for Creating the Database and Inserting Data
313(24)
B.1 Commands for Creating the Tables
313(6)
B.2 Commands for Creating Relationships
319(5)
B.3 Commands for Inserting Data
324(13)
Appendix C Bibliography: References and Recommended Reading
337(2)
Index 339
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.