Description of tables in BOOKKEEPING schema in the e-Ecology database
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.
|ID||unique file id|
|filename||unique 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_time||Time associated with filename as timestamp.|
|time_in||Timestamp when file was first registered|
|time_changed||Timestamp 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.
|id||ID for file|
|filetype||Type of file (MPR, tar, etc)|
|path||Original 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_id||Id of archive file in FILE_CATALOG table|
|file_id||Id of file in archive in FILE_CATALOG table|
|archive_path||Path 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_id||References in file_catalog|
|replica_id||replicanumber, ie 1 for first replica, 2 for second etc|
|surl||SURL is the storage location.|
|stored||timestamp with time of storage|
|adler32||adler32 checksum of file|
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.
|username||Name of user who requested the restore|
|status||Status of the request|
|time_start||Timestamp when request was started|
|time_changed||Timestamp when request was changed|