DATABASE SYSTEM AND IT'S COMPONENTS

Wednesday, February 13, 2008 by Ankit Goyal

DATABASE SYSTEM

A database system is a computer based record keeping System whose overall purpose is to record and maintain information that is relevant to the organization necessary for making decisions.

With the growth of the database, these systems are used in various applications of real world such as

• Banking System and ATM's machines.

• Stock Trading Systems.

• Flight Reservation Systems.

• Computerized Library Systems.

• Super Market Product Inventory System.

• Credit Card/Credit Limit Check System.

Database can range from those of a single user with a desktop computer to those on mainframe computers with thousands of users.

COMPONENTS OF DATABASE SYSTEM

A database system is composed of four components;

• Data

• Hardware

• Software

• Users

which coordinate with each other to form an effective database system.



Fig. 1.1 Data Base System

1. Data - It is a very important component of the database system. Most of the organizations generate, store and process 1arge amount of data. The data acts a bridge between the machine parts i.e. hardware and software and the users which directly access it or access it through some application programs.

Data may be of different types.

User Data - It consists of a table(s) of data called Relation(s) where Column(s) are called fields of attributes and rows are called Records for tables. A Relation must be structured properly.

Metadata - A description of the structure of the database is known as Metadata. It basically means "data about data". System Tables store the Metadata which includes.

- Number of Tables and Table Names

- Number of fields and field Names

- Primary Key Fields

Application Metadata - It stores the structure and format of Queries, reports and other applications components. '

2. Hardware - The hardware consists of the secondary storage devices such as magnetic disks (hard disk, zip disk, floppy disks), optical disks (CD-ROM), magnetic tapes etc. on which data is stored together with the Input/Output devices (mouse, keyboard, printers), processors, main memory etc. which are used for storing and retrieving the data in a fast and efficient manner. Since database can range from those of a single user with a desktop computer to those on mainframe computers with thousand of users, therefore proper care should be taken for choosing appropriate hardware devices for a required database.

3. Software - The Software part consists of DBMS which acts as a bridge between the user and the database or in other words, software that interacts with the users, application programs, and database and files system of a particular storage media (hard disk, magnetic tapes etc.) to insert, update, delete and retrieve data. For performing these operations such as insertion, deletion and updation we can either use the Query Languages like SQL, QUEL, Gupta SQL or application softwares such as Visual 3asic, Developer etc.

4. Users - Users are those persons who need the information from the database to carry out their primary business responsibilities i.e. Personnel, Staff, Clerical, Managers, Executives etc. On the basis of the job and requirements made by them they are provided access to the database totally or partially.

The various types of users which can access the database are:-

Database Administrators (DBA)

Database Designers

End Users

Application Programmers

Filed under having  

32 comments:

butt said...

its very helpful to understand theconcepts about the componenets of DBMS .thanks

Ankur said...

it is very helpful..... nice thanx to share....

ellieszayuelilia said...

it's not informations that i;m wanted...huhuhuhuhu.....

victoria said...

wow...thanks so much!!,,this is so cool

ocen said...

oh u saved on ma cours work thanks

mrunal said...

thanks!

Manasse Laizer said...

well described!!! i like it!! but i suggest that we should have the fifth component i.e procedure

ngunjirialex said...

thanks it of great help..

gacha said...

Easy to understand..Thanks a lot for your clear explaination

Web said...

Easy To understand....

Preet said...

According to Prateek Bhatia PROCEDUE is also one of the component....Explain about it in Detail

magelegedas said...

thanx this is very helpfull....

subhassh ram said...

thnks yaar... its hlpd me 2 undrstnd lots of information abur DBMS n Its componants... bt i thnk thr shud b 1 mor componant which cn b "feedback"

Suraj Aditya Singh said...

Thanks freind i have got right answers.

Suraj Aditya Singh said...

thanks freind.It is very helpful.

sujata said...

it too helpful for my 9th students to understand concept of database components.

fathiah said...

thanks for this information... it do help me understand more about DBMS component...

sherriwright said...

Yeah we do actually have a lecture about it, but you did pursuing a great effort upon explaining this, thanks folks...i have learned something from it

talent kamini said...

thus super hey im thrilled wth the result

Erick Jhonson said...

It is very handy post on database. It discuss the components in a style which make easy to understand it.
pst recovery

Amit sachan said...

Amit sachan said...

its helpful for beginners

shivani yadav said...
This comment has been removed by the author.
shivani yadav said...
This comment has been removed by the author.
Janice Rafael said...

Hey there, I think your website might be having browser compatibility issues. When I look at your blog site in Ie, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, great blog!
Oracle Training

Clara Snyder said...

Really enjoy reading your well written articles. I think you spend numerous effort and time in posting the blog. I have bookmarked it and I am looking ahead to reading new articles. Keep up the good articles.
Oracle Security

Dexter Mutasa said...

just what i was looking for . good paper.

Dexter Mutasa said...

just what i was looking for, good paper.

Amcares said...

Nice one!!!

Le Mystique said...
This comment has been removed by the author.
roughpad9211 said...

"Hi, My client's previous SEO consultant left spammy comments with the aliases Janice Rafael and Clara Snyder at your blog which links to my client's site. This is causing us serious trouble with respect to SEO and the comments do not look good on your blog either.
We apologize for the inconvenience and we request you to remove that comment as well as this current one that I am making within 48 hours. If you don't do so, I will have to use Google's disavow tool to get the spammy comment along with the website link removed and, sorry to say this, but Google may not look too nicely upon you either for not having removed the comments. Thanks in advance for your cooperation''.

I.MOHAMED FIRNAZ said...

wow its really useful, great work team......