Data and Knowledge Engineering

Johann Mitloehner, 2020-24

• Relational Database Systems
  • Basic database concepts ||| NB 13.03.
    • Video: Basic Concepts
    • Video: JupyterHub, Birding example
  • Functional Dependencies and Keys ||| NB 13.03.
    • Video: Functional dependencies and keys
    • Video: Exercise chess club
  • SQL by examples: products, customers and orders ||| NB 20.03.
    • Video: SQL by Examples: Join and Group by
    • Solutions to exercises
  • Good table design: Normal Forms ||| NB 10.04.
    • Video: Normal Forms 1,2,3
    • Video: BCNF and Algorithms
    • Video: 1NF movie example
    • Exercises for Normal Forms
    • Solutions for Exercises
  • DB Applications ||| NB 17.04.
    • Video: DB Apps Part 1: CSV Import
    • Video: DB Apps Part 2: CSV Export, Reports
    • Video: Another Import/Export Example: Auto MPG
• Knowledge Graphs
  • RDF and N3 ||| NB 24.04.
    • Video: Populating the Knowledge Graph
    • Video: Defining a simple Ontology
  • Sparql ||| NB 24.04.
    • Video: Sparql
  • Reasoning ||| NB 15.05.
    • Video: Reasoning
  • Sparql Endpoints ||| NB 15.05.
    • Video: Querying Endpoints
• Applications
  • Combining relational DB and RDF sources ||| NB 22.05.
    • Video: Combine SQL and Sparql
    • Video: DBpedia
    • Video: Sun Spots and Pirates

NB = Jupyter notebook zum download

In der LV wird nur open source software verwendet, die Sie auf Ihrem Computer installieren koennen:

• python.org
• jupyter.org

Alternativ dazu: JupyterHub server des Departments, ueber die Learn-Seite zur LV (Lernaktivitaeten)

Misc

• Normalization Tool at griffith.edu.au with lots of examples
• Big source of CSV data files: R datasets
• Comments: # for Python, -- for SQL
• Other RDF sources:
  • WikiData query service
  • OpenStreetMap Sophox service
• PostgresQL am JupyterHub server des Departments:

  %sql postgresql://h12345678:h12345678@postgresql.student-db.svc.cluster.local/h12345678

References

• Chris Date, An Introduction to Database Systems, various editions

  This one stands out from the large crowd of DB books as it is not tied to a particular software product and approaches relational DB systems and SQL critically; Date covers relational theory in great detail and points out weaknesses and bad design decisions in existing DBMS and SQL, at least from his point of view. Lots of exercises, very interesting read. Highly recommended, but not at all needed for this lecture; for those who wish to further explore the relational approach. New copies of the latest edition are very expensive, but older editions are fine as well (e.g. paperback 1999); cheap used copies can be found at various online retailers, often for a few $.