Components of DBMS
Most DBMS as of 2009 implement a relational model. Other DBMS system , such as object DBMS, offer specific feature for more specialized requirements. Their components are similar, but not identical.
RDBMS Components
Sublanguage
•Language(DDL):•for defining the structure of database and data control
•Language(DCL):for defining security/access controls, and data manipulation.
•Language(DML):For querying and updating data.
Interface drivers – these drivers are code libraries that provide methods to prepare statements, execute statement, fetch results etc. E.g. ODBC,JDBC
SQL engine – the components interprets and execute the DDL,DCL and DML statements, it include three major components computer, optimizer and executer.
Transaction engine – ensure that multiple SQL statements either or fail as a group, according to application dictates.
•Relation engine – relation objects such as Table, Index, and referential integrity constraints are implemented in this components.
Most DBMS as of 2009 implement a relational model. Other DBMS system , such as object DBMS, offer specific feature for more specialized requirements. Their components are similar, but not identical.
RDBMS Components
Sublanguage
•Language(DDL):•for defining the structure of database and data control
•Language(DCL):for defining security/access controls, and data manipulation.
•Language(DML):For querying and updating data.
Interface drivers – these drivers are code libraries that provide methods to prepare statements, execute statement, fetch results etc. E.g. ODBC,JDBC
SQL engine – the components interprets and execute the DDL,DCL and DML statements, it include three major components computer, optimizer and executer.
Transaction engine – ensure that multiple SQL statements either or fail as a group, according to application dictates.
•Relation engine – relation objects such as Table, Index, and referential integrity constraints are implemented in this components.
No comments:
Post a Comment
its cool