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.
منابع مشابه
Complete pivoting strategy for the $IUL$ preconditioner obtained from Backward Factored APproximate INVerse process
In this paper, we use a complete pivoting strategy to compute the IUL preconditioner obtained as the by-product of the Backward Factored APproximate INVerse process. This pivoting is based on the complete pivoting strategy of the Backward IJK version of Gaussian Elimination process. There is a parameter $alpha$ to control the complete pivoting process. We have studied the effect of dif...
متن کاملInvestigation of the Status of IoT-Based Health Information Systems in a Three-Dimensional Conceptual Framework
Introduction: The ability to transfer data over the Internet of Things (IoT) to make right and timely decisions through accurate data collection has provided incredible interactive power and has resulted in an intelligent world with automated decision-making capability. The objective of this study was to investigate the status of IoT-based health information systems in a three-dimensional conce...
متن کاملInvestigation of the Status of IoT-Based Health Information Systems in a Three-Dimensional Conceptual Framework
Introduction: The ability to transfer data over the Internet of Things (IoT) to make right and timely decisions through accurate data collection has provided incredible interactive power and has resulted in an intelligent world with automated decision-making capability. The objective of this study was to investigate the status of IoT-based health information systems in a three-dimensional conce...
متن کاملDatabase Reverse Engineering
Database reverse engineering consists of recovering the abstract descriptions of files and databases of legacy information systems. A legacy information system can be defined as a “data-intensive application, such as [a] business system based on hundreds or thousands of data files (or tables), that significantly resists modifications and changes” (Brodie & Stonebraker, 1995). The objective of d...
متن کاملRecovering Conceptual Data Models is Human-Intensive
1 To handle the complexity of modern software systems, a software comprehension strategy pointing out the conceptual abstraction level is necessary. In this context, the role of technology is only marginal as the latter produces results which are too closely linked to the implementation aspect, whereas the conceptualization task is typically a human activity. This study proposes a method for da...
متن کامل