A database that maintains a set of separate, related files (tables), but combines data elements from the files for queries and reports when required. The concept was developed in 1970 by Edgar Codd, whose objective was to accommodate a user's ad hoc request for selected data. Most every business database management system (DBMS), including Oracle, DB2, SQL Server, MySQL, etc., is a relational DBMS (RDBMS) (see DBMS).
Hierarchical, Network and Object Databases
In non-relational "hierarchical" and "network" databases, records in one file contain embedded pointers to the locations of records in another, such as customers to orders and vendors to purchases. These are fixed links set up ahead of time to speed up daily processing. Another type of non-relational database is the "object database," which stores data consistent with their object model (see object database).
Comparing and Joining
Routine queries to a relational database often require data from more than one file. For example, to obtain the names of customers who purchased a particular product, data must be extracted from both the customer and order files. A relational DBMS has the flexibility to "join" two or more files by comparing key fields such as account number and name and generating a new file from the records that meet the matching criteria (see join).
Indexes Are Used
In practice, a pure relational query can be very slow. In order to speed up the process, indexes are built and maintained on the key fields used for matching. Sometimes, indexes are created "on the fly" when the data are requested.
Hierarchical, Network and Object Databases
In non-relational "hierarchical" and "network" databases, records in one file contain embedded pointers to the locations of records in another, such as customers to orders and vendors to purchases. These are fixed links set up ahead of time to speed up daily processing. Another type of non-relational database is the "object database," which stores data consistent with their object model (see object database).
Comparing and Joining
Routine queries to a relational database often require data from more than one file. For example, to obtain the names of customers who purchased a particular product, data must be extracted from both the customer and order files. A relational DBMS has the flexibility to "join" two or more files by comparing key fields such as account number and name and generating a new file from the records that meet the matching criteria (see join).
Indexes Are Used
In practice, a pure relational query can be very slow. In order to speed up the process, indexes are built and maintained on the key fields used for matching. Sometimes, indexes are created "on the fly" when the data are requested.
Relational Terms Common Terms
Table or Relation File
Row or Tuple Record
Attribute or Field Field
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- RazorSQL 5.0.2 (Mac)
- Query, edit, browse, and manage all major databases from one database tool. RazorSQL OSX is a universal database query tool, programming and sql editor, database navigator, and administration tool with built-in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite,...
- Software downloads 2009-11-18
- Altova MissionKit for Enterprise Software Architects 2010 (Windows)
- The Altova MissionKit 2010 for Enterprise Software Architects is an integrated suite of XML, database, and UML tools from the developers of XMLSpy. It delivers eight tools for less than the price of two! The Altova MissionKit for Enterprise Software Architects includes Enterprise Editions of Altova XMLSpy, MapForce, StyleVision, UModel,...
- Software downloads 2009-11-17
- Data services may help address a major SOA unknown -- data quality
- The technology to do all this already exists......it's called a relational database management system.
- Discussion threads 2009-11-16
- Altova XMLSpy Professional Edition 2010 (Windows)
- Altova XMLSpy 2010 Professional Edition is the industry-leading XML editor and XML development environment, with intuitive editing views and powerful XML utilities to model, edit, transform, and debug XML-related technologies quickly and easily. In addition to the world's most popular XML editor, XMLSpy Professional includes a graphical XML Schema editor...
- Software downloads 2009-11-16
- Altova XMLSpy Enterprise Edition 2010 (Windows)
- Altova XMLSpy 2010 Enterprise Edition is the industry's best-selling XML editor and XML development environment for modeling, editing, transforming, and debugging XML technologies. In addition to the world's leading XML editor, XMLSpy includes a powerful graphical XML Schema editor that allows you to design complex schemas with ease. Advanced error...
- Software downloads 2009-11-16
- JumpBox for the MySQL Relational Database 1.1.11 (Mac)
- MySQL is probably the most widely used relational databases around. It's used as an integral component in many JumpBoxes and is also useful to have available in an easy to use standalone version. This JumpBox includes MySQL 5 along with PHPMyAdmin setup and ready to run. It's a great tool...
- Software downloads 2009-10-30
- JumpBox for the MySQL Relational Database 1.1.11 (Windows)
- MySQL is probably the most widely used relational databases around. It's used as an integral component in many JumpBoxes and is also useful to have available in an easy to use standalone version. This JumpBox includes MySQL 5 along with PHPMyAdmin setup and ready to run. It's a great tool...
- Software downloads 2009-10-30
- JumpBox for the PostgreSQL Relational Database Management System 1.1.5 (Mac)
- PostgreSQL is a powerful, open source object-relational database system that's been under active development for over 15 years. An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control MVCC, point in time recovery, tablespaces, asynchronous replication, nested transactions savepoints, online/hot backups, a sophisticated query planner/optimizer, and write...
- Software downloads 2009-10-29
- JumpBox for the PostgreSQL Relational Database Management System 1.1.5 (Windows)
- PostgreSQL is a powerful, open source object-relational database system that's been under active development for over 15 years. An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control MVCC, point in time recovery, tablespaces, asynchronous replication, nested transactions savepoints, online/hot backups, a sophisticated query planner/optimizer, and write...
- Software downloads 2009-10-29
- News to know: L.A. goes Google; AMD-Galleon; Cisco-ScanSafe; Ubuntu; Amazon RDS
- Here are today's notable headlines. You can get News To Know via email alert and RSS daily. For continuous updates see BNET's around-the-Web tech coverage.: Larry Dignan: WSJ: AMD's former CEO was a Galleon tipster Sam Diaz: Cisco continues its buying spree with...
- Blog posts 2009-10-28
- Amazon launches relational database service: Think MySQL in the cloud
- Three reasons this is a bad paradigm...Security, security and...let's see, what was that other thing...oh yeah, security. The comment "enterprise customers are likely to take their time moving sensitive data into Amazon?s RDS effort" should be nominated for the understatement of the year award. What's more likely is...
- Discussion threads 2009-10-27
- Amazon launches relational database service: Think MySQL in the cloud
- Amazon on Tuesday launched a public beta of a service dubbed the Amazon Relational Database Service RDS. The main appeal: Allow customers to operate and scale database clusters while leaving pesky tasks like patching and administration to Amazon Web Services. Adam Selipsky, vice president of Amazon Web...
- Blog posts 2009-10-27
- Aqua Data Studio 8.0.2 (Mac)
- Aqua Data Studio is a database developer's complete Integrated Development Environment IDE. The IDE provides three major areas of functionality: A) Database query and administration tool, B) a Suite of compare tools for databases, source control and filesystems and C) a complete and integrated source control client for Subversion SVN...
- Software downloads 2009-10-23
- Orac 1.0.1 (Mac)
- What is it ? Orac is an advanced but simple to use Apple Mac OSX Database tool for the Querying, Management and Maintenance of Relational Database Systems. Orac supports the following databases: Oracle 8i, 9i, 10g, 11g SQLite REALSQL Server Coming Soon More to Follow ... Who's it For ?...
- Software downloads 2009-10-20
- Story Shark 3.0 (Windows)
- There's no product that ties your story together like Story Shark! It let's you visually see your characters, settings, plot points, and timeline as you write. Synchronizes Your Characters, Plot Points, and Scenes as You Write. Timelines your story from a birds-eye view to the kitchen sink. Outlines your story...
- Software downloads 2009-10-15
- MailSteward 8.2.6 (Mac)
- MailSteward will archive all of your e-mail in a database for easy retrieval. Click on the Store Email button and MailSteward will go to work storing copies of all your e-mail text, HTML, attachments, and raw source, into a relational database file. MailSteward has a wealth of features for importing,...
- Software downloads 2009-09-28
- The 2010 Productivity Tool Bonanza - Microsoft, Google, Zoho & Open Standards
- On the eve of what looks to be a major Microsoft productivity products year in 2010 with the Windows 7 operating system, Exchange 2010, Office 2010, MOSS/SharePoint 2010 and Azure it's interesting to look at how the market for these products serve has changed. ...
- Blog posts 2009-09-25
- Genius Connect 4.0.0.9 (Windows)
- GeniusConnect will synchronize Outlook/Exchange data with any relational database that supports ODBC (MS Access, mySQL, MS SQL Server, Oracle...). A folder (calendar, contacts, mail, journal, notes, and tasks) can be linked to a database table or view. You can use your own table structure and define conversions for columns with...
- Software downloads 2009-09-22
- PostgreSQL 8.4.1 (Mac)
- PostgreSQL is a powerful, open source relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX,...
- Software downloads 2009-09-09
- Relational eXcel 3.2 (Windows)
- Relational eXcel is a tool to load data into your SQL server from Microsoft Excel, Access, or delimited text files. The data can then be previewed, loaded directly into your database, or saved as SQL script files. Although Relational eXcel can be used to directly import a table from a...
- Software downloads 2009-09-08
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Save time with automated shipping solutions
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Visit the UPS Business Essentials Guide
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
- The more you simplify, the more you save
-
When you transition from your existing Red Hat environment to SUSE Linux Enterprise from Novell, you can recognize dramatic cost savings, perhaps as much 50%
- Learn more >>
Popular Sanity Saver Videos
