Difference between revisions of "Bookkeeping"
From ecology
(New page: === Description of tables in BOOKKEEPING schema in the Flysafe database === == FILES == The FILES table describes the status of all data-files which have been or need to be processed. T...) |
(→FILES) |
||
| Line 5: | Line 5: | ||
The FILES table describes the status of all data-files which have been or need to be processed. | 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 flysafe website | This information is used by the bookkeeping service on the flysafe website | ||
| − | |||
{|border=1 | {|border=1 | ||
|'''ID'''||unique file id | |'''ID'''||unique file id | ||
|- | |- | ||
| − | |''filename | + | |''filename''||unique file name |
|- | |- | ||
|file_type|| Type of file ie MPR, ECMWF, | |file_type|| Type of file ie MPR, ECMWF, | ||
| Line 18: | Line 17: | ||
|status|| Status of file ie ''new'', ''processed'', ''archived'' | |status|| Status of file ie ''new'', ''processed'', ''archived'' | ||
|- | |- | ||
| − | |filename_time||Time associated with filename as timestamp | + | |filename_time||Time associated with filename as timestamp. |
|- | |- | ||
|time_in||Timestamp when file was first registered | |time_in||Timestamp when file was first registered | ||
| Line 24: | Line 23: | ||
|time_changed||Timastamp of last status change | |time_changed||Timastamp of last status change | ||
|} | |} | ||
| + | |||
| + | === Flysafe Grid-Store Catalog === | ||
| + | |||
| + | The following three tables are used to implement the Flysafe 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. | ||
| + | |||
| + | == FILE_CATALOG == | ||
| + | |||
| + | Every file to be stored gets an entry in the FILE_CATALOG table. | ||
| + | |||
| + | {|border=1 | ||
| + | |'''id'''||ID for file | ||
| + | |- | ||
| + | |''filename''||Unique filename | ||
| + | |- | ||
| + | |filetype||Type of file (MPR, tar, etc) | ||
| + | |- | ||
| + | |path||Original path of file on Flysafe server | ||
| + | |} | ||
| + | |||
| + | |||
| + | == ARCHIVE_FILE == | ||
| + | |||
| + | |||
| + | == FILE_REPLICA == | ||
Revision as of 11:08, 2 June 2008
Contents
Description of tables in BOOKKEEPING schema in the Flysafe database
FILES
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 flysafe 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 | Timastamp of last status change |
Flysafe Grid-Store Catalog
The following three tables are used to implement the Flysafe 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.
FILE_CATALOG
Every file to be stored gets an entry in the FILE_CATALOG table.
| id | ID for file |
| filename | Unique filename |
| filetype | Type of file (MPR, tar, etc) |
| path | Original path of file on Flysafe server |
