40 likes | 206 Views
High Performance Analytics (HPA) in NetWeaver 2004s Thomas Zurek SAP NetWeaver BI. Business Explorer. Any Tool. What is HPA ?. SAP NetWeaver 2004s. SAP BI 7.0. HPA Engine based on Adaptive Computing. Analytical Engine. InfoCubes. Data Acquisition. Any Source. What is HPA ? cont'd.
E N D
High Performance Analytics (HPA) in NetWeaver 2004sThomas ZurekSAP NetWeaver BI
BusinessExplorer Any Tool What is HPA ? SAP NetWeaver 2004s SAP BI 7.0 HPA Engine based on Adaptive Computing AnalyticalEngine InfoCubes DataAcquisition Any Source
What is HPA ? cont'd • blade-server based appliance • search engine technology • originally developed for unstructured data • now applied to structured data (cube data) • data resides in indexes • compressed • vertically / column-wise decomposed • no precomputed results (like materialized views, MOLAP aggregates, …) • query processing • parallel • horizontal partitioning • main memory processing
Cube 1,002,958,286 fact rows on the file system: CSV files: 950 GB on the RDBMS: data: 64 GB indexes: 56 GB on the HPA blade servers: indexes: 9 GB upload: ≈ 7 hours HPA server 7 * 2 CPU blades each CPU 3.2 GHz 2 GB memory per CPU 1 index server per CPU 470 MB memory consumed per server/CPU 120 GB Demo Statistics