{"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\/news\/postgresql-anonymizer-0-6-rasshirenie-dlya-anonimizaczii-dannyh-v-subd","title":{"rendered":"PostgreSQL Anonymizer 0.6, nj\u00eb shtes\u00eb p\u00ebr anonimizimin e t\u00eb dh\u00ebnave n\u00eb DBMS","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

I disponuesh\u00ebm<\/a><\/noindex> n\u00eb klas\u00ebn e re t\u00eb projektit PostgreSQL Anonymizer<\/a><\/noindex>, q\u00eb ofron nj\u00eb shtes\u00eb p\u00ebr SGBD PostgreSQL, q\u00eb zgjidh problemin e fshehjes ose z\u00ebvend\u00ebsimit t\u00eb t\u00eb dh\u00ebnave konfidenciale ose informacionit q\u00eb p\u00ebrb\u00ebn sekret tregtar. T\u00eb dh\u00ebnat mund t\u00eb fshihen n\u00eb koh\u00eb reale mbi baz\u00ebn e rregullave dhe listave t\u00eb p\u00ebrdoruesve t\u00eb p\u00ebrcaktuara posa\u00e7\u00ebrisht, p\u00ebrgjigjet ndaj k\u00ebrkesave t\u00eb t\u00eb cil\u00ebve duhet t\u00eb anonimizohen. Kodi shp\u00ebrndahet<\/a><\/noindex> n\u00ebn licenc\u00ebn PostgreSQL.<\/p>\n

P\u00ebr shembull, me an\u00eb t\u00eb k\u00ebsaj shtese mund t\u00eb ofrohet qasje n\u00eb DB p\u00ebr subjekte t\u00eb treta, si sh\u00ebrbime t\u00eb pal\u00ebve t\u00eb treta p\u00ebr analiza biznesi, duke hequr automatikisht p\u00ebr ta t\u00eb dh\u00ebna si numrat e telefonit dhe kartat e kreditit, ose duke aplikuar metoda m\u00eb t\u00eb avancuara, si z\u00ebvend\u00ebsimi i emrave t\u00eb klient\u00ebve dhe kompanive me informacion t\u00eb rrem\u00eb. P\u00ebrve\u00e7 anonimizimit gjat\u00eb lidhjes direkte me SGBD, parashikohet nj\u00eb modalitet p\u00ebr krijimin e dump-eve SQL t\u00eb anonimizuara (propozohet utilita pg_dump_anon). <\/p>\n

PostgreSQL Anonymizer zgjatim<\/a><\/noindex> PostgreSQL DDL (Gjuha e Definicionit t\u00eb T\u00eb Dh\u00ebnave) dhe lejon p\u00ebrcaktimin e strategjis\u00eb s\u00eb anonimizimit n\u00eb nivel skeme, e cila p\u00ebrcakton struktur\u00ebn e tabel\u00ebs. Ofrohet nj\u00eb gam\u00eb e gjer\u00eb funksionesh p\u00ebr p\u00ebrpunimin e t\u00eb dh\u00ebnave q\u00eb duhen z\u00ebvend\u00ebsuar: rast\u00ebsishm\u00ebria, z\u00ebvend\u00ebsimi me vlera t\u00eb rreme, pjes\u00ebrisht shkrembimi<\/a><\/noindex>, p\u00ebrzierja, zhurma etj. N\u00eb versionin e ri jan\u00eb shtuar funksione p\u00ebr identifikimin e identifikuesve, si dhe \u00ebsht\u00eb introduktuar nj\u00eb modalitet psevdonimizimi q\u00eb lejon gjenerimin e vlerave t\u00eb rreme t\u00eb realizuara q\u00eb lidhen me t\u00eb dh\u00ebnat origjinale.<\/p>\n

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

P\u00ebrve\u00e7 k\u00ebsaj, mund t\u00eb theksohet platforma e hapur e zhvilluar nga Microsoft p\u00ebr identifikimin e rrjedhjeve t\u00eb informacionit konfidencial Presidio<\/a><\/noindex>. Kjo platform\u00eb lejon identifikimin ose eliminimin n\u00eb dokumente, tekste dhe imazhe t\u00eb informacionit q\u00eb p\u00ebrmban t\u00eb dh\u00ebna personale dhe konfidenciale, si emra t\u00eb plot\u00eb, numra telefonik\u00eb, email, numra kartash krediti, portofol\u00eb kripto, adresa, numra pasaportash, t\u00eb dh\u00ebna financiare etj. Mb\u00ebshtetet p\u00ebrpunimi i ndrysh\u00ebm i arkivave (nga Amazon S3 deri n\u00eb PostgreSQL) dhe formateve. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn Go (ka nj\u00eb variant n\u00eb Python) dhe shp\u00ebrndahet<\/a><\/noindex> n\u00ebn 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-news"],"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, zgjerim p\u00ebr anonimizimin e t\u00eb dh\u00ebnave n\u00eb DBMS | ProHoster","description":"\u00cbsht\u00eb n\u00eb dispozicion nj\u00eb version i ri i projektit PostgreSQL.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/news\/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\/news\/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}]}}