{"id":4831,"date":"2015-05-21T10:32:48","date_gmt":"2015-05-21T08:32:48","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/"},"modified":"2015-05-21T10:32:48","modified_gmt":"2015-05-21T08:32:48","slug":"row-store-vs-column-store-in-sap-hana","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/","title":{"rendered":"Row Store vs Column Store in SAP HANA"},"content":{"rendered":"
\"\"<\/div>\n

The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases.<\/p>\n

Thanks to two kind of tests, I will show you that the Row Store mode should be used for simple SELECT SQL queries, without aggregation and the Column Store mode should be used for complex SELECT queries, containing aggregation levels.<\/p>\n

If you want to have more information regarding the Column Store or the In-memory technologies, don’t hesitate to assist at the next dbi services event:
\nhttps:\/\/www.dbi-services.com\/newsroom\/events\/<\/a><\/p>\n

Test 1: Simple SELECT query<\/h3>\n

Goal of the tests<\/h4>\n

This test will show you the difference of performance using a Row Store and a Column Store table in a simple SQL query.<\/p>\n

Description of the test<\/h4>\n

A SELECT query will be send to the database and we will check the Server time response.<\/p>\n

SQL Query<\/h4>\n

Using a Row Store table<\/strong><\/p>\n

The SQL is the following:<\/p>\n

\"1_SQL_ROW_STORE.PNG\"<\/a><\/p>\n

Using a Column Store table<\/strong>
\nThe SQL is the following:<\/p>\n

\"2_SQL_COLUMN_STORE.PNG\"<\/a><\/p>\n

Tables<\/h3>\n

Row Store Table<\/h4>\n

You can find here information regarding the Row Store table used in the test.<\/p>\n

Name: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SALES_ROW
\nTable type: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Row Store
\nRow count: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 309 873
\nIndex: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1
\nPartition:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 (SAP HANA doesn\u2019t allow the possibility to create partition on Row Store table)<\/p>\n

\"3_TABLE_ROW_STORE_1.PNG\"<\/a><\/p>\n

\"4_TABLE_ROW_STORE_2.PNG\"<\/a><\/p>\n

Column Store Table<\/h4>\n

You can find here information regarding the Column Store table used in the test.<\/p>\n

Name: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SALES_COLUMN
\nTable type: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column Store
\nRow count: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 309 873
\nIndex: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 (SAP HANA automatically apply a index if it is need)
\nPartition:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 RANGE partition on CUST_ID<\/p>\n

\"6_TABLE_COLUMN_STORE_2.PNG\"<\/a><\/p>\n

Result of the test<\/h3>\n

Using the Row Store table<\/h4>\n

\"8_SQL_Q1_SELECT_ROW_RESULT.PNG\"<\/a><\/p>\n

Using the Column Store table<\/h4>\n

\"9_SQL_Q1_SELECT_COLUMN_RESULT.PNG\"<\/a><\/p>\n

Test 2: Complex SELECT query<\/h3>\n

Goal of the tests<\/h4>\n

This test will show you the difference of performance using a Row Store and a Column Store table in a complex SQL query.<\/p>\n

Description of the test<\/h4>\n

A SELECT query will be send to the database and we will check the Server time response.<\/p>\n

SQL Query<\/h4>\n

Using a Row Store table<\/strong><\/p>\n

The SQL is the following:<\/p>\n

\"10_SQL_ROW_STORE.PNG\"<\/a><\/p>\n

Using a Column Store table<\/strong>
\nThe SQL is the following:<\/p>\n

\"11_SQL_COLUMN_STORE.PNG\"<\/a><\/p>\n

Tables<\/h4>\n

Row Store Fact Table<\/strong><\/p>\n

You can find here information regarding the Row Store table used in the test.<\/p>\n

Name: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SALES_ROW
\nTable type: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Row Store
\nRow count: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 309 873
\nIndex: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2
\nPartition:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 (SAP HANA doesn\u2019t allow the possibility to create partition on Row Store table)<\/p>\n

Column Store Fact Table<\/strong><\/p>\n

You can find here information regarding the Column Store table used in the test.<\/p>\n

Name: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SALES_COLUMN
\nTable type: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Column Store
\nRow count: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 309 873
\nIndex: \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 (SAP HANA automatically apply a index if it is need)
\nPartition:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 RANGE partition on CUST_ID<\/p>\n

Result of the test<\/h4>\n

Using the Row Store tables<\/strong><\/p>\n

\"12_SQL_Q2_SELECT_ROW_RESULT.PNG\"<\/a><\/p>\n

Using the Column Store tables<\/strong><\/p>\n

\"13_SQL_Q2_SELECT_COLUMN_RESULT.PNG\"<\/a><\/p>\n

Conclusion<\/h3>\n

Row and Column store modes in SAP HANA should be used in two different contexts:<\/p>\n

    \n
  • Tables in Row store mode must be used in SELECT queries WITHOUT any aggregation functions<\/li>\n
  • Tables in Column store mode are powerful when they are used to create analytical queries or view, using aggregation functions (GROUP BY, \u2026)<\/li>\n<\/ul>\n

    The performance can be highly optimized if the tables selected in the queries have the right store mode.<\/p>\n","protected":false},"excerpt":{"rendered":"

    The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two kind of tests, I will show you that the Row Store mode should be used […]<\/p>\n","protected":false},"author":17,"featured_media":4832,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368],"tags":[135,579,280,222,582],"type_dbi":[],"class_list":["post-4831","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development-performance","tag-cloud","tag-column-store","tag-database","tag-in-memory","tag-sap-hana"],"acf":[],"yoast_head":"\nRow Store vs Column Store in SAP HANA - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Row Store vs Column Store in SAP HANA\" \/>\n<meta property=\"og:description\" content=\"The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two kind of tests, I will show you that the Row Store mode should be used […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2015-05-21T08:32:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"157\" \/>\n\t<meta property=\"og:image:height\" content=\"56\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Alain Lacour\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alain Lacour\" \/>\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\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/\"},\"author\":{\"name\":\"Alain Lacour\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"headline\":\"Row Store vs Column Store in SAP HANA\",\"datePublished\":\"2015-05-21T08:32:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/\"},\"wordCount\":538,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg\",\"keywords\":[\"Cloud\",\"Column Store\",\"database\",\"In-memory\",\"SAP HANA\"],\"articleSection\":[\"Development & Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/\",\"name\":\"Row Store vs Column Store in SAP HANA - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg\",\"datePublished\":\"2015-05-21T08:32:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg\",\"width\":157,\"height\":56},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Row Store vs Column Store in SAP HANA\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\",\"name\":\"Alain Lacour\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"caption\":\"Alain Lacour\"},\"description\":\"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Row Store vs Column Store in SAP HANA - dbi Blog","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:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"Row Store vs Column Store in SAP HANA","og_description":"The SAP HANA database allows you to create your tables in Row or Column Store mode. In this blog, I will demonstrate that each method has its advantages and disadvantages and should be used for specific cases. Thanks to two kind of tests, I will show you that the Row Store mode should be used […]","og_url":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/","og_site_name":"dbi Blog","article_published_time":"2015-05-21T08:32:48+00:00","og_image":[{"width":157,"height":56,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg","type":"image\/jpeg"}],"author":"Alain Lacour","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Lacour","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/"},"author":{"name":"Alain Lacour","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"headline":"Row Store vs Column Store in SAP HANA","datePublished":"2015-05-21T08:32:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/"},"wordCount":538,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg","keywords":["Cloud","Column Store","database","In-memory","SAP HANA"],"articleSection":["Development & Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/","url":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/","name":"Row Store vs Column Store in SAP HANA - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg","datePublished":"2015-05-21T08:32:48+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/2e1ax_default_entry_logo_sap_hana.jpg","width":157,"height":56},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/row-store-vs-column-store-in-sap-hana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Row Store vs Column Store in SAP HANA"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0","name":"Alain Lacour","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","caption":"Alain Lacour"},"description":"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.","url":"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4831","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=4831"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/4831\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/4832"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=4831"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=4831"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=4831"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=4831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}