CSE Roadmap

Level 12 of 13 · about 1 week

Big data and analytics

OLTP versus OLAP as two different access patterns that both call themselves queries, data warehousing and the star schema, MapReduce and distributed batch processing, stream processing for events as they arrive, and column-oriented storage built for analytical queries.

Modules

Core: everyone needs it. Common: most jobs use it. Specialist: optional depth, safe to skip on a first read.

  1. 1

    OLTP versus OLAP

    two very different access patterns that both call themselves database queries, and why running them on one system causes trouble

    Core 5 parts · about 2 hours

  2. 2

    Data warehousing

    pulling data from many operational systems into one place built for analysis, and the star schema that organizes it

    Specialist 6 parts · about 2 hours

  3. 3

    MapReduce and distributed batch processing

    splitting a huge job across many machines by writing two small functions and letting the framework handle the rest

    Specialist 6 parts · about 2 hours

  4. 4

    Stream processing basics

    processing events as they arrive instead of waiting for a batch job to run on yesterday's data

    Specialist 6 parts · about 2 hours

  5. 5

    Column-oriented analytics storage

    storing each column together instead of each row, and why that shape fits analytical queries so well

    Specialist 6 parts · about 2 hours