EVALUATION OF DATABASE MANAGEMENT SYSTEMS

Qualitative and quantitative analysis of different database management systems (DBMS) have been performed in order to identify and compare those which address requirements such as public domain licensing, free of charge, high product support, ADO .NET Entity Framework compatibility, good performance...

Full description

Bibliographic Details
Main Authors: Liang, Xing, Lu, Yongyu
Format: Others
Language:English
Published: Högskolan i Halmstad, Sektionen för Informationsvetenskap, Data– och Elektroteknik (IDE) 2010
Online Access:http://urn.kb.se/resolve?urn=urn:nbn:se:hh:diva-6255
Description
Summary:Qualitative and quantitative analysis of different database management systems (DBMS) have been performed in order to identify and compare those which address requirements such as public domain licensing, free of charge, high product support, ADO .NET Entity Framework compatibility, good performance, referential integrity, among others. More than 20 existing database management systems have been selected as possible candidates. Qualitative analysis reduced that number to 4 candidates DBMSs (PostgreSQL, SQLite, Firebird and MySQL). Quantitative analysis has been used to test the performance of these 4 DBMSs while performing the most common structured query language (SQL) data manipulation statements (INSERT, UPDATE, DELETE and SELECT). Referential integrity and easy to install were also evaluated for these 4 DBMSs. As results, Firebird is the most suitable DBMS which best addressed all desired requirements.