October 2004
Intermediate to advanced
688 pages
16h 35m
English
• Understanding data structures
• Managing database objects
• Creating database objects: data types, tables and table spaces, aliases and synonyms, constraints, views, materialized query tables, indexes, databases, storage groups, and sequence objects
• Database design and implementation
DB2 is a relational database that consists of one or more tables made up of rows and columns. The tables are created and accessed using the industry-standard Structured Query Language. Data in these tables is accessed via content, not location. This chapter looks at the structures in a DB2 subsystem and those that make up a DB2 database.
Many of these objects can be directly referenced from an SQL statement; therefore, it is important ...