SearchSQLServer.com Definitions (Powered by WhatIs.com)
relational database
definition -
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.
Learn more about SQL Server 2000
-
Tutorial: Learn SQL Server basics from A-Z
Tutorial - If you're having issues with the basics of SQL Server, this learning guide will be the refresher you need. With a wide range of topics, these tutorials and tips will help you relearn SQL Server from... -
Track changes to SQL Server 2000 and 2005 with one simple utility
Tip - As a DBA, you need to be aware of what's happening within your SQL Servers. But if you have dozens of SQL Servers -- both 2000 and 2005 models -- and permissions are shared, you'll have to go beyond... -
FAQ: Creating and altering SQL Server tables
FAQ - Whether you want to select rows, move records, track activity or perform various other table-related tasks, this collection of frequently asked questions offers expert insights to help. -
Chapter Download: Essential SQL Server 2000 maintenance
Chapter Download - This chapter from the book, Essential SQL Server 2000, by Buck Woody discusses two types of maintenance tasks: tasks that keep the database going and tasks that keep the database going fast -
Learning Guide: SQL Server basics
Learning Guide - SQL Server is gaining ground in the database space. As more companies turn to the DBMS hyped as the low-cost big player, more DBAs will have to learn its intricacies. With that in mind, we created... -
Track changes to SQL Server 2000 and 2005 with one simple utility
Tip - As a DBA, you need to be aware of what's happening within your SQL Servers. But if you have dozens of SQL Servers -- both 2000 and 2005 models -- and permissions are shared, you'll have to go beyond... -
Problems running SQL Server 2000 RTM without service pack
Ask the Expert - Business Intelligence expert Eric Brown helps troubleshoot database growth problems.
last updated18 Aug 1998
Do you have something to add to this definition? Let us know.
Send your comments to techterms@whatis.comMore resources from around the web:
SQL Solutions - SQL Database Design