research-article

The benefits of the interaction between data warehouses and question answering

Authors:

Antonio Ferrández,

Jesús PeralAuthors Info & Claims

EDBT '10: Proceedings of the 2010 EDBT/ICDT Workshops

Article No.: 15, Pages 1 - 8

https://doi.org/10.1145/1754239.1754256

Published: 22 March 2010 Publication History

Abstract

Business Intelligence (BI) applications allow their users to query, understand, and analyze existing data within their organizations in order to acquire useful knowledge, thus making better decisions. The core of BI applications is a data warehouse (DW) which integrates several heterogeneous data sources, mainly structured transactional databases. However, a new trend has emerged, since users of BI applications no longer limit their analysis to structured databases, and they also need unstructured sources to empower their analysis (i.e. data from the Web, company-internal reports, emails, etc.). Therefore, the ability to manage this available information is crucial for the success of the decision making process. Unfortunately, this new useful data, although easily available for companies, are often found in unstructured data (such as web pages, internal reports, emails, and so on) which make it unuseful for feeding the DW beneath BI applications. To shed light on this scenario, in this paper, we propose a novel model for using ontologies to integrate Question Answering (QA) systems in the DW. The great benefit of using QA is that specific pieces of data (i.e. answers) that will empower the analysis are detected, obtained and returned from unstructured data in order to feed the DW.

References

[1]

Badia, A. (2006). Text warehousing: Present and future. In Processing and Managing Complex Data for Decision Support, J. Darmont and O. Boussaïd, Eds. Idea Group Publishing, pp. 96--121.

[2]

Ferrández, S., Toral, A., Ferrández, O., Ferrández, A., Muñoz, R. (2009). Exploiting Wikipedia and EuroWordNet to Solve Cross--Lingual Question Answering. Information Sciences 179 (20), pp. 3473--3488.

Digital Library

[3]

Ferrández, A., Palomar, M., Moreno, L. (1999). An empirical approach to Spanish anaphora resolution. Machine Translation, 14(3/4), pp. 191--216.

Digital Library

[4]

Ferrandez, S., Roger, S., Ferrandez, A., López-Moreno, P. (2006). A New Proposal of Word Sense Disambiguation for Nouns on a Question Answering System. Research in Computing Science, 18, pp. 83--92.

[5]

Fridman, N., Musen, M. A. (2000). Prompt: algorithm and tool for automated ontology merging and alignment. In Proceedings of Seventeenth National Conference on Artificial Intelligence (AAAI-2000), pp. 450--455.

Digital Library

[6]

Henrich, A., Morgenroth, K. (2003). Supporting Collaborative Software Development by Context-Aware Information Retrieval Facilities. In Proceedings of the DEXA 2003 Workshop on Web Based Collaboration (WBC 2003), pp. 249--253.

Digital Library

[7]

Jovanovic, J. and Gasevic, D. (2005). Achieving knowledge interoperability: an XML/XSLT approach. Expert systems with applications 29 (3), pp. 535--553.

Digital Library

[8]

Kimball, R. and Ross, M. (2002). The data warehouse toolkit: the complete guide to dimensional modelling, Wiley.

Digital Library

[9]

Llopis, F., Vicedo, JL, Ferrández, A., (2003). IR-n System at CLEF-2002. LNCS 2785, pp. 291--300.

[10]

Luján-Mora, S., Trujillo, J., Song, I. (2006). A UML profile for multidimensional modeling in data warehouses. Data Knowl. Eng. 59 (3), pp. 725--769

Digital Library

[11]

McCabe, M. C., Lee, J., Chowdhury, A., Grossman, D., Frieder, O., (2000). On the design and evaluation of a multi-dimensional approach to information retrieval. In Proceedings of the 23rd annual international ACM SIGIR conference on Research and development in information retrieval, pp. 363--365.

Digital Library

[12]

McGuinness, D., Fikes, R., Rice, J., Wilder, S. (2000). An environment for merging and testing large ontologies. In Proceedings of the 7th International Conference on Principles of Knowledge Representation and Reasoning, pp. 483--493.

[13]

Miller, G.; Beckwith, R.; Fellbaum, C.; Gross, D.; Miller, K. (1993). Five Papers on WordNet (revised in 1993). Special issue of the international journal of lexicography 3(4).

[14]

Pérez, J. M. (2007). Contextualizing a Data Warehouse with Documents. Ph. D. Thesis.

[15]

Persson, A., Gustavsson, H., Lings, B., Lundell, B., Mattsson, A., and Ärlig, U. (2005). OSS tools in a heterogeneous environment for embedded systems modelling: an analysis of adoptions of XMI. In 5-WOSSE: Proceedings of the fifth workshop on Open source software engineering. pp. 1--4.

Digital Library

[16]

Priebe, T., Pernul, G. (2003a). Towards integrative enterprise knowledge portals. In Proceedings of the 12th International Conference on Information and Knowledge Management (CIKM'03), pp. 216--223.

Digital Library

[17]

Priebe, T., Pernul, G. (2003b). Ontology-based Integration of OLAP and Information Retrieval. In Proceedings of the 14th International Workshop on Database and Expert Systems Applications (DEXA'03), pp. 610.

Digital Library

[18]

Qu, S., Wang, Q., Liu, K., Zou, Y. (2007). Data Warehouse Design for Chinese Intelligent Question Answering System Based on Data Mining. In Proceedings of the 2nd International Conference on Innovative Computing, Information and Control (ICICIC 2007), pp. 180.

Digital Library

[19]

Rieger, B., Kleber, A., von Maur, E. (2000). Metadatabased Integration of Qualitative and Quantitative Information Resources Approaching Knowledge Management. In Proceedings of the 8th European Conference of Information Systems, pp. 372--378.

[20]

Roger, S., Vila, K., Ferrández, A., Pardiño, M., Gómez, J. M., Puchol-Blasco, M., Peral, J. (2009). Using AliQAn in Monolingual QA@CLEF 2008. LNCS 5706, pp. 333--336.

Digital Library

Cited By

Biancofiore GDeldjoo YNoia TDi Sciascio ENarducci F(2024)Interactive Question Answering Systems: Literature ReviewACM Computing Surveys10.1145/365763156:9(1-38)Online publication date: 11-Apr-2024
https://dl.acm.org/doi/10.1145/3657631
Franciscatto MErpen de Bona LTrois CDidonet Del FabroFabro MDamasceno Lima J(2024)Situational Data Integration in Question Answering systems: a survey over two decadesKnowledge and Information Systems10.1007/s10115-024-02136-066:10(5875-5918)Online publication date: 18-Jun-2024
https://doi.org/10.1007/s10115-024-02136-0
Ferrández AMaté APeral JTrujillo JGregorio EAufaure M(2018)A framework for enriching Data Warehouse analysis with Question Answering systemsJournal of Intelligent Information Systems10.1007/s10844-014-0351-246:1(61-82)Online publication date: 28-Dec-2018
https://dl.acm.org/doi/10.1007/s10844-014-0351-2
Show More Cited By

Index Terms

The benefits of the interaction between data warehouses and question answering
1. Information systems

Recommendations

A framework for enriching Data Warehouse analysis with Question Answering systems

Business Intelligence (BI) applications allow their users to query, understand, and analyze existing data within their organizations in order to acquire useful knowledge, thus making better strategic decisions. The core of BI applications is a Data ...
Multidimensional Business Benchmarking Analysis on Data Warehouses

Benchmarking analysis has been used extensively in industry for business analytics. Surprisingly, how to conduct benchmarking analysis efficiently over large data sets remains a technical problem untouched. In this paper, the authors formulate benchmark ...
Best Practices in Data Warehousing to Support Business Initiatives and Needs
HICSS '04: Proceedings of the Proceedings of the 37th Annual Hawaii International Conference on System Sciences (HICSS'04) - Track 8 - Volume 8

The paper presents the data warehousing architecture and practices used at a major U.S. retailing company. Many considerations were assessed when deciding which data warehousing architecture to adopt. The paper discusses the two pre-dominant styles in ...

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Other conferences

EDBT '10: Proceedings of the 2010 EDBT/ICDT Workshops

March 2010

290 pages

ISBN:9781605589909

DOI:10.1145/1754239

Copyright © 2010 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 22 March 2010

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Funding Sources

Conference

EDBT/ICDT '10

EDBT/ICDT '10: EDBT/ICDT '10 joint conference

March 22 - 26, 2010

Lausanne, Switzerland

Acceptance Rates

Overall Acceptance Rate 7 of 10 submissions, 70%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

8
Total Citations
View Citations
399
Total Downloads

Downloads (Last 12 months)3
Downloads (Last 6 weeks)1

Reflects downloads up to 24 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Biancofiore GDeldjoo YNoia TDi Sciascio ENarducci F(2024)Interactive Question Answering Systems: Literature ReviewACM Computing Surveys10.1145/365763156:9(1-38)Online publication date: 11-Apr-2024
https://dl.acm.org/doi/10.1145/3657631
Franciscatto MErpen de Bona LTrois CDidonet Del FabroFabro MDamasceno Lima J(2024)Situational Data Integration in Question Answering systems: a survey over two decadesKnowledge and Information Systems10.1007/s10115-024-02136-066:10(5875-5918)Online publication date: 18-Jun-2024
https://doi.org/10.1007/s10115-024-02136-0
Ferrández AMaté APeral JTrujillo JGregorio EAufaure M(2018)A framework for enriching Data Warehouse analysis with Question Answering systemsJournal of Intelligent Information Systems10.1007/s10844-014-0351-246:1(61-82)Online publication date: 28-Dec-2018
https://dl.acm.org/doi/10.1007/s10844-014-0351-2
Aufaure MCuzzocrea AFavre CMarcel PMissaoui R(2013)An Envisioned Approach for Modeling and Supporting User-Centric Query Activities on Data WarehousesInternational Journal of Data Warehousing and Mining10.4018/jdwm.20130401059:2(89-109)Online publication date: Apr-2013
https://doi.org/10.4018/jdwm.2013040105
Abelló ADarmont JEtcheverry LGolfarelli MMazón JNaumann FPedersen TRizzi STrujillo JVassiliadis PVossen G(2013)Fusion CubesInternational Journal of Data Warehousing and Mining10.4018/jdwm.20130401049:2(66-88)Online publication date: Apr-2013
https://doi.org/10.4018/jdwm.2013040104
Trujillo JMaté A(2012)Business Intelligence 2.0: A General OverviewBusiness Intelligence10.1007/978-3-642-27358-2_5(98-116)Online publication date: 2012
https://doi.org/10.1007/978-3-642-27358-2_5
Vila KFerrández A(2011)Model-driven restricted-domain adaptation of question answering systems for business intelligenceProceedings of the 2nd International Workshop on Business intelligencE and the WEB10.1145/1966883.1966893(36-43)Online publication date: 25-Mar-2011
https://dl.acm.org/doi/10.1145/1966883.1966893
Kuchmann-Beauger NAufaure M(2011)Structured data-based q&a system using surface patternsProceedings of the 9th international conference on Flexible Query Answering Systems10.1007/978-3-642-24764-4_4(37-48)Online publication date: 26-Oct-2011
https://dl.acm.org/doi/10.1007/978-3-642-24764-4_4

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents