PostgreSQL Anonymizer 0.6, ืึท ืคืึทืจืœืขื ื’ืขืจื•ื ื’ ืคึฟืึทืจ ืึทื ืึธื ื™ืžื™ื–ื™ื ื’ ื“ืึทื˜ืŸ ืื™ืŸ ืึท DBMS

ื‘ื ื™ืžืฆื ื ื™ื™ึท ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ืคึผืจื•ื™ืขืงื˜ PostgreSQL ืึทื ืึธื ื™ืžื™ื–ืขืจ, ื•ื•ืึธืก ื’ื™ื˜ ืึทืŸ ืึทื“ื™ืฉืึทืŸ ืฆื• ื“ื™ PostgreSQL DBMS ื•ื•ืึธืก ืกืึทืœื•ื•ื– ื“ื™ ืคึผืจืึธื‘ืœืขื ืคื•ืŸ ื›ื™ื™ื“ื™ื ื’ ืึธื“ืขืจ ืจื™ืคึผืœื™ื™ืกื™ื ื’ ืงืึทื ืคืึทื“ืขื ืฉืึทืœ ืึธื“ืขืจ ื”ืึทื ื“ืœ ืกื•ื“ ื“ืึทื˜ืŸ. ื“ืึทื˜ืŸ ืงืขื ืขืŸ ื–ื™ื™ืŸ ืคืึทืจื‘ืึธืจื’ืŸ ืื•ื™ืฃ ื“ื™ ืคืœื™ืขืŸ ื‘ืื–ื™ืจื˜ ืื•ื™ืฃ ืกืคึผืขืฆื™ืขืœ ื“ื™ืคื™ื™ื ื“ ื›ึผืœืœื™ื ืื•ืŸ ืจืฉื™ืžื•ืช ืคื•ืŸ ื ื™ืฆืขืจืก ื•ื•ืขืžืขื ืก ืจืขืกืคึผืึธื ืกืขืก ืฆื• ืจื™ืงื•ื•ืขืก ืžื•ื–ืŸ ื–ื™ื™ืŸ ืึทื ืึธื ื™ืžื™ื™ื–ื“. ืงืึธื“ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ื“ื•ืจืš ืœื™ื™ืกืึทื ืกื˜ ืื•ื ื˜ืขืจ PostgreSQL.

ืฆื•ื ื‘ื™ื™ืฉืคึผื™ืœ, ืžื™ื˜ ื“ื™ ื”ื™ืœืฃ ืคื•ืŸ ื“ืขื ืึทื“ื™ืฉืึทืŸ ืื™ืŸ ืงืฉื™ื, ืื™ืจ ืงืขื ืขืŸ ืฆื•ืฉื˜ืขืœืŸ ืึทืงืกืขืก ืฆื• ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืฆื• ื“ืจื™ื˜ ืคึผืึทืจื˜ื™ืขืก, ืœืžืฉืœ, ื“ืจื™ื˜-ืคึผืึทืจื˜ื™ื™ ื’ืขืฉืขืคื˜ ืกื™ื™ื›ืœ ื‘ืึทื“ื™ื ื•ื ื’ืก, ืื•ื™ื˜ืึธืžืึทื˜ื™ืฉ ืฉื ื™ื™ึทื“ืŸ ื“ืึทื˜ืŸ ืคึฟืึทืจ ื–ื™ื™, ืึทื–ืึท ื•ื•ื™ ื˜ืขืœืขืคืึธืŸ ื ื•ืžืขืจืŸ ืื•ืŸ ืงืจืขื“ื™ื˜ ืงืึทืจื“ืก, ืึธื“ืขืจ ื ื™ืฆืŸ ืžืขืจ ืกืึทืคื™ืกื˜ืึทืงื™ื™ื˜ื™ื“ ืžืขื˜ื”ืึธื“ืก, ืึทื–ืึท ื•ื•ื™ ืจื™ืคึผืœื™ื™ืกื™ื ื’ ืงื•ื ื” ืื•ืŸ ืคื™ืจืžืข ื ืขืžืขืŸ ืžื™ื˜ ืคื™ืงื˜ื™ืฉืึทืก ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข. ืื™ืŸ ืึทื“ื™ืฉืึทืŸ ืฆื• ื“ื•ืจื›ืคื™ืจืŸ ืึทื ืึธื ื™ืžื™ื–ืึทื˜ื™ืึธืŸ ื•ื•ืขืŸ ืงืึทื ืขืงื˜ื™ื ื’ ื’ืœื™ื™ึทืš ืฆื• ื“ื™ DBMS, ืขืก ืื™ื– ืึท ืžืึธื“ืข ืคึฟืึทืจ ืงืจื™ื™ื™ื˜ื™ื ื’ ืึทื ืึธื ื™ืžื™ื™ื–ื“ SQL ื“ืึทืžืคึผืก (ื“ื™ pg_dump_anon ื ื•ืฆืŸ ืื™ื– ืคืืจื’ืขืœื™ื™ื’ื˜).

PostgreSQL ืึทื ืึธื ื™ืžื™ื–ืขืจ ื™ืงืกืคึผืึทื ื“ื– PostgreSQL DDL (Data Definition Language) ืื•ืŸ ืึทืœืึทื•ื– ืื™ืจ ืฆื• ืฉื˜ืขืœืŸ ืึทืŸ ืึทื ืึธื ื™ืžื™ื–ืึทื˜ื™ืึธืŸ ืกื˜ืจืึทื˜ืขื’ื™ืข ืื•ื™ืฃ ื“ื™ ืกื˜ืฉืขืžืึท ืžื“ืจื’ื” ื•ื•ืึธืก ื“ื™ืคื™ื™ื ื– ื“ื™ ื˜ื™ืฉ ืกื˜ืจื•ืงื˜ื•ืจ. ื ื’ืจื•ื™ืก ื’ืึทื ื’ ืคื•ืŸ ืคืึทื ื’ืงืฉืึทื ื– ืื™ื– ืฆื•ื’ืขืฉื˜ืขืœื˜ ืคึฟืึทืจ ืคึผืจืึทืกืขืกื™ื ื’ ื“ืึทื˜ืŸ ืฆื• ื–ื™ื™ืŸ ืจื™ืคึผืœื™ื™ืกื˜: ืจืึทื ื“ืึทืžื™ื–ื™ื™ืฉืึทืŸ, ืคืึทืจื‘ื™ื™ึทื˜ ืžื™ื˜ ื“ืึทืžื™ ื•ื•ืึทืœื•ืขืก, ืคึผืึทืจื˜ื™ื™ื™ืฉ ืกืงืจืึทืžื‘ืึทืœื™ื ื’, ืฉืึทืคื•ื ื’, ืจืึทืฉ, ืืื–"ื• ื•. ื“ื™ ื ื™ื™ึทืข ื•ื•ืขืจืกื™ืข ืžื•ืกื™ืฃ ืคืึทื ื’ืงืฉืึทื ื– ืฆื• ื™ื“ืขื ื˜ื™ืคื™ืฆื™ืจืŸ ื™ื“ืขื ื˜ื™ืคื™ืขืจืก, ืื•ืŸ ืื•ื™ืš ื”ืื˜ ืึท ืคึผืกืขื•ื•ื“ืึธื ื™ืžื™ื–ืึทื˜ื™ืึธืŸ ืžืึธื“ืข ื•ื•ืึธืก ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื“ื–ืฉืขื ืขืจื™ื™ื˜ ืจืขืึทืœื™ืกื˜ื™ืฉ ืคื™ืงื˜ื™ืฉืึทืก ื•ื•ืึทืœื•ืขืก ืžื™ื˜ ื“ื™ ืžืงื•ืจ ื“ืึทื˜ืŸ.

PostgreSQL Anonymizer 0.6, ืึท ืคืึทืจืœืขื ื’ืขืจื•ื ื’ ืคึฟืึทืจ ืึทื ืึธื ื™ืžื™ื–ื™ื ื’ ื“ืึทื˜ืŸ ืื™ืŸ ืึท DBMS

ื“ืขืจืฆื•, ืžื™ืจ ืงืขื ืขืŸ ื˜ืึธืŸ ื“ื™ ืึธืคึฟืŸ ืคึผืœืึทื˜ืคืึธืจืžืข ื“ืขื•ื•ืขืœืึธืคึผืขื“ ื“ื•ืจืš ืžื™ื™ืงืจืึธืกืึธืคึฟื˜ ืคึฟืึทืจ ื™ื“ืขื ื˜ื™ืคื™ื™ื ื’ ืœื™ืงืก ืคื•ืŸ ืงืึทื ืคืึทื“ืขื ืฉืึทืœ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ืคึผืจืขืกื™ื“ื™ืึธ. ื“ื™ ืคึผืœืึทื˜ืคืึธืจืžืข ืึทืœืึทื•ื– ืื™ืจ ืฆื• ื™ื“ืขื ื˜ื™ืคื™ืฆื™ืจืŸ ืึธื“ืขืจ ื•ื™ืกืžืขืงืŸ ืื™ื ืคึฟืึธืจืžืึทืฆื™ืข ืื™ืŸ ื“ืึธืงื•ืžืขื ื˜ืŸ, ื˜ืขืงืกื˜ ืื•ืŸ ื‘ื™ืœื“ืขืจ ืžื™ื˜ ืคืขืจื–ืขื ืœืขื›ืข ืื•ืŸ ืงืึทื ืคืึทื“ืขื ืฉืึทืœ ื“ืึทื˜ืŸ, ืึทื–ืึท ื•ื•ื™ ืคื•ืœ ื ืึธืžืขืŸ, ื˜ืขืœืขืคืึธืŸ ื ื•ืžืขืจืŸ, E- ื‘ืจื™ื•ื•, ืงืจืขื“ื™ื˜ ืงืึทืจื˜ืœ ื ื•ืžืขืจืŸ, ืงืจื™ืคึผื˜ืึธ ื•ื•ืึธืœืึทืฅ, ืึทื“ืจืขืกืขืก, ืคึผืึทืก ื ื•ืžืขืจืŸ, ืคื™ื ืึทื ืฆื™ืขืœ ื“ืึทื˜ืŸ, ืืื–"ื• ื•. ืฉื˜ื™ืฆื˜ ืคึผืจืึทืกืขืกื™ื ื’ ืคื•ืŸ ืคืึทืจืฉื™ื“ืŸ ืกื˜ืึธืจื™ื“ื–ืฉ (ืคึฟื•ืŸ Amazon S3 ืฆื• PostgreSQL) ืื•ืŸ ืคึฟืึธืจืžืึทื˜ื™ืจื•ื ื’ืขืŸ. ื“ืขืจ ืงืึธื“ ืื™ื– ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ Go (ืขืก ืื™ื– ืึท ื•ื•ืขืจืกื™ืข ืื™ืŸ ืคึผื™ื˜ื”ืึธืŸ) ืื•ืŸ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ื“ื•ืจืš ืื•ื ื˜ืขืจ ื“ื™ MIT ื“ืขืจืœื•ื™ื‘ืขื ื™ืฉ.

PostgreSQL Anonymizer 0.6, ืึท ืคืึทืจืœืขื ื’ืขืจื•ื ื’ ืคึฟืึทืจ ืึทื ืึธื ื™ืžื™ื–ื™ื ื’ ื“ืึทื˜ืŸ ืื™ืŸ ืึท DBMS

ืžืงื•ืจ: opennet.ru

ืœื™ื™ื’ืŸ ืึท ื‘ืึทืžืขืจืงื•ื ื’