Changes between Version 13 and Version 14 of cs222-2017-fall


Ignore:
Timestamp:
Sep 26, 2017, 4:12:40 PM (8 years ago)
Author:
jamshid
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • cs222-2017-fall

    v13 v14  
    88
    99Online Discussion: https://piazza.com/uci/fall2017/cs222cs122c
     10
    1011 * Please use Piazza properly.  It's a place for students to exchange ideas.  Don't post "easy" or "random" questions without much thinking.
    1112 * To encourage students to actively participate in Piazza discussions and provide high-quality answers, we will select two students with the best Piazza performance. Each student will get 2% extra credits in the overall scores.
    … …  
    1819=== Syllabus ===
    1920|| '''Date''' || '''Topic''' || '''Readings''' || '''Notes''' ||
    20 ||  || DBMS Architecture || Ch. 1; Chamberlin et al 1981 ||  ||
    21 ||  || Course Overview, Project 1, Disks and Files || Ch. 9.1-9.4; Stonebraker 1981 ||  ||
    22 ||  || Page structure, Heap Files, || Ch. 9.5-9.8 ||  ||
    23 ||  || Catalogs, Buffer Manager, || Ch. 8-8.4 ||  ||
    24 ||  || Project 2, Heap Files, Sorted files || ditto ||  ||
    25 ||  || Index Overview and ISAM Tree Index || ditto ||  ||
    26 ||  || Schema versioning, B+ tree || Ch. 10; Graefe 2011 (Sec. 1-3) ||  ||
    27 ||  || B+ tree || ditto || ditto ||
    28 ||  || Static Hashing, Extendible Hashing, Linear Hashing || Ch. 11; Fagin et al 1979; Litwin 1980 ||  ||
    29 ||  || Indexing and Performance || Ch. 8.5-8.6 ||  ||
    30 ||  || Project 3, ditto || ditto ||  ||
    31 ||  || Midterm || || ||
    32 ||  || External Sorting || Ch. 13 ||   ||
    33 ||  || Selection, Projection || Ch. 14.1 - 14.3   ||  ||
    34 ||  || Join || Ch. 14.4  ||  ||
    35 ||  || Set operations, Aggregation, Query Plans || Ch. 14.5, 14.6, Ch. 12  ||  ||
    36 ||  || Project 4, ditto || Ditto ||  ||
    37 ||  || Cost estimation || Ch. 15.2 ||  ||
    38 ||  || Plan Optimization (System-R) || Ch. 15.3, [https://www.cs.berkeley.edu/~brewer/cs262/3-selinger79.pdf Selinger et al 1979] ||  ||
    39 ||  || System-R Optimizer, Open Topics, Course Wrap Up || Ditto ||  ||
    40 
    41 
     21|| || DBMS Architecture || Ch. 1; Chamberlin et al 1981 || ||
     22|| || Course Overview, Project 1, Disks and Files || Ch. 9.1-9.4; Stonebraker 1981 || ||
     23|| || Page structure, Heap Files, || Ch. 9.5-9.8 || ||
     24|| || Catalogs, Buffer Manager, || Ch. 8-8.4 || ||
     25|| || Project 2, Heap Files, Sorted files || ditto || ||
     26|| || Index Overview and ISAM Tree Index || ditto || ||
     27|| || Schema versioning, B+ tree || Ch. 10; Graefe 2011 (Sec. 1-3) || ||
     28|| || B+ tree || ditto || ditto ||
     29|| || Static Hashing, Extendible Hashing, Linear Hashing || Ch. 11; Fagin et al 1979; Litwin 1980 || ||
     30|| || Indexing and Performance || Ch. 8.5-8.6 || ||
     31|| || Project 3, ditto || ditto || ||
     32|| || Midterm || || ||
     33|| || External Sorting || Ch. 13 || ||
     34|| || Selection, Projection || Ch. 14.1 - 14.3 || ||
     35|| || Join || Ch. 14.4 || ||
     36|| || Set operations, Aggregation, Query Plans || Ch. 14.5, 14.6, Ch. 12 || ||
     37|| || Project 4, ditto || Ditto || ||
     38|| || Cost estimation || Ch. 15.2 || ||
     39|| || Plan Optimization (System-R) || Ch. 15.3, [https://www.cs.berkeley.edu/~brewer/cs262/3-selinger79.pdf Selinger et al 1979] || ||
     40|| || System-R Optimizer, Open Topics, Course Wrap Up || Ditto || ||
    4241
    4342== Projects ==
    … …  
    4645|| '''Project''' || '''Due Date''' || '''Topic''' || '''Teams''' || '''Proportions (45%)''' || '''Graded By''' ||
    4746|| [https://grape.ics.uci.edu/wiki/public/wiki/cs222-2017-fall-project1 Project 1] || TBD || Record-Based File Manager (RBF) || Solo Project || 8% || Jamshid ||
    48 ||  || || Relation Manager (RM) || Pair Project || 12% ||
    49 ||  || || Index Manager (IX) || Pair Project || 13% ||
    50 ||  || || Query Engine (QE) || Pair Project || 12% ||
     47|| || || Relation Manager (RM) || Pair Project || 12% ||
     48|| || || Index Manager (IX) || Pair Project || 13% ||
     49|| || || Query Engine (QE) || Pair Project || 12% ||
    5150
    5251[https://docs.google.com/spreadsheets/d/1EoOp_Zyl_dPUBBIx7TJRs-4bcKokIYP01TlxagAJROI/edit?usp=sharing Project team sign-up sheet]
    … …  
    125124
    126125=== Final Exam ===
    127 Tuesday, December 12, 2017, 10:30 a.m. - 12:30 p.m [[BR]]  Usual classroom and an extra classroom [http://www.classrooms.uci.edu/gac/ICF.html Interim Classroom Facility (ICF) 101]. Closed books, Closed notes. You can bring an A4-sized "cheat sheet."  The exam will cover all materials taught in this quarter, with a more emphasis on those after the midterm.
     126Tuesday, December 12, 2017, 10:30 a.m. - 12:30 p.m [[BR]]Closed books, Closed notes. You can bring an A4-sized "cheat sheet."  The exam will cover all materials taught in this quarter, with a more emphasis on those after the midterm.