$30 off During Our Annual Pro Sale. View Details »

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
Tweet

More Decks by Mårten Gustafson

Other Decks in Technology

Transcript

  1. Databases overview
    Mårten Gustafson, 2010-11-12
    Hitta.se

    View Slide

  2. Mårten Gustafson
    Hitta.se
    Java
    PHP
    HTML
    Oracle
    MySQL
    PostgreSQL
    OpenLDAP
    Microsoft ActiveDirectory
    Riak
    CouchDB Linux
    Windows
    OS X

    View Slide

  3. Databases

    View Slide

  4. * Data
    * Baser

    View Slide

  5. fact / information / values
    %BUB
    * Data
    * Baser

    View Slide

  6. * Data
    * Baser

    View Slide

  7. fundamentals / basics
    CBTFT
    * Data
    * Baser

    View Slide

  8. foundation for information
    %BUBCBTFT
    * Data
    * Baser

    View Slide

  9. Information
    Mårten
    [email protected]

    View Slide

  10. Data models
    • Relational
    • Hierarchial
    • Graph
    • Document
    • Key-Value

    View Slide

  11. Relational databases
    Id Name
    1 Mårten
    Person E-mail
    1 [email protected]

    View Slide

  12. Relational databases
    • “Most of it” (it’s the standard)
    • Present in “all” businesss
    • eg. Financial systems
    • eg. Your schools website

    View Slide

  13. Hierarchical databases
    Mårten
    e-mail = [email protected]
    phone = 0705-10 51 98
    User

    View Slide

  14. Hierarchical databases
    • Account / logging in (Windows accounts)

    View Slide

  15. Graph databases
    Mårten
    [email protected]
    0705-10 51 98
    e-mail
    phone

    View Slide

  16. Graph databases
    • Facebook (friends, friends of friends, etc)
    • Twitter (followers)

    View Slide

  17. Document databases
    name: Mårten
    email: [email protected]
    phone: 0705-10 51 98

    View Slide

  18. Document databases
    • Hitta.se - PoI
    • train stations, weather, traffic cameras

    View Slide

  19. Key/Value
    Mårten => [email protected], 0705-10 51 98

    View Slide

  20. Key/Value
    • Hitta.se, profile pictures

    View Slide

  21. “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

    View Slide

  22. “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

    View Slide

  23. Try it
    Windows OS X / Linux
    Graph Neo4J Neo4J
    Key/Value ? Riak
    Document CouchDB CouchDB
    Relational PostgreSQL PostgreSQL

    View Slide

  24. In the corporate world
    • Now - now: relational databases
    • Now - indirect: hierarchical
    • Future?
    • My guess: document, key/value

    View Slide

  25. To read
    Deep dive
    Basics

    View Slide

  26. http://marten.gustafson.pp.se/
    [email protected]
    @martengustafson

    View Slide