Wednesday, February 18, 2015

Codd's Twelve Rules - Rule 7 - High level Insert, Update, and Delete


Codd's Twelve Rules - Rule 7 - High level Insert, Update, and Delete



Rule 7
High level Insert, Update, and Delete
Rule
The capability of handling a base relation or a derived relation as a single operand applies not only to the retrieval of data but also to the insertion, update, and deletion of data.
Description
This rule stresses the set-oriented nature of a relational database. It requires that rows be treated as sets in insert, delete, and update operations. The rule is designed to prohibit implementations that support only row-at-a-time, navigational modification of the database. The SQL language covers this via the INSERT, UPDATE, and DELETE statements.
Example
SQL Server,          MySQL, and Oracle support bulk insert, delete, and update.
          INSERT INTO yourtable VALUES (1,2), (5,5), ...; - this can be used to insert multiple rows at a time in MySQL.
Some DBMS that fulfills this property
SQL Server,          MySQL, and Oracle

No comments:

Post a Comment