The most significant characteristics of a relational DBMS models are

• The relation data management model eliminated all parent-child relationship and instead represented all data in the database as simple row/column tables of data values.
• A relation is similar to a table with rows /columns of data values. The rows of a table are referred to as Tuples and the columns are referred to as Attributes. Several tuples of equal length placed one below the other created a table.
• Most data management systems based on the relational model have a built-in support for query language like ANSI, SQL or OBE (Query by Example). These queries are simple English constructs that allows adhoc data manipulation from a table.
• Each table is an in dependent entity and there is no physical relationship between tables.
• Relational model of data management is based on set theory. Build in query language is designed in the RDBMS, so that it can manipulate sets of data.

Data as well as Data Security comes under the central command of the RDBMS system. In a RDBMS all users request to insert, data in a table or to Update, delete or View data in a table must be routed through the RDBMS engine only. Direct calls data, cannot be made to the tables themselves. Hence there is a single point of control when it comes to data manipulation; this gives rise to, excellent data security. This means that unless the RDBMS engine is loaded and running in a computers memory user request for tables data are simply not entertained.

Related Article: What do you mean by Oracle Server?

Submitted to RB by Angel Fish