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
. 覦一危 一危 螻 豌襴
. /觜 一危 覲伎ヾ
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)