{"id":13008,"date":"2019-11-14T16:13:13","date_gmt":"2019-11-14T15:13:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/"},"modified":"2019-11-14T16:13:13","modified_gmt":"2019-11-14T15:13:13","slug":"some-words-about-soug-day-in-lausanne","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/","title":{"rendered":"Some words about SOUG Day in Lausanne"},"content":{"rendered":"

Today I participate to SOUG Day<\/a> which takes place in Lausanne at the “Centre Pluriculturel et social d\u2019Ouchy”.
\n
\nAfter a coffee and a welcome speech by Yann Neushaus<\/a>, Ludovico Caldara<\/a> and Flora Barriele<\/a>,
\n\"\"<\/a>
\nthe event starts with 2 global sessions:<\/p>\n

A l’heure du serverless, le futur va-t-il aller aux bases de donn\u00e9es distribu\u00e9es?<\/h3>\n

Franck Pachot<\/a> makes a comparison between Oracle products (Active Data Guard, RAC, Sharding) and new distributed databases in order to scale-up and scale-out.
\nBriefly his talk makes reference to:
\n– Differences among RDBMS, NoSQL and NewSQL according to the CAP Theorem
\n– Definition and needs for NoSQL and NewSQL
\n– Definition of services such as Google’s Cloud Spanner<\/a>, TiDB<\/a>, CockroachDB<\/a>, YugabyteDB<\/a>.<\/p>\n

From DBA to Data Engineer – How to survive a career transition?<\/h3>\n

Kamran Agayev from Azerbaijan speaks about what Big Data in general is and the transition from DBA to Database Engineer.
\nHe addresses several interesting topics:
\n– Definition of Big Data
\n– Which are the skills for a Data Engineer, a Data Architect (more complex competences than “just” being a Database Administrator)
\n– Definition of products like Hadoop, Kafka, NoSQL
\nAfter the coffee break, the choice is between 2 different streams. Here some words about the sessions I attend.<\/p>\n

Amazing SQL<\/h3>\n

Laetitia Avrot from EnterpriseDB<\/a> talks about SQL, which is much more than what we know. SQL is different from other programming languages but it must be treated as one of them. At school we still learn SQL from before 1992, but in 1999 it changed to add relational algebra and data atomicity. PostgreSQL is very close to this standard. Laetitia shows lots of concrete examples of subqueries, common table expressions (CTE), lateral joins (not implemented in MySQL for the moment), anti joins, rollup, window functions, recursive CTE, and also some explanations about key words such as in, values, not in, not exists.<\/p>\n

Graph Database<\/h3>\n

After the lunch, Gianni Ceresa<\/a> presents property graph databases as combination of vertex (node, properties, ID) and edge (node, ID, label, properties). To start working with Oracle graphs, we can use PGX (Oracle Labs Parallel Graph AnalytiX). The OTN version is better for documentation. Through a demo, Gianni shows how to build a graph using Apache Zeppelin as interpreter and Phyton and Jupyter to visualize it. And then we can also use it to write some data analysis.<\/p>\n

5 mistakes that you’re making while presenting your data<\/h3>\n

Luiza Nowak<\/a>, a non-IT girl working with IT people (she is a board member of POUG<\/a>), talks about IT presentations. There are 4 important parts defining them: the content, the story, the speaker performance and visualization.
\nHere recurrent errors of IT presentations and how to handle them:
\n1. Lack of data selection – you need to filter your data, to consider who and where you are talking to
\n2. Too much at once – you need to divide your content, create some suspense and put less information into slides to let the audience listen to you instead of reading them
\n3. Forget about contrast – you have to use contrast on purpose because it can be useful to underline something but it can also distract your audience
\n4. Wrong type of charts – you have to be clear about your data and explain results
\n5. You don’t have any story – you need to conceptualize your data.<\/p>\n

How can Docker help a MariaDB cluster for disaster\/recovery<\/h3>\n

Sa\u00efd Mendi<\/a> from dbi services<\/a> explains what a MariaDB Galera Cluster<\/a> is and his benefits and how Docker can help in some critical situations. Actually you can create some delayed slaves which can be useful to emulate the flashback functionality.<\/p>\n

Conclusion<\/h3>\n

SOUG Day arrives to an end. It was a nice opportunity to meet international speakers, discuss with some customers and colleagues, learn and share. As usual, this is part of dbi services spirit and matches with our values!
\nAnd now, I have to say you goodbye: it’s the aperitif and dinner time with the community \ud83d\ude09 Hope to see you at the next SOUG<\/a> event.<\/p>\n","protected":false},"excerpt":{"rendered":"

Today I participate to SOUG Day which takes place in Lausanne at the “Centre Pluriculturel et social d\u2019Ouchy”.<\/p>\n","protected":false},"author":42,"featured_media":13009,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1183,955,229,198,1726,1739,59,83],"tags":[135,1396,141,1198,1740,947,96,77],"type_dbi":[],"class_list":["post-13008","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-big-data","category-cloud","category-database-administration-monitoring","category-database-management","category-mariadb","category-nosql","category-oracle","category-postgresql","tag-cloud","tag-hadoop","tag-mariadb","tag-microservice","tag-newsql","tag-nosql","tag-oracle","tag-postgresql"],"acf":[],"yoast_head":"\nSome words about SOUG Day in Lausanne - 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\/some-words-about-soug-day-in-lausanne\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Some words about SOUG Day in Lausanne\" \/>\n<meta property=\"og:description\" content=\"Today I participate to SOUG Day which takes place in Lausanne at the “Centre Pluriculturel et social d\u2019Ouchy”.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-14T15:13:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2048\" \/>\n\t<meta property=\"og:image:height\" content=\"1536\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Elisa Usai\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elisa Usai\" \/>\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\/some-words-about-soug-day-in-lausanne\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/\"},\"author\":{\"name\":\"Elisa Usai\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f\"},\"headline\":\"Some words about SOUG Day in Lausanne\",\"datePublished\":\"2019-11-14T15:13:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/\"},\"wordCount\":674,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg\",\"keywords\":[\"Cloud\",\"hadoop\",\"MariaDB\",\"Microservice\",\"NewSQL\",\"NoSQL\",\"Oracle\",\"PostgreSQL\"],\"articleSection\":[\"Big Data\",\"Cloud\",\"Database Administration & Monitoring\",\"Database management\",\"MariaDB\",\"NoSQL\",\"Oracle\",\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/\",\"name\":\"Some words about SOUG Day in Lausanne - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg\",\"datePublished\":\"2019-11-14T15:13:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg\",\"width\":2048,\"height\":1536},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Some words about SOUG Day in Lausanne\"}]},{\"@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\/ac5847ee8d7bad4196e72660c1377b1f\",\"name\":\"Elisa Usai\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"caption\":\"Elisa Usai\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/elisa-usai\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Some words about SOUG Day in Lausanne - 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\/some-words-about-soug-day-in-lausanne\/","og_locale":"en_US","og_type":"article","og_title":"Some words about SOUG Day in Lausanne","og_description":"Today I participate to SOUG Day which takes place in Lausanne at the “Centre Pluriculturel et social d\u2019Ouchy”.","og_url":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/","og_site_name":"dbi Blog","article_published_time":"2019-11-14T15:13:13+00:00","og_image":[{"width":2048,"height":1536,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg","type":"image\/jpeg"}],"author":"Elisa Usai","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elisa Usai","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/"},"author":{"name":"Elisa Usai","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f"},"headline":"Some words about SOUG Day in Lausanne","datePublished":"2019-11-14T15:13:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/"},"wordCount":674,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg","keywords":["Cloud","hadoop","MariaDB","Microservice","NewSQL","NoSQL","Oracle","PostgreSQL"],"articleSection":["Big Data","Cloud","Database Administration & Monitoring","Database management","MariaDB","NoSQL","Oracle","PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/","url":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/","name":"Some words about SOUG Day in Lausanne - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg","datePublished":"2019-11-14T15:13:13+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/20191114_090656.jpg","width":2048,"height":1536},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/some-words-about-soug-day-in-lausanne\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Some words about SOUG Day in Lausanne"}]},{"@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\/ac5847ee8d7bad4196e72660c1377b1f","name":"Elisa Usai","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","caption":"Elisa Usai"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/elisa-usai\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13008","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\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=13008"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/13008\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/13009"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=13008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=13008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=13008"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=13008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}