🔬Data Science: Data Modeling (Definitions)

"The task of developing a data model that represents the persistent data of some enterprise." (Keith Gordon, "Principles of Data Management", 2007)

"An analysis and design method, building data models to 

a) define and analyze data requirements,

b) design logical and physical data structures that support these requirements, and

c) define business and technical meta-data." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"The process of creating a data model by applying formal data model descriptions using data modeling techniques." (Christian Galinski & Helmut Beckmann, "Concepts for Enhancing Content Quality and eAccessibility: In General and in the Field of eProcurement", 2012)

"The process of creating the abstract representation of a subject so that it can be studied more cheaply (a scale model of an airplane in a wind tunnel), at a particular moment in time (weather forecasting), or manipulated, modified, and altered without disrupting the original (economic model)." (George Tillmann, "Usage-Driven Database Design: From Logical Data Modeling through Physical Schmea Definition", 2017)

"A method used to define and analyze the data requirements needed to support an entity’s business processes, defining the relationship between data elements and structures." (Solutions Review)

"A method used to define and analyze data requirements needed to support the business functions of an enterprise. These data requirements are recorded as a conceptual data model with associated data definitions. Data modeling defines the relationships between data elements and data structures. (Microstrategy)

"A method used to define and analyze data requirements needed to support the business functions of an enterprise. These data requirements are recorded as a conceptual data model with associated data definitions. Data modeling defines the relationships between data elements and structures." (Information Management)

"Refers to the process of defining, analyzing, and structuring data within data models." (Insight Software)

"Data modeling is a way of mapping out and visualizing all the different places that a software or application stores information, and how these sources of data will fit together and flow into one another." (Sisense) [source]

"Data modeling is the process of documenting a complex software system design as an easily understood diagram, using text and symbols to represent the way data needs to flow. The diagram can be used to ensure efficient use of data, as a blueprint for the construction of new software or for re-engineering a legacy application." (Techtarget) [source]

🛢DBMS: Data definition (Definitions)

"The process of setting up databases and creating database objects such as tables, indexes, rules, defaults, procedures, triggers, and views." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)

"A data definition specifies the attributes, properties, and objects in a database." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"Specification of data entities, including their attributes and relationships, in a coherent database structure to create a schema." (Sharon Allen & Evan Terry, "Beginning Relational Data Modeling" 2nd Ed., 2005)

"1.Statements that specify the business meaning associated with a conceptual, logical, or physical data entity or attribute. 2.The process of creating business meta-data, including names, meanings, integrity rules, and domain values. 3.In computer programming, the statements in a computer program that specify the physical attributes of the data to be processed, such as location and quantity of data." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"The attributes, properties, and objects in a database." (Microsoft, "SQL Server 2012 Glossary", 2012)

"An executable statement where a variable is assigned a value." (Software Quality Assurance)

🛢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)