Database Management System

Database Management System (DBMS) Types

Database Management System is a software package that has been designed to create and maintain shared collection of logically related data. A Database Management System generally facilitates the processes of Defining, Constructing and Manipulating of data. In addition to that it provides various background services including transaction management, disaster recovery and security. Data management has become a high priority issue in modern business management. Therefore to support that, database management systems providers improving their products using innovative technologies.

Types of (DBMS)

Flat File System
A Flat File is a database that stores the data in a plain text file. Each line of the file stores a single value. Each field is separated by delimiters such as commas or tabs. Although it can have multiple tables, it cannot have multiple relations as the Relational Databases have.
Relational Databases
The main advantage of Relational Database over the Flat File System is that the proper organization of data that has. A relational database also defines the relationships between those tables. In the relational databases, queries are used to fetch data with the help of the indexes. The relational database technology makes the databases efficient, lighter and faster. Some of the advantages of the relational databases are;
§ Bringing tables together using relations
§ Provides a structure query language (SQL) to define and manipulate data.
§ Security
Object Relational Model: It is also a relational data model but with object orientation in it. It reduces the gap between the conceptual data modeling techniques and object-relational mapping.
Object-Oriented Database
An Object Oriented database is a combination of objects in a persistent storage which holds information. It is quite similar to the object oriented languages. It can be named as the fifth-generation database technology that was began to develop in mid 80’s.  The real world entities are represented like an object in the Object Oriented Data Model.
Multidimensional Database
It is a database system that can be used to utilize the advantages of the databases. It is usually structured to optimize online analytical processing and data warehouse applications. The multidimensional database can receive data from a variety of relational databases and structure the information into categories and sections that can be accessed in number of different ways.

Selecting DBMS
Selecting an appropriate DBMS is an important decision in any software application. An inappropriate application in DBMS will result system instability and lower performance. In the software development context is similar to below cases it’s recommended to not to use a DBMS.
§ Single-user applications PC applications.
§ Non mission critical systems.
§ Non security critical systems.
§ If the application handles low volume of data
§ In low resource environments. (Ex: Mobile Devices)

Advantages of Using A DBMS
§ Application programs are independent of data representation and data storage details.
§ Data is stored and accessed efficiently including the support of very large files and index structures.
§ Centralize administration of data shared among many users.
§ Let users feel the data is accessed only by him at that time.


Current Database Management Systems



There are several Database Management Systems have been introduced as it became much popular. Some of the most popular databases are MySQL, Microsoft SQL Server, Oracle, Dataphore etc, and they have their own unique features. Considering them software developers can use them for their projects.
Oracle
§ Oracle has many advanced functions such as Real Cluster, Flush back recovery etc.
§ Oracle DBA and developer cost higher to hire and train. Oracle price is higher and charge you 22% support/maintains every year.
§ For very complicated store procedure, Oracle runs faster.
§ Oracle runs on many platforms. SQL Server only runs on Windows.
§ If you have a big database needs running on powerful Unix or IBM server, with complicated application. Oracle is a good choice.
MySQL
§ Mysql replication works well for backup services and scaling out purposes are available.
§ In Mysql master-slave replication model, changes only flow from master to slaves.
MSSQL
§ T-SQL (Transaction SQL) enhancements
§ CLR (Common Language Runtime)