{"id":48247,"date":"2018-02-13T09:41:38","date_gmt":"2018-02-13T04:11:38","guid":{"rendered":"http:\/\/blog.odango.com\/?p=48247"},"modified":"2023-02-03T14:05:43","modified_gmt":"2023-02-03T08:35:43","slug":"sap-hana-architecture","status":"publish","type":"post","link":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/","title":{"rendered":"SAP HANA Architecture"},"content":{"rendered":"\n[et_pb_section bb_built=”1″ next_background_color=”#000000″][et_pb_row][et_pb_column type=”4_4″][et_pb_post_title _builder_version=”3.0.106″ title=”on” meta=”off” author=”on” date=”on” categories=”on” comments=”on” featured_image=”off” featured_placement=”below” text_color=”dark” text_background=”off” title_font=”Titillium Web||||||||” title_font_size=”47″ title_font_size_tablet=”40″ title_font_size_phone=”35″ title_font_size_last_edited=”on|desktop” title_text_color=”rgba(0,0,0,0.8)” title_text_align=”left” text_shadow_horizontal_length=”0.08em” text_shadow_vertical_length=”0.08em” text_shadow_blur_strength=”0.08em” title_text_shadow_horizontal_length=”0.08em” title_text_shadow_vertical_length=”0.08em” custom_margin=”|||10%” \/][\/et_pb_column][\/et_pb_row][et_pb_row][et_pb_column type=”4_4″][et_pb_text _builder_version=”3.12.2″ text_font=”Titillium Web|300|||||||” text_font_size=”20″ text_font_size_last_edited=”on|desktop” text_text_color=”rgba(0,0,0,0.8)” text_line_height=”1.6em” max_width=”800px” custom_margin=”|||10%” text_line_height_last_edited=”off|phone” max_width_last_edited=”off|phone” custom_margin_last_edited=”off|desktop”]\r\n\r\n

\r\nWhat is SAP HANA\u00a0Architecture?<\/strong><\/p>\r\n

Various aspects are relevant to the SAP HANA Architecture.<\/p>\r\n

This platform comprises of several components.<\/p>\r\n

The key distinctions between HANA and the previous generation of SAP systems, are that it is a column-oriented, in-memory database that combines OLAP and OLTP operations into a single system. Thus, in general, SAP HANA<\/a> is an OLTAP system.<\/p>\r\n

Storing data in main memory rather than on disk provides faster data accessing and by extension faster querying and processing.<\/p>\r\n

While storing data in-memory confers performance advantages, it is a more costly form of data storage.<\/p>\r\n

Observing data access patterns up to 85% of the data in an enterprise system may be infrequently accessed, therefore, it can be cost-effective to store frequently accessed, data in-memory while the less frequently accessed data is stored on disk, an approach SAP is termed “Dynamic tiering<\/a>“.<\/p>\r\n\r\n[\/et_pb_text][et_pb_image _builder_version=”3.17.6″ src=”https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-129.png” align=”center” \/][et_pb_text _builder_version=”3.12.2″ text_font=”Titillium Web|300|||||||” text_font_size=”20″ text_font_size_last_edited=”on|desktop” text_text_color=”rgba(0,0,0,0.8)” text_line_height=”1.6em” max_width=”800px” custom_margin=”|||10%” text_line_height_last_edited=”off|phone” max_width_last_edited=”off|phone” custom_margin_last_edited=”off|desktop”]\r\n\r\n

\r\nColumn-oriented systems store all the data for a single column in the same location, rather than storing all the data for a single row in the same location (row-oriented systems).<\/p>\r\n

This enables performance improvements for OLAP queries on the large data sets and allows the greater vertical compression of similar types of data in a single column.<\/p>\r\n

If the read time\u00a0for column-store data is fast enough then consolidated viewing of the data can be done on the fly by removing the need for maintaining aggregate views, and it is associated with the data redundancy.<\/p>\r\n

Although row-oriented systems have traditionally been favored for OLTP, in-memory storage opens techniques for the development of hybrid systems, suitable for both OLAP and OLTP capabilities<\/a>, removing the need to maintain separate systems for OLTP and OLAP operations.<\/p>\r\n\r\n[\/et_pb_text][et_pb_image _builder_version=”3.17.6″ src=”https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-1-29.png” align=”center” \/][et_pb_text _builder_version=”3.0.106″ background_layout=”light” text_font=”Titillium Web|300|||||||” text_font_size=”20″ text_font_size_last_edited=”on|desktop” text_text_color=”rgba(0,0,0,0.8)” text_line_height=”1.6em” max_width=”800px” custom_margin=”|||10%” text_line_height_last_edited=”off|phone” max_width_last_edited=”off|phone” custom_margin_last_edited=”off|desktop”]\r\n\r\n

\r\nIndexer components:<\/strong><\/p>\r\n

The index server performs session management, authorization, transaction management and command processing.<\/p>\r\n

The database has both a row store and a column store. Users can create tables using either store, but the column store has more capabilities and is most frequently used.<\/p>\r\n

The index server also manages persistence between cached memory images of database objects, log files and permanent storage files.<\/p>\r\n

The XS engine allows web applications to build. SAP HANA Information Modeling (also known as SAP HANA Data Modeling) is a part of HANA application<\/a> development.<\/p>\r\n

Modeling is the methodology to expose the operational data to the end user.<\/p>\r\n

Reusable virtual objects are used in the modeling process.<\/p>\r\n\r\n[\/et_pb_text][et_pb_image _builder_version=”3.17.6″ src=”https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/download-2-20.png” align=”center” \/][et_pb_text _builder_version=”3.12.2″ text_font=”Titillium Web|300|||||||” text_font_size=”20″ text_font_size_last_edited=”on|desktop” text_text_color=”rgba(0,0,0,0.8)” text_line_height=”1.6em” max_width=”800px” custom_margin=”|||10%” text_line_height_last_edited=”off|phone” max_width_last_edited=”off|phone” custom_margin_last_edited=”off|desktop”]\r\n\r\n

\r\nMVCC:<\/strong><\/p>\r\n

SAP HANA manages concurrency through the use of multi-version concurrency control (MVCC) which gives every transaction a snapshot of the database at a point in time.<\/p>\r\n

When an MVCC database needs to update an item of data, it will not overwrite the old data with new data, but will instead mark the old data as obsolete and add the newer version.<\/p>\r\n

Streaming and Data Virtualization:<\/strong><\/p>\r\n

i. Data Virtualization is available via a tool named Smart Data Access.<\/p>\r\n

ii. Streaming data, for example from the Internet, of things, devices are available via a tool named Smart Data Streaming.<\/p>\r\n

iii. Dedicated streaming analytics(predictive analytics) can be employed against the data ingested by Smart Data Streaming.<\/p>\r\n

If you have done with Setup then you can have a look about SAP HANA\u00a0Security<\/a>\u00a0Tutorial.<\/p>\r\n

Enroll for SAP HANA Training Course<\/strong><\/span><\/a><\/p>\r\n\r\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section bb_built=”1″ prev_background_color=”#000000″][et_pb_row][et_pb_column type=”4_4″][et_pb_team_member _builder_version=”3.0.106″ name=”Mahesh J” position=”Author” facebook_url=”” twitter_url=”” google_url=”” linkedin_url=”” image_url=”https:\/\/asha24.net\/blog\/\/wp-content\/uploads\/2018\/03\/123.gif” background_layout=”light” header_font=”Titillium Web|700|||||||” body_font=”Titillium Web||||||||” body_font_size=”16″]\r\n\r\n

\r\nHello all! I\u2019m a nature\u2019s child, who loves the wild, bringing technical knowledge to you restyled.<\/p>\r\n\r\n[\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":4,"featured_media":48250,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[35],"tags":[],"class_list":["post-48247","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana"],"yoast_head":"\nSAP HANA Architecture (A step by step Guide)<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP HANA Architecture (A step by step Guide)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/\" \/>\n<meta property=\"og:site_name\" content=\"Asha24 Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-13T04:11:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-03T08:35:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/sap-hana-architecture-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"688\" \/>\n\t<meta property=\"og:image:height\" content=\"459\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mahesh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/asha24.net\/blog\/#website\",\"url\":\"https:\/\/asha24.net\/blog\/\",\"name\":\"Asha24 Blog\",\"description\":\"Dedication Towards Learning\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/asha24.net\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/sap-hana-architecture-1.jpg\",\"contentUrl\":\"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/sap-hana-architecture-1.jpg\",\"width\":688,\"height\":459},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#webpage\",\"url\":\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/\",\"name\":\"SAP HANA Architecture (A step by step Guide)\",\"isPartOf\":{\"@id\":\"https:\/\/asha24.net\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#primaryimage\"},\"datePublished\":\"2018-02-13T04:11:38+00:00\",\"dateModified\":\"2023-02-03T08:35:43+00:00\",\"author\":{\"@id\":\"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759\"},\"breadcrumb\":{\"@id\":\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/asha24.net\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP HANA Architecture\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759\",\"name\":\"Mahesh\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/asha24.net\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g\",\"caption\":\"Mahesh\"},\"url\":\"https:\/\/asha24.net\/blog\/author\/mahesh\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP HANA Architecture (A step by step Guide)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/","og_locale":"en_US","og_type":"article","og_title":"SAP HANA Architecture (A step by step Guide)","og_url":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/","og_site_name":"Asha24 Blog","article_published_time":"2018-02-13T04:11:38+00:00","article_modified_time":"2023-02-03T08:35:43+00:00","og_image":[{"width":688,"height":459,"url":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/sap-hana-architecture-1.jpg","path":"\/home\/reviews981\/public_html\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/sap-hana-architecture-1.jpg","size":"full","id":48250,"alt":"","pixels":315792,"type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"Mahesh","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/asha24.net\/blog\/#website","url":"https:\/\/asha24.net\/blog\/","name":"Asha24 Blog","description":"Dedication Towards Learning","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/asha24.net\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#primaryimage","inLanguage":"en-US","url":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/sap-hana-architecture-1.jpg","contentUrl":"https:\/\/asha24.net\/blog\/wp-content\/uploads\/2018\/03\/sap-hana-architecture-1.jpg","width":688,"height":459},{"@type":"WebPage","@id":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#webpage","url":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/","name":"SAP HANA Architecture (A step by step Guide)","isPartOf":{"@id":"https:\/\/asha24.net\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#primaryimage"},"datePublished":"2018-02-13T04:11:38+00:00","dateModified":"2023-02-03T08:35:43+00:00","author":{"@id":"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759"},"breadcrumb":{"@id":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/asha24.net\/blog\/sap-hana-architecture\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/asha24.net\/blog\/sap-hana-architecture\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/asha24.net\/blog\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Architecture"}]},{"@type":"Person","@id":"https:\/\/asha24.net\/blog\/#\/schema\/person\/f6167b78bbaddfc399ae1154cd5b6759","name":"Mahesh","image":{"@type":"ImageObject","@id":"https:\/\/asha24.net\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/085c03e75ffb51af2509c1cfad9c7d78b30236d43a008db2e46f96e2f40c67fc?s=96&d=wavatar&r=g","caption":"Mahesh"},"url":"https:\/\/asha24.net\/blog\/author\/mahesh\/"}]}},"_links":{"self":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48247","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/comments?post=48247"}],"version-history":[{"count":11,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48247\/revisions"}],"predecessor-version":[{"id":52121,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/posts\/48247\/revisions\/52121"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/media\/48250"}],"wp:attachment":[{"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/media?parent=48247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/categories?post=48247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asha24.net\/blog\/wp-json\/wp\/v2\/tags?post=48247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}