The Integration of Web-Based Information and the Structured Data in Data Warehousing

摘要

The article presents the concept of the solution for feeding the data warehouse from website forums including opinions about selected products. The key of the solution is to add a new data warehouse dimension called Variable that allows identifying both structured and unstructured data. In suggested solution the results of websites analysis will be stored in the same repository as the data from traditional corporate systems, such as CRM or ERP. The concept was presented regarding Internet shops that offered a selected kind of products.