ActiveRecordの力でDBのメタデータを迅速に解析する

by lni_T

Slide 1

Slide 1 text

"DUJWF3FDPSEͷྗͰ %#ͷϝλσʔλΛ ਝ଎ʹղੳ͢Δ 3FKFDUPO3BJMT !MOJ@5ϧχ 4IPSUWFS

Slide 2

Slide 2 text

ࣗݾ঺հ w5XJUUFS 9 *%!MOJ@5 ΑΈ͔ͨϧχ wجຊతʹ3BJMTαʔόʔαΠυΤϯδχΞ w࠷ۙ͸SVCZXBTNͰΑ͘༡ΜͰ͍Δ ʘHPUBOEBSCͷօ༷͸͡Ί·ͯ͠ʂʗ

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

͸͡Ίʹ

Slide 6

Slide 6 text

օ༷ɺ࢓༷ॻ͸ॻ͍͍ͯ·͔͢ʁ

Slide 7

Slide 7 text

ॻ͍ͯΔʔʂ✋

Slide 8

Slide 8 text

͑Β͍

Slide 9

Slide 9 text

ॻ͍ͯͳ͍ʜ😢

Slide 10

Slide 10 text

Θ͔Δʂ

Slide 11

Slide 11 text

࢓༷ॻ͕ͳ͍ͱ͖ γεςϜߏ଄ΛಡΈղ͍ͯ಄ʹೖΕΔඞཁ͕͋Δ ͱ͸͍͑Πν͔Βॻ͘ͷ͸େม

Slide 12

Slide 12 text

࢓༷ॻ͕ͳ͍ͱ͖ γεςϜߏ଄ΛಡΈղ͍ͯ಄ʹೖΕΔඞཁ͕͋Δ γεςϜ͕ංେԽ͢Δ΄Ͳਏ͘ͳΔ ͱ͸͍͑Πν͔Βॻ͘ͷ͸େม γεςϜ͕ංେԽ͢Δ΄Ͳਏ͘ͳΔ

Slide 13

Slide 13 text

γεςϜߏ଄ΛಡΈղ͍ͯ಄ʹೖΕΔඞཁ͕͋Δ γεςϜ͕ංେԽ͢Δ΄Ͳਏ͘ͳΔ ͱ͸͍͑Πν͔Βॻ͘ͷ͸େม γεςϜ͕ංେԽ͢Δ΄Ͳਏ͘ͳΔ ࢓༷ॻ͕ͳ͍ͱ͖ %&"%-0$,

Slide 14

Slide 14 text

࢓༷ॻ͕ͳ͍ͱ͖ γεςϜߏ଄ΛಡΈղ͍ͯ಄ʹೖΕΔඞཁ͕͋Δ γεςϜ͕ංେԽ͢Δ΄Ͳਏ͘ͳΔ ͱ͸͍͑Πν͔Βॻ͘ͷ͸େม γεςϜ͕ංେԽ͢Δ΄Ͳਏ͘ͳΔ ͔͠΋ٸʹඞཁʹͳͬͨΓ͢Δ ϝϯόʔ͕૿͑·͢ʂ ֎஫ʹग़͠·͢ʂɹͳͲ

Slide 15

Slide 15 text

ຊ೔ͷτʔΫςʔϚ ࢓༷ॻ ࠓճ͸%#͕୊ࡐ

Slide 16

Slide 16 text

࢓༷ॻʹٻΊΔ΋ͷ

Slide 17

Slide 17 text

࢓༷ॻʹٻΊΔ΋ͷ γεςϜͷݱঢ়ͱҰக͍ͯ͠Δ͜ͱ ϝϯςφϯεʹਓؒͷίετ͕͔͔Βͳ͍͜ͱ ద੾ͳϑΥʔϚοτͰग़ྗ͞Ε͍ͯΔ͜ͱ

Slide 18

Slide 18 text

ʹࣗಈੜ੒͞Εͯ΄͍͠ʂ

Slide 19

Slide 19 text

ࣗಈੜ੒ͷݱঢ়

Slide 20

Slide 20 text

UCMT HP੡ IUUQTHJUIVCDPNL-P8UCMT

Slide 21

Slide 21 text

4DIFNB4QZ +BWB੡ IUUQTTDIFNBTQZPSH

Slide 22

Slide 22 text

%#ʹ઀ଓͯ͠υΩϡϝϯτԽ ͢Δπʔϧ͕ଘࡏ

Slide 23

Slide 23 text

ࠔ͍ͬͯΔ͜ͱ

Slide 24

Slide 24 text

ࠔ͍ͬͯΔ͜ͱ %#Λϕʔεʹ࢓༷ॻΛग़ྗ͢Δͱ 3BJMTʹఆٛ͞Ε͍ͯΔ࢓༷͕ՄࢹԽ͞Εͳ͍͜ͱ͕͋Δ ྫ ֎෦Ωʔ੍໿Λ࢖༻͠ͳ͍ϦϨʔγϣϯ 3BJMTଆʹߏ଄͕ఆٛ͞Ε͍ͯΔ 45* EFMFHBUFE@UZQFͳͲ

Slide 25

Slide 25 text

3BJMTͷఆٛΛؚΊͯ ͍͍ײ͡ʹղੳ͍ͨ͠

Slide 26

Slide 26 text

ͦ͜Ͱ

Slide 27

Slide 27 text

"DUJWF3FDPSE

Slide 28

Slide 28 text

8IZ"DUJWF3FDPSE

Slide 29

Slide 29 text

"DUJWF3FDPSEͷػೳ σʔλͷಡΈॻ͖

Slide 30

Slide 30 text

"DUJWF3FDPSEͷػೳ όϦσʔγϣϯ

Slide 31

Slide 31 text

"DUJWF3FDPSEͷػೳ ϚΠάϨʔγϣϯ

Slide 32

Slide 32 text

"DUJWF3FDPSEͷػೳ σʔλͷಡΈॻ͖ όϦσʔγϣϯ ϚΠάϨʔγϣϯ ͳͲͷར༻ස౓͕ߴ͍Ͱ͕͢ʜʜ

Slide 33

Slide 33 text

"DUJWF3FDPSEͷػೳ "DUJWF3FDPSEʹ͸Ϩίʔυऔಘૢ࡞Ҏ֎ʹ ςʔϒϧ΍ΧϥϜͦͷ΋ͷͷ৘ใ ϝλσʔλ ΛಘΔػೳ͕උΘ͍ͬͯΔ

Slide 34

Slide 34 text

ࠓ೔ͷຊ୊

Slide 35

Slide 35 text

"DUJWF3FDPSEͰ %#ߏ଄Λࢀর͢Δ

Slide 36

Slide 36 text

"DUJWF3FDPSE.PEFM4DIFNB

Slide 37

Slide 37 text

"DUJWF3FDPSE.PEFM4DIFNB ςʔϒϧ໊΍ΧϥϜ৘ใ͕औΕΔʂ

Slide 38

Slide 38 text

"DUJWF3FDPSE$POOFDUJPO"EBQUFST 4DIFNB4UBUFNFOUT

Slide 39

Slide 39 text

"DUJWF3FDPSE$POOFDUJPO"EBQUFST 4DIFNB4UBUFNFOUT લड़ͷ.PEFM4DIFNBʹͳ͍৘ใ͸ %#ίωΫγϣϯͷΦϒδΣΫτ͔Β௚઀໰͍߹Θ͕ͤՄೳ ΠϯσοΫεͷ৘ใ ͦͷଞςʔϒϧίϝϯτɹͳͲ

Slide 40

Slide 40 text

"DUJWF3FDPSE$POOFDUJPO"EBQUFST 4DIFNB4UBUFNFOUT ΠϯσοΫεҰཡ͕औΕΔʂ

Slide 41

Slide 41 text

"DUJWF3FDPSE3F fl FDUJPO

Slide 42

Slide 42 text

"DUJWF3FDPSE3F fl FDUJPO .PEFMΫϥε͔ΒϦϨʔγϣϯఆٛͷҰཡऔಘ͕Մೳ CFMPOHT@UPIBT@NBOZIBT@POF

Slide 43

Slide 43 text

"DUJWF3FDPSE3F fl FDUJPO ؔ࿈ϞσϧͷҰཡ΋औΕΔʂ

Slide 44

Slide 44 text

ϞσϧఆٛΛࢀর͢Δػೳ͕ ଟ਺࣮૷͞Ε͍ͯΔ

Slide 45

Slide 45 text

࣮͸ଓʑͱػೳ௥Ճ

Slide 46

Slide 46 text

SBJMTQVMM

Slide 47

Slide 47 text

SBJMTQVMM EFMFHBUFE@UZQFͷ Ҡৡઌ͕औಘͰ͖ΔΑ͏ʹ

Slide 48

Slide 48 text

EFMFHBUFE@UZQF ෳ਺ͷαϒΫϥε΁ͷඥ͚͕ͮͰ͖Δ

Slide 49

Slide 49 text

EFMFHBUFE@UZQF Ϟσϧʹඥ͚ͮՄೳͳΫϥεͷ໊લΛऔಘՄೳʹʂ

Slide 50

Slide 50 text

3BJMTͰ௥Ճ͞Εͨ͹͔Γʂ

Slide 51

Slide 51 text

׆༻

Slide 52

Slide 52 text

"DUJWF3FDPSEͰ ࢀরͰ͖Δ৘ใΛ·ͱΊΔͱ

Slide 53

Slide 53 text

Ϟσϧ࢓༷͕ࣗಈੜ੒Մೳʂ

Slide 54

Slide 54 text

෼ੳ༻ίʔυ͸ߦ΄Ͳʂ

Slide 55

Slide 55 text

෼ੳ༻ίʔυ͸ߦ΄Ͳʂ

Slide 56

Slide 56 text

෼ੳ༻ίʔυ͸ߦ΄Ͳʂ ߦͷ࣮૷ˡਝ଎ʁ🤔

Slide 57

Slide 57 text

෼ੳ༻ίʔυ͸ߦ΄Ͳʂ 3BJMTͷػೳΛϑϧ׆༻͍ͯ͠ΔͷͰ ࣮૷͕ඞཁͳͷ͸࢓ํͳ͍ʜ

Slide 58

Slide 58 text

෼ੳ༻ίʔυ͸ߦ΄Ͳʂ 3BJMTͷػೳΛϑϧ׆༻͍ͯ͠ΔͷͰ ࣮૷͕ඞཁͳͷ͸࢓ํͳ͍ʜ Ͱ͕͢ ຊ೔ʹݶΓ

Slide 59

Slide 59 text

gem "schema_doctor" ߦͰ͝ఏڙʂ

Slide 60

Slide 60 text

%#ߏ଄औಘˠυΩϡϝϯτԽΛ ΍ͬͯ͘ΕΔHFNΛ։ൃʂ

Slide 61

Slide 61 text

%FNP

Slide 62

Slide 62 text

% FN P % FN P IUUQTMOJUHJUIVCJPTDIFNB@EPDUPS

Slide 63

Slide 63 text

%#ͷࣗಈղੳ͕ਝ଎ʹ׬ྃʂ

Slide 64

Slide 64 text

·ͱΊɿ%#࢓༷ॻΛ࡞Δʹ͸

Slide 65

Slide 65 text

·ͣ͸%#ͷػೳΛ׆͔͢

Slide 66

Slide 66 text

ςʔϒϧίϝϯτ ΧϥϜίϝϯτ ॻ͜͏ʂ

Slide 67

Slide 67 text

3BJMTΨΠυ΋ॻ͚ͬͯΏͬͯΔ IUUQTSBJMTHVJEFTKQBDUJWF@SFDPSE@NJHSBUJPOTIUNMίϝϯτ

Slide 68

Slide 68 text

ղੳπʔϧͰग़ྗՄೳʹʂ

Slide 69

Slide 69 text

΋ͬͱਖ਼֬ʹυΩϡϝϯτԽ͍ͨ͠ʜ

Slide 70

Slide 70 text

"DUJWF3FDPSEʂ ׆༻͠Α͏ʂ

Slide 71

Slide 71 text

એ఻

Slide 72

Slide 72 text

gem "schema_doctor" IUUQTHJUIVCDPNMOJUTDIFNB@EPDUPS

Slide 73

Slide 73 text

ࠓޙͷల๬

Slide 74

Slide 74 text

JOจݴͷநग़Λ։ൃத

Slide 75

Slide 75 text

JOͷจݴΛநग़ ςʔϒϧίϝϯτ΍ΧϥϜίϝϯτͷઃఆ͸ %#NJHSBUJPOΛ൐͏ͷͰѻ͍ͮΒ͍ʂ JOͷϞσϧ໊΍ଐੑ໊͕࢓༷ॻʹ൓ө͞ΕΔͱخ͍͠έʔε͕͋Γͦ͏ ಛʹզʑ͸KBͷจݴΛఆٛ͢ΔຽͳͷͰ

Slide 76

Slide 76 text

࢓༷ॻੜ੒ͷ Ϣʔεέʔεืूதʂ IUUQTHJUIVCDPNMOJUTDIFNB@EPDUPS

Slide 77

Slide 77 text

gem "schema_doctor" IUUQTHJUIVCDPNMOJUTDIFNB@EPDUPS ͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠ʂ