|
COP5: Databases in metrology
Task 1: Collection and review of existing solutions (data models, interfaces, application areas) Survey of existing and planed solutions with respect to different aspects Subtask 1.1: requirements and solutions for the conceptual model (data model) of measurement databases or other metrological databases, i.e. the structure and the relations of the database tables or objects Subtask 1.2: requirements and solutions for the implementation of interactive user interfaces with respect to different user roles such as data retrieval, data management or administration; Subtask 1.3: requirements and solutions for the implementation of interfaces to measurement systems for automatic data input and output Subtask 1.4: specification of desired data base support that could so far not or only partly realized (as, for example, systems for supporting an integrated management of calibration data including reference/standard devices used during calibration, calibrated devices and their calibration history and further data), analysis of the problems
Task 2: Exercises using selected solutions Analysis and evaluation by inspection of selected solutions capable of offering remote access or capable of offering an easy straightforward implementation procedure Subtask 2.1: exercises and evaluation of the kernel of a template database for registering different kinds of measurement, processing and evaluation; (e.g., the solution of PTB realized on the basis of the relational concept and implemented with the MS Access tool as the database 'db1' (file name: db1.mdb)); Subtask 2.2: exercises and evaluation of existing, remotely accessible measurement databases such as the PTB biosignal database or the test environment of the PTB web enabled database for non invasive blood pressure measurements, further examples are highly welcome;
Task 3: Development of recommendations for using standard/non-standard databases Elaboration of recommendations as conclusions from the gathered examples, experiences and discussions Subtask 3.1: recommendations supporting the initial design decisions concerning appropriate system architecture (stand alone or multi-tier systems), suitable DBMS (database management system), and selection of appropriate standard data bases or spreadsheet programs; Subtask 3.2: recommendations supporting the selection of suitable data modeling activities; Subtask 3.3: Recommendations supporting suitable navigational means in user interfaces of metrological databases;
| 
