On-line analytical processing with conceptual information systems

A conceptual information system consists of a database together with conceptual hierarchies. The management system TOSCANA visualizes arbitrary combinations of conceptual hierarchies by nested line diagrams and allows an on-line interaction with a database to analyze data conceptually. The paper describes the conception of conceptual information systems and discusses the use of their visualization techniques for on-line analytical processing (OLAP).

Numerical aspects in the data model of conceptual information systems

While most data analysis and decision support tools use numerical aspects of the data, Conceptual Information Systems focus on their conceptual structure. This paper discusses how both approaches can be combined.

Acquiring expert knowledge for the design of conceptual information systems

Conceptual Information Systems unfold the conceptual structure of data stored in relational databases. In the design phase of the system, conceptual hierarchies have to be created which describe different aspects of the data. In this paper, we describe two principal ways of designing such conceptual hierarchies, data driven design and theory driven design and discuss advantages and drawbacks. The central part of the paper shows how Attribute Exploration, a knowledge acquisition tool developped by B. Ganter can be applied for narrowing the gap between both approaches.

Dual retrieval in conceptual information systems

Conceptual Information Systems provide a multi-dimensional conceptually structured view on data stored in relational databases. On restricting the expressiveness of the retrieval language, they allow the visualization of sets of realted queries in conceptual hierarchies, hence supporting the search of something one does not have a precise description, but only a vague idea of. Information Retrieval is considered as the process of finding specific objects (documents etc.) out of a large set of objects which fit to some description. In some data analysis and knowledge discovery applications, the dual task is of interest: The analyst needs to determine, for a subset of objects, a description for this subset. In this paper we discuss how Conceptual Information Systems can be extended to support also the second task.

Conceptual information systems discussed through an IT-security tool

Conceptual Information Systems are based on a formalization of the concept of "concept" as it is discussed in traditional philosophical logic. This formalization supports a human-centered approach to the development of Information Systems. We discuss this approach by means of an implemented Conceptual Information System for supporting IT security management in companies and organizations.

Reverse pivoting in conceptual information systems

In database marketing, the behavior of customers is analyzed by studying the transactions they have performed. In order to get a global picture of the behavior of a customer, his single transactions have to be composed together. In On-Line Analytical Processing, this operation is known as reverse pivoting. With the ongoing data analysis process, reverse pivoting has to be repeated several times, usually requiring an implementation in SQL. In this paper, we present a construction for conceptual scales for reverse pivoting in Conceptual Information Systems, and also discuss the visualization. The construction allows the reuse of previously created queries without reprogramming and offers a visualization of the results by line diagrams.

Ideotyping integrated aquaculture systems to balance soil nutrients

Due to growing land scarcity and lack of nutrient inputs, African farmers switched from shifting cultivation to continuous cropping and extended crop area by bringing fragile lands such as river banks and hill slopes into production. This accelerated soil fertility decline caused by erosion, harvesting and insufficient nutrient replenishment. We explored the feasibility to reduce nutrient depletion by increasing nutrient utilization efficiencies, while diversifying and increasing food production through the development of integrated aquaculture – agriculture (IAA). Considering the climatic conditions prevailing in Kenyan highlands, aquaculture production scenarios were ideotyped per agro-ecological zone. These aquaculture production scenarios were integrated into existing NUTrient MONitoring (NUTMON) farm survey data for the area. The nutrient balances and flows of the resulting IAA-systems were compared to present land use. The effects of IAA development on nutrient depletion and total food production were evaluated. With the development of IAA systems, nutrient depletion rates dropped by 23–35%, agricultural production increased by 2–26% and overall farm food production increased by 22–70%. The study demonstrates that from a bio-physical point of view, the development of IAA-systems in Africa is technically possible and could raise soil fertility and total farm production. Further studies that evaluate the economic feasibility and impacts on the livelihood of farming households are recommended.

Socio-economic characterization of integrated cropping systems in urban and peri-urban agriculture of Faisalabad, Pakistan

Faisalabad city is surrounded by agricultural lands, where farmers are growing vegetables, grain crops, and fodder for auto-consumption and local marketing. To study the socioeconomic impact and resource use in these urban and peri-urban agricultural production (UPA) systems, a baseline survey was conducted during 2009–2010. A total of 140 households were selected using a stratified sampling method and interviewed with a structured questionnaire. The results revealed that 96 % of the households rely on agriculture as their main occupation. Thirty percent of the households were owners of the land and the rest cultivated either rented or sharecropped land. Most of the families (70 %) were headed by a member with primary education, and only 10 % of the household head had a secondary school certificate. Irrigationwater was obtained from waste water (37 %), canals (27 %), and mixed alternative sources (36 %). A total of 35 species were cultivated in the UPA systems of which were 65% vegetables, 15% grain and fodder crops, and 5% medicinal plants. Fifty-nine percent of the households cultivated wheat, mostly for auto-consumption. The 51 % of the respondents grew cauliflower (Brassica oleracea L.) and gourds (Cucurbitaceae) in the winter and summer seasons, respectively. Group marketing was uncommon and most of the farmers sold their produce at the farm gate (45 %) and on local markets (43 %). Seeds and fertilizers were available from commission agents and dealers on a credit basis with the obligation to pay by harvested produce. A major problem reported by the UPA farmers of Faisalabad was the scarcity of high quality irrigation water, especially during the hot dry summer months, in addition to lacking adequate quantities of mineral fertilizers and other inputs during sowing time. Half of the respondents estimated their daily income to be less than 1.25 US$ and spent almost half of it on food. Monthly average household income and expenses were 334 and 237 US$, respectively.