Manipulating Data

by Luke Satriani D. Felarca

• DATA DEFINITION LANGUAGE -  SQL's Data Definition Language (DDL) subset. It is a language used to describe data and the connections between it in a database. To: Maintain a copy of the database structure. You may create DDL for database objects in a script. By interacting with descriptions of the database schema, it is used to construct and alter the structure of objects in a database. DDL instructions, as opposed to data manipulation language (DML) commands, are used to change the database structure, such as by adding new tables or objects with all of their properties (data type, table name, etc.)
• INTERACTIVE DATA MANIPULATION LANGUAGE - A computer programming language called a data manipulation language (DML) is used to add (insert), remove (delete), and alter (update) data in a database. A DML is frequently a sublanguage of a more general database language like SQL, and it contains some of the language's operators. SELECT Retrieve data from the database. DML is separated into two categories: High-Level or Non-Procedural DML, and Low-level or Procedural DML. INSERT — Add information to a table. Update current data in a table using the UPDATE command. DESTROY — Remove data from a database table.
• EMBEDDED DATA MANIPULATION LANGUAGE - The phrase "Embedded Data Manipulation Language" (EDML) seems to be unusual or unorthodox. It's probable that it refers to a framework or language that is domain-specific and employed in a certain system or environment, but I am unable to give a firm explanation without further details.