Popular Database Management Systems


Popular Database Management Systems

1) Oracle
2) MySQL
3) Microsoft SQL Server
4) PostgreSQL
5) MongoDB
6) DB2
7) Cassandra
8) Microsoft Access
9) SQLite
10) Redis
-----------------------------------------------------
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) MongoDB

MongoDB is a cross-platform, document oriented database that provides, high performance, high availability, and easy scalability. MongoDB works on concept of collection and document.
-----------------------------------------------------
6) 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. 
-----------------------------------------------------
7) 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. 
-----------------------------------------------------
8) 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.
-----------------------------------------------------
9) SQLite

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. 

SQLite is available on UNIX (Linux, Mac OS-X, Android, iOS) and Windows. A complete SQLite database is stored in a single cross-platform disk file.
-----------------------------------------------------
10) 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. 

-----------------------------------------------------
G C Reddy Software Testing Videos

0 comments:

Post a Comment