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-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Cool Tools - What is your Twitter grade?
- HubSpot has launched what it is calling the Twitter Grader, which seems to be the now-defunct Tweeterboard reincarnate -- yet with a proposed business purpose. The grader allows Twitter users to enter in their screen names and the names of others into its secret algorithmic stuff generator and find out...
- Blog posts 2008-08-29
- The biggest health tech story of our time
- It's the sort of work politicians have been doing for decades, only with much greater depth, because the database is deeper, and with a purely scientific motivation. by Dana Blankenhorn
- Blog posts 2008-08-29
- Oncilla Excel2Text (exe)
- Oncilla Excel2Text is a tool to convert Excel files to Text files. The Text files can be in any of the following formats UTF8, ANSI or Unicode little endian. The tool lets you perform this conversion with out using MS Excel, it does not require that MS Excel be installed...
- Software downloads 2008-08-28
- Easy Tracker 2008 Enterprise (exe)
- Easy Tracker 2008 Enterprise edition is a full-featured time and expense tracking suite designed specifically for project & expense management, schedule notification and work measurement. Basing on SQL server database, it suits teams and companies specially. It provides convenient task assignment and timesheet entries for team members; simple approving process...
- Software downloads 2008-08-28
- Shopping Companion (exe)
- Shopping Companion allows you to keep a database of items and print out shopping lists. The database-driven system allows you to manage multiple shopping trips. Changes are automatically saved preventing data loss if computer shuts down or locks up. The database has fields for store, aisle, product, brand, category, size,...
- Software downloads 2008-08-28
- SuperOrca (exe)
- SuperOrca is a direct replacement to the Orca utility from Microsoft. SuperOrca may be used to examine and modify an MSI database. SuperOrca can be freely downloaded from the Internet, no need to download and install the entire Microsoft SDK. SuperOrca - will allow you to scan and manipulate all...
- Software downloads 2008-08-28
- EZ-Metrix (zip)
- EZ-Metrix is a source code metrics utility with a difference. It's like a tape measure for your software. With an easy Internet-based interface, multiple language support and flexible licensing features, you will be up and running in minutes with the EZ-Metrix code counter. Measure software size from virtually all text-based...
- Software downloads 2008-08-28
- ImVajra Password Manager (exe)
- ImVajra Password Manager stores your passwords, logins, credit card numbers, and any other confidential and precious data in top security level to prevent unauthorized users from accessing and viewing. You can log into your database with password, USB flash disk or both to secure and protect your personal info better...
- Software downloads 2008-08-28
- Internet Explorer 8 Beta 2 vs. Firefox 3.0.1
- Internet Explorer 8 Beta 2 vs. Firefox 3.0.1All part of the MS plan to keep browsers dumbded down. If we had reallygood browsers, how would they get people to use MS proprietary solutions for rich internet applications.RE: Internet Explorer 8 Beta 2 vs. Firefox 3.0.1The title says Firefox 3.0.1The graph...
- Discussion threads 2008-08-27
- Databases leverage MapReduce technology to radically juice data scale, performance, analytics
- Databases leverage MapReduce technology to radically juice data scale, performance, analyticsAster In-Database MapReduce Available NowDana - great article – thanks for covering this. Many agree this is a game-changing innovation for the database industry. I'd just like to point out: [1] Aster In-Database MapReduce is available now for evaluation...
- Discussion threads 2008-08-27
- Maxs (zip)
- With this program you can see all user connected to an access database. Step-by-step: Open maxs.exe2, select only .mdb or .ldb files and click view. This program is in 2 languages: Italian and English. This version is the first release on CNET Download.com.
- Software downloads 2008-08-27
- Huagati DBML/EDMX Tools (zip)
- Huagati DBML Tools is an add-in for Visual Studio that adds functionality to the Linq2SQL/DBML diagram designer in Visual Studio 2008, adding options for comparing and synchronizing Linq2SQL designer diagrams with the database, for updating classes and properties generated using the Linq to SQL designer or Entity Framework designer to...
- Software downloads 2008-08-27
- Feel like taunting an identity thief? Don't.
- Feel like taunting an identity thief? Don't.SurprisingI am a little surprised they would even bother to do this. But not very surprised.I have never been tempted to 'taunt' them in the first place. What I have been tempted to do is send them false information, preferably from an automated source,...
- Discussion threads 2008-08-26
- Patent suit alert: This time, Google and Verizon on the hot seat
- Inventor Judah Klausner has settled with the best of them: AT&T, Apple, Comcast and eBay. Now, he's taking Google, Verizon, Cox and LG to court for infringing on his patents for visual voicemail technology. A Reuters story highlights some of his past legal battles, including a June...
- Blog posts 2008-08-26
- Failed government IT: 'The mother of all databases'
- Failed government IT: 'The mother of all databases'Just another reason to keep government smallThis is just another example of how incompitant our government can be. This is a huge problem all over the government and it is wasting billions of our hard earned money while some would like to...
- Discussion threads 2008-08-26
- Does TraceMonkey kick Firefox into turbo mode?
- Does TraceMonkey kick Firefox into turbo mode?Wow, we are breaking down the barriers to web application adoption for allof our every day applications. The speed here will be so close to natively compiled code that it will not matter any more. But, we still need some kind of a sandboxed...
- Discussion threads 2008-08-26
- MyPersonalDiet (Smartphone) (exe)
- MyPersonalDiet is the most comprehensive diet software for Windows Mobile Smartphone that gives you the tools to reach you weight goal by providing simple means of tracking your food and workouts, monitor your health and get clear assessments of your efforts and results. MyPersonalDiet will not burn calories for you,...
- Software downloads 2008-08-26
- MyPersonalDiet (Pocket PC) (exe)
- MyPersonalDiet is the most comprehensive diet software for Pocket PC that gives you the tools to reach you weight goal by providing simple means of tracking your food and workouts, monitor your health and get clear assessments of your efforts and results. MyPersonalDiet will not burn calories for you, but...
- Software downloads 2008-08-26
- Amphis - Customer (msi)
- Amphis - Customer is a customer database that makes it easier to generate quotes and invoices, manage your email, keep track of who owes you money, send reminders, store correspondence and sales history. Email templates allow you to send standard emails and standard email replies including attachments. Reminders help you...
- Software downloads 2008-08-26
- Does Big Brother know where you've been surfing?
- Does Big Brother know where you've been surfing?microsoft.com & msdn, plus some weird gothic stuff knowing you:PRE: Does Big Brother know where you've been surfing?It'd be easier if my ISP asked me which porn sites I was going to instead of doing the deep packet sniffing. I'd be glad to...
- Discussion threads 2008-08-25
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Marc Canter: The master of multimedia speaks
-
In this Super Techies interview, larger-than-life techie Marc Canter talks with ZDNet's Editor in Chief Dan Farber about his career as a multimedia pioneer.
- Watch the video >>
- Demo: Virtualization with the Intel® Xeon® Processor
-
In this Flash demo, you'll learn about virtualization performance and features ideal for consolidation, load balancing, and disaster recovery with leading enterprise reliability.
- Watch how the Intel Xeon processor can increase performance and reliability of your servers >>
Ultraportables
- Understanding Ultraportable Laptops (BNET)
- Five steps to protect mobile devices anywhere, anytime (TechRepublic)
- View all ZDNet Toshiba laptop reviews
- From our sponsors
- Toshiba Satellite® U400 Series
-
- The ultra-portable, ultra-stylish Satellite® U405 is a smart choice for you and your small business. Only from the laptop expert, Toshiba. Explore the complete laptop lineup »
-
