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 basic understanding of the issues involved in database systems, knowledge of currently practical techniques for satisfying such needs, and the current research approaches that are likely to provide a basis for tomorrow's solutions.
The covered topics include:
Supporting this course
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.
Orientation2017/9/11 for 2 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 Concepts2017/9/12, 9/18, 9/19, 9/25 for 8 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 DBMS9/25 for 2 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 Databases10/2, 10/3, 10/16, 10/17 for 8 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 |
Web Databases10/23, 10/24 for 4 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
|
Lab for ElasticSearch10/30 for 2 hours |
This is the lab for Elasticsearch, an open source search engine on top of Apache Lucene. Activities
|
Multidimensional and Multimedia Databases11/6, 11/7 for 4 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 Databases11/13, 11/14 for 4 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 |
Big Data and Graph Databases11/13, 11/14 for 4 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 |
Midterm Examination11/20 for 2 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
|
Lab for Spark11/27 for 2 hours |
This is the lab for Spark, an engine for big data processing, with built-in modules for streaming, SQL, and graph processing. Activities
|
Student Presentation & Discussion12/4, 12/18 for 4 hours |
Time for student presentation and discussion based on specified papers Activities
|
Final Project Demo1/2 2 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 teammates, we dare to dream. Requirements
|