{"id":10019,"date":"2019-09-22T07:48:11","date_gmt":"2019-09-22T07:48:11","guid":{"rendered":"http:\/\/blog.bachi.net\/?p=10019"},"modified":"2020-01-15T11:08:47","modified_gmt":"2020-01-15T11:08:47","slug":"tsm_datamgmt","status":"publish","type":"post","link":"https:\/\/blog.bachi.net\/?p=10019","title":{"rendered":"TSM_DataMgmt"},"content":{"rendered":"

An Animated Guide: Knowing SQL Internal Processes makes SQL Easy, makes SQL easy<\/a>
\nWHERE-Klausel im Detail<\/a><\/p>\n

Lecture<\/h1>\n

<\/p>\n

Week 3<\/h3>\n

Postgres Handles More Than You Think<\/a>
\nDon’t Do This<\/a>
\nB-Baum<\/a>
\nAVL-Baum<\/a><\/p>\n

CTE in SQL<\/a><\/p>\n

What is the difference between tree depth and height?<\/a>
\nHeight, Depth and Level of a Tree<\/a><\/p>\n

Nested set model<\/a>
\nNested Sets<\/a>
\nJede Menge B\u00e4ume<\/a><\/p>\n

Storing hierarchical data: Materialized Path<\/a>
\nTrees in SQL: Nested Sets and Materialized Path<\/a>
\nNested Sets and Materialized Path SQL Trees<\/a>
\nTrees in SQL : an approach based on materialized paths and normalization for MySQLTrees in SQL : an approach based on materialized paths and normalization for MySQL<\/a>
\nMaterialized Path in PostgreSQL<\/a><\/p>\n

<\/p>\n

Week 4<\/h4>\n

Install MongoDB Community Edition on Ubuntu<\/a><\/p>\n

<\/p>\n

Week 5<\/h4>\n

“Schema Later” Considered Harmful<\/a>
\nVisualization software<\/a>
\nTableau Software<\/a>
\nSuperset: enterprise-ready web application for data exploration, data visualization and dashboarding
\nWhat does Tableau offer that Apache Superset doesn’t?<\/a><\/p>\n

<\/p>\n

Week 6<\/h4>\n

What is the difference between scale-out versus scale-up (architecture, applications, etc.)?<\/a><\/p>\n

<\/p>\n

Week 8<\/h4>\n

Assoziationsanalyse | Video Based Learning<\/a>
\nApriori-Algorithmus | Business Intelligence | Unsupervised Learning<\/a>
\nFrequent Pattern (FP) growth Algorithm for Association Rule Mining<\/a>
\nApriori algorithm with complete solved example to find association rules<\/a>
\ndata mining fp growth | data mining fp growth algorithm | data mining fp tree example | fp growth<\/a><\/p>\n

<\/p>\n

Week 9<\/h4>\n

ID3<\/a>
\nC4.5<\/a>
\nDecision tree learning<\/a>
\nDecision Tree Classification in R<\/a><\/p>\n

<\/p>\n

Week 11<\/h4>\n

K – Means Clustering – Fun and Easy Machine Learning<\/a>
\nHierarchical Clustering – Fun and Easy Machine Learning<\/a><\/p>\n

<\/p>\n

Week 13<\/h4>\n

Minimal Viable Search using Postgres<\/a>
\nUnscharfe Suche<\/a>, Levenshtein-Distanz, N-Grammen, Soundex
\nPostgreSQL Full Text Search and Trigram Confusion<\/a>
\nVictor Lavrenko – Search Engine<\/a><\/p>\n

MapReduce – Computerphile<\/a>
\nPostgreSQL Full Text Search and Trigram Confusion<\/a>
\n13.68 MapReduce, Verarbeitung eines MapReduce Jobs auf einem Cluster<\/a>\t \tVictor Lavrenko – Search Engine<\/a>
\nApache Hadoop<\/a>
\nMapReduce<\/a><\/p>\n

Heaps’ law<\/a>
\nZipf’s law<\/a><\/p>\n

<\/p>\n

Rest<\/h1>\n

Step by Step Guide to Dimensional Data Modeling<\/a>
\nIntroduction to Dimesional Modelling<\/a>
\nBusiness Intelligence: Building Your First Cube<\/a>
\nCreate First OLAP Cube in SQL Server Analysis Services<\/a>
\nBuilding Your First Data Cube<\/a>
\nDimensional modeling<\/a>
\nOLAP-W\u00fcrfel<\/a>
\nOLAP cube<\/a><\/p>\n

SQL | DDL, DQL, DML, DCL and TCL Commands<\/a><\/p>\n

Grundbegriffe der Pr\u00e4dikatenlogik<\/a>
\nProlog – Begriffe<\/a>, (Literal, Klausel, Pr\u00e4dikat)<\/p>\n

Wikipedia<\/h4>\n

Pr\u00e4dikatenlogik<\/a>
\nLiterale in der mathematischen Logik<\/a>
\nDisjunktionsterm<\/a>
\nPr\u00e4dikat (Logik)<\/a><\/p>\n

Wikipedia<\/h3>\n

<\/a> (de)
\nRelational algebra<\/a> (en)
\nJoin (SQL)<\/a> (de)
\nJoin (SQL)<\/a> (en)
\nData Manipulation Language (DML)<\/a>
\nTransaction Control Language (TCL)<\/a>
\nCRUD<\/a>
\nACID<\/a>
\nNoSQL<\/a>
\nDokumentenorientierte Datenbank<\/a>
\nCodd’s 12 rules<\/a><\/p>\n

NULL<\/h3>\n

NULL in SQL: Platzhalter f\u00fcr fehlende Daten<\/a><\/p>\n

SQL Functions<\/h3>\n

Substring function overview<\/a><\/p>\n

Sakila Databas<\/h3>\n

MySQL Sakila Sample Database<\/a>
\nThe Sakila Database<\/a>
\ngithub.com\/jOOQ\/jOOQ\/tree\/master\/jOOQ-examples\/Sakila<\/a><\/p>\n

JOOQ<\/h4>\n

A Beginner\u2019s Guide to the True Order of SQL Operations<\/a><\/p>\n

Datenbankenlernen.de – Prof. Dr. Jens Dittrich<\/h3>\n

Datenbankenlernen.de<\/a>
\n13.XX SQL<\/a> (Playlist)
\n13.20 \u00dcbersicht \u00fcber Datenbanksysteme: Welches DBMS f\u00fcr was?<\/a>
\n13.21a SQL Standards<\/a>
\n13.21b SQL Teilsprachen<\/a>
\n13.24 SELECT FROM WHERE<\/a>
\n13.44 NULL != NULL<\/a>
\n13.46 Unteranfragen mit IN, EXISTS, ALL, ANY<\/a>
\n13.48 SQL Datentypen<\/a><\/p>\n

postgresql<\/h3>\n

postgresql – can’t create database – OperationalError: source database \u201ctemplate1\u201d is being accessed by other users<\/a><\/p>\n

PostgreSQL Data Types<\/a>
\nPostgreSQL Show Tables<\/a>
\nShow tables in PostgreSQL<\/a>
\nPostgreSQL Show Databases<\/a><\/p>\n

Documentation<\/h4>\n

9.20. Aggregate Functions<\/a><\/p>\n

SELECT DISTINCT, GROUP BY<\/h3>\n

SQL – select DISTINCT<\/a>
\nIs there any difference between GROUP BY and DISTINCT<\/a><\/p>\n

NoSQL – Graph Databases<\/h1>\n

OrientDB<\/h4>\n

Demo Database<\/a><\/p>\n

Wikipedia<\/h4>\n

Multi-model database<\/a><\/p>\n

YouTube<\/h4>\n

OrientDB – the 2nd generation of (MultiModel) NoSQL by Luigi Dell’Aquila<\/a>
\nMichael Hackstein: Multi-Model NoSQL Databases<\/a>
\nBuilding on Multi-Model Databases<\/a><\/p>\n

WEKA<\/h1>\n

Weka 3: Machine Learning Software in Java<\/a>
\nWeka Wiki<\/a>
\nWEKA API Tutorial: How to use WEKA in JAVA<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

An Animated Guide: Knowing SQL Internal Processes makes SQL Easy, makes SQL easy WHERE-Klausel im Detail Lecture Week 3 Postgres Handles More Than You Think Don’t Do This B-Baum AVL-Baum CTE in SQL What is the difference between tree depth and height? Height, Depth and Level of a Tree Nested set model Nested Sets Jede […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-10019","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/10019","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10019"}],"version-history":[{"count":50,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/10019\/revisions"}],"predecessor-version":[{"id":10593,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=\/wp\/v2\/posts\/10019\/revisions\/10593"}],"wp:attachment":[{"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10019"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10019"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bachi.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10019"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}