OLAP analiza v šolskem informacijskem sistemu

diplomska naloga visokošolskega strokovnega študijskega programa

Žiga Jelen (Author), Tatjana Welzer-Družovec (Mentor)

Abstract

Vsak dan se srečujemo z ogromno količino podatkov. Samo shranjevanje podatkov pa za uporabnike ne predstavlja nobene dodane vrednosti. Te podatke je potrebno analizirati in spraviti v smiselna poročila. Tematika diplomske naloge je uvajanje OLAP tehnologije v šolski informacijski sistem. Ravno ta tehnologija pa nam omogoča analizirati podatke in iz njih pridobiti dodatno vrednost. S tem bomo predstavili sam postopek modeliranja podatkovnega skladišča in postavitev tega na strežniku. Na primerih bomo predstavili ETL procese in težave, ki nastanejo pri teh transformacijah. Predstavili bomo tudi gradnjo OLAP kocke in njeno uporabo v MS Excelu. Cilj diplomske naloge je na resničnem projektu predstaviti proces uvajanja OLAP-a.

Keywords

informatika;podatki;baze podatkov;rudarjenje podatkov;upravljanje s podatki;informacijski sistemi;podatkovna skladišča;dimenzijsko modeliranje;

Data

Language:	Slovenian
Year of publishing:	2009
Source:	Maribor
Typology:	2.11 - Undergraduate Thesis
Organization:	UM FERI - Faculty of Electrical Engineering and Computer Science
Publisher:	[Ž. Jelen]
UDC:	004.62/.65:37(043.2)
COBISS:	13713174
Views:	2762
Downloads:	310
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary title:	OLAP analysis in the school information system
Secondary abstract:	We face a huge amount of data every day. Only storing that data does not create any added value for the users. It is necessary to analyze this data and convert it into meaningful reports. The theme of this diploma work is the introduction of OLAP technology in to a schools information system. This technology enables us to analyze the data and gain additional value from it. Using this procedure we will demonstrate the process of data warehouse modeling and the installation of said warehouse on a server. We will use examples to show ETL processes and problems that may arise with these transformations. We will also show the construction of a OLAP cube and its use with MS Excel. Our goal with this diploma work is to demonstrate the process of OLAP introduction on a real project.
Secondary keywords:	database;data mining;dimensional modeling;data warehouse;ETL;
URN:	URN:SI:UM:
Type (COBISS):	Undergraduate thesis
Thesis comment:	Univ. v Mariboru, Fak. za elektrotehniko, računalništvo in informatiko
Pages:	XII, 89 str.
Keywords (UDC):	science and knowledge;organization;computer science;information;documentation;librarianship;institutions;publications;znanost in znanje;organizacije;informacije;dokumentacija;bibliotekarstvo;institucije;publikacije;prolegomena;fundamentals of knowledge and culture;propaedeutics;prolegomena;splošne osnove znanosti in kulture;computer science and technology;computing;data processing;računalniška znanost in tehnologija;računalništvo;obdelava podatkov;data;podatki;data handling;ravnanje s podatki;social sciences;družbene vede;education;vzgoja in izobraževanje;šolstvo;pouk;
ID:	987926