Your browser does not allow JavaScript!
JavaScript is necessary for the proper functioning of this website. Please enable JavaScript or use a modern browser.
|
|
SLO
|
ENG
|
Cookies and privacy
DKUM
EPF - Faculty of Business and Economics
FE - Faculty of Energy Technology
FERI - Faculty of Electrical Engineering and Computer Science
FF - Faculty of Arts
FGPA - Faculty of Civil Engineering, Transportation Engineering and Architecture
FKBV - Faculty of Agriculture and Life Sciences
FKKT - Faculty of Chemistry and Chemical Engineering
FL - Faculty of Logistic
FNM - Faculty of Natural Sciences and Mathematics
FOV - Faculty of Organizational Sciences in Kranj
FS - Faculty of Mechanical Engineering
FT - Faculty of Tourism
FVV - Faculty of Criminal Justice and Security
FZV - Faculty of Health Sciences
MF - Faculty of Medicine
PEF - Faculty of Education
PF - Faculty of Law
UKM - University of Maribor Library
UM - University of Maribor
UZUM - University of Maribor Press
COBISS
Faculty of Business and Economic, Maribor
Faculty of Agriculture and Life Sciences, Maribor
Faculty of Logistics, Celje, Krško
Faculty of Organizational Sciences, Kranj
Faculty of Criminal Justice and Security, Ljubljana
Faculty of Health Sciences
Library of Technical Faculties, Maribor
Faculty of Medicine, Maribor
Miklošič Library FPNM, Maribor
Faculty of Law, Maribor
University of Maribor Library
Bigger font
|
Smaller font
Introduction
Search
Browsing
Upload document
Statistics
Login
First page
>
Show document
Show document
Title:
PRIMERJAVA ARHITEKTUR PODATKOVNEGA SKLADIŠČENJA
Authors:
ID
Brmež, Simon
(
Author
)
ID
Leskovar, Robert
(
Mentor
)
More about this mentor...
Files:
MAG_Brmez_Simon_2011.pdf
(2,16 MB)
MD5: 5259CCB71AD0639FDE2B4A661FA8C8F1
PID:
20.500.12556/dkum/777f596f-912a-47cf-b0da-c1648b08a390
Language:
Slovenian
Work type:
Master's thesis
Organization:
FOV - Faculty of Organizational Sciences in Kranj
Abstract:
V raziskavi smo primerjali arhitekture, ki so primerne za podatkovno skladiščenje operaterja mobilne telefonije. Upoštevali smo realne količine podatkov in njihovo vsebino. Izdelali smo tri primerljive prototipne rešitve na treh arhitekturah podatkovnega skladiščenja: zvezdna shema, snežinkasta shema in OLAP-kocka. Vse prototipne rešitve smo implementirali na istem podatkovnem strežniku, ki je uporabljal sistem za upravljanje baze podatkov Oracle 10g. Prototipne rešitve smo kvantitativno primerjali z merjenjem časov izvajanja poizvedb. Med primerjalnim testiranjem prototipnih rešitev smo z analizo izvajalnih načrtov in interpretacijo doseženih časov izvajanj poizvedb prikazali prednosti in slabosti izbora posamezne arhitekture podatkovnega skladiščenja. Raziskava je osvetlila problematiko izbora arhitekture podatkovnega skladiščenja in je uporabna v konkretnem primeru operaterja mobilne telefonije pri odločanju o razvoju informacijskega sistema. Z vidika odzivnosti sistema in možnosti širitve je eksperiment pokazal, da sta za obravnavano problematiko bolj primerni arhitekturi OLAP-kocke in relacijske zvezdne sheme ter manj snežinkasta shema.
Keywords:
podatkovno skladišče
,
OLAP
,
podatkovno modeliranje
Place of publishing:
Maribor
Year of publishing:
2011
PID:
20.500.12556/DKUM-18203
COBISS.SI-ID:
6906899
NUK URN:
URN:SI:UM:DK:VSKZYISS
Publication date in DKUM:
30.08.2011
Views:
2216
Downloads:
241
Metadata:
Categories:
FOV
Cite this work
Plain text
BibTeX
EndNote XML
EndNote/Refer
RIS
ABNT
ACM Ref
AMA
APA
Chicago 17th Author-Date
Harvard
IEEE
ISO 690
MLA
Vancouver
:
Copy citation
Average score:
(0 votes)
Your score:
Voting is allowed only for
logged in
users.
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:
COMPARISON OF DATA WAREHOUSING ARCHITECTURES
Abstract:
This research compared data warehousing architectures suitable for operators of mobile telecommunications. Tests included near real volume and content of source data from actual business environment. We built three comparable prototype solutions on three basic data warehousing architectures: a star schema, a snowflake schema and an OLAP cube. All prototype solutions were built on the same data server with underlying Oracle 10g Relational Database Management System. Prototype solutions were compared by quantitative measurement of query execution times for particular architectures. During comparative testing of prototype solutions, we demonstrated the benefits and weaknesses of particular data warehousing architectures by analyzing query execution times and interpreting achieved query execution times. The research gave us deep insights into the problems of tested data warehousing architectures. The research findings can be used in decision-making on future development of information systems. Results of the experiments indicate that the system performance and growth possibilities of the OLAP cube and relational star schema are more acceptable. The relational snowflake schema gave less suitable results.
Keywords:
data warehouse
,
OLAP
,
data modeling
Comments
Leave comment
You must
log in
to leave a comment.
Comments (0)
0 - 0 / 0
There are no comments!
Back
