{"id":521,"date":"2017-06-10T15:12:49","date_gmt":"2017-06-10T13:12:49","guid":{"rendered":"http:\/\/explainit.pl\/wordpress\/?p=521"},"modified":"2017-06-10T15:12:49","modified_gmt":"2017-06-10T13:12:49","slug":"oracle-database-12-2-database-sharding-porady-praktyczne","status":"publish","type":"post","link":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/","title":{"rendered":"Oracle Database 12.2 Database Sharding &#8211; porady praktyczne"},"content":{"rendered":"<p>Jedn\u0105 z flagowych funkcjonalno\u015bci drugiego wydania serwera bazy danych Oracle Database 12c (12.2) jest Database Sharding (dzielenie bazy danych). Jest to klon rozwi\u0105zania dobrze znanego w \u015bwiecie system\u00f3w NoSQL, polegaj\u0105cego na horyzontalnym partycjonowaniu danych pomi\u0119dzy wiele fizycznych lokalizacji. Taki rozdzia\u0142 danych pozwala nast\u0119pnie rozdzieli\u0107 obci\u0105\u017cenie aplikacyjne i tym samym uzyska\u0107 efekt prawie-liniowej skalowalno\u015bci bardzo du\u017cych baz danych. Oczywi\u015bcie pod warunkiem, \u017ce rozs\u0105dnie rozdzielimy zar\u00f3wno dane, jak i obci\u0105\u017cenie aplikacyjne.<\/p>\n<p>Realizacja Database Shardingu w Oracle Database 12.2 korzysta po cz\u0119\u015bci z dotychczasowych mechanizm\u00f3w partycjonowania tabel (haszowego, zakresowego, listowego, dwupoziomowego), a po cz\u0119\u015bci wprowadza zupe\u0142nie nowe elementy architektoniczne, jak repozytorium metadanych (Shard Catalog) i procesy kieruj\u0105ce po\u0142\u0105czenia aplikacyjne do w\u0142a\u015bciwych cz\u0105stkowych baz danych (Shard Directors). Pojawi\u0142y si\u0119 przy tej okazji dwa nowe typy tabel: (1) Sharded Table &#8211; tabela dzielona horyzontalnie pomi\u0119dzy wiele cz\u0105stkowych baz danych, (2) Duplicated Table &#8211; tabela replikowana pomi\u0119dzy wszystkie cz\u0105stkowe bazy danych. Aplikacje klienckie mog\u0105 \u0142\u0105czy\u0107 si\u0119 bezpo\u015brednio z cz\u0105stkowymi bazami danych (Direct Connections) lub z ca\u0142\u0105 logiczn\u0105 dzielon\u0105 baz\u0105 danych (Proxy Connections). Dzielenie bazy danych mo\u017ce mie\u0107 charakter jednopoziomowy (mapowanie danych na bazy cz\u0105stkowe za pomoc\u0105 haszowania sp\u00f3jnego) lub dwupoziomowy (mapowanie danych na centra danych za pomoc\u0105 partycjonowania zakresowego\/listowego, a nast\u0119pnie na bazy cz\u0105stkowe za pomoc\u0105 haszowania sp\u00f3jnego).<\/p>\n<p>O praktycznych aspektach Database Shardingu opowiada\u0142em na ostatniej konferencji PLOUG w Warszawie. Dla zainteresowanych za\u0142\u0105czam moj\u0105 prezentacj\u0119: <a href=\"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2017\/06\/DatabaseShardingKonferencjaPLOUG2017.pdf\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-458\" src=\"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2017\/01\/filetype_pdf.png\" alt=\"Oracle 12.2. Database Sharding Konferencja PLOUG 2017\" width=\"54\" height=\"54\" \/><\/a>.<\/p>\n<p>Oto rekomendowane materia\u0142y \u017ar\u00f3d\u0142owe, pomagaj\u0105ce we wdra\u017caniu rozwi\u0105za\u0144 Oracle 12.2 Database Sharding:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=PzzjAb1pc-E\"> wideo omawiaj\u0105ce Oracle Database Sharding (Dominic Giles) &#8211; cz. I<\/a><\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=ACXeZCOo4uU\"> wideo omawiaj\u0105ce Oracle Database Sharding (Dominic Giles) &#8211; cz. II<\/a><\/li>\n<li><a href=\"https:\/\/docs.oracle.com\/database\/122\/ADMIN\/sharding-overview.htm\">oficjalna dokumentacja Oracle<\/a><\/li>\n<li><a href=\"http:\/\/db.geeksinsight.com\/2017\/02\/20\/oracle-sharding-part-2-installating-configuring-shards\/\">skr\u00f3cony tutorial instalacyjny na GeeksInsight<\/a><\/li>\n<\/ul>\n<p>Z zainteresowaniem czekam na pierwsze wdro\u017cenia tej bardzo kosztownej metody skalowania wielkich baz danych&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jedn\u0105 z flagowych funkcjonalno\u015bci drugiego wydania serwera bazy danych Oracle Database 12c (12.2) jest Database Sharding (dzielenie bazy danych). Jest to klon rozwi\u0105zania dobrze znanego w \u015bwiecie system\u00f3w NoSQL, polegaj\u0105cego na horyzontalnym partycjonowaniu danych pomi\u0119dzy wiele fizycznych lokalizacji. Taki rozdzia\u0142 danych pozwala nast\u0119pnie rozdzieli\u0107 obci\u0105\u017cenie aplikacyjne i tym samym uzyska\u0107 efekt prawie-liniowej skalowalno\u015bci bardzo du\u017cych <a href=\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/\" rel=\"nofollow\"><span class=\"sr-only\">Read more about Oracle Database 12.2 Database Sharding &#8211; porady praktyczne<\/span>[&hellip;]<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[31,30],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Database 12.2 Database Sharding - porady praktyczne - Explain IT<\/title>\n<meta name=\"description\" content=\"Oracle Database 12.2 Database Sharding - porady praktyczne\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database 12.2 Database Sharding - porady praktyczne - Explain IT\" \/>\n<meta property=\"og:description\" content=\"Oracle Database 12.2 Database Sharding - porady praktyczne\" \/>\n<meta property=\"og:url\" content=\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/\" \/>\n<meta property=\"og:site_name\" content=\"Explain IT\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-10T13:12:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2017\/01\/filetype_pdf.png\" \/>\n<meta name=\"author\" content=\"Maciej Zakrzewicz\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"Maciej Zakrzewicz\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/\"},\"author\":{\"name\":\"Maciej Zakrzewicz\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/740773131bc169a2dc9c0e5e07476219\"},\"headline\":\"Oracle Database 12.2 Database Sharding &#8211; porady praktyczne\",\"datePublished\":\"2017-06-10T13:12:49+00:00\",\"dateModified\":\"2017-06-10T13:12:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/\"},\"wordCount\":323,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/#organization\"},\"keywords\":[\"12.2\",\"Database Sharding\"],\"articleSection\":[\"Oracle Database\"],\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/\",\"url\":\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/\",\"name\":\"Oracle Database 12.2 Database Sharding - porady praktyczne - Explain IT\",\"isPartOf\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/#website\"},\"datePublished\":\"2017-06-10T13:12:49+00:00\",\"dateModified\":\"2017-06-10T13:12:49+00:00\",\"description\":\"Oracle Database 12.2 Database Sharding - porady praktyczne\",\"breadcrumb\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/explainit.pl\/wordpress\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database 12.2 Database Sharding &#8211; porady praktyczne\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#website\",\"url\":\"https:\/\/explainit.pl\/wordpress\/\",\"name\":\"Explain IT\",\"description\":\"Autorska pracownia doradztwa i szkole\u0144 IT - Maciej Zakrzewicz - szkolenia, ekspertyzy, wdro\u017cenia. Technologie Oracle, PostgreSQL, MySQL.\",\"publisher\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/explainit.pl\/wordpress\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#organization\",\"name\":\"Explain IT\",\"url\":\"https:\/\/explainit.pl\/wordpress\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2016\/08\/explainITmini.png\",\"contentUrl\":\"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2016\/08\/explainITmini.png\",\"width\":196,\"height\":64,\"caption\":\"Explain IT\"},\"image\":{\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/740773131bc169a2dc9c0e5e07476219\",\"name\":\"Maciej Zakrzewicz\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9c98d020128b142a480aa35a22300a69?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9c98d020128b142a480aa35a22300a69?s=96&d=mm&r=g\",\"caption\":\"Maciej Zakrzewicz\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Database 12.2 Database Sharding - porady praktyczne - Explain IT","description":"Oracle Database 12.2 Database Sharding - porady praktyczne","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:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/","og_locale":"pl_PL","og_type":"article","og_title":"Oracle Database 12.2 Database Sharding - porady praktyczne - Explain IT","og_description":"Oracle Database 12.2 Database Sharding - porady praktyczne","og_url":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/","og_site_name":"Explain IT","article_published_time":"2017-06-10T13:12:49+00:00","og_image":[{"url":"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2017\/01\/filetype_pdf.png"}],"author":"Maciej Zakrzewicz","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"Maciej Zakrzewicz","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/#article","isPartOf":{"@id":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/"},"author":{"name":"Maciej Zakrzewicz","@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/740773131bc169a2dc9c0e5e07476219"},"headline":"Oracle Database 12.2 Database Sharding &#8211; porady praktyczne","datePublished":"2017-06-10T13:12:49+00:00","dateModified":"2017-06-10T13:12:49+00:00","mainEntityOfPage":{"@id":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/"},"wordCount":323,"commentCount":0,"publisher":{"@id":"https:\/\/explainit.pl\/wordpress\/#organization"},"keywords":["12.2","Database Sharding"],"articleSection":["Oracle Database"],"inLanguage":"pl-PL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/","url":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/","name":"Oracle Database 12.2 Database Sharding - porady praktyczne - Explain IT","isPartOf":{"@id":"https:\/\/explainit.pl\/wordpress\/#website"},"datePublished":"2017-06-10T13:12:49+00:00","dateModified":"2017-06-10T13:12:49+00:00","description":"Oracle Database 12.2 Database Sharding - porady praktyczne","breadcrumb":{"@id":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/explainit.pl\/wordpress\/2017\/06\/10\/oracle-database-12-2-database-sharding-porady-praktyczne\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/explainit.pl\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Oracle Database 12.2 Database Sharding &#8211; porady praktyczne"}]},{"@type":"WebSite","@id":"https:\/\/explainit.pl\/wordpress\/#website","url":"https:\/\/explainit.pl\/wordpress\/","name":"Explain IT","description":"Autorska pracownia doradztwa i szkole\u0144 IT - Maciej Zakrzewicz - szkolenia, ekspertyzy, wdro\u017cenia. Technologie Oracle, PostgreSQL, MySQL.","publisher":{"@id":"https:\/\/explainit.pl\/wordpress\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/explainit.pl\/wordpress\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Organization","@id":"https:\/\/explainit.pl\/wordpress\/#organization","name":"Explain IT","url":"https:\/\/explainit.pl\/wordpress\/","logo":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/logo\/image\/","url":"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2016\/08\/explainITmini.png","contentUrl":"https:\/\/explainit.pl\/wordpress\/wp-content\/uploads\/2016\/08\/explainITmini.png","width":196,"height":64,"caption":"Explain IT"},"image":{"@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/740773131bc169a2dc9c0e5e07476219","name":"Maciej Zakrzewicz","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/explainit.pl\/wordpress\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9c98d020128b142a480aa35a22300a69?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9c98d020128b142a480aa35a22300a69?s=96&d=mm&r=g","caption":"Maciej Zakrzewicz"}}]}},"_links":{"self":[{"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/posts\/521"}],"collection":[{"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/comments?post=521"}],"version-history":[{"count":2,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/posts\/521\/revisions"}],"predecessor-version":[{"id":523,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/posts\/521\/revisions\/523"}],"wp:attachment":[{"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/media?parent=521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/categories?post=521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/explainit.pl\/wordpress\/wp-json\/wp\/v2\/tags?post=521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}