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