Empowering Applications with a Graph Database
The broader goal of creating an IT-Management Portal for Core-Customers is made possible by building a stable, flexible and performant foundation out of centralised data with a Graph Database.
Simon Bieri, 2019
Bachelor Thesis, lobsi.com
Betreuende Dozierende: Emanuele Laurenzi
Keywords: Graph, Database, Neo4j, APOC, SLA, IT-Management, SME, Portal, Cypher, Centralising
Lobsi.com is an IT-Service provider for SMEs and often operates behind the scenes. Therefore, customers don't always recognise the work and the value thereof. A customer portal showing information from four data sources should be created to enhance transparency. This project deals with creating a foundation for this portal.
Besides those four, a service level agreement management is urgently needed and forms a fifth source of data.
First of all, all data sources need to be analysed. Their current installation, software version, and finding a way to connect their data among each other is paramount. The preparations resulting of it included migrating installations, updating software versions and uniforming current data. To also include SLA information, a web-based CRUD-Application is to be developed.
The data of the prepared data sources and the web-application is then collected in a graph database, based on Neo4j with scheduled imports every night.
A web-based SLA manager has been developed. It satisfies the urgent need of a structured way to store SLAs and closes the information gap between Lobsi.com's management, service desk and administration.
The new graph database imports data from all five sources, connects them among each other as well as with the SLA data and makes it available in the local network for the customer portal as well as for other potential future use-cases.
Studiengang: Business Information Technology (Bachelor)
Fachbereich der Arbeit: Wirtschaftsinformatik & IT-Management