A relational database matches data using common characteristics found within the data set. The resulting groups of data are organized and are much easier for people to understand. In such a database the data and relations between them are organized in tables. A table is a collection of records and each record in a table contains the same fields. Certain fields may be designated as keys, which means that searches for specific values of that field will use indexing to speed them up.
The term relational database was originally defined by Edgar Codd, a British computer scientist, whilst working at IBM Almaden Research Center. He recognized that the concept of a relational database could be derived from the principles of relational algebra and relational calculus.
A Relational Database Management System (RDBMS) is a Database Management System (DBMS) that is based on the relational model. Most database systems today are based on this type of system.
A database is a vital system for any organization that stores mission critical information. The continual failure of a company’s database system can only lead to the demise of the organization – companies cannot do business without a working database system.
To provide an insight into the quality of software that is available, we have compiled a list of 10 open source RDBMS. Hopefully, there will be something of interest here for anyone who wants to store data in an efficient way.
Now, let’s explore the 10 open source RDBMS at hand. For each title we have compiled its own portal page, a full description with an in-depth analysis of its features, together with links to relevant resources
|MySQL||Multithreaded, multi-user SQL database management system|
|MariaDB||Seeks high compatibility with MySQL, ensuring drop-in replacement capability|
|PostgreSQL||Award winning Object-relational database management system|
|SQLite||Embeddable SQL Database Engine|
|Firebird||Relational database offering many ANSI SQL features|
|LucidDB||Purpose-built entirely for data warehousing and business intelligence|
|H2||Relational database management system written in Java|
|HSQLDB||JDBC interface, client-server version, query tool, grid and more|
|Apache Derby||Full-featured relational database implemented entirely in Java|
|Virtuoso||Data Management with Web Application Server and Web Services Platform|
|CUBRID||Database engine with built-in enterprise grade features|
There are many excellent database systems that are closed source free to download applications. Worthy of particular note are DB2 (a real heavyweight by IBM), Oracle Database 18c (developed by Oracle Corporation), and MaxDB (capable of running terabyte-range data in continuous operation).
Read our complete collection of recommended free and open source software. The collection covers all categories of software.
The software collection forms part of our series of informative articles for Linux enthusiasts. There are hundreds of in-depth reviews, open source alternatives to proprietary software from large corporations like Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. There are also fun things to try, hardware, free programming books and tutorials, and much more.