Fact sheet of the MÉTA database 1.2

F. Horváth, Zs Molnár, J. Bölöni, Zs Pataki, L. Polgár, A. Révész, K. Oláh, D. Krasser, E. Illyés

Research output: Contribution to journalArticle

20 Citations (Scopus)

Abstract

The survey results of the MÉTA program are managed with centralised relational database management system (MS SQL 2000) developed and set up in a local area network. Besides the MÉTA database server, a publishing server, an archiving server and a GIS workstation were applied. The core information entities of the MÉTA database are: information subproject, MÉTA quadrate, MÉTA hexagon, (semi-)natural habitat, potential vegetation with numerous habitats, landscape ecology and land use attributes, and surveyor. This information is coded in the nine main tables of the normalised database. In the recent state there are almost 1,500,000 records in the main tables that are managed in 241 independent fields. The published version of the MÉTA database supports the query service, and handles this information in 7 denormalised main tables. This much more redundant version is 11 GB in size. The 20.6% (179 man-month) of the human resources in the MÉTA program were devoted to the information tasks (set up and preparation, MÉTA database and information system development, replenishment and quality assessment, MÉTA query, GIS and printing services) between 2002 and 2007. The basic structure of the MÉTA database version 1.2 is finalised and the main functions regarding data processing have been developed. The accomplishment is higher than 90%, quality assessment is under way, while scientific verification and data harmonisation are started. The area of (semi-)natural and degraded vegetation of Hungary is estimated to 1,800,000 hectares (19.4% of the country) of which the natural, semi-natural is about 1,200,000 hectares (12.9% of the country). All of these are highly fragmented and unevenly distributed over the country. It is shown by several basic figures, professional content and quality measure facts of the database. There is also a fact sheet of surveyors that shapes the important characters of their field experience profile, too.

Original languageEnglish
Pages (from-to)11-34
Number of pages24
JournalActa Botanica Hungarica
Volume50
Issue numberSUPPL. 1
DOIs
Publication statusPublished - Mar 2008

Fingerprint

GIS
landscape ecology
vegetation
habitat
human resource
information systems
habitats
Hungary
human resources
information system
management systems
land use
programme
services
attribute
relational database

Keywords

  • GIS
  • Landscape ecology
  • Relational database management system
  • Vegetation survey

ASJC Scopus subject areas

  • Ecology, Evolution, Behavior and Systematics
  • Plant Science

Cite this

Horváth, F., Molnár, Z., Bölöni, J., Pataki, Z., Polgár, L., Révész, A., ... Illyés, E. (2008). Fact sheet of the MÉTA database 1.2. Acta Botanica Hungarica, 50(SUPPL. 1), 11-34. https://doi.org/10.1556/ABot.50.2008.Suppl.2

Fact sheet of the MÉTA database 1.2. / Horváth, F.; Molnár, Zs; Bölöni, J.; Pataki, Zs; Polgár, L.; Révész, A.; Oláh, K.; Krasser, D.; Illyés, E.

In: Acta Botanica Hungarica, Vol. 50, No. SUPPL. 1, 03.2008, p. 11-34.

Research output: Contribution to journalArticle

Horváth, F, Molnár, Z, Bölöni, J, Pataki, Z, Polgár, L, Révész, A, Oláh, K, Krasser, D & Illyés, E 2008, 'Fact sheet of the MÉTA database 1.2', Acta Botanica Hungarica, vol. 50, no. SUPPL. 1, pp. 11-34. https://doi.org/10.1556/ABot.50.2008.Suppl.2
Horváth F, Molnár Z, Bölöni J, Pataki Z, Polgár L, Révész A et al. Fact sheet of the MÉTA database 1.2. Acta Botanica Hungarica. 2008 Mar;50(SUPPL. 1):11-34. https://doi.org/10.1556/ABot.50.2008.Suppl.2
Horváth, F. ; Molnár, Zs ; Bölöni, J. ; Pataki, Zs ; Polgár, L. ; Révész, A. ; Oláh, K. ; Krasser, D. ; Illyés, E. / Fact sheet of the MÉTA database 1.2. In: Acta Botanica Hungarica. 2008 ; Vol. 50, No. SUPPL. 1. pp. 11-34.
@article{9f720bf37772492bb5f9ba8b86e15766,
title = "Fact sheet of the M{\'E}TA database 1.2",
abstract = "The survey results of the M{\'E}TA program are managed with centralised relational database management system (MS SQL 2000) developed and set up in a local area network. Besides the M{\'E}TA database server, a publishing server, an archiving server and a GIS workstation were applied. The core information entities of the M{\'E}TA database are: information subproject, M{\'E}TA quadrate, M{\'E}TA hexagon, (semi-)natural habitat, potential vegetation with numerous habitats, landscape ecology and land use attributes, and surveyor. This information is coded in the nine main tables of the normalised database. In the recent state there are almost 1,500,000 records in the main tables that are managed in 241 independent fields. The published version of the M{\'E}TA database supports the query service, and handles this information in 7 denormalised main tables. This much more redundant version is 11 GB in size. The 20.6{\%} (179 man-month) of the human resources in the M{\'E}TA program were devoted to the information tasks (set up and preparation, M{\'E}TA database and information system development, replenishment and quality assessment, M{\'E}TA query, GIS and printing services) between 2002 and 2007. The basic structure of the M{\'E}TA database version 1.2 is finalised and the main functions regarding data processing have been developed. The accomplishment is higher than 90{\%}, quality assessment is under way, while scientific verification and data harmonisation are started. The area of (semi-)natural and degraded vegetation of Hungary is estimated to 1,800,000 hectares (19.4{\%} of the country) of which the natural, semi-natural is about 1,200,000 hectares (12.9{\%} of the country). All of these are highly fragmented and unevenly distributed over the country. It is shown by several basic figures, professional content and quality measure facts of the database. There is also a fact sheet of surveyors that shapes the important characters of their field experience profile, too.",
keywords = "GIS, Landscape ecology, Relational database management system, Vegetation survey",
author = "F. Horv{\'a}th and Zs Moln{\'a}r and J. B{\"o}l{\"o}ni and Zs Pataki and L. Polg{\'a}r and A. R{\'e}v{\'e}sz and K. Ol{\'a}h and D. Krasser and E. Illy{\'e}s",
year = "2008",
month = "3",
doi = "10.1556/ABot.50.2008.Suppl.2",
language = "English",
volume = "50",
pages = "11--34",
journal = "Acta Botanica Hungarica",
issn = "0236-6495",
publisher = "Akademiai Kiado",
number = "SUPPL. 1",

}

TY - JOUR

T1 - Fact sheet of the MÉTA database 1.2

AU - Horváth, F.

AU - Molnár, Zs

AU - Bölöni, J.

AU - Pataki, Zs

AU - Polgár, L.

AU - Révész, A.

AU - Oláh, K.

AU - Krasser, D.

AU - Illyés, E.

PY - 2008/3

Y1 - 2008/3

N2 - The survey results of the MÉTA program are managed with centralised relational database management system (MS SQL 2000) developed and set up in a local area network. Besides the MÉTA database server, a publishing server, an archiving server and a GIS workstation were applied. The core information entities of the MÉTA database are: information subproject, MÉTA quadrate, MÉTA hexagon, (semi-)natural habitat, potential vegetation with numerous habitats, landscape ecology and land use attributes, and surveyor. This information is coded in the nine main tables of the normalised database. In the recent state there are almost 1,500,000 records in the main tables that are managed in 241 independent fields. The published version of the MÉTA database supports the query service, and handles this information in 7 denormalised main tables. This much more redundant version is 11 GB in size. The 20.6% (179 man-month) of the human resources in the MÉTA program were devoted to the information tasks (set up and preparation, MÉTA database and information system development, replenishment and quality assessment, MÉTA query, GIS and printing services) between 2002 and 2007. The basic structure of the MÉTA database version 1.2 is finalised and the main functions regarding data processing have been developed. The accomplishment is higher than 90%, quality assessment is under way, while scientific verification and data harmonisation are started. The area of (semi-)natural and degraded vegetation of Hungary is estimated to 1,800,000 hectares (19.4% of the country) of which the natural, semi-natural is about 1,200,000 hectares (12.9% of the country). All of these are highly fragmented and unevenly distributed over the country. It is shown by several basic figures, professional content and quality measure facts of the database. There is also a fact sheet of surveyors that shapes the important characters of their field experience profile, too.

AB - The survey results of the MÉTA program are managed with centralised relational database management system (MS SQL 2000) developed and set up in a local area network. Besides the MÉTA database server, a publishing server, an archiving server and a GIS workstation were applied. The core information entities of the MÉTA database are: information subproject, MÉTA quadrate, MÉTA hexagon, (semi-)natural habitat, potential vegetation with numerous habitats, landscape ecology and land use attributes, and surveyor. This information is coded in the nine main tables of the normalised database. In the recent state there are almost 1,500,000 records in the main tables that are managed in 241 independent fields. The published version of the MÉTA database supports the query service, and handles this information in 7 denormalised main tables. This much more redundant version is 11 GB in size. The 20.6% (179 man-month) of the human resources in the MÉTA program were devoted to the information tasks (set up and preparation, MÉTA database and information system development, replenishment and quality assessment, MÉTA query, GIS and printing services) between 2002 and 2007. The basic structure of the MÉTA database version 1.2 is finalised and the main functions regarding data processing have been developed. The accomplishment is higher than 90%, quality assessment is under way, while scientific verification and data harmonisation are started. The area of (semi-)natural and degraded vegetation of Hungary is estimated to 1,800,000 hectares (19.4% of the country) of which the natural, semi-natural is about 1,200,000 hectares (12.9% of the country). All of these are highly fragmented and unevenly distributed over the country. It is shown by several basic figures, professional content and quality measure facts of the database. There is also a fact sheet of surveyors that shapes the important characters of their field experience profile, too.

KW - GIS

KW - Landscape ecology

KW - Relational database management system

KW - Vegetation survey

UR - http://www.scopus.com/inward/record.url?scp=62249177154&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=62249177154&partnerID=8YFLogxK

U2 - 10.1556/ABot.50.2008.Suppl.2

DO - 10.1556/ABot.50.2008.Suppl.2

M3 - Article

VL - 50

SP - 11

EP - 34

JO - Acta Botanica Hungarica

JF - Acta Botanica Hungarica

SN - 0236-6495

IS - SUPPL. 1

ER -