MovGP0        Über mich        Hilfen        Artikel        Weblinks        Literatur        Zitate        Notizen        Programmierung        MSCert        Physik      


Azure Data Storage

Bearbeiten

Relational

Bearbeiten
  • relational SQL Databases
  • suitable for financial transactions because of transactional integrity
Examples
  • Azure SQL Database
  • SQL Server
  • Oracle
  • MySQL
  • SQL Compact
  • SQLite
  • Postgres

Key/Value

Bearbeiten
  • stores data in Key/Value tuples
Examples
  • Azure Blob Storage
    • maps URI to file
    • URI corresponds to folder and filename
  • Azure Table Storage
    • Value is Entity with properties
    • Queries on Entities properties are possible, but inefficient
    • Entity properties are optional
  • Azure Cache
  • Redis
  • Memcached
  • Riak
  • splits data of an entry into groups of columns with the same key
Examples
  • Cassandra
  • HBase

Document

Bearbeiten
  • hierarchical data possible
  • support for XML, YAML, JSON, BSON
  • queries of non-keys are possible, but should use indexers
Examples
  • MongoDB
  • RavenDB
  • CouchDB
  • stores data as objects and relationships
Examples
  • Neo4j
  • NuoDB
    • NewSQL database
    • supports transactional integrity
    • has distributed storage and querying

HDInsight

Bearbeiten
  • Hadoop with Map/Reduce
  • Framework to make data analysis on NoSQL databases
  • minimize cost by using a PowerShell skript to manage jobs and clusters