University of Twente Student Theses


Choosing a Suitable Query Engine for Providing Observability and Accessibility for Dynamic Reporting of Business Data

Ulici, Diana Laura (2021) Choosing a Suitable Query Engine for Providing Observability and Accessibility for Dynamic Reporting of Business Data.

[img] PDF
Abstract:Nowadays no one can imagine a thriving business without a proper data management and governance system for its applications data in place, in order to support the internal and external operations. Over the years, databases and their related DBMS (Database Management System) have grown in size, capability and performance, together with the development of cutting edge technologies and large scale business needs. Databases have become more fragmented and shifted towards being stored in the cloud, due to microservices and high tech advancements. Choosing the suitable database suite is no easy task for the database specialists team, as the choice needs to take into account a multitude of criteria based on the organization’s requirements, input from the business processes and the workflow of data, as well as the concerns regarding scalability, recovery and security. Furthermore, choosing a database suite is not sufficient anymore, as databases alone are not enough to make the information shareable and available everywhere it is needed. For this purpose, there should be a data management platform in place, that can handle all the steps from gathering, processing and making the information accessible. Therefore, a first step would be to analyze the structure of the information that will be held in the database, considering all the broad aspects of the business data, and then trying to shift towards one of the existing solutions available on the market, while keeping in mind the goals of the organization. When it comes to an integration platform vendor like eMagiz, storing the data that flows through the system comes as an extra feature that can prove to give a strategic advantage in the business landscape. This comes of course with its challenges related to what kind of data can be stored, for what period of time, security concerns and so on. For this Master Thesis, eMagiz, a Dutch IpaaS supplier, is the collaborative organization that provides the context for the developed prototype to be implemented and further validated. The prototype is mainly based on ElasticSearch as the chosen database storage option, and GraphQL as the querying engine. This solution aims to give the possibility of storing business data for a later use, while GraphQL provides the option of finding related data easily, while being able to visualize the data schema of the information stored.
Item Type:Essay (Master)
eMagiz, Enschede, Netherlands
Faculty:EEMCS: Electrical Engineering, Mathematics and Computer Science
Subject:54 computer science, 85 business administration, organizational science
Programme:Business Information Technology MSc (60025)
Link to this item:
Export this item as:BibTeX
HTML Citation
Reference Manager


Repository Staff Only: item control page