THE THEORY OF DATA MODELING TO BECOME THE FRIEND OF DYNAMODB MASASHI TERUI @ JAWS DAYS 2018 JAWS-UG OSAKA RE:CAP&SERVERLESS

WHY IS THE BUSINESS APPLICATION DIFFICULT TO BECOME SERVERLESS? • Stateful, Persistent • Difficult to parallelize, concurrent and asynchronous

WHY IS THE BUSINESS APPLICATION DIFFICULT TO BECOME SERVERLESS? • Stateful, Persistent • Difficult to parallelize, concurrent and asynchronous NO!!

DATA MODELING

NOSQL MATCHES BETTER THAN RDB • Does RDB’s connection model not match serverless? • Yes, but it is not a main issue • The data model is a main issue • Does your application data match NoSQL(DynamoDB)? • In order to judge it, you need to know general database theory • The people who knows RDB also knows NoSQL

DATA PLACEMENT Distributed by Partition Key
 and Indexed(B+tree) by Sort Key, LSI GSI is a projection of sorted(indexed) data

B+TREE INDEX B-treeͳͷ͔B+treeͳͷ͔͸ެද͞Ε͍ͯͳ͍͚Ͳ Range Keyͱ͔ݺͿ͘Β͍͔ͩΒ…Ͷʁ

TARGETING QUERY B+treeͷߏ଄Λ஌͍ͬͯΕ͹ ૊Έ߹ΘͤΩʔͷΠϯσοΫε͕ແͯ͘΋ ͜͏΍Ε͹ྑ͍͜ͱ͕෼͔Δ

ACID VS BASE? • It is not antinomy • Simply relationships can be consistent with denormalization • Discard the strong consistency 
 for the search queries • It is similar to the RDB replicas • It is difficult to replace the RDB master

SUMMARY

“DATA MODEL IS THE MAIN ISSUE” THANKS!! “NEED TO KNOW GENERAL DATABASE THEORY” “LET'S EXPAND SERVERLESS WORLD”