There are several types of databases include
PostgreSQL
:- It is an open-source object-relational database management system (ORDBMS)
with an emphasis on extensibility and standards-compliance. PostgreSQL manages
concurrency through a system known as multiversion concurrency control (MVCC),
which gives each transaction a snapshot of the database, allowing changes to be
made without being visible to other transactions until the changes are
committed. PostgreSQL has built-in support for Plain SQL, PL/pgSQL which
resembles Oracle's PL/SQL procedural language and SQL/PSM. C which allows
loading custom shared libraries into the database.
Microsoft
Access:-MS Access is a
Relational Database Management System. Microsoft
Access contains a DBMS engine that creates, processes, and administers the
database. It is a member of the Microsoft Office suite of applications.
Microsoft Access stores data in its own format based on the Access Jet Database
Engine. Access stores all database tables, queries, forms, reports, macros, and
modules in the Access.
SQL
Server:-SQL Serveris
a relational database management system developed by Microsoftwhose primary
function is to store and retrieve data as requested by other software
applications.
FileMaker:-FileMaker Pro is a cross-platform relational
database application. It integrates a database engine with a GUI-based
interface. FileMaker evolved from a DOS application.FileMaker server briefly
ran on Linux. FileMaker Pro makes it easy to create custom solutions for
managing business information on iPad, iPhone, Windows, Mac and the web.
Oracle,
RDBMS:-Oracle introduced the first commercial Relational
Database Management System .Oracle Database
will run on many Operating Systems.Data storage and retrieval are implemented
with simple tables. Provides data consistency as well as data concurrency.Supports
very large size databases. So it is very beneficial for multinational
organizations having billion of records.rs a
Relational Database Management System
dBASE:-
dBASE was one of the first and
in its day the most successful DBMS for microcomputers. dBASE's underlying file
format, the .dbf file, is widely
used in applications needing a simple format to store structured data.DBase is
designed to manipulate relational databases. DBase uses procedural functions
and commands similar to the BASIC language.
Clipper:-Clipper is a computer programming
language. it is a powerful general-purpose programming language, it was
primarily used to create database/business programs.Clipper was originally
createdas a compiler for dBASE III
FoxPro
:-FoxPro is a text-based
procedurally orientedprogramming language and DBMS. it does support
relationships between tables. It is both an interpreter and true compiler.
FoxPro supports arithmetic functions such as addition, subtraction,
multiplication, and division. It also provides many special mathematical and
financial functions. it could be any of thousands of applications in business,
education, engineering, and the professions, the sciences and other fields.In
general, a database consists of number of RECORDS.
Let's See Advantages and Disadvantages of DBMS
Advantages
of DBMS Disadvantages of
DBMS
Controlling
Data Redundancy Cost
of Hardware & Software
Sharing of
Data Cost
of Data Conversion:
Data
Consistency Cost
of Staff Training:
Integration
Constraints Appointing
Technical Staff:
Data Security Database
Failures
Control over
Concurrency
Backup and
Recovery Procedures
Data
Independence
