Current Proceedings on Technology
Yazarlar: Kolyo Onkov, Hristo Bozukov, Maria Kasheva
Konular:-
Anahtar Kelimeler:Multidimensional database,Data cubes,Tobacco varieties,Pest management,Statistical time series,User friendly environment
Özet: Information and knowledge on tobacco production is multi-aspect, heterogeneous, semi-structured and stored in different information sources. The paper presents a multidimensional database where data cubes are used for database building, thus giving the opportunity to store contextually related information on tobacco production in hierarchical structures. The relational database model presents four dimensions: Phytopharmacy, Varieties, Statistics and Legislation. The concept is used for integration of expert information on tobacco production in Bulgaria regarding: pests and permitted for use pesticides; tobacco groups and varieties including description of their biological features, chemical composition of tobacco and tobacco smoke, etc.; statistical time series on areas and quantity production; legislative documents. The presented solution is: a) hierarchically structured multidimensional database which integrates extracted information on tobacco production from different sources; b) open system as it regards to the number of dimensions and updates of stored information; c) platform for building databases which can integrate information on diverse crops in other countries, as well; d) user-friendly environment which helps the users to avoid the difficulties associated with finding and working with information in different files and formats. This solution increases expertise of scientists, teachers, experts and managers in their academic work and in the process of decision-making.