Skip to main content
SpringerLink
Log in
Book cover

Encyclopedia of Database Systems pp 792–793Cite as

Data Manipulation Language (DML)

  • Reference work entry
  • First Online:

  • 21 Accesses

Synonyms

Query language

Definition

A data manipulation language allows users to access and retrieve database contents in both interactive and embedded (in a host programming language) modes. DML includes constructs that allow retrieval and manipulation of database content. The more common and popular term used for DML is the “query language.” The ISO standard SQL language is the most popular DML for relational databases. DML can be declarative, specifying the properties of the data that is to be retrieved from the database or procedural where the use specifies how to access the data. Modern DBMSs are expected to have declarative DMLs (such as SQL), which allows the DBMS to convert them into a relational algebra expression before optimizing their execution. There are other data manipulation languages for specific DBMSs – e.g., SPARQL for RDF data, OQL for object database systems, and XQuery for XML DBMSs.

Historical Background

The definition of a DML dates back to the origins of...

This is a preview of subscription content, log in via an institution.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD   6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Recommended Reading

  1. Elmasri R, Navathe S. Fundamentals of database systems, 7th ed. Pearson; 2016.

    Google Scholar 

  2. Silberschatz A, Korth HF, Sudarshan S. Database systems concepts, 6th ed. McGraw-Hill; 2010.

    Google Scholar 

  3. Ramakrishnan R, Gehrke J. Database management systems, 3rd ed. McGraw-Hill; 2002.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Cheriton School of Computer Science, University of Waterloo, Waterloo, ON, Canada

    M. Tamer Özsu

Authors
  1. M. Tamer Özsu
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to M. Tamer Özsu .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, Canada

    M. Tamer Özsu

Section Editor information

  1. Computer Science, The University of Texas at Arlington, Arlington, TX, USA

    Ramez Elmasri

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Özsu, M.T. (2018). Data Manipulation Language (DML). In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_80654

Download citation

Publish with us

Policies and ethics

Search

Navigation