View in EDS

Derivations of Initial Data Warehouse Structure by Mapping Operational Database on Transaction Patterns

Saved in:
Bibliographic Details
Title: Derivations of Initial Data Warehouse Structure by Mapping Operational Database on Transaction Patterns
Authors: AMINA KHALFE, SYED IRFAN HYDER
Source: Market Forces, Vol 2, Iss 2, Pp 104-114 (2006)
Publisher Information: Karachi Institute of Economics and Technology, 2006.
Publication Year: 2006
Collection: LCC:Commerce
Subject Terms: Transaction patterns, mapping, operational database, data warehouse, Commerce, HF1-6182
Description: Data warehouses improve the quality of integrated information in the organization for decision-making.The data for the data warehouse comes from online transaction systems. Typically, an involved process ofanalysis precedes the actual design phase of a data warehouse (1999). The analysis process becomes moredifficult because of the costs involved in hiring experienced staff and the privacy issues arising from theuse of external consultants (2000). Peter Coad’s transaction pattern (2000) is a higher-level description ofa generic business process (or a template) that has helped in the analysis and design of a wide range ofbusiness domains. The thesis of this paper is that the mapping of the operational databases on thetransaction pattern facilitates the derivation of initial data warehouse structure. During the mappingprocess, the relationships, roles and attributes of the players defined by the transaction pattern help us inidentifying the instances of the pattern in the database. Through these instances, we can then derive theinitial data warehouse structure i.e. the attributes of the fact and dimension table(s). The data warehousestructure thus derived reduces the need for an extensive information analysis of the needs ofthe user and the dependency on the experienced personnel for data warehousedevelopment. This paper proposes a three-step derivation methodology that is illustratedusing a case study of an organization’s operational database.
Document Type: article
File Description: electronic resource
Language: English
ISSN: 1816-8434
Relation: http://www.pafkiet.edu.pk/dnnbeta/LinkClick.aspx?fileticket=vB65Mo0DqXk%3d&tabid=153&mid=712; https://doaj.org/toc/1816-8434
Access URL: https://doaj.org/article/9fc20644d6834bbf8a1f7ffe66463b8c
Accession Number: edsdoj.9fc20644d6834bbf8a1f7ffe66463b8c
Database: Directory of Open Access Journals
Description
Abstract:Data warehouses improve the quality of integrated information in the organization for decision-making.The data for the data warehouse comes from online transaction systems. Typically, an involved process ofanalysis precedes the actual design phase of a data warehouse (1999). The analysis process becomes moredifficult because of the costs involved in hiring experienced staff and the privacy issues arising from theuse of external consultants (2000). Peter Coad’s transaction pattern (2000) is a higher-level description ofa generic business process (or a template) that has helped in the analysis and design of a wide range ofbusiness domains. The thesis of this paper is that the mapping of the operational databases on thetransaction pattern facilitates the derivation of initial data warehouse structure. During the mappingprocess, the relationships, roles and attributes of the players defined by the transaction pattern help us inidentifying the instances of the pattern in the database. Through these instances, we can then derive theinitial data warehouse structure i.e. the attributes of the fact and dimension table(s). The data warehousestructure thus derived reduces the need for an extensive information analysis of the needs ofthe user and the dependency on the experienced personnel for data warehousedevelopment. This paper proposes a three-step derivation methodology that is illustratedusing a case study of an organization’s operational database.
ISSN:18168434