MET CS779 Term Project
MET CS779
Term Project
Jack Polnar
Update 1/17/2021
Purpose of the Project
CS779 brushes the surface of advanced database management.
What would you like to learn in this class?
Select a single topic of your choice.
Project can be:
Work related hands on Implementation
A proof of concept with a research paper
A research paper with approval
Project is worth 25% of the grade.
Opportunities to explore areas of interest to students and their employers.
An opportunity to do a major project with help from your faculty.
Lots of good learning from each other.
An opportunity to prepare a formal research report and obtain feedback from your faculty
An opportunity to prepare and present a summary of your project to your faculty and fellow students, and obtain feedback
Intellectual diversity – coverage of additional data management areas.
Purpose of the Project
3
Term Project Requirements
Complete a significant term project of your own design
Include advanced database technology or a challenging real problem
Hands on component
Present project to the class as slides and/or demonstrations, and to your facilitator and me as a report and source code as appropriate.
What makes a good project?
The primary goal in this class is learning. A good project helps you and your classmates learn useful database and data management skills.
Should be at the advanced Master’s (700) level.
Should include substantial original student work.
Involve implementation and experimentation.
Simply reporting on an advanced features in a DBMS is not sufficient.
Project Examples
A data warehouse project with a data set which has been identified, dimensional schema design ETL to load the data and queries to select the data.
Performance tuning exploration (query re-write, query plan analysis, indexing, re-design)
An exploration of integration using XML , JSON – various API implementations
Distributed or cloud based database design and implementation proof of concept
Example Big Data Database Topics
Design and implementation of a big data database.
Deep dive into noSQL DB platform of choice (i.e. Spark, DynamoDB, MongoDB, Hadoop, Elasticsearch)
Data integration, and or analysis using SQL, python, Java – or whatever you would like to learn!
Integration through Kafka or other streaming framework.
Add Visualization tool on top of your stack (i.e. Tableau)
Scraping a web site and loading data into noSQL with analysis.
Query performance comparison between NoSQL and relational DBMS.
Replication between relational and NoSQL databases
Deep dive into graph databases with social media examples.
Implementation of the integration of Hadoop or Spark with Oracle or another relational RDBMS and analysis of the tradeoffs.
Spark deep dive
Graph Database implementation – i.e. Neo4J
Term Project Deliverables
Project Updates:
is a proposal.
is your finalized proposal, term project plan and sample references.
is a progress update.
Updates are graded as 1 – On Track or 0 – off Track. If you receive a 0 it’s an indication that you are off track and you need to revise and resubmit your term project update.
Final Term Project Deliverables
In class term project presentation to your faculty and classmates (plan for about 40+ minutes).
Hand in you term project presentation slides
Term Project report
Term Project Update #1
This deliverable is a short conceptual-level description of what you are thinking of doing for your term project. The purpose of this deliverable is to provide your facilitator and professor an opportunity to guide you as you define your term project. You are not committed to what you propose here, but it is best if you define your term project early in the course.
Some questions to consider:
What is the advanced database area you are focusing on related to this course?
What is the proof of concept component in your term project?
What are some of the goals that you plan to learn in this project?
What skills are you bringing from other courses, and what is the new element that you are learning in this class that’s related to advanced database management?
What data are you looking to use specifically?
The Term Project Update is graded as 1 – On Track or 0 – off Track. If you receive a 0 it’s an indication that you are off track and you need to revise and resubmit your term project update.
Term Project Update #2
This term project deliverable should finalize your proposal by updating what you have submitted in the first term project update. Within the Update #2 include the following:
Your finalized project proposal answering questions outlined in term project update #1
Your project plan which should outline various parts of your term project and when you plan on working on them.
An outline and listing of at least three potential sources for the term project report. For each source in no more then two sentences explain how this source is helpful to your project research.
The purpose of this deliverable is to provide your facilitator and professor with an opportunity to guide you midway in your term project.
The Term Project Update is graded as 1 – On Track or 0 – off Track. If you receive a 0 it’s an indication that you are off track and you need to revise and resubmit your term project update. At this stage you want to make sure you are on track before doing any more work on your term project.
Optional Term Project Update #3
This term project deliverable may include an update of your project plan or any other portions of your term project you would like feedback.
The purpose of this deliverable is to provide your facilitator and professor with an opportunity to guide you as you begin to wrap up your term project research and implementation and begin to prepare your presentation and/or report.
The Term Project Update is graded as 1 – On Track or 0 – off Track.
I don’t know where to start…
First place to look is to review the outline of the course, does any topic jump out to you?
Do you have something interesting at work that is related, or something that you yourself have been curious in the past and never had the time to do it?
Have you learned Analytics, Python, R, Java in previous classes and want to apply it here extending your previous project?
Evaluation Criteria for Term Project
Criterion D C B A Letter Grade %
Technical quality, depth and relevance (35%) Insufficient coverage,
Insufficient complexity, Insufficient relevance Some coverage, explanation, and or examples, showing low relevance to selected topics Good coverage, explanation, and or examples, showing relevance to selected topics Exceptional coverage, explanation, and or examples, showing exceptional relevance to selected topics
Clarity and quality in expression of your ideas (30%) Mostly disorganized, hard to understand Somewhat clear, somewhat organized Clear and organized, non-repetitive Exceptionally clear, organized, persuasive
Understanding and innovative quality (35%) Minor understanding of topic evidenced Satisfactory understanding of topic evidenced, somewhat trivial approach Good understanding of topic throughout with innovative parts throughout Exceptional understanding of the topic and inter-relationships; demonstrating highly innovative approach
Overall Project Grade:
Key term project success factors
Defining your term project as early as possible and getting started on your plan.
Submitting often and working closely with your facilitator and professor.
Planning incremental gradable milestone deliverables, particularly near the end of the term, so that if something goes wrong you can still deliver a gradable project on time.
/docProps/thumbnail.jpeg