トランザクションの基本概念


事務の基本概念面接でよく聞かれる

1.     


  (Transaction)               ,        ,     ,            .         SQL  ,      SQL  .       , A    1000    B  ,   A    1000   1000   B      ,   A    1000    B    1000   ,   A    1000    B    1000  ,          ,      .         ,     SQL              .


 SQL   ,        :BEGIN TRANSACTION,COMMIT,ROLLBACK.                ,DBMS           .   BEGIN TRANSACTION    , COMMIT ROLLBACK    .COMMIT      ,        .ROLLBACK    ,             ,      ,             ,         .


2.     


        :   (Atomicity),   (Consistency),   (Isolation)     (Durability).   ACID  .


(1)    


             ,        ,         .              ,     .


(2)    


                              .                   ,           .              ,             ,                       ,             .


(3)    


                .                           ,                 .


(4)    


         ,                   .                         .


    ACID            .  ACID            :


(1)          ,           .


(2)              .


       ,                               ;       ,                                  .                        .