Week 10

 Technology Requirements and Decision Matrix

  • August 02, 2025

Author: Sagar Chaudhary

Title: Decision Matrix

  • Conducted a decision matrix of the technology and finalised the Language and Database for our project based on weighted criteria and team discussions.


5.1.1 Database Decision Matrix

CriteriaWeightMySQLPostgreSQLMongoDBSQLite
Real-Time Capability3(18)(18)(21)(15)
Scalability4(28)(32)(36)(20)
Performance5(40)(42)(35)(25)
Flexibility3(21)(24)(27)(18)
Integration2(12)(14)(15)(10)
Cost2(14)(14)(12)(18)
Learning Curve2(14)(13)(12)(16)
Community & Documentation2(16)(18)(17)(14)
Security Features3(24)(27)(23)(18)
Total187202198154
Rank3rd1st2nd4th

Final Choice: PostgreSQL — chosen for its performance, scalability, strong security, and compatibility with analytical workloads.


5.1.2 Programming Language Decision Matrix

CriteriaWeightPythonJavaC#JavaScript
Ease of Use4(36)(28)(32)(30)
Real-Time Capability3(24)(27)(25)(27)
Community Support4(38)(34)(33)(36)
Scalability3(27)(30)(29)(28)
Performance4(32)(36)(34)(33)
Learning Curve2(18)(14)(16)(18)
Cost2(18)(17)(17)(18)
Hosting Ease2(16)(15)(17)(18)
Availability of Libraries4(38)(34)(33)(36)
Project Setup & Maintenance2(18)(16)(17)(18)
Total265251253262
Rank1st4th3rd2nd

Final Choice: Python — chosen for ease of use, strong library support, community resources, and rapid development capabilities.


Survey Findings

Based on internal survey results from the development team and stakeholders (12 responses), Python and PostgreSQL scored the highest overall satisfaction ratings for our project’s goals.

Comments

Popular posts from this blog

Week 3 Activity

Week-5 Report (Food NextDoor)

Week 5 Report