Database management system introduction
Database
management system introduction
Database is a collection of
data or information. The real time example of databases is telephone directory.
It is used for storing information such as name, address, telephone number
along with code numbers and providing access to information for multiple
users. Computer stores such data and
provides easy access in a faster time. Computer databases are used in all kinds
of organisation like business, hospitals and banking and what not. Technology
advancements allow multiple users to allow data thereby making the information centralized. Complex algebraic algorithm works together to access information easily
and querying a database provides quick result. A database is a type of file
system that stores data and organizes it in a useful and understandable
structure.
A database is stored as a
file or set of files. The information in these files is broken into records
which consist of many fields. Field is the basic unit of storage which
contains information related to attribute
of an entity. Records are organised
into tables which establishes about
relationship between the fields. Database record and files must be organised to
allow retrieval of the information. A database management system allows accessing
and retrieving data in response to queries. Database provides cross referencing capabilities.
Database management system which is a collection of interrelated data provides
an environment to conveniently and efficiently use the data stored.
Databases uses file systems
to store data previously but it proved to be redundant and inconsistent. In Flat databases are organised according to
list of entities. Hierarchical databases
are tree like structure with each level of records branching off providing
just a single link between set of records at different levels. Whereas, network databases provide multiple
linkages between sets by placing links between records. The accuracy and speed
of network databases have led their use in business widely and in e-commerce increasingly.
Relational databases are used where
files cannot be related by links. Database management system employs various iterations
of SQL for relational databases. Object oriented databases store and
manipulate complex data structures called objects and it is considered to be
the most flexible and adaptable database structure.
Comments
Post a Comment