From Eecology

Jump to: navigation, search


Description of tables in BOOKKEEPING schema in the e-Ecology database

Bookkeeping datamodel.png


The FILES table describes the status of all data-files which have been or need to be processed. This information is used by the bookkeeping service on the e-Ecology website.

IDunique file id
filenameunique file name
file_type Type of file ie MPR, ECMWF,
file_size Size of file in bytes
status Status of file ie new, processed, archived
filename_timeTime associated with filename as timestamp.
time_inTimestamp when file was first registered
time_changedTimestamp of last status change

e-Ecology Grid-Store Catalog

The following three tables are used to implement the e-Ecology Grid-Store catalog. If files are being archived or copied the Grid-Storage, this is administratred in the following tables.

For Grid-Storage it is preferable to have a limited number of big files instead of many small files. Therefore files are first collected into bigger archives, which are then stored as archive to the Grid-Storage. This is also maintained in the tables below.


Every file to be stored gets an entry in the FILE_CATALOG table.

idID for file
filenameUnique filename
filetypeType of file (MPR, tar, etc)
pathOriginal path of file on Flysafe server


Files can be collected together in archive (usually tar files). These archive files are also registered as files in the FILE_CATALOG table. The ARCHIVE_FILE table contains the information about which files are in what archive file.

archive_idId of archive file in FILE_CATALOG table
file_idId of file in archive in FILE_CATALOG table
archive_pathPath of file in archive


The FILE_REPLICA table contains the actual storage location of the stored files. It is possible to have more replicas of the same file.

file_idReferences in file_catalog
replica_idreplicanumber, ie 1 for first replica, 2 for second etc
surlSURL is the storage location.
storedtimestamp with time of storage
adler32 adler32 checksum of file
verifiedboolean indicator

Auxiliary tables


The SRMREQUEST table is used when it is requested to have a file or group of files restored from SRM. In this table the status of the request is maintained so that it can be shown on a website. It is also possible to check all requests for a specific user.

idUnique ID
usernameName of user who requested the restore
statusStatus of the request
time_startTimestamp when request was started
time_changedTimestamp when request was changed
Personal tools