Session Previews: SAP Product Expert Jeff Tallman

    By: Mr. Adrian Bridgwater on Feb 06, 2015

    The ISUG-TECH blog talks to SAP Product Expert Jeff Tallman about his forthcoming sessions to be presented at the ISUG-TECH Conference in Atlanta.

    What is your position in your place of work?

    I work in SAP ASE Product Management – which means I work on a small team of people who are looking at the long term strategic direction of the SAP ASE product and work to ensure that customer requirements are considered.   This can be quite challenging sometimes as a completely new product is often easier as existing customer scenarios don’t need to be considered.  While the rest of the team all have product engineering backgrounds and understand the product development cycles, release/build requirements, etc., I bring a lot of field experience to the team – which I hope will be useful in representing customer requirements – both functional as well as ease of integration.

    What is the title of your session and when is it?

    Actually, I have several.  The first one that came to mind this year with respect to ISUG-TECH was “The Science of DBMS: Data Storage and Organization”. Not sure when it is scheduled (yet).  

    I also have a similar one “The Science of DBMS: Query Optimization” and am teaching a full day workshop on RS internals and performance & tuning – that one I do know when it is….it is currently scheduled to be a post-conference workshop on April 2nd.    

    I also am teaching a few other sessions – it will be busy – hopefully I get to sit in on a few sessions.   Last year I sat in on a session given by Solar Winds (nee Confio) on query tuning that discussed SQL graphing techniques – which is something I have advocated for a while.   It was interesting to see someone else’s notation and their approach.   It was also interesting to sit in on meetings with Bay Storage and other hardware partners to see the advances being made in hardware that is driving a lot of changes in datacenters.   

    Of course, I hope to spend some time meeting with old friends from customer sites, ISUG-TECH folks, as well as software partners such as Bradmark.

    What gave you the inspiration and drive to present this topic in this way?

    The reason it begins with “Science of DBMS” is that often I have found that DBA’s and developers are often unaware of the internal drivers behind implementations – and those decisions often have an impact on a lot of considerations that affect DBA’s and developers and understanding that often can lead to smarter implementations.   

    The product documentation discusses allocation units, extents and some aspects of datarow storage – I wanted to start at that level and explain how things are actually laid out and why.  But rather than just teach internals and how it works, I wanted to take an approach of then how it impacts query performance or DBMS features.  For example, in the Data Storage and Organization, I spend a bit of time looking at data compression methods, which ones other vendors use and the trade-offs associated as well as how to reduce the impacts it can have on query performance….and how hardware choices (e.g. big vs. little endian) may effect different types of compression and how different types of compression may impact data storage.  

    Similarly, I spend some time looking at data encryption techniques.  What I hope folks learn is that everything is a trade-off – and which trade-offs may be minor (e.g. null vs. not null) and which ones may have a more profound impact on query performance (e.g. compression/encryption).

    Why should people come to your session and why does it rock?

    I think it will be a good session for folks that have never been to the data structures class as they will learn about how the rows are actually stored on disk and provide a better understanding about how the in-memory row store will differ from the current IMDB implementation in SAP ASE.  Additionally, they will learn what the various compression techniques are and which ones are used by common DBMS’s such as SAP ASE, DB2, Oracle & MS SQL and see a bit beyond the marketing hype into what the impacts can be on query performance and how to minimize that impact.   Ditto on encryption.

    What is the one thing you hope attendees will take away from your session?

    A better understanding of DBMS data storage techniques used by ASE and what to expect from the various storage features.

    Released: February 6, 2015, 4:10 am | Updated: February 18, 2015, 6:31 am
    Keywords: ISUG-TECH News | Conference tracks


     

     

    TwitterLLinkedinLFacebook

    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk