In-Memory Data Management In a Nutshell

Brought by: openSAP

Overview

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.

Taught by

Dr. Ing. Jürgen Müller

Computer Science / Computer Science

Go to course

In-Memory Data Management In a Nutshell

Brought by: openSAP

openSAP
Free
English
Certificate Not Available
Available at any time
All
N/A

Messages Timeline Exceptions Views14 Route Queries6 Models5 Gate Session Request

8.1.2911ms2MBGET en/courses/{slug}

Booting (589ms)
Application (319ms)
1 x Booting (64.65%)
589.03ms
1 x Application (35.05%)
319.29ms

14 templates were rendered

public.courses.show (resources/views/public/courses/show.blade.php)3bladefile
Params
0
course
1
links
2
config
public.courses.partials.breadcrumbs (resources/views/public/courses/partials/breadcrumbs.blade.php)6bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
public.courses.partials.heading (resources/views/public/courses/partials/heading.blade.php)7bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
6
classes
public.courses.partials.details (resources/views/public/courses/partials/details.blade.php)6bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
public.courses.partials.breadcrumbs (resources/views/public/courses/partials/breadcrumbs.blade.php)6bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
public.courses.partials.heading (resources/views/public/courses/partials/heading.blade.php)7bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
6
classes
public.layouts.main (resources/views/public/layouts/main.blade.php)6bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
public.layouts.partials.meta (resources/views/public/layouts/partials/meta.blade.php)6bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
public.layouts.partials.navbar (resources/views/public/layouts/partials/navbar.blade.php)6bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
public.auth.profile.partials.links (resources/views/public/auth/profile/partials/links.blade.php)6bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
6
route
7
title
public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
6
route
7
title
public.auth.profile.partials.link (resources/views/public/auth/profile/partials/link.blade.php)8bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config
6
route
7
title
public.layouts.partials.flash-session (resources/views/public/layouts/partials/flash-session.blade.php)6bladefile
Params
0
__env
1
app
2
errors
3
course
4
links
5
config

Params
0	`course`
1	`links`
2	`config`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`
6	`classes`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`
6	`classes`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`
6	`route`
7	`title`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`
6	`route`
7	`title`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`
6	`route`
7	`title`

Params
0	`__env`
1	`app`
2	`errors`
3	`course`
4	`links`
5	`config`

uri: GET en/courses/{slug}
middleware: web, localize:en
controller: App\Http\Controllers\CourseController@show
as: en.courses.show
namespace
prefix: /en
where
file: app/Http/Controllers/CourseController.php:17-35

6 statements were executed11ms

select * from `courses` where `slug_en` = 'in-memory-data-management-in-a-nutshell' limit 1

9.46ms/app/Http/Controllers/CourseController.php:20corspedia

Metadata
Bindings	0. in-memory-data-management-in-a-nutshell
Backtrace	17. /app/Http/Controllers/CourseController.php:20 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

update `courses` set `visitors` = `visitors` + 1, `courses`.`updated_at` = '2025-06-17 08:46:48' where `id` = 1709

680μs/app/Http/Controllers/CourseController.php:21corspedia

Metadata
Bindings	0. 2025-06-17 08:46:48 1. 1709
Backtrace	17. /app/Http/Controllers/CourseController.php:21 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `name_en`, `name_ar`, `topic_id`, `slug_en`, `slug_ar` from `subjects` where `subjects`.`id` in (1)

210μs/app/Http/Controllers/CourseController.php:23corspedia

Metadata
Backtrace	20. /app/Http/Controllers/CourseController.php:23 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select `id`, `name_en`, `name_ar`, `slug_en`, `slug_ar` from `topics` where `topics`.`id` in (1)

190μs/app/Http/Controllers/CourseController.php:23corspedia

Metadata
Backtrace	25. /app/Http/Controllers/CourseController.php:23 26. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `providers` where `providers`.`id` in (22) and `providers`.`deleted_at` is null

210μs/app/Http/Controllers/CourseController.php:23corspedia

Metadata
Backtrace	20. /app/Http/Controllers/CourseController.php:23 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `html_files` where `html_files`.`id` = 1700 limit 1

250μs/app/Models/Course.php:84corspedia

Metadata
Bindings	0. 1700
Backtrace	21. /app/Models/Course.php:84 28. view::public.courses.show:29 30. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125 31. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 32. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72

App\Models\HtmlFile: 1
App\Models\Provider: 1
App\Models\Topic: 1
App\Models\Subject: 1
App\Models\Course: 1

_token: Zgs83yp1lBAzt6rn1Wb1gpaLdEljFOfsEhDTFZNM
locale: en
_previous: array:1 [ "url" => "https://www.corspedia.com/en/courses/in-memory-data-management-in-a-nutshell" ...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/courses/in-memory-data-management-in-a-nutshell

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:24 [▼
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "216.73.216.170"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "216.73.216.170"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "cf-ray" => array:1 [▶
    0 => "95114748ce6e7619-ORD"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "host" => array:1 [▶
    0 => "www.corspedia.com"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:50 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_CF_CONNECTING_IP" => "216.73.216.170"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "216.73.216.170"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_CF_RAY" => "95114748ce6e7619-ORD"
  "HTTP_ACCEPT_ENCODING" => "gzip, br"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "HTTP_HOST" => "www.corspedia.com"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "corspedia.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "141.95.147.152"
  "REMOTE_USER" => ""
  "REMOTE_PORT" => "57502"
  "REMOTE_ADDR" => "172.70.178.218"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/2.0"
  "DOCUMENT_ROOT" => "/var/www/corspedia/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/en/courses/in-memory-data-management-in-a-nutshell"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "SCRIPT_FILENAME" => "/var/www/corspedia/public/index.php"
  "PATH_INFO" => ""
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1750150007.4366
  "REQUEST_TIME" => 1750150007
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Tue, 17 Jun 2025 08:46:48 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkhSVGp5N1FOb2J0a3A5NzBOc2EyWHc9PSIsInZhbHVlIjoicE9ON21GSnNEMVBsNWQrcGNLbmlrSkgwR2N0RjZCUmw4UXdaY1A2UTNlTno2WVpDcmVBd3ZvaStydnhpRlhnQlhsdTVXOEdEN3IwYWVZSHVEWks0MlhRQXhrbGFrcVJ4UzhvVUdwRFljdWhpdHJ0QysycnAvZXBlYXNvcVJ0RnkiLCJtYWMiOiJkYzVmMWY0YmY0NmUwMTU4MjE1MTVkZDM3NjlhODY2MDQxYTJiOWQ0NTkyZTBiMGJmMDEyNTA0NzVhN2M1NjY1IiwidGFnIjoiIn0%3D; expires=Tue, 17 Jun 2025 10:46:48 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkhSVGp5N1FOb2J0a3A5NzBOc2EyWHc9PSIsInZhbHVlIjoicE9ON21GSnNEMVBsNWQrcGNLbmlrSkgwR2N0RjZCUmw4UXdaY1A2UTNlTno2WVpDcmVBd3ZvaStydnhpRlhnQlhsdTVXO ▶"
    1 => "laravel_session=eyJpdiI6IlFoSGxZdHg1YlpJK2d4OEtkOVY1eGc9PSIsInZhbHVlIjoiL2UvVUxiaVlxMEJJK3RTaCtPSk5KMFFCZ2NlS0p1aHVRMk5lRHJia3lva3JNYW50UnUwNTh5NE91akRRc2pvNW5WYitUNTh3bldBb2RmaXhpcm5KTm1YSEdiZXNubDlRdnZHY2tJc3Fxd3RPRVdCWXpKNDQ0elNWS05tK0JQSTIiLCJtYWMiOiIzZDY3MWRlODA2MzQ5N2FjNTVjZTBkN2Y3Y2U3Yzk3ZmVhZDk0MzJlZjI3ZTBlODRkYTc3OGNlODA2ZmNjNWI2IiwidGFnIjoiIn0%3D; expires=Tue, 17 Jun 2025 10:46:48 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6IlFoSGxZdHg1YlpJK2d4OEtkOVY1eGc9PSIsInZhbHVlIjoiL2UvVUxiaVlxMEJJK3RTaCtPSk5KMFFCZ2NlS0p1aHVRMk5lRHJia3lva3JNYW50UnUwNTh5NE91akRRc2pvNW5W ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkhSVGp5N1FOb2J0a3A5NzBOc2EyWHc9PSIsInZhbHVlIjoicE9ON21GSnNEMVBsNWQrcGNLbmlrSkgwR2N0RjZCUmw4UXdaY1A2UTNlTno2WVpDcmVBd3ZvaStydnhpRlhnQlhsdTVXOEdEN3IwYWVZSHVEWks0MlhRQXhrbGFrcVJ4UzhvVUdwRFljdWhpdHJ0QysycnAvZXBlYXNvcVJ0RnkiLCJtYWMiOiJkYzVmMWY0YmY0NmUwMTU4MjE1MTVkZDM3NjlhODY2MDQxYTJiOWQ0NTkyZTBiMGJmMDEyNTA0NzVhN2M1NjY1IiwidGFnIjoiIn0%3D; expires=Tue, 17-Jun-2025 10:46:48 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkhSVGp5N1FOb2J0a3A5NzBOc2EyWHc9PSIsInZhbHVlIjoicE9ON21GSnNEMVBsNWQrcGNLbmlrSkgwR2N0RjZCUmw4UXdaY1A2UTNlTno2WVpDcmVBd3ZvaStydnhpRlhnQlhsdTVXO ▶"
    1 => "laravel_session=eyJpdiI6IlFoSGxZdHg1YlpJK2d4OEtkOVY1eGc9PSIsInZhbHVlIjoiL2UvVUxiaVlxMEJJK3RTaCtPSk5KMFFCZ2NlS0p1aHVRMk5lRHJia3lva3JNYW50UnUwNTh5NE91akRRc2pvNW5WYitUNTh3bldBb2RmaXhpcm5KTm1YSEdiZXNubDlRdnZHY2tJc3Fxd3RPRVdCWXpKNDQ0elNWS05tK0JQSTIiLCJtYWMiOiIzZDY3MWRlODA2MzQ5N2FjNTVjZTBkN2Y3Y2U3Yzk3ZmVhZDk0MzJlZjI3ZTBlODRkYTc3OGNlODA2ZmNjNWI2IiwidGFnIjoiIn0%3D; expires=Tue, 17-Jun-2025 10:46:48 GMT; path=/; httponly ◀laravel_session=eyJpdiI6IlFoSGxZdHg1YlpJK2d4OEtkOVY1eGc9PSIsInZhbHVlIjoiL2UvVUxiaVlxMEJJK3RTaCtPSk5KMFFCZ2NlS0p1aHVRMk5lRHJia3lva3JNYW50UnUwNTh5NE91akRRc2pvNW5W ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▼
  "_token" => "Zgs83yp1lBAzt6rn1Wb1gpaLdEljFOfsEhDTFZNM"
  "locale" => "en"
  "_previous" => array:1 [▶
    "url" => "https://www.corspedia.com/en/courses/in-memory-data-management-in-a-nutshell"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Booting (64.65%)	589.03ms
1 x Application (35.05%)	319.29ms