Library > Products > Pervasive.SQL > Pervasive.SQL 9.1 > Programmer's Guide > University Database Tables and Referential Integrity > Table Design

Previous

Programmer's Guide (9.1 revision 1)

Programmer's Guide - Index

A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X

Accelerated file open mode

Accelerated mode

transaction durability, lack of

Access rights. See Security

Accessing records

by physical location

ACS. See Alternate collating sequence

ActiveX interface

redistributable files

registering files

ADD FOREIGN KEY clause

ADD keyword, with ALTER TABLE statement

ADD PRIMARY KEY clause

Pervasive.SQL source modules

to a Delphi project

to a Visual Basic project

Administering database security

Aggregate functions. See Group aggregate functions

Alias names for tables

ALTER TABLE statement

defining referential constraints

dropping columns with

with ADD FOREIGN KEY clause

with ADD keyword

with ADD PRIMARY KEY clause

with DROP FOREIGN KEY clause

with DROP keyword

with DROP PRIMARY KEY clause

Alternate collating sequence

case sensitivity

international sort rules

user-defined ACSs

AND boolean operator

on delete-connected cycles

on multiple paths

on self-referencing tables

API programming

basic operations

creating a file, overview

Get operations, overview

inserting records, overview

Step operations, overview

updating records, overview

using chunks,BLOBs,variable-length records, overview

working with segmented indexes, overview

Archival logging

and file backups

Ascending sort order

ATOMIC keyword, with compound statement

transaction processing and

Backing up files

Balanced indexes. See Indexes, balancing

BALANCED_KEYS constant

BEGIN...END statement

BETWEEN operator

Bias values and locking

Binary large objects. See BLOBs

Blank truncation

creating files that use

BLANK_TRUNC constant

Blanks in file names

and Btrieve API, overview

and record length

sample structures

Visual Basic and Btrieve API

expressions in triggers

operators, in restriction clauses

Bound databases

BTRCALL function, and PALN32.DLL

BTRCALLID function

Btrieve operation sequence

BTRVID function 1 2 3

Byte alignment, Visual Basic and Btrieve API

creating a file, and Btrieve API

inserting records, and Btrieve API

Get operations, and Btrieve API

Step operations, and Btrieve API

updating records

and Btrieve API

working with segmented indexes, and Btrieve API

and LRU algorithm

CALL (procedure) statement

Cartesian product joins

Cascaded deletes

Case sensitivity

column names and

index column values and

stored view names and

table names and

Choosing a development tool

and Btrieve API, overview

debugging operations

intrarecord currency and

sample structures

Visual Basic and Btrieve API

Clauses, restriction

Clearing owner names

ClientID parameter

handling multiple

Creating a file, Btrieve API

Get operations, Btrieve API

inserting records

Step operations, Btrieve API

multiple records, Btrieve API

chunks,BLOBs,variable-length records, Btrieve API

working with segmented indexes, Btrieve API

COLLATE.CFG file

Collating sequence. See Alternate collating sequence

Collation samples using ISRs

default values, specifying

headings in views

case-sensitivity and

qualified names of

COMMIT WORK statement

Compiling and linking sample programs. See Tutorials and Sample Code Reference

Compound statements

COMPRESS.Z file in InstallShield

CompressGet function in InstallShield

Compression buffer size

Compression. See Data compression

Computed columns

extended operations and

Concurrency control

data file locks

passive control

transaction processing

Concurrent transactions

Condition operators

Condition, defined

Conditional execution of SQL statements

Configuration issues

Connector, defined

Correlated subqueries

COUNT function 1 2

GROUP statement

INDEX statement

PROCEDURE statement

TABLE statement

with FOREIGN KEY clause

with PRIMARY KEY clause

TRIGGER statement

VIEW statement, with SELECT clause 1 2 3

Create Index operation, when to use

Create operation, example

Create Table right

CREATE TABLE statement

defining referential constraints

granting right to use

data dictionaries

C/C++ and Btrieve API

Delphi and Btrieve API

sample structures

Visual Basic and Btrieve API

stored procedures

and Btrieve API, overview

Cursor stability isolation level

delete-connected

Data compression

creating files that use

Data dictionaries

Data encryption

as locking units

index segments, maximum number of

Data security. See Security

in Btrieve data buffers

Data types. See also Pervasive.SQL Programmer's Reference

DATA_COMP constant

Data-only files

Database access methods

Database element names

maximum lengths for

valid characters for

defining referential constraints for

deleting rows from

normalization of

retrieving rows from 1 2

transactions in

using transactions in

Deadlock condition

with cursor stability isolation level

with exclusive isolation level

Deadlock detection

Default column values

DEFAULT statement

Defining stored procedures

anomalies, for foreign keys

DELETE statement

deleting rows with

invoking triggers with

Delete-connected table

stored procedures

users and user groups

adding Pervasive.SQL source modules to

and developing Pervasive.SQL applications

creating a file, and Btrieve API

inserting records

and Btrieve API

Get operations, and Btrieve API

Step operations, and Btrieve API

updating records

and Btrieve API

working with segmented indexes, and Btrieve API

DESC_KEY constant

Descending sort order

Descriptor, defined

Developer's Resource Center

and language interfaces

Developing Pervasive.SQL applications, getting started

Disabling security

blank truncation and

data compression and

page preallocation and

Distributing applications

ActiveX interface

distribution rules for Pervasive.SQL engines

shipping requirements for DLLs

Distribution rules for Pervasive.SQL engines

Documentation you supply

Double-byte character support

DRC. See Developer's Resource Center

DICTIONARY statement

PRIMARY KEY clause

PROCEDURE statement

TRIGGER statement

DROP FOREIGN KEY clause

DROP INDEX statement

DROP TABLE statement

DUP_PTRS constant

Duplicatability

Duplicatable keys

Dynamic Data Exchange (DDE)

Dynamic file expansion

Enabling security

Encryption, data

End-user documentation

Ending transactions

English language character sorting

isolation level

in concurrent transactions

in non-transactional environment

with multiple position blocks

scalar functions in

Extended files and extension files

Extended operations

heavy concurrency and

performance and

reject count and

Visual Basic and Btrieve API

External index files

Extractor, defined

EXTTYPE_KEY constant

FCR. See File Control Record

File Control Record

in key-only files

in standard data files

workstation vs. server engines

File size, estimating

File specifications, sample

required to redistribute applications

transaction log

Filter evaluation precedence

Filter, defined

First normal form

Fixed-length portions of variable-length records

FREE_10 constant

FREE_20 constant

FREE_30 constant

French language character sorting

with the DISTINCT keyword

German language character sorting

and Btrieve API, overview

C/C++ and Btrieve API

Delphi and Btrieve API

retrieving records

sample structures

Visual Basic and Btrieve API

shipping requirements for

access rights statement

LOGIN statement

Group aggregate functions

GROUP BY clause, with SELECT statement 1 2

Groups. See User groups

HAVING clause, with SELECT statement

with multiple position blocks

Import libraries

INCLUDE_SYSTEM_DATA constant

Index balancing configuration option 1 2 3

creating files that use balanced

duplicatability in

duplicate key values, storing

external index files

join conditions and

maximum number of

positioning rules

ascending order

case sensitivity and

descending order

when to use Create Index

Initiation Time Limit configuration option 1 2

INSERT statement

invoking triggers with

with VALUES clause

Visual Basic and Btrieve API

Inserting records

C/C++ and Btrieve API

Delphi and Btrieve API

sample structures

InstallShield 3 and Glue DLLs

controls for data

International sort rules

Intrarecord currency

Invalid Descriptor error

IS NOT NULL operator

IS NULL operator

Isolation levels

cursor stability

deadlock condition

deadlock condition

ISR. See International sort rules

Japanese language character sorting

cartesian product

computed columns in

using views and tables in

case-sensitivity

duplicatability 1 2

Key buffers, and segmented keys

Key numbers, assigning

Key paths, changing

Key segment, defined

optimization and

Key specifications, sample

Key types. See Data types

KEY_ONLY constant

creating files that are

adding and dropping

linked-duplicatable vs. repeating-duplicatable

characteristics of

Language interface source modules. See Source modules

Least-recently-used algorithm

LEAVE statement

Linked-duplicatable keys

advantages when using

bias values for

deadlock condition

implicit record

multiple-record

and Accelerated file open mode

log files and log segments

Logical currency

Logical record length, calculating

Long file names

and the WHILE statement

LRU algorithm. See Least-recently-used algorithm

MANUAL_KEY constant

Many-to-many relationship

Memory management

MicroKernel configuration issues

Minimum page size, determining

Multi-record operations

Multi-segment key

Btrieve clients 1 2

position blocks

Named databases

NAMED_ACS constant

Naming conventions

database elements

stored procedures

Nested queries. See Subqueries

NO_INCLUDE_SYSTEM_DATA constant

No-currency-change operations

NOCASE_KEY constant

Non-duplicatable keys, updating

Non-modifiable keys, updating

Normalization of databases

first normal form

second normal form

third normal form

NOT BETWEEN operator

NOT IN operator

NOT LIKE operator

NUMBERED_ACS constant

One-to-many relationship

One-to-one relationship

Operating system switches

Operation Bundle Limit configuration option 1 2

Operations, multi-record

Operations, sequence

multi-record operations

Optimum page size

OR boolean operator

ORDER BY clause, with SELECT statement

assigning with Set Owner operation

Page Allocation Table

shadow paging and

Page preallocation

creating files that use

maximum index segments and

PALN32.DLL, and user-defined data types

Passive concurrency

Passive control

case-sensitivity and

PAT. See Page Allocation Table

extended operations and

Performance enhancement

extended operations

memory management

page preallocation

system transactions

Permanent indexes. See Linked-duplicatable keys

Pervasive event logging

Pervasive.SQL ActiveX interface. See ActiveX interface

Physical currency

Physical record address

Physical record length, determining

Position blocks, handling multiple 1 2

extended operations and

PRE_ALLOC constant

Pre-image files

PRIMARY KEY clause

characteristics of

Procedure-owned

Procedures, stored

Processing transactions

PUBLIC group 1 2

Qualified column names

data dictionaries

Range operators in restriction clauses

Read-only tables in views

calculating logical

calculating physical

explicit, in non-transactional

chronological ordering

variable-length 1 2

Referential constraints

foreign keys with

primary keys with

Referential integrity

and delete-connected cycles

and multiple, delete-connected paths

and self-referencing tables

and the delete rule for foreign keys

self-referencing tables and

Registering ActiveX interface

Relational operators

RELEASE SAVEPOINT statement

REPEAT_DUPS_KEY constant

Repeating-duplicatable keys

advantages when using

Reserved duplicate pointers

Reset operation

Restricting file access

Restriction clauses

using functions

Step operations

Retrieving data

with SELECT statements

access rights statement

LOGIN statement

Revoking rights

RI. See Referential integrity

references, about

with TO SAVEPOINT clause

Rolling forward

sorting and grouping

Sample database. See University database, Developer's Resource Center

Sample structures

creating a file and Btrieve API

inserting records and Btrieve API

performing Get operations and Btrieve API

performing Step operations and Btrieve API

updating records and Btrieve API

using chunks,BLOBs,variable-length records and Btrieve API

SAVEPOINT statement

rolling back to

Scalar functions

Second normal form

creating user groups and

creating users and

master user and

case-sensitivity and

PUBLIC group and

Segmented indexes

and Btrieve API, overview

C/C++ and Btrieve API

Delphi and Btrieve API

Visual Basic and Btrieve API

setting key buffers

SELECT statement

as nested query

lists, specifying

with GROUP BY clause 1 2

with HAVING clause

with ORDER BY clause

with WHERE clause

Selecting, columns

Selection lists

Self-referencing tables

Sequence of Btrieve operations

SECURITY statement

with NULL keyword

SQL variable statement

Sharing files. See File sharing

Shift-JIS characters

Shutting down the MicroKernel

Smart Component Naming

descending, in indexes

ascending and descending

BTRCONST and BTRAPI32

Spaces in file names

Spanish language character sorting

SPECIFY_KEY_NUMS constant

column default values

list of columns

SQL control statements

compound statements

LEAVE statement

WHILE statement

SQL variable statements

procedure-owned variables

Standard data files

START TRANSACTION statement

a Pervasive.SQL application

Status Coded 62

Step operations

and Btrieve API, overview

and retrieving records

C/C++ and Btrieve API

Delphi and Btrieve API

sample structures

Stop operations, and shutting down the MicroKernel

Stored procedures

Stored statements. See Stored procedures

Storing, passwords

SUM function 1 2

Supplemental indexes. SeeRepeating-duplicatable keys

Supporting multiple Btrieve clients

creating files that use

System transactions

aliases for, assigning

relationships with referential integrity

views as an alternative

delete-connected

with other tables

modifying definitions of

case sensitivity and

primary keys, changing

read-only in views

self-referencing

Temporary views

Third normal form

Trace Operations configuration option

Transaction durability

not available with accelerated mode

Transaction durability, about

Transaction locks

Transaction logging

concurrent vs. exclusive

concurrent, about

exclusive, about

locking units in

nesting, with savepoints

special considerations for

defining trigger action

specifying execution time

specifying order of execution

UDT. See User-defined data types

University database

and referential integrity

entity relationships

referential integrity

Unused file space 1 2

anomalies, avoiding

UPDATE statement

invoking triggers with

with SET clause

with WHERE clause 1 2

Updating records

and Btrieve API, overview

C/C++ and Btrieve API

and Btrieve API

sample structures

and Btrieve API

granting rights to

User-defined ACSs

User-defined data types, and Btrieve API

granting rights to

VALUES clause, with INSERT statement

VAR_RECS constant

Variable statements. See SQL variable statements

Variable-length records

and Btrieve API, overview

blank truncation and

creating files that use

inserting and updating

sample structures

Variable-tail Allocation Tables

creating files that use

procedure-owned

VATS_SUPPORT constant

VATs. See Variable-tail Allocation Tables

column headings in

joining, with tables

with read-only tables

adding Pervasive.SQL source modules to

and developing Pervasive.SQL applications

Btrieve API and byte alignment

creating a file, and Btrieve API

including PALN32.DLL in a project

inserting records

and Btrieve API

Get operations, and Btrieve API

updating records

and Btrieve API

using chunks,BLOBs,extended operations, and Btrieve API

working with segmented indexes, and Btrieve API

Wasted file space 1 2

WHEN clause, in triggers

WHERE clause, with SELECT statement

WHILE statement

xCopyFile function in InstallShield

Chapter contents
Publication contents

Prev topic: Referential Integrity in the University Database
Next topic: