Data Manipulation Language (DML)

Data Manipulation Language (DML): DML is a language that enables users to access or manipulate data as organized by appropriate data model.

The types of accesses are:

i) The retrieval of information stored in the database - Query

ii) The insertion of new information into the database - insert

iii) The deletion of information from the database - delete

iv) The modification of information stored in the database — update

Classes of DML: There are basically two types:

(i) Procedural DMLs - user specifies what data are required and how to get or compute the data. e.g. Relational Algebra.

(ii) Nonprocedural DMLs (Declarative DMLs) - user specifies what data arc required without specifying how to get or compute the data. e.g. SQL.