{"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}
{"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}
{"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}
{"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}
{"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}
{"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}
{"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}