SQL and database - xinshuaiqi/My_books GitHub Wiki

Database

DB ranking: https://db-engines.com/en/ranking

  • MongoDB / NoSQL
  • MySQL

what is database

  • structured collection of data
  • database models:
    • Relational model
      • RDBMS: relational database management system
      • Oracle, MySQL, PostgreSQL
      • composition:
        • Key
        • Attributes
        • tuples
    • Hierarchical model
    • network model
  • CMonsistence
  • Availability
  • Network partitioning

MySQL

How to load csv to mysql


NoSQL

  • 列存储/Wide Column Stores: HBase, Cassandra, Hypertable,Google BigTable
  • **文档存贮/DocumenuchDB
  • Key-value: Redis; DynamoDB, Riak, Ehcache
  • Graph: Neo4J, Titan, GEMS
  • Queries: SPARQL, Cypher

DynamoDB

MongoDB (NoSQL)

William Liu--解析NoSQL之MongoDB(优势、应用场景、应用分析及趋势)

  • 容易横向扩展
  • 支持大量数据的访问
⚠️ **GitHub.com Fallback** ⚠️