1. Homepage
  2. Programming
  3. DSCI 551 Foundations of Data Management - Project: Sample Database System

DSCI 551 Foundations of Data Management - Project: Sample Database System

Engage in a Conversation
USCDSCI 551Foundations of Data ManagementSample Database SystemMySQLMongoDB

DSCI 551 – Fall 2023 CourseNana.COM

Project Guideline CourseNana.COM

In this project, you are asked to design and implement a sample database system. Here are general requirements. CourseNana.COM

  • The system should support a data model, which can be relation (as in MySQL) or JSON (as in Firebase and MongoDB), or any other model of your choice. Users of the system will structure their data using the model provided by the system. CourseNana.COM

  • The system should have its own query language which should be different from existing query languages, including SQL, and queries provided by Firebase and MongoDB. It is ok that the language is like natural language, e.g., “find employees who are at least 25 years old”. CourseNana.COM

  • The query language should support projection (selecting a subset of rows), filtering (selecting rows), join (e.g., combining multiple data tables), grouping, aggregation, and ordering CourseNana.COM

  • Your system should not load the entire database into the memory and process queries and data modifications on the entire database. Instead, you should assume that the database may potentially handle a large amount of data that might not fit in the main memory CourseNana.COM

  • You should implement an interactive command line interface (similar to MySQL, MongoDB, sftp clients, etc.) for users to interact with the systems, issue commands, and get results. As an example, suppose your database is called MyDB, your interface may look like: CourseNana.COM

o MyDB > create table person(a int);
o MyDB>Tablecreated.
o MyDB > insert into ...
o MyDB > find employees who are at least 25 years old o MyDB>... CourseNana.COM

o MyDB > exit CourseNana.COM

  • You should show how to create a database using your system to store multiple real-world data CourseNana.COM

    sets, and how the queries and data modifications work on the data sets. CourseNana.COM

  • Your dataset should be some existing real-world dataset available on the Web. For example, You can form a project team of no more than 3 people. However, there are additional requirements if your project group has more than one person. CourseNana.COM

o If your team has two people, you need to design two database systems, one for storing relational database, the other for NoSQL data. The data set for NoSQL should be different from the ones used for relational. CourseNana.COM


o If your team has three people, you also need to design two database systems, one for relational, the other for NoSQL data; and use different datasets. In addition, you are expected to build a web application that demonstrates the functions of your database systems. Students in the past have used framework, like Flask, with success. CourseNana.COM

There is no restriction on programming languages that can be used for the project. The project will be done in phases.Midterm progress report (due 10/13, 5 points): tell us your progress so far and the challenges you encountered. CourseNana.COM

  • Demo (11/21, 5 points): Give live demo of your project. All project members should be present during the demo. Before demo, please prepare slides talking about your project design. The presentation will be about 5 minutes and the demo 10 minutes. Note we may also use part of 11/28 meeting for your project presentation. Note two hours of 11/28 class will be used for your comprehensive exam. CourseNana.COM

  • Final report (due 12/8, 10 points): the final report should be comprehensive, details your design and implementation. CourseNana.COM

  • Implementation (due 11/21, 70 points): note your project should be fully implemented before the demo. You should include in your final report a link to Google drive where you will upload your project codebase and documentations. Make sure you give access to your project folder. CourseNana.COM

  • Note proposal, midterm report, and final report will need to be uploaded to course web site (Blackboard for afternoon section, D2L for morning sections including DEN). Submission entries will be announced before the deadline is approaching.  CourseNana.COM

Get in Touch with Our Experts

Wechat WeChat
Whatsapp Whatsapp
USC代写,DSCI 551代写,Foundations of Data Management代写,Sample Database System代写,MySQL代写,MongoDB代写,USC代编,DSCI 551代编,Foundations of Data Management代编,Sample Database System代编,MySQL代编,MongoDB代编,USC代考,DSCI 551代考,Foundations of Data Management代考,Sample Database System代考,MySQL代考,MongoDB代考,USChelp,DSCI 551help,Foundations of Data Managementhelp,Sample Database Systemhelp,MySQLhelp,MongoDBhelp,USC作业代写,DSCI 551作业代写,Foundations of Data Management作业代写,Sample Database System作业代写,MySQL作业代写,MongoDB作业代写,USC编程代写,DSCI 551编程代写,Foundations of Data Management编程代写,Sample Database System编程代写,MySQL编程代写,MongoDB编程代写,USCprogramming help,DSCI 551programming help,Foundations of Data Managementprogramming help,Sample Database Systemprogramming help,MySQLprogramming help,MongoDBprogramming help,USCassignment help,DSCI 551assignment help,Foundations of Data Managementassignment help,Sample Database Systemassignment help,MySQLassignment help,MongoDBassignment help,USCsolution,DSCI 551solution,Foundations of Data Managementsolution,Sample Database Systemsolution,MySQLsolution,MongoDBsolution,