{"id":30852,"date":"2025-10-02T21:02:03","date_gmt":"2025-10-02T18:02:03","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/"},"modified":"2025-10-02T21:02:03","modified_gmt":"2025-10-02T18:02:03","slug":"uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/","title":{"rendered":"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak"},"content":{"rendered":"<p><body><\/p>\n<style>\n        body {\n            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;\n            line-height: 1.6;\n            color: #333;\n            max-width: 1000px;\n            margin: 0 auto;\n            padding: 20px;\n            background-color: #f9f9f9;\n        }\n        h2, h3 {\n            color: #2c3e50;\n            margin-top: 30px;\n            margin-bottom: 15px;\n            border-bottom: 2px solid #3498db;\n            padding-bottom: 5px;\n        }\n        h2 {\n            font-size: 2em;\n        }\n        h3 {\n            font-size: 1.5em;\n            border-bottom: 1px dashed #7f8c8d;\n        }\n        p {\n            margin-bottom: 15px;\n            text-align: justify;\n        }\n        ul, ol {\n            margin-bottom: 15px;\n            padding-left: 25px;\n        }\n        li {\n            margin-bottom: 8px;\n        }\n        pre {\n            background-color: #ecf0f1;\n            padding: 15px;\n            border-radius: 8px;\n            overflow-x: auto;\n            font-family: 'Consolas', 'Monaco', monospace;\n            font-size: 0.9em;\n            margin-bottom: 20px;\n        }\n        code {\n            font-family: 'Consolas', 'Monaco', monospace;\n            background-color: #e0e6e7;\n            padding: 2px 4px;\n            border-radius: 4px;\n        }\n        table {\n            width: 100%;\n            border-collapse: collapse;\n            margin-bottom: 20px;\n            background-color: #ffffff;\n        }\n        th, td {\n            border: 1px solid #ddd;\n            padding: 10px;\n            text-align: left;\n        }\n        th {\n            background-color: #3498db;\n            color: white;\n            font-weight: bold;\n        }\n        tr:nth-child(even) {\n            background-color: #f2f2f2;\n        }\n        .expert-tip {\n            background-color: #dbe9f6;\n            border-left: 5px solid #3498db;\n            padding: 15px;\n            margin: 20px 0;\n            border-radius: 5px;\n            font-style: italic;\n            color: #2c3e50;\n        }\n        .faq-answer {\n            background-color: #ecf0f1;\n            padding: 10px 15px;\n            border-radius: 5px;\n            margin-bottom: 10px;\n            border-left: 3px solid #7f8c8d;\n        }<\/p>\n<p>        \/* Mobile Responsive Styles *\/\n        @media (max-width: 768px) {\n            body {\n                padding: 15px;\n            }\n            h2 {\n                font-size: 1.7em;\n            }\n            h3 {\n                font-size: 1.3em;\n            }\n            table, thead, tbody, th, td, tr {\n                display: block;\n            }\n            thead tr {\n                position: absolute;\n                top: -9999px;\n                left: -9999px;\n            }\n            tr {\n                margin: 0 0 10px 0;\n                border: 1px solid #ddd;\n                border-radius: 5px;\n                box-shadow: 0 2px 5px rgba(0,0,0,0.1);\n            }\n            td {\n                border: none;\n                border-bottom: 1px solid #eee;\n                position: relative;\n                padding-left: 50%;\n                text-align: right;\n            }\n            td:before {\n                position: absolute;\n                top: 0;\n                left: 6px;\n                width: 45%;\n                padding-right: 10px;\n                white-space: nowrap;\n                content: attr(data-label);\n                font-weight: bold;\n                text-align: left;\n            }\n            td:last-child {\n                border-bottom: 0;\n            }\n            .expert-tip {\n                margin: 15px 0;\n                padding: 10px;\n            }\n        }\n    <\/style>\n<p>\n        Veri tabanlar\u0131, g\u00fcn\u00fcm\u00fcz yaz\u0131l\u0131m uygulamalar\u0131n\u0131n kalbinde yer al\u0131r ve bu sistemlerin temelini olu\u015fturan verilerin tutarl\u0131l\u0131\u011f\u0131, i\u015flevselli\u011fi i\u00e7in hayati \u00f6neme sahiptir. Peki, karma\u015f\u0131k bir Uniface 10.4 uygulamas\u0131nda verilerinizin her zaman do\u011fru ve ili\u015fkisel olarak b\u00fct\u00fcn kalmas\u0131n\u0131 nas\u0131l sa\u011flars\u0131n\u0131z? Cevap, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc do\u011fru bir \u015fekilde anlamak ve uygulamakta yat\u0131yor. Bu makale, Uniface bile\u015fenlerinizde referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, y\u00f6netece\u011finizi ve olas\u0131 hatalar\u0131 nas\u0131l \u00f6nleyece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak.\n    <\/p>\n<p>\n        Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc (Referential Integrity), ili\u015fkisel veritaban\u0131 sistemlerinin temel yap\u0131 ta\u015flar\u0131ndan biridir. Bu kavram, veritaban\u0131ndaki iki ili\u015fkili tablonun birbiriyle tutarl\u0131 olmas\u0131n\u0131 sa\u011flayan bir kurallar b\u00fct\u00fcn\u00fcd\u00fcr. En basit ifadeyle, bir tabloda (alt tablo) ba\u015fka bir tabloya (\u00fcst tablo) referans veren bir de\u011ferin (foreign key &#8211; yabanc\u0131 anahtar) ger\u00e7ekten de \u00fcst tablonun birincil anahtar (primary key) s\u00fctununda mevcut olmas\u0131n\u0131 garanti eder. \u00d6rne\u011fin, bir &#8220;Sipari\u015fler&#8221; tablosundaki her sipari\u015fin, &#8220;M\u00fc\u015fteriler&#8221; tablosunda ger\u00e7ek bir m\u00fc\u015fteriye ait olmas\u0131n\u0131 bekleriz. E\u011fer m\u00fc\u015fteriyi silersek, o m\u00fc\u015fteriye ait sipari\u015flerin de bir \u015fekilde ele al\u0131nmas\u0131 gerekir. Aksi takdirde, var olmayan bir m\u00fc\u015fteriye ait sipari\u015f kay\u0131tlar\u0131 gibi &#8220;yetim&#8221; veya tutars\u0131z veriler ortaya \u00e7\u0131kar ve bu durum, uygulaman\u0131n do\u011fru \u00e7al\u0131\u015fmas\u0131n\u0131 engeller.\n    <\/p>\n<p>\n        Bu b\u00fct\u00fcnl\u00fc\u011f\u00fc sa\u011flamak, veri kalitesini art\u0131r\u0131r ve i\u015f mant\u0131\u011f\u0131n\u0131n do\u011fru bir \u015fekilde i\u015flemesini temin eder. Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kurallar\u0131 sayesinde, sistem yanl\u0131\u015fl\u0131kla birincil anahtar tablosundan yabanc\u0131 anahtar tablosunda hala referans verilen bir kayd\u0131n silinmesini veya de\u011fi\u015ftirilmesini \u00f6nleyebilir. Bu, yaz\u0131l\u0131mc\u0131lar\u0131n her veri manip\u00fclasyonunda manuel olarak bu kontrolleri yazma ihtiyac\u0131n\u0131 ortadan kald\u0131r\u0131r ve b\u00f6ylece geli\u015ftirme s\u00fcresini k\u0131salt\u0131rken, hata riskini \u00f6nemli \u00f6l\u00e7\u00fcde azalt\u0131r. Veritaban\u0131 y\u00f6netim sistemleri (VTYS) genellikle bu kurallar\u0131 do\u011frudan veritaban\u0131 seviyesinde uygular; bu da Uniface gibi uygulamalar\u0131n bu kurallardan faydalanmas\u0131n\u0131 sa\u011flar. Dolay\u0131s\u0131yla, referans b\u00fct\u00fcnl\u00fc\u011f\u00fc, sadece verilerin do\u011fru olmas\u0131n\u0131 de\u011fil, ayn\u0131 zamanda uygulaman\u0131z\u0131n g\u00fcvenilir ve tutarl\u0131 bir \u015fekilde \u00e7al\u0131\u015fmas\u0131n\u0131 da garanti eden bir sigorta mekanizmas\u0131d\u0131r. Uniface gibi veri odakl\u0131 geli\u015ftirme ortamlar\u0131nda, bu kavram\u0131 anlamak ve do\u011fru uygulamak, g\u00fc\u00e7l\u00fc ve s\u00fcrd\u00fcr\u00fclebilir uygulamalar geli\u015ftirmenin anahtar\u0131d\u0131r.\n    <\/p>\n<p>\n        Biraz daha detaya inmek gerekirse, referans b\u00fct\u00fcnl\u00fc\u011f\u00fc genellikle \u015fu \u00fc\u00e7 temel kural etraf\u0131nda \u015fekillenir:\n    <\/p>\n<ul>\n<li><strong>Silme K\u0131s\u0131tlamas\u0131 (Restrict Delete):<\/strong> Birincil anahtar tablosundaki bir kay\u0131t, yabanc\u0131 anahtar tablosunda referans verildi\u011fi s\u00fcrece silinemez. Bu, genellikle varsay\u0131lan ve en g\u00fcvenli se\u00e7enektir.<\/li>\n<li><strong>Basamakl\u0131 Silme (Cascade Delete):<\/strong> Birincil anahtar tablosundaki bir kay\u0131t silindi\u011finde, yabanc\u0131 anahtar tablosunda bu kayda referans veren t\u00fcm ili\u015fkili kay\u0131tlar otomatik olarak silinir. Bu se\u00e7enek dikkatli kullan\u0131lmal\u0131d\u0131r, \u00e7\u00fcnk\u00fc yanl\u0131\u015fl\u0131kla \u00e7ok say\u0131da verinin silinmesine yol a\u00e7abilir.<\/li>\n<li><strong>Null Yapma (Set Null):<\/strong> Birincil anahtar tablosundaki bir kay\u0131t silindi\u011finde, yabanc\u0131 anahtar tablosundaki ilgili s\u00fctunlar NULL (bo\u015f) olarak g\u00fcncellenir. Bu, ili\u015fkili verinin hala var olabilece\u011fi ancak art\u0131k birincil kayda ba\u011fl\u0131 olmayaca\u011f\u0131 senaryolarda kullan\u0131\u015fl\u0131d\u0131r.<\/li>\n<\/ul>\n<p>\n        Bu kurallar, veritaban\u0131n\u0131n yap\u0131s\u0131na ve i\u015f mant\u0131\u011f\u0131na g\u00f6re dikkatlice belirlenmelidir. Yanl\u0131\u015f bir se\u00e7im, veri kayb\u0131na veya uygulama hatalar\u0131na neden olabilirken, do\u011fru bir uygulama, sisteminizin sa\u011flaml\u0131\u011f\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131racakt\u0131r. Uniface, bu kurallar\u0131 hem veritaban\u0131 ba\u011fda\u015ft\u0131r\u0131c\u0131s\u0131 arac\u0131l\u0131\u011f\u0131yla veritaban\u0131 seviyesinde hem de kendi dahili mekanizmalar\u0131yla uygulama seviyesinde y\u00f6netme esnekli\u011fi sunar. Bu esneklik, geli\u015ftiricilere g\u00fc\u00e7l\u00fc veri kontrol yetenekleri sa\u011flar.\n    <\/p>\n<h2>Uniface 10.4&#8217;te Referans B\u00fct\u00fcnl\u00fc\u011f\u00fc Nas\u0131l Sa\u011flan\u0131r?<\/h2>\n<p>\n        Uniface, veri b\u00fct\u00fcnl\u00fc\u011f\u00fcne b\u00fcy\u00fck \u00f6nem veren bir geli\u015ftirme platformudur. Uniface 10.4&#8217;te referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flaman\u0131n birden fazla yolu vard\u0131r ve bu yollar genellikle veritaban\u0131n\u0131n kendi referans b\u00fct\u00fcnl\u00fc\u011f\u00fc mekanizmalar\u0131 ile Uniface&#8217;in uygulama seviyesi kontrollerinin birle\u015fimiyle en etkili hale gelir. \u00d6ncelikle, Uniface&#8217;in model tabanl\u0131 yakla\u015f\u0131m\u0131 sayesinde, veritaban\u0131 tablolar\u0131n\u0131z aras\u0131ndaki ili\u015fkileri g\u00f6rsel olarak tan\u0131mlayabilirsiniz. Bu tan\u0131mlar, Uniface&#8217;in uygulama kodunuzun nas\u0131l \u00e7al\u0131\u015faca\u011f\u0131n\u0131 anlamas\u0131na yard\u0131mc\u0131 olur.\n    <\/p>\n<p>\n        Uniface Model Editor&#8217;da Entity&#8217;ler (varl\u0131klar) ve onlar\u0131n aras\u0131ndaki ili\u015fkiler tan\u0131mlan\u0131r. \u00d6rne\u011fin, bir &#8220;M\u00fc\u015fteri&#8221; entity&#8217;si ile &#8220;Sipari\u015f&#8221; entity&#8217;si aras\u0131nda bir ili\u015fki kurdu\u011funuzda, Uniface bu ili\u015fkiyi otomatik olarak tan\u0131r. Bu ili\u015fkiyi tan\u0131mlarken, anahtar alanlar\u0131 (Primary Key ve Foreign Key) do\u011fru bir \u015fekilde belirtmek kritik \u00f6nem ta\u015f\u0131r. Uniface, bu anahtar tan\u0131mlar\u0131na dayanarak veritaban\u0131 i\u015flemlerini ger\u00e7ekle\u015ftirirken referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc otomatik olarak g\u00f6zetmeye \u00e7al\u0131\u015f\u0131r. Uniface&#8217;in en \u00f6nemli \u00f6zelliklerinden biri de, veritaban\u0131 adapt\u00f6r\u00fc arac\u0131l\u0131\u011f\u0131yla do\u011frudan veritaban\u0131 seviyesindeki referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kurallar\u0131n\u0131 kullanabilmesidir. E\u011fer veritaban\u0131n\u0131zda (\u00f6rne\u011fin SQL Server, Oracle) Foreign Key k\u0131s\u0131tlamalar\u0131 tan\u0131ml\u0131ysa, Uniface bu k\u0131s\u0131tlamalar\u0131 dikkate al\u0131r ve uygulama seviyesinde tekrar kontrol etme y\u00fck\u00fcnden sizi kurtar\u0131r. Bu sayede hem performans art\u0131\u015f\u0131 sa\u011flan\u0131r hem de veri b\u00fct\u00fcnl\u00fc\u011f\u00fc veritaban\u0131 taraf\u0131ndan garanti alt\u0131na al\u0131n\u0131r.\n    <\/p>\n<p>\n        Ancak, bazen veritaban\u0131 seviyesi k\u0131s\u0131tlamalar\u0131 yeterli olmayabilir veya belirli i\u015f kurallar\u0131n\u0131 kar\u015f\u0131lamayabilir. Bu durumlarda, Uniface kendi dahili mekanizmalar\u0131yla ek kontroller sa\u011flaman\u0131za olanak tan\u0131r. \u00d6rne\u011fin, bir komponente birden fazla entity ekledi\u011finizde ve bunlar aras\u0131nda yol tan\u0131mlad\u0131\u011f\u0131n\u0131zda (<code>path<\/code> veya grafiksel olarak), Uniface ilgili kay\u0131tlar\u0131n otomatik olarak y\u00fcklendi\u011finden ve ili\u015fkilendirildi\u011finden emin olur. Bir kay\u0131t silinmek istendi\u011finde, Uniface varsay\u0131lan olarak ilgili yabanc\u0131 anahtarlarda (Foreign Key) bu kayd\u0131 referans alan ba\u015fka kay\u0131t olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. E\u011fer varsa, genellikle bir hata mesaj\u0131 ile i\u015flemi durdurur ve veri tutars\u0131zl\u0131\u011f\u0131n\u0131 \u00f6nler.\n    <\/p>\n<div class=\"expert-tip\">\n        Uzman \u0130pucu: Uniface geli\u015ftirirken, veritaban\u0131 seviyesindeki referans b\u00fct\u00fcnl\u00fc\u011f\u00fc k\u0131s\u0131tlamalar\u0131n\u0131 kullanmak genellikle en iyi yakla\u015f\u0131md\u0131r. Bu, hem performans\u0131 art\u0131r\u0131r hem de veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc uygulaman\u0131zdan ba\u011f\u0131ms\u0131z olarak garantiler. Ancak, Uniface&#8217;in kendi dahili kontrolleri, geli\u015fmi\u015f i\u015f kurallar\u0131 veya birden fazla veritaban\u0131 sisteminin kullan\u0131ld\u0131\u011f\u0131 karma\u015f\u0131k senaryolarda esneklik sa\u011flar.\n    <\/div>\n<p>\n        Uniface&#8217;in komponentlerinde \u00f6zel mant\u0131k (logic) yazarak da referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc daha hassas bir \u015fekilde y\u00f6netebilirsiniz. \u00d6rne\u011fin, bir kay\u0131t silinmeden \u00f6nce belirli ko\u015fullar\u0131n sa\u011flan\u0131p sa\u011flanmad\u0131\u011f\u0131n\u0131 kontrol eden <code>delete<\/code> triggered operation&#8217;lar tan\u0131mlayabilirsiniz. Bu, veritaban\u0131 seviyesinde <code>CASCADE DELETE<\/code> tan\u0131mlamak istemedi\u011finiz ancak yine de belirli ili\u015fkili kay\u0131tlar\u0131 silmek istedi\u011finiz durumlarda kullan\u0131\u015fl\u0131d\u0131r. Uniface&#8217;in g\u00fc\u00e7l\u00fc olay tabanl\u0131 programlama modeli, bu t\u00fcr \u00f6zelle\u015ftirmeler i\u00e7in geni\u015f imkanlar sunar. T\u00fcm bu yakla\u015f\u0131mlar\u0131n birle\u015fimi, Uniface 10.4 geli\u015ftiricilerine veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flama konusunda hem esneklik hem de sa\u011flaml\u0131k sunar. Geli\u015ftiriciler, uygulamalar\u0131n\u0131n spesifik ihtiya\u00e7lar\u0131na g\u00f6re en uygun stratejiyi se\u00e7ebilir ve uygulayabilirler.\n    <\/p>\n<p>\n        A\u015fa\u011f\u0131daki tabloda, Uniface&#8217;te referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flayan temel mekanizmalar\u0131 ve veritaban\u0131 e\u015fde\u011ferlerini g\u00f6rebilirsiniz:\n    <\/p>\n<table>\n<thead>\n<tr>\n<th>Uniface Mekanizmas\u0131<\/th>\n<th>A\u00e7\u0131klama<\/th>\n<th>Veritaban\u0131 Kar\u015f\u0131l\u0131\u011f\u0131<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td data-label=\"Uniface Mekanizmas\u0131\">Model Editor \u0130li\u015fki Tan\u0131mlar\u0131<\/td>\n<td data-label=\"A\u00e7\u0131klama\">Entity&#8217;ler aras\u0131 FK\/PK ili\u015fkilerinin g\u00f6rsel ve mant\u0131ksal tan\u0131m\u0131.<\/td>\n<td data-label=\"Veritaban\u0131 Kar\u015f\u0131l\u0131\u011f\u0131\">FOREIGN KEY K\u0131s\u0131tlamalar\u0131<\/td>\n<\/tr>\n<tr>\n<td data-label=\"Uniface Mekanizmas\u0131\">Uniface Veritaban\u0131 Adapt\u00f6rleri<\/td>\n<td data-label=\"A\u00e7\u0131klama\">Veritaban\u0131ndaki FK k\u0131s\u0131tlamalar\u0131n\u0131 okuma ve uygulama seviyesinde yans\u0131tma.<\/td>\n<td data-label=\"Veritaban\u0131 Kar\u015f\u0131l\u0131\u011f\u0131\">Veritaban\u0131 Motoru RI Uygulamas\u0131<\/td>\n<\/tr>\n<tr>\n<td data-label=\"Uniface Mekanizmas\u0131\"><code>checkoccurrence<\/code> Logic<\/td>\n<td data-label=\"A\u00e7\u0131klama\">Bir kayd\u0131n silinmeden \u00f6nce ili\u015fkili kay\u0131tlar\u0131n varl\u0131\u011f\u0131n\u0131 kontrol eden Uniface methodu.<\/td>\n<td data-label=\"Veritaban\u0131 Kar\u015f\u0131l\u0131\u011f\u0131\">ON DELETE RESTRICT\/NO ACTION<\/td>\n<\/tr>\n<tr>\n<td data-label=\"Uniface Mekanizmas\u0131\">Component Path Tan\u0131mlar\u0131<\/td>\n<td data-label=\"A\u00e7\u0131klama\">Birden fazla entity&#8217;nin bir komponent i\u00e7inde nas\u0131l ili\u015fkili oldu\u011funu belirleme.<\/td>\n<td data-label=\"Veritaban\u0131 Kar\u015f\u0131l\u0131\u011f\u0131\">JOIN Operasyonlar\u0131<\/td>\n<\/tr>\n<tr>\n<td data-label=\"Uniface Mekanizmas\u0131\">Triggered Operations (<code>delete<\/code> logic)<\/td>\n<td data-label=\"A\u00e7\u0131klama\">Silme \u00f6ncesi \u00f6zel i\u015f kurallar\u0131 uygulama veya ili\u015fkili kay\u0131tlar\u0131 manuel olarak i\u015fleme.<\/td>\n<td data-label=\"Veritaban\u0131 Kar\u015f\u0131l\u0131\u011f\u0131\">Veritaban\u0131 Triggerlar\u0131 (AFTER\/BEFORE DELETE)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Vaka Analizi: Bir E-Ticaret Uygulamas\u0131nda M\u00fc\u015fteri-Sipari\u015f \u0130li\u015fkisi<\/h3>\n<p>\n        Ger\u00e7ek d\u00fcnya senaryolar\u0131nda referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fcn ne kadar kritik oldu\u011funu anlamak i\u00e7in, pop\u00fcler bir e-ticaret uygulamas\u0131n\u0131 ele alal\u0131m. Bu uygulamada \u00fc\u00e7 ana varl\u0131k bulunmaktad\u0131r: M\u00fc\u015fteri (<code>CUSTOMERS<\/code>), Sipari\u015f (<code>ORDERS<\/code>) ve Sipari\u015f Kalemi (<code>ORDER_ITEMS<\/code>). Bu varl\u0131klar aras\u0131ndaki ili\u015fkiler \u015fu \u015fekildedir:\n    <\/p>\n<ul>\n<li>Her Sipari\u015f, bir M\u00fc\u015fteriye aittir (<code>ORDERS<\/code> tablosundaki <code>CUSTOMER_ID<\/code>, <code>CUSTOMERS<\/code> tablosundaki <code>CUSTOMER_ID<\/code>&#8216;ye referans verir).<\/li>\n<li>Her Sipari\u015f Kalemi, bir Sipari\u015fe aittir (<code>ORDER_ITEMS<\/code> tablosundaki <code>ORDER_ID<\/code>, <code>ORDERS<\/code> tablosundaki <code>ORDER_ID<\/code>&#8216;ye referans verir).<\/li>\n<\/ul>\n<p>\n        \u015eimdi senaryolar\u0131 d\u00fc\u015f\u00fcnelim:\n    <\/p>\n<ol>\n<li><strong>Bir M\u00fc\u015fteriyi Silme Giri\u015fimi:<\/strong> E\u011fer bir m\u00fc\u015fteri hesab\u0131n\u0131 silmeye \u00e7al\u0131\u015f\u0131rsan\u0131z, bu m\u00fc\u015fteriye ait hen\u00fcz tamamlanmam\u0131\u015f veya ge\u00e7mi\u015fte yap\u0131lm\u0131\u015f sipari\u015fler ne olacak? Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kurallar\u0131 olmadan, bu m\u00fc\u015fteri silindi\u011finde ilgili sipari\u015f kay\u0131tlar\u0131 &#8220;sahipsiz&#8221; kal\u0131r ve veritaban\u0131nda tutars\u0131zl\u0131\u011fa yol a\u00e7ar. Bu sipari\u015fler art\u0131k hangi m\u00fc\u015fteriye ait oldu\u011fu bilinemeyen, anlams\u0131z verilere d\u00f6n\u00fc\u015f\u00fcr. Bu durumda, uygulaman\u0131z raporlama hatalar\u0131 verebilir, veya daha da k\u00f6t\u00fcs\u00fc, bu sipari\u015fleri i\u015flemeye \u00e7al\u0131\u015fan di\u011fer mod\u00fcllerde beklenmedik hatalara neden olabilir. Uniface, bu t\u00fcr durumlar\u0131 veritaban\u0131 seviyesindeki k\u0131s\u0131tlamalarla veya kendi i\u00e7 kontrolleriyle engelleyerek veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc korur. Genellikle, m\u00fc\u015fteriye ait aktif sipari\u015fler varken silme i\u015flemi engellenir ve kullan\u0131c\u0131ya uygun bir uyar\u0131 mesaj\u0131 g\u00f6sterilir.<\/li>\n<li><strong>Bir Sipari\u015fi Silme Giri\u015fimi:<\/strong> Benzer \u015fekilde, bir sipari\u015fi silmeye kalkt\u0131\u011f\u0131n\u0131zda, o sipari\u015fe ait \u00fcr\u00fcn detaylar\u0131n\u0131 i\u00e7eren sipari\u015f kalemleri ne olacak? E\u011fer sipari\u015f kalemleri otomatik olarak silinmezse, veritaban\u0131n\u0131zda art\u0131k var olmayan bir sipari\u015fe ait kalemler kal\u0131r. Bu durum da tutars\u0131zl\u0131\u011fa yol a\u00e7ar. Bu senaryoda, veritaban\u0131nda <code>ORDERS<\/code> ve <code>ORDER_ITEMS<\/code> tablolar\u0131 aras\u0131nda <code>CASCADE DELETE<\/code> ili\u015fkisi tan\u0131mlanm\u0131\u015fsa, Uniface bu ili\u015fkiyi otomatik olarak kullan\u0131r ve sipari\u015f silindi\u011finde ilgili t\u00fcm sipari\u015f kalemlerini de siler. E\u011fer <code>CASCADE DELETE<\/code> tan\u0131ml\u0131 de\u011filse, Uniface veya uygulama seviyesindeki mant\u0131k, silme i\u015flemini engelleyebilir veya sipari\u015f kalemlerinin manuel olarak silinmesini gerektirebilir.<\/li>\n<\/ol>\n<p>\n        Bu vaka analizleri, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fcn sadece veritaban\u0131 y\u00f6neticileri i\u00e7in de\u011fil, ayn\u0131 zamanda uygulama geli\u015ftiricileri i\u00e7in de ne kadar \u00f6nemli oldu\u011funu g\u00f6stermektedir. Uniface 10.4 geli\u015ftiricileri, bu ili\u015fkileri modelleme ortam\u0131nda do\u011fru bir \u015fekilde tan\u0131mlayarak ve gerekti\u011finde uygulama seviyesinde ek mant\u0131k ekleyerek, veri tutars\u0131zl\u0131klar\u0131n\u0131 ba\u015ftan \u00f6nleyebilir ve daha g\u00fcvenilir, hatas\u0131z uygulamalar olu\u015fturabilirler. Bu sayede, son kullan\u0131c\u0131lar da tutarl\u0131 ve do\u011fru verilerle kar\u015f\u0131la\u015farak daha iyi bir deneyim ya\u015farlar. Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc, modern yaz\u0131l\u0131m geli\u015ftirmede vazge\u00e7ilmez bir unsurdur.\n    <\/p>\n<h2>Uniface Komponentlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fc Uygulamalar\u0131: Ad\u0131m Ad\u0131m<\/h2>\n<p>\n        Uniface 10.4&#8217;te referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc uygulaman\u0131n en temel yolu, Model Editor&#8217;da Entity&#8217;ler aras\u0131ndaki ili\u015fkileri do\u011fru bir \u015fekilde tan\u0131mlamakt\u0131r. Bu ad\u0131m, veritaban\u0131 \u015femas\u0131n\u0131 olu\u015fturman\u0131n ve Uniface&#8217;in bu \u015femay\u0131 anlamas\u0131n\u0131n ilk basama\u011f\u0131d\u0131r. Ard\u0131ndan, bu ili\u015fkileri komponentlerinizde kullanarak veri manip\u00fclasyonlar\u0131n\u0131 g\u00fcvence alt\u0131na alabilirsiniz.\n    <\/p>\n<p>\n        Ad\u0131m ad\u0131m bir \u00f6rnekle ilerleyelim: Bir &#8220;Departmanlar&#8221; (<code>DEPARTMENTS<\/code>) tablosu ve &#8220;\u00c7al\u0131\u015fanlar&#8221; (<code>EMPLOYEES<\/code>) tablosu oldu\u011funu varsayal\u0131m. Her \u00e7al\u0131\u015fan\u0131n bir departman\u0131 vard\u0131r.\n    <\/p>\n<ol>\n<li><strong>Model Editor&#8217;da \u0130li\u015fkileri Tan\u0131mlama:<\/strong>\n<p>\u00d6ncelikle, Uniface Model Editor&#8217;\u0131 a\u00e7\u0131n. \u0130ki Entity olu\u015fturun: <code>DEPARTMENTS<\/code> ve <code>EMPLOYEES<\/code>.\n            <\/p>\n<ul>\n<li><strong>DEPARTMENTS Entity&#8217;si:<\/strong>\n<ul>\n<li><code>DEPT_ID<\/code> (Primary Key, Numeric)<\/li>\n<li><code>DEPT_NAME<\/code> (String)<\/li>\n<\/ul>\n<\/li>\n<li><strong>EMPLOYEES Entity&#8217;si:<\/strong>\n<ul>\n<li><code>EMP_ID<\/code> (Primary Key, Numeric)<\/li>\n<li><code>EMP_NAME<\/code> (String)<\/li>\n<li><code>DEPT_ID<\/code> (Numeric &#8211; Bu, <code>DEPARTMENTS<\/code> tablosundaki <code>DEPT_ID<\/code>&#8216;ye referans verecek Foreign Key&#8217;imiz olacak)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\n                \u015eimdi <code>EMPLOYEES.DEPT_ID<\/code> alan\u0131n\u0131 <code>DEPARTMENTS.DEPT_ID<\/code> alan\u0131na ba\u011flayarak bir ili\u015fki olu\u015fturun. Bu ili\u015fki, <code>EMPLOYEES<\/code> entity&#8217;sinin bir <code>FOREIGN KEY<\/code> i\u00e7erdi\u011fini belirtir. \u0130li\u015fkinin \u00f6zelliklerinde, silme kurallar\u0131n\u0131 (\u00f6rne\u011fin, <code>Restrict Delete<\/code> veya <code>Cascade Delete<\/code>) veritaban\u0131n\u0131zdaki k\u0131s\u0131tlamalarla senkronize olarak ayarlayabilirsiniz. Uniface genellikle bu ayarlar\u0131 veritaban\u0131ndan otomatik olarak alg\u0131lar, ancak manuel kontrol de m\u00fcmk\u00fcnd\u00fcr.\n            <\/p>\n<\/li>\n<li><strong>Komponent Olu\u015fturma ve Entity Yollar\u0131 Belirleme:<\/strong>\n<p>\n                Yeni bir Uniface Komponenti (\u00f6rne\u011fin bir Form) olu\u015fturun. Bu forma hem <code>DEPARTMENTS<\/code> hem de <code>EMPLOYEES<\/code> entity&#8217;lerini s\u00fcr\u00fckleyip b\u0131rak\u0131n. Uniface, Model Editor&#8217;da tan\u0131mlad\u0131\u011f\u0131n\u0131z ili\u015fkiye dayanarak bu iki entity aras\u0131nda otomatik olarak bir &#8220;path&#8221; (yol) olu\u015fturacakt\u0131r. Bu yol, iki entity aras\u0131ndaki ba\u011flant\u0131y\u0131 temsil eder.\n            <\/p>\n<p>\n                Uniface Komponent Editor&#8217;da entitylerinizi a\u015fa\u011f\u0131daki gibi ba\u011flad\u0131\u011f\u0131n\u0131z\u0131 d\u00fc\u015f\u00fcnelim:\n            <\/p>\n<pre><code>\n; DEPARTMENTS entity'si ana entity olarak\n; EMPLOYEES entity'si DEPARTMENTS'a ba\u011fl\u0131 olarak konumland\u0131r\u0131l\u0131r.\n; Uniface bu ili\u015fkiyi otomatik olarak tan\u0131r.\n\n; Manuel olarak path olu\u015fturmak i\u00e7in:\n; $ent(\"EMPLOYEES\").path = \"DEPARTMENTS\"\n            <\/pre>\n<p><\/code><\/p>\n<p>\n                Bu kod blo\u011fu, <code>EMPLOYEES<\/code> entity'sinin <code>DEPARTMENTS<\/code> entity'si ile ili\u015fkili oldu\u011funu belirtir. Genellikle, Uniface g\u00f6rsel olarak bu yolu kendili\u011finden kurar, ancak kod ile de y\u00f6netilebilir.\n            <\/p>\n<\/li>\n<li><strong>Veri Ekleme ve G\u00fcncelleme \u0130\u015flemleri:<\/strong>\n<p>\n                Bir kullan\u0131c\u0131 bir \u00e7al\u0131\u015fan kayd\u0131 eklerken, <code>DEPT_ID<\/code> alan\u0131na ge\u00e7erli bir departman ID'si girmesi gerekir. E\u011fer kullan\u0131c\u0131 var olmayan bir <code>DEPT_ID<\/code> girerse, Uniface (veya alttaki veritaban\u0131), bu i\u015flemi referans b\u00fct\u00fcnl\u00fc\u011f\u00fc ihlali olarak alg\u0131lar ve engeller. Kullan\u0131c\u0131ya ilgili bir hata mesaj\u0131 g\u00f6sterilir. Bu kontrol, Uniface'in <code>store<\/code> operasyonu s\u0131ras\u0131nda otomatik olarak ger\u00e7ekle\u015fir.\n            <\/p>\n<\/li>\n<li><strong>Veri Silme \u0130\u015flemleri ve Kontroller:<\/strong>\n<p>\n                En kritik k\u0131s\u0131m silme i\u015flemidir. Diyelim ki bir kullan\u0131c\u0131 bir departman\u0131 silmeye \u00e7al\u0131\u015f\u0131yor.\n            <\/p>\n<ul>\n<li>\n                    <strong>Varsay\u0131lan Davran\u0131\u015f (Restrict Delete):<\/strong> E\u011fer <code>DEPARTMENTS<\/code> entity'sinden bir kay\u0131t silinmek istenir ve bu departmana ba\u011fl\u0131 \u00e7al\u0131\u015fanlar (<code>EMPLOYEES<\/code> entity'sinde ilgili <code>DEPT_ID<\/code>'ye sahip kay\u0131tlar) varsa, Uniface (veya veritaban\u0131) bu silme i\u015flemini engelleyecektir. Kullan\u0131c\u0131ya, \"Bu departmana ba\u011fl\u0131 \u00e7al\u0131\u015fanlar oldu\u011fu i\u00e7in silinemez\" gibi bir hata mesaj\u0131 g\u00f6sterilir. Bu, veri tutars\u0131zl\u0131\u011f\u0131n\u0131 \u00f6nlemenin en g\u00fcvenli yoludur. Bu kontrol i\u00e7in genellikle \u00f6zel bir kod yazmaya gerek kalmaz, Uniface bu durumu otomatik olarak y\u00f6netir.\n                <\/li>\n<li>\n                    <strong>Uygulama Seviyesi Kontrol (<code>checkoccurrence<\/code>):<\/strong> Bazen veritaban\u0131 seviyesinde kat\u0131 <code>Restrict Delete<\/code> yerine, uygulama i\u00e7inde daha esnek bir kontrol isteyebilirsiniz. Uniface'in <code>checkoccurrence<\/code> operat\u00f6r\u00fc, bir kayd\u0131n silinmeden \u00f6nce ili\u015fkili kay\u0131tlar\u0131n olup olmad\u0131\u011f\u0131n\u0131 kontrol etmenizi sa\u011flar. Bu operat\u00f6r, genellikle bir <code>delete<\/code> triggered operation'\u0131 i\u00e7inde kullan\u0131l\u0131r.\n                <\/li>\n<\/ul>\n<p>\n                \u00d6rnek bir <code>delete<\/code> triggered operation kod blo\u011fu:\n            <\/p>\n<pre><code>\n; DEPARTMENTS Entity'sinin delete triggered operation'\u0131 i\u00e7inde\n; Bu \u00f6rnekte, e\u011fer departmana ba\u011fl\u0131 \u00e7al\u0131\u015fan varsa silmeyi engelliyoruz.\n\nvariables\n    numeric lvFoundEmployees\n\n; \u0130lgili departman ID'si ile EMPLOYEES tablosunda kay\u0131t ar\u0131yoruz\n; $count, ilgili ko\u015fulu sa\u011flayan kay\u0131t say\u0131s\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr\nlvFoundEmployees = $count($ent(\"EMPLOYEES\"), \"DEPT_ID=$field(\"DEPT_ID\")\")\n\nif (lvFoundEmployees > 0)\n    ; Hata mesaj\u0131 g\u00f6ster ve i\u015flemi geri al\n    message \"Bu departmana ba\u011fl\u0131 {$$lvFoundEmployees} \u00e7al\u0131\u015fan bulunmaktad\u0131r. Silme i\u015flemi iptal edildi.\"\n    reject\nelse\n    ; \u00c7al\u0131\u015fan yoksa silme i\u015flemine devam et\n    accept\nendif\n            <\/pre>\n<p><\/code><\/p>\n<p>\n                Bu kod, bir departman\u0131 silmeden \u00f6nce o departmana ait \u00e7al\u0131\u015fan olup olmad\u0131\u011f\u0131n\u0131 kontrol eder. E\u011fer \u00e7al\u0131\u015fan varsa, silme i\u015flemini reddeder ve kullan\u0131c\u0131ya bilgi verir. Bu, veritaban\u0131 seviyesindeki referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc uygulaman\u0131z\u0131n i\u015f kurallar\u0131yla birle\u015ftirmenin g\u00fczel bir \u00f6rne\u011fidir.\n            <\/p>\n<\/li>\n<\/ol>\n<p>\n        G\u00f6rd\u00fc\u011f\u00fcn\u00fcz gibi, Uniface 10.4, hem veritaban\u0131 k\u0131s\u0131tlamalar\u0131n\u0131 kullanarak hem de uygulama seviyesinde detayl\u0131 kontroller sunarak referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc y\u00f6netmek i\u00e7in g\u00fc\u00e7l\u00fc ara\u00e7lar sa\u011flar. Bu ara\u00e7lar\u0131 do\u011fru bir \u015fekilde kullanarak, veri tutars\u0131zl\u0131klar\u0131n\u0131 en aza indirebilir ve daha sa\u011flam uygulamalar geli\u015ftirebilirsiniz.\n    <\/p>\n<h2>Performans ve Hata Y\u00f6netimi \u0130\u00e7in \u0130pu\u00e7lar\u0131<\/h2>\n<p>\n        Referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc uygulamak, veri tutarl\u0131l\u0131\u011f\u0131 a\u00e7\u0131s\u0131ndan kritik \u00f6neme sahip olsa da, bu durumun performans\u0131 ve hata y\u00f6netimini nas\u0131l etkileyece\u011fini anlamak da bir o kadar \u00f6nemlidir. \u00d6zellikle b\u00fcy\u00fck veri setleriyle \u00e7al\u0131\u015f\u0131rken veya y\u00fcksek i\u015flem hacmine sahip sistemlerde, referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kontrollerinin do\u011fru bir \u015fekilde yap\u0131land\u0131r\u0131lmas\u0131, uygulaman\u0131z\u0131n genel yan\u0131t s\u00fcresini ve g\u00fcvenilirli\u011fini do\u011frudan etkiler.\n    <\/p>\n<h3>Performans \u0130pu\u00e7lar\u0131:<\/h3>\n<ul>\n<li>\n            <strong>Veritaban\u0131 Seviyesi K\u0131s\u0131tlamalar\u0131 ve \u0130ndeksleme:<\/strong> Uniface, veritaban\u0131 seviyesindeki Foreign Key k\u0131s\u0131tlamalar\u0131n\u0131 kullanma yetene\u011fine sahiptir. Bu, Uniface'in kendi i\u00e7 kontrolleri yerine veritaban\u0131 y\u00f6netim sisteminin (VTYS) optimize edilmi\u015f algoritmalar\u0131n\u0131 kullanmas\u0131 anlam\u0131na gelir. Genellikle bu, daha h\u0131zl\u0131 kontroller sa\u011flar. Ayr\u0131ca, Foreign Key s\u00fctunlar\u0131na indeks eklemek, ili\u015fkili tablolar aras\u0131nda yap\u0131lan kontrol sorgular\u0131n\u0131n performans\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131r\u0131r. Bir yabanc\u0131 anahtar (Foreign Key) s\u00fctununa indeks eklemedi\u011finizde, ili\u015fkili bir tabloya yap\u0131lan her kontrol i\u00e7in veritaban\u0131 t\u00fcm tabloyu taramak zorunda kal\u0131r, bu da \u00f6zellikle b\u00fcy\u00fck tablolarda yava\u015flamaya neden olur. \u0130ndeksler, bu aramalar\u0131 h\u0131zland\u0131rarak performans\u0131 art\u0131r\u0131r.<\/p>\n<pre><code>\n-- SQL Server \u00f6rne\u011fi:\nCREATE INDEX IX_EMPLOYEES_DEPTID ON EMPLOYEES (DEPT_ID);\n\n-- Oracle \u00f6rne\u011fi:\nCREATE INDEX IX_EMPLOYEES_DEPTID ON EMPLOYEES (DEPT_ID);\n            <\/pre>\n<p><\/code><\/p>\n<p>\n                Bu SQL \u00f6rnekleri, <code>EMPLOYEES<\/code> tablosundaki <code>DEPT_ID<\/code> s\u00fctununa bir indeks ekler. Bu sayede, bir departman silinirken veya bir \u00e7al\u0131\u015fan eklendi\u011finde yap\u0131lan referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kontrolleri \u00e7ok daha h\u0131zl\u0131 ger\u00e7ekle\u015fir.\n            <\/p>\n<\/li>\n<li>\n            <strong>Gereksiz Kontrollerden Ka\u00e7\u0131nma:<\/strong> E\u011fer veritaban\u0131n\u0131zda zaten sa\u011flam referans b\u00fct\u00fcnl\u00fc\u011f\u00fc k\u0131s\u0131tlamalar\u0131 varsa, Uniface'te ayn\u0131 kontrolleri uygulama seviyesinde tekrar tekrar yapmak gereksiz CPU d\u00f6ng\u00fclerine ve yava\u015flamalara neden olabilir. Uniface'in varsay\u0131lan davran\u0131\u015flar\u0131 \u00e7o\u011fu zaman yeterlidir. Ancak, spesifik i\u015f kurallar\u0131 i\u00e7in uygulama seviyesi kontroller (<code>checkoccurrence<\/code> veya \u00f6zel trigger'lar) yazman\u0131z gerekti\u011finde, bunlar\u0131 sadece mutlak gerekli oldu\u011fu yerlerde kullan\u0131n ve m\u00fcmk\u00fcn oldu\u011funca optimize edin.\n        <\/li>\n<li>\n            <strong>Transaction Y\u00f6netimi:<\/strong> \u00c7ok say\u0131da ili\u015fkili kayd\u0131n ayn\u0131 anda manip\u00fcle edildi\u011fi durumlarda, t\u00fcm i\u015flemlerin tek bir veritaban\u0131 transaction'\u0131 i\u00e7inde ger\u00e7ekle\u015fti\u011finden emin olun. Bu, hem veri tutarl\u0131l\u0131\u011f\u0131n\u0131 garanti eder hem de performans\u0131 art\u0131rabilir, \u00e7\u00fcnk\u00fc veritaban\u0131, commit edilene kadar t\u00fcm de\u011fi\u015fiklikleri tek bir birim olarak ele al\u0131r. Uniface'in <code>starttransaction<\/code>, <code>commit<\/code> ve <code>rollback<\/code> operasyonlar\u0131n\u0131 do\u011fru kullanmak bu noktada \u00f6nemlidir.\n        <\/li>\n<\/ul>\n<h3>Hata Y\u00f6netimi \u0130pu\u00e7lar\u0131:<\/h3>\n<ul>\n<li>\n            <strong>Kullan\u0131c\u0131 Dostu Hata Mesajlar\u0131:<\/strong> Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc ihlalleri meydana geldi\u011finde, Uniface genellikle standart veritaban\u0131 hata kodlar\u0131n\u0131 d\u00f6nd\u00fcr\u00fcr. Bu kodlar son kullan\u0131c\u0131lar i\u00e7in anla\u015f\u0131lmaz olabilir. Bu hatalar\u0131 yakalay\u0131n ve kullan\u0131c\u0131 dostu, a\u00e7\u0131klay\u0131c\u0131 mesajlara d\u00f6n\u00fc\u015ft\u00fcr\u00fcn. \u00d6rne\u011fin, \"ORA-02292\" yerine \"Bu departmana ba\u011fl\u0131 \u00e7al\u0131\u015fanlar oldu\u011fu i\u00e7in silme i\u015flemi ger\u00e7ekle\u015ftirilemiyor.\" mesaj\u0131n\u0131 g\u00f6stermek \u00e7ok daha faydal\u0131d\u0131r.<\/p>\n<pre><code>\n; Uniface delete logic'inde veya bir d\u00fc\u011fme operasyonunda\n; Bir departman\u0131 silme denemesi\n\nclearerrors\ndelete DEPARTMENTS\n\nif ($status = -1) ; Hata olu\u015ftuysa\n    ; $errorcode ve $errormessage sistem de\u011fi\u015fkenlerini kontrol edin\n    if ($errorcode = 2292) ; Oracle ORA-02292 (child record found)\n        message \"Bu departmana ba\u011fl\u0131 \u00e7al\u0131\u015fanlar bulunmaktad\u0131r. L\u00fctfen \u00f6nce \u00e7al\u0131\u015fanlar\u0131 siliniz.\"\n    else\n        message \"Silme i\u015flemi s\u0131ras\u0131nda bir hata olu\u015ftu: \" $errormessage\n    endif\n    reject ; \u0130\u015flemi geri al\nelse\n    message \"Departman ba\u015far\u0131yla silindi.\"\n    accept ; \u0130\u015flemi onayla\nendif\n            <\/pre>\n<p><\/code>\n        <\/li>\n<li>\n            <strong>G\u00fcnl\u00fckleme (Logging):<\/strong> \u00dcretim ortam\u0131nda ortaya \u00e7\u0131kan referans b\u00fct\u00fcnl\u00fc\u011f\u00fc hatalar\u0131n\u0131 detayl\u0131 bir \u015fekilde g\u00fcnl\u00fckleyin (loglay\u0131n). Bu, sorunlar\u0131n k\u00f6k nedenini belirlemenize ve gelecekteki olas\u0131 problemleri \u00f6nlemenize yard\u0131mc\u0131 olur. Hata kodu, mesaj\u0131, i\u015flemi ger\u00e7ekle\u015ftiren kullan\u0131c\u0131 ve zaman damgas\u0131 gibi bilgiler g\u00fcnl\u00fcklerde yer almal\u0131d\u0131r.\n        <\/li>\n<li>\n            <strong>\u00d6nleyici Kontroller:<\/strong> Hata mesajlar\u0131 g\u00f6stermek yerine, baz\u0131 durumlarda \u00f6nleyici kontroller yapmak daha iyi bir kullan\u0131c\u0131 deneyimi sunar. \u00d6rne\u011fin, bir departman silme d\u00fc\u011fmesini, o departmana ba\u011fl\u0131 \u00e7al\u0131\u015fanlar oldu\u011fu s\u00fcrece pasif (disabled) tutmak veya silme i\u015fleminden \u00f6nce bir onay penceresiyle ili\u015fkili kay\u0131tlar\u0131n varl\u0131\u011f\u0131n\u0131 kullan\u0131c\u0131ya bildirmek gibi yakla\u015f\u0131mlar sergilenebilir. Bu t\u00fcr bir yakla\u015f\u0131m, hata olu\u015fmadan \u00f6nce kullan\u0131c\u0131y\u0131 bilgilendirerek, sinir bozucu hata mesajlar\u0131n\u0131n \u00f6n\u00fcne ge\u00e7er.\n        <\/li>\n<\/ul>\n<p>\n        Uniface 10.4 geli\u015ftiricileri olarak, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sadece uygulamakla kalmay\u0131p, ayn\u0131 zamanda performans ve hata y\u00f6netimini de g\u00f6z \u00f6n\u00fcnde bulundurarak sistemlerimizi daha verimli ve kullan\u0131c\u0131 dostu hale getirebiliriz. Bu stratejiler, uzun vadede uygulaman\u0131z\u0131n s\u00fcrd\u00fcr\u00fclebilirli\u011fini ve ba\u015far\u0131s\u0131n\u0131 \u00f6nemli \u00f6l\u00e7\u00fcde art\u0131racakt\u0131r.\n    <\/p>\n<h2>Geli\u015fmi\u015f Referans B\u00fct\u00fcnl\u00fc\u011f\u00fc Stratejileri ve K\u0131s\u0131tlamalar\u0131<\/h2>\n<p>\n        Uniface 10.4 ile \u00e7al\u0131\u015f\u0131rken, standart referans b\u00fct\u00fcnl\u00fc\u011f\u00fc yakla\u015f\u0131mlar\u0131n\u0131n \u00f6tesine ge\u00e7en durumlarla kar\u015f\u0131la\u015fabilirsiniz. Bu, \u00f6zellikle karma\u015f\u0131k i\u015f mant\u0131klar\u0131na sahip, birden fazla veritaban\u0131 sistemini kullanan veya y\u00fcksek esneklik gerektiren projelerde kendini g\u00f6sterir. Geli\u015fmi\u015f stratejiler ve bunlar\u0131n getirdi\u011fi k\u0131s\u0131tlamalar\u0131 anlamak, uygulaman\u0131z\u0131n sa\u011flaml\u0131\u011f\u0131n\u0131 ve \u00f6l\u00e7eklenebilirli\u011fini art\u0131rman\u0131za yard\u0131mc\u0131 olacakt\u0131r.\n    <\/p>\n<h3>Geli\u015fmi\u015f Stratejiler:<\/h3>\n<ul>\n<li>\n            <strong>Ertelenmi\u015f Referans B\u00fct\u00fcnl\u00fc\u011f\u00fc (Deferred Referential Integrity):<\/strong> Baz\u0131 veritaban\u0131 sistemleri (\u00f6rne\u011fin Oracle), referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kontrollerini bir i\u015flemin (transaction) sonunda erteleme se\u00e7ene\u011fi sunar. Bu, \u00f6zellikle b\u00fcy\u00fck veri y\u00fcklemeleri veya ili\u015fkili bir\u00e7ok kayd\u0131n ayn\u0131 anda manip\u00fcle edildi\u011fi senaryolarda kullan\u0131\u015fl\u0131d\u0131r. E\u011fer bir transaction i\u00e7inde birden fazla tabloya de\u011fi\u015fiklik yap\u0131yorsan\u0131z ve bu de\u011fi\u015fiklikler ara ad\u0131mlarda referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ge\u00e7ici olarak bozuyorsa, deferred kontrol, t\u00fcm transaction ba\u015far\u0131yla tamamlanana kadar bu kurallar\u0131n uygulanmas\u0131n\u0131 bekler. Uniface, adapt\u00f6rleri arac\u0131l\u0131\u011f\u0131yla bu veritaban\u0131 \u00f6zelliklerini kullanabilir. Bu, geli\u015ftiriciye i\u015flem s\u0131ras\u0131nda daha fazla esneklik tan\u0131r, ancak ayn\u0131 zamanda transaction'\u0131n do\u011fru y\u00f6netilmesi sorumlulu\u011funu da beraberinde getirir.<\/p>\n<pre><code>\n; Uniface i\u00e7inde transaction y\u00f6netimi \u00f6rne\u011fi\n; (Veritaban\u0131 deferred RI destekliyorsa)\n\nstarttransaction\n\n; Ge\u00e7ici olarak referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc bozabilecek i\u015flemler\n; \u00d6rne\u011fin, \u00f6nce ana kayd\u0131 silip, sonra ili\u015fkili kay\u0131tlar\u0131 g\u00fcncellemek\n\ncall CUSTOM_DELETE_PARENT_RECORD()\ncall CUSTOM_UPDATE_CHILD_RECORDS()\n\n; E\u011fer t\u00fcm i\u015flemler ba\u015far\u0131l\u0131ysa\nif ($status = 0)\n    commit\nelse\n    ; Hata durumunda t\u00fcm de\u011fi\u015fiklikleri geri al\n    rollback\nendif\n            <\/pre>\n<p><\/code>\n        <\/li>\n<li>\n            <strong>Soft Delete Yakla\u015f\u0131mlar\u0131:<\/strong> Ger\u00e7ek silme i\u015flemleri yerine, kay\u0131tlar\u0131 pasif duruma getirme (soft delete) stratejisi, bir\u00e7ok uygulamada referans b\u00fct\u00fcnl\u00fc\u011f\u00fc sorunlar\u0131n\u0131 ortadan kald\u0131rman\u0131n pop\u00fcler bir yoludur. Bu y\u00f6ntemde, bir tablonun <code>IS_DELETED<\/code> veya <code>STATUS<\/code> gibi bir s\u00fctunu bulunur. Bir kay\u0131t \"silinmek\" istendi\u011finde, bu s\u00fctunun de\u011feri g\u00fcncellenir (\u00f6rne\u011fin <code>TRUE<\/code> veya <code>'PASSIVE'<\/code> yap\u0131l\u0131r) ancak kay\u0131t fiziksel olarak silinmez. Bu, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc ihlal etmeden ilgili kay\u0131tlar\u0131n hala var olmas\u0131n\u0131 sa\u011flar ve ge\u00e7mi\u015f verilere eri\u015fim ihtiyac\u0131n\u0131 korur. Uniface uygulamalar\u0131, veri sorgular\u0131nda bu <code>IS_DELETED<\/code> alan\u0131n\u0131 filtreleyerek yaln\u0131zca aktif kay\u0131tlar\u0131 g\u00f6sterecek \u015fekilde tasarlanabilir. Bu yakla\u015f\u0131m, ge\u00e7mi\u015f veriye dayal\u0131 raporlamalar i\u00e7in de b\u00fcy\u00fck fayda sa\u011flar.\n        <\/li>\n<li>\n            <strong>\u00c7apraz Veritaban\u0131 veya Entegre Sistemlerde RI:<\/strong> E\u011fer uygulaman\u0131z birden fazla farkl\u0131 veritaban\u0131 sistemini veya harici sistemleri (\u00f6rne\u011fin bir Web Servis) kullan\u0131yorsa, referans b\u00fct\u00fcnl\u00fc\u011f\u00fc y\u00f6netimi daha karma\u015f\u0131k hale gelir. Bu durumda, Uniface'in sadece tek bir veritaban\u0131n\u0131n de\u011fil, t\u00fcm entegre sistemin b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak i\u00e7in uygulama seviyesinde daha kapsaml\u0131 kontroller ve senkronizasyon mekanizmalar\u0131 geli\u015ftirmeniz gerekebilir. Bu, genellikle Uniface trigger'lar\u0131, \u00f6zel servisler veya i\u015f ak\u0131\u015flar\u0131 arac\u0131l\u0131\u011f\u0131yla ger\u00e7ekle\u015ftirilir. Bu senaryolarda veri tutarl\u0131l\u0131\u011f\u0131n\u0131 sa\u011flamak i\u00e7in titiz bir planlama ve test s\u00fcreci gereklidir.<\/li>\n<li>\n            <strong>Karma\u015f\u0131k \u0130\u015f Kurallar\u0131 \u0130\u00e7in Procs (Procedural Logic):<\/strong> Bazen, basit Foreign Key k\u0131s\u0131tlamalar\u0131, uygulaman\u0131z\u0131n karma\u015f\u0131k i\u015f kurallar\u0131n\u0131 kar\u015f\u0131lamaz. \u00d6rne\u011fin, bir \"Sipari\u015f\" sadece belirli ko\u015fullar (\u00f6rne\u011fin, \u00f6deme tamamland\u0131ysa ve stokta varsa) alt\u0131nda silinebilir. Bu t\u00fcr senaryolarda, Uniface'in procedural logic (proc) yetenekleri devreye girer. Entity'lerin <code>delete<\/code> triggered operation'lar\u0131nda veya component operasyonlar\u0131nda \u00f6zel kod yazarak bu kurallar\u0131 uygulayabilirsiniz.<\/p>\n<pre><code>\n; EMPLOYEES entity'sinin \"delete\" triggered operation'\u0131\n; \u00c7al\u0131\u015fan\u0131n maa\u015f\u0131 10000'den y\u00fcksekse silmeyi engelle\n\nvariables\n    numeric lvSalary\n\n; Mevcut \u00e7al\u0131\u015fan\u0131n maa\u015f\u0131n\u0131 al\nlvSalary = $field(\"SALARY\")\n\nif (lvSalary > 10000)\n    message \"Y\u00fcksek maa\u015fl\u0131 \u00e7al\u0131\u015fanlar do\u011frudan silinemez. L\u00fctfen \u0130K departman\u0131yla ileti\u015fime ge\u00e7in.\"\n    reject\nelse\n    ; Standart referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kontrol\u00fc devam edecek\n    accept\nendif\n            <\/pre>\n<p><\/code><\/p>\n<p>\n                Bu \u00f6rnek, veritaban\u0131 veya Uniface'in temel referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kontrol\u00fcn\u00fcn \u00f6tesine ge\u00e7en \u00f6zel bir i\u015f kural\u0131n\u0131 g\u00f6stermektedir.\n            <\/p>\n<\/li>\n<\/ul>\n<h3>K\u0131s\u0131tlamalar ve Dikkat Edilmesi Gerekenler:<\/h3>\n<ul>\n<li>\n            <strong>Performans Maliyeti:<\/strong> Uygulama seviyesinde a\u015f\u0131r\u0131ya ka\u00e7an referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kontrolleri, performans\u0131 olumsuz etkileyebilir. Her veri manip\u00fclasyonunda birden fazla sorgu veya kontrol \u00e7al\u0131\u015ft\u0131rmak, \u00f6zellikle b\u00fcy\u00fck veri k\u00fcmeleri \u00fczerinde \u00e7al\u0131\u015f\u0131rken yava\u015flamalara yol a\u00e7abilir. Bu nedenle, VTYS'nin yerle\u015fik yeteneklerini m\u00fcmk\u00fcn oldu\u011funca kullanmaya \u00f6ncelik vermek \u00f6nemlidir.\n        <\/li>\n<li>\n            <strong>Karma\u015f\u0131kl\u0131k:<\/strong> Geli\u015fmi\u015f referans b\u00fct\u00fcnl\u00fc\u011f\u00fc stratejileri, uygulaman\u0131n kod taban\u0131n\u0131 ve bak\u0131m\u0131n\u0131 daha karma\u015f\u0131k hale getirebilir. \u00d6zellikle \u00e7apraz sistem entegrasyonlar\u0131, hata ay\u0131klama ve s\u00fcrd\u00fcrme a\u00e7\u0131s\u0131ndan zorluklar yaratabilir. Bu nedenle, her zaman en basit ve etkili \u00e7\u00f6z\u00fcm\u00fc tercih etmek, gereksiz karma\u015f\u0131kl\u0131ktan ka\u00e7\u0131nmak esast\u0131r.\n        <\/li>\n<li>\n            <strong>Tutarl\u0131l\u0131k Zorluklar\u0131:<\/strong> Birden fazla sistem aras\u0131nda referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc sa\u011flamak, her zaman senkronizasyon ve veri tutarl\u0131l\u0131\u011f\u0131 riskleri ta\u015f\u0131r. Da\u011f\u0131t\u0131lm\u0131\u015f i\u015flemler veya yar\u0131-tutarl\u0131 (eventual consistency) modeller, veri b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc y\u00f6netirken farkl\u0131 yakla\u015f\u0131mlar gerektirebilir ve bu da geli\u015ftirme s\u00fcrecini zorla\u015ft\u0131r\u0131r.<\/li>\n<\/ul>\n<p>\n        Uniface 10.4 geli\u015ftiricileri, bu geli\u015fmi\u015f stratejileri ve beraberindeki k\u0131s\u0131tlamalar\u0131 g\u00f6z \u00f6n\u00fcnde bulundurarak, uygulamalar\u0131n\u0131n uzun \u00f6m\u00fcrl\u00fc ve performansl\u0131 olmas\u0131n\u0131 sa\u011flayabilirler. Do\u011fru dengeyi bulmak, uygulaman\u0131n spesifik ihtiya\u00e7lar\u0131na ve kullan\u0131lacak teknolojilere g\u00f6re dikkatli bir de\u011ferlendirme gerektirir.\n    <\/p>\n<h2>Sonu\u00e7<\/h2>\n<p>\n        Uniface 10.4 geli\u015ftiricileri i\u00e7in referans b\u00fct\u00fcnl\u00fc\u011f\u00fc, sadece teknik bir kavram olman\u0131n \u00f6tesinde, sa\u011flam, g\u00fcvenilir ve kullan\u0131c\u0131 dostu uygulamalar olu\u015fturman\u0131n temel ta\u015f\u0131d\u0131r. Bu makalede, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fcn ne oldu\u011fu, neden bu kadar \u00f6nemli oldu\u011fu ve Uniface ortam\u0131nda nas\u0131l etkin bir \u015fekilde y\u00f6netilebilece\u011fi konular\u0131n\u0131 ele ald\u0131k. Temel d\u00fczeyde veritaban\u0131 k\u0131s\u0131tlamalar\u0131n\u0131n g\u00fcc\u00fcnden yararlanmaktan, uygulama seviyesinde \u00f6zel i\u015f kurallar\u0131n\u0131 uygulamaya kadar \u00e7e\u015fitli y\u00f6ntemleri inceledik.\n    <\/p>\n<p>\n        G\u00f6rd\u00fck ki, Uniface'in model tabanl\u0131 yakla\u015f\u0131m\u0131, entity'ler aras\u0131 ili\u015fkilerin kolayca tan\u0131mlanmas\u0131na olanak tan\u0131rken, geli\u015fmi\u015f hata y\u00f6netimi ve performans ipu\u00e7lar\u0131 sayesinde uygulamalar\u0131m\u0131z\u0131n hem h\u0131zl\u0131 hem de hata toleransl\u0131 olmas\u0131n\u0131 sa\u011flayabiliyoruz. Vaka analizleri ve ad\u0131m ad\u0131m kod \u00f6rnekleri, bu teorik bilgilerin ger\u00e7ek d\u00fcnya senaryolar\u0131nda nas\u0131l hayata ge\u00e7irilebilece\u011fini somutla\u015ft\u0131rd\u0131. Unutmayal\u0131m ki, veri b\u00fct\u00fcnl\u00fc\u011f\u00fc sadece bug\u00fcn\u00fcn de\u011fil, yar\u0131n\u0131n da sorunsuz \u00e7al\u0131\u015fan uygulamalar\u0131n\u0131n garantisidir. Bu nedenle, Uniface projelerinizde referans b\u00fct\u00fcnl\u00fc\u011f\u00fcne hak etti\u011fi \u00f6nemi vermek, uzun vadeli ba\u015far\u0131 i\u00e7in at\u0131lacak en kritik ad\u0131mlardan biridir.\n    <\/p>\n<h2>S\u0131k\u00e7a Sorulan Sorular (SSS)<\/h2>\n<ol>\n<li>\n            <strong>Referans B\u00fct\u00fcnl\u00fc\u011f\u00fc neden bu kadar \u00f6nemlidir?<\/strong><\/p>\n<div class=\"faq-answer\">\n                Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc, veritaban\u0131ndaki ili\u015fkili verilerin tutarl\u0131 kalmas\u0131n\u0131 sa\u011flar. E\u011fer bu b\u00fct\u00fcnl\u00fck sa\u011flanmazsa, veritaban\u0131nda \"yetim\" veya anlams\u0131z kay\u0131tlar olu\u015fabilir. Bu durum, uygulaman\u0131n hatal\u0131 \u00e7al\u0131\u015fmas\u0131na, yanl\u0131\u015f raporlamalara ve genel veri kalitesinin d\u00fc\u015fmesine yol a\u00e7ar. Do\u011fru referans b\u00fct\u00fcnl\u00fc\u011f\u00fc, veri tutars\u0131zl\u0131klar\u0131n\u0131 \u00f6nler ve uygulaman\u0131n g\u00fcvenilirli\u011fini art\u0131r\u0131r.\n            <\/div>\n<\/li>\n<li>\n            <strong>Uniface, veritaban\u0131 seviyesindeki referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l kullan\u0131r?<\/strong><\/p>\n<div class=\"faq-answer\">\n                Uniface, g\u00fc\u00e7l\u00fc veritaban\u0131 ba\u011fda\u015ft\u0131r\u0131c\u0131lar\u0131 arac\u0131l\u0131\u011f\u0131yla veritaban\u0131 y\u00f6netim sistemlerinin (VTYS) kendi yerle\u015fik referans b\u00fct\u00fcnl\u00fc\u011f\u00fc k\u0131s\u0131tlamalar\u0131n\u0131 (Foreign Key k\u0131s\u0131tlamalar\u0131 gibi) do\u011frudan kullan\u0131r. Model Editor'da tan\u0131mlad\u0131\u011f\u0131n\u0131z ili\u015fkiler, Uniface'in bu k\u0131s\u0131tlamalar\u0131 anlamas\u0131n\u0131 sa\u011flar. B\u00f6ylece, uygulama seviyesinde tekrar kod yazmak yerine, veritaban\u0131n\u0131n optimize edilmi\u015f mekanizmalar\u0131 devreye girer ve hem performans hem de tutarl\u0131l\u0131k garantisi sa\u011flan\u0131r.\n            <\/div>\n<\/li>\n<li>\n            <strong>Cascade delete\/update Uniface'ta otomatik mi?<\/strong><\/p>\n<div class=\"faq-answer\">\n                Uniface, e\u011fer veritaban\u0131 seviyesinde <code>ON DELETE CASCADE<\/code> veya <code>ON UPDATE CASCADE<\/code> kural\u0131 tan\u0131mlanm\u0131\u015fsa, bu davran\u0131\u015flar\u0131 destekler ve otomatik olarak uygular. Ancak, bu kural veritaban\u0131nda tan\u0131ml\u0131 de\u011filse, Uniface varsay\u0131lan olarak silme veya g\u00fcncelleme i\u015flemlerini engelleyecektir (Restrict Delete benzeri). Geli\u015ftiriciler, uygulama seviyesinde kendi \u00f6zel cascade mant\u0131klar\u0131n\u0131 yazmak isterlerse, <code>delete<\/code> triggered operation'lar\u0131 veya Uniface'in di\u011fer procedural logic \u00f6zelliklerini kullanabilirler.\n            <\/div>\n<\/li>\n<li>\n            <strong>Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc performans\u0131 nas\u0131l etkiler?<\/strong><\/p>\n<div class=\"faq-answer\">\n                Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc kontrolleri, \u00f6zellikle b\u00fcy\u00fck tablolarda indeksleme yap\u0131lmad\u0131\u011f\u0131nda sorgu performans\u0131n\u0131 etkileyebilir. Ancak, Foreign Key s\u00fctunlar\u0131na do\u011fru indeksler eklenerek bu etki minimize edilebilir. Uniface'in veritaban\u0131 seviyesi k\u0131s\u0131tlamalar\u0131n\u0131 kullanmas\u0131, genellikle uygulama seviyesinde yaz\u0131lan manuel kontrollere g\u00f6re daha performansl\u0131d\u0131r \u00e7\u00fcnk\u00fc veritaban\u0131 motorlar\u0131 bu t\u00fcr kontroller i\u00e7in optimize edilmi\u015ftir.\n            <\/div>\n<\/li>\n<li>\n            <strong>Hata y\u00f6netimi i\u00e7in ne yapmal\u0131y\u0131m?<\/strong><\/p>\n<div class=\"faq-answer\">\n                Referans b\u00fct\u00fcnl\u00fc\u011f\u00fc ihlali durumunda, Uniface taraf\u0131ndan d\u00f6nd\u00fcr\u00fclen ham veritaban\u0131 hatalar\u0131n\u0131 kullan\u0131c\u0131 dostu mesajlara d\u00f6n\u00fc\u015ft\u00fcrmek \u00f6nemlidir. <code>$status<\/code>, <code>$errorcode<\/code> ve <code>$errormessage<\/code> sistem de\u011fi\u015fkenlerini kullanarak hatalar\u0131 yakalayabilir ve anla\u015f\u0131l\u0131r geri bildirimler sa\u011flayabilirsiniz. Ayr\u0131ca, baz\u0131 durumlarda hata mesaj\u0131 g\u00f6stermek yerine, \u00f6nleyici kontrollerle (\u00f6rne\u011fin, silme d\u00fc\u011fmesini pasif hale getirme) kullan\u0131c\u0131n\u0131n hataya d\u00fc\u015fmesini ba\u015ftan engellemek daha iyi bir kullan\u0131c\u0131 deneyimi sunabilir.\n            <\/div>\n<\/li>\n<\/ol>\n<p><\/body><\/p>\n","protected":false},"excerpt":{"rendered":"Veri tabanlar\u0131, g\u00fcn\u00fcm\u00fcz yaz\u0131l\u0131m uygulamalar\u0131n\u0131n kalbinde yer al\u0131r ve bu sistemlerin temelini olu\u015fturan verilerin tutarl\u0131l\u0131\u011f\u0131, i\u015flevselli\u011fi i\u00e7in hayati&hellip;","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1],"tags":[],"class_list":{"0":"post-30852","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-genel","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak<\/title>\n<meta name=\"description\" content=\"Veri tabanlar\u0131, g\u00fcn\u00fcm\u00fcz yaz\u0131l\u0131m uygulamalar\u0131n\u0131n kalbinde yer al\u0131r ve bu sistemlerin temelini olu\u015fturan verilerin tutarl\u0131l\u0131\u011f\u0131, i\u015flevselli\u011fi i\u00e7in hayati \u00f6neme sahiptir. Peki, karma\u015f\u0131k bir Uniface 10.4 uygulamas\u0131nda verilerinizin her zaman do\u011fru ve ili\u015fkisel olarak b\u00fct\u00fcn kalmas\u0131n\u0131 nas\u0131l sa\u011flars\u0131n\u0131z? Cevap, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc do\u011fru bir \u015fekilde anlamak ve uygulamakta yat\u0131yor. Bu makale, Uniface bile\u015fenlerinizde referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, y\u00f6netece\u011finizi ve olas\u0131 hatalar\u0131 nas\u0131l \u00f6nleyece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak\" \/>\n<meta property=\"og:description\" content=\"Veri tabanlar\u0131, g\u00fcn\u00fcm\u00fcz yaz\u0131l\u0131m uygulamalar\u0131n\u0131n kalbinde yer al\u0131r ve bu sistemlerin temelini olu\u015fturan verilerin tutarl\u0131l\u0131\u011f\u0131, i\u015flevselli\u011fi i\u00e7in hayati \u00f6neme sahiptir. Peki, karma\u015f\u0131k bir Uniface 10.4 uygulamas\u0131nda verilerinizin her zaman do\u011fru ve ili\u015fkisel olarak b\u00fct\u00fcn kalmas\u0131n\u0131 nas\u0131l sa\u011flars\u0131n\u0131z? Cevap, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc do\u011fru bir \u015fekilde anlamak ve uygulamakta yat\u0131yor. Bu makale, Uniface bile\u015fenlerinizde referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, y\u00f6netece\u011finizi ve olas\u0131 hatalar\u0131 nas\u0131l \u00f6nleyece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-02T18:02:03+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"25 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak\",\"datePublished\":\"2025-10-02T18:02:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/\"},\"wordCount\":4634,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/\",\"name\":\"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-10-02T18:02:03+00:00\",\"description\":\"Veri tabanlar\u0131, g\u00fcn\u00fcm\u00fcz yaz\u0131l\u0131m uygulamalar\u0131n\u0131n kalbinde yer al\u0131r ve bu sistemlerin temelini olu\u015fturan verilerin tutarl\u0131l\u0131\u011f\u0131, i\u015flevselli\u011fi i\u00e7in hayati \u00f6neme sahiptir. Peki, karma\u015f\u0131k bir Uniface 10.4 uygulamas\u0131nda verilerinizin her zaman do\u011fru ve ili\u015fkisel olarak b\u00fct\u00fcn kalmas\u0131n\u0131 nas\u0131l sa\u011flars\u0131n\u0131z? Cevap, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc do\u011fru bir \u015fekilde anlamak ve uygulamakta yat\u0131yor. Bu makale, Uniface bile\u015fenlerinizde referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, y\u00f6netece\u011finizi ve olas\u0131 hatalar\u0131 nas\u0131l \u00f6nleyece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak.\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak","description":"Veri tabanlar\u0131, g\u00fcn\u00fcm\u00fcz yaz\u0131l\u0131m uygulamalar\u0131n\u0131n kalbinde yer al\u0131r ve bu sistemlerin temelini olu\u015fturan verilerin tutarl\u0131l\u0131\u011f\u0131, i\u015flevselli\u011fi i\u00e7in hayati \u00f6neme sahiptir. Peki, karma\u015f\u0131k bir Uniface 10.4 uygulamas\u0131nda verilerinizin her zaman do\u011fru ve ili\u015fkisel olarak b\u00fct\u00fcn kalmas\u0131n\u0131 nas\u0131l sa\u011flars\u0131n\u0131z? Cevap, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc do\u011fru bir \u015fekilde anlamak ve uygulamakta yat\u0131yor. Bu makale, Uniface bile\u015fenlerinizde referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, y\u00f6netece\u011finizi ve olas\u0131 hatalar\u0131 nas\u0131l \u00f6nleyece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak.","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:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/","og_locale":"tr_TR","og_type":"article","og_title":"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak","og_description":"Veri tabanlar\u0131, g\u00fcn\u00fcm\u00fcz yaz\u0131l\u0131m uygulamalar\u0131n\u0131n kalbinde yer al\u0131r ve bu sistemlerin temelini olu\u015fturan verilerin tutarl\u0131l\u0131\u011f\u0131, i\u015flevselli\u011fi i\u00e7in hayati \u00f6neme sahiptir. Peki, karma\u015f\u0131k bir Uniface 10.4 uygulamas\u0131nda verilerinizin her zaman do\u011fru ve ili\u015fkisel olarak b\u00fct\u00fcn kalmas\u0131n\u0131 nas\u0131l sa\u011flars\u0131n\u0131z? Cevap, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc do\u011fru bir \u015fekilde anlamak ve uygulamakta yat\u0131yor. Bu makale, Uniface bile\u015fenlerinizde referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, y\u00f6netece\u011finizi ve olas\u0131 hatalar\u0131 nas\u0131l \u00f6nleyece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak.","og_url":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-10-02T18:02:03+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"25 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak","datePublished":"2025-10-02T18:02:03+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/"},"wordCount":4634,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/","url":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/","name":"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-10-02T18:02:03+00:00","description":"Veri tabanlar\u0131, g\u00fcn\u00fcm\u00fcz yaz\u0131l\u0131m uygulamalar\u0131n\u0131n kalbinde yer al\u0131r ve bu sistemlerin temelini olu\u015fturan verilerin tutarl\u0131l\u0131\u011f\u0131, i\u015flevselli\u011fi i\u00e7in hayati \u00f6neme sahiptir. Peki, karma\u015f\u0131k bir Uniface 10.4 uygulamas\u0131nda verilerinizin her zaman do\u011fru ve ili\u015fkisel olarak b\u00fct\u00fcn kalmas\u0131n\u0131 nas\u0131l sa\u011flars\u0131n\u0131z? Cevap, referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc do\u011fru bir \u015fekilde anlamak ve uygulamakta yat\u0131yor. Bu makale, Uniface bile\u015fenlerinizde referans b\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc nas\u0131l kuraca\u011f\u0131n\u0131z\u0131, y\u00f6netece\u011finizi ve olas\u0131 hatalar\u0131 nas\u0131l \u00f6nleyece\u011finizi ad\u0131m ad\u0131m a\u00e7\u0131klayacak.","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/uniface-10-4-bilesenlerinde-referans-butunlugunu-anlamak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Uniface 10.4 Bile\u015fenlerinde Referans B\u00fct\u00fcnl\u00fc\u011f\u00fcn\u00fc Anlamak"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/30852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=30852"}],"version-history":[{"count":0,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/30852\/revisions"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=30852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=30852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=30852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}