What is the best data warehouse solution? That's a question that is often asked by many people who are planning to build their own data warehouse. It is also one of the most misunderstood questions in the entire data warehouse management industry. The simple reason for this is that there are so many things that have to be considered when answering this question. The problem is made worse because there are even more issues that arise when one tries to actually define what the best solution is.
First of all, one should never answer the question: What are the best Data Warehouse Solutions? Instead, one should state: What is the most appropriate data warehouse architecture? This can be quite different from one company to another and even from one application to another. There is no one single definition of what makes a data warehouse an appropriate solution for a particular application.
The other thing to consider is that the actual definition of what is the best data warehouse solution will be different depending on whether it is for a small data warehouse or a large data warehouse. This is because the sizes of the data warehouses will vary greatly. For instance, while it may not be true that all companies need a data warehouse of ten million rows, it certainly makes more sense that a data warehouse of that size would have a higher throughput than that of a data warehouse that is only two million rows. Thus, these differences lead to significant variation among data warehouse solutions.