10 Open Source Relational Database Management Systems (RDMS)
The costs is always a concern when choosing a database, RDBMS from multinational corporations can be very costly and can cause you much grief if you are running a cost-free service online. Eventually open source database management tools can be very handy. These databases are either free or costs very less and offers most of the features of high-end database systems.
Here are the top 10 most popular open source database software with their descriptions.
MySQL is the world’s most popular open source database. MySQL is now owned by Oracle and uses Sequential Query Language to manage database. Its source is available under GNU license and propriety agreements. MySQL is most popular among PHP developers and used for websites, web applications and online services.
MySQL is available for free for non commercial purpose and can cost you less then $200 for commercial use. Offers features just like MS-SQL, Oracle and IBM DB2, large end database applications.
Commercial customers have the flexibility of choosing from multiple editions to meet specific business and technical requirements:
1. MySQL Standard Edition
2. MySQL Enterprise Edition
3. MySQL Cluster Carrier Grade Edition
Official Website: http://www.mysql.com/
PostgreSQL is a powerful, open source object-relational database system. PostgreSQL is known for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.
An enterprise class database, PostgreSQL boasts sophisticated 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 supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate. There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.
Official Website: http://www.postgresql.org/
Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird has always been more fully featured than MySQL, Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, including stored procedures, triggers, hot backups (backups while the database is running) and replication. Firebird database comes in two variations, classic server and super server.
Anyone can build a custom version of Firebird, as long as the modifications are made available, under the same IDPL licensing. No fees for download, registration, licensing or deployment, even you distribute Firebird as part of your commercial software package.
Official Website: http://www.firebirdsql.org/
CUBRID is a comprehensive open source relational database management system highly optimized for Web Applications, especially when complex web services process large amount of data and generate huge concurrent requests.
CUBRID is implemented in C programming language. It is scalable and is a high performance database system almost fully compatible with MySQL. CUBRID is a system with a unique architecture and rich functionality. Its High-Availability feature, sync/async/semi-sync replication, online and incremental backup, and many other enterprise level features make CUBRID a reliable solution ideal for Web services. By providing unique optimized features, CUBRID enables to process much more parallel requests at much less response time.
In addition, large Hosting companies Cafe24 and Mireene, Software Security company ESTsoft, and many Korean local colleges manage their data with CUBRID.
Two third of all CUBRID references come from the Government sector. Korea National Tax Service, Korea Ministry of Public Administration and Security, Korea Ministry of National Defense, Busan Transportation Corporation, and Korea White House are among the major customers who deployed CUBRID as their database management software. Just imagine how much sensitive data do they all have, how much security do they all require, and they all rely on CUBRID. CUBRID helps many organizations gain greater results and achieve faster performance at a lower cost of ownership.
Official Website: http://www.cubrid.org/
SQLite is an embedded SQL database engine for mobile apps and websites. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. SQLite has compliance with ACID properties of database. It is faster and has simple to use API. SQLite comes with a standalone command-line interface (CLI) client that can be used to administer SQLite databases.
Official Website: http://www.sqlite.org/
6) Berkeley DB
Owned by Oracle, Berkeley DB provides the foundational storage services for your application, no matter how demanding and unique your requirements may seem to be . Berkeley DB APIs are available in almost all programming languages including ANSI-C, C++, Java, C#, Perl, Python, Ruby and Erlang.
A program accessing the database is free to decide how the data is to be stored in a record. Berkeley DB puts no constraints on the record’s data. The record and its key can both be up to four gigabytes long. Note that Berkeley DB is not a full DBMS.
Official Website: http://www.oracle.com/
7) Apache Derby
Apache Derby (previously distributed as IBM Cloudscape) is an open relational database management system (RDBMS) developed by the Apache Software Foundation that can be embedded in Java programs and used for online transaction processing. Apache Derby implemented entirely in Java and available under the Apache License, Version 2.0.
Some key advantages include:
• Derby has a small footprint — about 2.6 megabytes for the base engine and embedded JDBC driver.
• Derby is based on the Java, JDBC, and SQL standards.
• Derby provides an embedded JDBC driver that lets you embed Derby in any Java-based solution.
• Derby also supports the more familiar client/server mode with the Derby Network Client JDBC driver and Derby Network Server.
• Derby is easy to install, deploy, and use.
Official Website: http://db.apache.org/derby/
•Full Index Support.
•Full Index Support
•Replication & High Availability
•Fast In-Place Updates
•MongoDB Management Service
Official Website: http://www.mongodb.org/
9) Infobright Community Edition (ICE)
The Open-Source Database for Ad hoc Analytics. Infobright is column oriented, open-source analytic database provides both speed and efficiency. ICE takes your machine generated data and gives you the ultimate power to slice-n’-dice your data. Plus, it’s free!
Official Website: http://www.infobright.org/
The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data. Cassandra’s support for replicating across multiple datacenters is best-in-class, providing lower latency for your users and the peace of mind of knowing that you can survive regional outages.
Cassandra’s data model offers the convenience of column indexes with the performance of log-structured updates, strong support for denormalization and materialized views, and powerful built-in caching.
Official Website: http://cassandra.apache.org/