| Aggregate Convex Hull |
Calculate and return
the convex hull for a
dataset |
| Aggregate Group By |
Calculate unique
combinations of values
for the given columns
in a given dataset |
| Aggregate Histogram |
Perform a histogram
calculation given a
table, column, and
interval function |
| Aggregate Min/Max |
Calculate the min and
max values of a column
in a dataset |
| Aggregate Statistics |
Calculate statistics of
a dataset |
| Aggregate Statistics by Range |
Divide a dataset into
bins and calculate
statistics of the
values |
| Aggregate Unique |
Find unique values in a
column |
| Aggregate k-means |
Run the k-means
algorithm on a dataset |
| Alter System Properties |
Alter system
configuration |
| Alter Table |
Modify various
properties of a table
or collection |
| Alter Table Metadata |
Alter metadata for
tables |
| Alter User |
Alter a user |
| Clear Table |
Delete a table |
| Clear Table Monitor |
Deactivate a table
monitor |
| Clear Trigger |
Delete a trigger |
| Create External User |
Create a new external
user |
| Create Internal User |
Create a new internal
user |
| Create Join Table |
Create a table that is
the result of a SQL
JOIN |
| Create Proc |
Create a proc |
| Create Projection |
Create a projection of
an existing table |
| Create Role |
Create a new role |
| Create Table |
Create a new table or
collection |
| Create Table Monitor |
Create a table monitor
that will watch for and
queue any records added |
| Create Trigger by Area |
Create a table trigger
for new records falling
within a 2-D boundary |
| Create Trigger by Range |
Create a table trigger
for new records falling
within a 1-D range |
| Create Type |
Create a table record
type (schema) |
| Create Union |
Create a table that is
the union of one or
more tables |
| Delete Proc |
Delete a proc |
| Delete Records |
Delete matching records
from a dataset |
| Delete Role |
Delete an existing role |
| Delete User |
Delete an existing user |
| Execute Proc |
Execute a proc |
| Filter |
Filter a dataset for
records matching an
expression |
| Filter by Area |
Filter a dataset for
records falling within
a 2-D polygon's
boundary |
| Filter by Box |
Filter a dataset for
records within a
rectangle's boundary |
| Filter by Geometry |
Filter a dataset for
records in relation to
a given WKT geometry's
boundary |
| Filter by List |
Filter a dataset for
records with specific
column values |
| Filter by Radius |
Filter a dataset for
records within a
circle's boundary |
| Filter by Range |
Filter a dataset for
records within a 1-D
range |
| Filter by Series |
Filter a dataset for
records within a
track's space/time
boundary |
| Filter by String |
Filter a dataset for
records with matching
column text values |
| Filter by Table |
Filter a dataset for
records with column
values matching another
table's column values |
| Filter by Value |
Filter a dataset for
records matching a
specific value |
| Get Records |
Retrieve records from a
table with optional
filtering and sorting |
| Get Records by Column |
Retrieve the values of
the given columns
within a specified
range. |
| Get Records by Series |
Retrieve the complete
series/track records
from partial track
information |
| Get Records from Collection |
Retrieve records from a
collection, optionally
returning the record
IDs |
| Grant Role |
Grant membership in a
role to a user or role |
| Grant System Permission |
Grant a system-level
permission to a user or
role |
| Grant Table Permission |
Grant a table-level
permission to a user or
role |
| Has Proc |
Check for existence of
specified proc |
| Has Table |
Check for the existence
of specified table |
| Has Type |
Check for the existence
of specified type |
| Insert Records Random |
Generate random records
and insert into
specified table |
| Insert Records Request |
Add records to
specified table |
| Insert Symbol |
Add rendering symbol or
icon to the database |
| Kill proc |
Kill a running proc
instance |
| Lock Table |
Set read or write locks
on a table |
| Revoke Role |
Revoke membership in a
role from a user or
role |
| Revoke System Permission |
Revoke a system-level
permission from a user
or role |
| Revoke Table Permission |
Revoke a table-level
permission from a user
or role |
| Show Proc |
Show information about
a proc. |
| Show Proc Status |
Show the statuses of
running or completed
proc instances. |
| Show Security |
Show security
information relating to
users and/or roles. |
| Show System Properties |
Show the server
configuration and
version information |
| Show System Status |
Show server
configuration and
health status |
| Show System Timing |
Show the last 100
requests, the request
timing, and internal
job id |
| Show Table |
Show information about
a table, view, or
collection, or all top-
level tables, views,
and collections. |
| Show Table Metadata |
Show metadata for the
specified table |
| Show Tables by Type |
Show table names of
specified type |
| Show Triggers |
Show information for
specified or all
triggers |
| Show Types |
Show information for
specified types |
| Shut System Down |
Stop the database
server application |
| Take System Offline |
Take the system offline |
| Update Records |
Perform predicate-based
updates to table data |
| Update Records by Series |
Update a view to
include all
series/track
information for
contained series/track |
| Verify Database |
Verify database is in a
consistent state |
| Visualize Video |
Generate a sequence of
raster images from
table data showing the
data over a specified
time |
| Web Map Service |
WMS capability |