1

Not sure where to ask this but here it is anyway.

I understand that changes to the database schema are called migrations from a certain version to another.

What do DBAs call changes to the underlying data, ie. the sequence of INSERT, UPDATE, DELETE? Think of the MySQL binlog for instance. Is there a specific term for this?

  • Data manipulation operations ? – Kin Shah Jun 29 '15 at 12:11
  • data migrations? – ypercubeᵀᴹ Jun 29 '15 at 12:50
  • Where else, except Ruby on Rails, they are called migrations? – mustaccio Jun 29 '15 at 21:29
  • Scala also calls them so. Haskell too AFAIK. – VH-NZZ Jun 30 '15 at 5:16
1

Check out DML - Data Manipulation Language. This includes CRUD operations (Create (i.e. INSERT - not to be confused with the CREATE TABLE statement below), Read (i.e. SELECT), Update, Delete) on Tables. It's what people associate most classically with SQL.

Compare this with DDL - Data Definition Language. DDL involves the CREATE TABLE and ALTER TABLE operations (among others - related to INDEXes amongst other things).

For completeness, there is also DCL - Data Control Language. DCL is for the control of access to tables - GRANT and REVOKE (i.e. GRANT READ ON schema_name.table_name TO user_name.

The SQL standard is an attempt to homogenise DML among various vendors - its success has been limited so far. Many servers implement non-standard extensions, their own Stored Procedure language, DDL and DCL. Take a look at the "Procedural extensions" section on the SQL page above.

Changes to a schema (from the same version of the same server to another or even within the same instance) are simply called DDL - CREATE TABLE, ALTER TABLE, DROP TABLE.

Changes to a schema brought about (normally) by an upgrade (e.g. Oracle 9 to Oracle 11) are called migrations - going the other way is called either downgrading or backward migration.

Changes to a schema due to a change of server (i.e. Oracle to SQL Server) are called ports ("porting"). These are normally quite difficult and involved due to the differences between servers mentioned above.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.