BCA - Data Manipulation and Analysis (DMA)

Data Manipulation Language (DML)

1. Data Manipulationis:
   • retrievalof information from the database
   • insertionof new information into the database
   • deletionof information in the database
   • modificationof 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 whatdata is needed and how to get it
   • nonprocedural: the user only specifies whatdata is needed
     • Easier for user
     • May not generate code as efficient as that produced by procedural language.
4. A query language is a portion of a DML involving information retrieval only. The terms DML and query language are often used synonymously.