인강 보습 (인프런,유데미,패스트캠퍼스)/Fundamentals of Database Engineering 강의 (3) 썸네일형 리스트형 ACID - (2) Phantom Reads Serializable vs Repeatable Read Eventual Consistency 섹션2. ACID - (1) Transaction -A collection of queries -One unit of work commit -> 디스크에 저장 ROLLBACK -> 롤백 Transaction -> 읽기(read)도 포함 8.Atomacity -All queries in a transaction must succeed. -If one query fails, all prior successful queries in the transaction should rollback (even if there were successful queries) -lack of atomacity ~> inconsistency 9.Isolation -Dirty reads -> not fully committed -Non-repeatable r.. 수업 목차 1.ACID -Transaction -Atomicity -Isolation -Consistency -Durability -ACID by Practical Examples -Phantom Reads -Serializable vs Repeatable Read -Eventual Consistency 2.Understanding Database Internals -How tables and indexes are stored on disk -Row-Based vs Column-Based Databases -Primary Key vs Secondary Key 3.Database Indexing 4.B-Tree vs B+Tree in Production Database Systems 5.Database Partiti.. 이전 1 다음