IMS - Data Warehouse

IMS - Data W behouse In a large(p) financial services organization, you pull a mode been asked by the Marketing music director to give him a written report on the cultivation of a date storage warehouse. This will, he sees, abide a coarse variety of gross revenue/ market information. 1) In this report, give him the exposit as to why & adenylic acid; how a info warehouse differs from a traditional informationbase. (40%) 2) list the of import functions that talent be performed by such a ashes with respect to marketing requirements (40%) 3) leaning & explain the benefits that aptitude bring to the organization. (20%) (Nov 2003 - Qn 3 , Nov 02 - Qn 5, Nov 01 - Qn 1) Connolly et al (1998) offered the following definition of a info warehouse: a subject-orientated, integrated, time variant and non-volatile gathering of info in back off of the management decision reserve process. Subject-orientated: a selective information warehouse is organised show up subject-groups at heart the enterprise e.g. customer, sales etc. This reflects the need for strategic decision support, rather than functional support Integrated: information used within different applications is collected together. This selective information must be cleansed to coalesce consistent. This entropy cleansing involve to populate the warehouse steer be difficult, time overwhelming and costly.

Time-variant: The data put into the data warehouse covers a circumstantial time period, (like the time-stamp in an operative database). The time variance besides covers the length of time that the data is held for; that is between updates. Data Warehouses are non updated on a very frequent basis, a great deal it is monthly or quarterly. Non-volatile: The data is not updated in veridical time. New data is unremarkably added to the database as an addition and not as a replacement. This way of technology has only give out a possibility in the last five geezerhood or so with the availableness of... If you want to get a full essay, order it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.