To interrogate a collection of data such as records in a database. The term may also be used to search a single file or collection of files such as HTML files on the Web. However, in addition to obtaining lists of records that match the search criteria, queries to a database allow for counting items and summing amounts. A query on the Web yields only a list of matching pages and is more often called a "search."
For years, query and report programs have been the primary applications that produce output from information systems. A query implies an online request as required (look up that record), while a report implies a more elaborate printout with page headings and numbers that is typically produced at regular intervals such as end of month. See report writer.
Simple or Complex
Defining a query for a relational database can be extremely simple or very complex. If the query is based on one matching condition, such as "retrieve all customers who owe us more than $10,000," it is usually easy to define in a query language or program. However, "retrieve all customers who owe us more than $10,000 from purchasing toasters" is not easy. It requires several steps to determine how many toaster orders are in the balance due.
Tables Must Be Joined
Relational databases are designed to eliminate redundancy. The goal is to store a data item in one table and not have it duplicated in others. For example, an order record will contain the product number ordered, but often not its description. The description is stored in a product table. Thus, any printout of products ordered and their descriptions requires that the order table be linked to the product table for that query or report. Linking customer, order and product tables is a common example of "joining" tables to satisfy a query.
Contents of a Query
Most queries require at least the following conditions to be stated. First, which table or tables is the data coming from. If from two or more tables, what is the link between (typically account number or name). Next, define the selection criteria, which is the matching condition or filter. Lastly, define which fields in the tables are to be displayed or printed in the result. See SQL.
The Query Statement
This diagram depicts the typical conditions that have to be stated when querying a relational database.
For years, query and report programs have been the primary applications that produce output from information systems. A query implies an online request as required (look up that record), while a report implies a more elaborate printout with page headings and numbers that is typically produced at regular intervals such as end of month. See report writer.
Simple or Complex
Defining a query for a relational database can be extremely simple or very complex. If the query is based on one matching condition, such as "retrieve all customers who owe us more than $10,000," it is usually easy to define in a query language or program. However, "retrieve all customers who owe us more than $10,000 from purchasing toasters" is not easy. It requires several steps to determine how many toaster orders are in the balance due.
Tables Must Be Joined
Relational databases are designed to eliminate redundancy. The goal is to store a data item in one table and not have it duplicated in others. For example, an order record will contain the product number ordered, but often not its description. The description is stored in a product table. Thus, any printout of products ordered and their descriptions requires that the order table be linked to the product table for that query or report. Linking customer, order and product tables is a common example of "joining" tables to satisfy a query.
Contents of a Query
Most queries require at least the following conditions to be stated. First, which table or tables is the data coming from. If from two or more tables, what is the link between (typically account number or name). Next, define the selection criteria, which is the matching condition or filter. Lastly, define which fields in the tables are to be displayed or printed in the result. See SQL.
The Query Statement
This diagram depicts the typical conditions that have to be stated when querying a relational database.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Ask revamps for faster Web search, more relevance
- Ask.com is overhauling its Web search engine to deliver faster results and improved relevance as it bids to win share from market leader Google. NEW YORK--IAC Corp's Ask.com is overhauling its Web search engine to deliver faster results and improved relevance as it bids to win share from market...
- News items 2008-10-07
- LINQPad (exe)
- LINQPad is a code snippet IDE that lets you execute C# or VB expressions and see the results interactively. You can execute LINQ queries in against databases or local collections in C# 3.0 or VB 9.0. No need for a typed DataContext, just query and run. This version is the...
- Software downloads 2008-10-07
- Prism (exe)
- Innovative Do-It-Yourself productivity software for building, sharing and using business intelligence applications such as Dashboards and Reports that solve common, information driven business problems. Build Dashboards, Reports and Guided Analytics solutions in one environment. Combine visual elements, also known as Widgets, into one interactive Business Intelligence application that is as...
- Software downloads 2008-10-07
- NoHaggleCarLeasing RSS News Reader (zip)
- Keep up to date with NoHaggleCarLeasings full inventory by installing this simple RSS reader on your desktop. You can leave this simple little programming running and it will query our servers RSS feeds and keep you up to date of all the new incoming cars to our database. This version...
- Software downloads 2008-10-06
- Cybercriminals syndicating Google Trends keywords to serve malware
- In an underground ecosystem that is anything but old fashioned when it comes to abusing legitimate web services, cybecriminals have started exploiting the traffic momentum, and by monitoring the peak traffic for popular search queries using Google's Trends, are syndicating the keywords in order to acquire the traffic and direct...
- Blog posts 2008-10-02
- Google to go back in time?
- Warning, this post is speculative, but I think all signs point to what I am about to describe. Google may be about to launch a search tool that uses the same algorithms used way back in 2001. Why would they do this? I think it's probably the...
- Blog posts 2008-09-30
- TOAD for Data Analysis (exe)
- TOAD for Data Analysis is a multi-platform database tool built for anyone that needs to query databases and report on the results. Key benefits: access data from any source, streamlined data collection, variety of export formats, eliminate the need to learn many tools, promote team collaboration, automate frequent and repetitive...
- Software downloads 2008-09-30
- Interview: From OpenWorld, HP's John Santaferraro on latest BI Modernization strategies
- Now that the optimized hardware and software are available to produce the means to analyze and query huge data sets in near real-time, the focus moves to how to best leverage these capabilities. Soon, business executives will have among the most powerful IT tools ever developed at their disposal to...
- Blog posts 2008-09-25
- Oracle Fires A Booming Shot Across The Bow Of The Storage Vendor Establishment
- Yesterday at Oracle OpenWorld, Larry Ellison announced the database giant's first foray into the hardware realm, unveiling the HP/Oracle Database Machine, branded as Exadata. The Exadata system is a combination of Oracle's 11g database engine using Automated Storage Management ASM to manage a grid of HP Proliant servers with 12 SATA...
- Blog posts 2008-09-25
- ENUMresolver (zip)
- A freeware program designed to query your default DNS for the ENUM NAPTR mapping between a telephone number and a SIP, H323, IAX2, or other URI. Use with VOIP systems to check your e.164 or freenum or other mappings. This program queries each default DNS assigned to your system using...
- Software downloads 2008-09-25
- Oracle enters hardware market; Launches storage server to ride shotgun with database
- Oracle CEO Larry Ellison on Wednesday unveiled its first ever hardware product--a storage server with embedded software designed to work with the company's databases and be used in a grid. The Exadata programmable storage server aims to put database intelligence next to each drive. Oracle and HP also launched a...
- Blog posts 2008-09-24
- Navicat 8 for PostgreSQL (exe)
- Navicat is an intuitive GUI tool for PostgreSQL. It lets you create, browse databases and run SQL queries in an easier way. Advanced features include visual query builder, report builder, backup/restore, batch job scheduling, remote connecting, and the ability to easily migrate data to/from Excel, access and other data formats....
- Software downloads 2008-09-24
- Google releases Android 1.0 SDK
- Hot on the heels of today's announcement of the first Android phone, Google released version 1.0 of the Android Software Developer's Kit SDK. Dan Morrill writes: Yes, that means we're officially at 1.0. Of course the SDK won't remain static—we'll keep improving the tools by adding features and fixing...
- Blog posts 2008-09-23
- Thomson Reuters bootstraps Semantic Web of Linked Data with SemanticProxy
- The Calais team inside Thomson Reuters continues to impress, and today's release could in many ways be the best yet as it promises to contribute massively to the growing body of 'Linked Data' on the Web. As regular readers will remember, this 'Linked Data' is the same stuff being described...
- Blog posts 2008-09-23
- Eclipse Classic (zip)
- Eclipse has formed an independent open eco-system around royalty-free technology and a universal platform for tools integration. Eclipse based tools give developers freedom of choice in a multi-language, multi-platform, multi-vendor environment. Eclipse provides a plug-in based framework that makes it easier to create, integrate, and utilize software tools, saving time...
- Software downloads 2008-09-22
- Federation Supplements The Data Warehouse - Not Either/Or, Never Was
- Few enterprise data warehousing EDW professionals regard the key rival approach--data federation--to be a best practice. Usually, the reasons for this disdain are valid, such as the fact that federated environments are not optimized for heavy-hitting data matching, merging, transformation and cleansing, all of which are essential functions to deliver...
- Blog posts 2008-09-18
- Arctic Class of '08: less ice, but not the least
- Arctic Class of '08: less ice, but not the leastArctic Ice can not effect sea level"What If All the Ice Melts?" Myths and Realities (Wm. Robert Johnston, B.A. Astronomy, M.S. Physics)http://www.johnstonsarchive.net/environment/waterworld.html[b]"[i]Arctic Ocean pack ice = 0.01 % Fraction of world ice - The melting of floating ice will not change...
- Discussion threads 2008-09-17
- WAP Proof 2008 Professional (exe)
- WAP Proof is a professional mobile browser emulator supporting WML, XHTML MP, HTML, and cHTML documents. Several mobile devices are emulated. The HTTP request entity is similar to that of a real device, so the mobile Web site may be tested for compatibility with various user agents. WAP Proof works...
- Software downloads 2008-09-17
- Cognition Technologies unveils their Semantic Map
- Los Angeles-based Cognition Technologies today announced availability of their Semantic Map to the English language. According to Cognition's press release, "[their] Semantic Map provides software applications with an 'understanding' of more than four million semantic contexts" The...
- Blog posts 2008-09-16
- Cheat sheet: SEO
- Confused about what SEO is and what it does? Silicon.com put together this SEO cheat sheet to help you understand why it's so important. SEO--something to do with aliens and unidentified objects, right? Hmm, not quite, but crawlers do come into it. Not outer space beings, mind,...
- News items 2008-09-16
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- ZDNet News Videos
-
Tech news covering the latest in products, conferences and blog commentary, from ZDNet video.
- Watch the latest video >>
- Is it time for "Radical Change" in IT?
-
We need to get back to freethinking and innovation that is core to our roots. Companies like Intel were founded on thoughts like the famous quote from Robert Noyce - "Don't be encumbered by the past, go out and do something wonderful."
- Read the impassioned view on IT@Intel Blog >>
