relational query


Also found in: Dictionary, Thesaurus.

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.
Copyright © 1981-2019 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.
References in periodicals archive ?
It took database researchers more than 20 years to develop efficient query optimization and execution methods for relational query languages.
Extensible enumeration of feasible joins for relational query optimization.
The value of declarativenes in relational query languages like SQL (the most common such language) has been amply demonstrated, and an extension of the idea to the next generation of query languages is desirable.
We then describe the translation of the OSH into Structured Query Language (SQL), a relational query language.
Among several relational query languages, we have chosen SQL as the uniform user interface because SQL is widely used and there is a movement to make SQL a standard relational query language.
This would be followed by operations that can handle sequences as standard relational query languages handle relations.

Full browser ?