ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo
NoSQL Or:  How I Learned to Stopped Worrying and Love Cassandra
What is NoSql?
NoSQL != No SQL N ot  O nly  SQL Mostly Same Functionality Same Purpose  No Longer Relational
ACID vs WHAM ACID A tomicity C onsistency I solation D urability Issues Dated Not Necessary
ACID vs WHAM WHAM W eb-scale H igh Traffic A daptive Schema M ulti-Use Benefits Better Suited for the current Data Ecosystem
No Family Drama Removes Existing Slowdowns Relations Consistency Between Related Data Joins More Easily Distributed Faster Queries
Implementations
Cassandra - History 2007  - Initial Developed by Facebook Manage User Inbox Searching 2008  - Released as Open Source 2008 2009  - Picked up by Apache Present  - Cassandra 1.0
Big Table + Dynamo Basic Design Principle Big Table Column Families Adaptable Similarities with SQL Dynamo Decentralized Distributive Nature Easily Scalable Durable
Cassandra Pyramid
Example
Building the Pyramid Columns 3 Values Name Value Time Stamp Primitive Types Similar Role to Columns in RDBMs
Example Column 1 Name: City Value: Houston Column 1 Name: Attire Value: Casual
Building the Pyramid Super Columns 2 Values Name Collection of Columns Columns can be sorted by name.
Example Super Column 1 Name: Hours Value: Column 1 Name: Mon-Thu Value: 10 am ¨C 10 pm Value: Column 2 Name: Fri-Sat Value: 10 am ¨C 11 pm Value: Column 3 Name: Sun Value: 10 am ¨C 9 pm
Building the Pyramid Rows A Collection of Columns Identified by A Unique Key Columns not necessarily related Similar Role to Rows in RDBMs
Example Row 1 Key: nikonikogreekcafe Column 1: City Column 2: Attire
Building the Pyramid Column Family A Collection of Rows Either Columns or Super Columns Query on Only One Column Family Similar Role to Tables in RDBMs
Example Value: Column 1 Name: Hours.Mon-Thu Value: 10 am ¨C 10 pm Value: Column 2 Name: Hours.Fri-Sat Value: 10 am ¨C 11 pm Value: Column 3 Name: Hours.Sun Value: 10 am ¨C 9 pm
Example Column Family: Name: Location Row 1: Niko Niko's Row 2: Goode Co. Row 3: Datafiniti
Building the Pyramid Keyspace A Collection of Column Families Global Settings Sorting Replication Factor Similar Role to Databases in RDBMs
Advantages Horizontally Scalable Decentralized Approach Eventually Consistent Auto-bootstrapping Distributed Computing Distributed Storage
Advantages Real Time Responses Read and Writes Removes Slower Functions Joins/Relations Consistency Does not need to Sort Able to return the first matches.
Advantages Developed for programmers Good API Support In most major languages Object-based Interaction model Few Function Calls Greater Control
Advantages No Single Point of Failure Redundancy across multiple nodes Decentralized Hinted Hand Offs Other Nodes will handle writes Update failed nodes when back online.
Disadvantages No Relational Model No Internal Joins Less Consistency Faster Queries
Disadvantages No Sorting at Query Time Less Flexibility on Data Returned No Ranking Able to Return First Results it Finds
Disadvantages No SQL Uses Proprietary Query Language (CQL) Less Familiar
Potential Uses Key Elements Large Amounts of Data Data Parameters Shift or Grow Frequently Real Time Responses Data is Not Reliant on Relations
Potential Uses Inbox Management Key/Value Store Social Network Management Data Warehouse
Potential Uses Major Users
Questions?

More Related Content

Similar to Phil Coleman Presentation (20)

No sql
No sqlNo sql
No sql
Shruti_gtbit
?
Front Range PHP NoSQL Databases
Front Range PHP NoSQL DatabasesFront Range PHP NoSQL Databases
Front Range PHP NoSQL Databases
Jon Meredith
?
NO SQL Databases, Big Data and the cloud
NO SQL Databases, Big Data and the cloudNO SQL Databases, Big Data and the cloud
NO SQL Databases, Big Data and the cloud
Manu Cohen-Yashar
?
No sq lv2
No sq lv2No sq lv2
No sq lv2
Nusrat Sharmin
?
NoSql Database
NoSql DatabaseNoSql Database
NoSql Database
Suresh Parmar
?
No SQL Databases as modern database concepts
No SQL Databases as modern database conceptsNo SQL Databases as modern database concepts
No SQL Databases as modern database concepts
debasisdas225831
?
Schemaless Databases
Schemaless DatabasesSchemaless Databases
Schemaless Databases
Dan Gunter
?
No sql
No sqlNo sql
No sql
Murat ?akal
?
Introduction to NoSQL
Introduction to NoSQLIntroduction to NoSQL
Introduction to NoSQL
Ahmed Helmy
?
ch02models.pptx
ch02models.pptxch02models.pptx
ch02models.pptx
dreamboy6060
?
ch02models.pptx
ch02models.pptxch02models.pptx
ch02models.pptx
dreamboy6060
?
ASP.NET 3.5 SP1
ASP.NET 3.5 SP1ASP.NET 3.5 SP1
ASP.NET 3.5 SP1
Dave Allen
?
05 No SQL Sudarshan.ppt
05 No SQL Sudarshan.ppt05 No SQL Sudarshan.ppt
05 No SQL Sudarshan.ppt
AnandKonj1
?
No SQL Databases.ppt
No SQL Databases.pptNo SQL Databases.ppt
No SQL Databases.ppt
ssuser8c8fc1
?
No SQL Databases sdfghjkl;sdfghjkl;sdfghjkl;'
No SQL Databases sdfghjkl;sdfghjkl;sdfghjkl;'No SQL Databases sdfghjkl;sdfghjkl;sdfghjkl;'
No SQL Databases sdfghjkl;sdfghjkl;sdfghjkl;'
sankarapu posibabu
?
Implementing the Database Server session 01
Implementing the Database Server  session 01Implementing the Database Server  session 01
Implementing the Database Server session 01
Guillermo Julca
?
To SQL or NoSQL, that is the question
To SQL or NoSQL, that is the questionTo SQL or NoSQL, that is the question
To SQL or NoSQL, that is the question
Krishnakumar S
?
Learning Cassandra NoSQL
Learning Cassandra NoSQLLearning Cassandra NoSQL
Learning Cassandra NoSQL
Pankaj Khattar
?
Presentation
PresentationPresentation
Presentation
Xiaoyu Chen
?
Architectural anti-patterns for data handling
Architectural anti-patterns for data handlingArchitectural anti-patterns for data handling
Architectural anti-patterns for data handling
Gleicon Moraes
?
Front Range PHP NoSQL Databases
Front Range PHP NoSQL DatabasesFront Range PHP NoSQL Databases
Front Range PHP NoSQL Databases
Jon Meredith
?
NO SQL Databases, Big Data and the cloud
NO SQL Databases, Big Data and the cloudNO SQL Databases, Big Data and the cloud
NO SQL Databases, Big Data and the cloud
Manu Cohen-Yashar
?
No SQL Databases as modern database concepts
No SQL Databases as modern database conceptsNo SQL Databases as modern database concepts
No SQL Databases as modern database concepts
debasisdas225831
?
Schemaless Databases
Schemaless DatabasesSchemaless Databases
Schemaless Databases
Dan Gunter
?
Introduction to NoSQL
Introduction to NoSQLIntroduction to NoSQL
Introduction to NoSQL
Ahmed Helmy
?
05 No SQL Sudarshan.ppt
05 No SQL Sudarshan.ppt05 No SQL Sudarshan.ppt
05 No SQL Sudarshan.ppt
AnandKonj1
?
No SQL Databases sdfghjkl;sdfghjkl;sdfghjkl;'
No SQL Databases sdfghjkl;sdfghjkl;sdfghjkl;'No SQL Databases sdfghjkl;sdfghjkl;sdfghjkl;'
No SQL Databases sdfghjkl;sdfghjkl;sdfghjkl;'
sankarapu posibabu
?
Implementing the Database Server session 01
Implementing the Database Server  session 01Implementing the Database Server  session 01
Implementing the Database Server session 01
Guillermo Julca
?
To SQL or NoSQL, that is the question
To SQL or NoSQL, that is the questionTo SQL or NoSQL, that is the question
To SQL or NoSQL, that is the question
Krishnakumar S
?
Architectural anti-patterns for data handling
Architectural anti-patterns for data handlingArchitectural anti-patterns for data handling
Architectural anti-patterns for data handling
Gleicon Moraes
?

Recently uploaded (20)

How Air Coil Inductors Work By Cet Technology
How Air Coil Inductors Work By Cet TechnologyHow Air Coil Inductors Work By Cet Technology
How Air Coil Inductors Work By Cet Technology
CET Technology
?
UiPath NY AI Series: Session 4: UiPath AutoPilot for Developers using Studio Web
UiPath NY AI Series: Session 4: UiPath AutoPilot for Developers using Studio WebUiPath NY AI Series: Session 4: UiPath AutoPilot for Developers using Studio Web
UiPath NY AI Series: Session 4: UiPath AutoPilot for Developers using Studio Web
DianaGray10
?
How Telemedicine App Development is Revolutionizing Virtual Care.pptx
How Telemedicine App Development is Revolutionizing Virtual Care.pptxHow Telemedicine App Development is Revolutionizing Virtual Care.pptx
How Telemedicine App Development is Revolutionizing Virtual Care.pptx
Dash Technologies Inc
?
ScotSecure Cyber Security Summit 2025 Edinburgh
ScotSecure Cyber Security Summit 2025 EdinburghScotSecure Cyber Security Summit 2025 Edinburgh
ScotSecure Cyber Security Summit 2025 Edinburgh
Ray Bugg
?
SAP Automation with UiPath: Solution Accelerators and Best Practices - Part 6...
SAP Automation with UiPath: Solution Accelerators and Best Practices - Part 6...SAP Automation with UiPath: Solution Accelerators and Best Practices - Part 6...
SAP Automation with UiPath: Solution Accelerators and Best Practices - Part 6...
DianaGray10
?
Build with AI on Google Cloud Session #5
Build with AI on Google Cloud Session #5Build with AI on Google Cloud Session #5
Build with AI on Google Cloud Session #5
Margaret Maynard-Reid
?
Columbia Weather Systems - Product Overview
Columbia Weather Systems - Product OverviewColumbia Weather Systems - Product Overview
Columbia Weather Systems - Product Overview
Columbia Weather Systems
?
Automating Behavior-Driven Development: Boosting Productivity with Template-D...
Automating Behavior-Driven Development: Boosting Productivity with Template-D...Automating Behavior-Driven Development: Boosting Productivity with Template-D...
Automating Behavior-Driven Development: Boosting Productivity with Template-D...
DOCOMO Innovations, Inc.
?
Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]
Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]
Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]
jackalen173
?
Rene-Peinado-A-Maritime-Professionals-Journey---.pptx
Rene-Peinado-A-Maritime-Professionals-Journey---.pptxRene-Peinado-A-Maritime-Professionals-Journey---.pptx
Rene-Peinado-A-Maritime-Professionals-Journey---.pptx
Rene Peinado
?
A General introduction to Ad ranking algorithms
A General introduction to Ad ranking algorithmsA General introduction to Ad ranking algorithms
A General introduction to Ad ranking algorithms
Buhwan Jeong
?
Scalable Multi-Agent AI with AutoGen by Udai
Scalable Multi-Agent AI with AutoGen by UdaiScalable Multi-Agent AI with AutoGen by Udai
Scalable Multi-Agent AI with AutoGen by Udai
Udaiappa Ramachandran
?
The Future of Materials: Transitioning from Silicon to Alternative Metals
The Future of Materials: Transitioning from Silicon to Alternative MetalsThe Future of Materials: Transitioning from Silicon to Alternative Metals
The Future of Materials: Transitioning from Silicon to Alternative Metals
anupriti
?
202408_JAWSPANKRATION_Introduction_of_Minaden.pdf
202408_JAWSPANKRATION_Introduction_of_Minaden.pdf202408_JAWSPANKRATION_Introduction_of_Minaden.pdf
202408_JAWSPANKRATION_Introduction_of_Minaden.pdf
NTTDOCOMO-ServiceInnovation
?
Smarter RAG Pipelines: Scaling Search with Milvus and Feast
Smarter RAG Pipelines: Scaling Search with Milvus and FeastSmarter RAG Pipelines: Scaling Search with Milvus and Feast
Smarter RAG Pipelines: Scaling Search with Milvus and Feast
Zilliz
?
Java on AWS Without the Headaches - Fast Builds, Cheap Deploys, No Kubernetes
Java on AWS Without the Headaches - Fast Builds, Cheap Deploys, No KubernetesJava on AWS Without the Headaches - Fast Builds, Cheap Deploys, No Kubernetes
Java on AWS Without the Headaches - Fast Builds, Cheap Deploys, No Kubernetes
VictorSzoltysek
?
RBM - PIXIAGE - AskPixi Page - Inpixon-MWC 2025.pptx
RBM - PIXIAGE - AskPixi Page - Inpixon-MWC 2025.pptxRBM - PIXIAGE - AskPixi Page - Inpixon-MWC 2025.pptx
RBM - PIXIAGE - AskPixi Page - Inpixon-MWC 2025.pptx
quinlan4
?
Getting the Best of TrueDEM ¨C April News & Updates
Getting the Best of TrueDEM ¨C April News & UpdatesGetting the Best of TrueDEM ¨C April News & Updates
Getting the Best of TrueDEM ¨C April News & Updates
panagenda
?
APAC Solutions Challenge Info Session.pdf
APAC Solutions Challenge Info Session.pdfAPAC Solutions Challenge Info Session.pdf
APAC Solutions Challenge Info Session.pdf
GDG on Campus Monash
?
CIOs Speak Out - A Research Series by Jasper Colin
CIOs Speak Out - A Research Series by Jasper ColinCIOs Speak Out - A Research Series by Jasper Colin
CIOs Speak Out - A Research Series by Jasper Colin
Jasper Colin
?
How Air Coil Inductors Work By Cet Technology
How Air Coil Inductors Work By Cet TechnologyHow Air Coil Inductors Work By Cet Technology
How Air Coil Inductors Work By Cet Technology
CET Technology
?
UiPath NY AI Series: Session 4: UiPath AutoPilot for Developers using Studio Web
UiPath NY AI Series: Session 4: UiPath AutoPilot for Developers using Studio WebUiPath NY AI Series: Session 4: UiPath AutoPilot for Developers using Studio Web
UiPath NY AI Series: Session 4: UiPath AutoPilot for Developers using Studio Web
DianaGray10
?
How Telemedicine App Development is Revolutionizing Virtual Care.pptx
How Telemedicine App Development is Revolutionizing Virtual Care.pptxHow Telemedicine App Development is Revolutionizing Virtual Care.pptx
How Telemedicine App Development is Revolutionizing Virtual Care.pptx
Dash Technologies Inc
?
ScotSecure Cyber Security Summit 2025 Edinburgh
ScotSecure Cyber Security Summit 2025 EdinburghScotSecure Cyber Security Summit 2025 Edinburgh
ScotSecure Cyber Security Summit 2025 Edinburgh
Ray Bugg
?
SAP Automation with UiPath: Solution Accelerators and Best Practices - Part 6...
SAP Automation with UiPath: Solution Accelerators and Best Practices - Part 6...SAP Automation with UiPath: Solution Accelerators and Best Practices - Part 6...
SAP Automation with UiPath: Solution Accelerators and Best Practices - Part 6...
DianaGray10
?
Build with AI on Google Cloud Session #5
Build with AI on Google Cloud Session #5Build with AI on Google Cloud Session #5
Build with AI on Google Cloud Session #5
Margaret Maynard-Reid
?
Automating Behavior-Driven Development: Boosting Productivity with Template-D...
Automating Behavior-Driven Development: Boosting Productivity with Template-D...Automating Behavior-Driven Development: Boosting Productivity with Template-D...
Automating Behavior-Driven Development: Boosting Productivity with Template-D...
DOCOMO Innovations, Inc.
?
Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]
Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]
Fast Screen Recorder v2.1.0.11 Crack Updated [April-2025]
jackalen173
?
Rene-Peinado-A-Maritime-Professionals-Journey---.pptx
Rene-Peinado-A-Maritime-Professionals-Journey---.pptxRene-Peinado-A-Maritime-Professionals-Journey---.pptx
Rene-Peinado-A-Maritime-Professionals-Journey---.pptx
Rene Peinado
?
A General introduction to Ad ranking algorithms
A General introduction to Ad ranking algorithmsA General introduction to Ad ranking algorithms
A General introduction to Ad ranking algorithms
Buhwan Jeong
?
Scalable Multi-Agent AI with AutoGen by Udai
Scalable Multi-Agent AI with AutoGen by UdaiScalable Multi-Agent AI with AutoGen by Udai
Scalable Multi-Agent AI with AutoGen by Udai
Udaiappa Ramachandran
?
The Future of Materials: Transitioning from Silicon to Alternative Metals
The Future of Materials: Transitioning from Silicon to Alternative MetalsThe Future of Materials: Transitioning from Silicon to Alternative Metals
The Future of Materials: Transitioning from Silicon to Alternative Metals
anupriti
?
Smarter RAG Pipelines: Scaling Search with Milvus and Feast
Smarter RAG Pipelines: Scaling Search with Milvus and FeastSmarter RAG Pipelines: Scaling Search with Milvus and Feast
Smarter RAG Pipelines: Scaling Search with Milvus and Feast
Zilliz
?
Java on AWS Without the Headaches - Fast Builds, Cheap Deploys, No Kubernetes
Java on AWS Without the Headaches - Fast Builds, Cheap Deploys, No KubernetesJava on AWS Without the Headaches - Fast Builds, Cheap Deploys, No Kubernetes
Java on AWS Without the Headaches - Fast Builds, Cheap Deploys, No Kubernetes
VictorSzoltysek
?
RBM - PIXIAGE - AskPixi Page - Inpixon-MWC 2025.pptx
RBM - PIXIAGE - AskPixi Page - Inpixon-MWC 2025.pptxRBM - PIXIAGE - AskPixi Page - Inpixon-MWC 2025.pptx
RBM - PIXIAGE - AskPixi Page - Inpixon-MWC 2025.pptx
quinlan4
?
Getting the Best of TrueDEM ¨C April News & Updates
Getting the Best of TrueDEM ¨C April News & UpdatesGetting the Best of TrueDEM ¨C April News & Updates
Getting the Best of TrueDEM ¨C April News & Updates
panagenda
?
APAC Solutions Challenge Info Session.pdf
APAC Solutions Challenge Info Session.pdfAPAC Solutions Challenge Info Session.pdf
APAC Solutions Challenge Info Session.pdf
GDG on Campus Monash
?
CIOs Speak Out - A Research Series by Jasper Colin
CIOs Speak Out - A Research Series by Jasper ColinCIOs Speak Out - A Research Series by Jasper Colin
CIOs Speak Out - A Research Series by Jasper Colin
Jasper Colin
?

Phil Coleman Presentation

  • 1. NoSQL Or: How I Learned to Stopped Worrying and Love Cassandra
  • 3. NoSQL != No SQL N ot O nly SQL Mostly Same Functionality Same Purpose No Longer Relational
  • 4. ACID vs WHAM ACID A tomicity C onsistency I solation D urability Issues Dated Not Necessary
  • 5. ACID vs WHAM WHAM W eb-scale H igh Traffic A daptive Schema M ulti-Use Benefits Better Suited for the current Data Ecosystem
  • 6. No Family Drama Removes Existing Slowdowns Relations Consistency Between Related Data Joins More Easily Distributed Faster Queries
  • 8. Cassandra - History 2007 - Initial Developed by Facebook Manage User Inbox Searching 2008 - Released as Open Source 2008 2009 - Picked up by Apache Present - Cassandra 1.0
  • 9. Big Table + Dynamo Basic Design Principle Big Table Column Families Adaptable Similarities with SQL Dynamo Decentralized Distributive Nature Easily Scalable Durable
  • 12. Building the Pyramid Columns 3 Values Name Value Time Stamp Primitive Types Similar Role to Columns in RDBMs
  • 13. Example Column 1 Name: City Value: Houston Column 1 Name: Attire Value: Casual
  • 14. Building the Pyramid Super Columns 2 Values Name Collection of Columns Columns can be sorted by name.
  • 15. Example Super Column 1 Name: Hours Value: Column 1 Name: Mon-Thu Value: 10 am ¨C 10 pm Value: Column 2 Name: Fri-Sat Value: 10 am ¨C 11 pm Value: Column 3 Name: Sun Value: 10 am ¨C 9 pm
  • 16. Building the Pyramid Rows A Collection of Columns Identified by A Unique Key Columns not necessarily related Similar Role to Rows in RDBMs
  • 17. Example Row 1 Key: nikonikogreekcafe Column 1: City Column 2: Attire
  • 18. Building the Pyramid Column Family A Collection of Rows Either Columns or Super Columns Query on Only One Column Family Similar Role to Tables in RDBMs
  • 19. Example Value: Column 1 Name: Hours.Mon-Thu Value: 10 am ¨C 10 pm Value: Column 2 Name: Hours.Fri-Sat Value: 10 am ¨C 11 pm Value: Column 3 Name: Hours.Sun Value: 10 am ¨C 9 pm
  • 20. Example Column Family: Name: Location Row 1: Niko Niko's Row 2: Goode Co. Row 3: Datafiniti
  • 21. Building the Pyramid Keyspace A Collection of Column Families Global Settings Sorting Replication Factor Similar Role to Databases in RDBMs
  • 22. Advantages Horizontally Scalable Decentralized Approach Eventually Consistent Auto-bootstrapping Distributed Computing Distributed Storage
  • 23. Advantages Real Time Responses Read and Writes Removes Slower Functions Joins/Relations Consistency Does not need to Sort Able to return the first matches.
  • 24. Advantages Developed for programmers Good API Support In most major languages Object-based Interaction model Few Function Calls Greater Control
  • 25. Advantages No Single Point of Failure Redundancy across multiple nodes Decentralized Hinted Hand Offs Other Nodes will handle writes Update failed nodes when back online.
  • 26. Disadvantages No Relational Model No Internal Joins Less Consistency Faster Queries
  • 27. Disadvantages No Sorting at Query Time Less Flexibility on Data Returned No Ranking Able to Return First Results it Finds
  • 28. Disadvantages No SQL Uses Proprietary Query Language (CQL) Less Familiar
  • 29. Potential Uses Key Elements Large Amounts of Data Data Parameters Shift or Grow Frequently Real Time Responses Data is Not Reliant on Relations
  • 30. Potential Uses Inbox Management Key/Value Store Social Network Management Data Warehouse