Large Database Technology (Fall 2017)

Instructor Lei Deng
Location: Rm.404, No.2 Comprehensive Laboratory Building
Office hour: 9:00-17:00
Teaching assistants Cheng Zeng
Prerequisites JAVA/C++ Programming
Data Structures
Database Basics
Texts and readings Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2, Steven Feuerstein, Bill Pribyl
Oracle PL/SQL从入门到精通
数据库技术丛书:高并发Oracle数据库系统的架构与设计 [High Concurrency Oracle Database System Architecture and Design]
Additional materials will be provided as handouts or in the form of light technical papers.
Grading Homework/Participation/Presentation/Experiment 40%, Final Exam 60%
Policies You are encouraged to discuss your homework assignments with your classmates; however, any code you submit must be your own work. You may not share code with others or copy code from outside sources, except where the assignment specifically allows it. Plagiarism can have serious consequences
Schedule Below is the tentative schedule for the course:

Date Topic Reading/Experiment materials Homework
Week 11 Monday Introduction & Course overview
Oracle basic knowledge
  • A Comparative Study on the Performance of the Top DBMS Systems
    Week 11 Friday Oracle & PL/SQL Introduction & Management
    slide 2-1, slide 2-2
    Oracle 11g install manual (linux & silent)  
    Week 12 Monday PL/SQL Conditional Controls & Iterative Controls
    slide 3-1
    Week 12 Friday (Move to Wednesday afternoon) Experiment 1
    Week 13 Monday PL/SQL Cursors & Exceptions
    slide 4-1
    Week 13 Friday (Move to Wednesday afternoon) Experiment 2
    Week 14 Monday PL/SQL Procedures & Functions & Triggers
    slide 4-2, slide 4-3
    Week 14 Friday (Move to Wednesday afternoon) Experiment 3
    Week 15 Monday High Performance Indexing
    slide 5-1
    Week 15 Friday (Move to Wednesday afternoon) Experiment 4
    Week 16 Monday High Performance In-memory Database
    Distributed Database System
    Week 16 Friday (Move to Wednesday afternoon) Experiment 5
    Week 17 Monday Distributed Database & Database Clustering
    Development of Ali Database
     DRDS Video  
    Week 17 Friday (Move to Wednesday afternoon) Experiment 6
    Week 18 Monday Future Development & Answer Questions
    Week 18 Friday Final Examination