Term of the Day

“Relational Database”

Definition — What is a Relational Database?

Databases are an essential component of almost every piece of software today. A relational database is a type of database that uses a structure that allows us to identify and access data in relation to another piece of data in the database. RDBs establish a well-defined relationship between database tables. Tables communicate and share information, which facilitates data searchability, organization and reporting.

RDBs use Structured Query Language (SQL), which is a standard user application that provides an easy programming interface for database interaction.

In a relational database, each row in the table is a record with a unique ID called the key. The columns of the table hold attributes of the data, and each record usually has a value for each attribute, making it easy to establish the relationships among data points.

Benefits of Relational Databases:

• Data Consistency
  
• Commitment and Atomicity
  
• Stored Procedures and Relational Databases
  
• Database Locking and Concurrency
  

Check this article to learn more about Relational Database.

In ServiceDesk Plus, you can access the data model from Reports  > Data Model.