From the course: Data Curation Foundations

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Curating study vs. production data

Curating study vs. production data

From the course: Data Curation Foundations

Start my 1-month free trial

Curating study vs. production data

“

- [Instructor] In this video, I'm going to highlight the differences between curating study data and curating production data. The reason curation for study and production data can be so different is because the data structures are typically different. Let's start by thinking of the structure of production data. There are usually a few big main tables with dynamic data that keep getting updated. Imagine a store database. There probably is a table of transactions that keeps getting updated each time someone buys something. But there are also a bunch of little picklist tables, these are what control the choices in the dropdown list. Sometimes, there are also skinny audit-trail tables that keep track of the history of values in different fields. All these mini tables are related in a complex way. You need a diagram to keep track of all that. A romanticized version of the kind of diagram that is on the slide. Now, let's see…

Contents