Schema

A schema is an identifier such as a user ID that helps group tables and other 

database objects. A schema can be owned by an individual, and the owner can 

control access to the data and the objects within it. A schema is also an object in 

the database. It may be created automatically when the first object in a schema is 

created. We can create a schema using:

db2>create schema itsoschema authorization itso

5.2.2  Table manipulation

Tables are logical structures maintained by the database manager. Tables are 

made up of columns and rows.

MySQL tables

As shown in Figure 5 3, MySQL supports two types of tables: transaction safe 

table and non transaction safe table. Transaction safe tables (InnoDB and BDB) 

are crash safe and can take part in transactions; they provide the concurrency 

feature and allow commit and rollback. On the other hand, non transaction safe 

tables (HEAP, ISAM, MERGE, and MyISAM) are much faster, and consume less 

space and memory.

 Chapter 5. Database porting 

99