04 May 2009

🛢DBMS: Data Definition Language [DDL] (Definitions)

"The subset of SQL statements used for modeling the structure (rather than the contents) of a database or a cube. The DDL gives you the ability to create, modify, and remove databases and database objects." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"Includes statements such as CREATE, ALTER, and DROP to work with objects such as tables. DDL modifies the structure of the objects in a database instead of the contents of the objects." (Bob Bryla, "Oracle Database Foundations", 2004)

"A language, usually part of a database management system, that is used to define all attributes and properties of a database, especially row layouts, column definitions, key columns (and sometimes keying methodology), file locations, and storage strategy." (Thomas Moore, "MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005", 2006)

"Commands supported by a database that enable the creation, removal, or modification of structures (such as relational tables or classes) within it." (Pramod J Sadalage & Scott W Ambler, "Refactoring Databases: Evolutionary Database Design", 2006)

"Commands used to change metadata. In some databases, these commands require a COMMIT command; in other database engines, this is not the case. When a COMMIT command is not required, these commands automatically commit any pending changes to the database, and cannot be rolled back." (Gavin Powell, "Beginning Database Design", 2006)

"A component of structured query language (SQL) used to create and delete databases and database objects such as tables and indexes." (Sara Morganand & Tobias Thernstrom , "MCITP Self-Paced Training Kit : Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 - Exam 70-442", 2007)

"The language component of a DBMS that is used to describe the logical structure of a database." (S. Sumathi & S. Esakkirajan, "Fundamentals of Relational Database Management Systems", 2007)

"The SQL commands that deal with creating the database's structure such as CREATE TABLE, CREATE INDEX, and DROP TABLE." (Rod Stephens, "Beginning Database Design Solutions", 2008)

"A special-purpose computer language used to define the schema of a navigational database." (Jan L Harrington, "Relational Database Design and Implementation, 3rd Ed.", 2009)

"1.Generally, the subset of Structured Query Language commands used to define and implement structured database objects. 2.In Database Management Systems, the specific definitions to formally define and implement a database." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"The language that allows a database administrator to define the database structure, schema, and subschema." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management" 9th Ed., 2011)

"A language that defines all attributes and properties of a database, especially record layouts, field definitions, key fields, file locations, and storage strategy." Microsoft, "SQL Server 2012 Glossary", 2012)

"SQL statements used for creating and modifying data structures, e.g., CREATE, ALTER, and DROP." (Craig S Mullins, "Database Administration: The Complete Guide to DBA Practices and Procedures" 2nd Ed. , 2012)

"SQL statements used for creating and modifying data structures, e.g., CREATE, ALTER, and DROP." (Craig S Mullins, "Database Administration", 2012)

"A language for describing data and its relationships in a database. See also Data Manipulation Language, relational database management system." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)


No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.