The aim of my thesis is to provide a collection of examples about document oriented MongoDB database using Node.js platform, specifically using the Mongoose program, for object-document mapping (ODM). The aim is met by analysis of Mongoose and Async module, which provides functions for more comprehensive asynchronous querying, needed for working with input/output to the MongoDB database in Node.js. The main merit of this thesis is (in the general sense) a demonstration of how to create a administration part of web application (backend) in Node.js, applying document oriented MongoDB database. The thesis discusses, in the theoretical part, about characteristics and significance of document oriented MongoDB database, about characteristics and architecture of Node.js platform employing untyped and multiplatform JavaScript language and about object document mapping (ODM) programs for Node.js on MongoDB. The practical part contains a collection of examples, where in the first chapter introduces an instalation and execution manual of necessary programs. The next chapter is dedicated to simple examples of Mongoose module and in the last chapter there are stated the complex examples of Mongoose and Async modules, which are the main merits of this thesis.

This work focuses on NoSQL databases, their use for analytical tasks and on comparison of NoSQL databases with relational and OLAP databases. The aim is to analyse the benefits of NoSQL databases and their use for analytical purposes. The first part presents the basic principles of Business Intelligence, Data Warehousing, and Big Data. The second part deals with the key features of relational and NoSQL databases. The last part of the thesis describes the properties of four basic types of NoSQL databases, analyses their advantages, disadvantages and areas of application. The end of this part in-cludes specific examples of the use of NoSQL databases, together with the reasons for the selection of those solutions.

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.