7 Replies Latest reply: Oct 1, 2011 4:21 PM by Marc Bernard RSS

Reg : SAP HANA features

priya swaminathan
Currently Being Moderated

Hello,

 

I am presently evaluating the features of SAP HANA. For this, I would like to have the following information.

 

 

Hardware Requirements      

Processor,RAM,disk space requirements? Are there any other requirements?             

Supports Intel x64 based processor, 2TB RAM servers and servers like the Dell R910 and HP DL980

 

What are the supported operatingsystems?                                                                               

AIX 5.3, 6.1, HP-UX 11.31/IA64 and SUSE Linux Enterprise Server 10/11 64-bit operating

systems

      

Cost of hardware,price per procesor, license costs ?

 

Are there any other APIs supported?                                                                          

JDBC, ODBC, ODBO, SQLDBC, SAP BI 4.0, SQL/MDX, BICS

 

Are there any other SQL standards supported?                                                                        

  Full ANSI SQL-92 and EXCEL 2010 standard MDX

 

Do they support Triggers and if yes, how?

 

Do they support Stored procedures ?

 

Supported Index Types     Bitmap?

 

Data independence(Programming Abstraction)     Yes or No?

 

Transaction Processing support     Yes or No?

 

What are the levels in transaction isolation ?

 

Locking support - at Row,table ,database level?

 

Durability Support (ACID) ?

     Yes , Persistence layer

 

High Availability support -Replication?     

Yes

Backup & Recovery Support?     

Yes

 

Can SAP In-Memory Database act as a secondary cache to Relational DBMS? What are the databases supported by the cache?

 

Which kind of application profile is best suited for SAP In-Memory Databases? Does it produce best results for complex queries, subqueries,joins,table lookups? 

Well suited for OLAP applications.                                                                               

Does it offer a cost-based optimizer or rule-based optimizer?

 

Does it support partitioning and maximum number of partitions supported?

 

Utilities - for administrative tasks?

 

Could you please support on the above information?

 

Thanks in advance.

  • Re: Reg : SAP HANA features
    Mark Foerster
    Currently Being Moderated

    Hello Priya,

     

    SAP HANA is currently only sold as an appliance, so SAP realeases you from worrying about hardware specifics. You can only buy the certified appliances from HP, IBM, Cisco, Fujitsu etc. I haven't heard any announcement that HANA could be installed independently.

     

    Most of your other questions about interfaces etc are answered in this presentation from Marc Bernard:

    FEATURED EVENTS

    There is even an example of the syntax for Stored procedures.

     

    Regards,

     

    Mark

  • Re: Reg : SAP HANA features
    Witalij Rudnicki
    Currently Being Moderated

    Hi priya4484.

     

    From the list of your questions, I think after going through the material sugested by Mark, you should then talk to your SAP and hardware vendor(s) reps to get general understanding as well as price points.

     

    Regards,

    -Vitaliy

  • Re: Reg : SAP HANA features
    Marc Bernard
    Currently Being Moderated

    Hello Priya,

     

    a lot of questions... Anyway, here we go...

     

    Processor,RAM,disk space requirements? Are there any other requirements?

    Check the Product Availability Matrix. It lists all certified hardware for HANA.

    http://service.sap.com/pam > Type in "HANA"

     

    What are the supported operatingsystems?

    The applicance/server runs on LINUX SUSE SLES11/X86_64 64BIT exclusively.

    The studio runs on WINDOWS and LINUX.

    Check the PAM for client OS support.

     

    Cost of hardware,price per procesor, license costs ?

    Hardware costs > Please contact hardware vendor.

    License costs > Please contact your SAP account executive.

     

    Are there any other APIs supported?

    JDBC, ODBC, ODBO, SQLDBC, SAP BI 4.0, SQL/MDX, BICS

    Yes, but please see SAP Note <a href="http://service.sap.com/sap/support/notes/1577128">1577128</a>

     

    Are there any other SQL standards supported?

    SQL 92 and core features of SQL 99. On top of this HANA offers several SQL extensions for example for row and column based tables and conversion between the two.

     

    Do they support Triggers and if yes, how?

    No

     

    Do they support Stored procedures ?

    Yes

     

    Supported Index Types Bitmap?

    No. Column tables do not need any additional indexes. You can create secondary indexes for row tables (type btree).

     

    Data independence(Programming Abstraction)?

    There are various levels of abstraction. Not sure what you refer to.

     

    Transaction Processing support Yes or No?

    Yes. HANA is fully ACID compliant.

     

    What are the levels in transaction isolation ?

    Transaction and statement level isolation

     

    Locking support - at Row,table ,database level?

    HANA uses multi version concurrency control. Concurrent read operations see a consistent view of the database without blocking concurrent write operations. Write operations use row-level locks to prevent conflicts.

     

    Durability Support (ACID) ?

    Yes. See above.

     

    High Availability support - Replication?

    Yes. Depends on hardware vendor.

     

    Backup & Recovery Support?

    Yes. See http://help.sap.com/hana > System Administration > Database Backup and Recovery Guide

     

    Can SAP In-Memory Database act as a secondary cache to Relational DBMS? What are the databases supported by the cache?

    No. But you can load data from basically any RDBMS (see BusinessObjects Data Services) into HANA and report on the data in HANA.

     

    Which kind of application profile is best suited for SAP In-Memory Databases? Does it produce best results for complex queries, subqueries,joins,table lookups?

    HANA has many use case with benefits to a large number of business applications.

     

    Does it offer a cost-based optimizer or rule-based optimizer?

    Both. The calculation engine uses mostly rule-based optimization. The database engine uses a cost-based optimization.

     

    Does it support partitioning and maximum number of partitions supported?

    Yes. However, partitioning is typically used to split data across several hosts in distributed HANA databases. It's not necessary to speed up queries.

     

    Utilities - for administrative tasks?

    The central administration tool is the HANA Studio.

     

    Regards,

    Marc

    SAP Customer Solution Adoption (CSA)

Actions