Repository of colleges and higher education institutions

Show document
A+ | A- | Help | SLO | ENG

Title:Večparameterska primerjalna analiza implementacij podatkovnih skladišč za potrebe migracije podatkovne baze v MS Accessu v podatkovno skladišče : magistrska naloga
Authors:ID Klenovšek, Nataša (Author)
ID Rodič, Blaž (Mentor) More about this mentor... New window
Files:.pdf MAG_2014_Klenovsek_Natasa.pdf (4,22 MB)
MD5: 80D0C74CF6D56086D683720F03FA3AEA
 
Language:Slovenian
Work type:Master's thesis/paper
Typology:2.09 - Master's Thesis
Organization:FIŠ - Faculty of Information Studies in Novo mesto
Abstract:V uvodnem delu raziskave smo predstavili in opredelili pojem podatkovnega skladišča ter preučili šest podatkovnih baz, ki se najpogosteje uporabljajo za namene podatkovnega skladiščenja: MySQL, PostgreSQL, MongoDB, MS SQL, Oracle in DB2. Izvorno podatkovno bazo v MS Accessu smo migrirali v podatkovna skladišča v prej naštetih bazah. Preučili smo kriterije, ki vplivajo na izbor podatkovnega skladišča za manjše podjetje ter na podlagi tega izoblikovali drevo kriterijev. S pomočjo sistema za podporo odločanju DEXi smo naredili večparametrsko primerjalno analizo obravnavnih podatkovnih skladišč, ter opravili dodatne analize v orodju VREDANA. Analizo najbolje ocenjenega podatkovnega skladišča smo razdelali še s pomočjo SWOT analize. Ugotovili smo, da MySQL najbolje zadovoljuje postavljene kriterije, saj je prejel najvišjo oceno. Sledijo mu v vrstnem redu po oceni PostgreSQL, DB2, MongoDB, MS SQL in Oracle.
Keywords:podatkovno skladišče, večparameterska odločitvena analiza, MySQL, PostgreSQL, MongoDB, MS SQL, Oracle, DB2
Place of publishing:Novo mesto
Place of performance:Novo mesto
Publisher:[N. Klenovšek]
Year of publishing:2014
Year of performance:2014
Number of pages:87 str., [8] f. pril.
PID:20.500.12556/ReVIS-4909 New window
COBISS.SI-ID:2048322579 New window
UDC:004.65(043.2)
Note:Na ov.: Magistrska naloga : študijskega programa druge stopnje;
Publication date in ReVIS:20.08.2018
Views:4401
Downloads:144
Metadata:XML DC-XML DC-RDF
:
Copy citation
  
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.

Licences

License:CC BY-NC-ND 4.0, Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International
Link:http://creativecommons.org/licenses/by-nc-nd/4.0/
Description:The most restrictive Creative Commons license. This only allows people to download and share the work for no commercial gain and for no other purposes.
Licensing start date:20.08.2018

Secondary language

Language:English
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.
Keywords:data warehouse, multi-attribute decision analysis, MySQL, PostgreSQL, MongoDB, MS SQL, Oracle, DB2


Back