Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP最新文献

筛选
英文 中文
Towards a Programmable Semantic Extract-Transform-Load Framework for Semantic Data Warehouses 面向语义数据仓库的可编程语义提取-转换-加载框架
Rudra Pratap Deb Nath, K. Hose, T. Pedersen
{"title":"Towards a Programmable Semantic Extract-Transform-Load Framework for Semantic Data Warehouses","authors":"Rudra Pratap Deb Nath, K. Hose, T. Pedersen","doi":"10.1145/2811222.2811229","DOIUrl":"https://doi.org/10.1145/2811222.2811229","url":null,"abstract":"In order to create better decisions for business analytics, organizations increasingly use external data, structured, semi-structured and unstructured, in addition to the (mostly structured) internal data. Current Extract-Transform-Load (ETL) tools are not suitable for this \"open world scenario\" because they do not consider semantic issues in the integration process. Also, current ETL tools neither support processing semantic-aware data nor create a Semantic Data Warehouse (DW) as a semantic repository of semantically integrated data. This paper describes SETL: a (Python-based) programmable Semantic ETL framework. SETL builds on Semantic Web (SW) standards and tools and supports developers by offering a number of powerful modules, classes and methods for (dimensional and semantic) DW constructs and tasks. Thus it supports semantic-aware data sources, semantic integration, and creating a semantic DW, composed of an ontology and its instances. A comprehensive experimental evaluation comparing SETL to a solution made with traditional tools (requiring much more hand-coding) on a concrete use case, shows that SETL provides better performance, knowledge base quality and programmer productivity.","PeriodicalId":397992,"journal":{"name":"Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP","volume":"30 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2015-10-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"130737120","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 44
Efficient Visualisation of the Relative Distribution of Keyword Search Results in a Corpus Data Cube 语料库数据立方中关键词搜索结果相对分布的高效可视化
M. Sifer, Y. Watanobe, S. Bhalla
{"title":"Efficient Visualisation of the Relative Distribution of Keyword Search Results in a Corpus Data Cube","authors":"M. Sifer, Y. Watanobe, S. Bhalla","doi":"10.1145/2811222.2811234","DOIUrl":"https://doi.org/10.1145/2811222.2811234","url":null,"abstract":"Most keyword searches target precision for finding the most relevant document. However some target recall, finding all relevant documents. Our system supports high recall searches that return hundreds or thousands of relevant results. In particular, it provides a visualization that shows the distribution of search results relative to the distribution of items for the entire corpus. Such relative distributional features include over and under representation, clusters and outliers. The contribution of this paper is efficient visualisation, that is, how to provide the best relative distribution view for a given data cube size. This requirement is translated to: for which limited size meta-data summary cube are search results disambiguated the most in our relative distribution view. We identify metrics and several algorithms for such a summary cube selection.","PeriodicalId":397992,"journal":{"name":"Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2015-10-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"129873307","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 1
Session details: Text Processing 会话详细信息:文本处理
C. Ordonez
{"title":"Session details: Text Processing","authors":"C. Ordonez","doi":"10.1145/3247587","DOIUrl":"https://doi.org/10.1145/3247587","url":null,"abstract":"","PeriodicalId":397992,"journal":{"name":"Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2015-10-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"129996586","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 0
Big Data Design 大数据设计
A. Abelló
{"title":"Big Data Design","authors":"A. Abelló","doi":"10.1145/2811222.2811235","DOIUrl":"https://doi.org/10.1145/2811222.2811235","url":null,"abstract":"It is widely accepted today that Relational databases are not appropriate in highly distributed shared-nothing architectures of commodity hardware, that need to handle poorly structured heterogeneous data. This has brought the blooming of NoSQL systems with the purpose of mitigating such problem, specially in the presence of analytical workloads. Thus, the change in the data model and the new analytical needs beyond OLAP take us to rethink methods and models to design and manage these newborn repositories. In this paper, we will analyze state of the art and future research directions.","PeriodicalId":397992,"journal":{"name":"Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP","volume":"74 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2015-10-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"127615655","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 24
SWOT: A Conceptual Data Warehouse Model for Semantic Trajectories SWOT:语义轨迹的概念数据仓库模型
M. T. D. Silva, V. Times, J. Macêdo, C. Renso
{"title":"SWOT: A Conceptual Data Warehouse Model for Semantic Trajectories","authors":"M. T. D. Silva, V. Times, J. Macêdo, C. Renso","doi":"10.1145/2811222.2811232","DOIUrl":"https://doi.org/10.1145/2811222.2811232","url":null,"abstract":"The increasing availability of positioning data fostered a number of new applications where the knowledge about mobility patterns is essential. However, the research conducted so far on mobility analysis focused on the geometric aspect at the expenses of the semantics of the movement. In this paper, we offer a new vision of semantic trajectory data warehouse that combines the pure geometrical features in terms of temporal and geographical coordinates with more semantic-related contextual information such as the goal of the movement and the transportation means of the moving object, or the activity performed by the moving entity. The conceptual model proposed is called SWOT and is capable of combining these aspects, thus providing a considerable improvement in answering semantic enriched mobility queries.","PeriodicalId":397992,"journal":{"name":"Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2015-10-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"121117833","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 10
Resolving Common Analytical Tasks in Text Databases 解决文本数据库中的常见分析任务
Sebastian Arnold, Alexander Löser, T. Kilias
{"title":"Resolving Common Analytical Tasks in Text Databases","authors":"Sebastian Arnold, Alexander Löser, T. Kilias","doi":"10.1145/2811222.2811224","DOIUrl":"https://doi.org/10.1145/2811222.2811224","url":null,"abstract":"With the convergence of data warehousing, online analytical processing and the Semantic Web, analytical tasks are no longer only designed and executed by experts. Instead, various users expect to query keyword search engines with analytical intentions. One efficient approach to answer these tasks is to leverage the factual information stored in large-scale text databases. These systems enable analysts to access unstructured text sources from the Web with structured query languages. The challenge of mapping keyword queries to structured queries has been approached in various forms. However, these systems are not able to detect the underlying intent of a task. Thus, they cannot infer the user's expectations towards specificity and form of the results. Moreover, a large fraction of queries for retrieving analytical results is rare. As a result, services for intent-aware task recognition perform poorly or are not even triggered on these long-tail queries. We report from a study over 102,360 query and click patterns from a factual search engine. Our analysis reveals six common analytical tasks: explore, relate, resolve, list, compare and answer. To distinguish among these, we study the effects of syntactical structures in the query, methods for interactive entity detection and query segmentation techniques. We evaluate these features on language models and Naive Bayes classifiers. From our evaluation we report a combined F1 score of 90% for the prediction of task intent from keyword queries.","PeriodicalId":397992,"journal":{"name":"Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP","volume":"2 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2015-10-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"128729799","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 2
Homogenizing Data and Metadata Retrieval in Scientific Applications 科学应用中的数据同质化和元数据检索
D. Misev, P. Baumann
{"title":"Homogenizing Data and Metadata Retrieval in Scientific Applications","authors":"D. Misev, P. Baumann","doi":"10.1145/2811222.2811223","DOIUrl":"https://doi.org/10.1145/2811222.2811223","url":null,"abstract":"Support for large arrays has been increasingly gaining attention by the database community. Array databases are a quickly expanding category of database management systems that treat large, multidimensional array data as first-class database citizens, allowing convenient and efficient storage and retrieval. Large array data on its own, however, is rarely meaningful or machine understandable. Therefore, arrays are almost always linked to additional, small metadata, typically managed in relational databases. This leads to an information integration gap, an \"impedance mismatch\" that we address with the work presented in this paper. We aim to remedy this with ASQL (Array SQL), an augmentation of the standard relational database language SQL with multidimensional array processing capabilities. Besides core ASQL concepts, this paper presents a general mediator approach to implementing it by combining a relational with an array DBMS. This improves on the most common situation of systems specializing in either relational or array processing, but not both. In particular we implement ASQLDB on top of the array DBMS rasdaman and relational DBMS HSQLDB, and demonstrate its potential for practical applicability through real world use cases. Initial benchmark comparisons against another array DBMS with a similar goal but rather different approach reveal advantageous results for ASQL.","PeriodicalId":397992,"journal":{"name":"Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2015-10-22","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"128825021","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
引用次数: 6
0
×
引用
GB/T 7714-2015
复制
MLA
复制
APA
复制
导出至
BibTeX EndNote RefMan NoteFirst NoteExpress
×
提示
您的信息不完整,为了账户安全,请先补充。
现在去补充
×
提示
您因"违规操作"
具体请查看互助需知
我知道了
×
提示
确定
请完成安全验证×
相关产品
×
本文献相关产品
联系我们:info@booksci.cn Book学术提供免费学术资源搜索服务,方便国内外学者检索中英文文献。致力于提供最便捷和优质的服务体验。 Copyright © 2023 布克学术 All rights reserved.
京ICP备2023020795号-1
ghs 京公网安备 11010802042870号
Book学术文献互助
Book学术文献互助群
群 号:604180095
Book学术官方微信
小红书