Material used by the teachers during the lectures.
Course Overview (Goals, Syllabus, Organization, Assessment, Bibliography).
Introduction to Big Data. Brewer’s CAP theorem. Abadi’s PACELC theorem. NoSQL quadrants.
Decision Support Systems. DW Reference Model. Historic perspective The need for a new approach. DW Reference Model. Corporate Information Factory. Quick overview of OLAP cube concepts. Basics of Multidimensional Modeling. Introduction: Different users (OLTP versus OLAP); Basic Elements of a Data Warehouse. Basic Concepts: Fact Tables; Dimension Table; Star Schemas.
The essential of "From Enterprise Models to Dimensional Models: A Methodology for Data Warehouse and Data Mart Designî from Daniel L. Moody and Mark A. R. Kortink: Classification of Entities; Hierarchies; Production of multidimensional models; Type of models, Evaluation and model tuning.
ntroduction: Different users (OLTP versus OLAP); Basic Elements of a Data Warehouse. Basic Concepts: Fact Tables; Dimension Table; Star Schemas.
Multidimensional Models for Inventory: Inventory Periodic Snapshot; Inventory Transactions; Inventory Accumulating Snapshot; Integration. Data Warehouse Bus Architecture; Conformed Dimensions; Conformed Facts.
Introduction. Procurement Transactions. Multiple- versus Single-Transaction Fact Tables. Slowly Changing Dimensions: Type 1: Overwrite the Value; Type 2: Add a Dimension Row; Type 3: Add a Dimension Column; Hybrid Slowly Changing Dimension Techniques.Large Changing Customer Dimensions.
Order Transactions.Fact Normalization; Dimension Role-Playing; Product Dimension Revisited; Customer Ship-To Dimension; Deal Dimension; Degenerate Dimension for Order Number; Junk Dimensions; Multiple Currencies; Header and Line Item Facts with Different Granularity Invoice Transactions: Accumulating Snapshot for the Order Fulfillment Pipeline;Fact Table Comparison. Designing Real-Time Partitions
Graph Models; Labeled Property Graphs; Modeling guidelines; Querying Graphs
Motivation and Evolution of Web; Semantic Web of Data; Semantic Web Principles; The Semantic Web Cake; Linked Open Data Project
A bit of history; RDF syntax; Representing triples in a graph; RDF Schema; RDF/XML.
Where the Web starts to be Semantic Web
How to query RDF datasets? SPARQL Query Language