The project in five facts.
Challenge, approach and results.
The diploma thesis analysed the performance of two popular databases, PostgreSQL and Redis, in the context of artificial intelligence and data processing. The aim of the research was to determine which database is more suitable for specific tasks such as fast data filtering, training artificial intelligence models, and stability and reliability of results. Four hypotheses were formulated and tested through experimental comparison of query speeds, model training times, and result stability.
Solution and method
The diploma thesis analysed the performance of two popular databases, PostgreSQL and Redis, in the context of artificial intelligence and data processing.
Results
The aim of the research was to determine which database is more suitable for specific tasks such as fast data filtering, training artificial intelligence models, and stability and reliability of results. Four hypotheses were formulated and tested through experimental comparison of query speeds, model training times, and result stability. The results confirmed that Redis is very fast for simple queries such as lookup operations, thanks to its architecture based on in-memory data storage.
However, it was not faster for complex filtering queries, as claimed by hypothesis 2. PostgreSQL demonstrated better performance when processing complex queries, where execution time was significantly shorter due to advanced optimisation and use of indices. This shows that PostgreSQL is more suitable for scenarios requiring filtering of large amounts of data with complex conditions.
For training artificial intelligence models, Redis showed an advantage with simpler models such as Ridge regression, as training speed slightly exceeded PostgreSQL. For more complex models such as random forest and gradient boosting, PostgreSQL and Redis proved to be equivalent, which contradicts hypothesis 4 about greater PostgreSQL stability. The research also showed that PostgreSQL enjoys greater community support and higher demand in the labour market, whilst Redis leads in open-source projects on GitHub.
Based on these findings, PostgreSQL is recommended for applications requiring extensive data processing, and Redis for applications where speed is crucial. In addition to these key findings, the impact of database choice on overall application architecture and scalability was examined. It was found that PostgreSQL offers better scaling options in environments where data requirements change dynamically, whilst Redis enables easier integration into real-time systems due to its exceptional speed.
These additional insights enable more informed decision-making when selecting a database according to specific project needs and will contribute to greater efficiency and reliability of final solutions.
Module, programme and stories.
Your diploma project for a real company.
A diploma thesis at Academia solves a challenge from a company – often the one where you do your 800 hours of placement. Read about the Programsko inženirstvo module or book a consultation.