Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Databases Overview

Databases Overview

This is a overview presentation on databases that I gave in Rudbecks upper secondary school in Stockholm through the Transfer network. Transfer is a non-profit knowledge transfer network whose aim is to bring professionals in all sorts of diverse areas to Sweden’s upper secondary schools. Teachers can use the Transfer website to request a lecture in an area and Transfer then matches those requests with the profiles of the affiliated professionals, which can then either accept or decline the request.

Approx 45 minutes.

Mårten Gustafson

November 12, 2010

More Decks by Mårten Gustafson

Other Decks in Technology


  1. Mårten Gustafson Hitta.se Java PHP HTML Oracle MySQL PostgreSQL OpenLDAP

    Microsoft ActiveDirectory Riak CouchDB Linux Windows OS X
  2. Relational databases • “Most of it” (it’s the standard) •

    Present in “all” businesss • eg. Financial systems • eg. Your schools website
  3. “traditionals” Namn Typ Microsoft SQL Relational Oracle Relational PostgreSQL Relational

    MySQL Relational Microsoft Active Directory Hierarchial OpenLDAP Hierarchical Apache Directory Server Hierarchical IBM Tivoli Directory Server Hierarchical Novell eDirectory Hierarchical
  4. “non-traditional” Namn Typ CouchDB Document MongoDB Document RavenDB Document Neo4J

    Graph InfiniteGraph Graph Amazon Dynamo Key/Value Dynomite Key/Value Riak Key/Value Redis Key/Value Scalaris Key/Value Tokyo Cabinet Key/Value Voldemort Key/Value Google BigTable Column family HBase Column family Cassandra Column family
  5. Try it Windows OS X / Linux Graph Neo4J Neo4J

    Key/Value ? Riak Document CouchDB CouchDB Relational PostgreSQL PostgreSQL
  6. In the corporate world • Now - now: relational databases

    • Now - indirect: hierarchical • Future? • My guess: document, key/value