The term “Database Hierarchy” typically refers to the organization and structure of data within database systems. It outlines different levels of data granularity, organization, and abstraction. Here’s a standard breakdown of the hierarchy from the smallest unit to the more complex organizational structures:
Bit:
- Definition: The most basic unit of data storage, representing either a 0 or 1 in the binary system.
Byte:
- Definition: Consists of 8 bits. A byte can represent a single character in many character encoding schemes, like ASCII.
Field:
- Definition: Represents a single data element or attribute for a record. For instance, “First Name” or “Date of Birth”.
- Example: In a “Customer” record, the “Address” field might contain the value “123 Main St”.
Record (or Row):
- Definition: A collection of related fields. It can be thought of as a single entry or instance in a database table.
- Example: A “Customer” record might include fields like “First Name”, “Last Name”, and “Address”.
File (or Table):
- Definition: A collection of related records. In relational databases, this is often referred to as a table.
- Example: A “Customers” table would contain many individual customer records.
Database:
- Definition: A structured collection of data. In the context of relational databases, a database is a collection of related tables/files. In other types of databases, the structure might vary, but it essentially contains organized, related data sets.
- Example: A retail system database might have separate tables for “Customers”, “Products”, “Orders”, and “Inventory”.
Database Management System (DBMS):
- Definition: Software that allows users to define, create, maintain, and control access to the database. Examples include MySQL, Oracle, and Microsoft SQL Server.
This hierarchy provides a framework for understanding how individual pieces of data are structured and organized within larger systems. It’s especially relevant in the context of relational database design and management.
Key terms in plain language
Open a term for a concise explanation of language used on this page.
Cloud Computing
Computing resources—such as applications, servers, storage, or databases—delivered from remote infrastructure and scaled as requirements change.
Infrastructure as a Service (IaaS)
Cloud-based servers, storage, and networking that customers configure and manage without owning the underlying data-center hardware.
Software as a Service (SaaS)
Software accessed as an online service instead of being installed and maintained entirely on the customer’s own computers or servers.
Disaster Recovery (DRaaS)
A plan and service for restoring applications, data, and operations after an outage or disruption. DRaaS provides recovery infrastructure through a managed cloud service.
Identity and Access Management (IAM)
The systems and policies that determine who a user is, what resources they may access, and how that access is authenticated and reviewed.
API
An application programming interface is a defined way for software systems to exchange data or request functions from one another.