7/27/2018

Reading time:4 min

A Shortcut to Awesome: Cassandra Data Modeling By Example (Jon Haddad…

by DataStax

A Shortcut to Awesome: Cassandra Data Modeling By Example (Jon Haddad… SlideShare Explore You Successfully reported this slideshow.A Shortcut to Awesome: Cassandra Data Modeling By Example (Jon Haddad, The Last Pickle) | C* Summit 2016Upcoming SlideShareLoading in …5× 0 Comments 1 Like Statistics Notes Anand Rao , Sr. SOA Architect at Cengage Learning No DownloadsNo notes for slide 1. JON HADDADTHE LAST PICKLELEARN DATA MODELING BY EXAMPLETHIS ISAWESOME!!! 2. WHAT’S THE LASTPICKLE DO? 3. WE HELP MAKE YOU ATEAM OF EXPERTS 4. > 50 YEARS COMBINEDEXPERIENCE 5. WHO IS THIS GUY? 6. 15 YEARSEXPERIENCE 7. 4 YEARS WITH CASSANDRA 8. LEARNING HOW TOCASSANDRA 9. WHAT’S YOURBACKGROUND? 10. ORACLE!MYSQL!POSTGRES! 11. CQL LOOKSLIKE SQL 12. BADASSUMPTIONS 13. 3RDNORMALFORM? 14. WHERE’SMYJOINS? 15. SECONDARYINDEX? 16. DO IT WRONGTRY TO DATA MODELGET ANGRYWATCH VIDEOS & READ 17. EVERYTHING IKNOW IS WRONG 18. LEARN BYEXAMPLE 19. CASSANDRA DATASETMANAGER 20. CDM 21. APT FOR CASSANDRADATA 22. INSTALL DATA TO YOURCASSANDRA CLUSTER 23. cdm install <dataset> 24. jhaddad@rustyrazorblade ~$ cdm listStarting CDMDatasets:movielenskillrvideokillrweatherFinished. 25. jhaddad@rustyrazorblade ~$ cdm install movielensStarting CDMInstalling movielensChecking for repo at /Users/jhaddad/.cdm/movielensPulling latestCDM is using dataset path: /Users/jhaddad/.cdm/movielenscqlsh -e "DROP KEYSPACE IF EXISTS movielens; CREATE KEYSPACE movielensWITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1}"Schema: /Users/jhaddad/.cdm/movielens/schema.cqlLoading datacqlsh -k movielens -e "COPY movies FROM '/Users/jhaddad/.cdm/movielens/data/movies.csv'"cqlsh -k movielens -e "COPY users FROM '/Users/jhaddad/.cdm/movielens/data/users.csv'"cqlsh -k movielens -e "COPY ratings_by_user FROM '/Users/jhaddad/.cdm/movielensdata/ratings_by_user.csv'"cqlsh -k movielens -e "COPY original_movie_map FROM '/Users/jhaddad/.cdm/movielens/data/original_movie_map.csv'" 26. jhaddad@rustyrazorblade ~/dev/cassandra$ cqlshConnected to Test Cluster at 127.0.0.1:9042.[cqlsh 5.0.1 | Cassandra 3.10-SNAPSHOT | CQL spec 3.4.3 | Native protocol v4]Use HELP for help.cqlsh> use movielens ;cqlsh:movielens> desc tables;movies users ratings_by_user original_movie_map ratings_by_movie 27. WHAT CAN WE DO WITH IT?▸ Learn by example▸ Blog posts / Tutorials▸ Jupyter notebooks▸ Reference applications▸ Data Models for presentations 28. MANAGINGREFERENCE / TEST DATA 29. DATASETS 30. MOVIELENS 31. DETAILS▸GroupLens Research Project▸University of Minnesota▸100K ratings▸1K users▸1700 movies 32. cqlsh:movielens> select id, avg_rating, genres, name... from movies limit 1;@ Row 1------------+--------------------------------------id | 76a38f64-94d8-4b8f-b830-a40af96f8d20avg_rating | 3.16667genres | {'Drama'}name | Little Lord Fauntleroy (1936)(1 rows) 33. cqlsh:movielens> select * from users limit 1;@ Row 1------------+--------------------------------------id | b52fcdfc-0eaf-4432-9896-aa22db56edb2address | 0322 Mattie Ramp Apt. 177age | 37city | South Fremontgender | Mname | Harrold Hillsoccupation | administratorzip | 06513(1 rows) 34. BLOG: WORKINGRELATIONALLY WITHCASSANDRA 35. CONNECTINGCASSANDRADATA WITHGRAPHFRAMES 36. cdm install killrweather 37. Helena EdelsonPatrick McFadin 38. cdm install killrvideo 39. Luke TillmanPatrick McFadin 40. UPCOMINGDATA SETS 41. openﬂights.org‣ airports‣ ﬂight data 42. HEALTH CARE▸ Cancer Genome Atlas Project▸ Ebola cases▸ Healthcare ﬁnancial data▸ Dani Traphagen 43. NYC TAXI DATA▸ pick up / drop off times & locations▸ trip distances▸ itemized fares▸ rate types▸ payment types 44. SOCIAL DATA▸Higgs Twitter Data▸Foursquare▸Enron executive emails 45. HOW TOCONTRIBUTE 46. https://github.com/riptano/cdm-java 47. ADD FEATURES 48. SUGGEST DATASETS 49. CREATE A DATASET▸ create a git repo▸ datasets.yaml▸ schema.cql▸ insert data▸ “cdm dump”▸ cdm install .▸ create a PR on cdm-javaOMG BESTDATASET EVER 50. @RUSTYRAZORBLADETHANK YOU, KIND HUMANS Recommended Train the TrainerOnline Course - LinkedIn Learning PowerPoint: Using Photos and Video Effectively for Great PresentationsOnline Course - LinkedIn Learning PowerPoint 2016: Tips and TricksOnline Course - LinkedIn Learning Cassandra By Example: Data Modelling with CQL3Eric Evans How to Power Innovation with Geo-Distributed Data Management in Hybrid CloudDataStax How to Evaluate Cloud Databases for eCommerceDataStax Webinar: DataStax Enterprise 6: 10 Ways to Multiply the Power of Apache Cassa...DataStax Webinar: DataStax and Microsoft Azure: Empowering the Right-Now Enterprise wi...DataStax Webinar - Real-Time Customer Experience for the Right-Now Enterprise featurin...DataStax Datastax - The Architect's guide to customer experience (CX)DataStax About Blog Terms Privacy Copyright LinkedIn Corporation © 2018 Public clipboards featuring this slideNo public clipboards found for this slideSelect another clipboard ×Looks like you’ve clipped this slide to already.Create a clipboardYou just clipped your first slide! Clipping is a handy way to collect important slides you want to go back to later. Now customize the name of a clipboard to store your clips. Description Visibility Others can see my Clipboard

Read this article if you want to know more about A Shortcut to Awesome: Cassandra Data Modeling By Example (Jon Haddad…

A Shortcut to Awesome: Cassandra Data Modeling By Example (Jon Haddad…

SlideShare Explore You

Successfully reported this slideshow.

A Shortcut to Awesome: Cassandra Data Modeling By Example (Jon Haddad, The Last Pickle) | C* Summit 2016

JON HADDAD
THE LAST PICKLE
LEARN DATA MODELING BY EXAMPLE
THIS IS
AWESOME!!!

Upcoming SlideShare

Loading in …5

×

0 Comments

Anand Rao , Sr. SOA Architect at Cengage Learning

1. JON HADDAD THE LAST PICKLE LEARN DATA MODELING BY EXAMPLE THIS IS AWESOME!!!
2. WHAT’S THE LAST PICKLE DO?
3. WE HELP MAKE YOU A TEAM OF EXPERTS
4. > 50 YEARS COMBINED EXPERIENCE
5. WHO IS THIS GUY?
6. 15 YEARS EXPERIENCE
7. 4 YEARS WITH CASSANDRA
8. LEARNING HOW TO CASSANDRA
9. WHAT’S YOUR BACKGROUND?
10. ORACLE! MYSQL! POSTGRES!
11. CQL LOOKS LIKE SQL
12. BAD ASSUMPTIONS
13. 3RD NORMAL FORM?
14. WHERE’S MY JOINS?
15. SECONDARY INDEX?
16. DO IT WRONG TRY TO DATA MODELGET ANGRY WATCH VIDEOS & READ
17. EVERYTHING I KNOW IS WRONG
18. LEARN BY EXAMPLE
19. CASSANDRA DATASET MANAGER
20. CDM
21. APT FOR CASSANDRA DATA
22. INSTALL DATA TO YOUR CASSANDRA CLUSTER
23. cdm install <dataset>
24. jhaddad@rustyrazorblade ~$ cdm list Starting CDM Datasets: movielens killrvideo killrweather Finished.
25. jhaddad@rustyrazorblade ~$ cdm install movielens Starting CDM Installing movielens Checking for repo at /Users/jhaddad/.cdm/movielens Pulling latest CDM is using dataset path: /Users/jhaddad/.cdm/movielens cqlsh -e "DROP KEYSPACE IF EXISTS movielens; CREATE KEYSPACE movielens WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1}" Schema: /Users/jhaddad/.cdm/movielens/schema.cql Loading data cqlsh -k movielens -e "COPY movies FROM '/Users/jhaddad/.cdm/movielens/data/ movies.csv'" cqlsh -k movielens -e "COPY users FROM '/Users/jhaddad/.cdm/movielens/data/ users.csv'" cqlsh -k movielens -e "COPY ratings_by_user FROM '/Users/jhaddad/.cdm/movielens data/ratings_by_user.csv'" cqlsh -k movielens -e "COPY original_movie_map FROM '/Users/jhaddad/.cdm/ movielens/data/original_movie_map.csv'"
26. jhaddad@rustyrazorblade ~/dev/cassandra$ cqlsh Connected to Test Cluster at 127.0.0.1:9042. [cqlsh 5.0.1 | Cassandra 3.10-SNAPSHOT | CQL spec 3.4.3 | Native protocol v4] Use HELP for help. cqlsh> use movielens ; cqlsh:movielens> desc tables; movies users ratings_by_user original_movie_map ratings_by_movie
27. WHAT CAN WE DO WITH IT? ▸ Learn by example ▸ Blog posts / Tutorials ▸ Jupyter notebooks ▸ Reference applications ▸ Data Models for presentations
28. MANAGING REFERENCE / TEST DATA
29. DATASETS
30. MOVIELENS
31. DETAILS ▸GroupLens Research Project ▸University of Minnesota ▸100K ratings ▸1K users ▸1700 movies
32. cqlsh:movielens> select id, avg_rating, genres, name ... from movies limit 1; @ Row 1 ------------+-------------------------------------- id | 76a38f64-94d8-4b8f-b830-a40af96f8d20 avg_rating | 3.16667 genres | {'Drama'} name | Little Lord Fauntleroy (1936) (1 rows)
33. cqlsh:movielens> select * from users limit 1; @ Row 1 ------------+-------------------------------------- id | b52fcdfc-0eaf-4432-9896-aa22db56edb2 address | 0322 Mattie Ramp Apt. 177 age | 37 city | South Fremont gender | M name | Harrold Hills occupation | administrator zip | 06513 (1 rows)
34. BLOG: WORKING RELATIONALLY WITH CASSANDRA
35. CONNECTING CASSANDRA DATA WITH GRAPHFRAMES
36. cdm install killrweather
37. Helena Edelson Patrick McFadin
38. cdm install killrvideo
39. Luke Tillman Patrick McFadin
40. UPCOMING DATA SETS
41. openﬂights.org ‣ airports ‣ ﬂight data
42. HEALTH CARE ▸ Cancer Genome Atlas Project ▸ Ebola cases ▸ Healthcare ﬁnancial data ▸ Dani Traphagen
43. NYC TAXI DATA ▸ pick up / drop off times & locations ▸ trip distances ▸ itemized fares ▸ rate types ▸ payment types
44. SOCIAL DATA ▸Higgs Twitter Data ▸Foursquare ▸Enron executive emails
45. HOW TO CONTRIBUTE
46. https://github.com/riptano/cdm-java
47. ADD FEATURES
48. SUGGEST DATASETS
49. CREATE A DATASET ▸ create a git repo ▸ datasets.yaml ▸ schema.cql ▸ insert data ▸ “cdm dump” ▸ cdm install . ▸ create a PR on cdm-java OMG BEST DATASET EVER
50. @RUSTYRAZORBLADE THANK YOU, KIND HUMANS

Visibility Others can see my Clipboard

Checkout Planet Cassandra

Claim Your Free Planet Cassandra Contributor T-shirt!

Make your contribution and score a FREE Planet Cassandra Contributor T-Shirt!  We value our incredible Cassandra community, and we want to express our gratitude by sending an exclusive Planet Cassandra Contributor T-Shirt you can wear with pride.

Join Our Newsletter!

Sign up below to receive email updates and see what's going on with our company