https://DevOpsCloud.io -- Cloud Monk Losang Jinpa, Ph.D., MCSE/MCT, GitOps DevOps Engineer

Return to Record, Columns, Fields

A database record, also called a row (database) or a tuple is a set of fields in a database related to one entity

In databases, a record, often referred to as a row, represents a single, structured data entry that holds values for each column in a table. Each record typically corresponds to one entity or object, such as a user, product, or transaction. The values in each record are aligned with the columns of the table, and the arrangement of these values provides detailed information about that entity. For example, in a customer table, a record or row may contain information like customer_id, name, email, and address. The use of rows allows the database to represent multiple records of similar types, each with unique attributes stored in the columns.

https://en.wikipedia.org/wiki/Row_(database)

Each record or row within a database table is uniquely identified by a primary key, which ensures that each entry is distinct. A primary key typically consists of one or more columns that have unique values across all records in the table. This uniqueness allows for efficient queries and retrieval of data. For example, a row representing a customer may be uniquely identified by the customer_id, ensuring that even if there are multiple entries for the same customer, they can be differentiated easily. In relational databases, the concept of a record or row is essential for maintaining data integrity and consistency.

https://www.oracle.com/database/what-is-a-relational-database.html

When databases grow in size, the number of records or rows can increase dramatically, leading to challenges in performance and scalability. Optimizing the storage and retrieval of rows is critical, especially when working with large datasets. Indexes are often created on specific columns in tables to speed up the process of querying and sorting records. Additionally, database operations like joins and aggregations often work by matching and comparing records across different tables. The design and structure of rows are therefore integral to the overall efficiency and effectiveness of the database system.

https://en.wikipedia.org/wiki/Primary_key

Snippet from Wikipedia: Row (database)

In a relational database, a row or "record" or "tuple", represents a single, implicitly structured data item in a table. A database table can be thought of as consisting of rows and columns. Each row in a table represents a set of related data, and every row in the table has the same structure.

For example, in a table that represents companies, each row might represent a single company. Columns might represent things like company name, address, etc. In a table that represents the association of employees with departments, each row would associate one employee with one department.

The implicit structure of a row, and the meaning of the data values in a row, requires that the row be understood as providing a succession of data values, one in each column of the table. The row is then interpreted as a relvar composed of a set of tuples, with each tuple consisting of the two items: the name of the relevant column and the value this row provides for that column.

Each column expects a data value of a particular type.

For example, one column might require a unique identifier, another might require text representing a person's name, another might require an integer representing hourly pay in dollars.

Creative Commons Attribution-Share Alike 4.0

Database | Database management system:

• Object database | Object-oriented
  • Comparison of object database management systems | comparison
• Relational_database | Relational
  • List of relational database management systems | list
  • Comparison of relational database management systems | comparison
• Key-value_database | Key-value
• Column-oriented DBMS | Column-oriented
  • List_of_column-oriented_DBMSes | list
• Document-oriented database | Document-oriented
• Wide_column_store | Wide column store
• Graph database | Graph
• NoSQL
• NewSQL
• In-memory_database | In-memory
  • List_of_in-memory_databases | list
• Multi-model_database | Multi-model
  • Comparison_of_multi-model_databases | comparison
• Cloud_database | Cloud

Database Concepts:

• Database
• ACID
• Armstrong's axioms
• Codd's_12_rules | Codd's 12 rules
• CAP theorem
• Create, read, update and delete | CRUD
• Null (SQL) | Null
• Candidate key
• Foreign key
• Superkey
• Surrogate key
• Unique key

Database Objects:

• Relation (database) | Relation
  • Table (database) | table
  • Column (database) | column
  • Row (database) | row
• View (SQL) | View
• Database transaction | Transaction
• Transaction log
• Database trigger | Trigger
• Database index | Index
• Stored procedure
• Cursor (databases) | Cursor
• Partition (database) | Partition

Database Components:

• Concurrency control
• Data dictionary
• Java Database Connectivity | JDBC
• XQuery API for Java | XQJ
• Open Database Connectivity | ODBC
• Query language
• Query optimization | Query optimizer
• Query Rewriting | Query rewriting system
• Query plan

Database Functions:

• Database administration | Administration
• Query optimization
• DATABASE | Replication
• Shard_(database_architecture) | Sharding

Related Topics:

• Database models
• Database normalization
• Database storage structures | Database storage
• Distributed database
• Federated database system
• Referential integrity
• Relational algebra
• Relational calculus
• Relational database
• Relational model
• Object-relational database
• Transaction processing

Category:Database_management_systems | Category

Outline of databases