Popular Database Management Systems

Popular Database Management Systems, SQL Databases, NoSQL Databases, Oracle, MS SQL Server, MS Access, MySQL, MongoDB, Cassandra, and Redis.

Popular Database Management Systems

Database Management System:

A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data.

Types of Databases:

Primarily, we have two types of databases,

1. SQL Databases/Relational Databases
2. NoSQL Databases/Non-relational Databases

I. SQL Databases or Relational Databases

Relational Database Management System (RDBMS):

A relational database management system (RDBMS) is a program that allows you to create, update, and administer a relational database. Most relational database management systems use the SQL language to access the database.

Relational Database or SQL Database:

A Relational database or SQL database is a type of database. It uses a structure that allows us to identify and access data in relation to another piece of data in the database. Often, data in a relational database is organized into tables.

Popular Relational Databases:

1. Oracle
2. MySQL
3. MS SQL Server
4. PostgreSQL
5. IBM DB2
6. Microsoft Access
Etc,

1. Oracle

Oracle Database Oracle RDBMS is an Object Relational Database Management System from the Oracle Corporation.

Oracle database is the first database designed for enterprise grid computing. The enterprise grid computing provides the most flexible and cost effective way to manage information and applications.

Editions of Oracle Database:

i. Enterprise Edition: It offers all features, including superior performance and security.

ii. Standard Edition: It provides the base functionality for users.

iii. Express Edition (XE): It is the lightweight, free and limited Windows and Linux edition.

iv. Oracle Lite: It is designed for Mobile devices.

2. MySQL

MySQL is a database management system that allows us to manage relational databases. It is open source software backed by Oracle. Even though MySQL is open source software, you can buy a commercial license version from Oracle to get a premium support services.

Editions of MySQL:

i. MySQL Community Edition: MySQL Community Edition is the freely downloadable version of the world’s most popular open source database.

ii. MySQL Standard Edition: MySQL Standard Edition includes InnoDB, making it a fully integrated transaction-safe, ACID compliant database. In addition, MySQL Replication allows you to deliver high performance and scalable applications.

iii. MySQL Enterprise Edition: MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, reliability, and uptime. It reduces the risk, cost, and complexity in developing, deploying, and managing business-critical MySQL applications.

iv. MySQL Cluster CGE: MySQL Cluster enables users to meet the database challenges of next generation web, cloud, and communications services with uncompromising scalability, uptime and agility.

3. Microsoft SQL Server

SQL Server is a Relational Database Management System (RDBMS) developed by Microsoft.

It is also an ORDBMS, Platform dependent, both GUI and command based software and SQL Language which is an IBM product (Freeware).

Editions of Microsoft SQL Server:

i. Enterprise Edition: This is the top-end edition with a full feature set.

ii. Standard Edition: This has less features than Enterprise, when there is no requirement of advanced features.

iii. Workgroup Edition: This is suitable for remote offices of a larger company.

iv. Web Edition: This is designed for web applications.

4. PostgreSQL

PostgreSQL is a powerful, open source object-relational database management system. PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

5. IBM DB2

DB2 is a database product from IBM. It is a Relational Database Management System (RDBMS). DB2 is designed to store, analyze and retrieve the data efficiently.

6. Microsoft Access

Microsoft Access is a member of the Microsoft Office suite of applications, It is a database management system (DBMS) that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.


II. NoSQL Databases/Non-relational Databases

NoSQL (Not Only SQL) databases are non-tabular databases and store data differently than relational tables. NoSQL databases come in a variety of types based on their data model. The main types are document, key-value, wide-column, and graph. They provide flexible schemas and scale easily with large amounts of data and high user loads.

Popular NoSQL Databases:

1. MongoDB
2. Apache Cassandra
3. Apache CouchDB
4. Redis
5. Neo4j
6. Amazon DynamoDB
Etc,

1. MongoDB

MongoDB is a No SQL database. It is an open-source, cross-platform, document-oriented database written in C++. It works on concept of collection and document.

2. Apache Cassandra

Apache Cassandra is a free and open-source distributed database management system designed to handle large amounts of data across many commodity servers.
It is a database that provides a mechanism to store and retrieve data other than the tabular relations used in relational databases.

3. Apache CouchDB

Apache CouchDB is an open-source document-oriented NoSQL database, implemented in Erlang.

CouchDB uses multiple formats and protocols to store, transfer, and process its data. It uses JSON to store data, JavaScript as its query language using MapReduce, and HTTP for an API.

Unlike a relational database, a CouchDB database does not store data and relationships in tables. Instead, each database is a collection of independent documents. Each document maintains its own data and self-contained schema.

4. Redis

Redis is an open source, in-memory data structure store, used as database, cache and message broker.

Redis supports data structures such as strings, hashes, lists, sets, sorted sets with range queries, bitmaps, hyperloglogs and geospatial indexes with radius queries.

5. Neo4j

Neo4j is the world’s leading open source Graph Database, it is highly scalable and schema free (NoSQL).

Neo4j is implemented in Java and accessible from software written in other languages using the Cypher query language through a transactional HTTP endpoint, or through the binary “Bolt” protocol.

6. Amazon DynamoDB

Amazon DynamoDB is a fully managed proprietary NoSQL database service that supports key–value and document data structures and is offered by Amazon.com as part of the Amazon Web Services portfolio.

Popular Database Management Systems

SQL Full Course Video

Introduction to NoSQL

SQL Tutorial for Beginners

Follow me on social media: