About ISA6120, Fall 2022

This course covers the essential concepts, principles, techniques, and mechanisms associated with database systems. The state-of-the-art techniques, including traditional approaches as well as recent research developments, would be introduced in this course. The course is intended to provide three major concepts: 1) basic understanding of the issues involved in database systems; 2) knowledge of currently practical techniques for satisfying such needs; and 3) the current research approaches that are likely to provide a basis for tomorrow's solutions.

The covered topics include:

  • Traditional DB Reviews: ER, Relational DM, EER, SQL
  • Object-Relational Databases
  • Web Database Format: XML, JSON
  • Spatial Databases
  • Multidimensional Databases
  • Multimedia Databases
  • Graph Databases
  • Big Data (and NoSQL)

Text Book

    Ramakrishnan, Gehrke. "DATABASE MANAGEMENT SYSTEMS" , third edition, McGRAW Hill

Time in 2022

  • Monday 9:00AM-10:15PM
  • Monday 10:25AM-11:40PM

Location

  • Delta 102
  • Teams

People

Supporting this course

Instructor:

Yi-Shin Chen

Yi-Shin Chen

She offers the fundamental database course and advance database courses for more than a decade. Her current research interests are: social networks, data mining, emotion analysis, and web intelligence.

  • email: yishin@gmail.com
  • phone: +886-3-573-1211
  • office: Delta 607
  • office hours: Mondays 15:00-16:00

Teaching Assistants:

Alejandro José Cortés

Alejandro Cortés
  • email: alex.cortes.i10@gmail.com
  • office: Delta 701

Dave Wu

Dave
  • email: d2cb103@gmail.com
  • office: Delta 701

Syllabus

Orientation

9/12 for 3 hours

You will get familiar with the course, the instructor, your classmates, and the learning environment. The overview of the course will also be covered during the same session.

Activities

Overview of Basic Database Concepts

9/19, 9/26 for 6 hours

"Database community focuses on information storage, organization, management, and access and it is driven by new applications" cited from the Lowell Database Research Self-Assessment Report. In this session, we will discuss how our society forms/formed the modern database management systems. We will also have an overview for basic database concepts.

Activities

Related Videos (IIT Styles)

Related Videos (US Styles)

Object Relational DBMS

10/3 for 3 hours

Object Relational Database (ORDB) can be considered as portals of relational database to other special databases. Why? The basic properties and functionalities of ORDB will be discussed in this session.

Activities

Related Videos

Spatial Databases

10/17, 10/24 for 6 hours

Spatial Databases is a database optimized for storing and query objects defined in a geometric space. Most spatial databases handle more complex data structures and hence require additional functionality to process spatial data types efficiently. In this session, the basic concepts of spatial databases and designs of spatial indexes will be covered.

Activities

Related Videos

Lab for PostGIS

10/31 for 3 hours

This is the lab for PostGIS, Spatial and Geographic Objects for PostgreSQL.

Activities

  • Attend the class with your personal laptop
  • Assignment One should be submitted before Nov 12

Student Presentation & Discussion

11/7 for 3 hours

Time for student presentation and discussion based on specified papers

Activities

  • The assignment will be given by TAs.

Web Databases

11/14, 11/21 for 6 hours

To store and access the data via websites requires special designed protocols. In this session, several approaches will be introduced, including HTML, XML, XML schema, JSON.

Activities

Related Videos

Multidimensional and Multimedia Databases

11/28, 12/5 for 6 hours

Can the DBMS support the needs of searching data in multiple perspectives? How can we still ensure the efficiency? Multidimensional databases and multimedia databases are the answers. In this session, several techniques for these databases will be introduced.

Activities

Related Videos

Big Data and Graph Databases

12/12 for 3 hours

When the sizes of data set grow rapidly, the ACID properties of traditional DBMS might need to be reconsidered. In this session, we will introduce and discuss the techniques addressing these Big Data challenges. How and Why?

Activities

Related Videos

Student Presentation & Discussion

12/19 for 3 hours

Time for student presentation and discussion based on specified papers about Big Data

Activities

  • The assignment will be given by TAs.

Examination

12/26 for 3 hours

Time to evaluate. Different from other examination in our life, we do not want to assess how much we remember. It is more important to know how much we understand. Hence, each student can bring one A4-page paper with all kinds of notes into the classroom. Enjoy.

Notes

  • Students can take one A4 page with them

Final Project Demo

1/9 3 hours

Realizing by learning, thinking, and doing. This is the final realizing step, to develop a fine application with advanced DBMS skills, for this course. Through this practice, we not only polish our database skills but also experience team works. With team mates, we dare to dream.

Requirements

  • Students should work with several people for their project.
  • Each group should generate 4 minute youtube clips to show in the class
  • Each group should have a poster and a working system
  • Final Project Requirement Description