diplomska naloga
Mladen Babić (Author), Viljan Mahnič (Mentor)

Abstract

Podatkovno skladišče za spremljanje poslovanja s transakcijskimi računi

Keywords

podatkovna skladišča;področno podatkovno skladišče;dimenzijski model;sistem ETL;transakcijski računi;računalništvo;univerzitetni študij;diplomske naloge;

Data

Language: Slovenian
Year of publishing:
Typology: 2.11 - Undergraduate Thesis
Organization: UL FRI - Faculty of Computer and Information Science
Publisher: [M. Babić]
UDC: 004.65(043.2)
COBISS: 6736468 Link will open in a new window
Views: 109
Downloads: 16
Average score: 0 (0 votes)
Metadata: JSON JSON-RDF JSON-LD TURTLE N-TRIPLES XML RDFA MICRODATA DC-XML DC-RDF RDF

Other data

Secondary language: English
Secondary title: [Data warehouse for bank transaction accounts business analysis]
Secondary abstract: In this work we present implementation of a data warehouse prototype for bank transaction accounts business analysis. As an introduction to extensive data warehousing area we provide some theoretical bases, which include basic terminology, a description of essential elements of data warehouse as well as a description of development methodology we use. We proceed with designing dimensional models of the data warehouse. We design three dimensional data models, which represent bank transaction accounts business activities. We also show integration of designed models into complete bank product analysis solution. When designing models, we use literature recommendations for designing heterogeneous products star schemas, transaction star schemas and periodic snapshot star schemas. By using these recommendations, we design dimensional models, which enable transaction accounts business analysis on different grain levels. The next step in the process of making the data mart is carrying out the ETL system, part of the system that is responsible for refreshing the data warehouse. We develop ETL processes, module for automatic execution of the ETL processes, and module for ETL process error handling. At the end of our work we provide some use cases of the data warehouse for bank transaction accounts. Possible upgrades and guidelines for the future developments of the data warehouse for bank transaction accounts are given in the conclusion.
Secondary keywords: data warehouses;data mart;dimensional model;ETL system;bank transaction accounts;computer science;diploma;
File type: application/pdf
Type (COBISS): Undergraduate thesis
Thesis comment: Univerza v Ljubljani, Fakulteta za računalništvo in informatiko
Pages: 101 str.
ID: 23809241