Databases and Data Management Systems

Introduction In the last post I provided an overview of data management plans: Data Management Plans. In this post I’ll be presenting on databases and data management systems (DBMS), including a discussion about what constitutes a database, the basics of relational databases, and an overview of several popular DMBS software options. What is a Database?Continue reading “Databases and Data Management Systems”

The Data Pipeline: Metadata & Archiving

Introduction In the previous post I provided an overview of the analysis and report stage of the data pipeline (Figure 1). In this post I’ll provide an overview of the metadata and archiving stage. At this stage in the pipeline you’re project is mostly completed, and your ready to prepare your data for long-term storage.Continue reading “The Data Pipeline: Metadata & Archiving”

The Data Pipeline: Analysis & Reporting

Introduction In the previous post I provided an overview of the Quality Assurance and Control (QAQC) stage of the data pipeline (Figure 1). In this post I’ll provide an overview of the data Analysis and Reporting stage. By this point you have developed a database system, acquired data, and performed QAQC review on the data.Continue reading “The Data Pipeline: Analysis & Reporting”

The Data Pipeline: Data QAQC

It only takes one bad apple to spoil the bunch. Introduction In the previous post I provided an overview of the data acquisition stage of the data pipeline (Figure 1). In this post I’ll provide an overview of the data Quality Assurance and Control (QAQC) stage. Data quality assurance and control is the process ofContinue reading “The Data Pipeline: Data QAQC”

The Data Pipeline: Data Acquisition

Data Quality Control and Assurance Starts Now! Introduction In the previous post I provided an overview of the database development stage odf the data pipeline, and emphasized that database design is largely driven by the data acquisition protocols. In this post I’ll 1) provide an overview of the third stage in the data pipeline: DataContinue reading “The Data Pipeline: Data Acquisition”

The Data Pipeline: Database Development

How data acquisition protocols drive database design. Introduction In the previous post I made the distinction between data stewardship and data management, introduced the data pipeline (Figure 1), provided an overview the planning stage of the pipeline, and made a call to action for everyone involved in data management to think like a data steward.Continue reading “The Data Pipeline: Database Development”

Data management?…But I don’t want to!

Why does data management in the environmental sciences seem to be undervalued? It’s likely that data management isn’t entirely undervalued; it’s also likely that part of the problem is that, as environmental scientists, we may not currently have the “tools in our tool chest” to become good data managers. After all, we’re field scientists, not data scientists, right? I would argue that we need to be both.

Elfin…what?

The objective of this blog is to help improve data management in the environmental sciences. To this end, I’ll present an introduction to data management and a database schema model with the intent of moving us towards a more integrated approach to data management in the environmental sciences. The materials presented will be equivalent to that of a graduate level course in data management.