Reverse Pivoting in Conceptual Information Systems
Herausgeber: H. Delugach, G. Stumme
Buchtitel: Conceptual Structures: Broadening the Base. Proc. ICCS '01
Reihe: LNAI 2120
Verlag: Springer, Heidelberg 2001
In database marketing, the behavior of customers is ana- lyzed 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 requir- ing an implementation in SQL. In this paper, we present a construction for conceptual scales for reverse pivoting in Conceptual Information Sys- tems, 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.