VOOL:一个模块化的基于洞察力的框架,用于表达OLAP会话

IF 3 2区 计算机科学 Q2 COMPUTER SCIENCE, INFORMATION SYSTEMS
Matteo Francia, Enrico Gallinucci, Matteo Golfarelli, Stefano Rizzi
{"title":"VOOL:一个模块化的基于洞察力的框架,用于表达OLAP会话","authors":"Matteo Francia,&nbsp;Enrico Gallinucci,&nbsp;Matteo Golfarelli,&nbsp;Stefano Rizzi","doi":"10.1016/j.is.2024.102496","DOIUrl":null,"url":null,"abstract":"<div><div>OLAP streamlines the exploration of multidimensional data cubes by allowing decision-makers to build sessions of analytical queries via a “point-and-click” interaction. However, new scenarios are appearing in which alternative forms of user-system communication, based for instance on natural language, are necessary. To cope with these scenarios, we present VOOL, an extensible framework for the vocalization of the results of OLAP sessions. To avoid flooding the user with long and tedious descriptions, we choose to vocalize only selected insights automatically extracted from query results. Insights are quantitative and rich-in-semantics characterizations of the results of an OLAP query, and they also take into account the user’s intentions as expressed by OLAP operators. Firstly, they are extracted using statistics and machine learning algorithms; then an optimization algorithm is applied to select the most relevant insights respecting a limit on the overall duration of vocalization. Finally, the selected insights are sorted into a comprehensive description that is vocalized to the user. After describing and formalizing our approach, we evaluate it from the points of view of efficiency, effectiveness, and operativity, also by comparing it with LLM-based applications.</div></div>","PeriodicalId":50363,"journal":{"name":"Information Systems","volume":"129 ","pages":"Article 102496"},"PeriodicalIF":3.0000,"publicationDate":"2024-12-02","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"VOOL: A modular insight-based framework for vocalizing OLAP sessions\",\"authors\":\"Matteo Francia,&nbsp;Enrico Gallinucci,&nbsp;Matteo Golfarelli,&nbsp;Stefano Rizzi\",\"doi\":\"10.1016/j.is.2024.102496\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"<div><div>OLAP streamlines the exploration of multidimensional data cubes by allowing decision-makers to build sessions of analytical queries via a “point-and-click” interaction. However, new scenarios are appearing in which alternative forms of user-system communication, based for instance on natural language, are necessary. To cope with these scenarios, we present VOOL, an extensible framework for the vocalization of the results of OLAP sessions. To avoid flooding the user with long and tedious descriptions, we choose to vocalize only selected insights automatically extracted from query results. Insights are quantitative and rich-in-semantics characterizations of the results of an OLAP query, and they also take into account the user’s intentions as expressed by OLAP operators. Firstly, they are extracted using statistics and machine learning algorithms; then an optimization algorithm is applied to select the most relevant insights respecting a limit on the overall duration of vocalization. Finally, the selected insights are sorted into a comprehensive description that is vocalized to the user. After describing and formalizing our approach, we evaluate it from the points of view of efficiency, effectiveness, and operativity, also by comparing it with LLM-based applications.</div></div>\",\"PeriodicalId\":50363,\"journal\":{\"name\":\"Information Systems\",\"volume\":\"129 \",\"pages\":\"Article 102496\"},\"PeriodicalIF\":3.0000,\"publicationDate\":\"2024-12-02\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Information Systems\",\"FirstCategoryId\":\"94\",\"ListUrlMain\":\"https://www.sciencedirect.com/science/article/pii/S0306437924001546\",\"RegionNum\":2,\"RegionCategory\":\"计算机科学\",\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"Q2\",\"JCRName\":\"COMPUTER SCIENCE, INFORMATION SYSTEMS\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Information Systems","FirstCategoryId":"94","ListUrlMain":"https://www.sciencedirect.com/science/article/pii/S0306437924001546","RegionNum":2,"RegionCategory":"计算机科学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q2","JCRName":"COMPUTER SCIENCE, INFORMATION SYSTEMS","Score":null,"Total":0}
引用次数: 0

摘要

OLAP允许决策者通过“指向-点击”交互构建分析查询会话,从而简化了对多维数据集的探索。然而,新的情况正在出现,在这种情况下,用户系统通信的替代形式,例如基于自然语言,是必要的。为了应对这些场景,我们提出了VOOL,这是一个可扩展的框架,用于对OLAP会话的结果进行发声。为了避免向用户提供冗长乏味的描述,我们选择只发出从查询结果中自动提取的精选见解。洞察是对OLAP查询结果的定量和语义丰富的特征描述,它们还考虑到OLAP操作符所表达的用户意图。首先,使用统计学和机器学习算法提取它们;然后应用优化算法来选择最相关的见解,尊重对发声的总持续时间的限制。最后,选择的见解被分类成一个全面的描述,并向用户发出声音。在描述和形式化我们的方法之后,我们从效率、有效性和可操作性的角度对其进行评估,并将其与基于llm的应用程序进行比较。
本文章由计算机程序翻译,如有差异,请以英文原文为准。
VOOL: A modular insight-based framework for vocalizing OLAP sessions
OLAP streamlines the exploration of multidimensional data cubes by allowing decision-makers to build sessions of analytical queries via a “point-and-click” interaction. However, new scenarios are appearing in which alternative forms of user-system communication, based for instance on natural language, are necessary. To cope with these scenarios, we present VOOL, an extensible framework for the vocalization of the results of OLAP sessions. To avoid flooding the user with long and tedious descriptions, we choose to vocalize only selected insights automatically extracted from query results. Insights are quantitative and rich-in-semantics characterizations of the results of an OLAP query, and they also take into account the user’s intentions as expressed by OLAP operators. Firstly, they are extracted using statistics and machine learning algorithms; then an optimization algorithm is applied to select the most relevant insights respecting a limit on the overall duration of vocalization. Finally, the selected insights are sorted into a comprehensive description that is vocalized to the user. After describing and formalizing our approach, we evaluate it from the points of view of efficiency, effectiveness, and operativity, also by comparing it with LLM-based applications.
求助全文
通过发布文献求助,成功后即可免费获取论文全文。 去求助
来源期刊
Information Systems
Information Systems 工程技术-计算机:信息系统
CiteScore
9.40
自引率
2.70%
发文量
112
审稿时长
53 days
期刊介绍: Information systems are the software and hardware systems that support data-intensive applications. The journal Information Systems publishes articles concerning the design and implementation of languages, data models, process models, algorithms, software and hardware for information systems. Subject areas include data management issues as presented in the principal international database conferences (e.g., ACM SIGMOD/PODS, VLDB, ICDE and ICDT/EDBT) as well as data-related issues from the fields of data mining/machine learning, information retrieval coordinated with structured data, internet and cloud data management, business process management, web semantics, visual and audio information systems, scientific computing, and data science. Implementation papers having to do with massively parallel data management, fault tolerance in practice, and special purpose hardware for data-intensive systems are also welcome. Manuscripts from application domains, such as urban informatics, social and natural science, and Internet of Things, are also welcome. All papers should highlight innovative solutions to data management problems such as new data models, performance enhancements, and show how those innovations contribute to the goals of the application.
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
copy
已复制链接
快去分享给好友吧!
我知道了
右上角分享
点击右上角分享
0
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:481959085
Book学术官方微信