#nosql

SQL vs NoSQL Database Differences Explained with few Example DB

Published at April 11, 2019 ·  1 min read

非常详细的解释了 sql 和 nosql 之间的区别。1. sql 是基于 table 的,而 nosql 是基于 document,kv 对,图或者 宽表,也就是说在 sql 中,sql 是包含若干 table,而 nosql 则是若干 document 的集合。2. 复杂的查询,我想这也是两者最为关键的区别,sql 可以轻易的完成多种条件关系组合的复杂查询,而 nosql 却将这种复杂的关系固化到 document 的 kv 组合中 3. 两者在 scale 时的区别sql 适合 vertically scalable,也就是说,提高服务器的硬件,比如 ram,cpu,disk 之类即可提高数据库的负载性能,而 nosql 则是需要通过增加数据库服务器的数量来提高负载。4. sql 设计遵循 acid, atomicity, consistency, isolation, durability, nosql 则遵循 cap , consistency, availability and partition tolerance SQL vs NoSQL Database Differences Explained with few Example DB...


Tags

abcs accept acid activemq affinity algorithm allocation android array async aws b+tree b-tree backoff benchmark best-practices bfs big-o bigquery bind bitcount blog break broker bubble buffer cache cap cert cgroups channel citus class classmethod cluster concurrency config consumer container cookie cors crawler cronjob csrf ctr data-science data-structure database datadog dataflow datascience decorator defer dfs distributed django dns docker double-shipping drf ecosia elastic-search enumerate epoll extra facebook-pixel financial-report flask flutter forward-proxy freelance frp garbage-collector gc gcp generator get gil git golang goroutine graphql ha handbook haproxy hash hash-slot hashring hashtable hpa http http-auth http-proxy http_proxy https index innodb instagram intergration interview ios javascript jinja2 jobboard jwt k8s kafka kibana kqueue label lambda layer4 layer7 lean levels.io linked-list linux list listen loadbalancer logs long-tail lru marketing master matplotlib memory merge metaclass metaprogramming metrics metrics-server microservices mitm model mq myisam mysql namespace nat netflix network-extension nginx nodejs nomad nosql npm oodesign openssl optimization orm pandas parallelism parkinglot patroni permission pg pipeline pixelme post postgresql postresql prefetch_related prerender process proxy proxycommand put pvm python queue rabbitmq rbac react-native rebase redis redis-cluster replication resource rest restfulapi retargeting retry revenue reverse-proxy rocketmq saas scaleable search-engine security select seo serverless service session set shadosocks shadowsocks shard sharding shell shopify sigint signal sigterm slack slave slow-query sniper sns socket socks5 source-code spa sql sqlalchemy sqs ssh ssl ssl-pinning stack startup state stateful stateless staticmethod string struct swift switch syscall system-design systemctl tcp tcp-proxy thread tmpreaper token traefik trustkit tunning type typeform udp variable vc vpn vuejs web web-development where yarn zset 削峰 宽索引 异步 窄索引 解耦 跨域 跳板机


Archives

2019 (137)
0001 (1)