Datenbank-Programmierung

Hier eine Liste von Links zu weiteren Informationen im Internet, die für die Vorlesung "Einführung in Datenbanken" im weiteren Sinne relevant sind. Die Liste ist ständig im Aufbau, teilweise ist die Auswahl noch eher zufällig. Wenn Sie weitere interessante Resourcen im Internet finden, schicken Sie mir bitte eine EMail. Wenn Sie einige der verlinkten Seiten für schlecht halten, informieren Sie mich bitte auch (manche habe ich nur kurz überflogen, zum Teil auch vor langer Zeit). Links zu Software finden Sie auf der Software-Seite, Lehrbücher und Übersichtsartikel auf der Literatur-Seite.

Datenbank-Vorlesungen (Foliensätze etc.)

• Vorlesung CS145 "Introduction to Databases" von Jeffrey D. Ullman (Stanford)
  [http://infolab.stanford.edu/~ullman/fcdb/aut07/]
• Vorlesungen von Jeffrey D. Ullman (Stanford)
  [http://infolab.stanford.edu/~ullman/cs345-notes.html]
• Vorlesung "Datenbanksysteme" von Oliver Vornberger (Osnabrück) (mit Video)
  [http://www-lehre.inf.uos.de/~dbs/2011/]
• Vorlesung "DB " von Torsten Grust, Christian Duta, Benjamin Dietrich (Tübingen)
  [https://db.inf.uni-tuebingen.de/teaching/DB1WS2019-2020.html]
• Vorlesung: Neuere Entwicklungen für Datenmodelle (Prof. Dr. Stefan Deßloch)
  [http://wwwlgis.informatik.uni-kl.de/cms/courses/datenmodelle/]
• Folien aus einer Vorlesung von Hugh Darwen (mit SQL-Kritik)
  [http://www.dcs.warwick.ac.uk/~hugh/CS253/CS253-TheAskewWall.pdf]
• Folien aus einer Vorlesung von Hugh Darwen (zu Nullwerten)
  [http://www.dcs.warwick.ac.uk/~hugh/CS253/CS253-Missing-info-without-NULL.pdf]
• Vorlesung "Database Management Systems" von Dr. Osmar R. Zaïane
  [http://webdocs.cs.ualberta.ca/~zaiane/courses/cmput391-02/materials.shtml]
• Vorlesung "Database Systems" von Natasha Alechina
  [http://www.cs.nott.ac.uk/~nza/G51DBS/]
• Vorlesung "Big Data Engineering" von Jens Dittrich (Saarbrücken)
  [https://bigdata.uni-saarland.de/datenbankenlernen/bde/index.html]
• Vorlesung "Einführung in Datenbanken" von Wolfgang May (Göttingen)
  [https://www.dbis.informatik.uni-goettingen.de/Teaching/DB/]

SQL Tutorials (teils mit Online Übungen)

• SQL Zoo
  [https://sqlzoo.net/]
• SQL Island (SQL Lernspiel)
  [http://sql-island.informatik.uni-kl.de/]
• Select Star SQL (mit Daten über Todesstrafe in Texas)
  [https://selectstarsql.com/]
• SQL Tutorial von w3schools.com
  [https://www.w3schools.com/sql/]
• SQL Tutor 1.02
  [http://sqltutor.fsv.cvut.cz/cgi-bin/sqltutor]
• Tech on the Net: SQL Tutorial (Browser-basierte SQL-Implementierung)
  [https://www.techonthenet.com/sql/]
• SQL_Tutorial des Leistungskurses Informatik, Lichtenbergschule Darmstadt
  [https://imoodle.de/sqltutorial/home.html]
• Schemaverse (SQL Lernspiel, Eroberung von Planeten)
  [https://schemaverse.com/]
• Wikibooks: Einführung in SQL (Jürgen Thomas)
  [http://de.wikibooks.org/wiki/Einf%C3%BChrung_in_SQL]
• Introduction to Structured Query Language (by James Hoffman)
  [http://www.sql.ru/docs/sql/tutorial/]

Tutorien und Lehrbücher zu spezielleren Themen

• Oracle/SQL Tutorial (by Michael Gertz)
  [http://www.mathcs.emory.edu/~cheung/Courses/377/Others/tutorial.pdf]
• DSP: Datenbank, SQL, PHP (von Christoph Reeg)
  [http://ffm.junetz.de/members/reeg/DSP/]
• Oracle/Access/Visual Studio Tutorials and Help Page (by Richard Holowczak)
  [http://www.holowczak.com/tutorials.html]
• Hugh Darwen: An Introduction to Relational Database Theory (Free E-Book with Advertisements)
  [http://bookboon.com/en/textbooks/it-programming/an-introduction-to-relational-database-theory]
• Tutorial zu Oracle PL/SQL (von Yu-May Chang, Jeff Ullman u.a.)
  [http://www.mathcs.emory.edu/~cheung/Courses/377/Others/or-plsql.html]
• Tutorial zu Oracle Triggern (von Yu-May Chang, Jeff Ullman u.a.)
  [http://www.mathcs.emory.edu/~cheung/Courses/377/Others/or-triggers.html]
• Tutorial zu Oracle Pro*C (von Ankur Jain, Jeff Ullman u.a.)
  [http://www.mathcs.emory.edu/~cheung/Courses/377/Others/or-proc.html]
• Tutorial zu Oracle Loader (von Jeff Ullman u.a.)
  [http://www.mathcs.emory.edu/~cheung/Courses/377/Oracle/SQL-loader/or-load.html]
• Oracle SQL*Loader FAQ
  [http://www.orafaq.com/wiki/SQL*Loader_FAQ]
• 12 Common Mistakes and Missed Optimization Opportunities in SQL
  [https://hakibenita.com/sql-dos-and-donts]
• "die extra harten Kopfnüsse" (SQL-Rätsel)
  [https://www.arelium.de/download/]

SQL-Standard:

• Entwurf des SQL:2011 Standards (kostenloses Download): ZIP-Archiv (der offizielle Standard ist nicht kostenlos).
  [http://www.wiscorp.com/sql20nn.zip]
• Entwurf des SQL:2008 Standards (kostenloses Download): ZIP-Archiv (der offizielle Standard ist nicht kostenlos).
  [http://www.wiscorp.com/sql200n.zip]
• Entwurf des SQL:2003 Standards (kostenloses Download): ZIP-Archiv (der offizielle Standard ist nicht kostenlos).
  [http://www.wiscorp.com/sql_2003_standard.zip]
• SQL-92 Standard (Entwurf als txt-Datei, kostenlos)
  [http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt]
• Links zum SQL-Standard (von Markus Winand)
  [http://modern-sql.com/de/standard]
• Übersicht und Informationen zum SQL-Standard
  [http://www.jcc.com/resources/sql-standards]
• SQL:2016 Standard (Expensive Paper Version)
  [https://www.iso.org/standard/63556.html]
• ISO Standards on Computer Languages (includes SQL-99)
  [http://www.iso.ch/cate/35060.html]

Grammatiken verschiedener Versionen des SQL-Standards:

• SQL-Grammatiken von Jake Wheat: Übersicht
  [https://jakewheat.github.io/sql-overview/]
• SQL-Grammatiken von Ron Savage
  [https://github.com/ronsavage/SQL]
• Navigierbare Grammatik von SQL-2016 (Jake Wheat)
  [https://jakewheat.github.io/sql-overview/sql-2016-foundation-grammar.html]
• Navigierbare Grammatik von SQL-2008 (Jake Wheat)
  [https://jakewheat.github.io/sql-overview/sql-2008-foundation-grammar.html]
• Navigierbare Grammatik von SQL-2003 (Ron Savage)
  [https://ronsavage.github.io/SQL/sql-2003-2.bnf.html]
• SQL 99 Grammatik (Jake Wheat)
  [https://jakewheat.github.io/sql-overview/sql-1999-grammar.html]
• SQL 99 Grammatik (Ron Savage)
  [https://ronsavage.github.io/SQL/sql-99.bnf.html]
• SQL 92 Grammatik (Jake Wheat)
  [https://jakewheat.github.io/sql-overview/sql-92-grammar.html]
• SQL 92 Grammatik (Ron Savage)
  [https://ronsavage.github.io/SQL/sql-92.bnf.html]
• SQL92 Grammatik (NorKen Technologies)
  [http://www.mathcs.emory.edu/~cheung/Courses/377/Others/sql2-syntax.html]
• SQL Grammatik von Apache Calcite
  [https://calcite.apache.org/docs/reference.html]
• Grammatik von SELECT-Anfragen in SQLite
  [https://www.sqlite.org/lang_select.html]
• SQL Grammar von H2
  [http://www.h2database.com/html/grammar.html]

Weitere Informationen zum SQL-Standard:

• SQL-99 Complete, Really (Online-Buch von Peter Gulutzan und Trudy Pelzer)
  [https://mariadb.com/kb/en/sql-99/]
  [https://crate.io/docs/sql-99/en/latest/]
• Webseite "Modern SQL" (Markus Winand)
  [https://modern-sql.com/]
• Vortrag von Markus Winand über einige neueren SQL-Konstrukte
  [https://modern-sql.com/slides/ModernSQL-2019-05-08.pdf]
• Mimer SQL Validator
  [http://developer.mimer.com/validator/parser92/index.tml]
• Bericht über JSON-Unterstützung in SQL:2016
  [http://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip]
• SQL Feature Comparison
  [https://www.sql-workbench.eu/dbms_comparison.html]
• SQL Reserved Words (Drupal)
  [https://www.drupal.org/docs/develop/coding-standards/list-of-sql-reserved-words]
• SQL Reserved Words Checker (Pete Freitag)
  [https://www.petefreitag.com/tools/sql_reserved_words_checker/?word=SYS]
• Diskussion über Änderungen bei GROUP BY Attributen unter SELECT
  [http://rpbouman.blogspot.com/2007/05/debunking-group-by-myths.html]
• Portable SQL (DEVPIT)
  [http://devpit.org/wiki/Portable_SQL]
• NIST SQL Test Suite (User's Guide)
  [https://nvlpubs.nist.gov/nistpubs/Legacy/IR/nistir5998.pdf]
• NIST SQL Test Suite Goes Online (aus Computer 1997)
  [https://www.itl.nist.gov/div897/ctg/dm/ieee_sqlarticle.htm]
• Can I write portable SQL Statements?
  [https://dba.stackexchange.com/questions/257305/can-i-write-portable-sql-statements]
• PostgreSQL vs. SQL Server (MSSQL) - Extremely Detailed Comparison
  [https://www.enterprisedb.com/blog/microsoft-sql-server-mssql-vs-postgresql-comparison-details-what-differences]
• SQL portability gotchas
  [https://stackoverflow.com/questions/1063866/sql-portability-gotchas]
• Think ANSI Standard SQL Is Fully Portable Between Databases? Think Again.
  [https://www.devx.com/database-development-zone/32852/]
• The History of SQL Standards
  [https://learnsql.com/blog/history-of-sql-standards/]

SQL Datentypen in verschiedenen Systemen:

• PostgreSQL
  [https://www.postgresql.org/docs/9.5/datatype.html]
• MariaDB
  [https://mariadb.com/kb/en/library/data-types/]
• MySQL
  [https://dev.mysql.com/doc/refman/8.0/en/data-types.html]
• Oracle 21c SQL Language Reference: Data Types
  [https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Data-Types.html]
• Oracle 11g Concepts: Data Types
  [https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm]
• Oracle 10g SQL Quick Reference: Datatypes
  [https://docs.oracle.com/cd/B12037_01/server.101/b10758/sqlqr06.htm]
• Microsoft SQL Server
  [https://docs.microsoft.com/en-us/sql/t-sql/data-types/]
• w3schools: SQL Data Types for MySQL, SQL Server, and MS Access
  [https://www.w3schools.com/sql/sql_datatypes.asp]
• ODBC
  [https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/appendix-d-data-types]
• ...

Rekursive Sichten:

• WITH RECURSIVE and MySQL (Guilhem Bichot)
• Why does a Recursive CTE in Transact-SQL require a UNION ALL and not a UNION?
• On recursive queries (Egor Rogov, Postgres Professional)

Geschichtliche Entwicklung von Oracle SQL:

• Oracle7 SQL Reference (7.3: February 1996)
  [https://docs.oracle.com/cd/A57673_01/DOC/server/doc/SQL73/toc.htm]
• Oracle8 SQL Reference (8.0: December 1997)
  [https://docs.oracle.com/cd/A64702_01/doc/server.805/a58225/toc.htm]
• Oracle8i SQL Reference (8.1.6: December 1999)
  [https://docs.oracle.com/cd/A81042_01/DOC/server.816/a76989/toc.htm]
• Oracle9i SQL Reference
  [https://docs.oracle.com/cd/A91202_01/901_doc/server.901/a90125/toc.htm]
• Oracle Database SQL Reference 10g (10.1: December 2003)
  [https://docs.oracle.com/cd/B14117_01/server.101/b10759/toc.htm]
• Oracle Database SQL Reference 11g (July 2013)
  [https://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm]
• Oracle Database SQL Language Reference 12c (12.1.0.2: July 2017)
  [https://docs.oracle.com/cd/B28359_01/server.111/b28286/toc.htm]
• Oracle Database SQL Language Reference 18c (18.1: February 2019)
  [https://docs.oracle.com/en/database/oracle/oracle-database/18/sqlrf/]

Literatur zu PostgreSQL:

• PostgreSQL Documentation: SQL Commands
  [https://www.postgresql.org/docs/9.4/sql-commands.html]
• PostgreSQL Documentation: Chapter 48. System Catalogs
  [https://www.postgresql.org/docs/9.4/catalogs.html]
• Lorenzo Alberton: Extracting Meta Information from PostgreSQL
  [http://www.alberton.info/postgresql_meta_info.html]
• TRUNCATE
  [https://www.postgresql.org/docs/9.1/sql-truncate.html]
• START TRANSACTION
  [https://www.postgresql.org/docs/9.1/sql-start-transaction.html]
• PostgreSQL Documentation: System Information Functions and Operators
  [https://www.postgresql.org/docs/current/functions-info.html]
• PostgreSQL Wiki
  [https://wiki.postgresql.org/wiki/Main_Page]

PostgreSQL Administration und Implementierungs-Details:

• PostgreSQL Documentation: Multiversion Concurrency Control
  [https://www.postgresql.org/docs/7.2/mvcc.html]
• Can I rollback a transaction I've already committed? (data loss)
  [https://stackoverflow.com/questions/12472318/can-i-rollback-a-transaction-ive-already-committed-data-loss/]
• Let’s talk dirty (PostgreSQL Extension pg_dirtyread)
  [https://www.depesz.com/2012/04/04/lets-talk-dirty/]
• Explicit Locking, Deadlocks
  [https://www.postgresql.org/docs/9.1/explicit-locking.html]
• Object Identifier Types
  [https://www.postgresql.org/docs/9.5/datatype-oid.html]
• Bruce Momjian: Postgres - Mvcc Unmasked
  [https://momjian.us/main/writings/pgsql/mvcc.pdf]
• Egor Rogov (postgrespro): MVCC in PostgreSQL-1. Isolation
  [https://habr.com/ru/company/postgrespro/blog/467437/]
• Egor Rogov (postgrespro): MVCC in PostgreSQL-2. Forks, files, pages
  [https://habr.com/ru/company/postgrespro/blog/469087/]
• Egor Rogov (postgrespro): MVCC in PostgreSQL-3. Row Versions
  [https://habr.com/en/company/postgrespro/blog/477648/]
• Egor Rogov (postgrespro): 2-Day Introduction to PostgreSQL 11
  [https://postgrespro.com/education/courses/2dINTRO]
• Vlad Mihalcea:How does MVCC work?
  [https://vladmihalcea.com/how-does-mvcc-multi-version-concurrency-control-work/]
• Vladimir Svedov: Understanding System Columns in PostgreSQL
  [https://severalnines.com/blog/understanding-system-columns-postgresql]
• PostgreSQL Documentation: System Columns
  [https://www.postgresql.org/docs/current/ddl-system-columns.html]
• PostgreSQL Documentation: Routine Database Maintenance Tasks (Vacuuming)
  [https://www.postgresql.org/docs/current/maintenance.html]
• Database Page Layout
  [https://www.postgresql.org/docs/9.0/storage-page-layout.html]
• PostgreSQL 7.3.21 Developer's Guide
  [https://www.postgresql.org/docs/7.3/developer.html]
• Why is UPSERT so complicated?
  [https://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/]
• Log Insights (pganalyze): Lock Events
  [https://pganalyze.com/docs/log-insights/locks]
• Marco Slot: When Postgres blocks: 7 tips for dealing with locks
  [https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/]
• Bruce Momjian: Database Hardware Selection Guidelines
  [https://momjian.us/main/writings/pgsql/hw_selection.pdf]
• PostgreSQL Documentation: WAL Internals
  [https://www.postgresql.org/docs/9.1/wal-internals.html]
• The Internals of PostgreSQL (Hironobu Suzuki): Write Ahead Logging
  [https://www.interdb.jp/pg/pgsql09.html]
• The Internals of PostgreSQL (Hironobu Suzuki)
  [https://www.interdb.jp/pg/index.html]

Literatur zu Microsoft SQL Server:

• Multiplication and Division with Numerics
  [https://blogs.msdn.microsoft.com/sqlprogrammability/2006/03/29/multiplication-and-division-with-numerics/]
• Microsoft SQL Server Version List
  [https://sqlserverbuilds.blogspot.com/]
• Hinweise für den Optimierer: Tabellenhinweise
  [https://docs.microsoft.com/de-de/sql/t-sql/queries/hints-transact-sql-table]

SQLite: Spezielle Informationen, u.a. zur Implementierung:

• SQLite as an Application File Format
  [https://sqlite.org/appfileformat.html]
• SQLite Database File Format
  [https://sqlite.org/fileformat2.html]
• Atomic Commit in SQLite
  [https://sqlite.org/atomiccommit.html]
• WAL: Write Ahead Logging in SQLite
  [https://sqlite.org/wal.html]

MySQL: Spezielle Informationen, u.a. zur Implementierung:

• MySQL History and Architecture (Probekapitel aus MySQL Internals)
  [https://www.oreilly.com/library/view/understanding-mysql-internals/0596009577/ch01.html]

JDBC:

• Wikipedia zu JDBC
  [https://de.wikipedia.org/wiki/Java_Database_Connectivity]
  [https://en.wikipedia.org/wiki/Java_Database_Connectivity]
• JDBC Overview (Oracle)
  [https://www.oracle.com/technetwork/java/overview-141217.html]
• JDBC Basic Tutorial (Oracle)
  [https://docs.oracle.com/javase/tutorial/jdbc/basics/index.html]
• JDBC Seite für Java 5 (JDBC 3.0), inklusive "Getting Started"
  [https://docs.oracle.com/javase/1.5.0/docs/guide/jdbc/index.html]
• JDBC API Documentation
  [https://docs.oracle.com/javase/8/docs/api/java/sql/package-summary.html]
  [https://docs.oracle.com/javase/8/docs/api/javax/sql/package-summary.html]
  [https://docs.oracle.com/javase/8/docs/technotes/guides/jdbc/]
• Lance Andersen: JDBC 4.1 Specification (JSR 221), July 2011.
  [https://download.oracle.com/otn-pub/jcp/jdbc-4_1-mrel-spec/jdbc4.1-fr-spec.pdf]
• Oracle zu Java-Datenbank Technologien
  [https://www.oracle.com/technetwork/java/javase/tech/index-jsp-136101.html]
• PostgreSQL JDBC Driver
  [https://jdbc.postgresql.org/documentation/head/index.html]
• Dokumentation zum JDBC Driver für Microsoft SQL Server
  [https://docs.microsoft.com/en-us/sql/connect/jdbc/programming-guide-for-jdbc-sql-driver]
• ...

Datenbank-Sicherheit:

• Database Security (Wikipedia)
  [https://en.wikipedia.org/wiki/Database_security]
• Database Security Best Practices (Paul Rubens, eSecurity Planet)
  [https://www.esecurityplanet.com/network-security/6-database-security-best-practices.html]
• SQL-Injection (Wikipedia)
  [https://de.wikipedia.org/wiki/SQL-Injection]
  [https://en.wikipedia.org/wiki/SQL_injection]
• Carsten Eilers: SQL-Injection im Schnelldurchlauf
  [https://www.ceilers-news.de/serendipity/256-SQL-Injection-im-Schnelldurchlauf.html]
• Steve Friedl: SQL Injection Attacks by Example
  [http://unixwiz.net/techtips/sql-injection.html]
• pentestmonkey: Postgres SQL Injection Cheat Sheet
  [http://pentestmonkey.net/cheat-sheet/sql-injection/postgres-sql-injection-cheat-sheet]
• Bundesamt für Sicherheit in der Informationstechnik (BSI): Sichere Passwörter erstellen
  [https://www.bsi.bund.de/DE/Themen/Verbraucherinnen-und-Verbraucher/Informationen-und-Empfehlungen/Cyber-Sicherheitsempfehlungen/Accountschutz/Sichere-Passwoerter-erstellen/sichere-passwoerter-erstellen_node.html]
• Bundesamt für Sicherheit in der Informationstechnik (BSI): IT-Grundschutz-Kompendium
  [https://www.bsi.bund.de/SharedDocs/Downloads/DE/BSI/Grundschutz/Kompendium/IT_Grundschutz_Kompendium_Edition2021.html]
• xkcd Webcomic zum Thema „SQL Injection”
  [https://xkcd.com/327/]
• Johannes Schildgen, Jessica Rosin: Game-based Learning of SQL Injections. (DataEd'2022)
  [https://dl.acm.org/doi/10.1145/3531072.3535321]

Fehler in SQL:

• The Danger of FETCH FIRST ROW ONLY (Ember Crooks)
  [https://datageek.blog/en/2014/01/28/the-danger-of-fetch-first-row-only/]

Objektdatenbanken, Objektorientierte DB-Schnittstellen:

• Object Database Management Group (ODMG)
  [http://www.odmg.org/]
• Object Database Management Systems (ODBMS.ORG)
  [http://www.odbms.org/]
• Wikipedia: Object-Relational Mapping
  [https://en.wikipedia.org/wiki/Object-relational_mapping]
• Java Data Objects (JDO)
  [http://java.sun.com/jdo/index.jsp]
• Artikel "Optimizing Object/Relational Mapper Performance"
  [http://www.infoq.com/articles/optimizing-orm-performance]

Graphdatenbanken, Ontologien:

• Neo4J Graph Platform
  [https://neo4j.com/]
• Apache Jena (Java framework for building Semantic Web and Linked Data applications)
  [https://jena.apache.org/]
• Resource Description Framework (Wikipedia)
  [https://de.wikipedia.org/wiki/Resource_Description_Framework]
• RDF Schema (Wikipedia)
  [https://de.wikipedia.org/wiki/RDF-Schema]
• Web Ontology Language (Wikipedia)
  [https://de.wikipedia.org/wiki/Web_Ontology_Language]
• SPARQL (Wikipedia)
  [https://en.wikipedia.org/wiki/SPARQL]
• What is a Knowledge Graph? (ontotext.com)
  [https://www.ontotext.com/knowledgehub/fundamentals/what-is-a-knowledge-graph/]

Andere Datenmodelle, NoSQL-Datenbanken:

• GraphQL
  [https://graphql.org/]
• Vortrag zur Motivation von MongoDB für ein Stammbaum-Projekt, mit kurzgefasster Geschichte von Datenbanken (Steven Francia)
  [https://de.slideshare.net/spf13/modern-database-systems-17862460]
• ...

JSON (JavaScript Object Notation):

• Introducing JSON
  [https://www.json.org/json-en.html]
• Einführung in JSON
  [https://www.json.org/json-de.html]
• The JSON Data Interchange Syntax (ecma Standard ECMA-404)
  [https://www.ecma-international.org/publications-and-standards/standards/ecma-404/]
• RFC 8259 - The JavaScript Object Notation (JSON) Data Interchange Format
  [https://tools.ietf.org/html/rfc8259]
• Wikipedia (Englisch): JSON
  [https://en.wikipedia.org/wiki/JSON]
• Wikipedia (Deutsch): JSON
  [https://de.wikipedia.org/wiki/JavaScript_Object_Notation]
• JSON Schema
  [https://json-schema.org/]
• JSONiq - The JSON Query Language
  [https://www.jsoniq.org/]

Dateiformat CSV:

• RFC 4180 (RFC Editor)
• Wikipedia (englisch): Comma Separated Values
• Wikipedia (deutsch): CSV (Dateiformat)
• What is CSV? (aus der Anleitung zur SuperCSV Bibliothek)
• Libraries for Reading and Writing CSV in Core Java (Jean Fernando, Stack Abuse)
• Reading and Writing CSV in Core Java (Jean Fernando, Stack Abuse)
• Reading and Writing CSV with Apache Commons CSV (Jean Fernando, Stack Abuse)
• Apache Commons CSV (User Guide der Bibliothek)
• Apache Commons CSV (Homepage der Bibliothek)
• Open CSV (Bibliothek)
• Super CSV Library
• xsv: Programm für CSV

EMail-Listen, Fachgruppen, Foren:

• DBWORLD EMail List
  [http://research.cs.wisc.edu/dbworld/]
• ACM SIGMOD (Special Interest Group on Mangament of Data)
  [http://bunny.cs.uiuc.edu/README.html]
  [http://www.acm.org/catalog/sigs/sigmod.html]
  [http://www.acm.org/sigmod/sigmodinfo/membership.html]
• Database Junior Researcher Organization
  [http://www.dbjunior.org/]
• GI-Arbeitskreis "Grundlagen von Informationssystemen
  [http://wwwiti.cs.uni-magdeburg.de/iti_db/ak/]
• Fachgruppe "Datenbanksysteme" der GI
  [http://wwwdb.informatik.uni-rostock.de/GI-FG-DB/]

DB-Literatur, Literatur-Suche, Bibliographien:

• DBLP: Database Systems and Logic Programming (Bibliography Server)
  [http://www.informatik.uni-trier.de/~ley/db/index.html]
• VLDB.org (Konferenz für "Very Large Databases")
  [http://www.vldb.org/]
• ACM Digital Library (aus dem Uni-Netz kostenloser Download)
  [http://www.acm.org/dl/]
• Digital Library der IEEE Computer Society (aus dem Uni-Netz kostenloser Download)
  [http://www.computer.org/portal/web/csdl]
• arXiv/CoRR (Computing Research Repository)
  [https://arxiv.org/corr]
• CiteSeer (Suchmaschine für wissenschaftliche Artikel)
  [http://citeseerx.ist.psu.edu/]
• Bibliographies about Database Research (Karlsruhe)
  [http://liinwww.ira.uka.de/bibliography/Database/index.html]
• Datenbank-Spektrum: Archiv
  [http://www.datenbank-spektrum.de/archiv.html]

Geschichtliches zu Datenbanken:

• System R Page
  [http://www.mcjones.org/System_R]
• A Timeline of Database History
  [https://www.quickbase.com/articles/timeline-of-database-history]
• Originaler Artikel von Codd über das relationale Modell
  [http://www.cs.nott.ac.uk/~nza/G51DBS/codd.pdf]
• RDBMS Genealogy (Felix Naumann, HPI)
  [https://hpi.de/naumann/projects/rdbms-genealogy.html]

Weitere Informationsquellen (Vermischtes):

• Seite von Hugh Darwen, SQL-Kritiker, Mitautor von The Third Manifesto
  [http://www.dcs.warwick.ac.uk/~hugh/]
• Provokanter Artikel über DB-Entwurf (von Badia/Lemire in ACM SIGMOD Record 40:3, 2011)
  [http://dx.doi.org/10.1145/2070736.2070750]
• FORWARD: A declarative, rapid development framework for data-driven Ajax reports and applications
  [http://forward.ucsd.edu/]
• 10 Common Mistakes Java Developers Make when Writing SQL (JOOQ)
  [http://blog.jooq.org/2013/07/30/10-common-mistakes-java-developers-make-when-writing-sql/]
• Josh's Rules (of Database Contracting)
  [https://it.toolbox.com/blogs/josh-berkus/joshs-rules-of-database-contracting-062707]

Prof. Dr. Stefan Brass

Impressum