Understanding the Purpose of CA Dataquery › Database Storage

Database Storage

A database can contain all kinds of information arranged in tables. Think of a drawer in a file cabinet as being like a table in a company database. The data in the file folder is the same as the data in one row of a database table.

In the following examples, the personnel information is in the Personnel table, with each row representing one employee. The table is made up of vertical columns and horizontal rows for storing data. The data stored at an intersection of a column and row is a value. For instance, there is a Last Name value, a First Name value, a Department value and a Social Security Number value for each row of the small table shown below. Notice that, to form the columns that make up the table, each row must have the columns arranged in the same order.

Your query tells CA Dataquery the name of the table and the names of the columns that have the information you want in a report.