Basic Information
Concepts of the Database System
Software Information
SAP DB and MaxDB
Documentation
Demo Database
Objects in the Schema HOTEL
Download
Version Notation
Supported Operating Systems and Architectures
Open Source Development of the Database Software
Support
Tracking Problem Messages with Web PTS
Overview of the Database System
SQL
Transactions
Logging Data Changes
History Management
Example: Restart
Example: Consistent View
Locks for Database Objects
Shared Lock
Exclusive Lock
Optimistic Lock
Phenomena
Parallel Locks
Isolation Level
Data Storage
Working Memory Areas
Volumes (Permanent Storage)
Savepoint
Logical Access Structures
B* Trees for Tables with LONG Columns
B* Trees for Tables with Indexes
Rebalancing
Example: SELECT Statement
Example: INSERT Statement
Example: DELETE Statement
Example: UPDATE Statement
Converter
Database Tools
Interfaces
Technical System Landscape
Network Communication
Architecture of the Database Tools
Architecture of the Interfaces
Data Encryption
Example: System Landscape with MaxDB Database Instance
Example: SAP System Landscape with Two MaxDB Database Instances
Process Structure
Overview of Processes
Overview of Services
Overview of Tasks
Overview of the Task States
Task Switching
Load Balancing
Overview of Special Threads
Creating and Configuring a Database Instance
Planning the Database Instance
Technical Restrictions
Template for Database Instances
Conventions for Database Names
Database Parameters
General Database Parameters
Special Database Parameters
Support Database Parameters
liveCache Database Parameters
Properties of Database Parameters
Automatic Start
Example: Start Script for a Database Instance (Linux)
Log Settings
Configuration Files
Database Design
Database Design Tips
Administration
Regular Administration Tasks
Automating Administration Tasks
Overview of Database Event Categories
Users, Authentication and Authorizations
Database System Administrator (SYSDBA User)
Database Manager Operator (DBM Operator)
Database User
Server Authorizations for the DBM Server
Conventions for User Names and Passwords
Authentication
Special Operating System Users and Groups (UNIX/Linux)
<sdb_user> (Special Operating System User)
<sdba_group> (Special Operating System Group)
Support Group (Special Operating System Group)
Backing Up and Restoring
Backup Templates and Data Carriers
Notes on the Different Types of Data Carriers
Backing Up Data
Backing Up Log Entries
Archiving Backup Files
Restoring the Database Instance
Example: Backing Up and Restoring
Backing Up and Restoring Data with Remote Computers
Using Backup Tools from Other Providers
Freezing the Data Area (Snapshot)
Exporting and Importing
Replication and High Availability
Database Copy
Compatible Processor Architectures for Database Copies
Standby Database
Setting Up a Standby Instance
Updating the Standby Instance
Starting the Standby Instance as an Active Instance
Hot Standby
System Requirements for a Hot Standby System
Architecture of a Hot Standby System
Synchronizing Master and Standby Instances
Behavior of the Hot Standby System when Errors Occur
Synchronization
Monitoring
Performance
Analyzing Performance Bottlenecks
Automatic Transformation of SQL Statements
SQL Optimizer
How the SQL Optimizer Operates
Search Conditions
Equality Condition
Range Condition
IN Condition
LIKE Condition
Restrictions for UPDATE Statements
Cost Determination
SQL Optimizer Statistics
Search Strategies
Sequential Search
Search Conditions for Key Columns
Search Conditions for Indexed Columns
Search Conditions Linked with OR
Postponement of the Search to the FETCH Time
Joins
JOIN_SEARCH_LEVEL Database Parameter
List of All Search Strategies
CATALOG KEY ACCESS
CATALOG SCAN
CATALOG SCAN USING USER EQUAL CONDITION
DIFFERENT STRATEGIES FOR OR TERMS
EQUAL CONDITION FOR INDEX
EQUAL CONDITION FOR KEY
IN CONDITION FOR INDEX
IN CONDITION FOR KEY
INDEX SCAN
JOIN VIA INDEXED COLUMN
JOIN VIA KEY COLUMN
JOIN VIA KEY RANGE
JOIN VIA MULTIPLE INDEXED COLUMNS
JOIN VIA MULTIPLE°KEY°COLUMNS
JOIN VIA RANGE OF MULTIPLE INDEXED COL.
JOIN VIA RANGE OF MULTIPLE KEY COLUMNS
NO RESULT SET POSSIBLE
NO STRATEGY NOW (ONLY AT EXECUTION TIME)
RANGE CONDITION FOR INDEX
RANGE CONDITION FOR KEY
SUBQ CONDITION FOR INDEX
SUBQ CONDITION FOR KEY
TABLE SCAN
Troubleshooting
EXPLAIN Statement
EXPLAIN Statement for Joins
EXPLAIN Statement for Complicated SELECT Statements
EXPLAIN Statement for SELECT Statements with Subqueries
STRATEGY Column
Troubleshooting
Typical Error Situations
Log Files
Traces
Checking Database Structures
Fixing Errors in the Data Structure
Example: Error in the Data Structure
Developing Database Applications
Glossary
A
Administration
After Image
Application Data
Architecture
ASCII
Authentication
Authorization
AUTOCOMMIT Mode
Automatic Log Backup
Automatic Start
Automation
B
B* Tree
Backint for MaxDB
Backup
Backup File
Backup History
Backup ID
Backup Medium
Backup Template
Backup Tool
Backup Type
Before Image
BLOB
C
Cache
Catalog Cache
Checkpoint
CLOB
Code Attribute
Column
Command Mode
Command Monitor
COMMIT
Communication Server
Complete Data Backup
Component Group
Configuration
Configuration Directory
Configuration File
Consistent View
Constraint
Control Structure
Converter
Costs
Critical Section
Cursor
D
Data Access
Data Area
Data Backup
Data Cache
Data Carrier
Data integrity
Data Record
Data Type
Data Volume
Data Writer
Database
Database Administrator (DBA User)
Database Analyzer
Database Application
Database Catalog
Database Connection
Database Copy
Database Design
Database File
Database Function
Database ID
Database Instance
Database Manager
Database Manager Operator (DBM Operator)
Database Name
Database Object
Database Parameters
Database Procedure
Database Session
Database Structure
Database System
Database System Administrator (SYSDBA User)
Database Tool
Database Trace
Database User
DBA
DBA Planning Calendar
DBADMIN
DBM Command
DBM Operator
DBM Operator Properties
DBM Option
DBM Server
DBMCLI
DBMGUI
DDL Statement
Default Parameter File
Demo Database
Development
Directory Structure
Documentation