Incorporating External Data into Data Warehouses – Problems Identified and Contextualized
نویسندگان
چکیده
Incorporating external data into data warehouses is a rather unexplored area and deserves more attention, especially if considering the resources organizations spend on acquiring data from specialized data suppliers. Therefore, this paper gives the results of an interview study partly aimed at evaluating, from a general perspective, the outline of such a process and related problems. The results show that trust and cost issues are utmost important characteristics to consider when acquiring external data. In addition, the results also show that the organizations incorporating external data need some type of hands-on support, for being able to fully exploit the potential thereof. Finally, the results also gave the outline of the external data incorporation process.
منابع مشابه
External Data Incorporation into Data Warehouses
Most organizations are exposed to increasing competition and must be able to orientthemselves in their environment. Therefore, they need comprehensive systems that areable to present a holistic view of the organization and its business. A data warehouse(DW) may support such tasks, due to its abilities to integrate and aggregate data fromorganizationally internal, as well as exte...
متن کاملAcquiring and Integrating External Data Into Data Warehouses: Are You Familiar With the Most Common Process?
Data warehouses (DWs) has become one of the major IT-investments during the last decades and in order to fully exploit the potential of data warehouses, more and more organizations are acquiring and integrating external data into their star-schemas. However, the literature covering external data acquisition and integration is limited. Therefore, in this paper the results of an interview study c...
متن کاملIncorporating ICD-9 and ICD-10 Data in a Warehouse
The shift from version 9 to version 10 of the ICD-code (“International Statistical Classification of Diseases and Related Health Problems”) causes enormous problems for the exploitation of medical data warehouses, since conventional data warehouses do not support the change of the structure of dimensions, i.e. the content and relationships of master data like the diagnostic codes, or other key ...
متن کاملIncorporating External Data into Data Warehouses: Characterizing and Categorizing Suppliers and Types of External Data
In order for organizations to survive and maintain their competitive edge, they must understand what is going on in their environment. One application, designed to contribute to such an understanding, is the data warehouse (DW). Traditionally, the focus of DW development projects has been on data internal to the organization, but as the competitive forces have become more important to understan...
متن کاملSyndicate Data Incorporation into Data Warehouses: Contrasting Consumer Problems with Supplier Viewpoints
The research reported in this paper extends current knowledge of problems related to syndicate data incorporation into data warehouses (DWs). It does so by employing an interview study towards syndicate data suppliers (SDSs). The result gives a contextualization of syndicate data incorporation problems, from a supplier perspective, by contrasting the problems experienced by user organizations. ...
متن کامل