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.

Information systems for you.

Cumple con los requisitos exigidos en la materia de Tecnologías de la Información y Comunicación (TIC) para la preparación del General Certificate Secondary Education (GCSE) en el Reino Unido. El objetivo de este libro es el conocimiento de los sistemas de información y el desarrollo de las habilidades en este área. Se divide en dos secciones: la primera parte, del capítulo uno al veintiséis abarca la parte teórica del programa: definición, características y componentes de los sistemas de información, hardware, software, sistemas de seguridad, bases de datos, transferencia de datos y sus aplicaciones en distintos sectores (educación, salud, oficinas), internet. En la segunda parte, de los capítulos veintisiete al treinta y cuatro, hay tareas prácticas con ejercicios sobre programas de procesamiento de textos, hojas de cálculo, paquetes gráficos, autoedición. Va acompañado del libro del profesor.

Information systems for you. Teacher support pack.

Este recurso para el profesor ayuda en la preparación de clases, ofrece ideas para lecciones y actividades basadas en el libro del alumno, así como, material diseñado para maximizar la utilidad del libro del alumno y que, además, puede ser fotocopiado. Cumple con los requisitos exigidos en la materia de Tecnologías de la Información y Comunicación (TIC) para la preparación del General Certificate Secondary Education (GCSE) en el Reino Unido.