Showing posts with label HANA. Show all posts
Showing posts with label HANA. Show all posts

Sunday, May 26, 2013

Cost-free, ERP-free Online HANA Course (UPDATE)


UPDATE: SAP has changed the start date from Sunday to Monday...

If you're interested in HANA The Relational Database Management System (and maybe you should be), there's a free online course starting on May 26, 2013 (that's four days from now): Monday, May 27, 2013:


Introduction to Software Development on SAP HANA

Thomas Jung

SAP HANA is an in-memory data platform that is deployable as an appliance or in the cloud. At its core, it is an innovative in-memory relational database management system that makes full sense of the capabilities of current hardware to increase application performance, to reduce cost of ownership, and to enable new scenarios and applications that were not possible before.

With SAP HANA, you have the opportunity to build applications that integrate the business logic, control logic, and the database layer with unprecedented performance. As a developer, one of the key questions is how you can minimize data movements. The more you can do directly on the data in memory next to the CPUs, the better the application will perform.

This course will introduce you to native software development on SAP HANA. Registration, learning content, and the final exam are free of charge. However, to fully benefit from the course, you can access a fee-based system environment to develop your own code. SAP works with several cloud providers to give you a choice of infrastructure platforms and attractive pricing models to enable system access at a very low cost.

Start: May 26, 2013 no, it's not starting on Sunday, in spite of what the SAP website said, it's starting on Monday, May 27, 2013... at least, that's what the website says now :)

Course language: English

If you think you might be interested...

. . . as a developer interested in new technologies, it might help to watch the inventor (and others) talk about it:

If you want to get ready...

. . . and take a "warm-up to the introduction" that's available, for free, right now, try this:

Warm-Up: In-Memory Data Management

Dr.-Ing. Jürgen Müller

While the first openSAP course, Introduction to Software Development on SAP HANA, is intended as an introductory class for software developers who are new to SAP HANA, it makes sense for course participants to obtain an understanding of the fundamental concepts of in-memory data management before the course starts.

If you have taken the openHPI course on the topic that was delivered by Prof. Hasso Plattner in 2012, you will be good to go. If you have not attended this course or similar training programs on in-memory data management, we recommend that you use this summary of Prof. Plattner’s lectures as a warm-up exercise. The summary was prepared by Dr.-Ing. Jürgen Müller (HPI) and is exclusively available on openSAP.

Start: Apr 28, 2013

Course language: English

...and the best part?

It's guaranteed to be ERP-free! For developers only!

No salesperson will call!


Friday, May 24, 2013

The fRiDaY File - Screech!

Screech! That's the sound of me hitting this sentence in the middle of an otherwise excellent article about SAP's recent Sapphire conference:


"The transport mechanism for this is a HANA cloud platform that allows the software’s data calls to go through HANA instead of a relational data base."

Whoa, hold on there sonny!

HANA is a relational database system. It has other stuff too (a graph engine and a text engine) but the big deal is its super-fast in-memory row- and column-oriented relational engine.

Maybe the author should have said "instead of a traditional relational data base" or a "disk-oriented relational data base" or a "legacy DBMS", something like that.

But no, I think the author really does think
  • that HANA is different from relational,

  • that relational implies row-oriented,

  • that column-oriented does not qualify as relational, and

  • that in-memory is somehow not relational.
If he doesn't think that, certainly lots of other people do.

Not true!

One of Codd's 12 rules for relational database management systems is this:

Rule 8: Physical data independence: Changes to the physical level (how the data is stored, whether in arrays or linked lists etc.) must not require a change to an application based on the structure.
That means it's perfectly OK, even encouraged, to have a variety of different physical architectures just as long as those architectures and the differences between them don't affect application code.

And THAT means HANA can be called a relational database even when it uses a column-oriented store, as long as Rule 8 and the others hold.

Another thing: HANA has BOTH row- and column-oriented tables. In fact, if you code CREATE TABLE in HANA you get row-based storage; to get column-based you have to ask for it by coding CREATE COLUMN TABLE.

Pedants might say having to code CREATE COLUMN TABLE violates Rule 8 because it requires a change to application code. Pedants might also say that not one single commercial product qualifies as "relational" because there are many ways physical characteristics bubble up into the code; think query hints.

In the real world pedants live at home in their parents' basement and have no effect on the fact SQL Anywhere, SQL Server etcetera are all recognized as relational...

...and HANA as well.



Wednesday, May 22, 2013

Cost-free, ERP-free Online HANA Course

If you're interested in HANA The Relational Database Management System (and maybe you should be), there's a free online course starting on May 26, 2013 (that's four days from now):


Introduction to Software Development on SAP HANA

Thomas Jung

SAP HANA is an in-memory data platform that is deployable as an appliance or in the cloud. At its core, it is an innovative in-memory relational database management system that makes full sense of the capabilities of current hardware to increase application performance, to reduce cost of ownership, and to enable new scenarios and applications that were not possible before.

With SAP HANA, you have the opportunity to build applications that integrate the business logic, control logic, and the database layer with unprecedented performance. As a developer, one of the key questions is how you can minimize data movements. The more you can do directly on the data in memory next to the CPUs, the better the application will perform.

This course will introduce you to native software development on SAP HANA. Registration, learning content, and the final exam are free of charge. However, to fully benefit from the course, you can access a fee-based system environment to develop your own code. SAP works with several cloud providers to give you a choice of infrastructure platforms and attractive pricing models to enable system access at a very low cost.

Start: May 26, 2013

Course language: English

If you think you might be interested...

. . . as a developer interested in new technologies, it might help to watch the inventor (and others) talk about it:

If you want to get ready...

. . . and take a "warm-up to the introduction" that's available, for free, right now, try this:

Warm-Up: In-Memory Data Management

Dr.-Ing. Jürgen Müller

While the first openSAP course, Introduction to Software Development on SAP HANA, is intended as an introductory class for software developers who are new to SAP HANA, it makes sense for course participants to obtain an understanding of the fundamental concepts of in-memory data management before the course starts.

If you have taken the openHPI course on the topic that was delivered by Prof. Hasso Plattner in 2012, you will be good to go. If you have not attended this course or similar training programs on in-memory data management, we recommend that you use this summary of Prof. Plattner’s lectures as a warm-up exercise. The summary was prepared by Dr.-Ing. Jürgen Müller (HPI) and is exclusively available on openSAP.

Start: Apr 28, 2013

Course language: English

...and the best part?

It's guaranteed to be ERP-free! For developers only!

No salesperson will call!


Friday, May 17, 2013

The fRiDaY File - Is it sap or is it ess-a-pee?

Question: How do I pronounce "SAP"? Is it sap or ess-a-pee?

Before you say "that's a pointless question!" consider this endless thread on the subject.

OK, it's still a pointless question


. . . but I'm asking it anyway.

Back on May 10 I thought it was important to say "ess-a-pee" but now I'm not so sure.

Why not?


Because even though the phrase "an SAP" appears 420 times in the 391-page SAP HANA Developer Guide, most (391) of those references appear in the boilerplate phrase "...an SAP affiliate company. All rights reserved...".

In the same document the phrase "a SAP" appears 25 times, as in "a SAP HANA system" and "adding a SAP Variables clause in your select statement".

That's a score of 25 for sap, versus 30 for ess-a-pee if we count the boilerplate as only one occurrence.

Pretty much a tie, doncha think?


So I'm going with this:

Answer: You pick the pronunciation that sounds right to you, given the context: sometimes sap, sometimes ess-a-pee... or you can use one or the other all the time, your choice.

It's called "English", which in German means "Anarchy".

Dilbert.com 1995-10-11

Friday, May 10, 2013

HANA Enterprise Cloud

Did you know that SAP has another database product, besides SQL Anywhere?

Yeah, you're right,

but they don't count because they don't have much of a future.

There's also Sybase IQ and that does have a future, but it's not the one I'm thinking of either.

No, the other SAP database with a future is . . .


... called HANA, brand new, just out.

And it's available for free, for testing, in the cloud.

HANA in the Cloud


Back on May 7 SAP held a "press event" in Palo Alto to introduce something called the "SAP HANA® Enterprise Cloud"; you can watch the whole thing here, all 82 minutes of it:



Caution: This video works in IE 10 but apparently not in Chrome 26. There's another browser I used to use, Fire-something-or-other, I forget, dunno if that works.

But if you'd rather READ than WATCH . . .


... here are my rough notes, with a few comments added:
=====
Jonathan Becher
Chief Marketing Officer

10,000 viewers for the initial presentation

HANA is not limited to SAP applications

pronounced "haw-na"
...not "hanna". HANA is a name, but not a girl's name; HANA doesn't stand for anything. In particular, it does not stand for High Performance ANalytic Appliance, and it most definitely does not stand for HAsso's New Architecture. While we're at it, SAP is pronounced ess-a-pee, not sap, and junior SAP employees are not called saplings.
=====
Hasso Plattner
SAP Founder and Chairman of the SAP Supervisory Board

old-school paper notes

HANA is the redefinition of enterprise software

will lower TCO dramatically

advantages of cloud

1. elasticity

2. innovation - SAP has renovated, recreated

HANA system has a much smaller data footprint - needs on one fifth of the storage capacity 
through compression

response time goals: 8 seconds, 3 seconds, 1 second

3. people - much less DBA work - no indexes, no materialized aggregates - dynamic aggregation

4. harmonization of hardware and system software - 100% standard hardware

should keep 100% of hot data in memory so performance can be calculated

cold data can certainly be kept on disk

faster releases - utilities run 20 times faster

what can we do with a "HANA-based system in the cloud"

1. regain innovation

better performance leads to innovation

120 msec for worldwide data round-trip - communication

no more "programmer test data" - can use copy of production

standard application interfaces are available for HANA

can make SMP use of a 200 core computer

after 41 years of SAP software, this is the way it should have been

=====
Vishal Sikka 
Member of the Executive Board of SAP AG, Technology & Innovation

we call it the "HANA Enterprise Cloud"

using current generation Intel processors 

300 billion scans per second

without virtualization

=====
Wesley Mukai
Vice President of HANA Cloud Computing

data centers are complicated

SAP Cloud Frame Technology

SAP Cloud Frame Monitor - Management Home - Create New HANA Instance

100s of terabytes on in-memory computing

each frame contains physical servers - no virtualization

servers from multiple vendors

=====
Vishal Sikka 

create a 5 terabyte system in minutes

we have been working on this for quite some time

60 customers, some already live

=====
Don Whittington
Florida Crystals Vice President and CIO

What if SAP ran as fast as Excel?

=====
Vishal Sikka 

multiple hardware platforms

Hasso has always been a champion of speed and performance

=====
Andy Bechtolsheim
Founder and Chairman, Arista Networks

The future of networking...

Accepted wisdom was that enterprise systems will be the last thing that moves to the cloud

low latency and high bandwidth is key for the communication network within a cluster

system management has been integrated into the switch

the cloud needs near-zero-time network configuration, not weeks like in the old days

100 Gbit networking will eventually be available.

=====
Vishal Sikka 

The HANA Enterprise Cloud is here.

There are 50,000 enterprise networks out there.

=====
Jonathan Becher 

Peaked at #3 on twitter.

Questions for Hasso and Vishal...

=====
Hasso Plattner

We must educate people in what parallelism means.

HANA can use massive parallelism for a single query.

The more complex the query the more parallelism can be used.

The larger the data volume the more we can split it up and run it in parallel.

We get the parallelism effect automatically through HANA.

Myth: "If everything runs so fast we don't have to write good SQL any more."

It is just the opposite - we have to think more about good algorithms.

There can be a factor of 10,000 between the performance of good and lousy algorithms.

HANA automatically gives a factor of 2 to three improvement over current databases - to get 
real improvements you have to exploit parallelism.

We have to teach people how to write good SQL and not just simple SQL that works.

While people are doing this, they learn more and more about how things can be done differently.

After 40 years of fighting batch, there is no batch any more.

We wanted to kill batch 40 years ago, and it came back and came back.

Now everything will be transactional.

Everything will be on a human time frame even if it involves billions of records.

What is our biggest innovation in SAP?

We now have the capacity to redo the user interface.

We used to build UIs to cover the functionality and to perform well enough - we were always 
watching performance, most of the programming we did was to achieve performance.'

Now we get great performance, the programs are much smaller - we have more time to concentrate 
on the UI.

=====
Vishal Sikka 

HANA has native integration services.

Pricing: You bring your own HANA license and pay for the cloud services separately
It was around this point when the penny finally dropped: they're not just talking about HANA-the-database-product, they're talking about an existing implementation of HANA and all the requisite bits, on existing public cloud services like Amazon, that you can just use... yeah, I'm kinda slow.
HANA One has been running in the cloud for about 7 months.

Even though HANA makes it possible to eliminate current batch processing, you will always have larger amounts of data coming that require batch processing.

=====
Hasso Plattner

Collaboration between Hadoop and HANA is possible.

=====
Vishal Sikka 

What about private clouds?

First of all - the HANA Enterprise Cloud is for HANA only, other relational database products 
are not welcome.

Having said that - it doesn't matter where the pieces run, and the landscape can be heterogeneous.

HANA cloud frames can, and have been, run on private clouds in customer datacenters - but it's 
not part of today's announcement.

Several dozen big customers will move to the HANA cloud this year.

Early customer feedback has been positive.

=====
Hasso Plattner

This is the next hockey stick.
I'm guessing he's talking about the "hockey stick curve"; see point 3 in "What is a Hockey Stick Curve?"
Mobile response time must be 3 seconds or faster, and we can do this now.

There are no hassles when growing or shrinking the system, and it will be so much faster.

Hardware provisioning is done already, by SAP.

What is the bottleneck? We honestly don't know.

The private private clouds will come - the ones on client premises.

The elasticity and security problems have been solved.

=====
Vishal Sikka 

We are looking at redesigning the server platform.

=====
Hasso Plattner

The data has to be in memory, that is a prerequisite.

=====
Vishal Sikka 

The underlying infractructure for all SAP applications is moving to the HANA Enterprise Cloud.

=====
Hasso Plattner

Enterprise, mid-size, small companies... it doesn't matter. We allocate a whole client to one 
machine, or half a machine, or a quarter machine.

We don't share anything in data storage between customers.

=====
Vishal Sikka 

If a third-party SAP vendor wanted to use the HANA infracture, would we let them do that? 
Yes, we would absolutely love it. If they compete with us we would love it even more.

We currently have more than 400 startup companies running on HANA. Many of them compete 
with parts of the SAP portfolio.

Companies like salesforce.com would definitely benefit from running on the HANA infrastructure.

Our own CRM system has been running since the middle of March, extraordinarily well. 

We have it running on a 6 terabyte monster system from IBM - we are only using 1.25 terabytes - 

=====
Hasso Plattner

The usage of the system went significantly up - the users are doing more with the system - that 
is a positive sign.

=====
Vishal Sikka 

We have run 100 million SQL queries per hour on our own system.

The communication round-trip between Palo Alto and Beijing or between Palo Alto and Amsterdam 
is around 120 milliseconds today.

That means you still have 880 milliseconds still available to you, for 1 second response time.

=====
Hasso Plattner

With traditional on-premise provisioning, just the hardware acquisition delays every single 
project by eight weeks.

Now we can provision a system within one hour... that's a hockey stick.

=====
Jonathan Becher, Chief Marketing Officer

Today we launched HANA Enterprise Cloud which combines real-time in-memory with the cloud.

No more batch.

[end]

For the official story see the SAP HANA Enterprise Cloud page.