Real Time Analytics with SAP Hana: Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics

Vinay Singh

€17.99 ~~€26.99~~

4.8 (13 Ratings)

eBook Oct 2015 226 pages 1st Edition

Vinay Singh

€17.99 ~~€26.99~~

4.8 (13 Ratings)

eBook Oct 2015 226 pages 1st Edition

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Preview Book

Real Time Analytics with SAP Hana

Chapter 2. SAP HANA Data Modeling Approach

This chapter gets you started with the modeling approach. We start with a discussion about row and column storage and their usage. Then, we move on to the architecture of the SAP HANA engine and understand how different views are processed. We will also discuss the different schemas available in SAP HANA. This chapter will introduce you to modeling principle and guidelines. We will perform a comparative study of different modeling artifacts in SAP HANA. We will close the chapter with a learning of the SAP HANA Studio and how to create packages and delivery units.

After completing this chapter, you should be able to:

Differentiate between row and column storage, and know when to use what
Understand basic architecture of the SAP HANA engine
Differentiate between modeling artifacts in SAP HANA
Know modeling principles
Learn to use the SAP HANA Studio
Differentiate schemas in SAP HANA
Create packages and delivery units

Different modeling artifacts in SAP HANA

Before creating a new SAP HANA modeling artifact it is of paramount importance to know which types of modeling artifacts will be suitable for our business need. Depending on the scenario you are working in, your choice might vary. Factors that should be taken into consideration are:

The write- or read-intensive scenario, so as to decide between column and row storage
Data access need and resources for the replication method available
The application or client to be supported with your information model as different clients expose/consume data differently
Performance and functionality, as not all views can give the same functionality or performance

The first thing we need to decide is do we need a column table or row store. Once we have decided, we can have a glance at the following table and choose the views, if our requirement can be fulfilled by any of these:

	Column table	Analytical view	Calculation view (SQL)	Calculation view (CE function...

Different modeling artifacts in SAP HANA

The write- or read-intensive scenario, so as to decide between column and row storage
Data access need and resources for the replication method available
The application or client to be supported with your information model as different clients expose/consume data differently
Performance and functionality, as not all views can give the same functionality or performance

	Column table	Analytical view	Calculation view (SQL)	Calculation view (CE function )
Scenario...

Key benefits

This book will help you to process analytical and transactional data in real time with the help of SAP HANA.
Walk through the steps of the data modeling process and build various data models and artifacts in SAP HANA Studio.
Packed with rich examples and use cases that are closely focused on developing real-time applications.

Description

SAP HANA is an in-memory database created by SAP. SAP HANA breaks traditional database barriers to simplify IT landscapes, eliminating data preparation, pre-aggregation, and tuning. SAP HANA and in-memory computing allow you to instantly access huge volumes of structured and unstructured data, including text data, from different sources. Starting with data modeling, this fast-paced guide shows you how to add a system to SAP HANA Studio, create a schema, packages, and delivery unit. Moving on, you’ll get an understanding of real-time replication via SLT and learn how to use SAP HANA Studio to perform this. We’ll also have a quick look at SAP Business Object DATA service and SAP Direct Extractor for Data Load. After that, you will learn to create HANA artifacts—Analytical Privileges and Calculation View. At the end of the book, we will explore the SMART DATA access option and AFL library, and finally deliver pre-packaged functionality that can be used to build information models faster and easier.

Who is this book for?

If you are a SAP HANA data modeler, developer, implementation/migration consultant, project manager, or architect who is responsible for implementing/migrating to SAP HANA, then this book is for you.

What you will learn

Get to grips with the basic building blocks of Analytics/Data models in the SAP HANA environment.
Discover various schemas, modeling principles, Joins, and the architecture of the SAP HANA engine.
Build data models and artifacts in Sap HANA Studio.
Design decision tables and understand the concept of transport management in the SAP HANA landscape.
Work with the different views in SAP HANA Studio.
Explore full-text search and fuzzy search in SAP HANA.
Create your own scenarios and use cases using sample data and code.

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Frequently bought together

Software Development on the SAP HANA Platform

€48.99

€41.99

€32.99

Total € 123.97

Filter reviews by

All

Amazon verified reviews

George Nov 30, 2015

Being a HANA Administrator I found this book to be quite useful , especially when you are looking for step by step information without depending on multiple sources when time comes for troubleshooting or performance improvement. Also, it goes into details which helped me to understanding how to play with tables.Finally, the book goes into detail advanced topics with solving.We expect you to write more books on different topics .Highly recommended for starters or intermediate developers/designers of a Data Warehouse

Amazon Verified review

SuJo Dec 25, 2015

Buy this book, it's def 5/5 material. Right now Packt has it on sale for $5!!! You can't go wrong! I've used Elastic and Redis, but this was the first time I worked with SAP HANA. Absolutely brilliant model and it works well. This book guides you along the way the entire time, the author knows the subject matter extremely well and it really shines in the quality of this book. Seriously you can't beat this title for $5! Grab your copy today and learn how to utilize SAP HANA over the weekend.

Taha M. Mahmoud Nov 26, 2015

Real Time analytic-es is one of the most attractive BI topics nowadays. This was impossible or very expensive at near past; but we can use advanced technologies like SAP HANA to achieve this dream.I was a student for the Author "Vinay Singh" by attending one of the Official SAP training. I have to say that Vinay is a very knowledgeable person who have a great skills to teach and being one whom working in SAP Labs and one of the early first people whom get the chance to see how SAP HANA started and evolved. So, I was very interested to read this book.The author did a really very good job here as he started with some introductory chapters to setup the basics which required to understand the remaining chapters. Topics like difference between traditional database and in-memory database, joins, union, procedures and scripts in SAP HANA are discussed in the first chapter. The author moves to explain SAP HANA Studio and and different modeling techniques like (attribute views, analytical views and calculation views). After that; the author start talking about data loading and how we can use replication techniques like SAP HANA SLT to instant data replication into SAP HANA.I really liked the self-study questions which added by end of each chapter; this is an amazing way to help understanding topics and do more re-search. Finally; I would like to thank the Author for his effort and looking for more great SAP HANA Books

Tarek Assem Feb 04, 2016

This book is a gold mine, it has everything you might need to understand regarding real time analytics as well as the way HANA made the term "Real Time" even more realistic! Well written and easy to understand. Thanks Vinay!

Amazon Customer Nov 15, 2015

One of the best.

Real Time Analytics with SAP Hana: Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics

What do you get with eBook?

Real Time Analytics with SAP Hana

Chapter 2. SAP HANA Data Modeling Approach

Row and column storage in SAP HANA

Basic architecture of the SAP HANA engine

Different modeling artifacts in SAP HANA

SAP HANA Studio

Perspectives in SAP HANA Studio

Different schemas in SAP HANA

Row and column storage in SAP HANA

Basic architecture of the SAP HANA engine

Different modeling artifacts in SAP HANA

Page 1 of 9

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with eBook?

Product Details

Frequently bought together

Table of Contents

Recommendations for you

Customer reviews

Filter reviews by

People who bought this also bought

About the author

FAQs

Real Time Analytics with SAP Hana: Enhance your SAP HANA skills using this step-by-step guide to creating and reporting data models for real-time analytics

What do you get with eBook?

Contact Details

Billing Address

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with eBook?

Contact Details

Billing Address

Product Details

Packt Subscriptions

Frequently bought together

Table of Contents

Recommendations for you

Customer reviews

Filter reviews by

People who bought this also bought

About the author

FAQs