SAP Library - Concepts of the Database System

Start Level 1 Node: Concepts of the Database System

Concepts of the Database System

End Level 1 Node: Concepts of the Database System

Start Level 2 Node: What Is an SAP MaxDB Database?

What Is an SAP MaxDB Database?

End Level 2 Node: What Is an SAP MaxDB Database?

Start Level 3 Node: SAP liveCache Technology

SAP liveCache Technology

End Level 3 Node: SAP liveCache Technology

Start Level 3 Node: Demo Database

End Level 3 Node: Demo Database

Start Level 4 Node: Objects in the HOTEL Schema

Objects in the HOTEL Schema

End Level 4 Node: Objects in the HOTEL Schema

Start Level 2 Node: Database Tools

End Level 2 Node: Database Tools

Start Level 2 Node: Interfaces

End Level 2 Node: Interfaces

Start Level 2 Node: Technical System Landscape

Technical System Landscape

End Level 2 Node: Technical System Landscape

Start Level 3 Node: Network Communication

Network Communication

End Level 3 Node: Network Communication

Start Level 3 Node: Architecture of the Database Tools

Architecture of the Database Tools

End Level 3 Node: Architecture of the Database Tools

Start Level 3 Node: Architecture of the Interfaces

Architecture of the Interfaces

End Level 3 Node: Architecture of the Interfaces

Start Level 2 Node: Data Definition, Query, and Manipulation

Data Definition, Query, and Manipulation

End Level 2 Node: Data Definition, Query, and Manipulation

Start Level 3 Node: SQL

End Level 3 Node: SQL

Start Level 3 Node: Transactions

End Level 3 Node: Transactions

Start Level 3 Node: Locks

End Level 3 Node: Locks

Start Level 4 Node: Isolation Level

Isolation Level

End Level 4 Node: Isolation Level

Start Level 2 Node: How Databases Log Data Changes

How Databases Log Data Changes

End Level 2 Node: How Databases Log Data Changes

Start Level 3 Node: Example: Restart

Example: Restart

End Level 3 Node: Example: Restart

Start Level 3 Node: Example: Consistent View

Example: Consistent View

End Level 3 Node: Example: Consistent View

Start Level 2 Node: How Databases Store Data and Log Entries

How Databases Store Data and Log Entries

End Level 2 Node: How Databases Store Data and Log Entries

Start Level 3 Node: Working Memory Areas

Working Memory Areas

End Level 3 Node: Working Memory Areas

Start Level 3 Node: Volumes (Permanent Storage)

Volumes (Permanent Storage)

End Level 3 Node: Volumes (Permanent Storage)

Start Level 3 Node: Data Area

End Level 3 Node: Data Area

Start Level 3 Node: Log Area

End Level 3 Node: Log Area

Start Level 3 Node: Savepoint

End Level 3 Node: Savepoint

Start Level 3 Node: Logical Access Structures

Logical Access Structures

End Level 3 Node: Logical Access Structures

Start Level 4 Node: B* Trees for Tables with LOB Columns

B* Trees for Tables with LOB Columns

End Level 4 Node: B* Trees for Tables with LOB Columns

Start Level 4 Node: B* Trees for Tables with Indexes

B* Trees for Tables with Indexes

End Level 4 Node: B* Trees for Tables with Indexes

Start Level 4 Node: Rebalancing

End Level 4 Node: Rebalancing

Start Level 4 Node: Example: SELECT Statement

Example: SELECT Statement

End Level 4 Node: Example: SELECT Statement

Start Level 4 Node: Example: INSERT Statement

Example: INSERT Statement

End Level 4 Node: Example: INSERT Statement

Start Level 4 Node: Example: DELETE Statement

Example: DELETE Statement

End Level 4 Node: Example: DELETE Statement

Start Level 4 Node: Example: UPDATE Statement

Example: UPDATE Statement

End Level 4 Node: Example: UPDATE Statement

Start Level 3 Node: Converter

End Level 3 Node: Converter

Start Level 3 Node: Repositories

End Level 3 Node: Repositories

Start Level 2 Node: Operating System Functions and Resources Used by Databases

Operating System Functions and Resources Used by Databases

End Level 2 Node: Operating System Functions and Resources Used by Databases

Start Level 3 Node: Services

End Level 3 Node: Services

Start Level 3 Node: Processes

End Level 3 Node: Processes

Start Level 3 Node: Threads

End Level 3 Node: Threads

Start Level 4 Node: Load Balancing Between User Kernel Threads

Load Balancing Between User Kernel Threads

End Level 4 Node: Load Balancing Between User Kernel Threads

Start Level 3 Node: Tasks

End Level 3 Node: Tasks

Start Level 4 Node: Task Switching

End Level 4 Node: Task Switching