Changes between Version 4 and Version 5 of cs222p-2018-fall


Ignore:
Timestamp:
Sep 26, 2018, 12:12:01 PM (7 years ago)
Author:
Qiushi Bai
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • cs222p-2018-fall

    v4 v5  
    99}}}
    1010== Course Personnel ==
    11 ''Instructor:'' [[BR]] Chen Li[[BR]] E-Mail: chenli AT ics DOT uci DOT edu [[BR]] Office: DBH 2092 [[BR]] Office hours: !Tuesdays/Thursdays 11: am - noon
     11''Instructor:'' [[BR]]
     12 - Chen Li[[BR]] E-Mail: chenli AT ics DOT uci DOT edu [[BR]] Office: DBH 2092 [[BR]] Office hours: !Tuesdays/Thursdays 11: am - noon
    1213
    1314''Assistants:'' [[BR]]
    14 Qiushi Bai [[BR]] E-mail: qbai1 AT uci DOT edu [[BR]] Office: TBD [[BR]] Office hours: TBD [[BR]]
    15 Abulrahman Abdulhamid Alsaudi [[BR]] E-mail: alsaudia AT uci DOT edu [[BR]] Office: TBD [[BR]] Office hours: TBD [[BR]]
     15 - Qiushi Bai [[BR]] E-mail: qbai1 AT uci DOT edu [[BR]] Office: ICS 464C [[BR]] Office hours: !Monday/Friday 8:30 am - 9:30 am [[BR]]
     16 - Abulrahman Abdulhamid Alsaudi [[BR]] E-mail: alsaudia AT uci DOT edu [[BR]] Office: TBD [[BR]] Office hours: TBD [[BR]]
    1617
    1718Online Discussion: https://piazza.com/uci/fall2018/cs222p
    … …  
    4041|| ID || '''Date''' || '''Topic''' || '''Readings''' || '''Notes''' ||
    4142|| 1 || 10/01/18, M || DBMS Architecture || Ch. 1; Chamberlin et al 1981 || [attachment:cs222p-lecture01.ppt PPT1],  [attachment:setup-mysql.txt Setup MySQL]  ||
    42 
     43|| 2 || 10/03/18, W || Project 1, Heap files, Page formats, Record formats || Ch. 9.3, 9.5-9.8 || ||
     44|| 3 || 10/08/18, M || Hard Disks, RAID, Buffer Manager || Ch. 9.1-9.4 || ||
     45|| 4 || 10/10/18, W || Catalogs, Project 2, Schema versioning || Ch. 12.1  || ||
     46|| 5 || 10/15/18, M || [http://www.pdl.cmu.edu/PDL-FTP/Database/pax.pdf PAX], Column Stores, OLTP/OLAP, File Organizations || Ch. 8.1-8.4  || ||
     47|| 6 || 10/17/18, W || Index Overview and ISAM Tree Index || Ch. 10  || ||
     48|| 7 || 10/22/18, M || B+ tree || Ch. 10  || ||
     49|| 8 || 10/24/18, W || Static Hashing, Extendible Hashing, Linear Hashing || Ch. 11; Fagin et al 1979; Litwin 1980 || ||
     50|| 9 || 10/29/18, M || Indexing and Performance || Ch. 8.4-8.6 || ||
     51|| 10 || 10/31/18, W || Project 3, Indexing and Performance || Ditto || Ditto ||
     52|| 11 || 11/05/18, M || Ditto || Ditto || Ditto ||
     53|| 12 || 11/07/18, W || In-class midterm ||  ||  ||
     54|| 13 || 11/12/18, M || External Sorting || Ch. 13 || ||
     55|| 14 || 11/14/18, W || Selection, Projection   || Ch. 14.1 - 14.3 || ||
     56|| 15 || 11/19/18, M || Join || Ch. 14.4 || ||
     57|| 16 || 11/21/18, W || Operator interface, Project 4, Join || Ditto || Ditto ||
     58|| 17 || 11/26/18, M || Set operations, Aggregation, Query Plans || Ch. 14.5, 14.6, Ch. 12 || ||
     59|| 18 || 11/28/18, W || Cost estimation || Ch. 15.2 || ||
     60|| 19 || 12/03/18, M || System-R Optimizer || Ch. 15.3 - 15.6, [attachment:system-R-selinger79.pdf Selinger et al 1979] || ||
     61|| 20 || 12/05/17, W || Textbook cover page, Open Topics, Wrap up! || || ||
    4362
    4463----
    … …  
    87106We will be using Piazza for online class discussions. This system is highly catered to getting you help fast and efficiently from classmates, the Reader(s), and the instructor. Rather than emailing questions to any of us on the teaching staff, we'll ask you to post your questions on Piazza. If you have any problems or feedback for the developers, email team@piazza.com.  Please make Piazza participation (at least monitoring the activity there) a part of your regular CS222P routine!
    88107
    89 You can find our class page at: https://piazza.com/uci/fall2017/cs222p
     108You can find our class page at: https://piazza.com/uci/fall2018/cs222p
    90109
    91110=== Programming Project ===