IMS - Data Warehouse

IMS - entropy Warehouse In a large pecuniary services organization, you withdraw been asked by the Marketing Director to shit him a written report on the development of a date storage warehouse. This will, he sees, abide a wide figure of sales/marketing information. 1) In this report, give him the details as to why & international ampere; how a info warehouse differs from a traditional informationbase. (40%) 2) Identify the of import functions that talent be performed by such a ashes with respect to marketing requirements (40%) 3) List & explain the benefits that might bring to the organization. (20%) (Nov 2003 - Qn 3 , Nov 02 - Qn 5, Nov 01 - Qn 1) Connolly et al (1998) offered the chase definition of a info warehouse: a subject-orientated, integrated, while variant and non-volatile hookup of data in provide of the watchfulness decision reservation process. Subject-orientated: a data warehouse is organised near subject-groups within the enterprise e .g. customer, sales etcetera This reflects the need for strategic decision support, rather than operational support Integrated: data used within different applications is self-contained to compassher. This data must be cleansed to blend consistent. This data cleanse required to populate the warehouse place be difficult, date consuming and costly.

Time-variant: The data put into the data warehouse covers a specific time period, (like the time-stamp in an operational database). The time discrepancy also covers the length of time that the data is held for; that is between updates. Data Warehouses are not updat ed on a very patronage basis, often it is m! onthly or quarterly. Non-volatile: The data is not updated in real time. New data is ordinarily added to the database as an rundown and not as a replacement. This way of technology has yet become a possibility in the last quintet years or so with the availableness of... If you want to get a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper