{"id":87814,"date":"2020-07-10T13:42:14","date_gmt":"2020-07-10T11:42:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy"},"modified":"2020-07-10T13:42:14","modified_gmt":"2020-07-10T11:42:14","slug":"chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy","title":{"rendered":"\u00c7far\u00eb \u00ebsht\u00eb m\u00eb mir\u00eb \u2013 Oracle apo Redis apo Si t\u00eb justifikohet zgjedhja e platform\u00ebs","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<blockquote><p>\u2014 Kjo duhet, \u2014 tha ajo me z\u00eb t\u00eb lart\u00eb, pa u drejtuar askujt. \u2014 Kjo duhet! K\u00ebshtu shkruhet qart\u00eb \u2013 detyra kryesore e shoq\u00ebris\u00eb \u00ebsht\u00eb t\u00eb nxjerr\u00eb fitim n\u00eb interes t\u00eb aksionar\u00ebve. Mendoni pak! Nuk kan\u00eb frik\u00eb nga asgj\u00eb!<\/p>\n<p><i>Juli Dubov, \u00abE keqja m\u00eb e vog\u00ebl\u00bb<\/i><\/p><\/blockquote>\n<p>\nDuke par\u00eb nj\u00eb titull t\u00eb till\u00eb, sigurisht q\u00eb tashm\u00eb keni vendosur se artikulli \u00ebsht\u00eb \u2013 ose budallall\u00ebk, ose provokim. Por mos u nxini n\u00eb p\u00ebrfundime: punonj\u00ebsve t\u00eb korporatave t\u00eb m\u00ebdha, ve\u00e7an\u00ebrisht atyre me pjes\u00ebmarrje shtet\u00ebrore, shpeshher\u00eb u duhet t\u00eb krahasojn\u00eb platforma t\u00eb ndryshme, p\u00ebrfshir\u00eb edhe ato krejt\u00ebsisht t\u00eb ndryshme \u2013 si\u00e7 jan\u00eb ato t\u00eb p\u00ebrmendura n\u00eb titull.<\/p>\n<p><img decoding=\"async\" alt=\"\u00c7far\u00eb \u00ebsht\u00eb m\u00eb mir\u00eb \u2013 Oracle apo Redis apo Si t\u00eb justifikohet zgjedhja e platform\u00ebs\" src=\"\/wp-content\/uploads\/2020\/07\/6b0c0a3a60794b2a9e98733e59eec6da.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSigurisht, askush nuk i krahason DBMS-t\u00eb, pasi pikat e tyre t\u00eb forta dhe t\u00eb dob\u00ebta jan\u00eb t\u00eb njohura mir\u00eb. N\u00eb p\u00ebrgjith\u00ebsi, platforma q\u00eb i n\u00ebnshtrohen krahasimit jan\u00eb ato q\u00eb zgjidhin nj\u00eb detyr\u00eb aplikuese. N\u00eb k\u00ebt\u00eb artikull do tregoj metodologjin\u00eb q\u00eb p\u00ebrdoret n\u00eb k\u00ebt\u00eb rast, duke marr\u00eb si shembull bazat e t\u00eb dh\u00ebnave, nj\u00eb subjekt q\u00eb lexuesit e Habr\u00ebs e njohin mir\u00eb. Pra,<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h4>Motivimi<\/h4>\n<p>\nKur filloni nj\u00eb projekt shkollor ose nj\u00eb projekt-hobi, motivimi p\u00ebr zgjedhjen e platform\u00ebs mund t\u00eb jet\u00eb shum\u00eb i ndrysh\u00ebm: \u00abkjo \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u00eb e njoh m\u00eb mir\u00eb\u00bb, \u00abm\u00eb intereson t\u00eb eksploroj k\u00ebt\u00eb\u00bb, \u00abk\u00ebtu \u00ebsht\u00eb dokumentacioni m\u00eb i mir\u00eb\u00bb... N\u00eb rastin e nj\u00eb kompanie tregtare, kriteri i zgjedhjes \u00ebsht\u00eb nj\u00eb: sa do t\u00eb paguaj dhe \u00e7far\u00eb do t\u00eb marr p\u00ebr k\u00ebto para.<\/p>\n<p>Natyrisht, d\u00ebshira \u00ebsht\u00eb t\u00eb paguash m\u00eb pak, por t\u00eb marr\u00ebsh m\u00eb shum\u00eb. Megjithat\u00eb, \u00ebsht\u00eb e nevojshme t\u00eb vendos\u00ebsh se \u00e7far\u00eb \u00ebsht\u00eb m\u00eb e r\u00ebnd\u00ebsishme \u2013 t\u00eb paguash m\u00eb pak apo t\u00eb marr\u00ebsh m\u00eb shum\u00eb, dhe t'i jap\u00ebsh \u00e7do elementi nj\u00eb pesh\u00eb. Le t\u00eb supozojm\u00eb se na intereson nj\u00eb zgjidhje cil\u00ebsore, m\u00eb shum\u00eb sesa nj\u00eb t\u00eb lir\u00eb, dhe t'i japim elementit \"Kosto\" nj\u00eb pesh\u00eb prej 40%, nd\u00ebrsa elementit \"Mund\u00ebsi\" - 60%.<\/p>\n<p><img decoding=\"async\" alt=\"\u00c7far\u00eb \u00ebsht\u00eb m\u00eb mir\u00eb \u2013 Oracle apo Redis apo Si t\u00eb justifikohet zgjedhja e platform\u00ebs\" src=\"\/wp-content\/uploads\/2020\/07\/b3ba842198428e7de98f3b5a27591d43.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nN\u00eb korporatat e m\u00ebdha zakonisht \u00ebsht\u00eb e kund\u00ebrta \u2013 pesha e kostos nuk bie n\u00ebn 50%, ndoshta edhe m\u00eb shum\u00eb se 60%. N\u00eb shembullin model, e r\u00ebnd\u00ebsishme \u00ebsht\u00eb vet\u00ebm q\u00eb pesha totale e n\u00ebn-elementeve t\u00eb \u00e7do elementi prind duhet t\u00eb jet\u00eb 100%.<\/p>\n<h4>Kushtet p\u00ebrjashtuese<\/h4>\n<p>\nFaqes <noindex><a rel=\"nofollow\" href=\"https:\/\/db-engines.com\/\">db-engines.com<\/a><\/noindex> jan\u00eb t\u00eb njohura rreth 500 sisteme menaxhimi t\u00eb bazave t\u00eb dh\u00ebnash. Natyrisht, n\u00ebse zgjidhet nj\u00eb platform\u00eb objektiv nga nj\u00eb num\u00ebr kaq i madh opsionesh, at\u00ebher\u00eb mund t\u00eb ndodh\u00eb nj\u00eb artikull p\u00ebrmbledh\u00ebs, por jo nj\u00eb projekt tregtar. P\u00ebr t\u00eb reduktuar hap\u00ebsir\u00ebn e zgjedhjes, formulohet nj\u00eb grup kriteresh p\u00ebrjashtuese, dhe n\u00ebse platforma nuk i p\u00ebrmbush k\u00ebto kritere, at\u00ebher\u00eb ajo nuk shqyrtohet.<\/p>\n<p>Kriteret p\u00ebrjashtuese mund t\u00eb lidhen me ve\u00e7orit\u00eb teknologjike, p\u00ebr shembull:<\/p>\n<ul>\n<li>Garancit\u00eb ACID;<\/li>\n<li>Modeli relacional i t\u00eb dh\u00ebnave;<\/li>\n<li>Mb\u00ebshtetje p\u00ebr gjuh\u00ebn SQL (vini re, kjo nuk \u00ebsht\u00eb e nj\u00ebjt\u00eb me \"modelin relacional\");<\/li>\n<li>Mund\u00ebsia e shkall\u00ebzimit horizontal.<\/li>\n<\/ul>\n<p>\nMund t\u00eb ket\u00eb kritere t\u00eb natyrshme t\u00eb p\u00ebrgjithshme:<\/p>\n<ul>\n<li>prania e mb\u00ebshtetjes tregtare n\u00eb Rusi;<\/li>\n<li>burim t\u00eb hapur;<\/li>\n<li>prania e platform\u00ebs n\u00eb Regjistrin e Ministris\u00eb s\u00eb Komunikimeve;<\/li>\n<li>prania e platform\u00ebs n\u00eb ndonj\u00eb renditje (p.sh., n\u00eb 100 m\u00eb t\u00eb mirat n\u00eb renditjen db-engines.com);<\/li>\n<li>prania e ekspert\u00ebve n\u00eb treg (p.sh., sipas rezultateve t\u00eb k\u00ebrkimit t\u00eb emrit t\u00eb platform\u00ebs n\u00eb CV-t\u00eb n\u00eb faqen hh.ru).<\/li>\n<\/ul>\n<p>\nP\u00ebrve\u00e7 k\u00ebsaj, mund t\u00eb ket\u00eb kritere specifike p\u00ebr nd\u00ebrmarrjen:<\/p>\n<ul>\n<li>prania e specialist\u00ebve n\u00eb stafin;<\/li>\n<li>kompatibiliteti me sistemin e monitorimit X ose me sistemin e kopjimit Y, n\u00eb t\u00eb cilin mb\u00ebshtetet e gjith\u00eb mb\u00ebshtetje\u2026<\/li>\n<\/ul>\n<p>\nM\u00eb e r\u00ebnd\u00ebsishmja, \u00ebsht\u00eb q\u00eb t\u00eb ekzistoj\u00eb nj\u00eb list\u00eb e kritereve p\u00ebrjashtuese. N\u00eb t\u00eb kund\u00ebrt, do t\u00eb ket\u00eb sigurisht ndonj\u00eb ekspert (ose \"ekspert\"), q\u00eb g\u00ebzon besim t\u00eb ve\u00e7ant\u00eb t\u00eb drejtuesve, i cili do t\u00eb thot\u00eb \"pse nuk e zgjidh\u00ebt platform\u00ebn Z, e di q\u00eb ajo \u00ebsht\u00eb m\u00eb e mira\". <\/p>\n<h4>Vler\u00ebsimi i kostos<\/h4>\n<p>\nKostoja e zgjidhjes p\u00ebrb\u00ebhet qart\u00eb nga kostoja e licencave, kostoja e mb\u00ebshtetjes dhe kostoja e pajisjeve.<\/p>\n<p>N\u00ebse sistemet jan\u00eb af\u00ebrsisht t\u00eb nj\u00eb klase (p.sh., Microsoft SQL Server dhe PostgreSQL), at\u00ebher\u00eb p\u00ebr thjesht\u00ebsi mund t\u00eb supozojm\u00eb se numri i pajisjeve p\u00ebr t\u00eb dy zgjidhjet do t\u00eb jet\u00eb af\u00ebrsisht i nj\u00ebjt\u00eb. Kjo do t\u00eb lejoj\u00eb q\u00eb t\u00eb mos vler\u00ebsohet pajisjet, duke kursyer k\u00ebshtu shum\u00eb koh\u00eb dhe energji. N\u00ebse megjithat\u00eb duhet t\u00eb krahasohen sisteme krejt\u00ebsisht t\u00eb ndryshme (p.sh., Oracle kundrejt Redis), \u00ebsht\u00eb e qart\u00eb se p\u00ebr vler\u00ebsim t\u00eb sakt\u00eb \u00ebsht\u00eb e nevojshme t\u00eb b\u00ebhet sizing (llogaritja e numrit t\u00eb pajisjeve). Sizingu i nj\u00eb sistemi t\u00eb paekzistuesh\u00ebm \u00ebsht\u00eb nj\u00eb pun\u00eb shum\u00eb e v\u00ebshtir\u00eb, prandaj zakonisht p\u00ebrpiqen t\u00eb shmangin nj\u00eb krahasim t\u00eb till\u00eb. \u00cbsht\u00eb e thjesht\u00eb ta b\u00ebsh k\u00ebt\u00eb: n\u00eb kushtet p\u00ebrjashtuese shkruhen humbje zero t\u00eb t\u00eb dh\u00ebnave dhe modeli relacional ose p\u00ebrkundrazi \u2013 ngarkesa prej 50 mij\u00eb transaksionesh n\u00eb sekond\u00eb.<\/p>\n<p>P\u00ebr t\u00eb vler\u00ebsuar licencat, \u00ebsht\u00eb e mjaftueshme t\u00eb k\u00ebrkoni nga vendor\u00ebt ose partner\u00ebt e tij \u00e7mimin e licenc\u00ebs p\u00ebr nj\u00eb num\u00ebr t\u00eb caktuar b\u00ebrthamash dhe mb\u00ebshtetje p\u00ebr nj\u00eb periudh\u00eb t\u00eb caktuar. Si rregull, kompanit\u00eb kan\u00eb nd\u00ebrtuar marr\u00ebdh\u00ebnie t\u00eb forta me vendor\u00ebt e softuerit, dhe n\u00ebse departamenti i operacioneve t\u00eb DB-s\u00eb nuk mund t\u00eb p\u00ebrgjigjet p\u00ebr \u00e7mimin vet\u00eb, p\u00ebr t\u00eb marr\u00eb k\u00ebt\u00eb informacion mjafton nj\u00eb let\u00ebr.<\/p>\n<p>Vendor\u00ebt e ndrysh\u00ebm mund t\u00eb ken\u00eb metrika t\u00eb ndryshme p\u00ebr licencimin: sipas numrit t\u00eb b\u00ebrthamave, volumit t\u00eb t\u00eb dh\u00ebnave apo numrit t\u00eb nyjeve. Nj\u00eb baz\u00eb Standby mund t\u00eb jet\u00eb falas, ose mund t\u00eb licencohet ashtu si baza kryesore. N\u00ebse zbulojn\u00eb ndonj\u00eb dallim n\u00eb metrika, do t\u00eb duhet t\u00eb p\u00ebrshkruajn\u00eb detajisht modelin e pistol\u00ebs dhe t\u00eb llogarisin \u00e7mimin e licencave p\u00ebr t\u00eb.<\/p>\n<p>Nj\u00eb \u00e7\u00ebshtje e r\u00ebnd\u00ebsishme p\u00ebr krahasim t\u00eb sakt\u00eb \u00ebsht\u00eb t\u00eb nj\u00ebjtat kushte mb\u00ebshtetjeje. Le t\u00eb themi, mb\u00ebshtetja p\u00ebr Oracle kushton 22% t\u00eb \u00e7mimit t\u00eb licenc\u00ebs p\u00ebr \u00e7do vit, nd\u00ebrsa p\u00ebr mb\u00ebshtetje PostgreSQL mund t\u00eb mos paguhet. A \u00ebsht\u00eb e sakt\u00eb t\u00eb krahasohet k\u00ebshtu? Jo, sepse pasojat e nj\u00eb gabimi q\u00eb nuk mund t\u00eb rregullohet me forcat e veta jan\u00eb krejt\u00ebsisht t\u00eb ndryshme: n\u00eb rastin e par\u00eb specialist\u00ebt e mb\u00ebshtetjes do t\u00eb ndihmojn\u00eb t\u00eb zgjidhin shpejt, nd\u00ebrsa n\u00eb rastin e dyt\u00eb ka rrezik p\u00ebr vones\u00ebn e projektit ose ndalimin e sistemit t\u00eb gatsh\u00ebm p\u00ebr nj\u00eb periudh\u00eb t\u00eb pacaktuar.<\/p>\n<p>Mund t\u00eb barazoni kushtet e llogaritjes n\u00eb tre m\u00ebnyra:<\/p>\n<ol>\n<li>T\u00eb p\u00ebrdorni Oracle pa mb\u00ebshtetje (n\u00eb realitet kjo nuk ndodh).<\/li>\n<li>T\u00eb blini mb\u00ebshtetje p\u00ebr PostgreSQL - p\u00ebr shembull, nga kompania Postgres Professional.<\/li>\n<li>T\u00eb p\u00ebrfshini n\u00eb llogaritje rreziqet e lidhura me munges\u00ebn e mb\u00ebshtetjes.<\/li>\n<\/ol>\n<p>\nP\u00ebr shembull, llogaritja e rreziqeve mund t\u00eb duket k\u00ebshtu: n\u00eb rast t\u00eb nj\u00eb d\u00ebshtimi t\u00eb pazgjidhsh\u00ebm t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, ndalimi i sistemit do t\u00eb zgjas\u00eb 1 dit\u00eb pune. Fitimi i parashikuar nga p\u00ebrdorimi i sistemit \u00ebsht\u00eb 40 miliard\u00eb tugrik\u00eb mongole n\u00eb vit, frekuenca e aksidenteve vler\u00ebsohet si 1\/400, k\u00ebshtu q\u00eb rreziku i munges\u00ebs s\u00eb mb\u00ebshtetjes vler\u00ebsohet n\u00eb rreth 100 milion tugrik\u00eb mongole n\u00eb vit. \u00cbsht\u00eb e qart\u00eb se \"fitimi i parashikuar\" dhe \"frekuenca e vler\u00ebsuar e aksidenteve\" jan\u00eb vlera virtuale, por \u00ebsht\u00eb shum\u00eb m\u00eb mir\u00eb t\u00eb kesh nj\u00eb model t\u00eb till\u00eb sesa t\u00eb mos kesh asnj\u00eb.<\/p>\n<p>N\u00eb realitet, sistemi mund t\u00eb jet\u00eb shum\u00eb i r\u00ebnd\u00ebsish\u00ebm, dhe humbjet reputacionale nga nj\u00eb koh\u00eb e gjat\u00eb ndalimi do t\u00eb ishin t\u00eb papranueshme, prandaj mb\u00ebshtetje \u00ebsht\u00eb e nevojshme. N\u00ebse megjithat\u00eb lejohet ndalja, at\u00ebher\u00eb heqja e mb\u00ebshtetjes ndonj\u00ebher\u00eb mund t\u00eb jet\u00eb nj\u00eb m\u00ebnyr\u00eb e mir\u00eb p\u00ebr t\u00eb kursyer.<\/p>\n<p>Le t\u00eb supozojm\u00eb se pas t\u00eb gjitha llogaritjeve, kostoja e operacionit t\u00eb platform\u00ebs A gjat\u00eb 5 viteve t\u00eb ardhsh\u00ebm ishte 800 milion tugrik\u00eb mongole, kostoja e operacionit t\u00eb platform\u00ebs B \u2013 650 milion tugrik\u00eb, dhe kostoja e operacionit t\u00eb platform\u00ebs C \u2013 600 milion tugrik\u00eb. Platforma C si fituese merr nj\u00eb pik\u00eb t\u00eb plot\u00eb p\u00ebr koston, nd\u00ebrsa platformat A dhe B marrin pak m\u00eb pak, proporcionalisht me sa m\u00eb t\u00eb shtrenjta jan\u00eb ato. N\u00eb k\u00ebt\u00eb rast \u2013 0.75 dhe 0.92 pik\u00eb p\u00ebrkat\u00ebsisht.<\/p>\n<h4>Vler\u00ebsimi i mund\u00ebsive<\/h4>\n<p>\nVler\u00ebsimi i mund\u00ebsive ndahet n\u00eb shum\u00eb grupe, numri i t\u00eb cilave \u00ebsht\u00eb i kufizuar vet\u00ebm nga fantazia e atij q\u00eb e b\u00ebn vler\u00ebsimin. Nj\u00eb opsion optimal duket t\u00eb jet\u00eb ndarja e mund\u00ebsive sipas ekipeve q\u00eb do t'i p\u00ebrdorin ato; n\u00eb shembullin ton\u00eb, k\u00ebtu jan\u00eb zhvilluesit, administrator\u00ebt dhe oficer\u00ebt e siguris\u00eb informative. Le t\u00eb supozojm\u00eb se pesha e k\u00ebtyre funksioneve ndahet si 40:40:20.<\/p>\n<p>N\u00eb funksionet e zhvillimit mund t\u00eb p\u00ebrfshihen:<\/p>\n<ul>\n<li>leht\u00ebsia e manipulimit t\u00eb t\u00eb dh\u00ebnave;<\/li>\n<li>shkall\u00ebzimi;<\/li>\n<li>prania e indekseve t\u00eb dyta.<\/li>\n<\/ul>\n<p>\nLista e kritereve, si dhe pesha e tyre, jan\u00eb shum\u00eb subjektive. Edhe n\u00eb zgjidhjen e t\u00eb nj\u00ebjtit problem, k\u00ebto lista, pesha e pik\u00ebve dhe p\u00ebrgjigjet do t\u00eb jen\u00eb duksh\u00ebm t\u00eb ndryshme n\u00eb var\u00ebsi t\u00eb p\u00ebrb\u00ebrjes s\u00eb ekipit tuaj. K\u00ebshtu, p\u00ebr shembull, Facebook p\u00ebrdor MySQL p\u00ebr ruajtjen e t\u00eb dh\u00ebnave, nd\u00ebrsa Instagram \u00ebsht\u00eb nd\u00ebrtuar mbi baz\u00ebn Cassandra. Ka gjasa q\u00eb zhvilluesit e k\u00ebtyre aplikacioneve nuk kan\u00eb plot\u00ebsuar tabela t\u00eb tilla. Mund t\u00eb supozohet vet\u00ebm se Mark Zuckerberg ka zgjedhur nj\u00eb model relacional t\u00eb plot\u00eb, duke paguar p\u00ebr k\u00ebt\u00eb me nevoj\u00ebn p\u00ebr ndarjen e aplikacioneve, nd\u00ebrsa Kevin Systrom ka nd\u00ebrtuar shkall\u00ebzimin me an\u00eb t\u00eb platform\u00ebs, duke sakrifikuar leht\u00ebsin\u00eb e aksesit n\u00eb t\u00eb dh\u00ebna.<\/p>\n<p>N\u00eb funksionet e administrat\u00ebs p\u00ebrfshihen:<\/p>\n<ul>\n<li>mund\u00ebsit\u00eb e sistemit t\u00eb kopjimit;<\/li>\n<li>leht\u00ebsia e monitorimit;<\/li>\n<li>leht\u00ebsia e menaxhimit t\u00eb kapaciteteve \u2013 disqe dhe nyje;<\/li>\n<li>mund\u00ebsit\u00eb e replikimit t\u00eb t\u00eb dh\u00ebnave.<\/li>\n<\/ul>\n<p>\nKujdes, se formulimet e pyetjeve duhet t\u00eb lejojn\u00eb vler\u00ebsimin e sasis\u00eb. Mund t\u00eb bie dakord gjithashtu se si t\u00eb vler\u00ebsojm\u00eb funksionin e caktuar. Le t\u00eb p\u00ebrpiqemi, p\u00ebr shembull, t\u00eb vler\u00ebsojm\u00eb mjetet e kopjimit t\u00eb rezerv\u00ebs duke p\u00ebrdorur mjetet q\u00eb ofrohen me DBMS Oracle:<\/p>\n<p>Mjeti<br \/>\nKoment<br \/>\nVler\u00ebsimi<\/p>\n<p>imp\/exp<br \/>\nEkstraktimi dhe ngarkimi i t\u00eb dh\u00ebnave<br \/>\n0.1<\/p>\n<p>fillim\/fund backup<br \/>\nKopjimi i skedave<br \/>\n0.3<\/p>\n<p>RMAN<br \/>\nMund\u00ebsia p\u00ebr kopjim inkremental<br \/>\n0.7<\/p>\n<p>ZDLRA<br \/>\nKopjim vet\u00ebm inkremental, rikuperim m\u00eb i shpejt\u00eb n\u00eb pik\u00ebn<br \/>\n1.0<\/p>\n<p>\nN\u00ebse nuk ka kritere t\u00eb qarta vler\u00ebsimi, ka kuptim t\u00eb k\u00ebrkoni nga disa ekspert\u00eb t\u00eb japin vler\u00ebsime, dhe pastaj t\u00eb mesatarizohen ato.<\/p>\n<p>M\u00eb n\u00eb fund, le t\u00eb rendisim thjesht funksionet e siguris\u00eb informative:<\/p>\n<ul>\n<li>prania e politikave p\u00ebr menaxhimin e fjal\u00ebkalimeve;<\/li>\n<li>mund\u00ebsia p\u00ebr t'u lidhur me mjete autentikimi t\u00eb jashtme (LDAP, Kerberos);<\/li>\n<li>modeli i aksesit t\u00eb rolit;<\/li>\n<li>mund\u00ebsit\u00eb p\u00ebr auditim;<\/li>\n<li>kriptimi i t\u00eb dh\u00ebnave n\u00eb disk;<\/li>\n<li>kriptimi gjat\u00eb transmetimit n\u00eb rrjet (TLS);<\/li>\n<li>mbrojtja e t\u00eb dh\u00ebnave nga administrator\u00ebt.<\/li>\n<\/ul>\n<p><\/p>\n<h4>Testimi i performanc\u00ebs<\/h4>\n<p>\nVe\u00e7mas, do t\u00eb doja t\u00eb paralajm\u00ebroja nga p\u00ebrdorimi si argument i rezultateve t\u00eb ndonj\u00eb testi t\u00eb ngarkes\u00ebs, t\u00eb b\u00ebr\u00eb nga ju.<\/p>\n<p>S\u00eb pari, struktura e t\u00eb dh\u00ebnave dhe profili i ngarkes\u00ebs s\u00eb aplikacioneve t\u00eb testuara mund t\u00eb ndryshojn\u00eb ndjesh\u00ebm nga ajo q\u00eb po planifikoni t\u00eb zgjidhni. 10-15 vjet m\u00eb par\u00eb, prodhuesit e bazave t\u00eb t\u00eb dh\u00ebnave m\u00eb p\u00eblqente t\u00eb tregonin rezultate t\u00eb arritura n\u00eb testet TPC, por tani, duket se askush nuk i merr k\u00ebto rezultate seriozisht.<\/p>\n<p>S\u00eb dyti, performanca e sistemit varet mjaft nga platforma p\u00ebr t\u00eb cil\u00ebn fillimisht \u00ebsht\u00eb shkruar kodi dhe n\u00eb cilin hardware \u00ebsht\u00eb b\u00ebr\u00eb testi. Kam par\u00eb shum\u00eb testime ku Oracle \u00ebsht\u00eb krahasuar me PostgreSQL. Rezultatet variojn\u00eb nga superioriteti i padiskutuesh\u00ebm i nj\u00eb sistemi deri n\u00eb nj\u00eb superioritet t\u00eb till\u00eb t\u00eb padiskutuesh\u00ebm t\u00eb tjetrit.<\/p>\n<p>Dhe s\u00eb fundmi, s\u00eb treti, nuk dini asgj\u00eb p\u00ebr at\u00eb q\u00eb e kryen testin. \u00cbsht\u00eb e r\u00ebnd\u00ebsishme si kualifikimi, q\u00eb ndikon n\u00eb cil\u00ebsin\u00eb e konfigurimit t\u00eb OS dhe platform\u00ebs, ashtu edhe motivimi, q\u00eb ndikon n\u00eb rezultatet e testit m\u00eb shum\u00eb se \u00e7do faktor tjet\u00ebr s\u00eb bashku.<\/p>\n<p>N\u00ebse performanca \u00ebsht\u00eb nj\u00eb faktor kritike, kryeni testin vet\u00eb, preferably me pjes\u00ebmarrjen e specialist\u00ebve q\u00eb do t\u00eb konfigurojn\u00eb dhe mb\u00ebshtesin sistemin industrial.<\/p>\n<h4>Rezultati<\/h4>\n<p>\nN\u00eb fund, rezultati i t\u00ebr\u00eb pun\u00ebs duhet t\u00eb jet\u00eb nj\u00eb tabel\u00eb elektronike, ku t\u00eb gjitha notat jan\u00eb aggreguar, shumzuar dhe p\u00ebrmbledhur:<\/p>\n<p><img decoding=\"async\" alt=\"\u00c7far\u00eb \u00ebsht\u00eb m\u00eb mir\u00eb \u2013 Oracle apo Redis apo Si t\u00eb justifikohet zgjedhja e platform\u00ebs\" src=\"\/wp-content\/uploads\/2020\/07\/760bfe92d02865ec27ab6ac28d64e855.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSi\u00e7 e kuptoni, duke ndryshuar peshat dhe duke korrigjuar notat, mund t\u00eb arrihet \u00e7do rezultat i k\u00ebrkuar, por kjo \u00ebsht\u00eb nj\u00eb histori krejt ndryshe...<br \/>\n<br \/>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/510176\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u2013\u00a0\u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e,\u00a0\u2014 \u043d\u0438 \u043a \u043a\u043e\u043c\u0443 \u043d\u0435 \u043e\u0431\u0440\u0430\u0449\u0430\u044f\u0441\u044c, \u0433\u0440\u043e\u043c\u043a\u043e \u0441\u043a\u0430\u0437\u0430\u043b\u0430 \u043e\u043d\u0430.\u00a0\u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e! \u0422\u0430\u043a \u043f\u0440\u044f\u043c\u043e \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u2013 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0431\u044b\u043b\u0438 \u0432\u00a0\u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430\u0445 \u0430\u043a\u0446\u0438\u043e\u043d\u0435\u0440\u043e\u0432. \u041d\u0443 \u0432\u044b \u043f\u043e\u0434\u0443\u043c\u0430\u0439\u0442\u0435! \u041d\u0438\u0447\u0435\u0433\u043e \u043d\u0435 \u0431\u043e\u044f\u0442\u0441\u044f! \u042e\u043b\u0438\u0439 \u0414\u0443\u0431\u043e\u0432, \u00ab\u041c\u0435\u043d\u044c\u0448\u0435\u0435 \u0437\u043b\u043e\u00bb \u0423\u0432\u0438\u0434\u0435\u0432 \u0442\u0430\u043a\u043e\u0439 \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a, \u0432\u044b \u043d\u0430\u0432\u0435\u0440\u043d\u044f\u043a\u0430 \u0443\u0436\u0435 \u0440\u0435\u0448\u0438\u043b\u0438, \u0447\u0442\u043e \u0441\u0442\u0430\u0442\u044c\u044f \u2013 \u0438\u043b\u0438 \u0433\u043b\u0443\u043f\u043e\u0441\u0442\u044c, \u0438\u043b\u0438 \u043f\u0440\u043e\u0432\u043e\u043a\u0430\u0446\u0438\u044f. \u041d\u043e \u043d\u0435 \u0441\u043f\u0435\u0448\u0438\u0442\u0435 \u0441 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":87815,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-87814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e, \u2014 \u043d\u0438 \u043a \u043a\u043e\u043c\u0443 \u043d\u0435 \u043e\u0431\u0440\u0430\u0449\u0430\u044f\u0441\u044c, \u0433\u0440\u043e\u043c\u043a\u043e \u0441\u043a\u0430\u0437\u0430\u043b\u0430 \u043e\u043d\u0430. \u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e! \u0422\u0430\u043a \u043f\u0440\u044f\u043c\u043e \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u2013 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0431\u044b\u043b\u0438 \u0432 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430\u0445 \u0430\u043a\u0446\u0438\u043e\u043d\u0435\u0440\u043e\u0432.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0427\u0442\u043e \u043b\u0443\u0447\u0448\u0435 \u2013 Oracle \u0438\u043b\u0438 Redis \u0438\u043b\u0438 \u041a\u0430\u043a \u043e\u0431\u043e\u0441\u043d\u043e\u0432\u0430\u0442\u044c \u0432\u044b\u0431\u043e\u0440 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e, \u2014 \u043d\u0438 \u043a \u043a\u043e\u043c\u0443 \u043d\u0435 \u043e\u0431\u0440\u0430\u0449\u0430\u044f\u0441\u044c, \u0433\u0440\u043e\u043c\u043a\u043e \u0441\u043a\u0430\u0437\u0430\u043b\u0430 \u043e\u043d\u0430. \u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e! \u0422\u0430\u043a \u043f\u0440\u044f\u043c\u043e \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u2013 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0431\u044b\u043b\u0438 \u0432 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430\u0445 \u0430\u043a\u0446\u0438\u043e\u043d\u0435\u0440\u043e\u0432.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-07-10T11:42:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-07-10T11:42:14+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Cili \u00ebsht\u00eb m\u00eb i mir\u00eb \u2013 Oracle apo Redis ose Si t\u00eb justifikoni zgjedhjen e platform\u00ebs | ProHoster","description":"\u2013 Kjo \u00ebsht\u00eb di\u00e7ka, \u2013 tha ajo me z\u00eb t\u00eb lart\u00eb, pa u drejtuar askujt. \u2013 Kjo \u00ebsht\u00eb di\u00e7ka! K\u00ebshtu \u00ebsht\u00eb shkruar \u2013 q\u00ebllimi kryesor i shoq\u00ebris\u00eb \u00ebsht\u00eb t\u00eb nxjerr\u00eb fitime n\u00eb interes t\u00eb aksionar\u00ebve.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0427\u0442\u043e \u043b\u0443\u0447\u0448\u0435 \u2013 Oracle \u0438\u043b\u0438 Redis \u0438\u043b\u0438 \u041a\u0430\u043a \u043e\u0431\u043e\u0441\u043d\u043e\u0432\u0430\u0442\u044c \u0432\u044b\u0431\u043e\u0440 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b | ProHoster","og:description":"\u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e, \u2014 \u043d\u0438 \u043a \u043a\u043e\u043c\u0443 \u043d\u0435 \u043e\u0431\u0440\u0430\u0449\u0430\u044f\u0441\u044c, \u0433\u0440\u043e\u043c\u043a\u043e \u0441\u043a\u0430\u0437\u0430\u043b\u0430 \u043e\u043d\u0430. \u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e! \u0422\u0430\u043a \u043f\u0440\u044f\u043c\u043e \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u2013 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0431\u044b\u043b\u0438 \u0432 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430\u0445 \u0430\u043a\u0446\u0438\u043e\u043d\u0435\u0440\u043e\u0432.","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-07-10T11:42:14+00:00","article:modified_time":"2020-07-10T11:42:14+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"87814","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 13:42:29","updated":"2022-10-02 03:57:29","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/87814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=87814"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/87814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/87815"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=87814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=87814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=87814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}