What's the difference between SAP BWA and HANA?
SAP Business Warehouse Accelerator (SAP BWA) is one of the ancestors of HANA, so there are definite similarities between the two SAP technologies. Both are in-memory, columnar, parallel database architectures. This means that both systems can distribute large queries evenly among hundreds of processors across several servers. However, BWA is very narrowly focused on its use case as an analytics accelerator and lacks many of the capabilities that allow HANA to act as a full database and application platform. For example, BWA requires that whenever data changes, its columnar indexes are fully rebuilt.
For more on SAP, HANA
What's SAP's approach to big data?
Know the difference between the HANA Enterprise Cloud and the HANA Cloud Platform?
What does it cost to run an SAP project in the AWS cloud?
HANA allows for much more fine-grained updates, allowing indices to be rebuilt much less often, making HANA workable as a transactional and an analytic database. HANA also provides standard interfaces (like SQL and MDX), a modeling environment, analytic and statistical function libraries and a full-fledged application platform on top of its database capabilities in the form of XS Engine and River -- all things that BWA never really aspired to.
So is there any place for BWA anymore? Not really. If a company already has BWA and doesn't want to go through the potential expense and disruption of migrating to BW on HANA, then it might make sense to stick with BWA for the moment. But the future looks to be BW on HANA. On the bright side, BW on HANA may not be as expensive a proposition as it seems at first, because BW and HANA both provide ample options for keeping data in cheaper, disk-based storage systems like SAP's Sybase IQ or Apache Hive while still getting good (but not as good, in most cases) performance.
Dig Deeper on SAP Business Warehouse
Related Q&A from Ethan Jewett
The design rule of thumb is to keep the Launchpad tile count under 20. But what about power users who need to launch more applications? Here are ... Continue Reading
The way Launchpad versions relate to each other and to SAPUI5 versions isn't intuitive, and both affect app compatibility and access to newer ... Continue Reading
If you want to get more serious about developing UI5 apps, you need to know how the libraries fit into the broader architecture, as well as their ... Continue Reading