SAP DB

(1)

EUROPEAN

SAP TECHNICAL

EDUCATION

CONFERENCE 2002

Sept. 30 – Oct. 2, 02 Bremen, Germany

IT Landscape

Management

Lecture

-The Enterprise

(2)

Learning Objectives

As a result of this presentation, you will

be able to:

understand SAP’s positioning of SAP DB

understand that SAP DB is an enterprise DBMS

know more about SAP DB’s technology

(3)

SAP DB Agenda

Positioning & history

Philosophy & technology

Interfaces & tools

(4)

DBMS are a Commodity !?

Feature-wise:

yes

(5)

DBMS Market

The DBMS market is currently dominated by three players

Oracle

IBM

Microsoft

DBMS technology has reached a saturation level

The feature war is over

(6)

DBMS Market Transition

Product

features

Consumer-driven

marketplace

• Low profit margins

• Average growth

• High volume

Level of

features

required by

average

customers

Transition point

where technology

delivers basic needs

Technology is “good enough” and

therefore irrelevant.

Customers look for convenience,

quality, satisfaction, cost,

reliability, prestige

Unfilled need

Source: D. A. Norman, The Invisible Computer,

MIT Press

Excess quality

Most customers

uninterested in this

region

Time

Technology-driven

marketplace

• High profit margins

• High growth

• Low volume

(7)

SAP’s Motivation to Open Source SAP DB

Energize competition in the DBMS market

Establish SAP DB in the DBMS market

End the over-prized phase of the DBMS market

Define new rules for the DBMS market

Create a community of SAP DB users beyond SAP’s customers

(8)

SAP DB Compared to Other Open Source DBMS

mySQL and PostgreSQL

Simply do not play in the same league

Are not able to run SAP applications

Lack concepts like views or transaction handling (mySQL)

Lack OLTP performance for high volume workloads (mySQL, PostgreSQL)

(9)

SAP’s Commitment to SAP DB

SAP DB is SAP’s strategic DBMS offering

Part of SAP’s technology stack

Runs all SAP applications

Means one-stop shopping for our customers

SAP DB’s feature set and performance level is comparable to our

competitors

SAP DB has been designed for easy and simple administration and

provides very low total costs of ownership

SAP heavily invests into the ongoing development of SAP DB

(10)

SAP DB‘s Support Model

3rd Party

DBMS

S A P D B

SAP

Solution

Maintenance

Free

Online

Support

SAP DB

Premium

Support

SAP Solution

3rd

Party

Solution

(11)

www.sapdb.org

Are you STILL paying database license fees ?

(12)

Where SAP DB Comes from—A Short History

1977-1981: Research project at Technical University of Berlin

1981-1989: SQL DBMS “DDB/4” of Nixdorf Computer AG

1989-1993: DDB/4 owned by Siemens-Nixdorf Informationssysteme AG

Licensed by Software AG (“ADABAS D”)

1993-1997: Development team part of Software AG

SAP R/3 available on ADABAS D

1997: Development team part of SAP AG

New product name SAP DB

1997- today: Substantial investments of SAP into SAP DB

SAP DB is available for all mySAP.com components

Object Management System (OMS) added to SAP DB

SAP DB becomes part of SAP’s APO product (

live

Cache)

Increasing use of SAP DB inside SAP’s IT systems

(13)

SAP DB Customers (1)

R/3

Vaillant GmbH, Germany, 650 GB, 1800 user, R/3, HP-UX/64

Intersnack, Germany, 400 GB, 300 user, R/3, Windows

**Deutsche Post, Germany, 120 systems (40P), e.g. 8*120 GB,**

Windows, 8 CPU

TDS, Germany, 80 systems, application service provider

Thyssen TKIS, Germany, 80 systems

Toyota, South Africa

Tenaga, Malaysia

APEX Corp. , Japan

Yamaha, Japan

(14)

SAP DB Customers (2)

APO /

live

Cache

Colgate, USA

Intel, USA

Bayer, Germany

Braun, Germany

Bertelsmann, Germany and USA

Toyota, South Africa

Becton & Dickinson, USA

Nestec, Switzerland

Eastman Chemical, USA

Daimler Chrysler, Germany

Bridgestone, Belgium

(15)

SAP DB Agenda

Positioning & history

Philosophy & technology

Interfaces & tools

(16)

SAP DB Platforms

IBM AIX

Sun Solaris

HP-UX

HP Tru64

Linux

Windows NT, 2000, XP

(17)

Present and Future DBMS Requirements

1) Performance

2) Availability

3) Ease of use

Our vision:

Zero administration DBMS

Invisible DBMS

Your benefit:

Lowest cost of ownership

Simplicity

(18)

Design Rationale of SAP DB

Do things right

No non-sense

Fight complexity

(19)

Example: CREATE TABLE

PCTFREE ...

PCTUSED ...

INITTRANS ...

MAXTRANS ...

TABLESPACE ...

STORAGE (INITIAL ... NEXT ...

MINEXTENTS ... MAXEXTENTS ... PCTINCREASE ...)

CLUSTER ...

ENABLE/DISABLE

CREATE TABLE <table name> ( <table definition> )

(20)

Our Vision

Other

DBMS

(21)

Anatomy of a SAP DB Instance

Log

Volume

Data

Volume

Data

Volume

Data

Volume

SAP DB

Kernel

Log

Volume

Data

Volume

Application

SAP DB Instance

(22)

Simplicity of SAP DB

Few configuration parameters

No size estimates for individual database objects

Automatic space allocation and de-allocation

Automatic balancing of disk I/O

No permanent attention required

(23)

High Availability of SAP DB

No reorganization

Online backup of database and log

Online extension of database and log

Online change of configuration parameters

Parallel backup and restore

Support of cluster configurations (failover)

Support of hot-stand-by configurations (failover)

(24)

Cluster Configuration

liv e

C a c h e

liv e

C a c h e

liv e

C a c h e

liv e

C a c h e

AUTO RESTART

Primary

RECONNECT

Backup

Application

IP SWITCH

Cluster

Log

Data

(25)

Hot-stand-by Configuration

Cluster

Log

Data

liv e

C a c h e

liv e

C a c h e

liv e

C a c h e

liv e

C a c h e

Data

After

Images

Primary

Backup

continous

RESTART

IP SWITCH

RECONNECT

Application

(26)

SAP DB Performance

Multi-process / multi-threaded server

SMP scalability

Minimal I/Os

Parallel CREATE INDEX

SAP application-specific tuning

(27)

Server Roundtrip Optimizations

Stored Procedures

Triggers

Array commands for

INSERT

UPDATE

DELETE

SELECT

FETCH

(28)

SAP DB Features

Full SQL functionality (SQL-92 entry level plus many extensions)

Unicode support

Rich set of data types:

CHAR

LONG

NUMBER

DATE, TIME, TIMESTAMP

BOOLEAN

OO-DBMS (

live

Cache)

(29)

Document Repository and XML Indexing

WebDAV server

Document repository with files and folders

Accessible via HTTP (web folders)

Checkout / checkin support

The Internet file system

Indexing of XML data

XML data are stored as LOB

XML indexes are defined by XPath expressions

Synchronous or asynchronous index maintenance

XML indexes are implemented by SQL tables

Retrieval support for pre-defined XML indexes

(30)

SAP DB Agenda

History & position

Philosophy & technology

Interfaces & tools

(31)

SAP DB Interfaces & Tools

SAP DB Kernel

Database Manager

DBMGUI

(Windows)

Web DBM

DBMCLI

DBAnalyzer

SQL Studio

(Windows

)

Web SQL

Loader

• Installation

• Configuration

• Monitoring

• Backup/Restore

• AutoSave

C/C++ precompiler

ODBC 3.5

JDBC 3.0

Perl

Python

PHP

SQLCLI

(32)

(33)

(34)

(35)

(36)

(37)

(38)

(39)

(40)

(41)

(42)

(43)

(44)

SAP DB Loader

DATALOAD/EXTRACT

External format,

Record-oriented

FASTLOAD

External format

Page-oriented

TABLELOAD/EXTRACT

Internal format

Page- or record-oriented

CATALOGLOAD/EXTRACT

DDL or XML

DB Migration

Scripting interface

SAP DB

File System

(45)

(46)

(47)

(48)

(49)

DBAnalyzer

Rule-based expert system to watch SAP DB instances

Collects statistical and monitoring data

Collects system messages

Supports remote access

Covers SAP DB as well as

live

Cache instances

Detects and reports

Low cache hit rates

High I/O load

Low hit rates of DML commands (Select, Update, Delete)

Log queue overflows

User lock collisions

Command timings

(50)

(51)

(52)

Summary

SAP DB

The Enterprise Open Source DBMS

Te

st

(53)

Further Information

Public Web:

www.sapdb.org

SAPNet:

Use ALIAS: ‚sapdb‘

Related Workshop at TechEd 2002

SAP DB – Administration made easy, Time,

Room

Related Lectures at TechEd 2002

liveCache – The Engine for SAP APO, Time,

Room

(54)

Feedback

http://www.sap.com/teched/bremen/

(55)

(56)

(57)

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express

permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other

software vendors.

Microsoft®, WINDOWS®, NT®, EXCEL®, Word®, PowerPoint® and SQL Server® are registered trademarks of

Microsoft Corporation.

IBM®, DB2®, DB2 Universal Database, OS/2®, Parallel Sysplex®, MVS/ESA, AIX®, S/390®, AS/400®, OS/390®,

OS/400®, iSeries, pSeries, xSeries, zSeries, z/OS, AFP, Intelligent Miner, WebSphere®, Netfinity®, Tivoli®, Informix

and Informix® Dynamic ServerTM are trademarks of IBM Corporation in USA and/or other countries.

ORACLE® is a registered trademark of ORACLE Corporation.

UNIX®, X/Open®, OSF/1®, and Motif® are registered trademarks of the Open Group.

Citrix®, the Citrix logo, ICA®, Program Neighborhood®, MetaFrame®, WinFrame®, VideoFrame®, MultiWin® and

other Citrix product names referenced herein are trademarks of Citrix Systems, Inc.

HTML, DHTML, XML, XHTML are trademarks or registered trademarks of W3C®, World Wide Web Consortium,

Massachusetts Institute of Technology.

JAVA® is a registered trademark of Sun Microsystems, Inc.

JAVASCRIPT® is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and

implemented by Netscape.

MarketSet and Enterprise Buyer are jointly owned trademarks of SAP Markets and Commerce One.

SAP, SAP Logo, R/2, R/3, mySAP, mySAP.com and other SAP products and services mentioned herein as well as

their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries