in

5 of the Best Relational Database Management System for Linux

- - 13 comments
A Database Management System (DBMS) is described as a set of computer programs that manages the creation, maintenance, and administration of a database. It is a system software package that supports the use of unified collection of data records and files known as databases. A DBMS could utilize any of a variety of database models, such as the network model or relational model.

A relational database management system (RDBMS) is a DBMS in which data is stored in the form of tables, and the relationship among the data is stored in the form of tables as well. Nowadays, majority of popular commercial and open-source databases are based on the relational database model.

For those of you who are interested, I have here a list of some of the best Relational Database Management System (RDBMS) for Linux (in no particular order):


MySQL
MySQL is a central component of the widely used LAMP (Linux, Apache, MySQL, Perl/PHP/Python) web application software stack. It is a common choice of database in web applications and is used in many well-known websites, including Google, Facebook, Wikipedia and YouTube. In addition, free software projects that need a full-featured database management system often use MySQL. Some of the popular free software projects using it are WordPress, MyBB, Drupal, and Joomla. MySQL is written in C and C++. Its SQL parser is written in yacc, and a home-brewed lexical analyzer named sql_lex.cc. The main features of MySQL include SSL support, query caching, embedded database library, True Varchar support, updatable views, and more. It also provides features that other RDBMS systems may not, such as multiple storage engines (native, partner-developed, and community-developed storage engines) and commit grouping.


Apache Derby
Apache Derby is an open source relational database management system (RDBMS) that is based on Java, JDBC, and SQL standards. The project's main aim is to provide a data management system that is easy to install, deploy, and use. Apache Derby has a 2.6 MB disk-space footprint, which contains the base engine and embedded JDBC driver. And since it provides an embedded JDBC driver, you could easily place it in any Java-based solution. Apache Derby supports the more standard client/server mode with the Derby Network Client JDBC driver and Derby Network Server. The network server maximizes the reach of the Derby database engine by allowing traditional client server operation. It also allows clients to connect over TCP/IP using the standard DRDA protocol and enables the Derby engine to support networked JDBC, ODBC/CLI, Perl and PHP.


PostgreSQL
PostgreSQL (also known as Postgres) is a free and open source object-relational database management system (ORDBMS) that has evolved from the Ingres project. With over 15 years of active development and a tested architecture, it is renowned for its dependability, data integrity and accuracy, and is widely considered as the most full-featured open-source database system. PostgreSQL has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others. It offers state of the art features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance. It also supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting.


HSQLDB
Written in Java, HSQLDB (Hyper Structured Query Language Database) is a relational database management system that supports a huge subset of SQL-92 and SQL:2008 standards. It provides a small but fast database engine that provides both in-memory and disk-based tables. HSQLDB offers tools such as a minimal web server, command line and GUI management tools, and several demonstration examples. It can run on Java runtimes from version 1.1 and above, including free Java runtimes like Kaffe. Some of the high-level features of HSQLDB include user-defined SQL procedures and functions, updatable views, arrays, schemas, datetime intervals, lobs, full and lateral joins and set operations. A lot of non-standard functions such as TO_CHAR and DECODE are also supported, and extensions to Standard SQL incorporate user-defined aggregate functions.


Ingres
Ingres is an SQL relational database management system that is aimed to support massive enterprise and government applications. Although commercially supported, it is fully open source with an ever-increasing global community of contributors. Ingres started as a research project at the University of California in the early 1970s and has since spawned a number of commercial and open source database applications that include Sybase, Microsoft SQL Server and Postgres. Originally funded by U.S. defense agency and the National Science Foundation, it has been steering the industry with pioneering technology for decades and has helped handle the most challenging enterprise applications of a number of Fortune 500 companies. Some of the main features of Ingres include fully transactional DBMS, ACID, and unlimited database and table size.


If you know of other excellent Relational Database Management System (RDBMS) for Linux, you may share them with us via comment.

13 comments

  1. Firebird RDBMS

    GPL 2.0 (last I heard) and has shadowing, an advanced db feature.

    ReplyDelete
  2. How could you possibly leave Firebird SQL out ? This article has no credibility...

    ReplyDelete
  3. IBM DB2 9.7.2 Express Edition. Limited to 2 CPU cores and 4Gb of main memory. No limitation in table sizes. I think, you can shuffle a lot data around before the restrictions cause you any serious pain.

    ReplyDelete
  4. Not much help if you are going to choose database. Very little is mentioned about the strength and weaknesses of each product.

    ReplyDelete
  5. Not open, not free, but Oracle RDMS is the best. The others is often good enough, and are being better and better.

    ReplyDelete
  6. Firebird!

    ReplyDelete
  7. FirebirdSQL - very fast, good with stored procedures, but poor documentation.
    SQLite - it's not server. Very lightweight, good documentation, perfectly ported. (I think it's most used DB in applications.)
    [Sorry for poor english, it's not my native lang.]

    ReplyDelete
  8. Firebird!

    ReplyDelete
  9. I haven't tried Firebird, but you can also take a look at CUBRID (http://www.cubrid.org) - an open source relational DBMS. It's pretty popular in Korea and it's just starting to enter the international market.

    ReplyDelete
  10. AnonymousMay 28, 2011

    MAXDB (formerly SAPDB)

    http://maxdb.sap.com/

    ReplyDelete
  11. Great post. Here’s a tutorial that shows how you can easily build an online database-driven web application with a parent-child table relationship, without codinghttp://blog.caspio.com/web-database/creating-one-to-many-relational-datapages/

    ReplyDelete
  12. Firebird? Are you joking?

    ReplyDelete