Top database management systems

Features and prices overview of leading and popular database management systems
29 June 2017   1014

Database management system is valuable element of any application, which works with big amount of information. It helps developers to store, search thru and edit data. 

A database is an organized block of data. It consists of schemas, tables, queries, reports, views, and other objects. As a rule, the data are organized to model aspects of reality in a way that supports processes requiring information, such as modeling the availability of plane seats in a way that supports finding an available plane.

A database management system (DBMS) is an application that interacts with the user, other applications, and the database itself to capture and analyze data.

A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

There are many DBMSs available at the market now. In regularly updated Github ranking there are 30 systems and they all depend on their architecture, purpose, functionality and price. Let’s take a closer look at this list and find out, which of them are popular, which gain popularity fast and why.

Top Database indexGitHub rate of top DBMS 

Leaders of the rate

Oracle Database

An object-relational database management system produced and marketed by Oracle Corporation.

Platforms: Linux, Windows, Solaris, Mac OS Server, IMB z/OS, HP-UX.

Price: free 30 days trial available. There are 5 types of license that you can buy. You can pay for each year separately or buy at once. 

  • Personal Edition – $92 – $460.
  • Standard Edition 2 – $700 – $17 500.
  • Enterprise Edition – $4 750 - $47 500.
  • Mobile Server – $4 600 – $23 000.
  • Secure Backup – $3 500.

Oracle Database interfaceOracle Database

Features:

  • Cloud First support. It can deploy cloud database and use it as ordinary local server database - check migrations, do the load tests and check it's performance in the test environment.
  • Cloud infrastructure allows to scale database fast in order to suit any business. 
  • High security level: built-in coding, data masking, tools for risks management and analytic.
  • Other cloud service integration - iass and paas oracle.

Oracle Database 12c video overview

MySQL

An open-source relational database management system.

Platforms: Linux, Mac OS, Windows, FreeBSD, HP-UX and the most another popular OS.

Price: available under free GPL license for all open source projects. There are also 3 editions for propriety development:

  • Standard Edition – $2 000.
  • Enterprise Edition – $5 000.
  • Cluster CGE – $10 000.

mysql interfaceMySql interface

Features: 

  • High data processing speed. Despite it's popularity for web development, it was initially created for cooperative systems with large amount of data.
  • This database is very popular and has a big community, many popular solutions support MySql by default, such as server complexes lamp and lemp.
  • Various data storage engines supported, which have no effect at the syntax.
  • Oracle MySQL Cloud Service is supported for cloud database deploy.

Oracle MySQL Cloud Service video overview

Microsoft SQL Server

A relational database management system developed by Microsoft.

Platforms: UNIX systems, Windows.

Price: free version is available for developers and hosting providers. Also, Express edition is free. It will suit for small companies with maximum database volume up to 10 gb.
Commercial licenses:

  • Standard – $3 717
  • Enterprise – $14 256

SQL server 2016 key innovationsSQL server 2016 key innovations

Features:

  • Full integration with Azure.
  • High security level. According to the tests of The National Institute of Standards and Technology, SQL server is the safest database management system for six years in a row.
  • Built in analytic tools, which are designed for systematize business information and data inside DB.
  • Virtual environments support.
  • Ability to use database for work with hybrid clouds.

SQL Server 2016 video review

PostgreSQL

An object-relational database management system with an emphasis on extensibility and standards compliance.

Platforms: Linux, Mac OS, Windows and the most of other popular OS.

Price: freeware.

postgresql structurePostgreSQL structure

Features:

  • Database runs on Storage Engine; that's why all tables represented as objects and all actions inside are performed with object-oriented functions.
  • Full support of NewSQL standards, which ensures compatibility with extensions for the structured queries language.
  • Regular expressions, recursive queries, table inheritance supported.
  • Big amount of data supported: geometric primitives, network addresses, arrays, JSON, pseudotypes and others.
  • Regular updates.

Top 10 features of PostgreSQL 

MongoDB

A free and open-source cross-platform document-oriented database program.

Platform: Windows, Linux, Mac OS , Solaris, FreeBSD.

Price: freeware.

mongodb interfaceMongoDB interface

Features:

  • A document-oriented database that uses the NoSQL approach.
  • Horizontal sharding used for scaling.
  • Replication support with the ability to use auxiliary replicas for read operations.
  • Drivers available for the most popular programming languages: C++, C#, Java, JavaScript, PHP.
  • Works with any data types.
  • Document indexation without relations setting.
  • Capability to use database as file storage with balanced load and replication support.

MongoDB video presentation

DBMS, that gain popularity 

Firebase Realtime Database

NoSQL database for real-time development.

Platforms: cloud application, works everywhere. 

Price: 3 editions with monthly payment.

  • Spark Plan – freeware with limits on volume and other restrictions.
  • Flame Plan – expanded version for 25$.
  • Blaze Plan – allows to create own database with necessary functionality.  

firebase interfaceFirebase interface

Features:

  • NoSQL database for real-time development.
  • Mobile development orientation, integration with applications, which are developed on Android, iOS, JavaScript, Java, Objective-C and Node.js.
  • Customers data sync. Firebase cloud is used for information storage. 
  • Own API for data encrypting.
  • Integration with debugging, testing, analytic and AdWords promotion tools.

Firebase Realtime Database presentation

SAP HANA

An in-memory, column-oriented, relational database management system developed and marketed by SAP SE.

Platforms: SUSE, Red Hat or cloud.

Price: free version available. Price depends on functionality and data volume.

sap hanaSAP HANA interface

Features:

  • Usage of NewSQL standard, which have advantages of both NoSQL and SQL features.
  • Built-in web-server and version management system.
  • HANA Studio available for Eclipse IDE.
  • Distribution Unit can be used for easy server-to-server migration. 
  • Big Data support.
  • Applications can use XML instead of SQL to connect to calculation subsystem.

SAP HANA usage for business solutions

MariaDB

A community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL.

Platforms: Unix, Windows, Solaris, Linux, Mac OS, BSD.

Price: freeware. 

MariaDBInside MariaDB

Features:

  • Created by the MySQL developers.
  • Improved data storage in InnoDB.
  • Secure and fast replication.
  • Enhanced storage support: Aria, XtraDB, PBXT and other.
  • Improved performance of character conversion and its deactivation in cases where this function is not needed.
  • Testing tools.

DynamoDB

A fully managed proprietary NoSQL database services that is offered by Amazon.com as part of the Amazon Web Services portfolio.

Platform: cloud service from Amazon Web Services.

Price: free test account available for 12 months. Price depends on functionality.  

DynamoDB architectureDynamoDB architecture

Features:

  • Evolution of NoSQL SimpleDB from Amazon.
  • The average processing time for the query is a few milliseconds, regardless of the scale of the system.
  • Automatic scaling of the database for the current load, both to increase or reduce resources , if high performance is not required at the moment.
  • AWS Lamda integration.
  • Access control

An example of using the features of DynamoDB in the Lyft application

What DBMS do you like?

Hackers made $226K in Monero breaking into Oracle WebLogic

The attacks started in December of 2017 as a group hackers installed Monero miners on Oracle WebLogic Servers, which led to hackers' profit of a quarter million dollars
12 January 2018   654

Oracle WebLogic Server is a Java EE application server currently developed by Oracle Corporation. The experts at the SANS Technology Institute and Morphus Labs reported that a group of hackers was attacking Oracle weblogic Servers from December 2017, using the exploit code for the CVE-2017-10271 vulnerability in Oracle WebLogic servers, patched by Oracle in October 2017 and leaked to the web.

The hackers reportedly chose that vulnerability as it was not difficult to use it through Internet to put the malicious code on the Weblogic server, and the exploit included IP scanner that searched for vulnerable hosts, which eventually let hackers make $226.000 worth 611 Monero coins installing a cryptocurrency miner.

The attackers had access to all the information in PeopleSoft that is touching WebLogic servers, but rather than sell this information on the black market, which takes more work than writing a simple script to exploit the system and drop crypto mining software on it, they probably thought they could get more money by crypto mining.
 

Johannes Ullrich

Dean of research, SANS Technology Institute

Despite the fact that hackers were able to steal significant corporate data or install ransomware, they only installed a cryptocurrency miner to mine Monero hoping that high CPU use of the server stayes unnoticed.

At the moment of press, these are main market parameters of Monero:

  • Average price: $370,66
  • Marketcap: $5 779 654 391
  • 24h volume: $150 136 000