Alan Freedman -- The Computer Language Company - Computer Desktop Encyclopedia
Computer Desktop Encyclopedia
Longest-Running Tech Reference on the Planet

A CDE Definition

You'll love The Computer Desktop Encyclopedia (CDE) for Tech Term of the Day (TTOD)

LOOK UP ANOTHER TERM


relational query

A question asked about data contained in two or more tables in a relational database. The relational query must specify the tables required and what the condition is that links them; for example, matching account numbers. Relational queries are tricky to specify because even the simplest of questions may require data from two or more tables. Both the knowledge of the query language and the database structure is necessary. Even with graphical interfaces that let you drag a line from one field to another, you still need to know how the tables were designed to be related.




An Early Relational Query
In the mid-1980s, Paradox was the first DBMS on a PC that made linking tables easier. Although not as sophisticated as today's methods, the ability to associate relationships by typing sample words was a breakthrough. The Customer No. and Part No. fields are related by "ABC" and "XYZ." Any words would suffice as long as they are the same.






Personal Use Only

Before/After Your Search Term
BeforeAfter
Reiser4relative address
ReiserFSrelative link
related filesrelative movement
relationalrelative path
relational algebrarelative reference
relational calculusrelative URL
relational databaserelative vector
relational DBMSRELAX NG
relational modelrelay
relational operatorRelay Gold

Terms By Topic
Click any of the following categories for a list of fundamental terms.
Computer Words You Gotta KnowSystem design
Job categoriesUnix/Linux
Interesting stuffPersonal computers
InternetIndustrial Automation/Process Control
Communications & networkingAssociations/Standards organizations
HistoryDesktop publishing
Audio/VideoGraphics
MainframesSecurity
ProgrammingHealthcare IT
System design