Information retrieval (IR) is the activity of obtaining information resources relevant to an information need from a collection of information resources. This activity plays an important role in data integration and data mining.
a. What do you understand about the relationship between information retrieval, data warehouse and data mining. How these concepts are inter-related in providing better decision making.
b. ETL process involves data matching, data mapping and data integration. Explain each of these processes and how they interact with each other in loading the data in the warehouse.
c. You are the data analyst on the project team building a data warehouse for a large national grocery chain company.
i. List the possible data sources from which you will bring the data into your data warehouse. State your assumptions.
ii. Prepare a table showing all the potential users and information delivery methods for a data warehouse supporting a large national grocery chain.
iii. Based on the questions (i) and (ii) above, construct data warehouse architecture for this company.