Unit 1
Introduction to database management system
Database
Characteristics
of data in database
Advantages
of database management system
Data
Data means
know facts that can be recorded and that have implicit meaning
In general term we can say that data is information
Database:
A database
is organized collection of data of reality in a way that support process
requiring this information
Example:
Modeling the
availability of rooms in a hotel in way that support finding a hotel with
vacancies
Or
Database is
setup that one set of software program provides all user with access to all the
data
DBMS (Data
Base Management System)
DBMS are specially designed application that interact
with user, other application and database itself to capture and analyses data
A general purpose DBMS is a software system
designed to allow the definition creation querying update and administration of
database.
Well known DBMS
include :MY SQL,postgre SQL,Microsoft SQL
Most existing
DBMS fall in following main group
ü >> Data Definition
ü Defining new data structure for a
database , removing data structure ,modifying updating the structure of existing data
ü ....>>Update, inserting modifying and
deleting data
ü ..>>Retrieval, obtaining info either for
end user query
ü >>>Administration registering and
monitoring user enforcing data, security
ü ..>> DBMS is responsible for maintain the
integriety and security of store data and recovering information if system
fail
ü ..>>Database servers are usally multiprocessor computer with generous memory and RAID disk array used for stable storage
IN Characteristics of Data base management system
ü Uses a digital repository established on a server and manage information
ü Provide a clear and logical view of the process that manipulate data
ü DBMS contains automatic backup and recovery process
ü Contain ACID property(Atomicity, consistency, isolation durability) maintain data in healthy state in case of failure
ü Reduce complex relationship between data
ü Used to support manipulation and processing of data
ü Provide security of data
ü View the database from different point of view according to requirement of user
ü Form a table to store data
ü Less redundancy
ü Maintain consistency ,consistency is a state where every relation in database remain consistent
ü DBMS is equipped with query language which make it more efficient to retrieve and manipulate data
ü Support multiuser and con current of data
i
0 Comments