The ISA6120 Advanced Database Systems course delves deep into the critical concepts, frameworks, strategies, and functionalities intrinsic to database systems. Throughout the program, students will be exposed to a blend of established methodologies and cutting-edge research advancements in the domain. The course endeavors to furnish students with:
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.
Orientation9/3 for 3 hours |
|
During the orientation session, you'll have the opportunity to acquaint yourself with the course structure, meet your instructor, and connect with fellow classmates, fostering a collaborative and engaging learning environment. Activities
|
Overview of Basic Database Concepts9/10, 9/24 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. The session will trace the origins and development of modern database management systems integral to contemporary society, offering an insightful glimpse into foundational database concepts. Key topics to be overviewed include relational models, Entity-Relationship (ER) models, the Structured Query Language (SQL), and intricate indexing concepts, thereby fostering a comprehensive understanding of the pivotal frameworks and languages shaping the current database landscape. Activities
Related Videos (IIT Styles)
Related Videos (US Styles)
|
Object Relational DBMS10/1 for 3 hours |
|
Object-Relational Databases (ORDBs) may be viewed as gateways connecting relational databases to specialized database realms. In this session, the fundamental characteristics and operations of ORDBs will be explored to illustrate why they serve as such critical junctions. Activities
Related Videos |
Spatial Databases10/8, 10/15 for 6 hours |
|
Spatial databases are databases fine-tuned to accommodate and query objects delineated within a geometric space. Given their tendency to manage more complex data structures, they demand enhanced functionalities for the efficient processing of spatial data types. This session will encompass a discussion on the foundational principles of spatial databases along with the frameworks of spatial indexing. Activities
Related Videos |
Lab for PostGIS10/22 for 3 hours |
|
This is the laboratory session focused on PostGIS, a vital extension that facilitates the management of spatial and geographic objects within the PostgreSQL relational database system. During this hands-on session, participants will engage with the dynamic functionalities that PostGIS brings to PostgreSQL, enhancing its capacity to handle geographic objects with precision and efficiency. Activities
|
Student Presentation & Discussion10/29 for 3 hours |
|
Participants will engage in a collaborative exploration of a specified paper using the Jigsaw reading approach. Each student will be entrusted with understanding a particular section of the paper in depth, with the goal to elucidate their findings to group members. This initiative encourages not only a profound individual comprehension of the material but also fosters a synergistic learning environment, where aiding group members in grasping complex concepts becomes paramount. It’s a step towards nurturing a learning community where knowledge is mutually shared and amplified through collaborative discussion. Activities
|
Web Databases11/05 for 3 hours |
|
In this session, the necessity for special protocols to store and access data via websites will be emphasized. Participants will get acquainted with various prominent approaches including HTML, which lays the foundation for web content; XML and its schema, pivotal in data definition and transmission; and JSON, renowned for its ease of use and readability in data interchange. These topics will be intricately explored to equip attendees with practical knowledge for effective web data management. Activities
Related Videos
|
Multidimensional and Multimedia Databases11/12, 11/19 for 6 hours |
|
The DBMS is primed to accommodate data searches from diverse viewpoints, ensuring maintained efficiency, courtesy of multidimensional and multimedia databases. In this session, a deeper focus will be placed on exploring techniques such as Online Analytical Processing (OLAP), which empowers users to swiftly analyze multidimensional data. Additionally, various multimedia database strategies for effectively managing and retrieving media content will be introduced, fostering a robust approach to data handling and analysis. Activities
Related Videos |
Big Data and Graph Databases11/26 for 3 hours |
|
As data sets swell rapidly in size, it may be necessary to reassess the conventional ACID properties entrenched in traditional DBMS. This session will serve to introduce the BASE model, an alternative to ACID, which is more aligned with the needs and challenges posed by Big Data environments, facilitating discussions on its application and benefits in handling voluminous data efficiently. Activities
Related Videos |
Examination12/03 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
|
Student Presentation & Discussion12/10 for 3 hours |
|
Participants will engage in a collaborative exploration of a specified paper using the Jigsaw reading approach. Each student will be entrusted with understanding a particular section of the paper in depth, with the goal to elucidate their findings to group members. This initiative encourages not only a profound individual comprehension of the material but also fosters a synergistic learning environment, where aiding group members in grasping complex concepts becomes paramount. It’s a step towards nurturing a learning community where knowledge is mutually shared and amplified through collaborative discussion. Activities
|
Final Project Demo12/17 3 hours |
|
Putting knowledge into action through learning, reflection, and practice: this marks the final phase of the course, where participants will have the opportunity to develop robust applications using advanced DBMS skills. Requirements
|