Skip to main content
SpringerLink
Log in

A multidimensional data model using the fuzzy model based on the semantic translation

  • Published:
Information Systems Frontiers Aims and scope Submit manuscript

Abstract

With the rapid development of Web 2.0 sites such as Blogs and Wikis users are encouraged to express opinions about certain products, services or social topics over the web. There is a method for aggregating these opinions, called Opinion Aggregation, which is made up of four steps: Collect, Identify, Classify and Aggregate. In this paper, we present a new conceptual multidimensional data model based on the Fuzzy Model based on the Semantic Translation to solve the Aggregate step of an Opinion Aggregation architecture, which allows exploiting the measure values resulting from integrating heterogeneous information (including unstructured data such as free texts) by means of traditional Business Intelligence tools. We also present an entire Opinion Aggregation architecture that includes the Aggregate step and solves the rest of steps (Collect, Identify and Classify) by means an Extraction, Transformation and Loading process. This architecture has been implemented in an Oracle Relational Database Management System. We have applied it to integrate heterogeneous data extracted from certain high end hotels websites, and we show a case study using the collected data during several years in the websites of high end hotels located in Granada (Spain). With this integrated information, the Data Warehouse user can make several analyses with the benefit of an easy linguistic interpretability and a high precision by means of interactive tools such as the dashboards.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13
Fig. 14

Similar content being viewed by others

References

  • Abiteboul, S. (1997). Querying semi-structured data. In Proceedings of the international conference on database theory (pp. 1–18). Delphi: ICDT.

    Google Scholar 

  • Araque, F., Salguero, A., Carrasco, R. A., & Delgado, C. (2007). Fuzzy integration of Web data sources for data warehousing. Lecture Notes in Computer Science, 4739, 1208–1215.

    Article  Google Scholar 

  • Atrapalo (2011). Travel agency and promotion of recreational activities on the Internet. http://www.atrapalo.com.

  • Bonissone, P. P. (1982). A fuzzy sets based linguistic approach: Theory and applications. In M. M. Gupta & E. Sanchez (Eds.), Approximate reasoning in decision analysis (pp. 329–339). Amsterdam: North-Holland.

    Google Scholar 

  • Bonissone, P. P., & Decker, K. S. (1986). Selecting uncertainty calculi and granularity: An experiment in trading-off precision and complexity. In L. H. Kanal & J. F. Lemmer (Eds.), Uncertainty in artificial intelligence (pp. 217–247). Amsterdam: North-Holland.

    Google Scholar 

  • Booking (2011). Europe’s leading online hotel reservations agency by room nights sold. http://www.booking.com.

  • Bordogna, G., & Passi, G. (1993). A fuzzy linguistic approach generalizing boolean information retrieval: a model and its evaluation. Journal of the American Society for Information Science, 44(2), 70–82.

    Article  Google Scholar 

  • Bordogna, G., & Passi, G. (2001). An ordinal information retrieval model. International Journal of Uncertainty Fuzziness and Knowledge Based Systems, 9, 63–76.

    Article  Google Scholar 

  • Burdick, D., Deshpande, P. M., Jayram, T. S., Ramakrishnan, R., & Vaithyanathan, S. (2007). OLAP over uncertain and imprecise data. The VLDB Journal, 16(1), 123–144.

    Article  Google Scholar 

  • Carenini, G., Ng, R. T., Zwart, E. (2005). Extracting knowledge from evaluative text. In: Proceedings of the 3rd international conference on Knowledge (pp 11–18). New York, USA.

  • Carrasco, R. A., & Villar, P. (2011). A new model for linguistic summarization of heterogeneous data: an application to tourism web data sources. Soft Computing, 16(1), 135–151.

    Article  Google Scholar 

  • Carrasco, R. A., Galindo, J., & Vila, M. A. (2001). Using artificial neural network to define fuzzy comparators in FSQL with the criterion of some decision-maker. Lecture Notes in Computer Science, 2085, 587–594.

    Article  Google Scholar 

  • Chiou, H. K., Tzeng, G. H., & Cheng, D. C. (2005). Evaluating sustainable fishing development strategies using fuzzy MCDM approach. Omega, 33, 223–234.

    Article  Google Scholar 

  • Cohen, S. (2006). User-defined aggregate functions: bridging theory and practice. In Proceedings of SIGMOD Conference (pp 49–60). New York, USA.

  • Condé Nast Johansens (2011). Luxury hotels, spas & venues from Condé Nast Johansens. http://www.johansens.com.

  • Condé Nast Traveller (2011). The luxury travel website of Condé Nast Traveller Magazine. http://www.cntraveller.com.

  • Delgado, M., Verdegay, J. L., & Vila, M. A. (1992). Linguistic decision making models. International Journal of Intelligence Systems, 7, 479–492.

    Article  Google Scholar 

  • Delgado, M., Molina, C., Rodríguez, L., Sánchez, D., & Ma, V. (2007). F-Cube factory: a fuzzy OLAP system for supporting imprecision. International Journal of Uncertainty, Fuzziness and Knowledge-Based Systems, 15(1), 59–81.

    Article  Google Scholar 

  • Deng, W., & Pei, W. (2009). Fuzzy neural based importance-performance analysis for determining critical service attributes. Expert Systems with Applications, 36(2), 3774–3784.

    Article  Google Scholar 

  • Dixon, P. (2001). Basics of oracle text retrieval. IEEE Data Engineering Bulletin, 24(4), 11–14.

    Google Scholar 

  • Du, N., Ye, X., & Wang, J. (2012). A schema aware ETL workflow generator. Information Systems Frontiers. doi:10.1007/s10796-012-9352-2.

  • eDreams (2011). Offers the widest selection and the best prices on the market for flights, hotels and vacation packages. http://www.edreams.net.

  • Expedia (2011). Broadest selections of travel products. http://www.expedia.com.

  • Feng, L., & Dillon, T. S. (2003). Using fuzzy linguistic representations to provide explanatory semantics for data warehouses. IEEE Transactions on Knowledge and Data Engineering, 15(1), 86–102.

    Article  Google Scholar 

  • Galindo, J., Carrasco, R. A., Almagro, A. M. (2008). Fuzzy Quantifiers with and without arguments for databases: definition, implementation and application to fuzzy dependencies. In Proceedings 12th Int. Conf. Information Processing and Management of Uncertainty for Knowledge-Based Systems (pp 227–234). Málaga, Spain.

  • Herrera, F., Herrera-Viedma, E., & Verdegay, J. L. (1995). A sequential selection process in group decision making with linguistic assessment. Information Sciences, 85, 223–239.

    Article  Google Scholar 

  • Herrera-Viedma, E. (2001). An information retrieval system with ordinal linguistic weighted queries based on two weighting elements. International Journal of Uncertainty Fuzziness and Knowledge Based Systems, 9, 77–88.

    Article  Google Scholar 

  • Herrera-Viedma, E., López-Herrera, A. G., Luque, M., & Porcel, C. (2007). A fuzzy linguistic IRS model based on a 2-tuple fuzzy linguistic approach. International Journal of Uncertainty Fuzziness and Knowledge Based Systems, 15, 225–250.

    Article  Google Scholar 

  • Hu, M., Liu, B. (2004). Mining opinion features in customer reviews. In: Proceedings of Nineteenth National Conference on Artificial Intelligence (pp 755–760). San José, California, USA.

  • Inmon, W. H. (2005). Building the data warehouse (4th ed.). New York: Wiley.

    Google Scholar 

  • Kosala, R., Blockell, H. (2000). Web mining research: a survey. SIGKDD explorations: newsletter of the Special Interest Group (SIG) on knowledge discovery and data mining 2(1):1–15.

  • Ku, L. W., Liang, Y. T., Chen, H. H. (2006). Opinion extraction, summarization and tracking in news and blog corpora. In Proceedings of AAAI-2006 Spring Symposium on Computational Approaches to Analyzing Weblogs (pp 100–107). Menlo Park, California, USA.

  • Likert, R. (1931). A technique for the measurement of attitudes. Archives of Psychology. New York: Columbia University Press.

    Google Scholar 

  • Long, C., Zhang, J., Huang, M., Zhu, X., Li, M., Ma, B. (2009). Specialized review selection for feature rating estimation. In Proceedings of the IEEE/WIC/ACM International Conference on Web Intelligence (pp 214–221). Milan, Italy.

  • Miao, Q., Li, Q., & Dai, R. (2009). Amazing: a sentiment mining and retrieval system. Expert Systems with Applications, 36(3), 7192–7198.

    Article  Google Scholar 

  • Morinaga, S., Yamanishi, K., Tateishi, K., Fukushima, T. (2002). Mining product reputations on the web. In Proceedings of the Eighth ACM SIGKDD International Conference on Knowledge discovery and data mining (pp 341–349). New York, USA.

  • Nguyen, T. B., Min Tjoa, A., & Wagner, R. R. (2000). An object oriented multidimensional data model for OLAP. In Proceedings of the First International Conference on Web-Age Information Management, WAIM-00 (pp. 1–14). Shanghai: LNCS, Springer Verlag.

    Google Scholar 

  • Rittman, M. (2009). Oracle business intelligence suite developer’s guide. Osborne McGraw-Hill

  • Roussopoulos, N., Kotidis, Y., Roussopoulos, M. (1997). Cubetree: Organization of and bulk incremental updates on the data cube (pp 89–99). In ACM SIGMOD.

  • GEO Saison (2011). A multithematical magazine dedicated to tourism. http://www.geo.de.

  • Shea, C. (2008). Oracle text reference, 11 g Release 1 (11.1) Part Number B28304-03.

  • Tang, H., Tan, S., & Cheng, X. (2009). A survey on sentiment detection of reviews. Expert Systems with Applications, 36(7), 760–773.

    Article  Google Scholar 

  • TheSleepEvent (2011). The sleep event conference. http://www.thesleepevent.com.

  • TripAdvisor (2011). Branded sites alone make up the most popular and largest travel community in the world. http://www.tripadvisor.es.

  • Trivago (2011). A premiere international online service for travelers seeking advice regarding their travel destinations. http://www.trivago.com.

  • Tsytsarau, M., & Palpanas, T. (2010). Mining subjective data on the web. In Technical Report DISI-10-045, Ingegneria e Scienza dell’Informazione. Italy: University of Trento.

    Google Scholar 

  • Umano, M., & Fukami, S. (1994). Fuzzy relational algebra for possibility-distribution-fuzzy-relational model of fuzzy data. Journal of Intelligent Information Systems, 3, 7–28.

    Article  Google Scholar 

  • Wang, M. (2011). Integrating organizational, social, and individual perspectives in Web 2.0-based workplace e-learning. Information Systems Frontiers, 13(2), 191–205.

    Article  Google Scholar 

  • Wang, H., Zaniolo, C. (2000). User defined aggregates in object-relational. In Proceedings of the 16th International Conference on Data Engineering Systems (pp 135–144).

  • Wei, C., Khoury, R., & Fong, S. (2012). Web 2.0 Recommendation service by multi-collaborative filtering trust network algorithm. Information Systems Frontiers. doi:10.1007/s10796-012-9377-6.

  • Yager, R. R. (1995). An approach to ordinal decision making. International Journal of Approximate Reasoning, 12(3–4), 237–261.

    Article  Google Scholar 

  • Yager, R. R. (1996). Quantifier guided aggregation using OWA operators. International Journal of Intelligent System, 11(1), 49–73.

    Article  Google Scholar 

  • Yager, R. R. (1999). Decision making under uncertainty with ordinal information. International Journal of Uncertainty Fuzziness and Knowledge Based Systems, 7, 483–500.

    Article  Google Scholar 

  • Zadeh LA (1975) The concept of a linguistic variable and its applications to approximate reasoning. Pt I, Inf Sci 8:199–249. Pt II, Inf Sci 8:301–357. Pt III, Inf Sci 9:43–80.

  • Zhang, J., Akula, K., Karim, M., & Ariga, R. K. R. (2011). A university-oriented Web 2.0 services portal. Information Systems Frontiers, 13(2), 251–264.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Software Engineering, University of Granada, Granada, 18071, Spain

    Ramón A. Carrasco & Miguel J. Hornos

  2. Department of Marketing and Market Research, University of Granada, Granada, 18071, Spain

    Francisco Muñoz-Leiva

Authors
  1. Ramón A. Carrasco
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Francisco Muñoz-Leiva
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Miguel J. Hornos
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Ramón A. Carrasco.

Rights and permissions

Reprints and permissions

About this article

Cite this article

Carrasco, R.A., Muñoz-Leiva, F. & Hornos, M.J. A multidimensional data model using the fuzzy model based on the semantic translation. Inf Syst Front 15, 351–370 (2013). https://doi.org/10.1007/s10796-012-9398-1

Download citation

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s10796-012-9398-1

Keywords

Search

Navigation