Jan Tyrychtr

Evaluation of the state of the Business Intelligence among small Czech farms.

Business Intelligence (BI) can assist in agricultural enterprises to strengthen their production potential and tech- nical effi ciency due to its eff ective support to the managerial, analytical, planning, and decision-making activities of man- agers and specialists. However, the state of the BI in the Czech Republic is not still completely understood. In this context, this paper aims at the evaluation of the current state of the art of the BI among small Czech farms. Th e focus of the re search was put on the evaluation of both the state of the BI, and the relevant business information systems and software for agri- culture. Th ere was a survey among 135 agricultural entrepreneurs from various regions in the Czech Republic. Th e survey results are presented by the descriptive statistics and frequency tables. Th ere is an examination of the relationship between the agricultural enterprise structure and the use of the BI. Dependencies among the examined characteristics were sought by the means of the analysis of qualitative variables. With 95% probability, it could be claimed that the type of production, the size of farmed land, the number of employees and the level of fi nancial subsidies have no signifi cant impact on using the BI, the expert and analytical systems in agricultural enterprises.

Multidimensional Modelling from Open Data for Precision Agriculture

The multidimensional data models are most often used for decision support in Business Intelligence field. This paper presents innovative approach for support of knowledge analysis in precision agriculture, where such analytical approach offers great potential for the future. Corner stone of our approach is the creation of knowledge rules based on open data and information available from inside a particular agricultural company. In the next step such explicit knowledge is transformed into multidimensional database and an analytical model for decision support of the farm’s managers is designed. Our approach is demonstrated on example concerning knowledge analysis of one of the agricultural problems – infestation of farm plants by aphids.

EM-OLAP Framework

Econometrics is currently one of the most popular approaches to economic analysis. To better support advances in these areas as much as possible, it is necessary to apply econometric problems to econometric intelligent systems. The article describes an econometric OLAP framework that supports the design of a multidimensional database to secure econometric analyses to increase the effectiveness of the development of econometric intelligent systems. The first part of the article consists of the creation of formal rules for the new transformation of the econometric model (TEM) method for the econometric model transformation of multidimensional schema through the use of mathematical notation. In the proposed TEM method, the authors pay attention to the measurement of quality and understandability of the multidimensional schema, and compare the proposed method with the original TEM-CM method. In the second part of the article, the authors create a multidimensional database prototype according to the new TEM method and design an OLAP application for econometric analysis.

Towards Data Storage for Online Analytical Antispam System – ASOLAP

Junk mail is a major concern of Internet communication. It represents most of the received messages. To filter unsolicited bulk e-mails there is a large amount of human and financial resources and computing resources needed. One way to counter this problem is to maximize the information yield of the obtained unsolicited messages. This article aims to introduce the concept ASOLAP - the use of OLAP to store and analyze metadata of e-mail messages. We propose a conceptual data model and verify its quality. Based on the results, we recommend to use the design of the star schema that represents the potential for quality and efficient solution of the ASOLAP design.

Towards Extension of Open Data Model: Relational Data Model Context

The main purpose for the use of open data (further OD) is to provide content. From the definition of OD there are two important attributes of OD: – machine readable format and reuse without any legal restriction. The issue of the so called “Open data” has recently been intensely investigated and discussed in detail. However, OD benefit can only be realized if the data are true, so called correct. There are a plenty of models of OD and their metrics, the proposed model extends one of the quality attributes called correctness. In the proposed model it seems preferable to use this aggregated attribute rather than individual attributes of quality.

Concept of Econometric Intelligence System: OLAP Applications in the Ambient Intelligence Environment

Econometric analysis is a non-trivial discipline applied to different areas of an enterprise or economy, in order to express economic reality and anticipate economic phenomena. This requires a great deal of econometric knowledge using a number of sophisticated methods and their good capabilities for correct and high quality interpretation of results. Currently, the intelligent system is a solution that is capable of performing highly complex tasks in the same way as people approach these tasks. In the context of ambient intelligence, it is possible to use personalized, contextual awareness and adaptive attributes for the design of an intelligent econometric system. In our work, we focused on the concept of an intelligent econometric system together with the application of OLAP technology for the creation of interactive analytical outputs. This new concept of the system is presented in an example of a data analysis to derive the forecast from the econometric model by designing a multidimensional view of the data.

Possibilities of Use of the Active Knowledge Databases in the Agricultural Sector

This contribution deals with the potential of the so called active knowledge database in conjunction with the agricultural resort. The authors of this contribution initially focus attention on the defining the term active databases, their possible roles and expectations associated with them. Agriculture of the Czech Republic certainly has some potential, which can initiate a qualitative change in the functioning of the entire agricultural sector. The authors also deal with the possibility of the creation of such databases and derive their principles from classical relational databases. The crucial matters of this examination will relational database technology (especially the issue of the database triggers) and the theory of measurement and evaluation of the quality of software products. Active database must be created only on the principles of relational database technology and on these principles must also work. The proposed principles of active databases are then verified through a functional prototype and then are generalized. On the basis of these conclusions are then specified the recommendations, which can significantly increase the benefits of this phenomenon.

Multidimensional Design of OLAP System for Context-Aware Analysis in the Ambient Intelligence Environment

Ambient Intelligence (AmI) is currently a perspective area of development intelligent systems that react on human presence, their behavior and AmI adapts to requirements based on contextual knowledge. The important issue in the study of AmI is thinking about context-aware preference. In the context of ubiquitous computing technologies there is not any access for users to the system at one point, but in different contexts. This creates need for context-sensitive preferences. The aim of context reasoning is getting new knowledge, so that systems or services were more intelligent. This process is not a trivial problem, so that we propose multidimensional view on context-aware knowledge for support of contextual reasoning. In this paper we introduce a new TCAP procedure for transformation context-aware preference through OLAP in the AmI. The OLAP technology enables us better analyzing contextual dependence on preferences and choosing relevant content for users in the AmI environment.

Data Modeling for Precision Agriculture

Presented article deals with issue of data modelling for managerial decision making of entrepreneurs with regards to knowledge management principles. The core line of the approach is capturing of explicit knowledge relevant to given business activities into multidimensional databases that would become part of utilized ICT/IT. These issues are demonstrated on the agriculture domain where the need to computer storage of relevant knowledge and provide them on-demand is very up to date. Recently, it has become very necessary in frequently discussed agriculture technique called precision agriculture.

Systems Theory and Model of Diversification in Building of Information Systems

First the paper characterizes the current situation in the field of building of information systems (IS). It discusses a model based on systems theory which describes some possibilities in diversification of risk in developing of IS. To minimize risk in the process of building information systems it is recommended to use components produced by worldly recognized manufacturers of the highest quality. The main subject of investigation by the present model is to quantify risk and to find the minimum. Finally, the paper mentions the direction for further research of the model described by use of correlations and covariances.