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) |
|
|
24 | (10) |
|
3.5 Database Management Systems |
|
|
34 | (5) |
|
3.6 Additional Considerations |
|
|
39 | (2) |
|
|
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) |
|
|
45 | (1) |
|
|
46 | (1) |
|
|
46 | (1) |
|
4.2 Elements of a Relational Database System |
|
|
47 | (40) |
|
4.2.1 Structured Query Language (SQL) |
|
|
47 | (2) |
|
|
49 | (1) |
|
4.2.3 Roles and Privileges |
|
|
50 | (1) |
|
|
51 | (1) |
|
|
52 | (7) |
|
|
59 | (12) |
|
|
71 | (1) |
|
|
72 | (8) |
|
|
80 | (4) |
|
|
84 | (1) |
|
4.2.11 Stored Procedures and Triggers |
|
|
85 | (2) |
|
|
87 | (1) |
|
4.3 Other Relational Database Concepts |
|
|
87 | (10) |
|
|
87 | (7) |
|
|
94 | (1) |
|
|
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) |
|
|
111 | (1) |
|
6.2 Designing the Data Model |
|
|
112 | (3) |
|
6.3 Other Data Considerations |
|
|
115 | (2) |
|
6.4 Creating the Database |
|
|
117 | (2) |
|
|
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) |
|
|
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) |
|
|
144 | (1) |
|
|
145 | (2) |
|
Chapter 8 Applying What We've Learned |
|
|
147 | (68) |
|
|
147 | (2) |
|
8.2 The Business Model and the Data Model |
|
|
149 | (3) |
|
8.3 Implementing the Data Model in the Database |
|
|
152 | (11) |
|
|
163 | (41) |
|
8.4.1 Preliminary Information about Writing a Program in VB.NET |
|
|
163 | (2) |
|
|
165 | (1) |
|
|
166 | (1) |
|
8.4.4 Main Form and Menu Options |
|
|
166 | (2) |
|
|
168 | (16) |
|
8.4.6 Project and Site Information |
|
|
184 | (1) |
|
8.4.7 Location Information |
|
|
185 | (2) |
|
|
187 | (4) |
|
8.4.9 Entering and Importing Results |
|
|
191 | (7) |
|
8.4.10 Analyses and Reports |
|
|
198 | (5) |
|
|
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 |
|
|
|
|
215 | (2) |
|
|
215 | (1) |
|
|
215 | (2) |
|
|
217 | (16) |
|
|
217 | (7) |
|
|
224 | (1) |
|
|
225 | (8) |
|
|
233 | (12) |
|
|
233 | (2) |
|
|
235 | (2) |
|
|
237 | (4) |
|
|
241 | (4) |
|
|
245 | (22) |
|
|
245 | (1) |
|
|
246 | (4) |
|
|
250 | (5) |
|
|
255 | (12) |
|
|
267 | (16) |
|
|
267 | (4) |
|
|
271 | (4) |
|
|
275 | (8) |
|
|
283 | (20) |
|
|
283 | (9) |
|
|
292 | (7) |
|
|
299 | (4) |
|
Appendix A Data Dictionary for the Database Developed in Chapter 8 |
|
|
303 | (10) |
|
|
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 | |