1.0Data Science made in Switzerlandhttps://blog.zhaw.ch/datascienceKurt Stockingerhttps://blog.zhaw.ch/datascience/author/stog/rich600338<blockquote class="wp-embedded-content" data-secret="07Kp21rzor"><a href="https://blog.zhaw.ch/datascience/soda-search-over-data-warehouse-reloaded/">SODA (Search Over Data Warehouse) Reloaded</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://blog.zhaw.ch/datascience/soda-search-over-data-warehouse-reloaded/embed/#?secret=07Kp21rzor" width="600" height="338" title="“SODA (Search Over Data Warehouse) Reloaded” — Data Science made in Switzerland" data-secret="07Kp21rzor" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://blog.zhaw.ch/datascience/wp-includes/js/wp-embed.min.js </script> https://blog.zhaw.ch/datascience/files/2013/09/SODAOverview.png640962Introduction SODA (Search over Data Warehouse) provides a Google-like search interface for querying an enterprise data warehouse.  The tool enables non-tech savvy users, who do not have technical knowledge of the underlying database system or the query language SQL, to intuitively explore complex data warehouses. The main idea is to use metadata information about the […]