Management of schemas

A schema, also known as a database schema, defines how data is structured, organized, and managed in a database management system (DBMS). It outlines the format, storage, processing, security, and data access across various structural schema elements such as tables, views, and logical constraints.

The following sections provide an overview of how schema concepts are applied within Test Hub to support efficient data management and test design:

Using schema in Test Hub

  • You can create a new schema either as an empty structure or by connecting it to an existing database, allowing you to visualize how data is structured and related in real environments. See Creating an empty schema and Creating a schema by using a database connection.
  • After the schema is created, two separate tabs are displayed based on the database connection:
    • Database View
    • Schema View
  • You can add data definitions and establish relationships between their fields in a schema.

Key benefits of schema in Test Hub

The schema in Test Hub offers the following advantages:
  • It defines how data is stored and related within the database, making it easier to understand, manage, and maintain.
  • You can group similar data to reuse it across different scenarios, even when it serves different purposes.
  • You can enhance data integrity by using logical constraints such as tables, primary keys, and relationships that helps maintain data consistency and accuracy while reducing errors.

To use schema in Test Hub, you must be aware of the terms and concepts that are used to link database tables.

Primary key

A primary key is one or more columns in a database table that uniquely identify each record in that table. The primary key enforces data integrity by ensuring that no two rows have the same value(s) in the key column(s) and that these values are never null. Database systems use the primary key to efficiently retrieve, update, or relate records across multiple tables in a relational database.

Foreign key

A foreign key is a link between two tables that ensures the data in one table corresponds with the data in another table, thereby maintaining uniformity of the database information.