| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:PODATKOVNO SKLADIŠČE ZA IZOBRAŽEVALNO USTANOVO
Authors:ID Ofentavšek, Ksenija (Author)
ID Rizman Žalik, Krista (Mentor) More about this mentor... New window
Files:.pdf UNI_Ofentavsek_Ksenija_2013.pdf (1,76 MB)
MD5: A30F096D167B280EC7A10F879E9E2780
PID: 20.500.12556/dkum/87368c5f-e51c-49e0-aadc-7f494d42eb21
 
Language:Slovenian
Work type:Undergraduate thesis
Typology:2.11 - Undergraduate Thesis
Organization:FNM - Faculty of Natural Sciences and Mathematics
Abstract:Diplomsko delo opisuje zgradbo in uporabo podatkovnih skladišč. Podrobneje je opisana arhitektura podatkovnih skladišč. Jedro podatkovnih skladišč je OLAP kocka, ki jo modeliramo s snežinkasto in zvezdno podatkovno shemo. Prikazana je izdelava vrtilnih tabel v programu Excel. V diplomskem delu je predstavljen izdelan model podatkovnega skladišča za izobraževalno ustanovo in bazo v Accessu in poročila, izdelana s pomočjo vrtilnih tabel.
Keywords:podatkovno skladišče, proces ETL, kocka OLAP, zvezdna shema, snežinkasta shema, arhitektura podatkovnih skladišč
Place of publishing:Maribor
Publisher:[K. Ofentavšek]
Year of publishing:2013
PID:20.500.12556/DKUM-39573 New window
UDC:004(043.2)
COBISS.SI-ID:19687944 New window
NUK URN:URN:SI:UM:DK:WZX6UENE
Publication date in DKUM:15.02.2013
Views:2182
Downloads:180
Metadata:XML DC-XML DC-RDF
Categories:FNM
:
Copy citation
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share



Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Secondary language

Language:English
Title:DATA WAREHOUSE FOR EDUCATIONAL INSTITUTION
Abstract:This thesis describes composition of data warehouse and its usage. Architecture of data warehouse is described in details. Core of data warehouse is OLAP cube that can be realized with snowflake or star scheme. There is shown how pivot tables in Excel are made. Thesis shows a model of data warehouse done for educational institution and data in Access and reports made with pivot tables.
Keywords:data warehouse, process ETL, cube OLAP, star scheme, snowflake data scheme, architecture of data warehous


Comments

Leave comment

You must log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica