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-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- EMS SQL Manager for SQL Server Lite 3.5.0.2 (Windows)
- EMS SQL Manager for SQL Server is a powerful tool for SQL Server administration and development. SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML columns,...
- Software downloads 2009-11-21
- Alchemy Network Monitor 10.4 (Windows)
- Alchemy Network Monitor monitors your network servers and business-critical applications availability and performance and immediately alerts you if a server gets out of order. Alchemy Network Monitor can also perform certain actions (e.g. launch an external application or execute an SQL query) when a server stops responding to the programs...
- Software downloads 2009-11-19
- Alchemy Network Monitor PRO 10.4 (Windows)
- Alchemy Network Monitor monitors your network servers and business-critical applications availability and performance and immediately alerts you if a server gets out of order. Alchemy Network Monitor can also perform certain actions (e.g. launch an external application or execute an SQL query) when a server stops responding to the programs...
- Software downloads 2009-11-19
- NBL Purchasing 1.3.1 (Windows)
- NBL Purchasing is a Windows database-driven software designed for soho, small and medium size company, to manage and monitor purchasing process, from receive quotation, issue purchase order, receive material to validate supplier bill. Includes features: Master Editor: Store Supplier, Employee, Organization particular / contact and Material information; Issuing: Print, fax...
- Software downloads 2009-11-19
- NBL Product Sale 1.3.1 (Windows)
- NBL Product Sale is a Windows database-driven software designed for soho, small and medium size company, to manage and monitor sale process, include issue quotation, offer price and receive sale order Include feature: Master Editor: Store Customer, Employee, Organization particular / contact and Product information Issuing: Print, fax Quotation, Sale...
- Software downloads 2009-11-19
- RazorSQL 5.0.2 (Mac)
- Query, edit, browse, and manage all major databases from one database tool. RazorSQL OSX is a universal database query tool, programming and sql editor, database navigator, and administration tool with built-in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite,...
- Software downloads 2009-11-18
- Bugzilla 3.4.4 (Mac)
- Bugzilla is the leading open-source/free software bug tracking system, with high-profile installations at mozilla.org (250,000 entries), Gnome, Red Hat and NASA, among others. It features a comprehensive set of fields, attachment management, inter-bug dependencies, email notification of changes, a powerful query interface, reporting, and web, xml, email and console interfaces....
- Software downloads 2009-11-18
- DatAdmin Personal 3.4.2 (Windows)
- Easy and quick database administration, natively supports MSSQL, MySQL, SQLite, Postgre SQL, MS Access. Also can be used to create and restoring backups, transfer data between databases, tables or files (supported formats are XML, CSV, HTML, Excel), edit database schema. Other functions: run queries, view data in tables of any...
- Software downloads 2009-11-17
- Altova DatabaseSpy 2010 (Windows)
- Altova DatabaseSpy is the unique multi-database data management, query, design, compare, and convert tool from the creators of XMLSpy. DatabaseSpy connects to all major databases, easing SQL editing and other database tasks for a fraction of the cost of single-database solutions. DatabaseSpy provides a straightforward database connection wizard and organizes...
- Software downloads 2009-11-17
- RazorSQL 5.0.1 (Windows)
- Query, edit, browse, and manage all major databases from one database tool. RazorSQL is a database query tool, SQL editor, database browser, and administration tool with built-in connection capabilities for DB2, Derby, Firebird, FrontBase, HSQLDB, Informix, Microsoft SQL Server, MySQL, OpenBase, Oracle, PostgreSQL, SQL Anywhere, SQLite, and Sybase. Any other...
- Software downloads 2009-11-16
- Altova XMLSpy Enterprise Edition 2010 (Windows)
- Altova XMLSpy 2010 Enterprise Edition is the industry's best-selling XML editor and XML development environment for modeling, editing, transforming, and debugging XML technologies. In addition to the world's leading XML editor, XMLSpy includes a powerful graphical XML Schema editor that allows you to design complex schemas with ease. Advanced error...
- Software downloads 2009-11-16
- Altova XMLSpy Professional Edition 2010 (Windows)
- Altova XMLSpy 2010 Professional Edition is the industry-leading XML editor and XML development environment, with intuitive editing views and powerful XML utilities to model, edit, transform, and debug XML-related technologies quickly and easily. In addition to the world's most popular XML editor, XMLSpy Professional includes a graphical XML Schema editor...
- Software downloads 2009-11-16
- Corona 3.3 (Mac)
- Originally introduced in 2001, Corona has been upgraded regularly to become a full general ledger accounting tool, yet still retains its "simple check register" appeal and price. Corona features "drag and drop" accounting, on-the-fly account creation, and one-click reconcilement. Innovations: On-the-fly account creation Journal selector for entry forms Popup selectors...
- Software downloads 2009-11-16
- Universal SQL Editor 1.2 (Windows)
- Universal SQL Editor is a graphical query tool for all database developers. It allows you connect any ODBC compliant databases, such as Oracle, DB2, SQL Server, Sybase, and edit SQL queries and scripts with code completion, syntax highlighting, SQL formatting, plus other useful features that allow you to work more...
- Software downloads 2009-11-16
- SmartCode VNC Manager Enterprise Edition 5.0.14 (Windows)
- SmartCode VNC Manager is a powerful yet easy to use remote administration and monitoring software application for both the business and home network environments. It is typically used for remote network management, remote system administration and in helpdesk environments. Its features include but are not limited to: Built-in VNC, RDP,...
- Software downloads 2009-11-15
- Database .NET 2.9.3605 (Windows)
- Database .NET is an intuitive database management tool for multi-database. It supports MS Access 97-2003/MS Access 2007/MS Excel 97-2003/MS Excel 2007/dBASE IV/Firebird/MySQL/SQL Server/SQL Server CE/SQLite/PostgreSQL/Oracle/OleDB databases. It allows to create, shrink, or protect databases automatically. Also features syntax highlighting, service manager, SQL example manager, multiple query tab, SQL query batch....
- Software downloads 2009-11-14
- Aqua Data Studio 8.0.4 (Windows)
- AquaFold today announced the availability of Aqua Data Studio , which provides new database tools and functionality and bundled with a complete verstion control client for Subversion and CVS. New tools include SQL Debuggers for Oracle and Sybase ASE, Object Search tool, SQL History Archive, Server Script Generator and Data...
- Software downloads 2009-11-13
- NBL Inventory 1.3.1 (Windows)
- NBL Inventory is a Windows database-driven software designed for soho, small and medium size company, to manage and monitor raw material warehouse or finished product stock quantity and movement Master Editor: Store Employee, Organization particular / contact and Material / Product information. Listing: Query, print or export master data and...
- Software downloads 2009-11-12
- A Visual SQL Query Designer
- This paper describes the implementation of a QueryDesignerDialog class that allows users to create SQL queries based on a given OleDb connection string. The designer is similar to the ones found in database tools such as the SQL Server Management Studio and Microsoft Access. It allows end users to build...
- White papers 2009-11-11
- LogQL: Excel Reports 1.4 (Windows)
- logQL is free, easy to install and extremely flexible data analysis tool. Easy to install: No database needed, no expensive hardware and logQL will run on any operating system supported by Java. Extremely Flexible: logQL employs a simple query language to generate the reports. Using this language, users can easily...
- Software downloads 2009-11-10
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- The more you simplify, the more you save
-
When you transition from your existing Red Hat environment to SUSE Linux Enterprise from Novell, you can recognize dramatic cost savings, perhaps as much 50%
- Learn more >>
- Reduce risk. Reduce complexity. Increase reliability.
-
A simplified IT environment isn't just less complex. It's also more reliable. Standardize on a single Linux platform with SUSE Linux Enterprise from Novell, and get the world's most interoperable Linux
- Learn more >>
- Save time with automated shipping solutions
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Visit the UPS Business Essentials Guide
- The best support in the Linux business
-
If Linux is going to power your mission-critical applications, you'd better have the best support known to business. Novell was rated the top provider of Linux technical support.
- Learn more >>
Meet Doc
-
-
Here to help you with your Document Management Needs
- Doc is an enigma. Born to a Russian ballerina and a German electrical engineer, he grew up in various locations in the United States. He’s seen the insides of more brands, versions, and generations of printer and printer-related hardware than almost anyone.
- To learn more about this mysterious figure check out his blog on ZDNet and his Workspace on TechRepublic. You’ll be glad you did.
-
Produced by
ZDNet and -
