Title :
Oracle parallel warehouse server
Author_Institution :
Oracle Corp., Redwood Shores, CA, USA
Abstract :
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
Keywords :
database machines; file servers; parallel architectures; query processing; very large databases; Oracle parallel database architecture; Oracle parallel warehouse server; complexity; data flow model; data shipping; function shipping; query plan; scalability; shared disk; shared everything; shared nothing hardware; Benchmark testing; Data warehouses; Engines; Hardware; Investments; Scalability; Scheduling; Spatial databases; Warehousing; Yarn;
Conference_Titel :
Data Engineering, 1997. Proceedings. 13th International Conference on
Conference_Location :
Birmingham
Print_ISBN :
0-8186-7807-0
DOI :
10.1109/ICDE.1997.581820
