DATABASE DESIGN FOR THE MEASURING IN FIELD

DATABASE DESIGN FOR THE MEASURING IN FIELD

Článek recenzovaný mimo WoS a Scopus

The measuring in field is the most commonly used activity in various industrial branches. To be the results useful the data must be stored in a suitable database. There is a problem: to use either one of most of commercial database systems or to create the special purpose designed database? This question is discussed and an own approach of the database design is presented in this paper. The goal is the designed database with minimum of memory capacity occupied and the most rapidly information provided. It is supposed that the basic database design rules e.g. to avoid redundant data (normalization), ensure that the relationships among attributes are represented or facilitate the checking of updates for violation of database integrity constraints are respected. A special optimization method for common attributes reduction, for storing strings of variable length and for database reorganization is used. The database model was implemented in the information system for anticorrosive protection of pipeline,

The measuring in field is the most commonly used activity in various industrial branches. To be the results useful the data must be stored in a suitable database. There is a problem: to use either one of most of commercial database systems or to create the special purpose designed database? This question is discussed and an own approach of the database design is presented in this paper. The goal is the designed database with minimum of memory capacity occupied and the most rapidly information provided. It is supposed that the basic database design rules e.g. to avoid redundant data (normalization), ensure that the relationships among attributes are represented or facilitate the checking of updates for violation of database integrity constraints are respected. A special optimization method for common attributes reduction, for storing strings of variable length and for database reorganization is used. The database model was implemented in the information system for anticorrosive protection of pipeline,

Database, object, measured values, quantities, relational model, E-R diagram, entities, common and individual attributes, equivalent classes, overlay table, optimization..

Database, object, measured values, quantities, relational model, E-R diagram, entities, common and individual attributes, equivalent classes, overlay table, optimization..

BARTONĚK, D.

02.07.2004

Wydawnictwo Akademii Rolniczej we Wroclawiu

Wroclaw, Polsko

1505-0297

ELECTRONIC JOURNAL OF POLISH AGRICULTURAL UNIVERSITIES

2003

6

Polská republika

25

33

9