{"id":14052,"date":"2020-05-09T10:12:44","date_gmt":"2020-05-09T08:12:44","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/"},"modified":"2020-05-09T10:12:44","modified_gmt":"2020-05-09T08:12:44","slug":"apex-connect-2020-day-1","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/","title":{"rendered":"APEX Connect 2020 &#8211; Day 1"},"content":{"rendered":"<p>This year the APEX connect conference goes virtual online, like all other major IT events, due to the pandemic. Unfortunately it spans only over two days with mixed topics around APEX, like JavaScript, PL\/SQL and much more. After the welcome speech and the very interesting Keynote about &#8220;APEX 20.1 and beyond: News from APEX Development&#8221; by Carsten Czarski, I decided to attend presentations on following topics:<br \/>\n&#8211; The Basics of Deep Learning<br \/>\n&#8211; \u201cMake it faster\u201d: Myths about SQL performance<br \/>\n&#8211; Using RESTful Services and Remote SQL<br \/>\n&#8211; The Ultimate Guide to APEX Plug-ins<br \/>\n&#8211; Game of Fraud Detection with SQL and Machine Learning<\/p>\n<h3>APEX 20.1 and beyond: News from APEX Development<\/h3>\n<p>Carsten Czarski from the APEX development team shared about the evolution of the latest APEX releases up to 20.1 released on April 23rd.<br \/>\nSince APEX 18.1 there are 2 release per year. There are no major nor minor releases, all are managed at the same level.<br \/>\nBeside those releases bundle PSE to fix critical issues are provided.<br \/>\nFrom the recent features a couple have retained my attention:<br \/>\n&#8211; Faceted search<br \/>\n&#8211; Wider integration of Oracle TEXT<br \/>\n&#8211; Application backups<br \/>\n&#8211; Session timeout warnings<br \/>\n&#8211; New URL<br \/>\nAnd more to come with next releases like:<br \/>\n&#8211; Native PDF export<br \/>\n&#8211; New download formats<br \/>\n&#8211; External data sources<br \/>\nA lot to test and enjoy!<\/p>\n<h3>The Basics of Deep Learning<\/h3>\n<p>Artificial Intelligence (AI) is now part of our life mostly without noticing it. Machine learning (ML) is part of AI and Deap Learning (DL) a specific sub-part of ML.<br \/>\nML is used in different sectors and used for example in:<\/p>\n<ul>\n<li>SPAM filters<\/li>\n<li>Data Analytics<\/li>\n<li>Medical Diagnosis<\/li>\n<li>Image recognition<\/li>\n<\/ul>\n<p>and much more&#8230;<br \/>\nDL is integrating automated feature extraction which makes it suited for:<\/p>\n<ul>\n<li>Natural Language processing<\/li>\n<li>Speech recognition<\/li>\n<li>Text to Speech<\/li>\n<li>Machine translation<\/li>\n<li>Referencing to Text<\/li>\n<\/ul>\n<p>You can find some example of text generator based on DL with <a href=\"https:\/\/talktotransformer.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Talk to transformer<\/a><br \/>\nIt is also heavily used in visual recognition (feature based recognition). ML is dependent on the datasets and preset models used so it&#8217;s key to have a large set of data to cover a wide range of possibilities. DL has made a big step forward with <a href=\"https:\/\/towardsdatascience.com\/a-comprehensive-guide-to-convolutional-neural-networks-the-eli5-way-3bd2b1164a53\" target=\"_blank\" rel=\"noopener noreferrer\">Convolutional Neural Networks<\/a> (by Yann Lecun).<br \/>\nDL is based on complex mathematical models in Neural Networks at different levels, which use activation functions, model design, hyper parameters, backpropagation, loss functions, optimzer.<br \/>\nYou can learn how it is implemented in image recognition at <a href=\"https:\/\/www.pyimagesearch.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">pyimagesearch.com<\/a><br \/>\nAnother nice example of DL with reinforcement learning is <a href=\"https:\/\/youtu.be\/VMp6pq6_QjI\" target=\"_blank\" rel=\"noopener noreferrer\">AI learns to park<\/a><\/p>\n<h3>\u201cMake it faster\u201d: Myths about SQL performance<\/h3>\n<p>Performance of the Database is a hot topic when it comes to data centric application development like with APEX.<br \/>\nThe pillars of DB performance are following:<br \/>\n&#8211; Performance planning<br \/>\n&#8211; Instance tuning<br \/>\n&#8211; SQL tuning<br \/>\nTo be efficient performance must be considered at every stage of a project.<br \/>\nRecurring statement is: &#8220;Index is GOOD, full table scan is BAD&#8221;<br \/>\nBut when is index better than full table scan? As a rule of thumb you can consider when selectivity is less than 5%<br \/>\nTo improve the performance there are also options like:<br \/>\n&#8211; KIWI (Kill It With Iron) where more hardware should solve the performance issue<br \/>\n&#8211; Hints where you cut branches of the optimizer decision tree to force its choice (which is always the less expensive plan)<br \/>\nUnfortunately there is no golden hint able to improve performance whenever it&#8217;s used<\/p>\n<h3>Using RESTful Services and Remote SQL<\/h3>\n<p>REST web services are based on URI returning different types of data like HTML, XML, CSV or JSON.<br \/>\nThose web services are based on <a href=\"https:\/\/www.restapitutorial.com\/lessons\/httpmethods.html\" target=\"_blank\" rel=\"noopener noreferrer\">request methods<\/a>:<\/p>\n<ul>\n<li>POST to insert data<\/li>\n<li>PUT to update\/replace data<\/li>\n<li>GET to read data<\/li>\n<li>DELETE to DELETE data<\/li>\n<li>PATCH to update\/modify data<\/li>\n<\/ul>\n<p>The integration of web services in APEX allows to make use of data outside of the Oracle database and connect to services like:<br \/>\n&#8211; Jira<br \/>\n&#8211; GitHub<br \/>\n&#8211; Online Accounting Services<br \/>\n&#8211; Google services<br \/>\n&#8211; &#8230;<br \/>\nWeb services module on ORDS instance provides extensions on top of normal REST which support APEX out of the box but also enables Remote SQL.<br \/>\nThanks to that, SQL statement can be sent over REST to the Oracle Database and executed remotely returning the data formatted as per REST standards.<\/p>\n<h3>The Ultimate Guide to APEX Plug-ins<\/h3>\n<p>Even though APEX plug-ins are not trivial to build they have benefits like:<br \/>\n&#8211; Introduction of new functionality<br \/>\n&#8211; Modularity<br \/>\n&#8211; Reusability<br \/>\nwhich makes them very interesting.<br \/>\nThere are already a lot of Plug-ins available which can be found on <a href=\"https:\/\/apex.world\/\" target=\"_blank\" rel=\"noopener noreferrer\">apex.world<\/a> or on professional providers like <a href=\"https:\/\/www.foex.at\" target=\"_blank\" rel=\"noopener noreferrer\">FOEX<\/a><br \/>\nWhat is important to look at with plug-ins are support, quality, security and updates.<br \/>\nThe main elements of a plug-in are:<br \/>\n&#8211; Name<br \/>\n&#8211; Type<br \/>\n&#8211; Callbacks<br \/>\n&#8211; Standard attributes<br \/>\n&#8211; Custom attributes<br \/>\n&#8211; Files (CSS, JS, &#8230;)<br \/>\n&#8211; Events<br \/>\n&#8211; Information<br \/>\n&#8211; Help Text<br \/>\nPlug-ins are also a way to provide tools to improve the APEX developer experience like <a href=\"https:\/\/github.com\/OraOpenSource\/apex-nitro\" target=\"_blank\" rel=\"noopener noreferrer\">APEX Nitro<\/a> or <a href=\"https:\/\/www.foex.at\/apex-builder-extension\/\" target=\"_blank\" rel=\"noopener noreferrer\">APEX Builder extension by FOS<\/a><\/p>\n<h3>Game of Fraud Detection with SQL and Machine Learning<\/h3>\n<p>With the example of some banking fraud, the investigation method based on deterministic SQL was compared to the method based on probabilistic ML.<br \/>\nEven though results were close on statistics Supervised Machine Learning (looking for patterns to identify the solutions) was giving more accurate ones. In fact, the combination of both methods was giving even better results.<br \/>\nThe challenge is to gain acceptance from the business on results produced using help of ML as they are not based on fully explainable rules.<br \/>\nThe Oracle database is embedding ML for free with specific package like DBMS_DATA_MINING for several years now.<\/p>\n<p>The day ended with the most awaited session: <strong>Virtual beer!<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This year the APEX connect conference goes virtual online, like all other major IT events, due to the pandemic. Unfortunately it spans only over two days with mixed topics around APEX, like JavaScript, PL\/SQL and much more. After the welcome speech and the very interesting Keynote about &#8220;APEX 20.1 and beyond: News from APEX Development&#8221; [&hellip;]<\/p>\n","protected":false},"author":17,"featured_media":14053,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368,59],"tags":[1926,96,24],"type_dbi":[],"class_list":["post-14052","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development-performance","category-oracle","tag-apex-connect-2020","tag-oracle","tag-pl-sql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>APEX Connect 2020 - Day 1 - 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\/apex-connect-2020-day-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"APEX Connect 2020 - Day 1\" \/>\n<meta property=\"og:description\" content=\"This year the APEX connect conference goes virtual online, like all other major IT events, due to the pandemic. Unfortunately it spans only over two days with mixed topics around APEX, like JavaScript, PL\/SQL and much more. After the welcome speech and the very interesting Keynote about &#8220;APEX 20.1 and beyond: News from APEX Development&#8221; [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-09T08:12:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\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=\"5 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\\\/apex-connect-2020-day-1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/\"},\"author\":{\"name\":\"Alain Lacour\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/acabba2b6ca473b44b098c2de61294b0\"},\"headline\":\"APEX Connect 2020 &#8211; Day 1\",\"datePublished\":\"2020-05-09T08:12:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/\"},\"wordCount\":950,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg\",\"keywords\":[\"APEX connect 2020\",\"Oracle\",\"PL\\\/SQL\"],\"articleSection\":[\"Development &amp; Performance\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/\",\"name\":\"APEX Connect 2020 - Day 1 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg\",\"datePublished\":\"2020-05-09T08:12:44+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/acabba2b6ca473b44b098c2de61294b0\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg\",\"width\":1024,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/apex-connect-2020-day-1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"APEX Connect 2020 &#8211; Day 1\"}]},{\"@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&amp;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":"APEX Connect 2020 - Day 1 - 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\/apex-connect-2020-day-1\/","og_locale":"en_US","og_type":"article","og_title":"APEX Connect 2020 - Day 1","og_description":"This year the APEX connect conference goes virtual online, like all other major IT events, due to the pandemic. Unfortunately it spans only over two days with mixed topics around APEX, like JavaScript, PL\/SQL and much more. After the welcome speech and the very interesting Keynote about &#8220;APEX 20.1 and beyond: News from APEX Development&#8221; [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/","og_site_name":"dbi Blog","article_published_time":"2020-05-09T08:12:44+00:00","og_image":[{"width":1024,"height":768,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg","type":"image\/jpeg"}],"author":"Alain Lacour","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Lacour","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/"},"author":{"name":"Alain Lacour","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"headline":"APEX Connect 2020 &#8211; Day 1","datePublished":"2020-05-09T08:12:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/"},"wordCount":950,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg","keywords":["APEX connect 2020","Oracle","PL\/SQL"],"articleSection":["Development &amp; Performance","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/","url":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/","name":"APEX Connect 2020 - Day 1 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg","datePublished":"2020-05-09T08:12:44+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/A420F087-6E41-425E-90E1-1027CBA19321_1_105_c.jpeg","width":1024,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2020-day-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"APEX Connect 2020 &#8211; Day 1"}]},{"@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&amp;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\/14052","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=14052"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14052\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14053"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14052"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14052"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14052"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14052"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}