At the heart of any database solution, you will find a table. Tables are logical structures used to manage data. The type of table is defined by the type of data it contains. Data can be identified as summary, temporary, persistent, results, partitioned, or dimensional. See the following table for a complete list:
|
Table group |
Table type |
Description |
|
Base
|
Regular |
General purpose. |
|
Multidimensional clustering (MDC) |
Physical clusters on more than one key or dimension. Not supported in pureScale. |
|
|
Insert time (ITC) |
Clustered on time of insert. |
|
|
Range-Clustered (RCT) |
Tightly clustered (RID) access. Not supported in PS. |
|
|
Range Partitioned (RPT) |
Data is divided across data partitions or ranges. |
|
|
Temporal |
Time-based state information. |
|
|
Temporary |
Temporary data storage |
Stores temporary data for different database... |