Relatsiooniliste andmebaaside haldussüsteemide võrdlus
Date
2013
Authors
Journal Title
Journal ISSN
Volume Title
Publisher
Tartu Ülikool
Abstract
Antud bakalaureusetöö eesmärgiks oligi valida kolm populaarset relatsioonilise andmebaasi haldussüsteemi, mil¬leks osutusid Oracle Database 11g Standard Edition, Microsoft SQL Server 2012 ja Sybase SQL Anywhere 12, ning võrrelda ja analüüsida neid kasutades spetsiaalselt selle töö jaoks püstitatud ülesannet ning defineeritud hindamiskriteeriume algaja või keskmiste teadmis¬tega andmebaasi haldaja seisukohalt. Seejärel oli kavas tulemusi võrrelda DB-Engines veebilehel aprilli seisuga avalikustatud relatsiooniliste andmebaasi haldussüsteemide populaarsuse pingereaga.
Kuna aga erinevad andmebaaside haldussüsteemide tootjad on oma litsentsilepingutest läh-tuvalt keelanud süsteemide võrdlustestide (ingl benchmark tests) tulemuste avalikustamise kolmandale osapoolele ilma tootjate kirjaliku nõusolekuta, siis ei jäänud muud üle, kui taodelda töö mitteavalikustamist. Seetõttu on antud dokumendis esitletud vaid töö kokkuvõte nii eesti kui ka inglise keeles koos tähtajatut mitteavalikustamise piirangut taotleva lihtlitsentsiga.
The purpose of this paper is to compare and analyse three different relational database management systems from a novice user’s point of view. These three systems are chosen from the DB-Engine’s relational DBMS popularity ranking and include Oracle Database 11g Standard Edition, Microsoft SQL Server 2012 and Sybase SQL Anywhere 12. For the analysis of the DBMSs a sample assignment was created together with nine different rating criteria. The goal of the assignment was to create a small database, similar to a one of a small business and perform all the tasks described in the declaration of the rating system. The criteria included the rating of the availability of the DBMS, documentation, ease of use, learning curve, the creation of a database, data management, user management, security (backup and recovery only), the support for operating systems and some other functionalities. Unfortunately, this thesis will not be published because all the vendors of those three systems have stated in their licence agreements that no one is allowed to disclose the results of any program benchmark tests without their prior consent. So this document consists of only abstracts of the paper both in Estonian and in English as well as a non-exclusive licence for not publishing the whole thesis.
The purpose of this paper is to compare and analyse three different relational database management systems from a novice user’s point of view. These three systems are chosen from the DB-Engine’s relational DBMS popularity ranking and include Oracle Database 11g Standard Edition, Microsoft SQL Server 2012 and Sybase SQL Anywhere 12. For the analysis of the DBMSs a sample assignment was created together with nine different rating criteria. The goal of the assignment was to create a small database, similar to a one of a small business and perform all the tasks described in the declaration of the rating system. The criteria included the rating of the availability of the DBMS, documentation, ease of use, learning curve, the creation of a database, data management, user management, security (backup and recovery only), the support for operating systems and some other functionalities. Unfortunately, this thesis will not be published because all the vendors of those three systems have stated in their licence agreements that no one is allowed to disclose the results of any program benchmark tests without their prior consent. So this document consists of only abstracts of the paper both in Estonian and in English as well as a non-exclusive licence for not publishing the whole thesis.