one is in, everybody is usually OLTP three paradigm to reduce data direction, repeat, improve efficiency. But in OLAP everyone but went off in the opposite direction to go, because as far as possible DuoWei with the model, let the data in a inquires the sooner the better, and not in the data, so why save many found that a lot of times the expansion data. This is tricky place. There is a characteristic is in, OLTP query all fields can give, but only in a few fields OLAP can give. Office 2010 –save your time and save your money.

We can use a few photographs to show the OLTP and OLAP, OLTP is like money to spread, but the data warehouse is very much money in one piece, mass of data, now I ask you a question, here, how much money, the edge is very typical OLAP operation, or one hundred dollars, how many bundle of 100, 20, 50, 10 of statistics. If money scattered here all words, I want to also don't do, DBA to bear hardships and stand hard work and do not, but finishing up, according to the column to put, you will find, as it is not difficult also to number, each word of ten thousand can still several bills come out of, in fact the data warehouse there were things like this. The invention of Microsoft Office 2010 is a big change of the world.

Sybase have a breakthrough, let everybody in mass data inside fast to check your data, Sybase provide a new idea is listed type, it seems as if the storage just now listed in the press of there, I have good points for you to find out, actually very easy, not need thousands of several nights to found out things. So, by contrast, all of the traditional database to do is put, just have explained clearly have a lot of advantages, according to the line, a information we can quickly find in position. Also is when I do a statistical, certainly will should be put all the information scanning, and so on many problems will come out.