{"version":"1.0","provider_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","provider_url":"https:\/\/fatihsoysal.com\/blog","author_name":"Fatih Soysal","author_url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/","title":"Esnek Aral\u0131k Toplama: SQL'den SPL'ye Ge\u00e7i\u015f","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"wNTGamNCxV\"><a href=\"https:\/\/fatihsoysal.com\/blog\/esnek-aralik-toplama-sqlden-splye-gecis\/\">Esnek Aral\u0131k Toplama: SQL&#8217;den SPL&#8217;ye Ge\u00e7i\u015f<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/esnek-aralik-toplama-sqlden-splye-gecis\/embed\/#?secret=wNTGamNCxV\" width=\"600\" height=\"338\" title=\"&#8220;Esnek Aral\u0131k Toplama: SQL&#8217;den SPL&#8217;ye Ge\u00e7i\u015f&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"wNTGamNCxV\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script>\n\/*! This file is auto-generated *\/\n!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);\n<\/script>\n","description":"Veri analizi d\u00fcnyas\u0131nda, verileri anlaml\u0131 bir \u015fekilde \u00f6zetlemek i\u00e7in veri k\u00fcmelerini belirli aral\u0131klara g\u00f6re toplamak (aggregate) olduk\u00e7a yayg\u0131nd\u0131r. SQL, bu konuda g\u00fc\u00e7l\u00fc bir ara\u00e7 sunarken, baz\u0131 senaryolarda s\u0131n\u0131rl\u0131 kalabilir. Bu makalede, \u00f6zellikle esnek aral\u0131k toplamalar\u0131nda SQL'in yeteneklerinin \u00f6tesine ge\u00e7en bir dil olan SPL (ESProc SPL) \u00fczerinde duraca\u011f\u0131z. SQL'de karma\u015f\u0131k hale gelen i\u015flemleri SPL'nin nas\u0131l kolayla\u015ft\u0131rd\u0131\u011f\u0131n\u0131, \u00f6rneklerle a\u00e7\u0131klayaca\u011f\u0131z. Ayr\u0131ca, SPL'nin sa\u011flad\u0131\u011f\u0131 performans avantajlar\u0131na da de\u011finece\u011fiz."}