This website uses cookies to ensure you have the best experience. Learn more

Data Warehousing Development Methodologies: A Comparative Analysis

3704 words - 15 pages

Data warehousing provides the large-scale infrastructure for decision support inmodern organizations. Data warehousing development methodologies have been developedby hardware & software vendors and consulting companies. There has been little academiccontribution to this work. This paper analyses four influential methodologies using the Avisonand Fitzgerald (1995) comparison framework. The analysis highlights a number of issues orareas where conceptual and empirical research may significantly improve developmentpractice.KEY WORDS: data warehousing, systems development, development methodologies, decisionsupport.1. IntroductionSystems development methodologies have been at the core of informationsystems practice since the 1960s. A systems development methodology is a"recommended collection of philosophies, phases, procedures, rules, techniques,tools, documentation, management and training for developers of informationsystems" (Maddison, 1983 cited in Avison & Fitzgerald, 1995, p 418). There arehundreds of methodologies available ranging from general methods like structuredsystems analysis & design method and rapid application development to proprietarymethods like Ernst & Young's Navigator. Fitzgerald (1997) argues that most currentmethodologies are based on concepts developed in the period 1967-1977. He alsoargues that changes in the organisational and technical environment since that periodhave been so great that these methodologies need fundamental review and believesthat professional practice is currently leading theory in the developmentmethodology area. This has usually been the case but the divergence is probablygreater now, in the age of the Internet, than at any other time.A data warehouse is a set of databases created to provide information to decisionmakers. Typically, the applications used to access a data warehouse provide agraphical interface that facilitates the creation of ad hoc reports. It is usual for thesedelivery systems to provide a multi-dimensional conceptual view of the data to theend users. Data warehouses contain both current and historical data and are typicallyvery large. Building and implementing a data warehouse is a complex process thatincludes acquiring information requirements from business executives and designingthe data warehouse; sourcing, transforming, cleansing and synchronizing data fromsource systems; developing delivery systems; and managing the evolutionaryprocess of building the data warehouse. Despite the importance of data warehousingto contemporary IT practice there has been little reported academic research on datawarehouse development methods.The aim of this paper is to contribute to data warehouse developmentmethodology theory. Following Fitzgerald's practice leads theory proposition, anumber of data warehousing methodologies that are the result of vendor orconsultant practice are analyzed using a methodology comparison framework(Avison & Fitzgerald, 1995). A set of data...

Find Another Essay On Data warehousing development methodologies: A comparative analysis

Juvenile and Adult Courts - A Comparative Analysis

1522 words - 6 pages rules and laws, the debates may eventually fade away.ReferencesKerbs, J. (n.d.) "Juvenile Court Abolition and the Collateral Consequences of Using Adult Courts and Prisons with Children" Paper presented at the annual meeting of the American Society of Criminology, Royal York, Toronto . 2009-10-26. Retrieved from (2006, May 11). Juvenile and Adult Courts: A Comparative Analysis. Associated

Part A: Data Collection, Presentation And Analysis

1576 words - 6 pages Part A: Data Collection, Presentation And Analysis Survey Results Many human features are controlled by a single pair of alleles, one dominant and one recessive, that are inherited in simple Mendelian fashion. To examine this further, a survey was done on two of basic human features. The two phenotypes chosen for the survey were hand clasping (left over right being dominant) and tongue rolling (where the ability to do so is dominant

System Elements-Data Roles in System Development - End Users Systems Development Life Cycle – Feasibility CMGT 555 / Systems Analysis and Development

1323 words - 5 pages Week 1 Paper GMGT 555- A BBB PAGE 1 System Elements-DataRoles in System Development - End UsersSystems Development Life Cycle - FeasibilityCMGT 555 / Systems Analysis and DevelopmentDarrell BroylesUniversity Of PhoenixDecember 2, 2006System Elements-DataThe design of a system varies in response to the expected audience for the perticulare application. Some systems are intended for back rooms, some for the front office, and some are for the

A Comparative Analysis of Political Communication in Turkey

1757 words - 7 pages A Comparative Analysis of Political Communication in Turkey Case In Turkey case of this paper, I will try to analyse Turkish media system with the theoretical framework which is developed by Daniel C. Hallin and Paolo Mancini in the article of Comparing Media Systems, Three Models of Media and Politics. I will make an attempt in order to investigate the basic characteristics of the media systems in Turkey, moreover I will bring the relationship

Why should not invest in Exxon – A comparative Analysis

1780 words - 8 pages Comparative analysis: Analysing the ratio of one with the other in the industry provides for better understanding about the performance of the company in market. An investor has to make a comparative analysis before making any investment decision. In this case, the direct competitor of Exxon is Chevron, ratios is being computed for the recent four quarters which is being used for comparative analysis. Current ratio: This is an essential ratio

Analysis and Research for a data warehouse system

992 words - 4 pages Analysis and Research for a data warehouse system Data warehousing is a difficult system and has to have the capability deliver quality data. An operational database is one which is used by organizations to run its day to day database activities. They are designed to handle rapid transaction processes with systematically updates. Velocity is important to operational databases. They are most commonly operated by office staff, and are on

Exploratory Data Analysis from World's Bank's World Development Indicators of 2003: Analysis of Variable series FERAT80 and FERAT01

2007 words - 8 pages From the Systat data file for WDI2003 data related to several variables concerning global development and related fields have been complied and give code names. The code FERAT is a representation of the ratio of women age 65 and above per 100 men in the same age group. FERAT80 and FERAT01 are the same variable but represent data collected in two different years. FERAT80 is data corresponding to statistics collected worldwide in the year 1980

This essay is a recapitulation and meta-analysis of two essays appertaining to pedagogical ideologies and the methodologies that are concomitant to them

1583 words - 6 pages equanimity are defenestrated (if they are lucky) or, at worst, their salubrious visages turn sallow as the misanthropic malefactors divest them of their corporeal existence, leaving a concatenation of sanguinary bodies, myriad dreams and expectations stanched, as the oppressors continue on the road to genocide. While the development of most power structures (and the societal bifurcation of equality and inequality and the internecine struggles that are

A Comparative Analysis into Oral and Topically Applying Vitamin A in the Topic of Photo Ageing

2077 words - 9 pages Contents. Front Cover…………………………………………………………………………...Page 1. Introduction………………………………………………………………...…………Page 2. Research Proposal…………………………………………………………………..Page 3. Literature Review………………………………………………………………….…Page 7. Methodology Discussion of Findings Conclusion Bibliography   Introduction. The purpose of this study is to research topically applied and orally taken vitamin A for the treatment of photo ageing. From this data it will

A Comparative Analysis of the Social Media Marketing Approaches of Ryanair and easyJet

7890 words - 32 pages 0 Heidi Mariegaard Poulsen & Alice Høst Fowler Business and Social Sciences, Aarhus University International Virksomhedskommunikation Leila Trapp 3 May 2012 99,003 characters (without spaces) A Comparative Analysis of the Social Media Marketing Approaches of Ryanair and easyJet Abstract Title: A comparative analysis of the social media marketing approaches of Ryanair and easyJet. Year: 2012 Authors: Heidi Mariegaard Poulsen, Alice H

Hardy, Bronte and the Loss “A Comparative Analysis of Bronte and Hardy”

936 words - 4 pages Hardy, Bronte and the Loss “A Comparative Analysis of Bronte and Hardy” Death, it scares even the greatest heroes on the face of the Earth, nobody knows what will happen after the blackness has taken over your sight and you lay down for your final rest. It has been a purpose of thousands of writers all across the globe for centuries, three of which being: “Remembrance” by Emily Bronte, “The Darkling Thrush”, and “Ah, Are You Digging on My

Similar Essays

Project Analysis Approach And Project Development Life Cycle Methodologies Process

2238 words - 9 pages company. (Hill/Jones, Page 10)The mission or vision is a formal declaration of what the company is trying to achieve over the medium to long term. Its purpose is to provide a platform for thinking strategically. Hill/Jones, Page 10)Analysis of the Organizational External Competitive environment to identify opportunities or threatsIt's the second component of the strategic management process of the organization's external operating environment. The

Using Information Systems Development Methodologies And Knowledge Management Ideas To Create A University E Learning Infrastructure

5384 words - 22 pages points of concern that could be rectified by the introduction of an effective e-learning and communication infrastructure. See Appendix * for a summary of the key points from the analysis of returned questionnaires.1.6 ANALYSIS OF CURRENT SITUATIONThe following table analyses the relevant strengths and weaknesses of the current situation and draws on the results from the questionnaire which can be seen in Appendix *.Divisional StrengthsReasonEasy

A Proposal For Signal Integrity Analysis And Design Methodologies Of Deep Sub Micron Cmos Vlsi Circuits

2099 words - 9 pages complexity and smaller feature size (deep submicron) [9] and international roadmap of semiconductors (ITRS) predicting the gap between exponential increases in the number of transistors and meaningfully designing them [10], there is much need in modelling and analyzing some of the issues that are critical to the technology. Device Modelling was a subject of interest for more than a decade and many researchers have gone to new designs and methodologies

A Comparative Analysis Of Harlem Renaissance Poetry

760 words - 4 pages Aint Nobody Got Time for a Creative Title (A Comparative Analysis of Harlem Renaissance Poetry) The great philosopher Plato once orated: “Every heart sings a song, incomplete, until another heart whispers back. PBS defines the the Harlem Renaissance a “Cultural, social, and artistic explosion that took place in Harlem between the end of World War I and the middle of the 1930s. During this period Harlem was a cultural center, drawing black