Nowadays, we find multiple databases on the market and this forces us to make comparisons to find out which one is the best suited to our environment. Last year we were looking at the best databases of 2016 and, although these have not changed too much, today we will see the best databases of 2017. If you are interested in selecting a database, think that on the one hand you have relational databases and on the other hand NoSQL databases. Relational databases remained booming during the 1970s era, while NoSQL databases are relatively new, emerging about 10 years ago. In addition to these two types of databases, there are hybrid databases such as SQL/NoSQL, in-memory databases or databases as a service. The right choice of storage technology, with simple and secure use, with useful tools and a community that supports the product, will make the difference when it comes to managing a business. It will improve our productivity and therefore becomes vital for any business. For all these reasons, database monitoring is a priority in any installation.

Better databases

If you are going to hire a new support technician for your team, the most logical thing to do is to carry out a good selection process. The same applies to databases; it is advisable to investigate the pros and cons of each tool. Not only should we think about where our company is at the moment, but we should also evaluate the database thinking about where we want to be. The questions we should ask ourselves before choosing a database are the following:
  • How many customers do I want to serve?
  • What size of data will I need to manage?
  • Will I need to implement batch jobs that will access the database?
  • What response time requirements do I need to provide to my customers?
  • How will I scale my database as the number of customers and transactions increase?
  • How will I monitor my database to avoid downtime?
  • Do I need a relational database or a NoSQL one?
  • How will the database behave in case of downtime? How does it behave when there is a problem?
Before continuing, we leave you a link to this article comparing NOSQL vs SQL databases, so that you can know the main differences between these two models. And finally the expected moment; we present what, for us, are the best databases of 2017, with their main features.

Best Commercial databases

Today, the market is still dominated by DB2, SQL Server, Oracle and IBM. On Windows operating systems SQL Server tends to be the most common choice, while on Mainframe or Unix/Linux, Oracle and DB2 are the clear leaders.

Microsoft SQL Server

It is a database developed by Microsoft and is only compatible with Windows systems. There are many expert profiles in SQL Server and it is not difficult to acquire. The integration with Microsoft Azure has greatly improved its flexibility and performance. It also allows to manage information from other servers improving its usability. Benchmark:


Oracle is a database that can run on almost any operating system. Oracle has an abundance of profiles with experience in this technology and a large number of tools for administration and monitoring. Benchmark de Oracle:


It is the second most used database in Unix/Linux environments after Oracle. It is clearly an undisputed winner in Mainframe. There are professional profiles for DB2 but not as much as for Oracle. On the other hand, the DB2 Mainframe profile does not have to know how to move in DB2 linux/unix. Benchmark de DB2:


It stands out from other types of databases due to its storage and data analysis capacity. It is often used in large Big Data installations.

SAP Sybase

A decade ago it was one of the most successful databases; today it is less widespread, but still stands out for its scalability and performance.


During 1990, the company Informix was a very popular database system. However, in 2000 it had several management stumbles, weakening the company; it eventually sold the rights to IBM, including the brand, its plans and the database. As of today Informix and Ascential have ceased to exist as such, as IBM split the tools and applications; they are now part of IBM.

Best Freely Distributed Relational Databases

Within the free relational databases, there are three that stand out above the rest: these are MySQL, Maria DB and PostgreSQL. All of them have several benefits in common: the existence of a powerful community, the possibility of viewing and modifying the code as needed and the price they have, since they are free. mejores bases de datos

NoSQL Databases

NoSQL databases have evolved to respond to different problems and, although they are part of the same group, they have many differences between them. Currently we can divide them into four groups by their way of modeling data.

NoSQL Key-Value Oriented

It is the simplest data model and is ideal when accessing data by key. The difference of this type of database lies in the possibility of storing data without any predefined schema. They are usually very efficient for reads and writes; they are also designed to scale massively achieving a very fast response time. The data are usually stored in complex structures such as BLOB. Some examples of databases of this type would be the following:
  • Redis: Free software
  • Riak:Stands out for its ability to be a Key-value database, document storage and searchable.
  • Oracle NoSQL.
  • Microsoft Azure Table Storage.

Document-oriented NoSQL

Documents are stored supporting different formats (JSON, XML). Schemas can be changed without stopping the databases; developers can insert indexed documents and have access through the database engine. Its flexibility makes it one of the most versatile tools; Mongo DB and Couchbase Server stand out.

Mongo DB

It is one of the most popular databases today. It has the possibility of working with structured and unstructured data. It stands out for its great scalability and performance. It is also one of the databases with more experienced profiles, facilitating the learning and use process. It allows working by key-value pairs and accessing different parts of the stored data. Mongo DB does not support atomicity in operations and guarantees eventual integrity. Changes will be replicated across all nodes, but there is no guarantee that all nodes will have the same data at the same time.

Couchbase Server

Free database created in the Apache project. It does not guarantee 100% data integrity. It stands out for its large administration console, with which it is possible to access a large number of data in a very simple way.

Mark Logic Server

This database stands out from the previous ones for its data integrity and compatibility with XML, JSON and RDF. Supported systems: Windows, Solaris, Red Hat, Suse, CentOS, Amazon Linux and Mac OS.

Elastic Search

Other databases of note are RavenDB, Apache Jena and Pivotal GemFire.

Non-SQL Column-Oriented Databases

These databases are very similar to relational data tables, where you can map keys to values and group them into structures. They are used in environments where there is little typing and there is a need to access multiple columns of many rows. They are very useful in event processing and analysis, content management and data analysis.

Apache Cassandra

This database was created by Facebook and is now freely distributed. It is highly recommended for managing databases with large amounts of data. It currently has an Enterprise version of Cassandra called Datastax Enterprise. Supported data: ASCII, bigint, BLOB, Boolean, counter, decimal, double, float, int, text, timestamp, UUID, VARCHAR and varint.


Apache Hbase

It was designed to support large numbers of real-time read and write accesses to large amounts of data. One of its advantages is mail over Hadoop and over the Hadoop file system.

Non-SQL graph databases

This model is focused on entities and their relationships. It uses graph theory to link databases. Every element points to its adjacent element. These databases are recommended if your data is highly related, such as in social networks, fraud detection, real-time recommendations, etc. Here, the database should be normalized where each structure will have one column and each relation two.


Supports data integrity and high availability and cluster scaling. It also has a good administration panel.

Infinite graph

It is not freely distributable. Supported systems: Mac OSx, Linux and Windows. Benchmark: can be ordered from Objectivity. mejores bases de datos

Hybrid Model

More and more companies are offering hybrid solutions in which multiple database engines are used to support multiple NoSQL models and even relational engines. For example, CortexDB, Foundation DB and Orient DB offer multiple NoSQL models. IBM has extended its DB2 database to offer the ability to use NoSQL databases with BLU Acceleration. IBM DB2, in its extended version, allows data to be stored in XML, JSON and network storage.

As a Service Databases

As a Service databases are different from the rest because they offer their services in the cloud. You only have to read and write your data using services offered by the provider. Probably, over time, this is going to be one of the most demanded databases because of its ease of use.

Amazon SimpleDB

Database that offers a simple web services interface; it is used to store and create various data sets. If you want to create simple database accesses, Amazon SimpleDB can be a good choice. Data is stored as text and structures are generated by value parameter pairs. In addition, the data is automatically indexed, making it easy to search for information. There is no benchmark.

List of Pandora FMS modules for Database Monitoring

DatabaseModules and plugins
OracleOracle Monitoring
DB2DB2 Monitoring
SQL ServerSQL Server Monitoring
TeradataTeradata Monitoring Pandora FMS Enterprise
SAP SybaseSybase Monitoring
InformixInformix Monitoring
MySQLMonitoring MySQL active connections
MySQl Cluster
MysQL Monitoring
MySQL Performance
MySQL Plugin
MySQL Server Advanced Monitoring
Postgre SQLPerl PostgreSQL Monitoring
PostgreSQL Plugin Monitoring
Postgre SQL Plugin Monitoring
PostgreSQL Plugin Agents
Mongo DBMongoDB Monitoring Module MongoDB Monitoring Plugin Mongo DB
CouchbaseMonitoring Couchbase with Pandora FMS Enterprise
Mark Logic ServerMonitoring MarkLogic with Pandora FMS Enterprise
Elastic SearchMonitoring Elastic Search with Pandora FMS Enterprise
RedisMonitoring Redis with Pandora FMS Enterprise
RiakMonitoring Riak with Pandora FMS Enterprise
Microsoft Azure Table StorageMonitoring Azure with Pandora FMS Enterprise
Apache CassandraMonitoring Apache Cassandra
Apache HbaseMonitoring Apache hbase
Neo4jMonitoring Nwo4j with Pandora FMS Enterprise
Infinite graphMonitoring Infinite Graph with Pandora FMS Enterprise
Amazon SimpleDBMonitoring Amazon SimpleDB with Pandora FMS Enterprise
We hope this article has been useful for you. If you want to add any database, don’t hesitate to comment us. Finally, remember that Pandora FMS is a flexible monitoring software, capable of monitoring devices, infrastructures, applications, services and business processes. Do you want to know more about what Pandora FMS can offer you? Find out here. Or if you have to monitor more than 100 devices you can also enjoy a FREE 30 days DEMO of Pandora FMS Enterprise. Get it here.

Also, remember that if you have a small number of devices to monitor, you can use the OpenSource version of Pandora FMS. Find more information here.

Don’t hesitate to send your questions, the team behind Pandora FMS will be happy to help you!