Data Manipulation Language (DML)

1. Data Manipulation is:
   • retrieval of information from the database
   • insertion of new information into the database
   • deletion of information in the database
   • modification of information in the database
2. A DML is a language which enables users to access and manipulate data.

   The goal is to provide efficient human interaction with the system.

3. There are two types of DML:
   • procedural: the user specifies what data is needed and how to get it
   • nonprocedural: the user only specifies what data is needed
     • Easier for user
     • May not generate code as efficient as that produced by procedural languages
4. A query language is a portion of a DML involving information retrieval only. The terms DML and query language are often used synonymously.