際際滷

際際滷Share a Scribd company logo
Sarc Seminar January 2017
Data Series I
by sarc.io

NoSQL??
marc
sarc.io
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL?
= Non SQL
= Non relational
= Not only SQL
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
Non SQL
Non Relational
Why not
Relational ?
Why not SQL?
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
Relational DB (蟯螻
DB). 一危  蟯螻 覿襴
. 一危 手 覲伎
. JOIN  覲旧″ 一 螳
.  一危 /豌襴
. 觜 一危 蟯襴
. 螳 一危磯 觜襯 
 ?
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL
. 轟  麹
. RDB 曙 覲伎
. Next Gen DBs
- non-relational
- distributed
- open-source
- horizontally scalable
Not only
SQL
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
Distributed
. 一危 襴曙朱 り
. 一危  
. JOIN 覩語
Horizontally
Scalable. Scale-up << Scale-out
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL
. 一危 Cache
. 覦一危 一危 螻 豌襴
. /觜 一危 覲伎ヾ
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
DBMS Ranking
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
By 2017, the "NoSQL" label will
cease to distinguish DBMSs, leading
data and analytics leaders to select
multimodel and/or specific document-
style, key-value, graph and table-style
engines.
- Gartner Magic Quadrant for Operational Database Management Systems
2016
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL 譬襯
 Key-value store
- data  : key-value 
- key   殊蟆 
-  觜襴
- 譬襯 : eventually consistent,
ordered,
RAM (覦),
solid-state drive or rotating disk (
)
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL 譬襯
 Key-value store
eventually consistent ordered RA M solid-state drive
D ynam o IBM Inform ix C -ISA M A erospike A erospike
O racle N oSQ L D atabase InfinityD B C oherence C ouchbase Server
Riak M em cachedD B M em cached C oherence
Redis O racle N oSQ L D atabase
Tokyo C abinet
- 
-  
- 語覲
- 狩豺危 覲
-  豺危螻襴
-  襴觀
- IP forwarding 企
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL 譬襯
 Document store (Document-
oriented DB)
- data  : document
- Schemaless
- 覲旧″ 蟆譟郁唄  螳 (JOIN 覿螳)
: Xquery, JSON, SPASQL
data(value)  譟壱 螳
- Scale-out  (Sharding)
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL 譬襯
 Document store
- 
-  
- 觚襦蠏 
- Web 覿
- Twit
- 豈襦蠏碁
- MongoDB
- Amazon Dynamo
- Couchbase
- MarkLogic
- Azure DocumentDB
- Google Cloud Datastore
豢豌 : Database.guide
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL 譬襯
 Column-oriented DB (table-style)
- data 蟯襴 :   (RDB :   蟯襴)
-  一危 轟  蟆 
- 覈   轟 伎 手 螳煙 
-  一危 郁鍵 螳
- 豢 牛 ろ襴讌  企
- record 豌伎  譟壱  襴
-  企れ
Row-based
Column-based
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL 譬襯
- 
-  
- Data warehouse
- Relational DB 豌 (OLAP )
- HBase
- Cassandra
- Accumulo
- Hypertable
- Azure table storage
- Amazon Redshift
- Oracle Exadata
 Column-oriented DB
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL 譬襯
 Graph Database
- data + 蟯螻 
-  一危 覲旧″ Query 螳
- depth 2 豐螻狩 蟆 觜蟲 觜襴
- ACID 螻 (覲危 NoSQL BASE 螻)
- nodes, edges, properties 蟲
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
NoSQL 譬襯
- 
-  
- Fraud Detection
- Real-time 豢豌讌
- 蟯螻 蠍磯 Search
- SNS 覿
- IAM
- neo4j
- OrientDB
- Titan
- ArangDB
 Graph DB
Sarc Seminar January 2017  Data Series I
by sarc.io
NoSQL??
Reference
- 4 predictions for NoSQL technologies in 2016 (http://www.information-
age.com/evolution-knowledge-workers-123460640/)
- Magic Quadrant for Operational Database Management Systems
(https://www.gartner.com/document/3467318?ref=solrResearch&refval=17892
5527&qid=3a2cd31003f6a3917500e34591634ac1)
- What is ~~ Database? (http://database.guide)

More Related Content

NoSQL?? (marc)

  • 1. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? marc sarc.io
  • 2. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL? = Non SQL = Non relational = Not only SQL
  • 3. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? Non SQL Non Relational Why not Relational ? Why not SQL?
  • 4. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? Relational DB (蟯螻 DB). 一危 蟯螻 覿襴 . 一危 手 覲伎 . JOIN 覲旧″ 一 螳 . 一危 /豌襴 . 觜 一危 蟯襴 . 螳 一危磯 觜襯 ?
  • 5. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL . 轟 麹 . RDB 曙 覲伎 . Next Gen DBs - non-relational - distributed - open-source - horizontally scalable Not only SQL
  • 6. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? Distributed . 一危 襴曙朱 り . 一危 . JOIN 覩語 Horizontally Scalable. Scale-up << Scale-out
  • 7. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL . 一危 Cache . 覦一危 一危 螻 豌襴 . /觜 一危 覲伎ヾ
  • 8. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? DBMS Ranking
  • 9. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? By 2017, the "NoSQL" label will cease to distinguish DBMSs, leading data and analytics leaders to select multimodel and/or specific document- style, key-value, graph and table-style engines. - Gartner Magic Quadrant for Operational Database Management Systems 2016
  • 10. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL 譬襯 Key-value store - data : key-value - key 殊蟆 - 觜襴 - 譬襯 : eventually consistent, ordered, RAM (覦), solid-state drive or rotating disk ( )
  • 11. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL 譬襯 Key-value store eventually consistent ordered RA M solid-state drive D ynam o IBM Inform ix C -ISA M A erospike A erospike O racle N oSQ L D atabase InfinityD B C oherence C ouchbase Server Riak M em cachedD B M em cached C oherence Redis O racle N oSQ L D atabase Tokyo C abinet - - - 語覲 - 狩豺危 覲 - 豺危螻襴 - 襴觀 - IP forwarding 企
  • 12. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL 譬襯 Document store (Document- oriented DB) - data : document - Schemaless - 覲旧″ 蟆譟郁唄 螳 (JOIN 覿螳) : Xquery, JSON, SPASQL data(value) 譟壱 螳 - Scale-out (Sharding)
  • 13. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL 譬襯 Document store - - - 觚襦蠏 - Web 覿 - Twit - 豈襦蠏碁 - MongoDB - Amazon Dynamo - Couchbase - MarkLogic - Azure DocumentDB - Google Cloud Datastore 豢豌 : Database.guide
  • 14. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL 譬襯 Column-oriented DB (table-style) - data 蟯襴 : (RDB : 蟯襴) - 一危 轟 蟆 - 覈 轟 伎 手 螳煙 - 一危 郁鍵 螳 - 豢 牛 ろ襴讌 企 - record 豌伎 譟壱 襴 - 企れ Row-based Column-based
  • 15. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL 譬襯 - - - Data warehouse - Relational DB 豌 (OLAP ) - HBase - Cassandra - Accumulo - Hypertable - Azure table storage - Amazon Redshift - Oracle Exadata Column-oriented DB
  • 16. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL 譬襯 Graph Database - data + 蟯螻 - 一危 覲旧″ Query 螳 - depth 2 豐螻狩 蟆 觜蟲 觜襴 - ACID 螻 (覲危 NoSQL BASE 螻) - nodes, edges, properties 蟲
  • 17. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? NoSQL 譬襯 - - - Fraud Detection - Real-time 豢豌讌 - 蟯螻 蠍磯 Search - SNS 覿 - IAM - neo4j - OrientDB - Titan - ArangDB Graph DB
  • 18. Sarc Seminar January 2017 Data Series I by sarc.io NoSQL?? Reference - 4 predictions for NoSQL technologies in 2016 (http://www.information- age.com/evolution-knowledge-workers-123460640/) - Magic Quadrant for Operational Database Management Systems (https://www.gartner.com/document/3467318?ref=solrResearch&refval=17892 5527&qid=3a2cd31003f6a3917500e34591634ac1) - What is ~~ Database? (http://database.guide)