relational database

This definition is part of our Essential Guide: Oracle ERP software implementation tips and trends

A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. The relational database was invented by E. F. Codd at IBM in 1970.

The standard user and application program interface to a relational database is the structured query language (SQL). SQL statements are used both for interactive queries for information from a relational database and for gathering data for reports.

In addition to being relatively easy to create and access, a relational database has the important advantage of being easy to extend. After the original database creation, a new data category can be added without requiring that all existing applications be modified.

A relational database is a set of tables containing data fitted into predefined categories. Each table (which is sometimes called a relation) contains one or more data categories in columns. Each row contains a unique instance of data for the categories defined by the columns. For example, a typical business order entry database would include a table that described a customer with columns for name, address, phone number, and so forth. Another table would describe an order: product, customer, date, sales price, and so forth. A user of the database could obtain a view of the database that fitted the user's needs. For example, a branch office manager might like a view or report on all customers that had bought products after a certain date. A financial services manager in the same company could, from the same tables, obtain a report on accounts that needed to be paid.

When creating a relational database, you can define the domain of possible values in a data column and further constraints that may apply to that data value. For example, a domain of possible customers could allow up to ten possible customer names but be constrained in one table to allowing only three of these customer names to be specifiable.

The definition of a relational database results in a table of metadata or formal descriptions of the tables, columns, domains, and constraints.

This was last updated in April 2006

Next Steps

Learn how to boost relational data base security with database security software and tools.

Read about the key criteria to consider before purchasing a relational DBMS and read reviews of the various products on the market to help you decide on the best RDBMS for your organization.

Purchasing criteria for database security tools.

Continue Reading About relational database

Join the conversation


Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

As I read the Bible on a daily basis I want to capture my thoughts of different words or topics to a 'database' so later I can search by either word, scripture reference, or my thoughts. Basically I want to build my own 'concordance' of my study. I want to be able to open, for instance, the topic of 'wind' where I have previously entered a scripture reference and add another reference under 'wind'. I understand that a database can do this, but I get confused by how to do this. Can anyone help?
I couldn't remember what a relational database was. Your definition sufficed! It was well written.

This was not helpful at all. You guys need to work on it and come up with new and more precise information. This kind of information is of no use. I hope you will take my feedback seriously.
Thank You.
Abdul Moiz

Hey! Me again xD
Can anyone here help me with DBMS?


File Extensions and File Formats