MarketSquare / MarketSquare/robotframework-dashboard
[Improvement] Investigate benefits of database restructure
Nobody has claimed this yet.
- Dominant language
- HTML
- Stars
- 87
- Forks
- 21
- Avg merge
- 14h 55m
- Merged PRs (30d)
- 13
Description
## Summary
Investigate the potential benefits of transitioning from the current flat table structure to a relational database model, and implement changes if proven valuable.
## Problem
The current flat table setup lacks relationships between data entities, which can lead to data redundancy, limited flexibility, and more complex data management as the system grows.
## Proposed Solution
Conduct an investigation that:
- Evaluates the limitations of the current flat table structure
- Explores relational database design (e.g., normalized tables, relationships, keys)
- Identifies potential performance, scalability, and maintainability improvements
- Assesses migration complexity and risks
- Provides a recommendation on whether to proceed with implementation
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files, tests, or entry points are named. Start by mapping the current flat table structure and its data entities, then compare it with normalized relational designs, relationships, and keys. Document performance, scalability, maintainability, migration risks, and a recommendation on whether implementation should proceed.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100