SlideShare a Scribd company logo
1 of 18
September 10-13, 2012
                                                              Orlando, Florida




Impact of In-Memory Technology and
SAP HANA on Your Business, IT, and Career (updated for 2012)
Vitaliy Rudnytskiy, Developer Experience (DevEx), SAP
Dave Carlisle, HP-IT, Hewlett-Packard
Learning Points
     As SAP keeps executing on its in-memory vision,
      SAP In-memory technology is becoming the major piece
      in SAP solutions portfolio (SAP, BusinessObjects, Sybase)
     It is not just a niche toy for few übergeek experts anymore, but is
      reshaping the way business and IT are going to use
      SAP solutions, and it is impacting the set of skills required
     Look at the different layers of this technology and its extended
      landscape, and how they are mapped into the skills required by
      different roles in your business and IT teams


                 “The noblest pleasure is the joy of understanding”
                                                   - Leonardo da Vinci

2
Broader view on In-memory from SAP
     Applications for in-memory computing
        Customer's home-grown solutions or off-the-shelf products
         delivered by SAP or SAP partners
        Products can be brand new, or existing, but re-worked to
         benefit from in-memory technology

     SAP HANA as a platform
        As an appliance or in the cloud
        Bundled software products depending on the license

     In-memory technology
        Pretty wide term to describe everything that enables highly
         efficient storage and high performing processing of
         (sometimes substantial) data volumes

3
Major principles of SAP in-memory technology
     Keep all required data (aka “hot data”) in main memory
        Compress data to minimize the footprint by utilizing column storage
        Disk I/O is no longer an optimization target
             No need for pre-aggregated stores and multiple DB indexes
        Rarely accessed data (aka cold data) can be moved to cheap storage
     Cache sensitive data layout and cache-aware algorithms
        High locality (data that is needed together is stored together)
        Late materialization (decompress in cache)
     Software performance growth is in parallel processing, not clock speed
     Move data-intensive operations to the data layer
        Requires application logic in data layer (example: currency conversion)
                      “By 2012, 70% of Global 1000 organizations will load
                      detailed data into memory as the primary method
                      to optimize BI application performance.”        - Gartner

4
Learn It! Open web course from
    Week 1 (03.09.12 - 10.09.12)                 Week 4 (24.09.12 - 01.10.12)               https://openhpi.de
    The Future of Enterprise Computing:          In-Memory Database Operators Part 3:
    Introduction                                 Aggregate Functions
    New Requirements for Enterprise Computing    Parallel Select
    Enterprise Application Characteristics       Workload Management
    Changes in Hardware                          Parallel Join                                      You
    A Blueprint of SanssouciDB                   Parallel Aggregation
                                                                                                  still can
    Week 2 (10.09.12 - 17.09.12)                 Week 5 (01.10.12 - 08.10.12)                      enroll!
    Foundations of Database Storage Techniques   Advanced Database Storage Techniques:
    and In-Memory Database Operators Part 1:     Differential Buffer
    Dictionary Encoding                          Insert-only
    Compression                                  Merge
    Data Layout in Main Memory                   Logging
    Partitioning                                 Recovery
    Delete                                       On-the-fly Database Reorganization
    Insert
    Update                                       Week 6 (08.10.12 - 15.10.12)
    Tuple Reconstruction                         Foundations for a New Enterprise Application
    Scan Performance                             Development Era:
                                                 Implications
    Week 3 (17.09.12 - 24.09.12)                 Views
    In-Memory Database Operators Part 2:         Handling Business Objects
    Select                                       Bypass Solution
    Materialization Strategies
    Parallel Data Processing                     Week 7 (15.10.12 - 22.10.12)
    Indices                                      Final Exam
    Join


5
SAP In-Memory Technology Evolution




    Source: “SAP HANA Essentials”, Jeffrey Word


6
SAP HANA Database Architecture




7
Read It! Some Good Books

           “In-Memory Data Management: Technology and
    Applications”, Hasso Plattner, Alexander Zeier, 2nd ed.

     http://epic.hpi.uni-potsdam.de/Home/InMemoryBook




              “SAP HANA Essentials”, Jeff Word

              http://www.saphanabook.com/?__register=1
              Voucher-Code 17C55987 for free download




8
Data Mart Use Cases with SAP HANA and BI
     Data Marts are more narrow in scope comparing
      to the data warehouse: focused on selected subject areas,
      moderate volumes and typically one source system
     Data Mart use cases with SAP HANA and SAP BusinessObjects
        Operational Data Marts
           Getting data from business application (most typical is SAP ERP, but not
            necessarily) in the near real-time fashion using replication technology
           Lightly transformed source data
           Additional transformations based on non-materialized views
        Agile Data Marts
           Getting highly transformed data from a broader range of the SAP and
            non-SAP source systems in the batch fashion using SAP DataServices



9
Major Principles of SBOP Integration with SAP HANA
      There is very limited integration available between
       SAP BusinessObjects XI 3.1 and SAP HANA 1.0
      For optimal integration between SAP BusinessObjects 4.0
       and SAP HANA 1.0 make sure both systems are on matching
       Service Pack and patch levels
         See SAP Note 1577128 - Supported clients for SAP HANA 1.0 for
          details


      SAP HANA database can be used only as a reporting
       database with SAP BusinessObjects BI Platform 4.0 SP2
      As of 4.0 FP3 you can use SAP HANA database as well
       as a CMS and Auditing database


10
Authentication in SAP HANA Database
      Access to the SAP HANA database is secured by authentication
         Direct logon to the database with user name and password
         Kerberos (single sign-on)
      The SAP BusinessObjects Business Intelligence platform
       only provides single sign-on (SSO) authentication from FP3
       of the release 4.0 for SAP HANA database 1.0 SP3 through JDBC
       on MS Windows and Linux platforms
         Once users are logged on to the BI platform from an SAP
          BusinessObjects application by using their Windows AD credentials,
          they can perform actions that require database access, such as
          refreshing Web Intelligence documents, without providing their
          database credentials



11
Authorizations in SAP HANA Database
      For data access SAP HANA database provides the authorization
       concept based on two privilege types
         SQL privileges (access to database objects such as tables, SQL
          ownership concept)
         Analytical privileges (filters on information models for reporting
          purposes, for read operations only)
      Having analytical privileges built into the SAP HANA database
       allows unified data access management from different BI tools:
       Universe-based, SBO Analysis for MS Office, MDX-enabled
      There is no automated user and roles provisioning in SAP HANA
       database from SAP BusinessObjects BI Platform at the moment



12
Practice It! SAP HANA Developer Center
                          http://developer.sap.com/hana

                                          Two options
                                             Try&Test (30-days)
                                               Includes Visual
                                                Intelligence, SBO
                                                Analysis, Explorer
                                             Free SAP HANA
                                              Development
                                              License

                                                +
                                             Forums
                                             Blogs
                                             E-Learnings
                                              etc

13
SAP HANA DevCenter: facts speak better than words




14
Try It! SAP InnoJam
                      http://www.sapinnojam.com


                                     Multiple locations
                                        Design Thinking
                                        30 hours of coding
                                              HANA DB
                                              BusinessObjects
                                              Mobile
                                              etc




15
Key Learnings
     1. It’s time to learn about SAP in-memory technology –
        an unavoidable trend for all SAP customers –
        and start assessing its impact on your business and IT
     2. Get the holistic picture – learn to distinguish three overlapping
        but different layers – technology, platforms, and applications –
        and chart the roadmap for each of them in your planning
     3. Think early about how to do proper landscape planning satisfying
        all requirements to realize the ultimate promise
        of the HANA platform capable of simultaneous handling
        both OLTP and OLAP processing

           “A man paints with his brain and not with his hands”
                                                        -Michelangelo

16
To find even more
      From Dave:
         dave.carlisle@hp.com
         Video “HP Business Results with SAP HANA”
          (http://www.youtube.com/watch?v=aMKJBisNEQE)
      From Vitaliy:
         vitaliy.rudnytskiy@sap.com
         Twitter: @VitalBI, @Sygyzmundovych
         Blog: http://VitalBI.wordpress.com
      From SAP Communities:
         BI SIGs at http://www.ASUG.com
         Forum at SCN: http://scn.sap.com/community/hana-in-memory
      From SAP:
         http://www.ExperienceSAPHANA.com


17
Thank you for participating.
  Please provide feedback on this
session by completing a short survey
  via the event mobile application.
      SESSION CODE: 1214

     Learn more year-round at
          www.asug.com

More Related Content

What's hot

Introducing the SAP high-performance analytic appliance (SAP HANA)
Introducing the SAP high-performance analytic appliance (SAP HANA)Introducing the SAP high-performance analytic appliance (SAP HANA)
Introducing the SAP high-performance analytic appliance (SAP HANA)IBM India Smarter Computing
 
Innovating the Real-Time Business with SAP BusinessObjects BI Solutions and S...
Innovating the Real-Time Business with SAP BusinessObjects BI Solutions and S...Innovating the Real-Time Business with SAP BusinessObjects BI Solutions and S...
Innovating the Real-Time Business with SAP BusinessObjects BI Solutions and S...SAP Analytics
 
Innovations in SAP BusinessObjects 4.0
Innovations in SAP BusinessObjects 4.0Innovations in SAP BusinessObjects 4.0
Innovations in SAP BusinessObjects 4.0Pierre Leroux
 
Asug SAP HANA Presentation - Perceptive Technologies SAP
Asug SAP HANA Presentation - Perceptive Technologies SAPAsug SAP HANA Presentation - Perceptive Technologies SAP
Asug SAP HANA Presentation - Perceptive Technologies SAPBrendan Kane
 
Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Doug Berry
 
SAP Hana Solution Brief
SAP Hana Solution BriefSAP Hana Solution Brief
SAP Hana Solution Briefkavyakaya
 
1310 success stories_and_lessons_learned_implementing_sap_hana_solutions
1310 success stories_and_lessons_learned_implementing_sap_hana_solutions1310 success stories_and_lessons_learned_implementing_sap_hana_solutions
1310 success stories_and_lessons_learned_implementing_sap_hana_solutionsBobby Shah
 
Hana Intel SAP Whitepaper
Hana Intel SAP WhitepaperHana Intel SAP Whitepaper
Hana Intel SAP Whitepaperugur candan
 
HANA Demystified by DataMagnum
HANA Demystified by DataMagnumHANA Demystified by DataMagnum
HANA Demystified by DataMagnumPrasad Mavuduri
 
Document Imaging and the SAP Content Server 101
Document Imaging and the SAP Content Server 101Document Imaging and the SAP Content Server 101
Document Imaging and the SAP Content Server 101Verbella CMG
 
Summit 2011 ods edw technical
Summit 2011 ods edw technicalSummit 2011 ods edw technical
Summit 2011 ods edw technicalGreg Turmel
 
Document imaging 101 Imaging 101 using SAP's Content Server
Document imaging 101 Imaging 101 using SAP's Content Server Document imaging 101 Imaging 101 using SAP's Content Server
Document imaging 101 Imaging 101 using SAP's Content Server Verbella CMG
 
SAP HANA Lösungen in der Praxis
SAP HANA Lösungen in der PraxisSAP HANA Lösungen in der Praxis
SAP HANA Lösungen in der PraxisIBM Switzerland
 
Informatica World 2006 - MDM Data Quality
Informatica World 2006 - MDM Data QualityInformatica World 2006 - MDM Data Quality
Informatica World 2006 - MDM Data QualityDatabase Architechs
 
HANA overview
HANA overviewHANA overview
HANA overviewjenkin
 
Talk IT_ Oracle_김태완_110831
Talk IT_ Oracle_김태완_110831Talk IT_ Oracle_김태완_110831
Talk IT_ Oracle_김태완_110831Cana Ko
 

What's hot (16)

Introducing the SAP high-performance analytic appliance (SAP HANA)
Introducing the SAP high-performance analytic appliance (SAP HANA)Introducing the SAP high-performance analytic appliance (SAP HANA)
Introducing the SAP high-performance analytic appliance (SAP HANA)
 
Innovating the Real-Time Business with SAP BusinessObjects BI Solutions and S...
Innovating the Real-Time Business with SAP BusinessObjects BI Solutions and S...Innovating the Real-Time Business with SAP BusinessObjects BI Solutions and S...
Innovating the Real-Time Business with SAP BusinessObjects BI Solutions and S...
 
Innovations in SAP BusinessObjects 4.0
Innovations in SAP BusinessObjects 4.0Innovations in SAP BusinessObjects 4.0
Innovations in SAP BusinessObjects 4.0
 
Asug SAP HANA Presentation - Perceptive Technologies SAP
Asug SAP HANA Presentation - Perceptive Technologies SAPAsug SAP HANA Presentation - Perceptive Technologies SAP
Asug SAP HANA Presentation - Perceptive Technologies SAP
 
Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8
 
SAP Hana Solution Brief
SAP Hana Solution BriefSAP Hana Solution Brief
SAP Hana Solution Brief
 
1310 success stories_and_lessons_learned_implementing_sap_hana_solutions
1310 success stories_and_lessons_learned_implementing_sap_hana_solutions1310 success stories_and_lessons_learned_implementing_sap_hana_solutions
1310 success stories_and_lessons_learned_implementing_sap_hana_solutions
 
Hana Intel SAP Whitepaper
Hana Intel SAP WhitepaperHana Intel SAP Whitepaper
Hana Intel SAP Whitepaper
 
HANA Demystified by DataMagnum
HANA Demystified by DataMagnumHANA Demystified by DataMagnum
HANA Demystified by DataMagnum
 
Document Imaging and the SAP Content Server 101
Document Imaging and the SAP Content Server 101Document Imaging and the SAP Content Server 101
Document Imaging and the SAP Content Server 101
 
Summit 2011 ods edw technical
Summit 2011 ods edw technicalSummit 2011 ods edw technical
Summit 2011 ods edw technical
 
Document imaging 101 Imaging 101 using SAP's Content Server
Document imaging 101 Imaging 101 using SAP's Content Server Document imaging 101 Imaging 101 using SAP's Content Server
Document imaging 101 Imaging 101 using SAP's Content Server
 
SAP HANA Lösungen in der Praxis
SAP HANA Lösungen in der PraxisSAP HANA Lösungen in der Praxis
SAP HANA Lösungen in der Praxis
 
Informatica World 2006 - MDM Data Quality
Informatica World 2006 - MDM Data QualityInformatica World 2006 - MDM Data Quality
Informatica World 2006 - MDM Data Quality
 
HANA overview
HANA overviewHANA overview
HANA overview
 
Talk IT_ Oracle_김태완_110831
Talk IT_ Oracle_김태완_110831Talk IT_ Oracle_김태완_110831
Talk IT_ Oracle_김태완_110831
 

Similar to Impact of in-memory technology and SAP HANA (2012 Update)

SAP HANA – A Technical Snapshot
SAP HANA – A Technical SnapshotSAP HANA – A Technical Snapshot
SAP HANA – A Technical SnapshotDebajit Banerjee
 
Non-SAP Data Integration with SAP HANA_v5.0
Non-SAP Data Integration with SAP HANA_v5.0Non-SAP Data Integration with SAP HANA_v5.0
Non-SAP Data Integration with SAP HANA_v5.0Tim Korba
 
Power of the SAP HANA Platform – Integrating non-SAP data with custom HANA ap...
Power of the SAP HANA Platform – Integrating non-SAP data with custom HANA ap...Power of the SAP HANA Platform – Integrating non-SAP data with custom HANA ap...
Power of the SAP HANA Platform – Integrating non-SAP data with custom HANA ap...Dickinson + Associates
 
ManMachine&Mathematics_Arup_Ray_Ext
ManMachine&Mathematics_Arup_Ray_ExtManMachine&Mathematics_Arup_Ray_Ext
ManMachine&Mathematics_Arup_Ray_ExtArup Ray
 
SAP Strategie und Innovation
SAP Strategie und InnovationSAP Strategie und Innovation
SAP Strategie und InnovationIBM Switzerland
 
Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Doug Berry
 
5507832a c074-4013-9d49-6e58befa9c3e-161121113026
5507832a c074-4013-9d49-6e58befa9c3e-1611211130265507832a c074-4013-9d49-6e58befa9c3e-161121113026
5507832a c074-4013-9d49-6e58befa9c3e-161121113026Krishna Kiran
 
Extreme SSAS- SQL 2011
Extreme SSAS- SQL 2011Extreme SSAS- SQL 2011
Extreme SSAS- SQL 2011Itay Braun
 
MDS ap_OEM Product Portfolio Intorduction to the DT & Analytics
MDS ap_OEM Product Portfolio Intorduction to the DT & AnalyticsMDS ap_OEM Product Portfolio Intorduction to the DT & Analytics
MDS ap_OEM Product Portfolio Intorduction to the DT & AnalyticsMDS ap
 
Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Doug Berry
 
#sitROME 2015 - SAP HANA project experiences
#sitROME 2015 - SAP HANA project experiences#sitROME 2015 - SAP HANA project experiences
#sitROME 2015 - SAP HANA project experiencesSbgMartin
 

Similar to Impact of in-memory technology and SAP HANA (2012 Update) (20)

SAP HANA - Understanding the Basics
SAP HANA - Understanding the Basics SAP HANA - Understanding the Basics
SAP HANA - Understanding the Basics
 
SAP HANA
SAP HANASAP HANA
SAP HANA
 
SAP HANA – A Technical Snapshot
SAP HANA – A Technical SnapshotSAP HANA – A Technical Snapshot
SAP HANA – A Technical Snapshot
 
SAP HANA Overview
SAP HANA OverviewSAP HANA Overview
SAP HANA Overview
 
Symphony Driver Essay
Symphony Driver EssaySymphony Driver Essay
Symphony Driver Essay
 
Cool features 7.4
Cool features 7.4Cool features 7.4
Cool features 7.4
 
Non-SAP Data Integration with SAP HANA_v5.0
Non-SAP Data Integration with SAP HANA_v5.0Non-SAP Data Integration with SAP HANA_v5.0
Non-SAP Data Integration with SAP HANA_v5.0
 
HANA SITSP 2011
HANA SITSP 2011HANA SITSP 2011
HANA SITSP 2011
 
Power of the SAP HANA Platform – Integrating non-SAP data with custom HANA ap...
Power of the SAP HANA Platform – Integrating non-SAP data with custom HANA ap...Power of the SAP HANA Platform – Integrating non-SAP data with custom HANA ap...
Power of the SAP HANA Platform – Integrating non-SAP data with custom HANA ap...
 
ManMachine&Mathematics_Arup_Ray_Ext
ManMachine&Mathematics_Arup_Ray_ExtManMachine&Mathematics_Arup_Ray_Ext
ManMachine&Mathematics_Arup_Ray_Ext
 
SAP Strategie und Innovation
SAP Strategie und InnovationSAP Strategie und Innovation
SAP Strategie und Innovation
 
Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8
 
Project report
Project reportProject report
Project report
 
5507832a c074-4013-9d49-6e58befa9c3e-161121113026
5507832a c074-4013-9d49-6e58befa9c3e-1611211130265507832a c074-4013-9d49-6e58befa9c3e-161121113026
5507832a c074-4013-9d49-6e58befa9c3e-161121113026
 
HANA
HANAHANA
HANA
 
Sap hana
Sap hanaSap hana
Sap hana
 
Extreme SSAS- SQL 2011
Extreme SSAS- SQL 2011Extreme SSAS- SQL 2011
Extreme SSAS- SQL 2011
 
MDS ap_OEM Product Portfolio Intorduction to the DT & Analytics
MDS ap_OEM Product Portfolio Intorduction to the DT & AnalyticsMDS ap_OEM Product Portfolio Intorduction to the DT & Analytics
MDS ap_OEM Product Portfolio Intorduction to the DT & Analytics
 
Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8Hana To Go Presentation Final With Demo Screen Shots Nov8
Hana To Go Presentation Final With Demo Screen Shots Nov8
 
#sitROME 2015 - SAP HANA project experiences
#sitROME 2015 - SAP HANA project experiences#sitROME 2015 - SAP HANA project experiences
#sitROME 2015 - SAP HANA project experiences
 

Recently uploaded

UiPath Studio Web workshop series - Day 2
UiPath Studio Web workshop series - Day 2UiPath Studio Web workshop series - Day 2
UiPath Studio Web workshop series - Day 2DianaGray10
 
How to release an Open Source Dataweave Library
How to release an Open Source Dataweave LibraryHow to release an Open Source Dataweave Library
How to release an Open Source Dataweave Libraryshyamraj55
 
Oracle Database 23c Security New Features.pptx
Oracle Database 23c Security New Features.pptxOracle Database 23c Security New Features.pptx
Oracle Database 23c Security New Features.pptxSatishbabu Gunukula
 
EMEA What is ThousandEyes? Webinar
EMEA What is ThousandEyes? WebinarEMEA What is ThousandEyes? Webinar
EMEA What is ThousandEyes? WebinarThousandEyes
 
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptxEmil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptxNeo4j
 
Planetek Italia Srl - Corporate Profile Brochure
Planetek Italia Srl - Corporate Profile BrochurePlanetek Italia Srl - Corporate Profile Brochure
Planetek Italia Srl - Corporate Profile BrochurePlanetek Italia Srl
 
Webinar: The Art of Prioritizing Your Product Roadmap by AWS Sr PM - Tech
Webinar: The Art of Prioritizing Your Product Roadmap by AWS Sr PM - TechWebinar: The Art of Prioritizing Your Product Roadmap by AWS Sr PM - Tech
Webinar: The Art of Prioritizing Your Product Roadmap by AWS Sr PM - TechProduct School
 
March Patch Tuesday
March Patch TuesdayMarch Patch Tuesday
March Patch TuesdayIvanti
 
TrustArc Webinar - How to Live in a Post Third-Party Cookie World
TrustArc Webinar - How to Live in a Post Third-Party Cookie WorldTrustArc Webinar - How to Live in a Post Third-Party Cookie World
TrustArc Webinar - How to Live in a Post Third-Party Cookie WorldTrustArc
 
Scenario Library et REX Discover industry- and role- based scenarios
Scenario Library et REX Discover industry- and role- based scenariosScenario Library et REX Discover industry- and role- based scenarios
Scenario Library et REX Discover industry- and role- based scenariosErol GIRAUDY
 
UiPath Studio Web workshop series - Day 1
UiPath Studio Web workshop series  - Day 1UiPath Studio Web workshop series  - Day 1
UiPath Studio Web workshop series - Day 1DianaGray10
 
Stobox 4: Revolutionizing Investment in Real-World Assets Through Tokenization
Stobox 4: Revolutionizing Investment in Real-World Assets Through TokenizationStobox 4: Revolutionizing Investment in Real-World Assets Through Tokenization
Stobox 4: Revolutionizing Investment in Real-World Assets Through TokenizationStobox
 
.NET 8 ChatBot with Azure OpenAI Services.pptx
.NET 8 ChatBot with Azure OpenAI Services.pptx.NET 8 ChatBot with Azure OpenAI Services.pptx
.NET 8 ChatBot with Azure OpenAI Services.pptxHansamali Gamage
 
My key hands-on projects in Quantum, and QAI
My key hands-on projects in Quantum, and QAIMy key hands-on projects in Quantum, and QAI
My key hands-on projects in Quantum, and QAIVijayananda Mohire
 
UiPath Studio Web workshop series - Day 4
UiPath Studio Web workshop series - Day 4UiPath Studio Web workshop series - Day 4
UiPath Studio Web workshop series - Day 4DianaGray10
 
Where developers are challenged, what developers want and where DevEx is going
Where developers are challenged, what developers want and where DevEx is goingWhere developers are challenged, what developers want and where DevEx is going
Where developers are challenged, what developers want and where DevEx is goingFrancesco Corti
 
Trailblazer Community - Flows Workshop (Session 2)
Trailblazer Community - Flows Workshop (Session 2)Trailblazer Community - Flows Workshop (Session 2)
Trailblazer Community - Flows Workshop (Session 2)Muhammad Tiham Siddiqui
 
Top 10 Squarespace Development Companies
Top 10 Squarespace Development CompaniesTop 10 Squarespace Development Companies
Top 10 Squarespace Development CompaniesTopCSSGallery
 
Explore the UiPath Community and ways you can benefit on your journey to auto...
Explore the UiPath Community and ways you can benefit on your journey to auto...Explore the UiPath Community and ways you can benefit on your journey to auto...
Explore the UiPath Community and ways you can benefit on your journey to auto...DianaGray10
 

Recently uploaded (20)

UiPath Studio Web workshop series - Day 2
UiPath Studio Web workshop series - Day 2UiPath Studio Web workshop series - Day 2
UiPath Studio Web workshop series - Day 2
 
How to release an Open Source Dataweave Library
How to release an Open Source Dataweave LibraryHow to release an Open Source Dataweave Library
How to release an Open Source Dataweave Library
 
Oracle Database 23c Security New Features.pptx
Oracle Database 23c Security New Features.pptxOracle Database 23c Security New Features.pptx
Oracle Database 23c Security New Features.pptx
 
EMEA What is ThousandEyes? Webinar
EMEA What is ThousandEyes? WebinarEMEA What is ThousandEyes? Webinar
EMEA What is ThousandEyes? Webinar
 
SheDev 2024
SheDev 2024SheDev 2024
SheDev 2024
 
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptxEmil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
Emil Eifrem at GraphSummit Copenhagen 2024 - The Art of the Possible.pptx
 
Planetek Italia Srl - Corporate Profile Brochure
Planetek Italia Srl - Corporate Profile BrochurePlanetek Italia Srl - Corporate Profile Brochure
Planetek Italia Srl - Corporate Profile Brochure
 
Webinar: The Art of Prioritizing Your Product Roadmap by AWS Sr PM - Tech
Webinar: The Art of Prioritizing Your Product Roadmap by AWS Sr PM - TechWebinar: The Art of Prioritizing Your Product Roadmap by AWS Sr PM - Tech
Webinar: The Art of Prioritizing Your Product Roadmap by AWS Sr PM - Tech
 
March Patch Tuesday
March Patch TuesdayMarch Patch Tuesday
March Patch Tuesday
 
TrustArc Webinar - How to Live in a Post Third-Party Cookie World
TrustArc Webinar - How to Live in a Post Third-Party Cookie WorldTrustArc Webinar - How to Live in a Post Third-Party Cookie World
TrustArc Webinar - How to Live in a Post Third-Party Cookie World
 
Scenario Library et REX Discover industry- and role- based scenarios
Scenario Library et REX Discover industry- and role- based scenariosScenario Library et REX Discover industry- and role- based scenarios
Scenario Library et REX Discover industry- and role- based scenarios
 
UiPath Studio Web workshop series - Day 1
UiPath Studio Web workshop series  - Day 1UiPath Studio Web workshop series  - Day 1
UiPath Studio Web workshop series - Day 1
 
Stobox 4: Revolutionizing Investment in Real-World Assets Through Tokenization
Stobox 4: Revolutionizing Investment in Real-World Assets Through TokenizationStobox 4: Revolutionizing Investment in Real-World Assets Through Tokenization
Stobox 4: Revolutionizing Investment in Real-World Assets Through Tokenization
 
.NET 8 ChatBot with Azure OpenAI Services.pptx
.NET 8 ChatBot with Azure OpenAI Services.pptx.NET 8 ChatBot with Azure OpenAI Services.pptx
.NET 8 ChatBot with Azure OpenAI Services.pptx
 
My key hands-on projects in Quantum, and QAI
My key hands-on projects in Quantum, and QAIMy key hands-on projects in Quantum, and QAI
My key hands-on projects in Quantum, and QAI
 
UiPath Studio Web workshop series - Day 4
UiPath Studio Web workshop series - Day 4UiPath Studio Web workshop series - Day 4
UiPath Studio Web workshop series - Day 4
 
Where developers are challenged, what developers want and where DevEx is going
Where developers are challenged, what developers want and where DevEx is goingWhere developers are challenged, what developers want and where DevEx is going
Where developers are challenged, what developers want and where DevEx is going
 
Trailblazer Community - Flows Workshop (Session 2)
Trailblazer Community - Flows Workshop (Session 2)Trailblazer Community - Flows Workshop (Session 2)
Trailblazer Community - Flows Workshop (Session 2)
 
Top 10 Squarespace Development Companies
Top 10 Squarespace Development CompaniesTop 10 Squarespace Development Companies
Top 10 Squarespace Development Companies
 
Explore the UiPath Community and ways you can benefit on your journey to auto...
Explore the UiPath Community and ways you can benefit on your journey to auto...Explore the UiPath Community and ways you can benefit on your journey to auto...
Explore the UiPath Community and ways you can benefit on your journey to auto...
 

Impact of in-memory technology and SAP HANA (2012 Update)

  • 1. September 10-13, 2012 Orlando, Florida Impact of In-Memory Technology and SAP HANA on Your Business, IT, and Career (updated for 2012) Vitaliy Rudnytskiy, Developer Experience (DevEx), SAP Dave Carlisle, HP-IT, Hewlett-Packard
  • 2. Learning Points  As SAP keeps executing on its in-memory vision, SAP In-memory technology is becoming the major piece in SAP solutions portfolio (SAP, BusinessObjects, Sybase)  It is not just a niche toy for few übergeek experts anymore, but is reshaping the way business and IT are going to use SAP solutions, and it is impacting the set of skills required  Look at the different layers of this technology and its extended landscape, and how they are mapped into the skills required by different roles in your business and IT teams “The noblest pleasure is the joy of understanding” - Leonardo da Vinci 2
  • 3. Broader view on In-memory from SAP  Applications for in-memory computing  Customer's home-grown solutions or off-the-shelf products delivered by SAP or SAP partners  Products can be brand new, or existing, but re-worked to benefit from in-memory technology  SAP HANA as a platform  As an appliance or in the cloud  Bundled software products depending on the license  In-memory technology  Pretty wide term to describe everything that enables highly efficient storage and high performing processing of (sometimes substantial) data volumes 3
  • 4. Major principles of SAP in-memory technology  Keep all required data (aka “hot data”) in main memory  Compress data to minimize the footprint by utilizing column storage  Disk I/O is no longer an optimization target  No need for pre-aggregated stores and multiple DB indexes  Rarely accessed data (aka cold data) can be moved to cheap storage  Cache sensitive data layout and cache-aware algorithms  High locality (data that is needed together is stored together)  Late materialization (decompress in cache)  Software performance growth is in parallel processing, not clock speed  Move data-intensive operations to the data layer  Requires application logic in data layer (example: currency conversion) “By 2012, 70% of Global 1000 organizations will load detailed data into memory as the primary method to optimize BI application performance.” - Gartner 4
  • 5. Learn It! Open web course from Week 1 (03.09.12 - 10.09.12) Week 4 (24.09.12 - 01.10.12) https://openhpi.de The Future of Enterprise Computing: In-Memory Database Operators Part 3: Introduction Aggregate Functions New Requirements for Enterprise Computing Parallel Select Enterprise Application Characteristics Workload Management Changes in Hardware Parallel Join You A Blueprint of SanssouciDB Parallel Aggregation still can Week 2 (10.09.12 - 17.09.12) Week 5 (01.10.12 - 08.10.12) enroll! Foundations of Database Storage Techniques Advanced Database Storage Techniques: and In-Memory Database Operators Part 1: Differential Buffer Dictionary Encoding Insert-only Compression Merge Data Layout in Main Memory Logging Partitioning Recovery Delete On-the-fly Database Reorganization Insert Update Week 6 (08.10.12 - 15.10.12) Tuple Reconstruction Foundations for a New Enterprise Application Scan Performance Development Era: Implications Week 3 (17.09.12 - 24.09.12) Views In-Memory Database Operators Part 2: Handling Business Objects Select Bypass Solution Materialization Strategies Parallel Data Processing Week 7 (15.10.12 - 22.10.12) Indices Final Exam Join 5
  • 6. SAP In-Memory Technology Evolution Source: “SAP HANA Essentials”, Jeffrey Word 6
  • 7. SAP HANA Database Architecture 7
  • 8. Read It! Some Good Books “In-Memory Data Management: Technology and Applications”, Hasso Plattner, Alexander Zeier, 2nd ed. http://epic.hpi.uni-potsdam.de/Home/InMemoryBook “SAP HANA Essentials”, Jeff Word http://www.saphanabook.com/?__register=1 Voucher-Code 17C55987 for free download 8
  • 9. Data Mart Use Cases with SAP HANA and BI  Data Marts are more narrow in scope comparing to the data warehouse: focused on selected subject areas, moderate volumes and typically one source system  Data Mart use cases with SAP HANA and SAP BusinessObjects  Operational Data Marts  Getting data from business application (most typical is SAP ERP, but not necessarily) in the near real-time fashion using replication technology  Lightly transformed source data  Additional transformations based on non-materialized views  Agile Data Marts  Getting highly transformed data from a broader range of the SAP and non-SAP source systems in the batch fashion using SAP DataServices 9
  • 10. Major Principles of SBOP Integration with SAP HANA  There is very limited integration available between SAP BusinessObjects XI 3.1 and SAP HANA 1.0  For optimal integration between SAP BusinessObjects 4.0 and SAP HANA 1.0 make sure both systems are on matching Service Pack and patch levels  See SAP Note 1577128 - Supported clients for SAP HANA 1.0 for details  SAP HANA database can be used only as a reporting database with SAP BusinessObjects BI Platform 4.0 SP2  As of 4.0 FP3 you can use SAP HANA database as well as a CMS and Auditing database 10
  • 11. Authentication in SAP HANA Database  Access to the SAP HANA database is secured by authentication  Direct logon to the database with user name and password  Kerberos (single sign-on)  The SAP BusinessObjects Business Intelligence platform only provides single sign-on (SSO) authentication from FP3 of the release 4.0 for SAP HANA database 1.0 SP3 through JDBC on MS Windows and Linux platforms  Once users are logged on to the BI platform from an SAP BusinessObjects application by using their Windows AD credentials, they can perform actions that require database access, such as refreshing Web Intelligence documents, without providing their database credentials 11
  • 12. Authorizations in SAP HANA Database  For data access SAP HANA database provides the authorization concept based on two privilege types  SQL privileges (access to database objects such as tables, SQL ownership concept)  Analytical privileges (filters on information models for reporting purposes, for read operations only)  Having analytical privileges built into the SAP HANA database allows unified data access management from different BI tools: Universe-based, SBO Analysis for MS Office, MDX-enabled  There is no automated user and roles provisioning in SAP HANA database from SAP BusinessObjects BI Platform at the moment 12
  • 13. Practice It! SAP HANA Developer Center http://developer.sap.com/hana  Two options  Try&Test (30-days)  Includes Visual Intelligence, SBO Analysis, Explorer  Free SAP HANA Development License +  Forums  Blogs  E-Learnings etc 13
  • 14. SAP HANA DevCenter: facts speak better than words 14
  • 15. Try It! SAP InnoJam http://www.sapinnojam.com  Multiple locations  Design Thinking  30 hours of coding  HANA DB  BusinessObjects  Mobile  etc 15
  • 16. Key Learnings 1. It’s time to learn about SAP in-memory technology – an unavoidable trend for all SAP customers – and start assessing its impact on your business and IT 2. Get the holistic picture – learn to distinguish three overlapping but different layers – technology, platforms, and applications – and chart the roadmap for each of them in your planning 3. Think early about how to do proper landscape planning satisfying all requirements to realize the ultimate promise of the HANA platform capable of simultaneous handling both OLTP and OLAP processing “A man paints with his brain and not with his hands” -Michelangelo 16
  • 17. To find even more  From Dave:  dave.carlisle@hp.com  Video “HP Business Results with SAP HANA” (http://www.youtube.com/watch?v=aMKJBisNEQE)  From Vitaliy:  vitaliy.rudnytskiy@sap.com  Twitter: @VitalBI, @Sygyzmundovych  Blog: http://VitalBI.wordpress.com  From SAP Communities:  BI SIGs at http://www.ASUG.com  Forum at SCN: http://scn.sap.com/community/hana-in-memory  From SAP:  http://www.ExperienceSAPHANA.com 17
  • 18. Thank you for participating. Please provide feedback on this session by completing a short survey via the event mobile application. SESSION CODE: 1214 Learn more year-round at www.asug.com