Relational Management and Display of Site Environmental Data

Relational Management and Display of Site Environmental Data

When your environmental project reaches the point where the amount of data seems overwhelming, you will need a robust tool to help you manage it. Written by a recognized expert and software author with over 25 years of industry experience, Relational Management and Display of Site Environmental Data...

Mô tả đầy đủ

Đã lưu trong:
Chi tiết về thư mục
Tác giả chính: Rich, David W
Định dạng: Sách
Ngôn ngữ:English
Được phát hành: CRC Press 2009
Những chủ đề:
Environmental Sciences
Truy cập trực tuyến:http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/1194
Các nhãn: Thêm thẻ
Không có thẻ, Là người đầu tiên thẻ bản ghi này!
Thư viện lưu trữ: Thư viện Trường Đại học Đà Lạt
id oai:scholar.dlu.edu.vn:DLU123456789-1194
record_format dspace
institution Thư viện Trường Đại học Đà Lạt
collection Thư viện số
language English
topic Environmental Sciences
spellingShingle Environmental Sciences
Rich, David W
Relational Management and Display of Site Environmental Data
description When your environmental project reaches the point where the amount of data seems overwhelming, you will need a robust tool to help you manage it. Written by a recognized expert and software author with over 25 years of industry experience, Relational Management and Display of Site Environmental Data begins with an overview of site data management concepts, then progresses through relational data management theory, the design of the database tool, and implementing a data management system. It includes detailed information on data output including mapping and GIS applications, practical suggestions about working with laboratories, and concludes with pitfalls, horror stories, and successes in site data management. Current topics such as Internet data delivery and eXtensible Markup Language are also covered. The text provides you with the skills needed to effectively implement and operate an environmental data management system. The concepts covered can be applied to any system, from stand-alone through client-server to Web-based. Relational Management and Display of Site Environmental Data combines the fundamentals of data management and display with the author's many years of experience to help you create your own data management system or more intelligently select and use a commercial solution.
format Book
author Rich, David W
author_facet Rich, David W
author_sort Rich, David W
title Relational Management and Display of Site Environmental Data
title_short Relational Management and Display of Site Environmental Data
title_full Relational Management and Display of Site Environmental Data
title_fullStr Relational Management and Display of Site Environmental Data
title_full_unstemmed Relational Management and Display of Site Environmental Data
title_sort relational management and display of site environmental data
publisher CRC Press
publishDate 2009
url http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/1194
_version_ 1757662012845850624
spelling oai:scholar.dlu.edu.vn:DLU123456789-11942009-10-13T02:27:01Z Relational Management and Display of Site Environmental Data Rich, David W Environmental Sciences When your environmental project reaches the point where the amount of data seems overwhelming, you will need a robust tool to help you manage it. Written by a recognized expert and software author with over 25 years of industry experience, Relational Management and Display of Site Environmental Data begins with an overview of site data management concepts, then progresses through relational data management theory, the design of the database tool, and implementing a data management system. It includes detailed information on data output including mapping and GIS applications, practical suggestions about working with laboratories, and concludes with pitfalls, horror stories, and successes in site data management. Current topics such as Internet data delivery and eXtensible Markup Language are also covered. The text provides you with the skills needed to effectively implement and operate an environmental data management system. The concepts covered can be applied to any system, from stand-alone through client-server to Web-based. Relational Management and Display of Site Environmental Data combines the fundamentals of data management and display with the author's many years of experience to help you create your own data management system or more intelligently select and use a commercial solution. OVERVIEW AND CONCEPTS OVERVIEW OF ENVIRONMENTAL DATA MANAGEMENT * Concern for the environment * The Computer Revolution * Convergence - Environmental data management * Concept of Data vs. Information EMS vs. EMIS vs. EDMS SITE DATA MANAGEMENT CONCEPTS * Purpose of data management * Types of data storage * Responsibility for data management * Understanding the data RELATIONAL DATA MANAGEMENT THEORY * What is relational data management? * History of relational data management * Data normalization * Structured Query Language * Benefits of normalization * Automated normalization DATA CONTENT * Data content overview * Project technical data * Project administrative data * Project document data * Reference data * Document management SYSTEM DESIGN AND IMPLEMENTATION GENERAL DESIGN ISSUES * Database management software * Database location options * Distributed vs. centralized databases * The data model * Data access requirements * Government EDMS systems * Other issues DATABASE ELEMENTS * Hardware and software components * Units of data storage * Databases and files * Tables ("databases") * Fields (columns) * Records (rows) * Queries (views) * Other database objects THE USER INTERFACE * General user interface issues * Conceptual guidelines * Guidelines for specific elements * Documentation IMPLEMENTING THE DATABASE SYSTEM * Designing the system * Buy or build? * Implementing the system * Managing the system ONGOING DATA MANAGEMENT ACTIVITIES * Managing the workflow * Managing the data * Administering the system GATHERING ENVIRONMENTAL DATA SITE INVESTIGATION AND REMEDIATION * Overview of environmental regulations * The Investigation and Remediation Process * Environmental Assessments and Environmental Impact Statements GATHERING SAMPLES AND DATA IN THE FIELD * General sampling issues * Soil * Sediment * Groundwater * Surface water * Decontamination of equipment * Shipping of samples * Air * Other media * Overview of parameters ENVIRONMENTAL LABORATORY ANALYSIS * Laboratory workflow * Sample preparation * Analytical methods * Other analysis issues MAINTAINING THE DATA IMPORTING DATA * Manual entry * Electronic import * Tracking imports * Undoing an import * Tracking quality EDITING DATA * Manual editing * Automated editing MAINTAINING AND TRACKING DATA QUALITY QA vs. QC * The QAPP * QC samples and analyses * Data quality procedures * Database support for data quality and usability * Precision vs. Accuracy * Protection from loss DATA VERIFICATION AND VALIDATION * Types of data review * Meaning of Verification * Meaning of Validation * The verification and validation process * Verification and validation checks * Software assistance with verification and validation MANAGING MULTIPLE PROJECTS AND DATABASES * One file or many? * Sharing data elements * Moving between databases * Limiting site access USING THE DATA DATA SELECTION * Text-based queries * Graphical selection * Query-by-form REPORTING AND DISPLAY * Text output * Formatted reports * Formatting the result * Interactive output * Electronic distribution of data GRAPHS * Graph overview * General concepts * Types of graphs * Graph examples * Curve fitting * Graph theory CROSS SECTIONS, FENCE DIAGRAMS, AND 3-D DISPLAYS * Lithologic and wireline logs * Cross sections * Profiles * Fence diagrams and stick displays * Block Diagrams and 3-D displays MAPPING AND GIS * Mapping concepts * Mapping software * Displaying data * Contouring and modeling * Specialized displays STATISTICS AND ENVIRONMENTAL DATA * Statistical concepts * Types of statistical analyses * Outliers and comparison with limits * Toxicology and risk assessment INTEGRATION WITH OTHER PROGRAMS * Export - import * Digital output * Export - import advantages and disadvantages * Direct connection * Data warehousing and data mining * Data integration PROBLEMS, BENEFITS, AND SUCCESSES AVOIDING PROBLEMS * Manage expectations * Use the right tool * Prepare for problems with the data * Plan project administration * Increasing the chance of a positive outcome SUCCESS STORIES * Financial benefits * Technical benefits * Subjective benefits THE FUTURE OF ENVIRONMENTAL DATA MANAGEMENT APPENDICES NEEDS ASSESSMENT EXAMPLE DATA MODEL EXAMPLE o Introduction o Conventions o Primary Tables o Lookup tables o Reference tables o Utility tables DATA TRANSFER STANDARD o Purpose o Database background information o Data content o Acceptable file formats o Submittal requirements o Non-conforming data THE PARAMETERS o Inorganic parameters o Organic parameters o Other parameters o Method reference EXERCISES o Database redesign exercise o Data normalization exercise o Group discussion - data management and your organization o Database redesign exercise solution o Data normalization exercise solution o Database software exercises GLOSSARY BIBLIOGRAPHY 2009-10-13T02:27:01Z 2009-10-13T02:27:01Z 2002 Book 156670591 http://scholar.dlu.edu.vn/thuvienso/handle/DLU123456789/1194 en application/octet-stream CRC Press

Những quyển sách tương tự