SAP HANA 和 BWA的比较

时间:2021-08-08 16:19:56

Technically

   SAP HANA is far more than BWA

       Standard interfaces ( SQL, HTTP, REST, MDX )

       Real persistence layer ( not just flat files )   --->  redo/undo logs, backup/recovery,

   There is a lot of BWA/TREX in HANA

       Column store, distributed computing, calculation engine

   Beyond BWA

        Row store, persistence, transaction (MaxDB), SQL Parser,

 

Data Models / Content

   BWA relies completely on SAP BW

        You only load infocubes into BWA

           technically trivial data model, Automatic creation of relation / join conditions

        BWA has BW on top

           Complex logic? ---> Do it in BW

           Dewfining the data mode? ---> Do it in BW

           Analysis authorizations? ---> Do it in BW

   SAP HANA is intended as a Data Mart ( and BWA clearly is not ) ---> flexibility ( not tied to BW )

 

参考:

HANA能够作为传统交易型数据库,又能够作为分析型数据库来使用。

HANA还提供了标准化的SQL接口,包括SQL、MDX等,还有建模环境,分析和统计函数库。

HANA还能够以XS Engine和River等形式在数据库之上提供完整的应用平台支持,所有这些都是BWA所无法企及的。