高等資料庫 ( 持續更新...)
高等資料庫 2017 Fall Review： DBMS： Evolution of DBMS： Punched-Card Record 1914 - 1918 WWI 1929 - 1933 Big Depression ( Bank ) 1939 - 1945 WWII 1950 magnetic tape 1955 Programmed Record Managers ( Batch Processing ) Con： Transaction error 無法即時被偵測 didn't know the current situation. 1965 - 1980 On-line Network Database Indexed sequential records 建立索引 Data independence 資料獨立性 Physical Logical Concurrent Access 一致性 Con： Programming interface are too low level. 1970 E.F. Codd Outline the Relational Model 1976 Peter Chen E-R Model SQL ...( still adding ... ACID： Atomicity： happen or none happen 全有全無 IDEA : keep a log ( history ) for all actions Consistency Isolation：每一筆 transaction 都是獨立的 Durability：耐久性 Relational Model： Data Model - a language to description data 相關名詞： Relation = Table Attribute / Field = Column Record / Tuple = Row Constraint Type：關聯模型的限制 Domain constraints - for value of each attribute