This project is geared towards giving students practice in designing, implementing, demonstrating, and documenting a Data Warehouse that consolidates data and supports efficient data-driven decision-making.
- Team Size: 2-3 members
- Group Coordinator: Omoremi
- Group Members: Omoremi, Yara and Inioluwa
The goal of this project is to implement a Data Warehouse backend using a NoSQL database system. We recommend using MongoDB, but your group may choose other NoSQL databases. The project should be completed in groups, with each group member actively participating in all project tasks.
Each group member should take primary responsibility for one of the following topics:
- Using a NoSQL database system to provide an implementation of the Data Warehouse system.
It is acceptable to make assumptions about the application, provided that:
- The assumptions are explicitly stated in the final report.
- The assumptions are reasonable.
A final report should be submitted for grading at the end of the term. The report should be formatted in a reasonable manner and include the following sections:
- System Overview:
- Identify the various types of users, administrators, etc., who will be accessing the system in various ways.
- Assumptions:
- List the assumptions made about the system.
- Data Description:
- Describe the data that will be maintained in the system.
- Data Loading Process:
- Describe the process of loading the data, including any required data cleaning and transformation.
- System Design:
- Describe the design of the system.
- Data Warehouse Queries and Front-ends:
- Describe the queries and front-ends required for the warehouse.
- User Scenarios:
- Provide example scenarios of how various types of users will interact with the system.
- Implementation Details:
- Describe the implementation of the data warehouse system using the chosen NoSQL platform.
- NoSQL Implementations:
- Explain the advantages and disadvantages of the chosen NoSQL approach.
- Testing:
- Describe the testing process for the system.
The project requires a working implementation of the system to be built, tested, and demonstrated. All group members should attend the presentation and be prepared to explain and demonstrate the aspects of the project for which they were responsible.
- Final Report: Due during class on the "Project Due" date specified in the class schedule.
- Source Code: Should be submitted along with the final report.
- Presentation Slides: Should be submitted after the presentation, by midnight of the presentation day or Friday of the presentation week.
We welcome contributions to this project! To contribute to this project, please follow the steps outlined in the CONTRIBUTE.md file. It provides a detailed step-by-step guide for contributing to the project. If you prefer a simpler approach, you can follow the steps mentioned above.
- Copy the project URL for clone
https://github.com/innextinit/DataWarehousing.git. - Clone the repository to your local machine:
git clone https://github.com/innextinit/DataWarehousing.git. - Go inside the cloned repository:
cd DataWarehousing. - Create a new branch for your changes:
git checkout -b your-branch-name. - Make the necessary changes to the project files.
- Stage the changes made to the project files:
git add .orgit add filename1 filename3. - Commit your changes:
git commit -m "Add your commit message here". - Push your changes to your forked repository:
git push origin your-branch-name. - Open a pull request from your branch to the main repository.
- Provide a detailed description of your changes in the pull request.
- Follow the pull request review process and address any feedback if necessary.
- Once your pull request is approved, your changes will be merged into the main repository.
For more information on creating a branch and opening a pull request, please refer to the following references:
- Creating a Branch for an Issue
- Creating a Pull Request Template for Your Repository
- Conventional Commit Messages
We appreciate your contributions and thank you for your interest in this project!