Oracle parallel warehouse server
Gary Hallmark · 2002
Oracle is the leading supplier of data warehouse servers, yet little has been published about Oracle's parallel warehouse architecture. After a brief review of Oracle's market, performance, and platform strengths, we present two novel features of the Oracle parallel database architecture. First, the data flow model achieves scalability while using a fixed number of threads that is independent of the complexity of the query plan. Second, a new "load shipping" architecture combines the best aspects of data shipping and function shipping, and runs on shared everything, shared disk, and shared nothing hardware.