| Work with
the tables in the sysmaster database. |
IBM Informix Administrator's Reference |
| Place tables on disk.
Estimate table size and manage
table extents.
Modify tables (truncate, alter, modify columns, load, attach fragments).
Denormalize data to improve performance.
Create and manage B-tree indexes.
Work with specialized indexes (R-tree and secondary access methods).
Set appropriate lock modes and monitor locks.
Design a fragmentation strategy (round-robin or expression-based).
Fragment indexes and temporary tables.
Use the WHERE clause and joins to
filter queries. |
IBM Informix Performance Guide |
| Find corrective actions to error messages. |
IBM Informix Error Messages |
| Design a database (choose whether to implement
the relational, object-relational, or dimensional database model).
Build
a relational or object-relational database:
- Define the data objects.
- Create an entity-relationship
diagram.
- Normalize the data.
- Create and populate the
database.
Build and implement a dimensional database for data warehousing.
Choose data types for the database.
Set up check constraints and referential constraints.
Determine the primary
keys and foreign keys in tables.
Extend a database with user-defined
casts.
Understand type and table
inheritance.
Grant and limit access to a database.
Use views and privileges.
Define a fragmentation strategy or distribution schema. |
IBM Informix Database Design and Implementation Guide |
| Invoke the DB–Access utility.
Connect to or create
one or more databases and transfer data between a database and external text
files.
Display information about databases and verify database server
status.
Perform ad hoc queries that you
execute once or infrequently.
Execute and debug SQL statements and SPL routines. Display system catalog tables and the Information Schema.
Access,
modify, and retrieve information from the database server.
Use menus,
screens, SQL statements, and SPL routines to view, access, retrieve,
store, and modify data in a database.
Work with relational (stores_demo) and object-relational (superstores_demo) demonstration databases. |
IBM Informix DB–Access User's Guide |
| Learn how GLS affects database
server migration.
Load and unload data.
Display the database schema with dbschema. |
IBM Informix Migration Guide |
| Use the system catalog tables to track objects.
Set environment variables.
Find a description
of the tables in the stores_demo or superstores_demo database.
Look up definitions in the glossary. |
IBM Informix Guide to SQL: Reference |
| Create databases and manage access.
Compose
correct SQL statements.
Learn the categories of SQL statements.
Use segments such as arguments, expressions, and identifiers.
Write procedures with SPL and store them in a database.
Look up reserved words. |
IBM Informix Guide to SQL: Syntax |
| Learn database concepts.
Compose basic and advanced SELECT statements.
Use functions
and SPL routines in SQL statements.
Modify data in a
database.
Set locks.
Work with casts on extended data types.
Create and use triggers.
Use embedded SQL in
programs. |
IBM Informix Guide to SQL: Tutorial |
| Assign data types to columns. |
IBM Informix Database Design and Implementation Guide
IBM Informix Guide to SQL: Reference
IBM Informix Guide to SQL: Syntax
IBM Informix Guide to SQL: Tutorial |
| Use the Optical Subsystem interface
for an optical storage subsystem to store TEXT and BYTE data (simple large
objects) on optical platters (WORM optical media). Use SQL statements
to store and retrieve data to and from the Optical Subsystem. |
IBM Informix Optical Subsystem Guide |