Where is the Item dublin core metadata stored?

I am using omeka for a library collection and have already established
the dublin core metadata fields. I have no issues modifying the
display of the metadata fields in the php pages.

However I am having some difficulty in understanding how and where the
metadata is stored in the mysql database. The items table does not
contain the metadata and the files table only seems to contain the mimetype
in the metadata field. Yet, I see that the description, creator fields have the values but I am not clear where this is being stored.

Is the actual dublin core metadata associated with an item stored somewhere on the filesystem or is this in another table? I do not see any mysql table that
has this information.

Omeka stores Dublin Core metadata in the element_texts table.

Thank you , Got it. Omeka has been extremely easy to install, is structured and also flexible enough to configure and modify.