The MySQL database has numerous tables that can be divided up into the
Here's a brief overview.
Additional comments can also be found in the database specification file
found in source distribution in:
Dissemination cache - tables that function as a kind of "dissemination
cache" to enhance dissemination performance when using custom,
user-defined disseminators. When using the Fedora built-in default
disseminator or when requesting versioned(timestamped) dissemination
requests, these requests bypass the sql cache and go directly against
the xml representation of the objects that are stored on disk in LLStore.
LLStore - tables that track physical storage locations of xml-encoded
objects and Managed Content datastreams
PID generator - table that keeps track of highest known ID for each PID
Registry - table containing object registry for all objects in the
FieldSearch - tables related to simple FieldSearch index
ResourceIndex - tables related to the ResourceIndex