Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Speaker Deck
PRO
Sign in
Sign up for free
【社内勉強会用】SQLアンチパターン / SQL Antipatterns study
VTRyo
April 12, 2020
Programming
0
1.4k
【社内勉強会用】SQLアンチパターン / SQL Antipatterns study
2020/4/13 第5章 エンティティ・アトリビュート・バリュー
VTRyo
April 12, 2020
Tweet
Share
More Decks by VTRyo
See All by VTRyo
Datadogでシステムとアプリケーション情報を民主化をはじめよう / System and Application information democratize with datadog
vtryo
1
700
サービスと開発者に最も近いProduct SREsとして 取り組んでいるコト / Work as Product SREs closest to services and developers
vtryo
0
1.7k
一人から始めるプロダクトSRE / How to start SRE in a product team, all by yourself
vtryo
4
8.9k
へんなSlackスタンプMeetup
vtryo
0
160
Kubernetes × CircleCIで実現する安心安全Deploy / Safe Deploy with Kubernetes and CircleCI
vtryo
1
2k
これからエンジニアになる人に知ってほしい失敗や不安との向き合い方 / A way of life for beginner engineers
vtryo
2
360
物語を技術同人誌に落とし込む技術 / Technology that uses stories in technology Fanzine
vtryo
1
1.2k
Amazon EKSで構築する社内PaaS - AWS Summit Startup Central / create-paas-eks
vtryo
2
9.4k
技術書典6前夜祭!サークル主LT "挫折論への招待" / techbook-fest6
vtryo
3
190
Other Decks in Programming
See All in Programming
tidy_rpart
bk_18
0
590
データドリブンな組織の不正検知
fkubota
0
230
Amebaブログの会員画面システム刷新の道程
ryotasugawara
1
230
SwiftPMのPlugin入門 / introduction_to_swiftpm_plugin
uhooi
2
100
(新米)エンジニアリングマネージャーのしごと #RSGT2023
murabayashi
9
5.7k
Spring BootとKubernetesで実現する今どきのDevOps入門
xblood
0
340
ECテックカンファレンス2023
kspace
1
330
Showkase、Paparazziを用いたビジュアルリグレッションテストの導入にチャレンジした話 / MoT TechTalk #15
mot_techtalk
0
110
xarray-Datatree: Hierarchical Data Structures for Multi-Model Science
tomnicholas
0
210
CDKでValidationする本当の方法 / cdk-validation
gotok365
1
200
Excelの助けを借りて楽にシナリオを作ろう
rpa_niiyama
0
290
Cloudflare Workersと状態管理
chimame
3
480
Featured
See All Featured
Understanding Cognitive Biases in Performance Measurement
bluesmoon
2
400
KATA
mclloyd
12
9.7k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
44
14k
Product Roadmaps are Hard
iamctodd
38
7.7k
Building Adaptive Systems
keathley
27
1.3k
Docker and Python
trallard
30
1.9k
Debugging Ruby Performance
tmm1
67
11k
Learning to Love Humans: Emotional Interface Design
aarron
263
38k
Statistics for Hackers
jakevdp
785
210k
Bash Introduction
62gerente
601
210k
Distributed Sagas: A Protocol for Coordinating Microservices
caitiem20
318
19k
Large-scale JavaScript Application Architecture
addyosmani
499
110k
Transcript
d753ZPQSFTFOUBUJPO NBTUFS WUSZPDUMEFTDSJCFQSFTFOUBUJPO d753ZPQSFTFOUBUJPO NBTUFS QSFTFOUBUJPOTUBSUFE 42-Ξϯνύλʔϯ ୈষ ΤϯςΟςΟɾΞτϦϏϡʔτɾόϦϡʔ ʢ˞ࣾษڧձൃදࢿྉʣ
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
˞ҙ w ຊࢿྉࣾษڧձͷ՝Ͱ࡞ͨ͠ͷͰ͢ w l42-ΞϯνύλʔϯzΛࢀߟʹ࡞͍ͯ͠·͢ w ͡ΊͯຊॻΛಡΜͰ͍·͢
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
&"7ͱ w ΤϯςΟςΟɾΞτϦϏϡʔτɾόϦϡʔ ʢఆٛରʣɹɹɹʢଐੑʣɹɹʢʣ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
Ξϯνύλʔϯߏ Α͘ݟͨΒ ϯνύλʔϯʹͳͬͯ·ͨ͠ ൚༻తͳଐੑςʔϒϧΛ༻ͪ͠Ό͏ ଐੑΛߦʹ֨ೲͪ͠Ό͏ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
ଐੑऔಘ͢Δʹ ΫΤϦ͕ෳࡶʹͳΔ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
ඞਢଐੑΛઃఆͰ͖ͳ͍ /05/6--੍Λએݴ͢Δ͚ͩͰ ຊΑ͔ͬͨͷʹʜ ଐੑ͕ ߦʹ֨ೲ͞Ε͍ͯΔ
[email protected]
ྻʹ
[email protected]
͕ೖ͍ͬͯΔߦΛ
[email protected]
͝ͱʹଘࡏͤ͞Δ੍͕Ϝζ͍
ผʹ·ͱΊͯϨϙʔτΛ࡞Γ͍ͨ ˠʮ
[email protected]
Ͱूܭ͠Αʯ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
σʔλܕΛ͑ͳ͍ %"5&ܕͰྻΛఆٛ͢Ε͍͍ ͚ͩͳͷʹʜ σʔλܕ ͕จࣈྻ ݸผͷ
[email protected]
ྻΛఆٛ͢Δ͜ͱ͋Δ͕ʜ ΫΤϦෳࡶԽ͢Δ
ผʹ·ͱΊͯϨϙʔτΛ࡞Γ͍ͨ ˠʮ
[email protected]
Ͱूܭ͠Αʯ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
ࢀর߹ੑͷڧ੍ෆՄ '03&*(/,&: TUBUVT 3&'&3&/$&4#VH4UBUVT TUBUVT
Ͱ͍͍ͷʹʜ શߦʹ ద༻͞Εͯ͠·͏ '03&*(/,&:
[email protected]
3&'&3&/$&4#VH4UBUVT TUBUVT TUBUVTଐੑͷ#VH4UBUVTςʔϒϧ͕ ֨ೲ͍ͯ͠Δʹ͍ͨ͠ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
*TTVFΛҰߦͰऔಘ ɾ࠶ߏங͕ඞཁ ɾଐੑ૿Ճʹ݁߹ͷ૿Ճ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
͏Ξϯνύλʔϯ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
ΞϯνύλʔϯͰ͍͍ྫ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
&"7Λճආ͠Α͏ ̍ɽͻͱͭͷςʔϒϧʹ αϒλΠϓΛશ෦ೖΕΔ ̎ɽαϒλΠϓ͝ͱʹ ςʔϒϧΛ࡞͢Δ ̏ɽςʔϒϧΛΦϒδΣΫτࢦͷ ΫϥεʹݟཱͯͯܧঝΛ฿͢Δ
̐ɽ9.-+40/ܗࣜͰଐੑɾ Λڞʹ֨ೲ͢Δ దͳঢ়گͰͲΕ͔Λબͯ͜͠͏ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
̍ɽγϯάϧςʔϒϧܧঝ w શͯͷଐੑΛ*TTVFͷݸผྻͱͯ֨͠ೲ͢Δ w "DUJWF3FDPSEͱ૬ੑΑ͖ w αϒλΠϓͷগͳ͍ͱ͖ʹ༗ޮ
Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
̎ɽ۩ςʔϒϧܧঝ w #VHTςʔϒϧɺ'FBUVSF3FRVFTUTςʔϒϧͳͲαϒλΠ ϓ͝ͱʹ࡞͢Δ w ڞ௨͢ΔଐੑͱݸผͷଐੑΛ࣋ͭ w
ͯ͢ͷαϒλΠϓΛ·͍ͨͩݕࡧ͕গͳ͍ͱ͖༗ޮ w αϒλΠϓ͕ผςʔϒϧʹ͋ΓෳࡶԽ͢ΔͨΊ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
̏ɽΫϥεςʔϒϧܧঝ w ͯ͢ͷαϒλΠϓʹڞ௨͢ΔଐੑΛؚΉجఈςʔϒϧ ʢ*TTVFʣΛ࡞Δ w *TTVFςʔϒϧɺ#VHTςʔϒϧɺ'FBUVSF3FRVFTUT ςʔϒϧʹ
[email protected]
Λઃఆ͢Δ
w ͯ͢ͷαϒλΠϓʹڞ௨͢ΔྻΛࢀর͢ΔΫΤϦ͕ස ൟʹ࣮ߦ͞ΕΔͱ͖ʹ༗ޮ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
̐ɽߏԽςʔϒϧ w සൟʹଐੑΛՃ͢Δέʔε-0#ܕʢ-BSHF0CKFDUʣ ΛՃ͠+40/ͳͲͷܗࣜͰ֨ೲ͢Δ w ͲΜͳଐੑͰ֨ೲͰ͖ΔͷͰ֦ுੑ͕ߴ͍ w
ಛఆͷଐੑʹΞΫηε͢Δखஈ͕ͳ͘ɺΞϓϦέʔγϣϯ ίʔυͰղ͢Δඞཁ͕͋Δܽ w αϒλΠϓͷ੍͕ݶͰ͖ͳ͍ɺଐੑఆٛͷॊೈੑ͕ඞཁ ͳ߹ʹ༗ޮ Q
d753ZPQSFTFOUBUJPO NBTUFS 5XJUUFS!
[email protected]
·ͱΊ w 42-ɺҟͳΔଐੑҟͳΔྻʹ֨ೲ͢Δํ๏ཱ͕֬͞ Ε͍ͯΔ w &"7ͷ࠾༻ɺଐੑΛࣝผ͢ΔͨΊͷ৽ͨͳํ๏Λ42- ্ʹߏங͢Δ͜ͱΛҙຯ͢Δ
w ʮϝλσʔλɺϝλσʔλͷͨΊʹ༻͍·͠ΐ͏ʯ Q
d753ZPQSFTFOUBUJPO NBTUFS WUSZPDUMEFTDSJCFQSFTFOUBUJPO d753ZPQSFTFOUBUJPO NBTUFS QSFTFOUBUJPOTUBSUFE 42-Ξϯνύλʔϯ ୈষ ΤϯςΟςΟɾΞτϦϏϡʔτɾόϦϡʔ ʢ˞ࣾษڧձൃදࢿྉʣ