Showing posts with label rows. Show all posts
Showing posts with label rows. Show all posts

22 June 2009

DBMS: Record (Definitions)

"A group of related fields (columns) of information treated as a unit. A record is more commonly called a row in a SQL database." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"A row in a database table." (Bill Pribyl & Steven Feuerstein, "Learning Oracle PL/SQL", 2001)

"An aggregation of values of data organized by their relation to a common key." (William H Inmon, "Building the Data Warehouse", 2005)

"In relational databases, a single instance in a table. In the context of hierarchical and network databases, a record is a data structure." (Sharon Allen & Evan Terry, "Beginning Relational Data Modeling" 2nd Ed., 2005)

"A repetition of a field structure across a table. Records repeat field structure in a table, where each repeated field can (and sometimes should) have a different value. Tables are divided into fields and records. Fields impose structure and datatype specifics onto each of the field values, in each record." (Gavin Powell, "Beginning Database Design", 2006)

"This is a group of related fields containing information about a single entity." (Joseph L Jorden & Dandy Weyn, "MCTS Microsoft SQL Server 2005: Implementation and Maintenance Study Guide - Exam 70-431", 2006)

"A grouping of information typically returned from a query or other database operation. It can consist of data from only one table or be an aggregation of information dispersed among many tables" (Robert D Schneider and Darril Gibson, "Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies", 2008)

"In a file processing system, a collection of data that describes one instance of an entity." (Jan L Harrington, "Relational Database Design and Implementation" 3rd Ed., 2009)

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

"A collection of related (logically connected) fields." (Carlos Coronel et al, "Database Systems: Design, Implementation, and Management 9th Ed", 2011)

"Related characters combined into a field or related fields, such as vendor name, address, and account data." (Linda Volonino & Efraim Turban, "Information Technology for Management 8th Ed", 2011)

"A set of related data values in a file or stream, often associated with a unique key field." (Jon Orwant et al, "Programming Perl" 4th Ed., 2012)

"The physical representation of data about an instance in a flat file." (Craig S Mullins, "Database Administration: The Complete Guide to DBA Practices and Procedures 2nd Ed", 2012)

"A unit of data that typically contains keys and attributes" (Daniel Linstedt & W H Inmon, "Data Architecture: A Primer for the Data Scientist", 2014)

"A collection of related data items." (Adam Gordon, "Official (ISC)2 Guide to the CISSP CBK" 4th Ed., 2015)

"A collection of related fields in a table. In Excel, each record goes into a separate row." (E C Nelson & Stephen L Nelson, "Excel Data Analysis For Dummies ", 2015)

"A row in a table, storing information about a specific person, place, or thing." (Faithe Wempen, "Computing Fundamentals: Introduction to Computers", 2015)

"In a relational database, a single set of values in a table. For example, a particular student’s data would be contained in a record in the Students table. Also called rows or tuples." (Rod Stephens, "Beginning Software Engineering", 2015)

"A collection of related fields that make up a single database entry" (Nell Dale & John Lewis, "Computer Science Illuminated" 6th Ed., 2015)

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)

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.