MongoDB based ERP

The company pier4all AG is developing an Enterprise Resource Planning (ERP) system for SMEs in collaboration with the FHNW and the HSLU. The project will deliver an ERP solution backed by MongoDB. This thesis focuses on the modeling, creating and querying data for HR processes.

Lang, Florian, 2021

Type of Thesis Bachelor Thesis
Client Institute for Information Systems, HSW FHNW
Supervisor Hanne, Thomas
Views: 41 - Downloads: 4
ERP systems are a fundamental part of many companies; one property of such systems is a reliance on a Relational Database Management System (RDBMS). Relational databases offer many advantages, which are well researched and documented but also innately possess a rigid architecture. This limitation leads to an ERP system that is inflexible and expensive to modify. Alternatives to relational databases have only seen successful adoption in non-ERP application areas so far.
The work first focused on understanding the goals of the project and the technology vision. This included acquiring the necessary knowledge through reviewing the literature and learning about NoSQL databases. After that, the practical work was structured incrementally. The workload consisted of BPMN modeling, creating an Entity Relationship (ER) diagram and a JavaScript Object Notation (JSON) data model, programming the data generator, defining the queries in the MongoDB Query Engine, measuring and improving query performance, and optimizing the JSON data schemas.
The developed artifacts of this thesis can support the enablerr project with the HR data model, improved event schemas and the evaluation of query performance. They include the generator which can create, upload, export, and measure data with several options to fit specific research scenario needs. The generator can be modified and expanded upon to include more JSON schemas, to broaden its application area. Additionally, query performance analysis results might provide insight into effective data models which can overcome some of the shortcomings of the document-based Database Management System (DBMS) MongoDB.
Studyprogram: Business Information Technology (Bachelor)
Keywords MongoDB, NoSQL, Queries, Query, Generator, JavaScript, Node.js, Mongoose, Aggregation
Confidentiality: öffentlich
Type of Thesis
Bachelor Thesis
Client
Institute for Information Systems, HSW FHNW, Olten
Authors
Lang, Florian
Supervisor
Hanne, Thomas
Publication Year
2021
Thesis Language
English
Confidentiality
Public
Studyprogram
Business Information Technology (Bachelor)
Location
Basel
Keywords
MongoDB, NoSQL, Queries, Query, Generator, JavaScript, Node.js, Mongoose, Aggregation