仓库与集市的异同（Similarities and differences between warehouses and markets）.doc

仓库与集市的异同（Similarities and differences between warehouses and markets） BI has always existed data warehouse construction and the construction of data mart, a top-down or bottom-up debate, but in actual construction, not be completely in accordance with some ideas to do, for example in data mart construction of telecom company, the game between the special situation of the citys headquarters and standard has become a major problem. Top-down VS bottom-up When I first entered the BI field, I felt like I was talking about data warehouse everywhere. Now, many places are beginning to say data mart. However, it is always a problem to make a clear distinction between data warehouse and data mart. From the word meaning, warehouse can be thought of as a big house, high shelf, reasonable access routes, is a centralized storage of goods, the average customer is not to visit; and when it comes to the market, it is easy to think of the empty space, the size of businesses put The stream never stops flowing.. I sell clothes to sell, and Clay oven rolls of performers, is to allow customers to consume the place. Specifically, the data warehouse is only providing storage, providing a data management oriented service, not for the final analysis of users; and data marts are analysis oriented applications, oriented to end users. Such understanding is relatively simple, but use this analogy to define the difference between data warehouse and data mart is too shallow. For example, data warehouses can also be accessed directly, and data marts provide storage, and such differentiation seems to indicate that data warehouses and markets must exist for end-users. The fact is not the case. So, it seems, the difference between them seems to lie in the size of the difference. But this is also a problem, such as how much, how small is small? That would be relative, for example, Telecoms data marts are probably thousands of times larger than a toy factorys data warehouse. In fact, from a different po