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.
GitHub rate of top DBMS
Leaders of the rate
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.
- 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
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.
- 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.
- Standard – $3 717
- Enterprise – $14 256
SQL server 2016 key innovations
- 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
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.
- 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
A free and open-source cross-platform document-oriented database program.
Platform: Windows, Linux, Mac OS , Solaris, FreeBSD.
- 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.
- 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.
- NoSQL database for real-time development.
- 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
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 HANA interface
- 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
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.
- 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.
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.
- 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