Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Purpose-Build Database Advanced Design Pattern

Purpose-Build Database Advanced Design Pattern

AWS DevDay Online 2020にて発表させていただいた資料です!

Akihiro Kuwano

October 21, 2020
Tweet

More Decks by Akihiro Kuwano

Other Decks in Technology

Transcript

  1. © 2020, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Purpose-Build Database Advanced Design Pattern Solutions Architect Akihiro Kuwano ( twitter: @kuwa_tw )
  2. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with UGS? ( ) • #.,0!-/0%' • 1+&C7A=:  • 5AWS0(" • Amazon Route53, Amazon S3, Amazon Aurora • Amazon DocumentDB
  3. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with L/1-9; 8E? • AWS+   ! !!  (  • ! !"#  2@> 9   • AWS! !!"#%$-  '*  D • RDBMS, • !&),
  4. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Agenda AWS  Purpose-Built Database F4&0$*0"G<?B Working backwards….;6 & / ).0!-/&0$*0"G63 
  5. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with
  6. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with AWS4<07<.+<5.$ EQ ?
  7. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with AWS4<07<.+<5.$ EQ ? !
  8. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with AWS4<07<.+<5.$ EQ ? !
  9. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with AWS4<07<.+<5.$ EQ ? ! ! !
  10. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with AWS4<07<.+<5.$ EQ ? ! ! !  
  11. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Purpose built
  12. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Purpose-built databases
  13. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Purpose-built databases
  14. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Purpose-built databases C M I R C C I DI T E PIM p M v C oeM p O C s M M !
  15. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with When You’re a Hammer, Everything Looks Like a Nail
  16. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with 4<07<.ZI AWS         Purpose built The right tool for the right job https://www.allthingsdistributed.com/2018/06/purpose-built-databases-in-aws.html   
  17. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Amazon.com ZI$  91 !%0' 85),/ 2016&  OracleAWS 4(*3 Purpose-Built Databases  $# .: DB%%27   "+6.:-,/ Relational Key-value Document In-memory Graph Data warehouse Oracle databases AWS Purpose-Built Databases
  18. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with
  19. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with YB4<07<.$ZI "KO !}]X),CI3M6HL'žUhe)+BK -1;.L) ­ŽY • $#-&;: • *;&s • #;9-&;: • 5;#;# • 70DBGMDB] 5;#;#Wf _ • ^kn@ • :",#9$(+ •
  20. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with "%6:)<-9;V@ 1  : 1,000 .& 2: GB (,: " # %: "0 " : -//sec  :  41:  #/% *)' : !  Social media
  21. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with "%6:)<-9;V@ 2  : 1,000,000 .& 2: PB (,: $# %: "0 " : -3+/sec  : /# 41:  #/% *)' : API  Social media Ride hailing Media streaming Dating
  22. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with =D>
  23. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with
  24. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards – (':$HF 4,&; 18;!6: ed
  25. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards – (':$HF 4,&; {{{ 18;!6: ed 18;!6: *;&4*9 Ž+¥s)#'?M:ož± Pn *;&
  26. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards – (':$HF 4,&; 8  '1/Iož)± 18;!6: *;&4*9 18;!6: ed Pn *;& {{{
  27. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards – (':$HF 4,&; *;&%;# IS }m?M:9M7(gx+”) 8 18;!6: *;&4*9 18;!6: ed {{{ Pn *;&
  28. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards – (':$HF 4,&; 18;!6: ;.# ,CI3M6HLj}m $,CI3M6HLŽ+”)}] *;&%;# IS 8 18;!6: *;&4*9 18;!6: ed {{{ Pn *;&
  29. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with
  30. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with %6:)<-9;4<07<. j¬,CI3M6HLžU+„#§i+›"! &
  31. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with *;3;2RP-.38 • AGM75-@y| 4L>L=‰+›67> E • Pil?M:‚£ • 4FL@+ )  ) • :2[® • š•d$‰  APL 
  32. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with %6:)<-9;V@JP • €U+\v !b' ,187žU+”)  : 1,000,000 .& 2: TB (,: " # %: "0 " : -+/sec  : /# 41:  #/% #/% *)' : API 
  33. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with %6:)<-9;V@JP • €U+\v !b' ,187žU+”) • {TOƒžU$”" ) • =KN *;&C • /;>Y #-; $#   : 1,000,000 .& 2: TB (,: " # %: "0 " : -+/sec  : /# 41:  #/% #/% *)' : API 
  34. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards "  : 1,000,000 .& 2: TB (,: " # %: "0 " : -+/sec  : /# 41:  #/%  #/% *)' : API  =KN *;& C /;>Y  #-; $# 
  35. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards "  : 1,000,000 .& 2: TB (,: " # %: "0 " : -+/sec  : /# 41:  #/%  #/% *)' : API  =KN *;& C /;>Y  #-; $# 
  36. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards " ue DL p?ID abcde BQVX 2020/10/21 00:00:00 Hgj Akihiro Kuwano & blog ZU y)#+z w3:+x y)#+z
  37. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards " 8 p?ID 2('p?FO BQVX %;+ XX@mX Hgj \h & \h p?ID  3:+<oFO
  38. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with TN\*;3;2RP-.38 • AGM75-@y| 4L>L=‰+›67>E • Pil?M:‚£$kpa— • y| ªZq%:2S  4FL@$œˆ % • y|‘z’ $regex $ ^Ša— • 73MJ$a— • DocumentDB©Œ_‡˜  …) { } APL { _id: abcde, title: "My Blog", created: ISODate("2020-08-26…"), author: { _id: “kuwanoa”, name: ‘Akihiro Kuwano' }, tags: [ “blog”, … ], detail: { text: ”…”} }
  39. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with TN\*;3;2RP-.38 • AGM75-@y| 4L>L=‰+›67>E • Pil?M:‚£$kpa— • y| ªZq%:2S  4FL@$œˆ % • y|‘z’ $regex $ ^Ša— • 73MJ$a— • DocumentDB©Œ_‡˜  …) { } APL { _id: abcde, title: "My Blog", created: ISODate("2020-08-26…"), author: { _id: “kuwanoa”, name: ‘Akihiro Kuwano' }, tags: [ “blog”, … ], detail: { text: ”…" }, comment: [ { author: {name: ”Takashi” }, created: ISODate("2020-08-26…"), detail: { text: ”…" } }, { author: {name: “Zabbio” }, created: ISODate("2020-08-26…"), detail: { text: ”…" } }, ] }
  40. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with  [
  41. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with M@ C# "  c,CI3M6HL & €U+g"! &
  42. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with %6:)<-9;V@JP\A • ,187žUNt+« c  : 1,000,000 .& 2: TB (,: " # %: "0 : /sec  : /# 41:  #/% #/% *)' : API 
  43. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with %6:)<-9;V@JP\A • ,187žUNt+« c • {TOƒžU$”" ) • =KN *;&C • /;>Y #-; $# • i[8#+TJ  : 1,000,000 .& 2: TB (,: " # %: "0 : /sec  : /# 41:  #/% #/% *)' : API 
  44. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards "\A  : 1,000,000 .& 2: TB (,: " # %: "0 " : -+/sec  : /# 41:  #/%  #/% *)' : API  =KN *;& C /;>Y  #-; $# i[8#+ TJ
  45. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards "\A  : 1,000,000 .& 2: TB (,: " # %: "0 " : -+/sec  : /# 41:  #/%  #/% *)' : API  =KN *;& C /;>Y  #-; $# i[8#+ TJ
  46. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards " \A ue DL p?ID abcde BQVX 2020/10/21 00:00:00 Hgj Akihiro Kuwano & blog ZU y)#+z w3:+x y)#+z
  47. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with Working backwards " \A 8 p?ID 2('p?FO BQVX %;+ XX@mX Hgj \h & \h p?ID  3:+<oFO
  48. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with *;3;2RP-.38 • AGM75-@y| 4L>L=‰+›67> E • Pil?M:‚£$kpa — • 4*8:R`I • 73MJ”rQ ­†) • ’DynamoDB Streams Elasticsearchw$  API APL BlogID Type title 1 title 1 author kuwano a 1 tags blog Attributes Item    Partition Key Sort Key Primary Key 1 created 2020/10/21 00:00:00
  49. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with 4<07<.ZF • žU+BK-1;.L }“N‹FI<@+R`)?M :DM7+§u) • vtcEaArbql • c,CI3M6HL cžU$W+¨Ÿ)§u–g* )
  50. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with
  51. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with  • AWS  Purpose-Built Database ”f~ “¦¦t” • }¦?M:DM7§i! ”W+jˆ ” (¢”  • }¦?M:DM7+§u)  ”¯©Œ_‡” % “V¤Š¡™ ” +jˆ)Qa—)
  52. © 2019, Amazon Web Services, Inc. or its affiliates. All

    rights reserved. In Partnership with  !W$X Q! [ Purpose-Built Database Week,M0-B$n  °
  53. Thank you! © 2019, Amazon Web Services, Inc. or its

    affiliates. All rights reserved. In Partnership with Speaker Name Contact information