What makes SAP NetWeaver BI Accelerator so fast?
Traditional approaches to the optimization of query response times require some form of pre-aggregation. SAP NetWeaver BI Accelerator performs aggregation quickly during query execution because it processes the entire query in memory with no disk reads. The BI Accelerator owes its speed to a series of breakthrough innovations; for some, patents are pending. Query processing is performed entirely in memory, using extremely compact index structures that are persisted on a separate file server with gigabit connectivity to avoid the need for database reads. To create the indexes, database tables are decomposed vertically and stored by column, not row, and the indexes can be split horizontally for highly parallel processing on multiple processors. Smart compression is used based on dictionaries and integer processing, and optimized to run on 64-bit Intel CPUs. The algorithms are innovative and use TREX search engine technology. Flexibility is increased by adopting the adaptive computing par
