21 June 2009

DBMS: Row (Definitions)

"A set of related columns that describes a specific entity. Also called record." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)

"A data structure that is a collection of elements (columns), each with its own name and type. A row can be accessed as a collective unit of elements, or the elements can be accessed individually. A row is equivalent to a record." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"In a relational database table, a primary key value plus the associated values of each non-key column. The number of rows usually varies over time." (Bill Pribyl & Steven Feuerstein, "Learning Oracle PL/SQL", 2001)

"A record in a relational table." (Ralph Kimball & Margy Ross, "The Data Warehouse Toolkit 2nd Ed ", 2002)

"The collection of elements that form a horizontal line in the table. Each row in the table represents a single occurrence of the object modeled by the table and stores the values for all the attributes of that object." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"A group of one or more data elements in a database table that describes a person, place, or thing." (Bob Bryla, "Oracle Database Foundations", 2004)

"A single instance in a table. This is also called a record." (Sharon Allen & Evan Terry, "Beginning Relational Data Modeling" 2nd Ed., 2005)

"A group of related column values in a table. The corresponding formal database term is tuple." (Rod Stephens, "Beginning Database Design Solutions", 2008)

"An individual entry from a given table. For example, a table may contain details about thousands of customers; a specific customer’s data will be found in one row. See also record." (Robert D Schneider & Darril Gibson, "Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies", 2008)

"A horizontal line in the table that contains all attributes of a single object modeled in the table." (Jim Joseph, "Microsoft SQL Server 2008 Reporting Services Unleashed", 2009)

"In relational theory, a set of values for a specified set of attributes." (David C Hay, "Data Model Patterns: A Metadata Map", 2010)

"A group of data items treated as a unit by an application; a record; a tuple in relational database terminology." (Toby J Teorey, ", Database Modeling and Design" 4th Ed., 2010)

"A set of column values describing one logical instance in a relational database table. Technically called a tuple in relational calculus. Equivalent to a record in a flat file." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"A set of column values describing one logical instance in a table." (Craig S Mullins, "Database Administration", 2012)

"The horizontal component of a table, consisting of a sequence of values, one for each column of the table." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
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.