這篇文章簡單描述了 資料庫的 技術演進 與 解決問題的簡述, 簡單的圖示說明了一切~
好文 - Cache is the new RAM (DB 技術演進史)
每個時代遇到的問題都不一樣, 資料庫的類型、技術都是為了解決當下的問題而設計, 非常有趣的歷史回顧~
下述摘錄此文圖片文字敘述: Cache is the new RAM | MemSQL, 詳細說明請回原文觀看.
硬體速度差異
- CPU Register: 1ns
- Main Memory: 100ns
- Flash Drive: 100,000 ns
- Hard Drive: 10,000,000 ns
Database 相關技術的演進歷史
- 2000: Load Balancing Solves Everything!
- 2002: Replication Solves Everything!
- 2004: Memcached Solves Everything!
- 2006: Sharding Solves Everything!
- 2008: NoSQL Solves Everything!
- 2010: Map/Reduce Solves Everything!
- 2012: NoSQL Solves Everything, Again!
- 2014: What now?
- Load balancing (with failover)
- Replication (without wasted hardware)
- RAM Storage (without cache invalidation)
- Sharding (with management)
- Analytics (without ETL headaches)
- SQL (because, math)
- 2014: SQL RAM Clusters Solve Everything
- Throughput and Latency always have the last laugh.
- 2016: [???] Sloves Everything!
上述名詞不清楚的, 想再進階的, 可再搭配下述兩篇服用:
好文一篇~~~
但 "Sloves" 應該改成 "Solves" ???
最上面一個字打錯, 複製到下面就全都錯~ 感謝指正~ 🙂