トランザクションスクリプトは何がダメなのか？

トランザクションスクリプトの何がダメなのか自分なりに考えてみた話をします。

Transcript

1. !QPMJEPH
   τϥϯβΫγϣϯεΫϦϓτ͸Կ
   ͕μϝͳͷ͔ʁ
   

   ઃܭφΠτ
   

   View Slide

2. ࣗݾ঺հ
   w !QPMJEPH
   w ύʔςΟʔϋʔυגࣜձࣾ
   w 1)1FS 4ZNGPOZ
   
   w ଉࢠ͸ࡀϲ݄ɺΊͬͪΌ͔Θ͍͍
   

   View Slide

3. IUUQTUXJUUFSDPNQPMJEPHTUBUVT
   

   View Slide

4. τϥϯβΫγϣϯεΫϦϓτͷԿ͕μϝͳ
   ͷ͔ࣗ෼ͳΓʹߟ͑ͯΈͨ࿩Λ͠·͢ɻ
   

   View Slide

5. τϥϯβΫγϣϯεΫϦϓτʹ͍ͭͯ
   ߟ͑ΔΑ͏ʹͳ͖͔͚ͬͨͬ
   

   View Slide

6. ͖͔͚ͬ
   w ύʔτφʔ͞Μ͔Βೲ඼͞Εͨίʔυ͕τϥϯβΫγϣϯεΫϦϓτͩͬͨ
   w ࢓༷ͷมߋ͕݁ߏ͚͋ͬͨͲɺͦΜͳʹਏ͘ͳ͔ͬͨ
   

   ςετ͔ͬ͠Γॻ͔ΕͯΔ͔Βɺਏ͘ͳ͍͚͔ͩ΋͠Εͳ͍͕
   
   w ͔͠΋ಡΈ΍͍͢ɺΘ͔Γ΍͍͢ɺਪ࿦͠΍͍͢ίʔυ
   w τϥϯβΫγϣϯεΫϦϓτͬͯԿ͕ͩΊͳΜ͚ͩͬʁͬͯߟ͑ΔΑ͏ʹͳͬ
   ͨ
   

   View Slide

7. τϥϯβΫγϣϯεΫϦϓτͷ໰
   ୊఺
   

   View Slide

8. IUUQTIJHBZBTVPIBUFOBCMPHDPNFOUSZ
   

   View Slide

9. IUUQTIJHBZBTVPIBUFOBCMPHDPNFOUSZ
   lτϥϯβΫγϣϯεΫϦϓτ೿͸ɺʮτϥϯβΫγϣϯεΫϦϓτͷํ͕ॻ͘ͷ͕
   ؆୯ͩ͠ɺۀ຿ΞϓϦέʔγϣϯʹΦϒδΣΫτࢦ޲͸ɺ΄ͱΜͲඞཁͳ͍ʯͱ
   ͍͍·͢ɻ
   ͦΕʹର͠ɺυϝΠϯϞσϧ೿͸ɺʮυϝΠϯϞσϧ͸ΦϒδΣΫτࢦ޲Λੜ͔͢
   ͜ͱ͕Ͱ͖ΔͷͰϝϯςφϯεੑ͕ྑ͍ʯͱओு͠·͢ɻz
   

   View Slide

10. IUUQTIJHBZBTVPIBUFOBCMPHDPNFOUSZ
    zࣅͨΑ͏ͳৼΔ෣͍͕ෳ਺ͷαʔϏεʹ෼ࢄ͢Δةݥ͕͋ΔͨΊͰ͢ɻ
    ͜Ε͸ɺτϥϯβΫγϣϯεΫϦϓτͰϩδοΫ͕ॏෳ͠΍͘͢ͳΔͷͱಉ͡ཧͰ͢ɻ
    υϝΠϯΦϒδΣΫτ ΤϯςΟςΟ
    ʹର͢ΔαʔϏεʹׂΓ౰ͯΔͱ͍͏ϧʔϧ͕໌
    ֬ͳΒɺطଘͷαʔϏε ΍ΤϯςΟςΟ
    Λௐ΂Δ͜ͱͰॏෳΛආ͚ΒΕΔ͔ΒͰ
    ͢ɻz
    

    View Slide

11. View Slide

12. ΤϯλʔϓϥΠζΞϓϦέʔγϣϯΞʔΩςΫνϟύλʔϯ1
    lಛʹ஫ҙ͢΂͖͜ͱ͸ɺτϥϯβΫγϣϯؒͰͷॏෳͷ໰୊Ͱ͋
    Δɻ
    ͭͷτϥϯβΫγϣϯΛॲཧ͢Δ͜ͱ͕ॏཁࣄ߲ͱͳΔͷͰɺ
    ڞ௨͢ΔͲͷίʔυ΋ॏෳ͠΍͍͢ঢ়گʹͳΔɻz
    

    View Slide

13. ΤϯλʔϓϥΠζΞϓϦέʔγϣϯΞʔΩςΫνϟύλʔϯ1
    lΑΓෳࡶͳϏδωευϝΠϯͰ͸ɺυϝΠϯϞσϧͷߏங͕ඞཁ
    ʹͳΔɻυϝΠϯϞσϧͰ͸ɺ๛෋ͳΦϓγϣϯΛ࢖ͬͯίʔ
    υΛܗ੒Ͱ͖ΔͷͰɺಡΈ΍͕͢͞૿͢ͱಉ࣌ʹॏෳ΋ݮΒ͢
    ࣄ͕Ͱ͖Δz
    

    View Slide

14. ΤϯλʔϓϥΠζΞϓϦέʔγϣϯΞʔΩςΫνϟύλʔϯ1
    lυϝΠϯϞσϧ͕࣋ͭՁ஋͸ɺ͍ͬͨΜ׳Εͯ͠·͑͹ɺϩδοΫ͕ෳࡶʹͳͬͯ
    ΋े෼ʹମܥԽ͞Εͨํ๏ͰରॲͰ͖Δଟ͘ͷٕ๏͕͋Δ͜ͱͰ͋Δɻz
    lτϥϯβΫγϣϯεΫϦϓτͷ৔߹͸ɺεΫϦϓτͷ৚݅෼ذϩδοΫΛ௥Ճͯ͠
    ΞϧΰϦζϜΛ௥Ճ͢Δ͜ͱʹͳΔɻz
    

    View Slide

15. τϯϥϯβΫγϣϯεΫϦϓτ͕μϝͳཧ༝
    w ίʔυͷॏෳͷ໰୊
    w ಡΈ΍͢͞ͷ໰୊
    w ֦ுੑͷ໰୊
    w ෳࡶੑͷ໰୊
    

    View Slide

16. υϝΠϯϞσϧͰղܾͰ͖Δͷ
    ͔ʁ
    

    View Slide

17. υϝΠϯϞσϧͰղܾͰ͖Δͷ͔ʁ
    w ίʔυͷॏෳͷ໰୊αϒϧʔνϯԽ
    w ಡΈ΍͢͞ͷ໰୊υϝΠϯϞσϧͷֶशίετ͕ߴ͍ͷʹಡΈ΍͍͢ͱ͍
    ͍͍ͬͯͷ͔ʁ
    w ֦ுੑͷ໰୊૝ఆ಺ͷ֦ு͔͠୲อͰ͖ͳ͍ͷͰ͸ʁ
    w ෳࡶੑͷ໰୊ෳࡶͳ΋ͷ͸ෳࡶɾίʔυͰղܾ͢Δ໰୊͡Όͳ͍
    

    View Slide

18. ΤϯλʔϓϥΠζΞϓϦέʔγϣϯΞʔΩςΫνϟύλʔϯ1
    lෳࡶͰසൟʹมߋ͞ΕΔϏδωεϧʔϧΛ࢖͍ͬͯΔ৔߹ɺΦϒ
    δΣΫτϞσϧͰରॲ͢Δ͜ͱ͕͋Δɻ
    ҰํͰɺ؆୯ͳඇψϧνΣοΫͱ̎ͭͷ߹ܭΛܭࢉ͢Δ৔߹ɺτ
    ϥϯβΫγϣϯεΫϦϓτͷํ͕ద੾Ͱ͋Δz
    

    View Slide

19. τϥϯβΫγϣϯεΫϦϓτΛ
    ࢖͏ͳͬͯ͜ͱͰ͸ͳ͍
    

    View Slide

20. IUUQTUXJUUFSDPNTVHJNPUP@LFJTUBUVT
    

    View Slide

21. IUUQTUXJUUFSDPNKJLPTUBUVT
    

    View Slide

22. ςελϏϦςΟతͳࢦඪͰߟ͑ͨ
    ΄͏͕͍͍ͷͰ͸ʁ
    

    View Slide

23. ·ͱΊ
    

    View Slide

24. ·ͱΊ
    w τϥϯβΫγϣϯεΫϦϓτ͸μϝͰ͸ͳ͍
    w ͦ΋ͦ΋τϥϯβΫγϣϯεΫϦϓτWTυϝΠϯϞσϧΈ͍ͨͳߏਤͰߟ͑
    Δ΂͖Ͱ͸ͳ͍
    w ৽͍͠ࢹ఺͕ඞཁͳͷͰ͸ʁ
    

    View Slide