An Envisioned Approach for Modeling and Supporting User-Centric Query Activities on Data Warehouses

Abstract

In this vision paper, the authors discuss models and techniques for integrating, processing and querying data, information and knowledge within data warehouses in a user-centric manner. The user-centric emphasis allows us to achieve a number of clear advantages with respect to classical data warehouse architectures, whose most relevant ones are the following: (i) a unified and meaningful representation of multidimensional data and knowledge patterns throughout the data warehouse layers (i.e., loading, storage, metadata, etc); (ii) advanced query mechanisms and guidance that are capable of extracting targeted information and knowledge by means of innovative information retrieval and data mining techniques. Following this main framework, the authors first outline the importance of knowledge representation and management in data warehouses, where knowledge is expressed by existing ontology or patterns discovered from data. Then, the authors propose a user-centric architecture for OLAP query processing, which is the typical applicative interface to data warehouse systems. Finally, the authors propose insights towards cooperative query answering that make use of knowledge management principles and exploit the peculiarities of data warehouses (e.g., multidimensionality, multi-resolution, and so forth).

Analyzing AI-Generated Packaging's Impact on Consumer Satisfaction With Three Types of Datasets

“…Once a comprehensive data warehouse has been established, it can facilitate the visualization of the packaging design and service management processes. A data warehouse provides robust analyzing and querying functions, enabling design teams to easily track project progress, allocate resources, and control quality (Aufaure et al, 2013;Farnum et al, 2019). Additionally, data analysis tools can be used to analyze user preferences, packaging functionality, packaging design, and production processes.…”

Encyclopedia of Database Systems

“…The role played by external data in current OLAP systems and the need to assist the user to explore these data repositories is addressed in [3]. There, the authors discuss how to capture the semantics of the queries posed by the users and exploit them to assist the user in her future analysis.…”