Institutional Repository of Vilnius University
Design and implementation of a data integration platform for heterogeneous sources /
Abstract
dc:descriptionThis thesis presents a web-based data integration platform that consolidates information from heterogeneous sources into unified datasets. Companies frequently have their data distributed and stored in incompatible systems like relational databases, CSVs, etc., where different schemas and formats are implemented. As a result, this fragmentation obstructs comprehensive analysis. To overcome such an issue, the platform extracts data from different sources, applies user-defined mappings for standardization, and then merges the records to resolve relationships. The platform provides a complete integration process that starts with users establishing connections to files and databases, selecting fields that correspond between the source schemas and the structure of the unified dataset, running Extract-Load-Transform cycles that retain the original data while producing standardized outputs, and finally, integrating results that are ready for further analysis. The notable features include automatic relationship detection through the matching of identifiers and a visual mapping editor. The evaluation reveals the platform's effectiveness in managing small- to medium-scale integration scenarios while remaining accessible to users without specialized technical expertise. Although currently limited to CSV and relational database sources, the architecture provides a foundation for future extensions, including additional data formats and automated schema matching.
Degree
thesis:*- Grantor dc:publisher
- Institutional Repository of Vilnius University
- Year dc:date
- 2026
Author and committee
dc:creator, dc:contributor.*- Author dc:creator
-
- Bublii, Kyrylo,
Subjects
dc:subject × 1Rights
dc:rights- Statement dc:rights
-
- info:eu-repo/semantics/openAccess
- Language dc:language
- eng
Identifiers
dc:identifier.*- Repository record dc:identifier
- https://repository.vu.lt/VU:ELABAETD277692727&prefLang=en_US