Database and file system

Database types

SQL v.s. NoSQL

• SQL

  • Pros

    • support transaction, which is good for financial application.

    • structure data: use structured query language and have a predefined schema

      • analytic scenario?

  • Cons

    • hard to scale out

    • low availability

      • low throughput, qps is generally lower than NoSQL DB

• NoSQL

  • Pros

    • dynamic schema

    • highly available: eventual consistent, replication

    • highly and easily scalable

Distributed database