1 / 22

SAP HANA

SAP HANA. What is SAP HANA. Provides in memory, column-oriented, relational database management system A modern platform for real-time analytics and applications is a combination of hardware and software specifically made to process massive real time data using In-Memory computing.

audi
Download Presentation

SAP HANA

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAP HANA

  2. What is SAP HANA • Provides in memory, column-oriented, relational database management system • A modern platform for real-time analytics and applications • is a combination of hardware and software specifically made to process massive real time data using In-Memory computing

  3. What is SAP HANA? • SAP • System Analysis and Program Development • German enterprise software developer • HANA • Short for “High-Performance Analytic Appliance” • In Memory • Column-oriented

  4. How does SAP hana work?

  5. How does SAP HANA work • Stores data in in-memory vs. disk-based memory • Stores data in column-based storage • Replicates and ingest data from SAP and non-SAP Databases & Applications

  6. How does SAP HANA work • In-Memory • Primarily relies on main memory • faster than disk-optimized databases since the internal optimization algorithms are simpler and execute fewer CPU instructions

  7. Column-Based Storage • The data sequence consists of the entries in one table column • Column layout supports sequential memory access

  8. Advantages of Column Based Storage • Faster Data Access • Only affected columns have to be read during the selection process of a query

  9. Advantages of Column Based Storage • Better Compression • Column data storage allows highly efficient compression because the majority of the columns contain only few distinct values compared to the number of rows

  10. Advantages of Column Based Storage • Better Parallel Processing • In a column store, data is already vertically partitioned. This means that operations on different columns can easily be processed in parallel. If multiple columns need to be searched or aggregated, each of these operations can be assigned to a different processor core

  11. How does SAP HANA work • Three styles of data replication • Trigger-Based • ETL (Extract, Transform, and Load) • Log based

  12. How does SAP HANA work • Trigger based replication • Near Real-time data • Replication server based on capturing the database changes at high level of abstraction in Enterprise resource planning • Benefits for database independent and parallelize the database changes on multiple tables.

  13. How does SAP HANA work • ETL (Extract, transform, and load) • Data services specify and load the relevant data in defined points of time in form an ERP system into SAP HANA DB • Reuse the application logic by reading the extractors or using SAP functions modules

  14. How does SAP HANA work • Log Based Replication • Based on capturing the table changes from low level database log files. • Method is Database Dependent

  15. How does SAP HANA work • The replicated data is then stored in RAM rather than loaded onto disk, the traditional form of application data storage. • Because the data is stored in-memory, it can be accessed in near real-time by analytic and transactional applications

  16. SAP Hana use Cases

  17. SAP Hana use Cases • Profitability reporting and forecasting • Retail merchandizing and supply-chain optimization • Security and fraud detection • Energy use monitoring and optimization • Telecommunications network monitoring and optimization.

  18. How much does SAP Hana cost

  19. How much does SAP HANA cost • SAP has not publicly released specific pricing information regarding HANA • Estimates indicate customers could have HANA up and running for under $300,000 including hardware, software, and services • Depending on scale, pricing levels can reach up to $2 million or more

  20. Benefits of SAP HANA

  21. Benefits of SAP HANA • Delivers Real-Time Analysis • Helps manage risk in Real-Time • Runs 3600x faster than traditional based database storage

  22. The END Any questions?

More Related