Choose Index below for a list of all words and phrases defined in this glossary.


Relational Database

index | Index

Relational Database - definitions

Relational Database - 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 the need to reorganize the database tables.

[Category=Data Governance ]

Source: The Data Governance Institute, 21 December 2009 10:22:57, http://www.datagovernance.com/glossary-governance/ External


These advertisers support this free service


Relational Database - 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 the need to reorganize the database tables.

[Category=Information Management ]

Source: Information-Management.com, 04 July 2010 08:26:53, http://www.information-management.com/glossary/m.html External


Relational Database - 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 the need to reorganize the database tables.

[Category=Data Management ]

Source: DataMentors, 26 August 2010 10:12:01, http://www.datamentors.com/News-and-Resources/Glossary.html External


Relational Data Base - Stores data in such a way that it can be added to, and used independently of, all other data stored in the database. Users can query a relational database without knowing how the information has been organized. Although relational databases have the advantages of ease-of-use and analytical flexibility, their weakness can be slower retrieval speed. SQL (structured query language) is an interface to a relational database.

[Category=Geospatial ]

Source: Open Geospatial Consortium, 03 July 2011 09:18:36, http://www.opengeospatial.org/ogc/glossary External


relational database - [database structures] A data structure in which collections of tables are logically associated with each other by shared fields.

[Category=Geospatial ]

Source: esri, 31 July 2012 09:58:25, http://support.esri.com/en/knowledgebase/GISDictionary/term/abbreviation External


Relational Database - A collection of data items that is organized as a set of related tables from which data can be accessed or reassembled in many different ways without the need to reorganize the database tables.

[Category=Business Intelligence ]

Source: ElegantJ BI Business Intelligence, 04 November 2012 09:09:19, http://www.elegantjbi.com/resources/glossary_a.htm External 


relational database - 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.

[Category=Data Management ]

Source: WhatIs.com, 04 September 2013 09:15:18, http://whatis.techtarget.com/glossary/Data-and-Data-Management External

 

 


Data Quality Glossary.  A free resource from GRC Data Intelligence. For comments, questions or feedback: dqglossary@grcdi.nl