Tablespace

This article or the following section is not adequately provided with supporting documents ( e.g. individual evidence ). Information without sufficient evidence could be removed soon. Please help Wikipedia by researching the information and including good evidence.

A tablespace (German table space ) designated in the database area the location is written to the tables, indexes, and other data objects. The database management system (DBMS) can access memory in two different ways:

• SMS Tablespace - System Managed Storage: The storage is written via operating system functions.
• DMS Tablespace - Database Managed Storage: The DBMS takes care of the storage management itself.

SMS are easy to manage. Your limits are set by the operating system.

DMS, on the other hand, can be individual files that the DBMS then divides internally. Depending on the system, parts of devices ( partitions ) or entire devices ( raw devices ) can be managed by the DBMS. The administration effort may increase. a. by the fact that the area does not enlarge automatically when necessary. This often goes hand in hand with a higher processing speed, since both the rights management is completely relocated to the DBMS and the selection of the data to be cached. The DBMS can often better decide which data is likely to be required more than once (more complex cache strategies through buffer pools ).

There are basically 4 types of tablespaces:

• Regular (tables and indexes)
• Temporary (sorting, reorganizing)
• LARGE (for large objects like BLOB , CLOB , IMAGES etc.)
• System catalogs (contains e.g. tables in which the data types are defined)