Which tables are index, temporary, and base tables?

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Product: Aleph
Product Version: 20, 21, 22, 23
Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care

Question
Which tables in the system are base or "corpus" tables (permanent tables which can not be re-constructed from other tables) and which are indexes (can be reconstructed from other tables) or temporary?

Answer
These tables can be reconstructed from other tables:
z00p, z00r, z01, z0101, z0102, z02, z101, z103, z11, z111, z13, z13u, z120, z127, z301, z320, z321, z353, z403, z79, z95, z97, z970, z98, and z980.

These are temporary (result set, session, or lock tables):
z05, z110, z130, z131, z200, z50, z51, z60, z63, z64, and z65. [Note: all of these except the z50 occur only in the VIR01 library.]

The z34 and z69 are OPAC statistics tables; the z35 is used for statistics, especially circ statistics.

The above lists may not be complete but, generally, other tables should be considered as base tables.

Article last edited: 28-Feb-2016