{"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\/da\/blog\/news\/postgresql-anonymizer-0-6-rasshirenie-dlya-anonimizaczii-dannyh-v-subd","title":{"rendered":"PostgreSQL Anonymizer 0.6, et udvidelse til anonymisering af data i databaser","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Tilg\u00e6ngelig<\/a><\/noindex> ny udgave af projektet PostgreSQL Anonymizer<\/a><\/noindex>, som tilbyder et supplement til PostgreSQL-databasen, der l\u00f8ser opgaven med at skjule eller erstatte fortrolige data eller oplysninger, der udg\u00f8r handelshemmeligheder. Data kan anonymiseres i realtid baseret p\u00e5 specielt definerede regler og brugerlister, hvis anmodninger skal anonymiseres. Koden distribueres<\/a><\/noindex> under PostgreSQL-licensen.<\/p>\n

For eksempel, med det p\u00e5g\u00e6ldende supplement kan der gives adgang til databasen for tredjeparter, s\u00e5som eksterne forretningsanalyse-tjenester, der automatisk fjerner oplysninger s\u00e5som telefonnumre og kreditkortnumre, eller anvender mere avancerede metoder som at erstatte navne p\u00e5 kunder og virksomheder med fiktive oplysninger. Udover anonymiseringen ved direkte tilslutning til databasen, er der en mulighed for at oprette anonymiserede SQL-dumps (der er foresl\u00e5et et v\u00e6rkt\u00f8j kaldet pg_dump_anon). <\/p>\n

PostgreSQL Anonymizer udvider<\/a><\/noindex> PostgreSQL DDL (Data Definition Language) og muligg\u00f8r at angive en anonymiseringsstrategi p\u00e5 skemaniveau, der definerer tabelstrukturen. Der tilbydes et stort s\u00e6t funktioner til behandling af data, der skal erstattes: tilf\u00e6ldig udv\u00e6lgelse, erstatning med fiktive v\u00e6rdier, delvis skr\u00e6mblisering<\/a><\/noindex>, blanding, st\u00f8jtilf\u00f8jelse osv. I den nye version er der tilf\u00f8jet funktioner til at identificere identifikatorer, samt en tilstand for pseudonymisering, der muligg\u00f8r generering af realistiske fiktive v\u00e6rdier, der kan knyttes til de oprindelige data.<\/p>\n

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

Derudover skal man n\u00e6vne den \u00e5bne platform udviklet af Microsoft til at opdage l\u00e6kager af fortrolige oplysninger Presidio<\/a><\/noindex>. Platformen kan identificere eller fjerne personlige og fortrolige data, s\u00e5som navne, telefonnumre, e-mail, kreditkortnumre, kryptovaluta-tegneb\u00f8ger, adresser, pasnumre, finansielle data osv., i dokumenter, tekst og billeder. Der underst\u00f8ttes behandling af forskellige lagringssystemer (fra Amazon S3 til PostgreSQL) og formater. Koden er skrevet i Go (der er en version i Python) og distribueres<\/a><\/noindex> under MIT-licensen. <\/p>\n

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

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

Kilde: 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\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, en udvidelse til dat anonymisering i databaser | ProHoster","description":"En ny version af PostgreSQL-projektet er tilg\u00e6ngelig.","canonical_url":"https:\/\/prohoster.info\/da\/blog\/news\/postgresql-anonymizer-0-6-rasshirenie-dlya-anonimizaczii-dannyh-v-subd","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"da_DK","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\/da\/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\/da\/wp-json\/wp\/v2\/posts\/73531","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/comments?post=73531"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/posts\/73531\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media\/73532"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/media?parent=73531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/categories?post=73531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/da\/wp-json\/wp\/v2\/tags?post=73531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}