This project investigates the feasibility of migrating from an SQL database utilizing complex stored procedures to a NoSQL database, specifically focusing on the Saab application BAAS. The motivation behind the investigation is that the stored procedures are complex to maintain. The aim is to determine whether such a migration can simplify the database structure while maintaining acceptable performance levels. The study involves developing a proof of concept by translating a frequently used SQL stored procedure into application-sided logic implemented with MongoDB, a document-oriented NoSQL database. Performance tests comparing execution times of SQL stored procedures and the NoSQL alternative showed that while SQL stored procedures are faster due to primarily pre-compilation and optimized indexing, the NoSQL solution achieves acceptable execution times and offers enhanced maintainability and flexibility. This report provides a detailed evaluation of the potential benefits and drawbacks of migrating to NoSQL, emphasizing the importance of optimizing indexing strategies to close the performance gap. The findings suggest that, despite the time investment required for migration, the reduction in complexity and improved maintainability may justify the transition for organizations facing similar challenges.
| Identifer | oai:union.ndltd.org:UPSALLA1/oai:DiVA.org:lnu-130559 |
| Date | January 2024 |
| Creators | Najafi Zadeh, Sam, Hellgren, Viktor |
| Publisher | Linnéuniversitetet, Institutionen för datavetenskap och medieteknik (DM) |
| Source Sets | DiVA Archive at Upsalla University |
| Language | English |
| Detected Language | English |
| Type | Student thesis, info:eu-repo/semantics/bachelorThesis, text |
| Format | application/pdf |
| Rights | info:eu-repo/semantics/openAccess |
Page generated in 0.0023 seconds