Show simple item record

dc.contributor.authorMoyle, Sam Aen_NZ
dc.date.available2011-04-07T03:09:47Z
dc.date.copyright2000-11en_NZ
dc.identifier.citationMoyle, S. A. (2000, November). Data warehouses and data marts: Can these tools be implemented too early in the development of a company? (Dissertation, Bachelor of Commerce with Honours). Retrieved from http://hdl.handle.net/10523/1160en
dc.identifier.urihttp://hdl.handle.net/10523/1160
dc.description.abstractThis document will discuss the small business and its particular needs when considering data warehouses or data marts in conjunction with business intelligence tools. We will discuss some of the history of the data warehouse genre, and how it relates to the small business. Issues of data model architecture and development strategies are also discussed with the purpose of discovering techniques that help the developer maximise return from their time investment. Proposed or expected benefits should be ascertained before the data warehouse is built. This provides management with information upon which to base decisions, particularly important where resources are tight. Especially important is time till cost recovery, which allows financial benefit to be calculated. The process (or methodology) by which data warehouses are developed is discussed. Current practice is shown, and it is noted that there are no real ‘hard and fast’ rules that govern this process. Industry-accepted ‘Do’s and Don’ts’ are listed for discussion. There are two questions being asked by this document. The first, “Can these tools be implemented too early in the development of a company”, is answered by implementing a pre-packaged data warehouse, with associated business intelligence tools, as a pilot project for a small company. From this implementation conclusions will be drawn about whether the company is mature enough to warrant such a tool. The second question asked is “Can we generate heuristics that will enable small business to assess the value of a data warehouse, before implementation?” Through this implementation it will be established that heuristic rules may be derived to guide small-business people in their pre-implementation decision making. However, a number of implementations will need to be completed before similarities can be accurately identified and rules derived.en_NZ
dc.format.mimetypeapplication/pdf
dc.subject.lcshT Technology (General)en_NZ
dc.subject.lcshQA76 Computer softwareen_NZ
dc.titleData warehouses and data marts: Can these tools be implemented too early in the development of a company?en_NZ
dc.typeDissertationen_NZ
dc.description.versionUnpublisheden_NZ
otago.bitstream.pages61en_NZ
otago.date.accession2006-01-20en_NZ
otago.schoolInformation Scienceen_NZ
thesis.degree.disciplineInformation Scienceen_NZ
thesis.degree.nameBachelor of Commerce with Honours
thesis.degree.grantorUniversity of Otagoen_NZ
thesis.degree.levelHonours Dissertationsen_NZ
otago.openaccessOpen
dc.identifier.eprints194en_NZ
otago.school.eprintsInformation Scienceen_NZ
dc.description.referencesNote: All internet links were valid as at 5 October 2000. Some sites may require user verification before allowing access to the material. Altana Inc., “STRATEGY helps pharmaceutical company boost sales with AS/400 data warehouse”, http ://www.showcasecorp.com/library/dwcase/atlana.html 2000. BRIO Technology Inc., “Critical Success Factors for Enterprise Business Intelligence Solutions from Brio Technology”, 1997. [http://www.brio.com/library/white papers/wp_critical.html] Butler M, “How Valid is Data Warehousing”, 1998. [http://www.butlergroup.com/subs/journals/contra/feb984.htm ] Codd E F, “Derivability, Redundancy, and Consistency of Relations Stored in Large Data Banks.” IBM Research Report RJ599. August 19th, 1969. COGNOS, “ Bringing IT to the Forefront at Foster Parents Plan of Canada”. http://www.intelligententerprise.com/realware/cognos.shtml 2000a. COGNOS, “Cognos BISE”, http ://www.cognos.com/products/bise/index.html, 2000b. Connelly R, McNeill R, and Mosimann R, “The Multidimensional Manager”, © Cognos Corporation 1997. Data Warehouse Institute, The (TDWI), “Ten Mistakes To Avoid “, The Data Warehouse Institute, 2000. http://www.dw-institute.coin/papers/10mistks.htm Date C J, “The Birth of the Relational Model” series of articles, Intelligent Enterprise, beginning Volume 1, Issue 1, October 1998. Devlin B A, and Murphy P T, “An architecture for a business and information system”. IBM Systems Journal. Volume 27, No. 1, 1988. Greenfield L, “Actions for Data Warehouse Success”, LGI Systems, 1995. [http ://www.dwinfocenter.org/success.html ]. Copyright © 1995 - 2000 LGI Systems Incorporated Informix, “Warehouse Provides an Ounce of Prevention for Tufts Health Plan”. http://www.intelligententerprise.com/realware/informix_1.shtml 2000. Inmon W H, “Building the Data Warehouse”, Wiley-QED, 1992.QA76.9.D315372 1992 Inmon W H, “Data Model - Manufacturing “. (http://www.bIllinmon.com/library/models/models_frame.asp] 1999. Inmon W H, “Definition of a Data Warehouse”. [http://www.billinmon.com/library/] 1999b. Inmon W H, “Does Your Data Mart Vendor Care About Your Architecture?”. [http ://www.billinmon.com/library/] 1999c. Jones G, “Building Effective Data Marts”, Oracle Magazine, Volume XII/Number 3, 1998, pages 89-97. Kelly T J, “Dimensional Data Modeling”, Sybase Professional Services. [http://www.gatel.com/solutions/whitepapers/sybase/syb_dim_data_mod.html] March 2000. Keen, J M, “Turn “Soft” Benefits into Hard Savings”, Datamation, September 1997. Keen, J M, “Benefits-capture programs help measure ROI”, Datamation, March 2000. Kimball R, “Is ER Modeling Hazardous to DSS? Don’t assume that an ER model is suitable for building a decision-support database.” DBMS and Internet Systems, © 1995 Miller Freeman, Inc, Volume 8 Issue 11, October 1995. http://www.dbmsmag.com/9510d05.htm1 Kimball R, “ Brave New Requirements for Data Warehousing.” Intelligent Enterprise Magazine, © 1998 CMP Media, Volume 1 Issue 1, October 1998. [Also found at http://www.intelligententerprise.com/db_area/archives/1998/9810/warehouse.shtml] Kimball R, “Millennium Ahead”, Intelligent Enterprise Magazine, © 2000 CMP Media Inc. January 1, 2000, Volume 3 - Number 1, [http://www.intelligententerprise.com/000101/webhouse.shtml ] McKnight W, “Data Warehouse Justification and ROI”, DM Review, November 1999 [http://www.dmreview.com/master.cfm?NavlD=198&EdID=1565] Mimno P R, “Build Your Data Warehouse Right The First Time”, © Brio Technology, Inc. 1999. [http://www.brio.com/library/white_papers/wp_build.html] NCR, “Warehousing for Life at Anthem Blue Cross Blue Shield”. http://www.intelligententerprise.com/realware/ncr.shtml 2000. Peterson S, “Stars: A Pattern Language for Query Optimized Schema”, Sequent Computer Systems, Inc. [http://c2.com/ppr/stars.html] 1994 RealWare Awards, Intelligent Enterprise Magazine, © 2000, CMP Media, Volume 3 Issue 1, January 2000. Also found at http://www.intelligententerprise.com/realware/ Lawrence S, Personal communication, 15 August 2000. CDP, Wellington. Small Business Administration (SBA), “Small Business Size Regulations; Size Standards and the North American Industry Classification System”, Federal Register / Vol. 65, No. 94 / Monday, May 15, 2000a. Small Business Administration (SBA), “Learn about SBA”. http://www.sbaonline.sba.gov/aboutsba/, 2000b. Standish Group, “The Meta Myth”, The Standish Group, 1997. http://standishgroup.com/visitor/db.htm Sterling, “Data Warehousing Creates One Company, One Voice at 3M”, http://www.intelligententerprise.com/realware/sterling.shtml 2000. Survey, “Data Warehousing Survey”. http://www.terry.uga.edu/mis/datawarehousing/dataware.htm, 2000. White C, DMReview Magazine, March 2000, http://www.dmreview.com/editorial/dmreview/print_action.cfm?EdID=1953en_NZ
 Find in your library

Files in this item

Thumbnail

This item appears in the following Collection(s)

Show simple item record