27 | | || 1 || 09/28/17, Th || DBMS Architecture || Ch. 1; Chamberlin et al 1981 || [attachment:cs222-lecture01.ppt PPT], [attachment:setup-mysql.txt Setup MySQL] || |
28 | | || 2 || 10/03/17, Tu || Project 1, Disks and Files || Ch. 9.1, 9.7; Stonebraker 1981 || [attachment:cs222-lecture02.ppt PPT] || |
29 | | || 3 || 10/05/17, Th || Heap Files, Page Formats, Buffer Manager || Ch. 9.2-9.6 || [attachment:cs222-lecture03.ppt PPT] || |
30 | | || 4 || 10/10/17, Tu || Buffer Management, RAID, Catalogs, [https://grape.ics.uci.edu/wiki/public/wiki/cs222-2017-fall-project2 Project 2] || Ch. 9.2, 9.4, 12.1 || [attachment:cs222-lecture04.ppt PPT] || |
31 | | || 5 || 10/12/17, Th || Schema versioning, [http://www.pdl.cmu.edu/PDL-FTP/Database/pax.pdf PAX], Column Stores, OLTP/OLAP, File Organizations || Ch. 8.4 || [attachment:cs222-lecture05.ppt PPT] || |
| 27 | || 1 || 09/28/17, Th || DBMS Architecture || Ch. 1; Chamberlin et al 1981 || [attachment:cs222-lecture01.ppt PPT1], [attachment:setup-mysql.txt Setup MySQL] || |
| 28 | || 2 || 10/03/17, Tu || Project 1, Disks and Files || Ch. 9.1, 9.7; Stonebraker 1981 || [attachment:cs222-lecture02.ppt PPT2] || |
| 29 | || 3 || 10/05/17, Th || Heap Files, Page Formats, Buffer Manager || Ch. 9.2-9.6 || [attachment:cs222-lecture03.ppt PPT3] || |
| 30 | || 4 || 10/10/17, Tu || Buffer Management, RAID, Catalogs, [https://grape.ics.uci.edu/wiki/public/wiki/cs222-2017-fall-project2 Project 2] || Ch. 9.2, 9.4, 12.1 || [attachment:cs222-lecture04.ppt PPT4] || |
| 31 | || 5 || 10/12/17, Th || Schema versioning, [http://www.pdl.cmu.edu/PDL-FTP/Database/pax.pdf PAX], Column Stores, OLTP/OLAP, File Organizations || Ch. 8.4 || [attachment:cs222-lecture05.ppt PPT5] || |