Printer Friendly
The Free Dictionary
1,036,482,618 visitors served.
?
Dictionary/
thesaurus
Medical
dictionary
Legal
dictionary
Financial
dictionary
Acronyms
 
Idioms
Encyclopedia
Wikipedia
encyclopedia
?

relational query

   Also found in: Wikipedia, Hutchinson 0.03 sec.

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.


?Page tools
Printer friendly
Cite / link
Email
Feedback
? Mentioned in ? References in periodicals archive
 
The validation test was run on Hyperion System 9 BI+ Interactive Reporting, a module of Hyperion System 9 that provides executives, business users and analysts with the most intuitive user-directed relational query and analysis capabilities available today.
Using this platform, customers may address their entire spectrum of Business Intelligence needs--data integration, relational query and reporting, as well as simple and advanced analysis--all through a Linux-based solutions.
The new ODBO interface means that QueryObject's can now support simultaneous use by a whole variety of popular Business Intelligence tools using either the traditional relational query style via ODBC or JDBC, or full multi-dimensional analysis via OLE/DB for OLAP," Thompson added.
 
Encyclopedia browser? ? Full browser
 
 
Encyclopedia
?

Disclaimer | Privacy policy | Feedback | Copyright © 2008 Farlex, Inc.
All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.. Terms of Use.