Best Open Source Database Management Systems
This section covers our favourite open source database management systems. There’s a wide selection of open source database management systems available.
Data is the currency of enterprise, web, mobile, social, and cloud applications. Ensuring data is always a top priority for any business. For some businesses even minutes of downtime can cause a notable loss of revenue, reputation. A database is a vital system for any organisation that stores mission critical information. The continual failure of a company’s database system can only lead to the demise of the organisation – companies cannot do business without a working database system.
There’s a wide selection of open source database management systems,
|MariaDB fully merits our accolade. Its popularltiy with Google and Wikipedia is well documented. More importantly, it's a perfect solution for small and midsize bushiness. It's a complete drop-in replacement for MySQL with library binary equivalency and exact matching with MySQL APIs and commands. It adds some enhanced features.
License: GNU General Public License v2, GNU Lesser General Public License (for client libraries)
|MySQL is a worthy contender to MariaDB, and may be your preferred solution depending on your requirements. It's strengths include high availability. High availability environments provide substantial benefit for databases that must remain available. A high availability database environment co-locates a database across multiple machines, any one of which can assume the functions of the database.
MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks).
License: GNU General Public License v2 (or proprietary)
|MongoDB is a rather splendid cross-platform document-oriented database program that warrants special attention.
About Database Management Systems
There are four main types of database management systems:
- Hierarchical databases – records contain information about their groups of parent/child relationships, just like as a tree structure. This model is recognized as the first database model created by IBM in the 1960s.
- Network databases – a database model conceived as a flexible way of representing objects and their relationships. Its distinguishing feature is that the schema, viewed as a graph in which object types are nodes and relationship types are arcs, is not restricted to being a hierarchy or lattice.
- Relational databases – a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables.
- Object databases – information is represented in the form of objects as used in object-oriented programming.
Back to Linux Means Business Homepage