Monday, March 21, 2011

structure of DBMS

hey..
in this post
im here to share with you about 
structure of DBMS
based on this page that i got it..

for your information..
database management system (DBMS)
~~~~~~~
are actually interface between user and database
~~~~~~~
perform various operations on database

but, 
what help DBMS to perform this all various operation?

^^ dont worry..i will tell you..
~~~~~~~
components of DBMS 
help to perform all these requested operations
on the database and 
provide necessary data to the users


DDL Compiler
Data Description Language compiler
it processes schema definitions specified in DDL

DML Compiler and Query optimizer
The DML commands 
such as insert, update, delete, retrieve from the application program
sent 
to the DML compiler 
for compilation 
into object code for database access
then
optimized the best way execute query by query optimizer
and
send to data manager

Data Manager
central software component of DBMS

========================
here we go..
just that for this post!!
see you again..







Best regards,

No comments:

Post a Comment