This is an old revision of the document!
DRAFT
Glossary
C
C String
Calling errors
Cardinality
For example:
The products table is a parent table with a primary key that has a column cardinality of 10,000. This means it has 10,000 unique product codes.
The orders table is a child table with 10,000,000 rows. This means it has a table cardinality of 10,000,000.
SELECT O.PRODUCT_CODE, O.CUSTOMER_NO, O.STATUS
FROM PRODUCTS P, ORDERS O
WHERE P.PRODUCT_CODE=O.PRODUCT_CODE
AND P.PRODUCT_NAME = 'PRINTER'
Cartesian product
For example: Customers is the parent table and activity and orders are the child tables. Selecting from both the activity and orders table for a particular customer will produce a cartesian product. Meaning, every row in the activity table will be qualified with every row in the orders table. If activity has 10 rows for one customer and orders has 10 rows for the same customer, the cartesian product is 100 rows.
table1 (t1) contains 2 rows (r1, r2) and table2 (t2) contains 3 rows (r1, r2, r3). The cartesian product or these tables contains 6 rows: t1r1-t2r1, t1r1-t2r1, t1r1-t2r3, t1r2-t2r1, t1r2-t2r2, t1r2-t2r3.
Chained list
Child
Child key
Child table
There is a one-to-many relationship between the parent table and the child table.
Client
The user interface aspect of a client/server system, usually a personal computer or small computer workstation dedicated to immediate, local user interactions, such as system navigation and help, rather than widely accessed or centralized computational activity, such as data processing.
Client/server
A distributed technology approach, or system, where computer processing is divided by function to take advantage of processing on multiple computer units, dividing tasks between client activities and server activities. See client and server.
Codified data
Data represented by codes instead of actual data values, used by data warehouses to conserve data storage space, e.g., income ranges represented by a single character.
Column
Column cardinality
Composite index
Composite keys
Connection
Container application
Criteria count
A count of the number of rows qualified for the current set of criteria. This count differs from the qualifying count which returns the total number of rows qualified when the rows found in the current search are merged with the rows in the qualified subset. This applies to oaqualify and the SQL extended command, QUALIFY.
Cursor
In OmniAccess, cursors are established by a call to oaopencursor, and closed by a call to oaclosecursor. They are referenced through the cursor option as an integer value in calls to OmniAccess routines.
Contains
Custom Indexes