Storing and analysing voice of the market data in the corporate data warehouse

García-Moya, Lisette; Kudama, Shahad; Aramburu, María; Berlanga, Rafael
July 2013
Information Systems Frontiers;Jul2013, Vol. 15 Issue 3, p331
Academic Journal
Web opinion feeds have become one of the most popular information sources users consult before buying products or contracting services. Negative opinions about a product can have a high impact in its sales figures. As a consequence, companies are more and more concerned about how to integrate opinion data in their business intelligence models so that they can predict sales figures or define new strategic goals. After analysing the requirements of this new application, this paper proposes a multidimensional data model to integrate sentiment data extracted from opinion posts in a traditional corporate data warehouse. Then, a new sentiment data extraction method that applies semantic annotation as a means to facilitate the integration of both types of data is presented. In this method, Wikipedia is used as the main knowledge resource, together with some well-known lexicons of opinion words and other corporate data and metadata stores describing the company products like, for example, technical specifications and user manuals. The resulting information system allows users to perform new analysis tasks by using the traditional OLAP-based data warehouse operators. We have developed a case study over a set of real opinions about digital devices which are offered by a wholesale dealer. Over this case study, the quality of the extracted sentiment data is evaluated, and some query examples that illustrate the potential uses of the integrated model are provided.


Related Articles

  • Financial System Analysis and Research of OLAP and Data Warehouse Technology. Min Guo // Information Technology Journal;2014, Vol. 13 Issue 3, p522 

    With the continuous development and progress of scientific technology, the computerization of financial are getting more sophisticated while the financial gradually moving to the changes of the financial analysis and management functions. In this transformation, the information system with...

  • Is Better Search the Answer?  // Information Today;Jul/Aug2004, Vol. 21 Issue 7, pS25 

    The article elaborates the function of text analytics as a bridge to linking previously disconnected structured and unstructured data. The evolution of text analytics mirrors that of structured data processing paradigms, where basic access via SQL queries matured into OLAP-based analytics. In...

  • Proposed Algorithm of Sentiment Analysis for Punjabi Text. Kaur, Amandeep; Gupta, Vishal // Journal of Emerging Technologies in Web Intelligence;May2014, Vol. 6 Issue 2, p180 

    Sentiment Analysis is to identify and classify the opinions/emotions/sentiments in written text. Till date, English Language includes most of the research work in this area. In this paper, we discussed the various approaches used to accomplish the sentiment analysis and research work done for...

  • An Approach for Sentiment Tendency Analysis on Comment Text. Min LI; Mengdong CHEN; Xiangbin LI // Advanced Materials Research;7/24/2014, Vol. 989-994, p1913 

    With the rapid development of network, texts which contain position, views and opinions of events are exploding. Texts of review contain author's feelings, views and tendencies the author wants to express. People need to analyze these texts automatically to acquire sentiment tendency of the...

  • The inelastic neutron scattering spectrum of chromous acid at high energy transfers. Tomkinson, J.; Taylor, A. D.; Howard, J.; Eckert, J.; Goldstone, J. A. // Journal of Chemical Physics;2/1/1985, Vol. 82 Issue 3, p1112 

    The inelastic incoherent neutron scattering spectrum of chromous acid, at 77 K, is presented. It is dominated by the intense bending mode at 1254 cm-1 with some modes at lower frequencies showing indications of dispersion. The antisymmetric stretch νas(OHS) {|1>-|2>} was assigned to a broad...

  • EXTENSIBLE MARKUP LANGUAGE (XML) SCHEMAS FOR DATA VAULT MODELS. KNOWLES, CURTIS; JOVANOVIC, VLADAN // Journal of Computer Information Systems;Summer2013, Vol. 53 Issue 4, p12 

    With the conceptualization of next generation architecture for Data Warehousing, that is the DW 2.0, there is now an increased emphasis on using fully-temporalized databases, in particular with approaches such as the Data Vault. In this paper we present a template XML Schema for Data Vault model...

  • D-PIPE: A Worker Hour Rates Data Warehouse for Estimating Industrial Pipe Work Construction. Al-Hussein, Mohamed; Vanderstar, Aubrey; Kandanala, Rajesh // Cost Engineering;Jun2005, Vol. 47 Issue 6, p24 

    Estimating pipe work, shop fabrication, and fieldwork is a time-consuming process that involves extensive data manipulation. Several systems have been developed to assist estimators in preparing their estimates for industrial construction work and planning their operations. These systems lack...

  • Discover the Star Schema. Poolet, Michelle A. // SQL Server Magazine;Jul2007, Vol. 9 Issue 7, p29 

    The article discusses the several key elements of star schema design for a data warehouse. It cites various reasons for using star schema rather than a conventional normalized design. In addition, it states that if star schema is implemented as online analytical processing (OLAP) cube, both...

  • Coalescing Data Marts. Parimala, N.; Pahwa, P. // Enformatika;2006, Vol. 16, p285 

    OLAP uses multidimensional structures, to provide access to data for analysis. Traditionally, OLAP operations are more focused on retrieving data from a single data mart. An exception is the drill across operator. This, however, is restricted to retrieving facts on common dimensions of the...


Read the Article


Sorry, but this item is not currently available from your library.

Try another library?
Sign out of this library

Other Topics