A Generalized Comparison of Open Source and Commercial Database Management Systems

2009 ◽  
pp. 13-27
Author(s):  
Theodoros Evdoridis ◽  
Theodoros Tzouramanis
Keyword(s):  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Commercial Products ◽  
Database Model ◽  
Source Database ◽  
Main System ◽  
Closed Source

This chapter attempts to bring to light the field of one of the less popular branches of the open source software family, which is the open source database management systems branch. In view of the objective, the background of these systems will first be briefly described followed by presentation of a fair generic database model. Subsequently and in order to present these systems under all their possible features, the main system representatives of both open source and commercial origins will be compared in relation to this model, and evaluated appropriately. By adopting such an approach, the chapter’s initial concern is to ensure that the nature of database management systems in general can be apprehended. The overall orientation leads to an understanding that the gap between open and closed source database management systems has been significantly narrowed, thus demystifying the respective commercial products.

A Generalized Comparison of Open Source and Commercial Database Management Systems

2011 ◽  
pp. 296-304
Author(s):  
Theodoros Evdoridis
Keyword(s):  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Commercial Products ◽  
Database Model ◽  
Source Database ◽  
Main System ◽  
Closed Source

This chapter attempts to bring to light the field of one of the less popular branches of the open source software family, which is the open source database management systems branch. In view of the objective, the background of these systems will first be briefly described followed by presentation of a fair generic database model. Subsequently and in order to present these systems under all their possible features, the main system representatives of both open source and commercial origins will be compared in relation to this model, and evaluated appropriately. By adopting such an approach, the chapter’s initial concern is to ensure that the nature of database management systems in general can be apprehended. The overall orientation leads to an understanding that the gap between open and closed source database management systems has been significantly narrowed, thus demystifying the respective commercial products.

A Generalized Comparison of Open Source and Commercial Database Management Systems

2011 ◽  
pp. 294-308
Author(s):  
Theodoros Evdoridis
Keyword(s):  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Commercial Products ◽  
Database Model ◽  
Source Database ◽  
Main System ◽  
Closed Source

This chapter attempts to bring to light the field of one of the less popular branches of the open source software family, which is the open source database management systems branch. In view of the objective, the background of these systems will first be briefly described followed by presentation of a fair generic database model. Subsequently and in order to present these systems under all their possible features, the main system representatives of both open source and commercial origins will be compared in relation to this model, and evaluated appropriately. By adopting such an approach, the chapter’s initial concern is to ensure that the nature of database management systems in general can be apprehended. The overall orientation leads to an understanding that the gap between open and closed source database management systems has been significantly narrowed, thus demystifying the respective commercial products.

Open Source Database Management Systems

2005 ◽  
pp. 457-462 ◽  
Author(s):  
Sulayman K. Sowe ◽  
Ioannis Samoladas ◽  
Ioannis Stamelos
Keyword(s):  
Software Development ◽  
Open Source ◽  
Open Source Software ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Free Open Source Software ◽  
Source Database ◽  
1960S And 1970S ◽  
Free Open Source

This article discusses open source database management systems (OSDBMS) trends from two broad perspectives. First, the software engineering discipline platform on which databases are built has recently witnessed a new form of software development—Free/Open Source Software Development (F/OSSD). Methodically, the F/OSSD paradigm has changed the way relational databases, initiated in the 1960s and 1970s, are developed, distributed, supported, and maintained. Second, commercial relational database management systems (RDBMS) still dominate the database market because, on one hand, vendors and users are skeptical of the boon of applications developed and distributed under the F/OSSD paradigm, and on the other hand, it has been argued that OSDBMS are not likely to follow the successful trend of other robust Free/Open Source Software (F/OSS) systems (Linux, Apache, etc.). This article presents trends in OSDBMS by looking at the morphology and landscape of the type of applications developed by the F/OSS community. Implementation of F/OSS strategies and factors mitigating the adoption and utilization of OSDBMS are explored by looking at the interactions between the F/OSSD process and database firms, vendors, and users.

scholarly journals Overview of Modern Nosql Database Management Systems. Case Study: Apache Cassandra

2018 ◽  
Vol 9 (1) ◽  
pp. 83-86
Author(s):  
Katalin Ferencz
Keyword(s):  
Open Source ◽  
Database Management ◽  
Query Language ◽  
Distributed Database ◽  
Database Management Systems ◽  
Sensor Data ◽  
Management Systems ◽  
Database Server ◽  
Server Software ◽  
Iot Devices

Abstract The wide spread of IoT devices makes possible the collection of enormous amounts of sensor data. Traditional SQL (structured query language) database management systems are not the most appropriate for storing this type of data. For this task, distributed database management systems are the most adequate. Apache Cassandra is an open source, distributed database server software that stores large amounts of data on low-coast servers, providing high availability. The Cassandra uses the gossip protocol to exchange information between the distributed servers. The query language used is the CQL (Cassandra Query Language). In this paper we present an alternative solution to traditional SQL-based database management systems - the so called NoSQL type database management systems, summarize the main types of these systems and provide a detailed description of the Apache Cassandra open source distributed database server installation, configuration and operation.

scholarly journals A Survey of Open Source Tools for Business Intelligence

2011 ◽  
pp. 237-257
Keyword(s):  
Open Source ◽  
Business Intelligence ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Survey Article ◽  
On Line ◽  
Analytical Processing ◽  
Industrial Use ◽  
On Line Analytical Processing

The industrial use of open source Business Intelligence (BI) tools is becoming more common, but is still not as widespread as for other types of software. It is therefore of interest to explore which possibilities are available for open source BI and compare the tools. In this survey article, we consider the capabilities of a number of open source tools for BI. In the article, we consider a number of Extract- Transform-Load (ETL) tools, database management systems (DBMSs), On-Line Analytical Processing (OLAP) servers, and OLAP clients. We find that, unlike the situation a few years ago, there now exist mature and powerful tools in all these categories. However, the functionality still falls somewhat short of that found in commercial tools.

scholarly journals A Survey of Open Source Tools for Business Intelligence

2010 ◽  
pp. 624-644
Author(s):  
Christian Thomsen ◽  
Torben Bach Pedersen
Keyword(s):  
Open Source ◽  
Business Intelligence ◽  
Database Management ◽  
Database Management Systems ◽  
Management Systems ◽  
Survey Article ◽  
On Line ◽  
Analytical Processing ◽  
Industrial Use ◽  
On Line Analytical Processing

The industrial use of open source Business Intelligence (BI) tools is becoming more common, but is still not as widespread as for other types of software. It is therefore of interest to explore which possibilities are available for open source BI and compare the tools. In this survey article, we consider the capabilities of a number of open source tools for BI. In the article, we consider a number of Extract-Transform-Load (ETL) tools, database management systems (DBMSs), On-Line Analytical Processing (OLAP) servers, and OLAP clients. We find that, unlike the situation a few years ago, there now exist mature and powerful tools in all these categories. However, the functionality still falls somewhat short of that found in commercial tools.

scholarly journals Kajian Unified Theory of Acceptance and Use of Technology Dalam Penggunaan Open Source Software Database Management System

2016 ◽  
Vol 2 (1) ◽  
Author(s):  
Michael Sonny
Keyword(s):  
Open Source ◽  
Open Source Software ◽  
Management System ◽  
Database Management ◽  
Database Management System ◽  
Unified Theory ◽  
Source Database ◽  
Use Of Technology ◽  
Mozilla Firefox

Perkembangan perangkat lunak computer dewasa ini terjadi sedemikian pesatnya, perkembangan tidak hanya terjadi pada perangkat lunak yang memiliki lisensi tertentu, perangkat open source pun demikian. Perkembangan itu tentu saja sangat menggembirakan bagi pengguna computer khususnya di kalangan pendidikan maupun di kalangan mahasiswa, karena pengguna mempunyai beberapa pilihan untuk menggunakan aplikasi. Perangkat lunak open source juga menawarkan produk yang umumnya gratis, diberikan kode programnya, kebebasan untuk modifikasi dan mengembangkan. Meneliti aplikasi berbasis open source tentu saja sangat beragam seperti aplikasi untuk pemrograman (PHP, Gambas), Database Management System (MySql, SQLite), browsing (Mozilla, Firefox, Opera). Pada penelitian ini di kaji penerimaan aplikasi DBMS (Database Management System) seperti MySql dan SQLite dengan menggunakan sebuah model yang dikembangkan oleh Venkantes(2003) yaitu UTAUT (Unified Theory of Acceptance and Use of Technology). Faktor – faktor tertentu juga mempengaruhi dalam melakukan kegiatan pembelajaran aplikasi open source ini, salah satu faktor atau yang disebut dengan moderating yang bisa mempengaruhi efektifitas dan efisiensi. Dengan demikian akan mendapatkan hasil yang bisa membuat kelancaran dalam pembelajaran aplikasi berbasis open source ini.   Kata kunci— open source, Database Management System (DBMS), Modereting

Sign in / Sign up

Export Citation Format

Share Document