The acronym “DML” may not mean what you think it means

do 10 januari 2019 — Raphael ‘kena’ Poss

SQL defines many statements for different things: creating tables, putting data into tables, using tables, between other things. To reason about groups of statements with related behavior, the data community uses common, widely accepted acronyms to designate these groups.

For example, the acronym “DDL” stands for “data definition language”, the subset of SQL that modifies the logical schema of a database (CREATE, etc.).

However, what about “DML” which stands for “data manipulation language”. What does “manipulation” mean?

Fun fact: it depends who you ask!

❦❦❦

There are two widely accepted but rather different definitions circulating in the wild:

❦❦❦

What to do? Like always, do not assume too much about what your community knows about your vocabulary. Define your terms! And in the specific case of “DML”, qualify: “DML, of the church of Oracle” (or “PostgreSQL”), or “DML, of the church of SQL Server” (or “MySQL”).


Copyright © 2018 Raphael ‘kena’ Poss. Permission is granted to distribute, reuse and modify this document according to the terms of the Creative Commons Attribution-ShareAlike 4.0 International License. To view a copy of this license, visit http://creativecommons.org/licenses/by-sa/4.0/.


Comments


dr knz @ work © Raphael ‘kena’ Poss. Powered by Pelican and Twitter Bootstrap. Icons by Font Awesome.