IMS - Data Warehouse

IMS - information Warehouse In a large pecuniary services organization, you withdraw been asked by the Marketing Director to take a shit him a written report on the development of a date store. This will, he sees, abide a wide admixture of sales/marketing information. 1) In this report, give him the details as to why & angstrom; 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 spare- fourth dimension activity definition of a info warehouse: a subject-orientated, integrated, time variant and non-volatile hookup of data in leap out of the circumspection decision reservation process. Subject-orientated: a data warehouse is organised near subject-groups with in the enterprise e.g. customer, sales and so forth This reflects the need for strategic decision support, rather than operational support Integrated: data used within different applications is stack away to lodgeher. This data must be cleansed to blend consistent. This data purging required to populate the warehouse place be difficult, time 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 sectionalization also covers the length of time that the data is held for; that is between updates. Data Ware houses are not updated on a very obsess bas! is, often it is monthly or quarterly. Non-volatile: The data is not updated in real time. New data is ordinarily added to the database as an increment and not as a replacement. This way of technology has entirely become a possibility in the last quintette 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