{"id":73531,"date":"2020-03-10T14:42:30","date_gmt":"2020-03-10T11:42:30","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/postgresql-anonymizer-0-6-rasshirenie-dlya-anonimizaczii-dannyh-v-subd"},"modified":"2020-03-10T14:42:30","modified_gmt":"2020-03-10T11:42:30","slug":"postgresql-anonymizer-0-6-rasshirenie-dlya-anonimizaczii-dannyh-v-subd","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/postgresql-anonymizer-0-6-rasshirenie-dlya-anonimizaczii-dannyh-v-subd","title":{"rendered":"PostgreSQL Anonymizer 0.6, shtes\u00eb p\u00ebr anonimizimin e t\u00eb dh\u00ebnave n\u00eb DBMS","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

I verf\u00fcsh\u00ebm<\/a><\/noindex> l\u00ebshimi i ri i projektit PostgreSQL Anonymizer<\/a><\/noindex>, duke ofron nj\u00eb shtes\u00eb p\u00ebr SGB PostgreSQL, e cila zgjidh problemin e fshehjes ose z\u00ebvend\u00ebsimit t\u00eb t\u00eb dh\u00ebnave konfidenciale ose informacionit q\u00eb p\u00ebrb\u00ebn sekretin tregtar. T\u00eb dh\u00ebnat mund t\u00eb fshihen n\u00eb koh\u00eb reale n\u00eb baz\u00eb t\u00eb rregullave dhe listave t\u00eb p\u00ebrdoruesve t\u00eb p\u00ebrcaktuara posa\u00e7\u00ebrisht, p\u00ebrgjigjet ndaj k\u00ebrkesave t\u00eb cil\u00ebve duhet t\u00eb anonimizohen. Kodi distribuohet<\/a><\/noindex> n\u00eb p\u00ebrputhje me licenc\u00ebn PostgreSQL.<\/p>\n

P\u00ebr shembull, me an\u00eb t\u00eb shtes\u00ebs n\u00eb fjal\u00eb, mund t\u00eb sigurohet akses n\u00eb DB p\u00ebr pal\u00ebt e treta, si\u00e7 jan\u00eb sh\u00ebrbimet e jashtme t\u00eb analiz\u00ebs biznesore, duke e hequr automatikisht p\u00ebr ta t\u00eb dh\u00ebna si numrat e telefonave dhe kartat e kreditit, ose duke aplikuar metoda m\u00eb t\u00eb sofistikuara, si z\u00ebvend\u00ebsimi i emrave t\u00eb klient\u00ebve dhe kompanive me informacion t\u00eb rrem\u00eb. P\u00ebrve\u00e7 kryerjes s\u00eb anonimizimit gjat\u00eb lidhjes direkte me SGB, parashikohet nj\u00eb mod p\u00ebr krijimin e dump-\u00ebve SQL t\u00eb anonimizuar (\u00ebsht\u00eb propozuar utilitari pg_dump_anon). <\/p>\n

PostgreSQL Anonymizer shkall\u00ebzon<\/a><\/noindex> PostgreSQL DDL (Gjuha e Definimit t\u00eb Datan) dhe lejon caktimin e strategjis\u00eb s\u00eb anonimizimit n\u00eb nivelin e skem\u00ebs, e cila p\u00ebrcakton struktur\u00ebn e tabel\u00ebs. Ofron nj\u00eb grup t\u00eb gjer\u00eb funksionesh p\u00ebr p\u00ebrpunimin e t\u00eb dh\u00ebnave q\u00eb duhet t\u00eb z\u00ebvend\u00ebsohen: rast\u00ebsizimi, z\u00ebvend\u00ebsimi me vlera fiktive, pjes\u00ebrisht scrambling<\/a><\/noindex>, shuffling, zhurma etj. N\u00eb versionin e ri jan\u00eb shtuar funksione p\u00ebr identifikimin e identifikuesve, si dhe \u00ebsht\u00eb prezantuar nj\u00eb mod p\u00ebr pseudonimizimin, i cili lejon gjenerimin e vlerave fiktive realiste t\u00eb lidhura me t\u00eb dh\u00ebnat origjinale.<\/p>\n

\"PostgreSQL<\/center><\/p>\n

P\u00ebr m\u00eb tep\u00ebr, mund t\u00eb theksohet platforma e hapur q\u00eb zhvillohet nga Microsoft p\u00ebr identifikimin e rrjedhjeve t\u00eb informacionit konfidencial Presidio<\/a><\/noindex>. Platforma lejon identifikimin ose eliminimin n\u00eb dokumente, tekst dhe imazhe t\u00eb informacionit q\u00eb p\u00ebrmban t\u00eb dh\u00ebna personale dhe konfidenciale, si emrat e plot\u00eb, numrat e telefonave, email, numrat e kartave t\u00eb kreditit, portofolat kriptografik\u00eb, adresat, numrat e pasaportave, t\u00eb dh\u00ebnat financiare etj. Mb\u00ebshtetet p\u00ebrpunimi i burimeve t\u00eb ndryshme (nga Amazon S3 n\u00eb PostgreSQL) dhe formateve. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn Go (ka nj\u00eb version n\u00eb Python) dhe distribuohet<\/a><\/noindex> n\u00eb p\u00ebrputhje me licenc\u00ebn MIT. <\/p>\n

\"PostgreSQL<\/a><\/noindex><\/center><\/p>\n

<\/a><\/noindex><\/p>\n

Burimi: opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u043d\u043e\u0432\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 PostgreSQL Anonymizer, \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0435\u0433\u043e \u0434\u043e\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u043a \u0421\u0423\u0411\u0414 PostgreSQL, \u0440\u0435\u0448\u0430\u044e\u0449\u0435\u0435 \u0437\u0430\u0434\u0430\u0447\u0443 \u0441\u043a\u0440\u044b\u0442\u0438\u044f \u0438\u043b\u0438 \u0437\u0430\u043c\u0435\u043d\u044b \u043a\u043e\u043d\u0444\u0435\u0434\u0435\u043d\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0445 \u0434\u0430\u043d\u043d\u044b\u0445 \u0438\u043b\u0438 \u0441\u0432\u0435\u0434\u0435\u043d\u0438\u0439, \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u044e\u0449\u0438\u0445 \u043a\u043e\u043c\u043c\u0435\u0440\u0447\u0435\u0441\u043a\u0443\u044e \u0442\u0430\u0439\u043d\u0443. \u0414\u0430\u043d\u043d\u044b\u0435 \u043c\u043e\u0433\u0443\u0442 \u0441\u043a\u0440\u044b\u0432\u0430\u0442\u044c\u0441\u044f \u043d\u0430 \u043b\u0435\u0442\u0443 \u043d\u0430 \u043e\u0441\u043d\u043e\u0432\u0435 \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u043e \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0451\u043d\u043d\u044b\u0445 \u043f\u0440\u0430\u0432\u0438\u043b \u0438 \u0441\u043f\u0438\u0441\u043a\u043e\u0432 \u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u0435\u043b\u0435\u0439, \u043e\u0442\u0432\u0435\u0442\u044b \u043d\u0430 \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e \u0430\u043d\u043e\u043d\u0438\u043c\u0438\u0437\u0438\u0440\u043e\u0432\u0430\u0442\u044c. \u041a\u043e\u0434 \u0440\u0430\u0441\u043f\u0440\u043e\u0441\u0442\u0440\u0430\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u043e\u0434 \u043b\u0438\u0446\u0435\u043d\u0437\u0438\u0435\u0439 PostgreSQL. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043f\u0440\u0438 \u043f\u043e\u043c\u043e\u0449\u0438 \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u0435\u043c\u043e\u0433\u043e \u0434\u043e\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u043c\u043e\u0436\u043d\u043e \u043f\u0440\u0435\u0434\u043e\u0441\u0442\u0430\u0432\u0438\u0442\u044c \u0434\u043e\u0441\u0442\u0443\u043f […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":73532,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-73531","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-novosti-interneta"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47PostgreSQL Anonymizer 0.6, nj\u00eb zgjerim p\u00ebr anonimizimin e t\u00eb dh\u00ebnave n\u00eb DBMS | ProHoster","description":"Nj\u00eb num\u00ebr i ri i projektit PostgreSQL \u00ebsht\u00eb tani i disponuesh\u00ebm.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/postgresql-anonymizer-0-6-rasshirenie-dlya-anonimizaczii-dannyh-v-subd","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\udd47PostgreSQL Anonymizer 0.6, \u0440\u0430\u0441\u0448\u0438\u0440\u0435\u043d\u0438\u0435 \u0434\u043b\u044f \u0430\u043d\u043e\u043d\u0438\u043c\u0438\u0437\u0430\u0446\u0438\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 \u0421\u0423\u0411\u0414 | ProHoster","og:description":"\u0414\u043e\u0441\u0442\u0443\u043f\u0435\u043d \u043d\u043e\u0432\u044b\u0439 \u0432\u044b\u043f\u0443\u0441\u043a \u043f\u0440\u043e\u0435\u043a\u0442\u0430 PostgreSQL.","og:url":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/postgresql-anonymizer-0-6-rasshirenie-dlya-anonimizaczii-dannyh-v-subd","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-03-10T11:42:30+00:00","article:modified_time":"2020-03-10T11:42:30+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"73531","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 18:31:39","updated":"2022-10-02 04:20:11","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\/73531","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=73531"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/73531\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/73532"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=73531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=73531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=73531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}