{"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":"SQL'de Benzersiz Anahtarlar: Veri B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Sa\u011flama","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"ElxBgi0Rh8\"><a href=\"https:\/\/fatihsoysal.com\/blog\/sqlde-benzersiz-anahtarlar-veri-butunlugunu-saglama\/\">SQL&#8217;de Benzersiz Anahtarlar: Veri B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Sa\u011flama<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/fatihsoysal.com\/blog\/sqlde-benzersiz-anahtarlar-veri-butunlugunu-saglama\/embed\/#?secret=ElxBgi0Rh8\" width=\"600\" height=\"338\" title=\"&#8220;SQL&#8217;de Benzersiz Anahtarlar: Veri B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Sa\u011flama&#8221; &#8212; Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" data-secret=\"ElxBgi0Rh8\" 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":"Veritaban\u0131 y\u00f6netim sistemlerinde (DBMS), \u00f6zellikle SQL'de, veri b\u00fct\u00fcnl\u00fc\u011f\u00fc son derece \u00f6nemlidir. Do\u011fru ve tutarl\u0131 veriler, g\u00fcvenilir uygulamalar\u0131n temelini olu\u015fturur. Bu b\u00fct\u00fcnl\u00fc\u011f\u00fc sa\u011flaman\u0131n en etkili yollar\u0131ndan biri de benzersiz anahtarlar\u0131n (Unique Keys) kullan\u0131m\u0131d\u0131r. \u00d6zetle, benzersiz anahtarlar, bir tabloda her sat\u0131r\u0131n benzersiz bir \u015fekilde tan\u0131mlanmas\u0131n\u0131 garanti eder. Bu sayede, ayn\u0131 veriyi tekrar tekrar kaydetmeyi \u00f6nleyerek, veri redundans\u0131n\u0131 ve tutars\u0131zl\u0131klar\u0131n\u0131 ortadan kald\u0131r\u0131r."}