Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Parallelism And Oracle Data Warehousing
The widespread acceptance of parallel processing and multitasking operating systems has heralded a new mode of designing and implementing data warehouses. Instead of the traditional linear warehouse design where queries are single-threaded, today’s state-of-the-art Oracle warehouses incorporate massively parallel processors. Indeed, this new processing paradigm is not limited to data warehouses. The corporate information resource has been expanded in definition to include all sources of information, not just relational databases. Corporate information resides within e-mail, Lotus Notes, and many other non-traditional sources, and many companies are collecting information without fully exploiting its value. Oracle universal server, in conjunction with Oracle parallel server, provides an ideal technique for searching the huge amounts of free-form corporate information.

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.