Index
Page 1 of 1

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

Index

A

Access path
ACID properties of transactions
glossary definition
Aggregates ,
Agreement
glossary definition
Altering classes
Applets
common problems
example
using client driver
Application logic
application-side vs. database-side execution
Application servers
Applications
developing
Atomicity
glossary definition
Auto-commit
glossary definition
AVG aggregate function

B

Backing indexes
glossary definition
Binding stage of compilation
Blobs
glossary definition
Bulk export
glossary definition
Bulk import
glossary definition

C

CALL statement
example use of
CAST function
example use of
Check constraints
glossary definition
Class compatibility
Class path
glossary definition
testing ,
Classes
altering
storing in the database
ClassNotFound exceptions
troubleshooting
Clobs
glossary definition
Cloudscape as server
cloudscape.properties file
cloudscape.system.home
importance of setting
CLOUDSCAPE_INSTALL environment variable
Cloudview
how to use
Code generation
stage of compilation
Commit ,
glossary definition
Compilation
definition
COM.cloudscape.tools.sysinfo -cp
COM.cloudscape.vti.ExternalQuery
Concurrency
glossary definition
Conglomerates
definition
Connecting to databases
from an application
Connection object
as parameter to JDBC method
Connections
glossary definition
multiple
Consistency
glossary definition
Constraints
glossary definition
Constructors
use of in SQL-J
COUNT aggregate function
COUNT(*) aggregate function
Covering indexes
Creating a database
from an application
Cursors
glossary definition

D

Data
importing from a file in Cloudview
importing from a file in SQL-J statement
Database class loading
glossary definition
Database connection URL
glossary definition
short form in ij
Databases
definition
glossary definition
Database-side JDBC methods
glossary definition
Database-side methods
glossary definition
DBMS (database management system)
definition
glossary definition
DDL (data definition language)
glossary definition
Dependencies
glossary definition
Deployment modes
Derived tables
Dictionary objects
glossary definition
Disk encryption
glossary definition
Durability
glossary definition
Dynamic parameters
glossary definition
use of within prepared statements

E

Embedded
definition
Entry-level SQL-92
definition
Environment space
Error log
Exclusive locks
glossary definition
External virtual tables
glossary definition
requirements for

F

Field access
glossary definition
Fields
accessing
File descriptors
unlimiting

G

GETCURRENTCONNECTION() function
GROUP BY

H

Hash joins
glossary definition
HAVING

I

ij
starting
Importing data ,
Indexes
definition
finding name of with Cloudview
glossary definition
not usable when query includes complex expression
performance benefits of
preventing Cloudscape from using
when they are useful
Information log
Inner tables
glossary definition
INSTANCEOF
example use of
IOExceptions
troubleshooting
Isolation
glossary definition

J

Java
extensions to Cloudscape
implications for deployment
Java constructors
use of in SQL-J statements
Java data types
glossary definition
storing
Java stored procedures
glossary definition
JBMSTours sample application
in client/server mode
JBMSTours.BuildATour
JBMSTours.GenerateReport
JBMSTours.serializabletypes.City
JDBC
glossary definition
tutorial for
JDBC driver
glossary definition
JDBC methods
glossary definition
JDBC objects
explicitly closing
JDBC-ODBC bridge
JDK
glossary definition
JIT
glossary definition
Join
definition
Join order
Joins
definition
example
glossary definition
JRE (Java runtime environment)
glossary definition
JVMs (Java Virtual Machines)
glossary definition

K

Keys
definition
Keywords
glossary definition

L

Latency
glossary definition
LDAP
glossary definition
Leaf level
glossary definition
Locales
glossary definition
Locks
exclusive , ,
glossary definition
shared ,
Long rows
glossary definition ,
LUCID
glossary definition

M

Matching index scans
definition
MAX aggregate function
example
Metadata
glossary definition
Method aliases
Method invocation
glossary definition
overview
Methods
executing from Cloudview
executing within SQL-J statements
glossary definition
requirements for invoking
MIN aggregate function
example

N

Nested connections
glossary definition
Nested loop joins
glossary definition
NEW (Java constructor)
Not enough environment space
troubleshooting
Null
object definition

O

Objects
browsing in Cloudview
definition
executing methods of
stored
storing in the database
Optimization
glossary definition
stage of compilation
ORDBMS
definition
Outer tables
glossary definition

P

Packages
glossary definition
Pages
glossary definition
Parsing
stage of compilation
Positioned update/deletes
glossary definition
Prepared statements
glossary definition
in a Java program , ,
in ij
performance benefits of
using
Primary keys
glossary definition
Properties
glossary definition
sample use of
Provisional transactions
glossary definition
Publications
glossary definition

Q

Queries
definition

R

RDBMS (relational database management system)
definition
glossary definition
Refresh
glossary definition
Replication
overview
Result sets
glossary definition
ResultSets
working with
RmiJdbc server
starting
stopping
Rollback , ,
glossary definition
Row-level locking
benefits of
glossary definitions
RunTimeStatistics

S

Schemas
glossary definition
Serialization
glossary definition
serialVersionUID
Server frameworks
Servers
glossary definition
Servlets
configuring
examples
Shared locks
glossary definition
Shutdown
function
Shutting down Cloudscape
from an application
Sorting results
ORDER BY
Sources
glossary definition
SQL
case-insensitivity of
definition
uses
SQLExceptions
glossary definition
handling
SQL-92
definition
Starting Cloudscape
from an application
Statements
using
when they are optimizable
Static methods
glossary definition
invoking
Stored prepared statements
differences from views
glossary definition
Stored procedures
glossary definition
invoking
Storing classes in the database
Streaming columns
glossary definition
Strings
delimited by single quotation marks in SQL-J
Subclasses
accessing methods of
storing
Synchronization
glossary definition
System
glossary definition
System directory ,

T

Table scan
forcing
Table-level locking
Tables
definition
Targets
glossary definition
Technology overview
toursDB sample database
how to build
installed with product
Transaction control
Transactions
ACID properties
glossary definition
TRANSACTION_SERIALIZABLE isolation level

U

Update locks
glossary definition
URL
glossary definition

V

VALUES clause
Views
differences from stored prepared statements
Virtual Table Interface (VTI)
glossary definition
Virtual tables

W

WHERE clause
definition
glossary definition
Work units
glossary definition

Symbols

? (dynamic parameter)