Advanced Database Systems -Group 4

Group [GROUP NUMBER]

Replace [GROUP NUMBER] with your assigned group number. Replace the sample entries and add or remove rows so each group member has one row.

If your site is public, include full student IDs only with course authorization. Submit the complete roster privately if required.

Course overview

This course builds on introductory databases and SQL. Students examine how a database management system processes queries, compare physical design choices, and apply techniques for transaction management, recovery, and access control.

Level

Undergraduate

Recommended background

Relational modeling, keys, joins, and basic SQL

Learning outcomes

By the end of the course, students should be able to:

1. Compare B+ tree and hash-based access methods for different query patterns.
2. Translate SQL queries into relational algebra and use equivalence rules to rewrite query plans.
3. Interpret execution plans and use measurements to evaluate indexing and query rewrites.
4. Explain transaction isolation, concurrency anomalies, and the role of logs in recovery.
5. Build views and stored procedures, and grant database users only the privileges they need.

Core topics

Practical work and assessment

A sample project is a PHP application backed by MySQL. Students design the schema, build search pages using views, compare a slow query before and after indexing, call a stored procedure from PHP, and verify access restrictions using separate database accounts.

Assessment may include lab exercises, quizzes, exams, and a project. Refer to the official syllabus for grading weights and deadlines.

Deploy this page to a web server

Each group must register its own domain in DigitalPlat, deploy to its own web server, and publish this page at https://advanceddb.<GROUP_DOMAIN>/. Replace <GROUP_DOMAIN> with your group's full registered domain. For example, if your domain is group12.dpdns.org, your site address is https://advanceddb.group12.dpdns.org/.

1. Prepare the page. Edit the group number and roster in the HTML, save the file as index.html, and open it in a browser to check the content.
2. Set up DNS. In your group's DigitalPlat Hosted DNS zone, create an A record with the relative name advanceddb and your own server's public IPv4 address as the value. Verify the result with nslookup or Resolve-DnsName.
3. Upload the file to your group's server. Transfer index.html via SCP or SFTP using your SSH account. Place it in your site's document root, for example /var/www/advanceddb. Ensure the web server can read the file and traverse its parent directories.
4. Configure the web server. On Ubuntu with Nginx, configure a server block with your hostname as server_name, your document directory as root, and index.html as index. Enable the configuration, run sudo nginx -t, then reload Nginx if the test passes.
5. Enable HTTPS. For a public site, check that cloud and host firewall rules allow TCP ports 80 and 443. After public HTTP works, configure a certificate for your hostname using your host's HTTPS feature or Certbot with Nginx. Check certificate renewal and the HTTP-to-HTTPS redirect.
6. Verify the result. Open the HTTPS address from outside the server. Confirm that it loads your group page and that the navigation and roster display correctly. To publish later edits, replace index.html and reload the page in your browser.