Tweet
Tweet

Slide 1

Slide 1 text

MICRO-BLOGGING FOR THE ENTERPRISE Sunday, September 16, 12

Slide 2

Slide 2 text

Who Am I Sunday, September 16, 12

Slide 3

Slide 3 text

Amit Kumar Who Am I Sunday, September 16, 12

Slide 4

Slide 4 text

Amit Kumar Consultant and Rubyist Who Am I Sunday, September 16, 12

Slide 5

Slide 5 text

Amit Kumar Consultant and Rubyist TATA Consultancy Services Limited Who Am I Sunday, September 16, 12

Slide 6

Slide 6 text

Amit Kumar Consultant and Rubyist TATA Consultancy Services Limited twitter.com/toamit Who Am I Sunday, September 16, 12

Slide 7

Slide 7 text

Amit Kumar Consultant and Rubyist TATA Consultancy Services Limited twitter.com/toamit github.com/toamitkumar Who Am I Sunday, September 16, 12

Slide 8

Slide 8 text

AGENDA Sunday, September 16, 12

Slide 9

Slide 9 text

AGENDA Micro-Blogging for “The Enterprise” Sunday, September 16, 12

Slide 10

Slide 10 text

AGENDA Micro-Blogging for “The Enterprise” Relational DB Structure Sunday, September 16, 12

Slide 11

Slide 11 text

AGENDA Micro-Blogging for “The Enterprise” Relational DB Structure Performance issues Sunday, September 16, 12

Slide 12

Slide 12 text

AGENDA Micro-Blogging for “The Enterprise” Relational DB Structure Performance issues Caching? Sunday, September 16, 12

Slide 13

Slide 13 text

AGENDA Micro-Blogging for “The Enterprise” Relational DB Structure Performance issues Caching? MongoDB Sunday, September 16, 12

Slide 14

Slide 14 text

AGENDA Micro-Blogging for “The Enterprise” Relational DB Structure Performance issues Caching? MongoDB Hybrid Approach Sunday, September 16, 12

Slide 15

Slide 15 text

What Micro-Blogging Mean To Enterprise Sunday, September 16, 12

Slide 16

Slide 16 text

Sunday, September 16, 12

Slide 17

Slide 17 text

Sunday, September 16, 12

Slide 18

Slide 18 text

Sunday, September 16, 12

Slide 19

Slide 19 text

Sunday, September 16, 12

Slide 20

Slide 20 text

Enterprise Demands Sunday, September 16, 12

Slide 21

Slide 21 text

Message threads (Facebook like experience) Enterprise Demands Sunday, September 16, 12

Slide 22

Slide 22 text

Message threads (Facebook like experience) Activities of follower list Enterprise Demands Sunday, September 16, 12

Slide 23

Slide 23 text

Message threads (Facebook like experience) Activities of follower list Two timelines Enterprise Demands Sunday, September 16, 12

Slide 24

Slide 24 text

Message threads (Facebook like experience) Activities of follower list Two timelines Individual Enterprise Demands Sunday, September 16, 12

Slide 25

Slide 25 text

Message threads (Facebook like experience) Activities of follower list Two timelines Individual Public Enterprise Demands Sunday, September 16, 12

Slide 26

Slide 26 text

Message threads (Facebook like experience) Activities of follower list Two timelines Individual Public Filtering messages (role/office etc) Enterprise Demands Sunday, September 16, 12

Slide 27

Slide 27 text

Timeline Sunday, September 16, 12

Slide 28

Slide 28 text

Timeline Sunday, September 16, 12

Slide 29

Slide 29 text

Timeline Sunday, September 16, 12

Slide 30

Slide 30 text

Timeline Sunday, September 16, 12

Slide 31

Slide 31 text

Timeline Sunday, September 16, 12

Slide 32

Slide 32 text

Timeline Sunday, September 16, 12

Slide 33

Slide 33 text

Relational DB Structure Sunday, September 16, 12

Slide 34

Slide 34 text

Traditional Relational Design Sunday, September 16, 12

Slide 35

Slide 35 text

Traditional Relational Design Sunday, September 16, 12

Slide 36

Slide 36 text

Traditional Relational Design Sunday, September 16, 12

Slide 37

Slide 37 text

Enterprise Demands - II Sunday, September 16, 12

Slide 38

Slide 38 text

Enterprise Demands - II Most popular posts Sunday, September 16, 12

Slide 39

Slide 39 text

Enterprise Demands - II Most popular posts Hash-tags (#hashtag) Sunday, September 16, 12

Slide 40

Slide 40 text

Enterprise Demands - II Sunday, September 16, 12

Slide 41

Slide 41 text

Enterprise Demands - II Ability to follow hash-tags Sunday, September 16, 12

Slide 42

Slide 42 text

Enterprise Demands - II Ability to follow hash-tags Sunday, September 16, 12

Slide 43

Slide 43 text

Enterprise Demands - II Sunday, September 16, 12

Slide 44

Slide 44 text

Enterprise Demands - II Activity on hash-tag flow to timeline Sunday, September 16, 12

Slide 45

Slide 45 text

Enterprise Demands - II Activity on hash-tag flow to timeline Sunday, September 16, 12

Slide 46

Slide 46 text

Enterprise Demands - II Activity on hash-tag flow to timeline Sunday, September 16, 12

Slide 47

Slide 47 text

Enterprise Demands - II Activity on hash-tag flow to timeline Sunday, September 16, 12

Slide 48

Slide 48 text

Enterprise Demands - II Sunday, September 16, 12

Slide 49

Slide 49 text

Hash-tag on comment will tag the whole thread Enterprise Demands - II Sunday, September 16, 12

Slide 50

Slide 50 text

Hash-tag on comment will tag the whole thread Enterprise Demands - II Sunday, September 16, 12

Slide 51

Slide 51 text

Traditional Relational Design Sunday, September 16, 12

Slide 52

Slide 52 text

Traditional Relational Design Sunday, September 16, 12

Slide 53

Slide 53 text

Traditional Relational Design Sunday, September 16, 12

Slide 54

Slide 54 text

Traditional Relational Design Sunday, September 16, 12

Slide 55

Slide 55 text

COMPLEX AND UNMAINTAINABLE CODE Sunday, September 16, 12

Slide 56

Slide 56 text

COMPLEX AND UNMAINTAINABLE CODE Sunday, September 16, 12

Slide 57

Slide 57 text

COMPLEX AND UNMAINTAINABLE CODE Sunday, September 16, 12

Slide 58

Slide 58 text

COMPLEX AND UNMAINTAINABLE CODE Sunday, September 16, 12

Slide 59

Slide 59 text

COMPLEX AND UNMAINTAINABLE CODE Sunday, September 16, 12

Slide 60

Slide 60 text

PERFORMANCE DEGRADES WITH INCREASING DATA VOLUME Sunday, September 16, 12

Slide 61

Slide 61 text

Performance Benchmark Sunday, September 16, 12

Slide 62

Slide 62 text

Performance Benchmark SQL query benchmarks Sunday, September 16, 12

Slide 63

Slide 63 text

Performance Benchmark SQL query benchmarks 10,000,000 messages Sunday, September 16, 12

Slide 64

Slide 64 text

Performance Benchmark SQL query benchmarks 10,000,000 messages 200,000,000 comments Sunday, September 16, 12

Slide 65

Slide 65 text

Performance Benchmark SQL query benchmarks 10,000,000 messages 200,000,000 comments 50,000,000 message likes 2 4 8 10 12 0 750 1500 2250 3000 Response ms in millions Sunday, September 16, 12

Slide 66

Slide 66 text

Caching? (Redis) Sunday, September 16, 12

Slide 67

Slide 67 text

Caching Solution Like Sunday, September 16, 12

Slide 68

Slide 68 text

Caching Solution Like Break point in Architecture Sunday, September 16, 12

Slide 69

Slide 69 text

Caching Solution Like Break point in Architecture No Query Interface Sunday, September 16, 12

Slide 70

Slide 70 text

Caching Solution Like Break point in Architecture No Query Interface No clustering support Sunday, September 16, 12

Slide 71

Slide 71 text

Caching Solution Like Break point in Architecture No Query Interface No clustering support More messy code Sunday, September 16, 12

Slide 72

Slide 72 text

A Document Based DB? Sunday, September 16, 12

Slide 73

Slide 73 text

A Document Based DB? Activity threads are like nested “DOCUMENTS” Sunday, September 16, 12

Slide 74

Slide 74 text

Sunday, September 16, 12

Slide 75

Slide 75 text

Sunday, September 16, 12

Slide 76

Slide 76 text

Sunday, September 16, 12

Slide 77

Slide 77 text

One Document Sunday, September 16, 12

Slide 78

Slide 78 text

A Document Based DB? Sunday, September 16, 12

Slide 79

Slide 79 text

A Document Based DB? Storing them as relational structure Sunday, September 16, 12

Slide 80

Slide 80 text

A Document Based DB? Storing them as relational structure Converting them back to documents Sunday, September 16, 12

Slide 81

Slide 81 text

A Document Based DB? Storing them as relational structure Converting them back to documents Store them as “Activity Documents” Sunday, September 16, 12

Slide 82

Slide 82 text

Sunday, September 16, 12

Slide 83

Slide 83 text

Why MONGODB? Sunday, September 16, 12

Slide 84

Slide 84 text

Why MONGODB? It is Cool Sunday, September 16, 12

Slide 85

Slide 85 text

Hybrid Approach (Relational DB + MongoDB) Sunday, September 16, 12

Slide 86

Slide 86 text

Hybrid Approach Sunday, September 16, 12

Slide 87

Slide 87 text

Hybrid Approach Sunday, September 16, 12

Slide 88

Slide 88 text

Architecture Sunday, September 16, 12

Slide 89

Slide 89 text

Architecture Sunday, September 16, 12

Slide 90

Slide 90 text

Data Migration From Relational DB TO MongoDB WAS EASY!! Sunday, September 16, 12

Slide 91

Slide 91 text

Performance Benchmark SQL MongoDB Sunday, September 16, 12

Slide 92

Slide 92 text

Performance Benchmark 2 4 8 10 12 0 750 1500 2250 3000 SQL QUERY vs MongoDB Response in ms in millions SQL MongoDB Sunday, September 16, 12

Slide 93

Slide 93 text

Sunday, September 16, 12

Slide 94

Slide 94 text

Simple, Clean Sunday, September 16, 12

Slide 95

Slide 95 text

Simple, Clean And Sunday, September 16, 12

Slide 96

Slide 96 text

Simple, Clean And Maintainable Code Sunday, September 16, 12

Slide 97

Slide 97 text

Simple, Clean And Maintainable Code BUT WAIT !!! Sunday, September 16, 12

Slide 98

Slide 98 text

Simple, Clean And Maintainable Code BUT WAIT !!! TRANSACTION?? Sunday, September 16, 12

Slide 99

Slide 99 text

Transaction Management Sunday, September 16, 12

Slide 100

Slide 100 text

Transaction Management Sunday, September 16, 12

Slide 101

Slide 101 text

Scaling with MongoDB Sunday, September 16, 12

Slide 102

Slide 102 text

Scaling with MongoDB Indexing Sunday, September 16, 12

Slide 103

Slide 103 text

Scaling with MongoDB Indexing Sharding? Sunday, September 16, 12

Slide 104

Slide 104 text

Scaling with MongoDB Indexing Sharding? 8 GB of Data Sunday, September 16, 12

Slide 105

Slide 105 text

Monitoring Mongos mongostat Http Console (localhost:28017) Sunday, September 16, 12

Slide 106

Slide 106 text

Monitoring Mongos Sunday, September 16, 12

Slide 107

Slide 107 text

Relational DB And MongoDB Live In Harmony Together Sunday, September 16, 12

Slide 108

Slide 108 text

Relational DB And MongoDB Live In Harmony Together Sunday, September 16, 12

Slide 109

Slide 109 text

THANK YOU Sunday, September 16, 12