Večparameterska primerjalna analiza implementacij podatkovnih skladišč za potrebe migracije podatkovne baze v MS Accessu v podatkovno skladišče

Abstract

Keywords

Data

Language:	Slovenian
Year of publishing:	2014
Typology:	2.09 - Master's Thesis
Organization:	FIŠ - Faculty of Information Studies
Publisher:	[N. Klenovšek]
UDC:	004.65(043.2)
COBISS:	2048322579
Views:	0
Downloads:	0
Average score:	0 (0 votes)
Metadata:

Other data

Secondary language:	English
Secondary abstract:	In the introductory part of the research we have presented and defined the concept of a data warehouse and examined the six databases which are most frequently used for the purpose of data warehousing: MySQL, PostgreSQL, MongoDB, MS SQL, Oracle and DB2. We have migrated a source database in MS Access into data warehouses using databases mentioned above. We have examined the criteria that influence the selection of a data warehouse for a small company, and based on that formed a criteria tree. With the decision support system DEXi, we have performed a multi-attribute comparative analysis of data warehouses and an additional analysis with the VREDANA tool. We have performed a SWOT analysis for the best scored data warehouse. We have concluded that MySQL best meets the criteria, as scored highest in final evaluation, followed by PostgreSQL, DB2, MongoDB, MS SQL and Oracle.
Secondary keywords:	data warehouse;multi-attribute decision analysis;MySQL;PostgreSQL;MongoDB;MS SQL;Oracle;DB2;
Type (COBISS):	Master's thesis/paper
Thesis comment:	Fak. za informacijske študije v Novem mestu
Source comment:	Na ov.: Magistrska naloga : študijskega programa druge stopnje;
Pages:	87 str., [8] f. pril.
ID:	10954200