Information Systems Frontiers

, Volume 15, Issue 3, pp 351–370 | Cite as

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

  • Ramón A. CarrascoEmail author
  • Francisco Muñoz-Leiva
  • Miguel J. Hornos


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.


Multidimensional data model Fuzzy linguistic modelling Linguistic multidimensional data model Opinion aggregation 


  1. Abiteboul, S. (1997). Querying semi-structured data. In Proceedings of the international conference on database theory (pp. 1–18). Delphi: ICDT.Google Scholar
  2. 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.CrossRefGoogle Scholar
  3. Atrapalo (2011). Travel agency and promotion of recreational activities on the Internet.
  4. 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
  5. 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
  6. Booking (2011). Europe’s leading online hotel reservations agency by room nights sold.
  7. 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.CrossRefGoogle Scholar
  8. Bordogna, G., & Passi, G. (2001). An ordinal information retrieval model. International Journal of Uncertainty Fuzziness and Knowledge Based Systems, 9, 63–76.CrossRefGoogle Scholar
  9. 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.CrossRefGoogle Scholar
  10. 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.Google Scholar
  11. 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.CrossRefGoogle Scholar
  12. 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.CrossRefGoogle Scholar
  13. Chiou, H. K., Tzeng, G. H., & Cheng, D. C. (2005). Evaluating sustainable fishing development strategies using fuzzy MCDM approach. Omega, 33, 223–234.CrossRefGoogle Scholar
  14. Cohen, S. (2006). User-defined aggregate functions: bridging theory and practice. In Proceedings of SIGMOD Conference (pp 49–60). New York, USA.Google Scholar
  15. Condé Nast Johansens (2011). Luxury hotels, spas & venues from Condé Nast Johansens.
  16. Condé Nast Traveller (2011). The luxury travel website of Condé Nast Traveller Magazine.
  17. Delgado, M., Verdegay, J. L., & Vila, M. A. (1992). Linguistic decision making models. International Journal of Intelligence Systems, 7, 479–492.CrossRefGoogle Scholar
  18. 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.CrossRefGoogle Scholar
  19. Deng, W., & Pei, W. (2009). Fuzzy neural based importance-performance analysis for determining critical service attributes. Expert Systems with Applications, 36(2), 3774–3784.CrossRefGoogle Scholar
  20. Dixon, P. (2001). Basics of oracle text retrieval. IEEE Data Engineering Bulletin, 24(4), 11–14.Google Scholar
  21. Du, N., Ye, X., & Wang, J. (2012). A schema aware ETL workflow generator. Information Systems Frontiers. doi: 10.1007/s10796-012-9352-2.
  22. eDreams (2011). Offers the widest selection and the best prices on the market for flights, hotels and vacation packages.
  23. Expedia (2011). Broadest selections of travel products.
  24. 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.CrossRefGoogle Scholar
  25. 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.Google Scholar
  26. 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.CrossRefGoogle Scholar
  27. 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.CrossRefGoogle Scholar
  28. 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.CrossRefGoogle Scholar
  29. 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.Google Scholar
  30. Inmon, W. H. (2005). Building the data warehouse (4th ed.). New York: Wiley.Google Scholar
  31. 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.Google Scholar
  32. 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.Google Scholar
  33. Likert, R. (1931). A technique for the measurement of attitudes. Archives of Psychology. New York: Columbia University Press.Google Scholar
  34. 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.Google Scholar
  35. Miao, Q., Li, Q., & Dai, R. (2009). Amazing: a sentiment mining and retrieval system. Expert Systems with Applications, 36(3), 7192–7198.CrossRefGoogle Scholar
  36. 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.Google Scholar
  37. 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
  38. Rittman, M. (2009). Oracle business intelligence suite developer’s guide. Osborne McGraw-HillGoogle Scholar
  39. Roussopoulos, N., Kotidis, Y., Roussopoulos, M. (1997). Cubetree: Organization of and bulk incremental updates on the data cube (pp 89–99). In ACM SIGMOD.Google Scholar
  40. GEO Saison (2011). A multithematical magazine dedicated to tourism.
  41. Shea, C. (2008). Oracle text reference, 11 g Release 1 (11.1) Part Number B28304-03.Google Scholar
  42. Tang, H., Tan, S., & Cheng, X. (2009). A survey on sentiment detection of reviews. Expert Systems with Applications, 36(7), 760–773.CrossRefGoogle Scholar
  43. TheSleepEvent (2011). The sleep event conference.
  44. TripAdvisor (2011). Branded sites alone make up the most popular and largest travel community in the world.
  45. Trivago (2011). A premiere international online service for travelers seeking advice regarding their travel destinations.
  46. 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
  47. 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.CrossRefGoogle Scholar
  48. Wang, M. (2011). Integrating organizational, social, and individual perspectives in Web 2.0-based workplace e-learning. Information Systems Frontiers, 13(2), 191–205.CrossRefGoogle Scholar
  49. 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).Google Scholar
  50. 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.
  51. Yager, R. R. (1995). An approach to ordinal decision making. International Journal of Approximate Reasoning, 12(3–4), 237–261.CrossRefGoogle Scholar
  52. Yager, R. R. (1996). Quantifier guided aggregation using OWA operators. International Journal of Intelligent System, 11(1), 49–73.CrossRefGoogle Scholar
  53. Yager, R. R. (1999). Decision making under uncertainty with ordinal information. International Journal of Uncertainty Fuzziness and Knowledge Based Systems, 7, 483–500.CrossRefGoogle Scholar
  54. 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.Google Scholar
  55. 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.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media New York 2013

Authors and Affiliations

  • Ramón A. Carrasco
    • 1
    Email author
  • Francisco Muñoz-Leiva
    • 2
  • Miguel J. Hornos
    • 1
  1. 1.Department of Software EngineeringUniversity of GranadaGranadaSpain
  2. 2.Department of Marketing and Market ResearchUniversity of GranadaGranadaSpain

Personalised recommendations