COURSE DESCRIPTION

This course covers advanced database management system design principles and techniques. Course topics include access methods, query processing and optimization, transaction processing, distributed databases, object-oriented and object-relational databases, semi-structured data, search engines, transaction management, advanced indexing, multidimensional data, performance evaluation, advanced structured query language (SQL), and database tuning. Students learn about the advanced object-relational features such as binary large objects (BLOBs), abstract data types, and methods. In addition, students learn about database programming including the use of triggers and stored procedures.

COURSE TOPICS

Traditional relational database management systems (RDBMSs)
Technology trends
Weak isolation and distribution
Query optimization
Techniques everyone should know
Database architectures
Database recovery
Interactive analytics
Languages
Web data

COURSE OBJECTIVES

After completing this course, you should be able to:

CO1 Assess the explosion of the data management field.

CO2 Assess the structural correctness of a database’s design.

CO3 Critique database software.

CO4 Evaluate querying languages.

CO5 Validate database security and integrity policies.

CO6 Evaluate the impact of the Internet on database management.

CO7 Evaluate data integration.

COURSE MATERIALS

You will need the following materials to complete your coursework. Some course materials may be free, open source, or available from other providers. You can access free or open-source materials by clicking the links provided below or in the module details documents. To purchase course materials, please visit the University's textbook supplier.

The required textbook is available at http://www.redbook.io and in the Course Documents folder in the course.

Required Textbook

Bailis, P., Hellerstein, J. M., & Stonebraker, M. (Eds.). (2015). Readings in database systems (5th ed.).

COURSE STRUCTURE

Advanced Database Systems is a three-credit, online course consisting of five modules and a final project. Modules include an overview, topics, learning objectives, study materials, and activities. Module titles are listed below.

Module 1: Traditional Systems and New Trends
Course objectives covered in this module: CO1, CO2, CO3, CO6
Module 2: Isolation, Distribution, and Optimization
Course objectives covered in this module: CO3, CO4
Module 3: Techniques and Architectures
Course objectives covered in this module: CO2, CO3,CO5, CO6
Module 4: Languages
Course objectives covered in this module: CO4, CO7
Module 5: Web Impacts
Course objectives covered in this module: CO5, CO6, CO7

ASSESSMENT METHODS

For your formal work in the course, you are required to participate in online discussion forums, complete written assignments, and complete a final project. See below for details.

Consult the Course Calendar for due dates.

Promoting Originality

One or more of your course activities may utilize a tool designed to promote original work and evaluate your submissions for plagiarism. More information about this tool is available in this document.

Discussion Forums

This course requires you to participate in six graded discussion forums. There is an ungraded but required Introductions Forum in Module 1.

Written Assignments

You are required to complete seven written assignments. The written assignments are on a variety of topics associated with the course modules.

Final Project

The purpose of the final project is to have you demonstrate your command of at least one of the advanced topics addressed by the course by conducting research on that topic and producing a final paper.

GRADING AND EVALUATION

Your grade in the course will be determined as follows:

Discussion forums (6)—30 percent
Written assignments (7)—42 percent
Final project—28 percent

Topic approval (1 percent)—graded as Approved/Needs Revision; must be approved to receive credit. Resubmission until approved will be required.
Preliminary reference list (2 percent)
Final paper (25 percent)

All activities will receive a numerical grade of 0–100. You will receive a score of 0 for any work not submitted. Your final grade in the course will be a letter grade. Letter grade equivalents for numerical grades are as follows:

A	=	93–100	B	=	83–87
A–	=	90–92	C	=	73–82
B+	=	88–89	F	=	Below 73

To receive credit for the course, you must earn a letter grade of C or higher on the weighted average of all assigned course work (e.g., assignments, discussion postings, projects). Graduate students must maintain a B average overall to remain in good academic standing.

STRATEGIES FOR SUCCESS

First Steps to Success

To succeed in this course, take the following first steps:

Read carefully the entire Syllabus, making sure that all aspects of the course are clear to you and that you have all the materials required for the course.
Take time to read the entire Online Student Handbook. The Handbook answers many questions about how to proceed through the course and how to get the most from your educational experience at Thomas Edison State University.
Familiarize yourself with the learning management systems environment—how to navigate it and what the various course areas contain. If you know what to expect as you navigate the course, you can better pace yourself and complete the work on time.
If you are not familiar with web-based learning, be sure to review the processes for posting responses online and submitting assignments before class begins.

Study Tips

Consider the following study tips for success:

To stay on track throughout the course, begin each week by consulting the Course Calendar. The Course Calendar provides an overview of the course and indicates due dates for submitting assignments, posting discussions, and scheduling and taking examinations.
Check Announcements regularly for new course information.

ACADEMIC POLICIES

To ensure success in all your academic endeavors and coursework at Thomas Edison State University, familiarize yourself with all administrative and academic policies including those related to academic integrity, course late submissions, course extensions, and grading policies.

For more, see: