Advanced Database Management System - Tutorials and Notes: Codd's Twelve Rules - Rule 7 - High level Insert, Update, and Delete

Search Engine

Please visit, subscribe and share 10 Minutes Lectures in Computer Science

Thursday, 19 February 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

3 comments:

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents