Detail publikace

DATABASE DESIGN FOR THE MEASURING IN FIELD

BARTONĚK, D.

Originální název

DATABASE DESIGN FOR THE MEASURING IN FIELD

Typ

článek v časopise - ostatní, Jost

Jazyk

angličtina

Originální abstrakt

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,

Klíčová slova

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

Autoři

BARTONĚK, D.

Vydáno

2. 7. 2004

Nakladatel

Wydawnictwo Akademii Rolniczej we Wroclawiu

Místo

Wroclaw, Polsko

ISSN

1505-0297

Periodikum

ELECTRONIC JOURNAL OF POLISH AGRICULTURAL UNIVERSITIES

Ročník

2003

Číslo

6

Stát

Polská republika

Strany od

25

Strany do

33

Strany počet

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"
}