Benutzer:MovGP0/Azure/Data Storage

aus Wikipedia, der freien Enzyklopädie
   MovGP0        Über mich        Hilfen        Artikel        Weblinks        Literatur        Zitate        Notizen        Programmierung        MSCert        Physik      


Azure Data Storage

Relational

  • 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

  • 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

Column

  • splits data of an entry into groups of columns with the same key
Examples
  • Cassandra
  • HBase

Document

  • hierarchical data possible
  • support for XML, YAML, JSON, BSON
  • queries of non-keys are possible, but should use indexers
Examples
  • MongoDB
  • RavenDB
  • CouchDB

Graph

  • stores data as objects and relationships
Examples
  • Neo4j

Andere

  • NuoDB
    • NewSQL database
    • supports transactional integrity
    • has distributed storage and querying

HDInsight

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