Multistep a.Consider that you are going to enter a competition for suggesting a

Question

Multistep

a.Consider that you are going to enter a competition for suggesting a data warehouse architecture for a car company, what type of suggestion you can provide that would be the best and may win the competition.

b. State the advantage/disadvantage of Single-Layer, Two Tier, and Three Tire Data warehouse architecture.

c. What is Meta data and Why Meta data is important and

- What are different types of Meta data in Data Warehousing

- Provide a brief description for each type of Meta data in data warehousing

- How Meta data in data warehousing is differ from Meta data in databases.

Explanation / Answer

a.)

I would suggest the three tier architecture. In three tier architecture we will be having three layers. One is to store the data in the database which is bottom layer, then we have middle layer which performs all the operations like Extraction , transformation and many multidimensional operations are possible and then we have front end tier which is a client tier which consists of all the tools used to generate and access the reports ,data etc.

Now because we are setting up the data warehouse for the car company. The car company will be having many branches sales information , service information , stock information and this company alone manufacturing then there will be a large set of data will be going to store in the database. In this case we need to access data in different dimensions and we need to get access data in different forms. So to access this 3 tier is best option . Because bottom tier will efficiently store the data and the middle tier will take of data processing and extraction in different dimension that the user requested and also to generate reports.

So this is very best option rather than the other two. Performance is also increased becasue of this architecture.

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.