01 April 2009

🛢DBMS: Column (Definitions)

"The logical equivalent of a field. A column contains an individual data item within a row or record." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)

"In a SQL database table, the area, sometimes called a field, in each row that stores the data about an attribute of the object modeled by the table (for example, the ContactName column in the Customers table of the Northwind database). Individual columns are characterized by their maximum length and the type of data that can be placed in them. A column contains an individual data item within a row." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"A named portion of a table that can hold some number of data values of a particular datatype. Columns usually have some maximum width or number of bytes. The names and datatypes of a table's columns typically do not vary over time." (Bill Pribyl & Steven Feuerstein, "Learning Oracle PL/SQL", 2001)

"The area in each row that stores the data value for some attribute of the object modeled by the table." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"The component of a database table that contains all of the data of the same name and type across all rows." (Bob Bryla, "Oracle Database Foundations", 2004)

"A piece of data that may be recorded for each row in a table. The corresponding formal database term is attribute." (Rod Stephens, "Beginning Database Design Solutions", 2008)

"Stored within tables, a column contains a particular piece of information." (Robert D Schneider & Darril Gibson, "Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies", 2008)

"In a table, the area in each row that stores the data value for some attribute of the object presented in the table. For example, in an Employee table, a FirstName column would contain the first name of an employee." (Jim Joseph, "Microsoft SQL Server 2008 Reporting Services Unleashed", 2009)

"A data attribute as implemented in a relational database as a vertical component of a table, similar to a field in a flat file record." (Craig S Mullins, "Database Administration", 2012)

"The area in each row of a database table that stores the data value for some attribute of the object modeled by the table." (Microsoft, "SQL Server 2012 Glossary", 2012)

"A column is the data structure for storing a single value in a column family database." (Dan Sullivan, "NoSQL for Mere Mortals", 2015)

"The vertical component of a database table. A column has a name and a particular data type (for example, character, decimal, or integer)." (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.