hoʻokuʻu hou o ka papahana , e hāʻawi i kahi mea hoʻohui i ka PostgreSQL DBMS e hoʻonā i ka pilikia o ka hūnā a pani ʻana i ka ʻikepili huna a i ʻole kālepa. Hiki ke hūnā ʻia ka ʻikepili ma ka lele e pili ana i nā lula i wehewehe ʻia a me nā papa inoa o nā mea hoʻohana pono ʻole nā pane i nā noi. Code laikini ma lalo o PostgreSQL.
No ka laʻana, me ke kōkua o ka mea hoʻohui i nīnau ʻia, hiki iā ʻoe ke hāʻawi i ke komo i ka waihona i nā ʻaoʻao ʻekolu, no ka laʻana, nā lawelawe naʻauao ʻoihana ʻekolu, ʻoki ʻoki i nā ʻikepili no lākou e like me nā helu kelepona a me nā kāleka hōʻaiʻē, a i ʻole. me ka hoʻohana ʻana i nā ʻano hana maʻalahi, e like me ka hoʻololi ʻana i nā inoa mea kūʻai aku a me nā ʻoihana me ka ʻike hoʻopunipuni. Ma waho aʻe o ka hana ʻana i ka inoa ʻole i ka wā e hoʻopili pololei ai i ka DBMS, aia kahi ʻano hana no ka hana ʻana i nā dumps SQL anonymized (ua manaʻo ʻia ka pono pg_dump_anon).
Anonymizer PostgreSQL PostgreSQL DDL (Data Definition Language) a hiki iā ʻoe ke hoʻonohonoho i kahi hoʻolālā inoa ʻole ma ka pae schema e wehewehe i ke ʻano papa. Hāʻawi ʻia kahi hoʻonohonoho nui o nā hana no ka hoʻoili ʻana i ka ʻikepili e hoʻololi ʻia: randomization, hoʻololi me nā waiwai dummy, hapa. , shuffling, walaʻau, etc. Hoʻohui ka mana hou i nā hana no ka ʻike ʻana i nā mea ʻike, a loaʻa pū kekahi mode pseudonymization e hiki ai iā ʻoe ke hana i nā waiwai fictitious maoli i pili i ka ʻikepili kumu.
Eia hou, hiki iā mākou ke hoʻomaopopo i ke kahua hāmama i hoʻomohala ʻia e Microsoft no ka ʻike ʻana i nā leaks o ka ʻike huna . Hāʻawi ka paepae iā ʻoe e ʻike a holoi paha i ka ʻike i loko o nā palapala, kikokikona a me nā kiʻi i loaʻa ka ʻikepili pilikino a pilikino, e like me ka inoa piha, nā helu kelepona, ka leka uila, nā helu kāleka hōʻaiʻē, nā wallets crypto, nā helu wahi, nā helu passport, nā ʻikepili kālā, etc. Kākoʻo i ka hana ʻana o nā waihona like ʻole (mai Amazon S3 a i PostgreSQL) a me nā ʻano. Ua kākau ʻia ke code ma Go (aia kahi mana ma Python) a ma lalo o ka laikini MIT.
Source: opennet.ru