⭐ Mark the project with a star.
👀 Watch the project for receive news.
🌐 Access my personal website: thiago-tjas.com
🇧🇷 Acesse a versão em Português do Brasil.
Project to evaluate the performance of databases in the Data Architecture postgraduate discipline "Relational and Non-Relational Databases" at Pontifical Catholic University of Minas Gerais (PUC Minas).
Pontifical Catholic University of Minas Gerais (PUC Minas)
Continuing Education Directorate (IEC)
Postgraduation in Data Architecture (AD03T1, 1/2024)
Relational and Non-Relational Databases
Evaluative Activity 03 - Database Project
Nicole Tavares
Thiago Jorge Almeida dos Santos
The purpose of this activity is to allow students to apply data concepts in a distributed database environment. They must design a system that is scalable and efficiently partitioned to handle a large volume of data.
- Imagine you are designing an inventory management system for a supermarket chain that has branches in different cities.
- Each branch has a large volume of products in its stock;
- The system needs to be able to handle millions of product records;
- Stock query and inventory updates must be quick and efficient;
- System scalability is essential as new branches may be added in the future.
- Design the data partitioning strategy, consider aspects such as horizontal, vertical or fragmentation partitioning.
- Justify your choices based on scalability and performance requirements.
- The group may choose a different approach, but must present solid arguments for their decisions.
- Carry out a simulation of the implementation of the idealized partitioning strategy using freely chosen tools.
- Participants must generate a simulated data set to represent products in various branches.
- Conduct performance tests to evaluate the effectiveness of your partitioning strategy.
- Include inventory query scenarios, inventory updates and addition of new branches.
- Submit a report describing your approach, performance test results, and any recommended adjustments.
Thiago Jorge Almeida dos Santos, project author and maintainer.
Nicole Tavares, project maintainer.
If our work has been useful to you, we kindly ask you to cite it in one of the following formats:
- Santos, T.J.A. & Tavares, N. Data Strategy with MongoDB: case study on performance for data architecture strategies. Pontifical Catholic University of Minas Gerais, Postgraduation in Data Architecture, evaluative activity, GitHub repository, 2024. Retrieved June 2nd, 2024, from https://github.com/tjas/postgrad-ad03t1-nsqol-databaseproject
- Santos, T.J.A. & Tavares, N. (2024) Data Strategy with MongoDB: case study on performance for data architecture strategies. Pontifical Catholic University of Minas Gerais, Postgraduation in Data Architecture, evaluative activity, GitHub repository. Retrieved June 2nd, 2024, from https://github.com/tjas/postgrad-ad03t1-nsqol-databaseproject
- © 2024 Thiago Jorge Almeida dos Santos and Nicole Tavares. Code distributed under MIT License.