Publication result detail

DATABASE DESIGN FOR THE MEASURING IN FIELD

BARTONĚK, D.

Original Title

DATABASE DESIGN FOR THE MEASURING IN FIELD

English Title

DATABASE DESIGN FOR THE MEASURING IN FIELD

Type

Peer-reviewed article not indexed in WoS or Scopus

Original Abstract

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,

English abstract

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,

Keywords

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

Key words in English

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

Authors

BARTONĚK, D.

Released

02.07.2004

Publisher

Wydawnictwo Akademii Rolniczej we Wroclawiu

Location

Wroclaw, Polsko

ISBN

1505-0297

Periodical

ELECTRONIC JOURNAL OF POLISH AGRICULTURAL UNIVERSITIES

Volume

2003

Number

6

State

Republic of Poland

Pages from

25

Pages to

33

Pages count

9

BibTex

@article{BUT49988,
  author="Dalibor {Bartoněk}",
  title="DATABASE DESIGN FOR THE MEASURING IN FIELD",
  journal="ELECTRONIC JOURNAL OF POLISH AGRICULTURAL UNIVERSITIES",
  year="2004",
  volume="2003",
  number="6",
  pages="25--33",
  issn="1505-0297"
}