ื“ืขืจ ืขืจืฉื˜ืขืจ ืกื˜ืึทื‘ื™ืœ ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ื’ืจืึทืคื™ืง-ืึธืจื™ืขื ื˜ื™ื“ DBMS ื ืขื‘ื•ืœืึท ื’ืจืึทืคื™ืง

ืคืืจื’ืขืงื•ืžืขืŸ ืžืขืœื“ื•ื ื’ ืคื•ืŸ ืึท ืขืคืขื ืขืŸ DBMS ื ืขื‘ื•ืœืึท ื’ืจืึทืคื™ืง 1.0.0, ื“ื™ื–ื™ื™ื ื“ ืฆื• ื™ืคื™ืฉืึทื ื˜ืœื™ ืงืจืึธื ื’ืจื•ื™ืก ืฉื˜ืขืœื˜ ืคื•ืŸ ื™ื ื˜ืขืจืงืึทื ืขืงื˜ื™ื“ ื“ืึทื˜ืŸ ื•ื•ืึธืก ืคืึธืจืขื ืึท ื’ืจืึทืคื™ืง ื•ื•ืึธืก ืงืขื ืขืŸ ืึทื ื˜ื”ืึทืœื˜ืŸ ื‘ื™ืœื™ืึทื ื– ืคื•ืŸ ื ืึธื•ื“ื– ืื•ืŸ ื˜ืจื™ืœื™ืึทื ื– ืคื•ืŸ ืงืึทื ืขืงืฉืึทื ื–. ื“ื™ ืคึผืจื•ื™ืขืงื˜ ืื™ื– ื’ืขืฉืจื™ื‘ืŸ ืื™ืŸ C ++ ืื•ืŸ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ื“ื•ืจืš ืœื™ื™ืกืึทื ืกื˜ ืื•ื ื˜ืขืจ ืึทืคึผืึทื˜ืฉื™ 2.0. ืงืœื™ืขื ื˜ ืœื™ื™ื‘ืจืขืจื™ื– ืคึฟืึทืจ ืึทืงืกืขืก ื“ื™ DBMS ื–ืขื ืขืŸ ืฆื•ื’ืขื’ืจื™ื™ื˜ ืคึฟืึทืจ ื“ื™ Go, Python ืื•ืŸ Java ืฉืคึผืจืึทื›ืŸ. DBMS ืึทื ื˜ื•ื•ื™ืงืœื•ื ื’ ืกื˜ืึทืจื˜ืึทืคึผ VESoft ืขื˜ืœืขื›ืข ื˜ืขื’ ืฆื•ืจื™ืง ื’ืึทื˜ ื“ืขืจ ืขืจืฉื˜ืขืจ ื˜ืจืึทื ื˜ืฉ ืคื•ืŸ ื™ื ื•ื•ืขืกื˜ืžืึทื ืฅ ืื™ืŸ ื“ื™ ืกื•ืžืข ืคื•ืŸ โ€‹โ€‹$ 8 ืžื™ืœื™ืึธืŸ.

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

ื“ืขืจ ืขืจืฉื˜ืขืจ ืกื˜ืึทื‘ื™ืœ ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ื’ืจืึทืคื™ืง-ืึธืจื™ืขื ื˜ื™ื“ DBMS ื ืขื‘ื•ืœืึท ื’ืจืึทืคื™ืง

ื”ื•ื™ืคึผื˜ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ืคื•ืŸ ื ืขื‘ื•ืœืึท ื’ืจืึทืคื™ืง:

  • ื–ื™ื›ืขืจื”ื™ื™ื˜ security ื“ื•ืจืš ืฆื•ืฉื˜ืขืœืŸ ืึทืงืกืขืก ื‘ืœื•ื™ื– ืฆื• ืึธื˜ืขื ื˜ืึทืงื™ื™ื˜ืึทื“ ื ื™ืฆืขืจืก ื•ื•ืขืžืขื ืก ืคึผืขืจืžื™ืฉืึทื ื– ื–ืขื ืขืŸ ื‘ืึทืฉื˜ื™ืžื˜ ื“ื•ืจืš ืึท ืจืึธืœืข-ื‘ืื–ื™ืจื˜ ืึทืงืกืขืก ืงืึธื ื˜ืจืึธืœ (RBAC) ืกื™ืกื˜ืขื.
  • ื’ืขืœืขื’ื ื”ื™ื™ื˜ ืงืึทื ืขืงื˜ื™ื ื’ ืคืึทืจืฉื™ื“ืขื ืข ื˜ื™ื™ืคึผืก ืคื•ืŸ ืกื˜ืึธืจื™ื“ื–ืฉ ืขื ื“ื–ืฉืึทื ื–. ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ื™ืงืกืคึผืึทื ื“ื™ื ื’ ื“ื™ ืึธื ืคึฟืจืขื’ ื“ื•ืจ ืฉืคึผืจืึทืš ืžื™ื˜ ื ื™ื™ึทืข ืึทืœื’ืขืจื™ื“ืึทืžื–.
  • ื™ื ืฉื•ืจื™ื ื’ ืžื™ื ื™ืžืึทืœ ืœื™ื™ื˜ืึทื ืกื™ ื•ื•ืขืŸ ืœื™ื™ืขื ืขืŸ ืึธื“ืขืจ ืฉืจื™ื™ื‘ืŸ ื“ืึทื˜ืŸ ืื•ืŸ ื”ืึทืœื˜ืŸ ื”ื•ื™ืš ื˜ืจื•ืคึผื•ื˜. ืื™ืŸ ื˜ืขืกื˜ื™ื ื’ ืื™ืŸ ืึท ืงื ื•ื™ืœ ืคื•ืŸ ืื™ื™ืŸ ื’ืจืึทืคื“ ื ืึธื“ืข ืื•ืŸ ื“ืจื™ื™ ืกื˜ืึธืจื™ื“ื–ืฉ ื“ืึทื˜ืึทื‘ื™ื™ืก ื ืึธื•ื“ื– ืคื•ืŸ 632 ื’ื™ื’ืื‘ื™ื™ื˜ ืื™ืŸ ื’ืจื™ื™ืก, ืึทืจื™ื™ึทื ื’ืขืจืขื›ื ื˜ ืึท ื’ืึทืจืฃ ืคื•ืŸ 1.2 ื‘ื™ืœื™ืึธืŸ ื•ื•ืขืจื˜ื™ืกืขืก ืื•ืŸ 8.4 ื‘ื™ืœื™ืึธืŸ ืขื“ื–ืฉืึทื–, ืœื™ื™ื˜ืึทื ืกื™ ื–ืขื ืขืŸ ื’ืขื•ื•ืขืŸ ืขื˜ืœืขื›ืข ืžื™ืœื™ืกืขืงืึทื ื“ื–, ืื•ืŸ ื“ื™ ื˜ืจื•ืคึผื•ื˜ ืื™ื– ืึทืจื•ื™ืฃ ืฆื• 140 ื˜ื•ื™ื–ื ื˜ ืจื™ืงื•ื•ืขืก ืคึผืขืจ ืกืขืงื•ื ื“ืข .

    ื“ืขืจ ืขืจืฉื˜ืขืจ ืกื˜ืึทื‘ื™ืœ ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ื’ืจืึทืคื™ืง-ืึธืจื™ืขื ื˜ื™ื“ DBMS ื ืขื‘ื•ืœืึท ื’ืจืึทืคื™ืง

  • ืœื™ื ืขืึทืจ ืกืงืึทืœืึทื‘ื™ืœื™ื˜ื™.
  • ืึท SQL-ื•ื•ื™ ืึธื ืคึฟืจืขื’ ืฉืคึผืจืึทืš ื•ื•ืึธืก ืื™ื– ืฉื˜ืึทืจืง ืื•ืŸ ื’ืจื™ื ื’ ืฆื• ืคึฟืึทืจืฉื˜ื™ื™ืŸ. ืฉื˜ื™ืฆื˜ ืึทืคึผืขืจื™ื™ืฉืึทื ื– ืึทืจื™ื™ึทื ื ืขืžืขืŸ GO (ื‘ื™ื™ื“ื™ืจืขืงื˜ื™ืึธื ืึทืœ ื˜ืจืึทื•ื•ืขืจืกืึทืœ ืคื•ืŸ ื’ืจืึทืคื™ืง ื•ื•ืขืจื˜ื™ืกืขืก), GROUP BY, ORDER BY, LIMIT, UNION, UNION DISTINCT, INTERSECT, MINUS, PIPE (ื ื™ืฆืŸ ื“ื™ ืจืขื–ื•ืœื˜ืึทื˜ ืคื•ืŸ ืึท ืคืจื™ืขืจื“ื™ืงืŸ ืึธื ืคึฟืจืขื’). ื™ื ื“ืขืงืกื™ื– ืื•ืŸ ื‘ืึทื ื™ืฆืขืจ-ื“ื™ืคื™ื™ื ื“ ื•ื•ืขืจื™ืึทื‘ืึทืœื– ื–ืขื ืขืŸ ื’ืขืฉื˜ื™ืฆื˜.
  • ื™ื ืฉื•ืจื™ื ื’ ื”ื•ื™ืš ืึทื•ื•ื™ื™ืœืึทื‘ื™ืœืึทื˜ื™ ืื•ืŸ ืจื™ื–ื™ืœื™ืึทื ืก ืฆื• ืคื™ื™ืœื™ืขืจื–.
  • ืฉื˜ื™ืฆืŸ ืคึฟืึทืจ ืฉืืคืŸ ืกื ืึทืคึผืฉืึทืฅ ืžื™ื˜ ืึท ืจืขืคื˜ืœ ืคื•ืŸ ื“ื™ ื“ืึทื˜ืึทื‘ื™ื™ืก ืฉื˜ืึทื˜ ืฆื• ืคืึทืจืคึผืึธืฉืขื˜ืขืจืŸ ื“ื™ ืฉืึทืคื•ื ื’ ืคื•ืŸ ื‘ืึทืงืึทืคึผ ืงืืคื™ืขืก.
  • ื’ืจื™ื™ื˜ ืคึฟืึทืจ ืื™ื ื“ื•ืกื˜ืจื™ืขืœืข ื ื•ืฆืŸ (ืฉื•ื™ืŸ ื’ืขื ื™ืฆื˜ ืื™ืŸ ื“ื™ ื™ื ืคืจืึทืกื˜ืจืึทืงื˜ืฉืขืจ ืคื•ืŸ JD, Meituan ืื•ืŸ Xiaohongshu).
  • ื“ื™ ืคื™ื™ื™ืงื™ื™ื˜ ืฆื• ื˜ื•ื™ืฉืŸ ื“ื™ ื“ืึทื˜ืŸ ืกื˜ืึธืจื™ื“ื–ืฉ ืกื›ืขืžืข ืื•ืŸ ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ืขืก ืึธืŸ ืกื˜ืึธืคึผืคึผื™ื ื’ ืึธื“ืขืจ ืึทืคืขืงื˜ื™ื ื’ ืึธื ื’ืึธื™ื ื’ ืึทืคึผืขืจื™ื™ืฉืึทื ื–.
  • TTL ืฉื˜ื™ืฆืŸ ืฆื• ื‘ืึทื’ืจืขื ืขืฆืŸ ื“ื™ ืœืขื‘ืŸ ืคื•ืŸ ื“ืึทื˜ืŸ.
  • ืงืึทืžืึทื ื“ื– ืคึฟืึทืจ ืึธื ืคื™ืจื•ื ื’ ืกืขื˜ื˜ื™ื ื’ืก ืื•ืŸ ืกื˜ืึธืจื™ื“ื–ืฉ ืžื—ื ื•ืช.
  • ืžื›ืฉื™ืจื™ื ืคึฟืึทืจ ืึธื ืคื™ืจื•ื ื’ ืึทืจื‘ืขื˜ ืื•ืŸ ืกืงืขื“ื–ืฉื•ืœื™ื ื’ ืึทืจื‘ืขื˜ ืœืึธื ื˜ืฉื™ื– (ืคื•ืŸ ื“ื™ ืึทืจื‘ืขื˜ ืื™ืฆื˜ ื’ืขืฉื˜ื™ืฆื˜ ื–ืขื ืขืŸ COMPACT ืื•ืŸ FLUSH).
  • ืึธืคึผืขืจืึทื˜ื™ืึธื ืก ืคื•ืŸ ื“ืขืจื’ื™ื™ื•ื ื’ ื“ื™ ื’ืึทื ืฅ ื“ืจืš ืื•ืŸ ื“ื™ ืฉืึธืจื˜ื™ืกื˜ ื•ื•ืขื’ ืฆื•ื•ื™ืฉืŸ ื’ืขื’ืขื‘ืŸ ื•ื•ืขืจื˜ื™ืงืก.
  • OLAP ืฆื•ื‘ื™ื ื“ ืคึฟืึทืจ ื™ื ืึทื’ืจื™ื™ืฉืึทืŸ ืžื™ื˜ ื“ืจื™ื˜-ืคึผืึทืจื˜ื™ื™ ืึทื ืึทืœื™ื˜ื™ืงืก ืคึผืœืึทื˜ืคืึธืจืžืก.
  • ื™ื•ื˜ื™ืœืึทื˜ื™ื– ืคึฟืึทืจ ื™ืžืคึผืึธืจื˜ื™ื ื’ ื“ืึทื˜ืŸ ืคึฟื•ืŸ CSV ื˜ืขืงืขืก ืึธื“ืขืจ ืคึฟื•ืŸ Spark.
  • ืขืงืกืคึผืึธืจื˜ ืžืขื˜ืจื™ืงืก ืคึฟืึทืจ ืžืึธื ื™ื˜ืึธืจื™ื ื’ ื ื™ืฆืŸ ืคึผืจืึธืžืขื˜ื”ืขื•ืก ืื•ืŸ ื’ืจืึทืคืึทื ืึท.
  • ื•ื•ืขื‘ ืฆื•ื‘ื™ื ื“
    ื ืขื‘ื•ืœืึท ื’ืจืึทืคื™ืง ืกื˜ื•ื“ื™ืึธ ืคึฟืึทืจ ื•ื•ื™ื–ืฉื•ื•ืึทืœื™ื™ื–ื™ื ื’ ื’ืจืึทืคื™ืง ืึทืคึผืขืจื™ื™ืฉืึทื ื–, ื’ืจืึทืคื™ืง ื ืึทื•ื•ื™ื’ืึทืฆื™ืข, ื“ื™ื–ื™ื™ื ื™ื ื’ ื“ืึทื˜ืŸ ืกื˜ืึธืจื™ื“ื–ืฉ ืื•ืŸ ืœืึธื•ื“ื™ื ื’ ืกืงื™ืžื–.
    ื“ืขืจ ืขืจืฉื˜ืขืจ ืกื˜ืึทื‘ื™ืœ ืžืขืœื“ื•ื ื’ ืคื•ืŸ ื“ื™ ื’ืจืึทืคื™ืง-ืึธืจื™ืขื ื˜ื™ื“ DBMS ื ืขื‘ื•ืœืึท ื’ืจืึทืคื™ืง

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

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