LINCS Blog

What Is Extract Transform Load?

  • LINCS Project
  • October 27, 2021
A general Extract Transform Load process

— Justin Francis, LINCS Junior Programmer — A general Extract Transform Load process In data science there is a commonly used process called extract-transform-load (ETL). ETL involves three main steps:  1. Extract data from a source,  2. Transform the data via data cleansing and data manipulation, and  3. Load the transformed data to a data […]

Flowchart diagram showing the DoReMus model for improvised performance, including the distinct Performed Expression class

— Sam Peacock, LINCS undergraduate research assistant — When I began working with ontologies at the LINCS project this summer, my colleagues and I quickly found ourselves asking exasperating questions like “How do you explain the visual concepts present in an artwork to a database?” Even more broad (and maybe ultimately unanswerable) questions like “what is […]

— Gracy Go, undergraduate research assistant — History has always been something I’ve been passionate about, and as an undergraduate student approaching graduation, I’ve become more eager to find ways to preserve primary sources. From my experience, having access to primary sources makes the researching process a lot easier, and these sources would not exist […]