Oceanographic observation data in relational data base

INTERNATIONAL SYMPOSIUM ON INFORMATION TECHNOLOGY IN OCEANOGRAPHY (ITO-98)

GOA, INDIA 12-16 OCTOBER 1998

Oceanographic observation data in relational data base

Igor Lebedev

Russian Research Institute of Hydrometeorological Information World Data Center (RIHMI-WDC), Department National Center Oceanographic Data of Russia,
6, Korolyova St, Obninsk, Kaluga region, 249020, Russia

Tel: (7)(08439) 74953 Fax: (7)(095) 255-22-25
E-mail: lebedev@meteo.ru

At present oceanographic observation data are generally organized in flat text files, sometimes as records of varying length. Such an approach is warranted from archival storage standpoint, but the problem arise when data are needed from those sets for processing. Organisation of data for modern relational DBMS is an urgent task. Many organizations apply relational DBs and different DBMSs when working with data. It often happens that the data structure represents by itself the normalized version of the structures that have been used before. Ultimately, not only the data transfer to relational DB would be important here but their structure complex designing also.

The author offers the model of presentation of oceanographic observation data for relational DB. Based on the basis of emphasizing general characteristics using the objective approach, the model can be applied for organizing the data under various types of observations. Observation data in the information system, based on the model of observation presentation, are not connected via space-time restrictions or the restrictions on observation type. Using such a model it is possible to choose the data by criteria, assigned particularly to location, or time or type of observation. The data of each particular type of observation can be organized where appropriate by some certain way differed from the others. That is, regulating the data organization on the whole, the model enables one to flexibly and in a different way organize the data in each particular case.

The work is underway at RIHMI-WDC to make this model applicable in realization of the Integrated Data Base on the basis of DBMS Oracle7.

[ITO - 98] [Welcome] [1998 - Internetional Year of the Oceans] [Objectives of ITO-98] [Plenary Lectures] [Technical Sessions] [Commercial/Corporate Presentation] [Exhibition/Demonstration] [Ocean IT CDROM] [Awards/Financial Assistance] [Fees / Charges] [Souvenir] [Post Symposium Event] [International Scientific Programme Committee] [Organizing Committee] [Schedule] [Scientific Programme Summary] [The Host] [Travelling / Accomodation] [Registration Forms] [Abstracts]

"to continously improve our understanding of the seas
around us and to translate this knowledge to benefit all"