{"id":1296,"date":"2023-09-28T18:24:39","date_gmt":"2023-09-28T18:24:39","guid":{"rendered":"https:\/\/www.dbo.com.tr\/?p=1296"},"modified":"2024-09-30T10:53:57","modified_gmt":"2024-09-30T10:53:57","slug":"oracle-database-nedir-oracle-databasein-calisma-yapisi-nedir","status":"publish","type":"post","link":"https:\/\/www.dbo.com.tr\/en\/oracle-database-nedir-oracle-databasein-calisma-yapisi-nedir\/","title":{"rendered":"Oracle Veritaban\u0131 (Database) nedir? Oracle Veritaban\u0131n Database\u2019in \u00c7al\u0131\u015fma Yap\u0131s\u0131 Nedir?"},"content":{"rendered":"<p class=\"wp-block-paragraph\"><strong>Oracle Database<\/strong>, Oracle firmas\u0131 taraf\u0131ndan geli\u015ftirilen ve y\u00f6netilen bir veritaban\u0131 y\u00f6netim sistemidir. G\u00fcnl\u00fck hayatta s\u0131k\u00e7a kar\u015f\u0131la\u015f\u0131lan bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fc de\u011fildir. \u00d6zellikle banka, telekom\u00fcnikasyon ve sanayi gibi k\u0131ymetli verilere sahip olan firmala (JP Morgan, Walmart, Amazon, ABD Sosyal G\u00fcvenlik \u0130daresi, IFS, Walt Disney\u2026) taraf\u0131ndan tercih edilen, son derece de\u011ferli bir teknolojidir. Bu firmalar, m\u00fc\u015fteri bilgileri, finansal veriler ve kritik i\u015f s\u00fcre\u00e7leri gibi \u00f6nemli verileri g\u00fcvenli bir bi\u00e7imde korumak i\u00e7in Oracle Database\u2019i tercih ederler. Ancak bu y\u00fcksek d\u00fczeyde g\u00fcvenlik ve performans, beraberinde y\u00fcksek maliyetleri de getirir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle Database Mimarisi Nedir?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle\u2019\u0131n mimarisini \u00e7ok basit bir \u015fekilde anlatacak olursak, 3 par\u00e7aya ay\u0131rmam\u0131z gerekecektir. Instance, database dosyalar\u0131 ve kullan\u0131c\u0131 instance\u2019\u0131.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Instance,&nbsp;<\/strong>database\u2019in arkas\u0131nda \u00e7al\u0131\u015fan t\u00fcm process\u2019leri kapsamaktad\u0131r. Bu processler i\u00e7erisinde database dosyalar\u0131ndan veri okumak veya yedekleme yapmak gibi bir\u00e7ok process bulunmaktad\u0131r.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Database dosyalar\u0131&nbsp;<\/strong>ise verilerinizin sakland\u0131\u011f\u0131 aland\u0131r. Database\u2019de bulunan t\u00fcm veriler bu dosyalarda tutulur.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kullan\u0131c\u0131 instance\u2019\u0131<\/strong>&nbsp;ise her kullan\u0131c\u0131n\u0131n ger\u00e7ekle\u015ftirdi\u011fi i\u015flemler i\u00e7in ayr\u0131lm\u0131\u015f alana verilen isimdir. Her kullan\u0131c\u0131 i\u00e7in CPU ve RAM\u2019de \u00f6zel bir alan ayr\u0131l\u0131r ve kullan\u0131c\u0131n\u0131n yapt\u0131\u011f\u0131 i\u015flemler (g\u00f6nderilen sorgunun \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131, sorgunun plan\u0131n\u0131n \u00e7\u0131kar\u0131lmas\u0131) bu alanda i\u015flenir.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle Database\u2019i nas\u0131l kullanabilirim?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Oracle Database\u2019i iste\u011finize g\u00f6re bir\u00e7ok farkl\u0131 i\u015flem i\u00e7in kullanabilirsiniz. Bunlardan birka\u00e7\u0131n\u0131 sizlere a\u015fa\u011f\u0131da a\u00e7\u0131klayaca\u011f\u0131m:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>1- Online Transaction Processing (OLTP)<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OLTP veritabanlar\u0131, i\u015flemlerin h\u0131zl\u0131 ve verimli bir \u015fekilde i\u015flenmesi i\u00e7in tasarlanm\u0131\u015ft\u0131r. Bu i\u015flemler, \u00e7evrimi\u00e7i sipari\u015fler, bankac\u0131l\u0131k i\u015flemleri veya envanter y\u00f6netimi gibi \u015feyleri i\u00e7erebilir.<\/li>\n\n\n\n<li>Oracle Database, e\u015fzamanl\u0131 i\u015flemleri y\u00f6netme yetenekleri ve veri b\u00fct\u00fcnl\u00fc\u011f\u00fc ile tutarl\u0131l\u0131k sa\u011flama yetenekleri nedeniyle OLTP senaryolar\u0131nda s\u0131k\u00e7a kullan\u0131l\u0131r.<\/li>\n\n\n\n<li><\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>2- Data Warehousing (Veri Ambar\u0131)<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Veri ambar\u0131, analitik ama\u00e7lar i\u00e7in b\u00fcy\u00fck miktarda tarihsel verinin depolanmas\u0131 ve y\u00f6netilmesini i\u00e7erir.<\/li>\n\n\n\n<li>Oracle Database, b\u00f6lmeleme, dizinleme ve sorgu optimizasyonu gibi \u00f6zellikler sunarak veri ambar\u0131 i\u00e7in uygundur.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>3- Business Intelligence (\u0130\u015f Zekas\u0131)<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Databasee, BI uygulamalar\u0131 i\u00e7in arka u\u00e7 depo olarak kullan\u0131labilir. Veriyi depolar ve y\u00f6netir ve BI ara\u00e7lar\u0131n\u0131n sorgu yapmas\u0131n\u0131 ve raporlar ve i\u00e7g\u00f6r\u00fcler \u00fcretmesini sa\u011flar.<\/li>\n\n\n\n<li>Oracle ayr\u0131ca Oracle \u0130\u015f Zekas\u0131 Kurumsal S\u00fcr\u00fcm\u00fc (OBIEE) olarak adland\u0131r\u0131lan bir BI ara\u00e7lar\u0131 paketi sunar, bu ara\u00e7lar Oracle veritabanlar\u0131yla sorunsuz bir \u015fekilde \u00e7al\u0131\u015f\u0131r.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><em><strong>4. Cloud Deployment (Bulut Da\u011f\u0131t\u0131m\u0131)<\/strong><\/em><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Oracle Database, organizasyonlar\u0131n bulut tabanl\u0131 altyap\u0131 ve hizmetlerden yararlanmas\u0131na izin veren bulutta da\u011f\u0131t\u0131labilir.<\/li>\n\n\n\n<li>Oracle Cloud, Oracle Veritaban\u0131 dahil olmak \u00fczere \u00e7e\u015fitli veritaban\u0131 hizmetleri sunar. Bunlar aras\u0131nda tamamen y\u00f6netilen, otomatik s\u00fcr\u00fcc\u00fc veritaban\u0131 hizmeti olan Oracle Otomatik Veritaban\u0131 da bulunur.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle Database\u2019in Kurumsal Firmalara Sundu\u011fu \u00c7\u00f6z\u00fcmler Nelerdir ?<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle Real Application Clusters (RAC)<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>RAC, Oracle Database\u2019in y\u00fcksek kullan\u0131labilirlik ve \u00f6l\u00e7eklenebilirlik sa\u011flayan bir \u00f6zelli\u011fidir.<\/li>\n\n\n\n<li>Birden fazla sunucu \u00fczerinde \u00e7al\u0131\u015fan Oracle veritaban\u0131n\u0131n ayn\u0131 anda eri\u015filebilir olmas\u0131n\u0131 ve kesintileri azaltmas\u0131n\u0131 sa\u011flar.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle Data Guard<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Data Guard, felaket kurtarma ve y\u00fcksek kullan\u0131labilirlik i\u00e7in kullan\u0131lan bir Oracle veritaban\u0131 \u00f6zelli\u011fidir.<\/li>\n\n\n\n<li>Veri taban\u0131n\u0131 korumak ve ayn\u0131 anda birincil ve yedek veri tabanlar\u0131 aras\u0131nda veri replikasyonu yaparak i\u015f s\u00fcreklili\u011fini sa\u011flar.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle Exadata<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Exadata, Oracle\u2019\u0131n optimize edilmi\u015f bir donan\u0131m ve yaz\u0131l\u0131m sunucusu sistemidir.<\/li>\n\n\n\n<li>B\u00fcy\u00fck veri i\u015fleme, y\u00fcksek performansl\u0131 sorgular ve veri ambar\u0131 \u00e7\u00f6z\u00fcmleri i\u00e7in tasarlanm\u0131\u015ft\u0131r.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle Autonomous Database<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Autonomous Database, Oracle\u2019\u0131n tamamen y\u00f6netilen ve otomatikle\u015ftirilmi\u015f bulut veritaban\u0131 hizmetidir.<\/li>\n\n\n\n<li>Otomatik yedekleme, g\u00fcvenlik g\u00fcncellemeleri ve otomatik veritaban\u0131 optimizasyonu gibi \u00f6zellikler sunar, b\u00f6ylece kullan\u0131c\u0131lar veritaban\u0131na odaklanabilir.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Oracle GoldenGate<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>GoldenGate, ger\u00e7ek zamanl\u0131 veri entegrasyonu ve veri replikasyonunu sa\u011flayan bir Oracle \u00fcr\u00fcn\u00fcd\u00fcr.<\/li>\n\n\n\n<li>Farkl\u0131 veritabanlar\u0131 aras\u0131nda veri ak\u0131\u015f\u0131n\u0131 ve senkronizasyonunu kolayla\u015ft\u0131r\u0131r.<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Oracle Database, Oracle firmas\u0131 taraf\u0131ndan geli\u015ftirilen ve y\u00f6netilen bir veritaban\u0131 y\u00f6netim sistemidir. G\u00fcnl\u00fck hayatta s\u0131k\u00e7a kar\u015f\u0131la\u015f\u0131lan bir veritaban\u0131 \u00e7\u00f6z\u00fcm\u00fc de\u011fildir. \u00d6zellikle banka, telekom\u00fcnikasyon ve sanayi gibi k\u0131ymetli verilere sahip olan firmala (JP Morgan, Walmart, Amazon, ABD Sosyal G\u00fcvenlik \u0130daresi, IFS, Walt Disney\u2026) taraf\u0131ndan tercih edilen, son derece de\u011ferli bir teknolojidir. Bu firmalar, m\u00fc\u015fteri bilgileri, finansal [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":1293,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[11],"tags":[],"class_list":["post-1296","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-teknoloji"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/posts\/1296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/comments?post=1296"}],"version-history":[{"count":3,"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/posts\/1296\/revisions"}],"predecessor-version":[{"id":1446,"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/posts\/1296\/revisions\/1446"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/media\/1293"}],"wp:attachment":[{"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/media?parent=1296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/categories?post=1296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbo.com.tr\/en\/wp-json\/wp\/v2\/tags?post=1296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}