CONTENTS


1 Introduction
2 AMOSQL introduction
3 Running AMOS II
4 General syntactic constructs
4.1 Identifiers
4.2 Variables
4.3 Constants
4.4 Comments
5 Types
5.1 System type hierarchy
5.2 Deleting types
6 Objects
6.1 Object deletion
7 Functions and Queries
7.1 Function Calls
7.2 Cardinality Constraints
7.3 Deleting functions
7.4 The select statement
7.5 Predicate expressions
7.6 Overloaded Functions and Late Binding
7.7 Disjunctive Queries
7.8 Subqueries and Aggregation Operators
7.9 Negated subqueries and quantification
7.10 Transitive Closures
7.11 Cursors
7.12 Recursive functions
8 Database updates
8.1 Function Updates
8.2 Updating type memberships
9 Database procedures
10 Multi-database facilities
10.1 Interconnecting AMOS II systems
10.2 Data integration primitives
10.3 Translators
11 Sagas for long-running transactions
12 Physical database design
12.1 Indexing
12.2 Clustering
13 System functions and commands
13.1 Comparison operators
13.2 Arithmetic functions
13.3 Aggregation functions
13.4 Accessing the type system
13.5 Query optimizer tuning
13.6 Miscellaneous
References