{"id":2075,"date":"2017-11-12T22:39:32","date_gmt":"2017-11-12T19:39:32","guid":{"rendered":"http:\/\/www.profelis.com.tr\/tr\/blog\/?p=2075"},"modified":"2024-04-16T22:11:05","modified_gmt":"2024-04-16T19:11:05","slug":"oracledan-edb-postgres-advanced-servera-goc-etmeye-hazir-misiniz","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2017\/11\/12\/oracledan-edb-postgres-advanced-servera-goc-etmeye-hazir-misiniz\/","title":{"rendered":"Oracle\u2019dan EDB Postgres Advanced Server\u2019a g\u00f6\u00e7 etmeye haz\u0131r m\u0131s\u0131n\u0131z?"},"content":{"rendered":"<p style=\"text-align: left;\"><span style=\"font-weight: 400;\">zellikle kurumsal \u015firketler, var olan Oracle veri tabanlar\u0131n\u0131n tamam\u0131 veya bir k\u0131sm\u0131n\u0131 a\u00e7\u0131k kaynak kodlu PostgreSQL\u2019e ta\u015f\u0131nmas\u0131 s\u00fcrecini, getirece\u011fi kazan\u0131mlar\u0131, riskleri ve yat\u0131r\u0131m maliyetini ara\u015ft\u0131rmaktad\u0131r. <\/span>Kurumsal yap\u0131larda kullan\u0131lan veri tabanlar\u0131n\u0131n b\u00fcy\u00fckl\u00fc\u011f\u00fc, i\u015f s\u00fcre\u00e7lerinin karma\u015f\u0131kl\u0131\u011f\u0131 ve proje yo\u011funlu\u011fu nedeniyle bu konuya yeterli zaman\u0131 olmayan y\u00f6neticiler i\u00e7in yol haritas\u0131 niteli\u011finde bir yaz\u0131 okuyacaks\u0131n\u0131z.<\/p>\n<h3>Ba\u015flang\u0131\u00e7 Tavsiyesi<\/h3>\n<p><span style=\"font-weight: 400;\">Yapaca\u011f\u0131n\u0131z \u00e7al\u0131\u015fmay\u0131 kay\u0131t alt\u0131na alman\u0131z, kurumsal haf\u0131za olu\u015fturman\u0131za ve hi\u00e7bir \u015feyi g\u00f6zden ka\u00e7\u0131rmaman\u0131za yard\u0131mc\u0131 olur. Bu i\u015fi <\/span><span style=\"font-weight: 400;\">Balabit SCB<\/span><span style=\"font-weight: 400;\"> ile ajan yaz\u0131l\u0131m kullanmadan yapabilirsiniz.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">Veritaban\u0131 G\u00f6\u00e7 Ya\u015fam D\u00f6ng\u00fcs\u00fc<\/span><\/h2>\n<h3><span style=\"font-weight: 400;\">Analiz ve De\u011ferlendirme S\u00fcreci<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u0130lk ve en \u00f6nemli s\u00fcre\u00e7 olan analiz ve de\u011ferlendirme s\u00fcrecinin kapsam\u0131n belirlenmesi, risk analizi, yat\u0131r\u0131m getirisinin analizi ve kesinti s\u00fcresinin en aza indirgenmesi, g\u00f6\u00e7 plan\u0131n\u0131n temelini olu\u015fturur.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Kapsam Belirleme<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Ge\u00e7i\u015fe konu olacak uygulamalar\u0131n\u0131z\u0131n ve veritabanlar\u0131n\u0131z\u0131n hangileri olaca\u011f\u0131na karar verirken birka\u00e7 fakt\u00f6r\u00fc d\u00fc\u015f\u00fcnmelisiniz. \u015eirketinizin ilk PostgreSQL ge\u00e7i\u015fi ise, daha az zorlu, daha d\u00fc\u015f\u00fck riskli bir ge\u00e7i\u015f ile ba\u015flayabilirsiniz. Edinece\u011finiz tecr\u00fcbe, y\u00fcksek hacimli, suncular\u0131n\u0131z\u0131n g\u00f6\u00e7\u00fcnde rahat etmenizi sa\u011flar. Oracle konusunda deneyimliyseniz, PostgreSQL\u2019e \u00e7ok kolay adapte olaca\u011f\u0131n\u0131z\u0131 g\u00f6receksiniz. Kendinizi yeterince rahat hissetmezseniz, deneyimli veritaban\u0131 y\u00f6neticileri (DBA) kiralama ad\u0131m\u0131n\u0131 da devreye sokabilirsiniz.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Veritaban\u0131 g\u00f6\u00e7 i\u015flemleri s\u0131ras\u0131nda, veritaban\u0131n\u0131 kullanan uygulamalar\u0131 da g\u00f6z \u00f6n\u00fcnde bulundurmal\u0131s\u0131n\u0131z. Genel olarak, kaynak kodunu de\u011fi\u015ftirebildi\u011finiz bir kurum i\u00e7i uygulama veya web sitesi i\u00e7in PostgreSQL\u2019e g\u00f6\u00e7 \u00e7ok kolay \u015fekilde \u00a0ger\u00e7ekle\u015ftirilebilir. PostgreSQL i\u00e7in destek sa\u011flamayan, \u00fc\u00e7\u00fcnc\u00fc ki\u015filer taraf\u0131ndan geli\u015ftirilmi\u015f bir ticari yaz\u0131l\u0131m \u00fcr\u00fcn\u00fc, ek geli\u015ftirmeler isteyebilece\u011finden, g\u00f6\u00e7 s\u0131ras\u0131nda zahmetli bir s\u00fcre\u00e7 ya\u015fayabilirsiniz. Buradaki kritik konu, sadece belirli veritabanlar\u0131na \u00f6zel yap\u0131lar\u0131n kullan\u0131lmas\u0131 ile ortaya \u00e7\u0131kar.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Departman uygulamalar\u0131 veya raporlama veri martlar\u0131, Postgres g\u00f6\u00e7\u00fcne imkan veren d\u00fc\u015f\u00fck riskli se\u00e7eneklerdir. ODBC veya JDBC ba\u011flant\u0131lar\u0131 yoluyla birden \u00e7ok veritaban\u0131 ile birlikte \u00e7al\u0131\u015fan veri tabanlar\u0131 veya \u00e7\u0131karma, aktarma, y\u00fckleme (ETL) ara\u00e7lar\u0131, \u00e7ok y\u00fcksek uyumluluk ve d\u00fc\u015f\u00fck de\u011fi\u015ftirme gereksinimleri nedeniyle m\u00fckemmel adaylard\u0131r. <\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Risk Analizi<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Her yeni projede oldu\u011fu gibi, g\u00f6\u00e7 i\u015fleminin her ad\u0131m\u0131nda veya sonras\u0131nda bir tak\u0131m beklenmedik sorunlar veya zorluklar ile kar\u015f\u0131la\u015fabilirsiniz. Bu sorunlar ve zorluklar i\u00e7in ne kadar \u00f6ng\u00f6r\u00fcl\u00fc ve haz\u0131rl\u0131kl\u0131 olursan\u0131z, sonu\u00e7lar\u0131ndan o kadar az etkilenirsiniz. Bu nedenle elinizde bir risk haritas\u0131 olmas\u0131 daha sa\u011fl\u0131kl\u0131 bir plan olu\u015fturman\u0131z\u0131 sa\u011flayacakt\u0131r.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Yat\u0131r\u0131m Getirisinin Analizi<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Veritaban\u0131 de\u011fi\u015fikli\u011fi karar\u0131n\u0131za \u00f6nemli \u00f6l\u00e7\u00fcde etki eden, yat\u0131r\u0131m\u0131n geri d\u00f6n\u00fc\u015f\u00fcn\u00fcn analizini yapmak bu s\u00fcre\u00e7te sizi motive edecek ve ihtiyac\u0131n\u0131z olan cesareti sa\u011flayacakt\u0131r. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tipik bir yaz\u0131l\u0131m \u00fcr\u00fcn\u00fc i\u00e7in g\u00f6z \u00f6n\u00fcnde bulundurman\u0131z gereken maliyetleri; <\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Donan\u0131m maliyetleri, <\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Lisans maliyeti<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Bak\u0131m\/Destek maliyeti <\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">olmak \u00fczere 3 farkl\u0131 ba\u015fl\u0131kta ele alabilirsiniz. Bu maliyetleri detayl\u0131ca de\u011ferlendirme konusunda deneyiminiz oldu\u011funu d\u00fc\u015f\u00fcnerek, biz basit bir de\u011ferlendirme \u00f6nerisinde bulunaca\u011f\u0131z. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Oracle\u2019dan EDB Postgres Advanced Server\u2019a ge\u00e7i\u015f karar\u0131n\u0131z size sadece lisanslama taraf\u0131nda kabaca %60-%70 civar\u0131nda bir maliyet avantaj\u0131 sa\u011flayacakt\u0131r. Bu kazanc\u0131n bir k\u0131sm\u0131n\u0131 PostgreSQL i\u00e7in e\u011fitim ve dan\u0131\u015fmanl\u0131k hizmetleri i\u00e7in kullanabilirsiniz. Bu yat\u0131r\u0131m, sizi uzun s\u00fcrede hem daha karl\u0131 hem de deneyimli yapacakt\u0131r.<\/span><\/p>\n<h4><span style=\"font-weight: 400;\">Kesinti S\u00fcresinin En Aza \u0130ndirgenmesi<\/span><\/h4>\n<p><span style=\"font-weight: 400;\">Her kurum, veritaban\u0131 sistemlerinde i\u015f s\u00fcre\u00e7lerinin elverdi\u011fi kabul edilebilir \u00f6l\u00e7\u00fclerde kesinti s\u00fcreleri belirler. G\u00f6\u00e7 i\u015flemleri s\u0131ras\u0131nda olu\u015fabilecek kesintilerin de \u00f6nceden belirlenmesi ve kesinti s\u00fcrelerinin azalt\u0131lmas\u0131 konusunda gerekli \u00f6nlemlerin planlanmas\u0131 \u00f6nemlidir.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">\u015eema ve kod \u00e7evrimi<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">EnterpriseDB ara\u00e7lar\u0131ndan biri olan Migration Toolkit, bu ba\u015fl\u0131k alt\u0131nda ihtiyac\u0131n\u0131z olan t\u00fcm i\u015flemleri ger\u00e7ekle\u015ftirece\u011finiz yard\u0131mc\u0131n\u0131z olacakt\u0131r. Hem \u015fema, hem de veri aktar\u0131mlar\u0131n\u0131 otomatik olarak yapan bu ara\u00e7, \u015fema \u00e7evrimlerini do\u011frudan hedef veritaban\u0131na uygulayabildi\u011fi gibi, offline olarak DDL scriptlerine \u00e7evirerek, gerekti\u011finde elle m\u00fcdahele etme ve farkl\u0131 bir zamanda uygulama imkan\u0131 veriyor. Yaz\u0131 konusu g\u00f6\u00e7 i\u015flemlerinde veri kayna\u011f\u0131n\u0131z Oracle veritaban\u0131 oldu\u011fu i\u00e7in, \u015fema aktar\u0131mlar\u0131 olduk\u00e7a zahmetsiz \u015fekilde ger\u00e7ekle\u015fecektir. Oracle veritaban\u0131nda yer alan objeleri, b\u00fcy\u00fck bir oranda destekleyen EDB Postgres Advanced Server, sadece CLOB, BLOB gibi b\u00fcy\u00fck boyutlu veri setleri i\u00e7in ek baz\u0131 i\u015flemlere ihtiya\u00e7 duyar.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Veri ta\u015f\u0131ma ve Senkronizasyon<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">\u015eemay\u0131 d\u00f6n\u00fc\u015ft\u00fcrd\u00fckten sonraki ad\u0131m, veriyi kaynak veritaban\u0131n\u0131zdan \u00e7ekmektir. Genellikle, verilerin tamam\u0131n\u0131 ta\u015f\u0131madan \u00f6nce, belirleyece\u011finiz bir alt k\u00fcmeyi veya test veri setini kontroll\u00fc aktararak ba\u015flayabilirsiniz.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Ta\u015f\u0131nacak veritaban\u0131n\u0131n b\u00fcy\u00fckl\u00fc\u011f\u00fc, verilerin de\u011fi\u015fim h\u0131z\u0131 ve eri\u015fimde ne kadar kesintiye izin verildi\u011fine ba\u011fl\u0131 olarak, veri ta\u015f\u0131ma i\u015fleminde farkl\u0131 yakla\u015f\u0131mlar izlemeniz gerekebilir. S\u0131n\u0131rl\u0131 bant geni\u015fli\u011fi olan ya da \u00e7ok y\u00fcksek veri de\u011fi\u015fim oranlar\u0131na sahip ortamlar i\u00e7in, uzak sistemlere do\u011frudan aktar\u0131m yerine, yerel a\u011fda h\u0131zl\u0131 ge\u00e7i\u015f ile ba\u015flamak daha mant\u0131kl\u0131d\u0131r.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Kontrol<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">G\u00f6\u00e7 s\u00fcrecinin son a\u015famas\u0131 olan kontrol a\u015famas\u0131, do\u011frulama testlerinden olu\u015fur. Kaynak veritaban\u0131 ile ge\u00e7i\u015f yap\u0131lan EDB Postgres Advanced Server veritaban\u0131 aras\u0131nda veri tutarl\u0131\u011f\u0131n\u0131 do\u011frulayacak testleri tamamlamal\u0131s\u0131n\u0131z. Ancak i\u015finiz bitmedi. Uygulama testlerinin de sorunsuz tamamlanmas\u0131 gerekiyor.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">Uygulama Testi<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">Uygulama Testi ad\u0131m\u0131nda, g\u00f6\u00e7 i\u015fleminden etkilenecek uygulamalar\u0131n sorunsuz \u015fekilde \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131n kontrol edilmesi gerekmektedir. Uygulamalar\u0131n veritabanlar\u0131na sa\u011fl\u0131kl\u0131 \u015fekilde ba\u011fland\u0131\u011f\u0131n\u0131 ve do\u011fru veriyi \u00fcretti\u011fini, olu\u015fturdu\u011funuz test senaryolar\u0131 ile kontrol etmelisiniz. Her \u015fey sorunsuzsa <\/span><span style=\"font-weight: 400;\">kendinizi kutlayabilirsiniz.<\/span><\/p>\n<h3><span style=\"font-weight: 400;\">E\u011fitim<\/span><\/h3>\n<p><span style=\"font-weight: 400;\">G\u00f6\u00e7 projelerinde, e\u011fitim olduk\u00e7a \u00f6nemli bir konudur. Hem veritaban\u0131 y\u00f6neticilerinize hem de geli\u015ftiricilerinize \u00f6zel PostgreSQL e\u011fitimlerini planlamal\u0131s\u0131n\u0131z. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00d6zellikle g\u00f6\u00e7 proje ekibine, \u00e7al\u0131\u015fmalar ba\u015flamadan e\u011fitim ald\u0131rman\u0131z\u0131 \u00f6neririz. Ekibinizin EDB PostgreSQL sertifikasyonuna sahip olmas\u0131 kendi kendinize yetece\u011finizin g\u00f6stergesidir. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">T\u00fcrkiye\u2019deki tek EnterpriseDB yetkili e\u011fitim merkezi olan Profelis\u2019in e\u011fitim i\u00e7eriklerine <\/span><a href=\"https:\/\/profelis.com.tr\/en\/postgresql-egitimleri\/\"><span style=\"font-weight: 400;\">buradan<\/span><\/a><span style=\"font-weight: 400;\"> ula\u015fabilirsiniz. Bu e\u011fitimleri tamamlad\u0131\u011f\u0131n\u0131zda, s\u0131nav hakk\u0131 elde edeceksiniz. Bu s\u0131nav EDB taraf\u0131ndan internet \u00fczerinden yap\u0131lmaktad\u0131r. S\u0131navda ba\u015far\u0131l\u0131 oldu\u011funuzda t\u00fcm d\u00fcnyada ge\u00e7erli sertifikan\u0131z\u0131 alacaks\u0131n\u0131z.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">PostgreSQL ve EDB Postgres Advanced Server<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">PostgreSQL, geli\u015fmi\u015f \u00f6zellikler, y\u00fcksek performans, sa\u011flam veri b\u00fct\u00fcnl\u00fc\u011f\u00fc, esnek yap\u0131s\u0131 ve a\u00e7\u0131k kaynak lisans\u0131 ile g\u00f6\u00e7 i\u00e7in m\u00fckemmel bir se\u00e7imdir. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">PostgreSQL ANSI SQL uyumludur, neredeyse t\u00fcm geli\u015ftirme dillerinin s\u00fcr\u00fcc\u00fclerini destekler. EnterpriseDB, 2nd Quadrant, Citus ve Heroku gibi b\u00fcy\u00fck \u015firketlerin bulundu\u011fu, g\u00fc\u00e7l\u00fc bir toplulu\u011fa sahiptir. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">PostgreSQL\u2019in geli\u015fimine destek veren bu sayg\u0131n \u015firketler i\u00e7erisinde, Oracle kullan\u0131c\u0131lar\u0131 i\u00e7in, EnterpriseDB\u2019nin ismi bir ad\u0131m daha \u00f6ne \u00e7\u0131kar. Bunun nedeni, EnterpriseDB\u2019nin \u00f6zellikle Oracle veri taban\u0131na a\u015fina olan kullan\u0131c\u0131lar i\u00e7in g\u00f6\u00e7 s\u00fcrecini kolayla\u015ft\u0131ran teknolojiler sa\u011flamas\u0131d\u0131r. Bu teknolojiler sayesinde, kullan\u0131c\u0131lar g\u00fcnl\u00fck al\u0131\u015fkanl\u0131klar\u0131n\u0131 neredeyse de\u011fi\u015ftirmek zorunda kalmazlar. Bir\u00e7ok ek \u00f6zellik sayesinde hayatlar\u0131 daha da kolayla\u015f\u0131r.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">EnterpriseDB \u00fcr\u00fcnleri ile ilgili geni\u015f bilgiye <\/span><a href=\"https:\/\/profelis.com.tr\/en\/enterprisedb\/\"><span style=\"font-weight: 400;\">buradan<\/span><\/a><span style=\"font-weight: 400;\"> ula\u015fabilir ya da bizimle <\/span><a href=\"https:\/\/profelis.com.tr\/en\/iletisim\/\"><span style=\"font-weight: 400;\">ileti\u015fime<\/span><\/a><span style=\"font-weight: 400;\"> ge\u00e7ebilirsiniz.<\/span><\/p>","protected":false},"excerpt":{"rendered":"<p>\u00d6zellikle kurumsal \u015firketler, var olan Oracle veri tabanlar\u0131n\u0131n tamam\u0131 veya bir k\u0131sm\u0131n\u0131 a\u00e7\u0131k kaynak kodlu PostgreSQL\u2019e ta\u015f\u0131nmas\u0131 s\u00fcrecini, getirece\u011fi kazan\u0131mlar\u0131, riskleri ve yat\u0131r\u0131m maliyetini ara\u015ft\u0131rmaktad\u0131r.<\/p>\n<p>Kurumsal yap\u0131larda kullan\u0131lan veri tabanlar\u0131n\u0131n b\u00fcy\u00fckl\u00fc\u011f\u00fc, i\u015f s\u00fcre\u00e7lerinin karma\u015f\u0131kl\u0131\u011f\u0131 ve proje yo\u011funlu\u011fu nedeniyle bu konuya yeterli zaman\u0131 olmayan y\u00f6neticiler i\u00e7in yol haritas\u0131 niteli\u011finde bir yaz\u0131 okuyacaks\u0131n\u0131z.<\/p>","protected":false},"author":7,"featured_media":13999,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,45],"tags":[48,60],"class_list":["post-2075","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-yazi","tag-enterprisedb","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/2075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=2075"}],"version-history":[{"count":0,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/2075\/revisions"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=2075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=2075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=2075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}