ืงืึทืกืึทื ื“ืจืึท. ื•ื•ื™ ื ื™ื˜ ืฆื• ืฉื˜ืึทืจื‘ืŸ ืื•ื™ื‘ ืื™ืจ ื ืึธืจ ื•ื•ื™ืกืŸ ืึธืจืึทืงืœืข

ื”ืขืœื, ื”ืื‘ืจ.

ืžื™ื™ืŸ ื ืึธืžืขืŸ ืื™ื– ืžื™ืฉืึท ื‘ื•ื˜ืจื™ืžืึธื•ื•, ืื™ืš ื•ื•ืึธืœื˜ ื•ื•ื™ ืฆื• ื“ืขืจืฆื™ื™ืœืŸ ืื™ืจ ืึท ื‘ื™ืกืœ ื•ื•ืขื’ืŸ ืงืึทืกืึทื ื“ืจืึท. ืžื™ื™ึทืŸ ื“ืขืจืฆื™ื™ืœื•ื ื’ ื•ื•ืขื˜ ื–ื™ื™ืŸ ื ื•ืฆื™ืง ืคึฟืึทืจ ื™ืขื ืข ื•ื•ืึธืก ื”ืึธื‘ืŸ ืงื™ื™ื ืžืึธืœ ื’ืขืคึผืœืึธื ื˜ืขืจื˜ NoSQL ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื– - ืขืก ื”ืื˜ ืึท ืคึผืœืึทืฅ ืคื•ืŸ ื™ืžืคึผืœืึทืžืขื ื˜ื™ื™ืฉืึทืŸ ืคึฟืขื™ึดืงื™ื™ื˜ืŸ ืื•ืŸ ืคึผื™ื˜ืคืึธืœื– ื•ื•ืึธืก ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ื•ื•ื™ืกืŸ ื•ื•ืขื’ืŸ. ืื•ืŸ ืื•ื™ื‘ ืื™ืจ ื”ืึธื˜ ื ื™ืฉื˜ ื’ืขื–ืขืŸ ืขืคึผืขืก ืึทื ื“ืขืจืฉ ื•ื•ื™ ืึธืจืึทืงืœืข ืึธื“ืขืจ ืงื™ื™ืŸ ืื ื“ืขืจืข ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืก, ื“ื™ ื˜ื™ื ื’ื– ื•ื•ืขื˜ ืจืึทื˜ืขื•ื•ืขืŸ ื“ื™ื™ืŸ ืœืขื‘ืŸ.

ื•ื•ืึธืก ืื™ื– ืึทื–ื•ื™ ื’ื•ื˜ ื•ื•ืขื’ืŸ ืงืึทืกืกืึทื ื“ืจืึท? ืขืก ืื™ื– ืึท NoSQL ื“ืึทื˜ืึทื‘ื™ื™ืก ื“ื™ื–ื™ื™ื ื“ ืึธืŸ ืึท ืื™ื™ืŸ ืคื•ื ื˜ ืคื•ืŸ ื“ื•ืจื›ืคืึทืœ ื•ื•ืึธืก ื•ื•ืึธื’ ื’ืขื–ื•ื ื˜. ืื•ื™ื‘ ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืœื™ื™ื’ืŸ ืึท ืคึผืึธืจ ืคื•ืŸ ื˜ืขืจืึทื‘ื™ื˜ืขืก ืคึฟืึทืจ ืขื˜ืœืขื›ืข ื“ืึทื˜ืึทื‘ื™ื™ืก, ืื™ืจ ืคืฉื•ื˜ ืœื™ื™ื’ืŸ ื ืึธื•ื“ื– ืฆื• ื“ื™ ืจื™ื ื’. ื™ืงืกืคึผืึทื ื“ ืขืก ืฆื• ืืŸ ืื ื“ืขืจ ื“ืึทื˜ืŸ ืฆืขื ื˜ืขืจ? ืœื™ื™ื’ ื ืึธื•ื“ื– ืฆื• ื“ืขื ืงื ื•ื™ืœ. ืคืึทืจื’ืจืขืกืขืจืŸ ืคึผืจืึทืกืขืกื˜ ืจืคึผืก? ืœื™ื™ื’ ื ืึธื•ื“ื– ืฆื• ื“ืขื ืงื ื•ื™ืœ. ืขืก ืึทืจื‘ืขื˜ ืื•ื™ืš ืื™ืŸ ื“ื™ ืคืึทืจืงืขืจื˜ ืจื™ื›ื˜ื•ื ื’.

ืงืึทืกืึทื ื“ืจืึท. ื•ื•ื™ ื ื™ื˜ ืฆื• ืฉื˜ืึทืจื‘ืŸ ืื•ื™ื‘ ืื™ืจ ื ืึธืจ ื•ื•ื™ืกืŸ ืึธืจืึทืงืœืข

ื•ื•ืึธืก ืึทื ื“ืขืจืฉ ืื™ื– ื–ื™ ื’ื•ื˜ ืื™ืŸ? ืขืก ืื™ื– ื•ื•ืขื’ืŸ ื”ืึทื ื“ืœื™ื ื’ ืึท ืคึผืœืึทืฅ ืคื•ืŸ ืจื™ืงื•ื•ืขืก. ืื‘ืขืจ ื•ื•ื™ ืคื™ืœ ืื™ื– ืึท ืคึผืœืึทืฅ? 10, 20, 30, 40 ื˜ื•ื™ื–ื ื˜ ืจื™ืงื•ื•ืขืก ืคึผืขืจ ืกืขืงื•ื ื“ืข ืื™ื– ื ื™ืฉื˜ ืคื™ืœ. 100 ื˜ื•ื™ื–ื ื˜ ืจื™ืงื•ื•ืขืก ืคึผืขืจ ืกืขืงื•ื ื“ืข ืคึฟืึทืจ ืจืขืงืึธืจื“ื™ื ื’ - ืื•ื™ืš. ืขืก ื–ืขื ืขืŸ ืงืึธืžืคึผืึทื ื™ืขืก ื•ื•ืึธืก ื”ืึธื‘ืŸ ื’ืขื–ืึธื’ื˜ ืึทื– ื–ื™ื™ ื”ืึทืœื˜ืŸ 2 ืžื™ืœื™ืึธืŸ ืจื™ืงื•ื•ืขืก ืคึผืขืจ ืกืขืงื•ื ื“ืข. ื–ื™ื™ ื•ื•ืขืœืŸ ืžื™ืกื˜ืึธืžืข ื”ืึธื‘ืŸ ืฆื• ื’ืœื•ื™ื‘ืŸ ืขืก.

ืื•ืŸ ืื™ืŸ ืคึผืจื™ื ืฆื™ืคึผ, ืงืึทืกืกืึทื ื“ืจืึท ื”ืื˜ ืื™ื™ืŸ ื’ืจื•ื™ืก ื—ื™ืœื•ืง ืคื•ืŸ ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืŸ - ืขืก ืื™ื– ื ื™ืฉื˜ ืขื ืœืขืš ืฆื• ื–ื™ื™. ืื•ืŸ ื“ืึธืก ืื™ื– ื–ื™ื™ืขืจ ื•ื•ื™ื›ื˜ื™ืง ืฆื• ื’ืขื“ืขื ืงืขืŸ.

ื ื™ื˜ ืึทืœืฅ ื•ื•ืึธืก ืงื•ืงื˜ ื“ื™ ื–ืขืœื‘ืข ืึทืจื‘ืขื˜ ื“ื™ ื–ืขืœื‘ืข

ืึทืžืึธืœ ืึท ืงืึธืœืขื’ืข ื’ืขืงื•ืžืขืŸ ืฆื• ืžื™ืจ ืื•ืŸ ื’ืขืคืจืขื’ื˜: "ื“ืึธ ืื™ื– ืึท CQL Cassandra ืึธื ืคึฟืจืขื’ ืฉืคึผืจืึทืš, ืื•ืŸ ืขืก ื”ืื˜ ืึท ืกืขืœืขืงื˜ืขื“ ื“ืขืจืงืœืขืจื•ื ื’, ืขืก ื”ืื˜ ื•ื•ื•, ืขืก ื”ืื˜ ืื•ืŸ. ืื™ืš ืฉืจื™ื™ื‘ ื‘ืจื™ื•ื• ืื•ืŸ ืขืก ื˜ื•ื˜ ื ื™ืฉื˜ ืึทืจื‘ืขื˜ืŸ. ืคืืจื•ื•ืืก?". ื˜ืจืขืึทื˜ื™ื ื’ ืงืึทืกืกืึทื ื“ืจืึท ื•ื•ื™ ืึท ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืก ืื™ื– ื“ื™ ืฉืœื™ื™ืžืขืกื“ื™ืง ื•ื•ืขื’ ืฆื• ื˜ื•ืขืŸ ื”ื™ืฆื™ืง ื–ืขืœื‘ืกื˜ืžืึธืจื“. ืื•ืŸ ืื™ืš ื‘ื™ืŸ ื ื™ืฉื˜ ืคึผืจืึทืžืึธื•ื˜ื™ื ื’ ืขืก, ืขืก ืื™ื– ืคึผืจืึธื•ื›ื™ื‘ืึทื˜ืึทื“ ืื™ืŸ ืจื•ืกืœืึทื ื“. ืื™ืจ ื•ื•ืขื˜ ื ืึธืจ ืคึผืœืึทืŸ ืขืคึผืขืก ืคืึทืœืฉ.

ืœืžืฉืœ, ืึท ืงื•ื ื” ืงื•ืžื˜ ืฆื• ืื•ื ื“ื– ืื•ืŸ ื–ืื’ื˜: "ืœืึธืžื™ืจ ื‘ื•ื™ืขืŸ ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก ืคึฟืึทืจ ื˜ืขืœืขื•ื•ื™ื–ื™ืข ืกืขืจื™ืข, ืึธื“ืขืจ ืึท ื“ืึทื˜ืึทื‘ื™ื™ืก ืคึฟืึทืจ ืึท ืจืขืฆืขืคึผื˜ ื•ื•ืขื’ื•ื•ื™ื™ึทื–ืขืจ. ืžื™ืจ ื•ื•ืขืœืŸ ื“ืึธืจื˜ ืขืกืŸ ืงื™ื™ืœื™ื ืึธื“ืขืจ ืึท ืจืฉื™ืžื” ืคื•ืŸ ื˜ืขืœืขื•ื•ื™ื–ื™ืข ืกืขืจื™ืข ืื•ืŸ ืึทืงื˜ืขืจื– ืื™ืŸ ืขืก. โ€ ืžื™ืจ ื–ืึธื’ืŸ ืคืจื™ื™ืœืขืš: "ืœืึธืžื™ืจ ื’ื™ื™ืŸ!" ื ืึธืจ ืฉื™ืงืŸ ืฆื•ื•ื™ื™ ื‘ื™ื˜ืขืก, ืึท ืคึผืึธืจ ืคื•ืŸ ื•ื•ืื•ื ื“ืขืจ ืื•ืŸ ืื™ืจ ื ื™ื˜ืึธ ื’ืขื˜ืืŸ, ืึทืœืฅ ื•ื•ืขื˜ ืึทืจื‘ืขื˜ืŸ ื–ื™ื™ืขืจ ื’ืขืฉื•ื•ื™ื ื“ ืื•ืŸ ืคืึทืจืœืึธื–ืœืขืš. ืื•ืŸ ืึทืœืฅ ืื™ื– ื’ื•ื˜, ื‘ื™ื– ื“ื™ ืงืึทืกื˜ืึทืžืขืจื– ืงื•ืžืขืŸ ืื•ืŸ ื–ืึธื’ืŸ ืึทื– ื“ื™ ื‘ืึทืœืขื‘ืึทื˜ื™ื ืœื™ื™ื–ืŸ ืื•ื™ืš ื“ื™ ืคืึทืจืงืขืจื˜ ืคึผืจืึธื‘ืœืขื: ื–ื™ื™ ื”ืึธื‘ืŸ ืึท ืจืฉื™ืžื” ืคื•ืŸ ืคึผืจืึธื“ื•ืงื˜ืŸ, ืื•ืŸ ื–ื™ื™ ื•ื•ื™ืœืŸ ืฆื• ื•ื•ื™ืกืŸ ื•ื•ืึธืก ืฉื™ืกืœ ื–ื™ื™ ื•ื•ื™ืœืŸ ืฆื• ืงืึธื›ืŸ. ื“ื• ื‘ื™ืกื˜ ื˜ื•ื™ื˜.

ื“ืึธืก ืื™ื– ื•ื•ื™ื™ึทืœ Cassandra ืื™ื– ืึท ื›ื™ื™ื‘ืจื™ื“ ื“ืึทื˜ืึทื‘ื™ื™ืก: ืขืก ืกื™ื™ืžืึทืœื˜ื™ื™ื ื™ืึทืกืœื™ ื’ื™ื˜ ืึท ืฉืœื™ืกืœ ื•ื•ืขืจื˜ ืื•ืŸ ืกื˜ืึธืจื– ื“ืึทื˜ืŸ ืื™ืŸ ื‘ืจื™ื™ื˜ ืฉืคืืœื˜ืŸ. ืื™ืŸ Java ืึธื“ืขืจ Kotlin, ืขืก ืงืขืŸ ื–ื™ื™ืŸ ื“ื™ืกืงืจื™ื™ื‘ื“ ื•ื•ื™ ื“ืึธืก:

Map<RowKey, SortedMap<ColumnKey, ColumnValue>>

ื“ืึธืก ืื™ื–, ืึท ืžืึทืคึผืข ื•ื•ืึธืก ืื•ื™ืš ื›ึผื•ืœืœ ืึท ืกืึธืจื˜ื™ืจื˜ ืžืึทืคึผืข. ื“ืขืจ ืขืจืฉื˜ืขืจ ืฉืœื™ืกืœ ืฆื• ื“ืขื ืžืึทืคึผืข ืื™ื– ื“ื™ ืจื•ื“ืขืจืŸ ืฉืœื™ืกืœ ืึธื“ืขืจ ืคึผืึทืจื˜ื™ื˜ื™ืึธืŸ ืฉืœื™ืกืœ - ื“ื™ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืฉืœื™ืกืœ. ื“ืขืจ ืฆื•ื•ื™ื™ื˜ืขืจ ืฉืœื™ืกืœ, ื•ื•ืึธืก ืื™ื– ื“ืขืจ ืฉืœื™ืกืœ ืฆื• ืึท ืฉื•ื™ืŸ ืื•ื™ืกื’ืขืฉื˜ืขืœื˜ ืžืึทืคึผืข, ืื™ื– ื“ื™ ืงืœืึทืกื˜ืขืจื™ื ื’ ืฉืœื™ืกืœ.

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

ืงืึทืกืึทื ื“ืจืึท. ื•ื•ื™ ื ื™ื˜ ืฆื• ืฉื˜ืึทืจื‘ืŸ ืื•ื™ื‘ ืื™ืจ ื ืึธืจ ื•ื•ื™ืกืŸ ืึธืจืึทืงืœืข

ื“ืขื ื ื•ืžืขืจ ืื™ื– ื’ืขื ื•ืžืขืŸ ืžื™ื˜ ืึท ื”ืึทืฉ ืคึฟื•ื ืงืฆื™ืข, ื•ื•ืึธืก ืื™ื– ื’ืขื•ื•ืขื ื“ื˜ ืฆื• ื•ื•ืึธืก ืžื™ืจ ืจื•ืคืŸ ื“ื™ ืฆืขื˜ื™ื™ืœื•ื ื’ ืฉืœื™ืกืœ. ื“ืึธืก ืื™ื– ื“ืขืจ ื–ื™ื™ึทืœ ื•ื•ืึธืก ืื™ื– ืกืคึผืขืกื™ืคื™ืขื“ ืื™ืŸ ื“ื™ ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ ื“ื™ืจืขืงื˜ื™ื•ื•, ืื•ืŸ ื“ืึธืก ืื™ื– ื“ืขืจ ื–ื™ื™ึทืœ ื•ื•ืึธืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ื“ืขืจ ืขืจืฉื˜ืขืจ ืื•ืŸ ืžืขืจืกื˜ ื™ืงืขืจื“ื™ืง ืฉืœื™ืกืœ ืคื•ืŸ ื“ืขืจ ืžืึทืคึผืข. ืขืก ื“ื™ื˜ืขืจืžืึทื ื– ื•ื•ืึธืก ื ืึธื“ืข ื•ื•ืขื˜ ื‘ืึทืงื•ืžืขืŸ ื•ื•ืึธืก ื“ืึทื˜ืŸ. ื ื˜ื™ืฉ ืื™ื– ื‘ืืฉืืคืŸ ืื™ืŸ Cassandra ืžื™ื˜ ื›ึผืžืขื˜ ื“ืขืจ ื–ืขืœื‘ื™ืงืขืจ ืกื™ื ื˜ืึทืงืก ื•ื•ื™ ืื™ืŸ SQL:

CREATE TABLE users (
	user_id uu id,
	name text,
	year int,
	salary float,
	PRIMARY KEY(user_id)

)

ื“ืขืจ ืขืจืฉื˜ื™ืง ืฉืœื™ืกืœ ืื™ืŸ ื“ืขื ืคืึทืœ ื‘ืืฉื˜ื™ื™ื˜ ืคื•ืŸ ืื™ื™ืŸ ื–ื™ื™ึทืœ, ืื•ืŸ ืขืก ืื™ื– ืื•ื™ืš ื“ื™ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืฉืœื™ืกืœ.

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

ืงืึทืกืึทื ื“ืจืึท. ื•ื•ื™ ื ื™ื˜ ืฆื• ืฉื˜ืึทืจื‘ืŸ ืื•ื™ื‘ ืื™ืจ ื ืึธืจ ื•ื•ื™ืกืŸ ืึธืจืึทืงืœืข

ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ: ื•ื•ืขืŸ ืœืึธื–ืŸ ืคึฟื™ืœื˜ืจื™ืจื•ื ื’ ื˜ื•ืจื ืก ืื™ืŸ ืคื•ืœ ื™ื‘ืขืจืงื•ืงืŸ, ืึธื“ืขืจ ื•ื•ืึธืก ื ื™ื˜ ืฆื• ื˜ืึธืŸ

ื–ืืœ ืก ืฉืจื™ื™ึทื‘ืŸ ืขื˜ืœืขื›ืข ืื•ื™ืกื’ืขืงืœื™ื‘ืŸ ื“ืขืจืงืœืขืจื•ื ื’: select * from users where, userid = . ืขืก ื˜ื•ืจื ืก ืื•ื™ืก ื•ื•ื™ ืื™ืŸ ืึธืจืึทืงืœืข: ืžื™ืจ ืฉืจื™ื™ึทื‘ืŸ ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ, ืกืคึผืขืฆื™ืคื™ืฆื™ืจืŸ ื“ื™ ื‘ืื“ื™ื ื’ื•ื ื’ืขืŸ ืื•ืŸ ืึทืœืฅ ืึทืจื‘ืขื˜, ื ื™ืฆืขืจืก ื‘ืึทืงื•ืžืขืŸ ืขืก. ืึธื‘ืขืจ ืื•ื™ื‘ ืื™ืจ ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ, ืœืžืฉืœ, ืึท ื‘ืึทื ื™ืฆืขืจ ืžื™ื˜ ืึท ื–ื™ื›ืขืจ ื™ืึธืจ ืคื•ืŸ ื’ืขื‘ื•ืจื˜, ืงืึทืกืึทื ื“ืจืึท ืงืึทืžืคึผืœื™ื™ื ื– ืึทื– ืขืก ืงืขืŸ ื ื™ืฉื˜ ืžืงื™ื™ื ื“ื™ ื‘ืงืฉื”. ื•ื•ื™ื™ึทืœ ื–ื™ ื˜ื•ื˜ ื ื™ืฉื˜ ื•ื•ื™ืกืŸ ืขืคึผืขืก ื•ื•ืขื’ืŸ ื•ื•ื™ ืžื™ืจ ืคืึทืจืฉืคึผืจื™ื™ื˜ืŸ ื“ืึทื˜ืŸ ื•ื•ืขื’ืŸ ื“ื™ ื™ืึธืจ ืคื•ืŸ ื’ืขื‘ื•ืจื˜ - ื–ื™ ื”ืื˜ ื‘ืœื•ื™ื– ืื™ื™ืŸ ื–ื™ื™ึทืœ ืื ื’ืขื•ื•ื™ื–ืŸ ื•ื•ื™ ืึท ืฉืœื™ืกืœ. ื“ืขืžืึธืœื˜ ื–ื™ ื–ืื’ื˜, "ืึธื•ืงื™ื™, ืื™ืš ืงืขืŸ ื ืึธืš ืžืงื™ื™ื ื“ืขื ื‘ืงืฉื”. ืœื™ื™ื’ ืœืึธื–ืŸ ืคึฟื™ืœื˜ืจื™ืจื•ื ื’." ืžื™ืจ ืœื™ื™ื’ืŸ ื“ื™ ื“ื™ืจืขืงื˜ื™ื•ื•, ืึทืœืฅ ืึทืจื‘ืขื˜. ืื•ืŸ ืื™ืŸ ื“ืขื ืžืึธืžืขื ื˜ ืขืคึผืขืก ืฉืจืขืงืœืขืš ื›ืึทืคึผืึทื ื–.

ื•ื•ืขืŸ ืžื™ืจ ืœื•ื™ืคืŸ ืื•ื™ืฃ ืคึผืจื•ื‘ื™ืจืŸ ื“ืึทื˜ืŸ, ืึทืœืฅ ืื™ื– ื’ื•ื˜. ืื•ืŸ ื•ื•ืขืŸ ืื™ืจ ื•ื™ืกืคื™ืจืŸ ืึท ืึธื ืคึฟืจืขื’ ืื™ืŸ ืคึผืจืึธื“ื•ืงืฆื™ืข, ื•ื•ื• ืžื™ืจ ื”ืึธื‘ืŸ, ืœืžืฉืœ, 4 ืžื™ืœื™ืึธืŸ ืจืขืงืึธืจื“ืก, ืึทืœืฅ ืื™ื– ื ื™ืฉื˜ ื–ื™ื™ืขืจ ื’ื•ื˜ ืคึฟืึทืจ ืื•ื ื“ื–. ื•ื•ื™ื™ึทืœ ืœืึธื–ืŸ ืคึฟื™ืœื˜ืจื™ืจื•ื ื’ ืื™ื– ืึท ื“ื™ืจืขืงื˜ื™ื•ื• ื•ื•ืึธืก ืึทืœืึทื•ื– ืงืึทืกืึทื ื“ืจืึท ืฆื• ื–ืึทืžืœืขืŸ ืึทืœืข ื“ื™ ื“ืึทื˜ืŸ ืคื•ืŸ ื“ืขื ื˜ื™ืฉ ืคึฟื•ืŸ ืึทืœืข ื ืึธื•ื“ื–, ืึทืœืข ื“ืึทื˜ืŸ ืกืขื ื˜ืขืจืก (ืื•ื™ื‘ ืขืก ื–ืขื ืขืŸ ืคื™ืœืข ืคื•ืŸ โ€‹โ€‹โ€‹โ€‹ื–ื™ื™ ืื™ืŸ ื“ืขื ืงื ื•ื™ืœ), ืื•ืŸ ื‘ืœื•ื™ื– ื“ืขืžืึธืœื˜ ืคื™ืœื˜ืขืจ ืขืก. ื“ืึธืก ืื™ื– ืึทืŸ ืึทื ืึทืœืึธื’ ืคื•ืŸ ื’ืึทื ืฅ ืกืงืึทืŸ, ืื•ืŸ ืงื•ื™ื ื•ื•ืขืจ ืขืก ื™ื– ืื™ื– ื“ื™ืœื™ื™ื˜ื™ื“ ืžื™ื˜ ืื™ื.

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

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

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

CREATE TABLE users_by_year_salary_id (
	user_id uuid,
	name text,
	year int,
	salary float,
	PRIMARY KEY((year), salary, user_id)

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

ืžื™ืจ ืฉื˜ืขืœืŸ ืกืึธืจื˜ื™ื ื’ ืื•ืŸ ืึธื ื˜ืึธืŸ ืจื™ืกื˜ืจื™ืงืฉืึทื ื–

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

ืงืึทืกืึทื ื“ืจืึท. ื•ื•ื™ ื ื™ื˜ ืฆื• ืฉื˜ืึทืจื‘ืŸ ืื•ื™ื‘ ืื™ืจ ื ืึธืจ ื•ื•ื™ืกืŸ ืึธืจืึทืงืœืข

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

ืื•ื ื“ื–ืขืจ ืึทืจื‘ืขื˜ ืื™ื– ื•ื•ื™ื“ืขืจ where, and, ืื•ืŸ ืžื™ืจ ื‘ืึทืงื•ืžืขืŸ ื ื™ืฆืขืจืก, ืื•ืŸ ืึทืœืฅ ืื™ื– ื’ื•ื˜ ื•ื•ื™ื“ืขืจ. ืื‘ืขืจ ืื•ื™ื‘ ืžื™ืจ ืคึผืจื•ื‘ื™ืจืŸ ืฆื• ื ื•ืฆืŸ ื‘ืœื•ื™ื– ืึท ื˜ื™ื™ืœ ืคื•ืŸ ื“ื™ ืงืœืึทืกื˜ืขืจื™ื ื’ ืฉืœื™ืกืœ, ืื•ืŸ ืึท ื•ื•ื™ื™ื ื™ืงืขืจ ื‘ืึทื˜ื™ื™ึทื˜ื™ืง ืื™ื™ื ืขืจ, ื“ืขืžืึธืœื˜ ืงืึทืกืึทื ื“ืจืึท ื•ื•ืขื˜ ืžื™ื“ ื‘ืึทืงืœืึธื’ื  ื–ื™ืš ืึทื– ืขืก ืงืขืŸ ื ื™ืฉื˜ ื’ืขืคึฟื™ื ืขืŸ ื“ืขื ืึธืจื˜ ืื™ืŸ ืื•ื ื“ื–ืขืจ ืžืึทืคึผืข ื•ื•ื• ื“ืขื ื›ื™ื™ืคืขืฅ, ื•ื•ืึธืก ื”ืื˜ ื“ื™ ืคืขืœื“ืขืจ ืคึฟืึทืจ ื“ื™ ื ืึทืœ ืคืึทืจื’ืœื™ื™ึทืš, ืื•ืŸ ื“ืขื ืื™ื™ื ืขืจ ื•ื•ืึธืก ืื™ื– ื ืึธืจ ืฉื˜ืขืœืŸ , - ื•ื•ื• ืขืจ ืœื™ื’ื˜. ืื™ืš ื•ื•ืขื˜ ื”ืึธื‘ืŸ ืฆื• ืฆื™ืขืŸ ืึทืœืข ื“ื™ ื“ืึทื˜ืŸ ืคื•ืŸ ื“ืขื ื ืึธื“ืข ื•ื•ื™ื“ืขืจ ืื•ืŸ ืคื™ืœื˜ืขืจ ืขืก. ืื•ืŸ ื“ืึธืก ืื™ื– ืึทืŸ ืึทื ืึทืœืึธื’ ืคื•ืŸ ื’ืึทื ืฅ ืกืงืึทืŸ ืื™ืŸ ืึท ื ืึธื“ืข, ื“ืึธืก ืื™ื– ืฉืœืขื›ื˜.

ืื™ืŸ ืงื™ื™ืŸ ื•ืžืงืœืึธืจ ืกื™ื˜ื•ืึทืฆื™ืข, ืฉืึทืคึฟืŸ ืึท ื ื™ื™ึทืข ื˜ื™ืฉ

ื•ื•ืึธืก ื–ืึธืœ ืžื™ืจ ื˜ืึธืŸ ืื•ื™ื‘ ืžื™ืจ ื•ื•ื™ืœืŸ ืฆื• ืฆื™ืœ ื ื™ืฆืขืจืก ื“ื•ืจืš ืฉื™ื™ึทืŸ ืึธื“ืขืจ ืขืœื˜ืขืจ ืึธื“ืขืจ ื’ืขืฆืึธืœื˜? ื’ืึธืจื ื™ืฉื˜. ื ืึธืจ ื ื•ืฆืŸ ืฆื•ื•ื™ื™ ื˜ื™ืฉืŸ. ืื•ื™ื‘ ืื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ื“ืขืจื’ืจื™ื™ื›ืŸ ื ื™ืฆืขืจืก ืื™ืŸ ื“ืจื™ื™ ืคืึทืจืฉื™ื“ืขื ืข ื•ื•ืขื’ืŸ, ืขืก ื•ื•ืขื˜ ื–ื™ื™ืŸ ื“ืจื™ื™ ื˜ื™ืฉืŸ. ื ื™ื˜ืึธ ื“ื™ ื˜ืขื’ ื•ื•ืขืŸ ืžื™ืจ ื’ืขืจืื˜ืขื•ื•ืขื˜ ืคึผืœืึทืฅ ืื•ื™ืฃ ื“ื™ ืฉืจื•ื™ืฃ. ื“ืึธืก ืื™ื– ื“ื™ ื˜ืฉื™ืคึผืึทืกื˜ ืžื™ื˜ืœ. ืขืก ืงืึธืก ืคื™ืœ ื•ื•ื™ื™ื ื™ืงืขืจ ื•ื•ื™ ืขื ื˜ืคืขืจ ืฆื™ื™ื˜, ื•ื•ืึธืก ืงืขื ืขืŸ ื–ื™ื™ืŸ ื“ืขื˜ืจืึทืžืขื ืึทืœ ืคึฟืึทืจ ื“ื™ ื‘ืึทื ื™ืฆืขืจ. ืขืก ืื™ื– ืคื™ืœ ืžืขืจ ืึธื ื’ืขื ืขื ืคึฟืึทืจ ื“ืขืจ ื‘ืึทื ื™ืฆืขืจ ืฆื• ื‘ืึทืงื•ืžืขืŸ ืขืคึผืขืก ืื™ืŸ ืึท ืจื’ืข ื•ื•ื™ ืื™ืŸ 10 ืžื™ื ื•ื˜.

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

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

ื“ืขื ืึธืจืžืึทืœื™ื™ื–ื™ื ื’ ื“ืึทื˜ืŸ ืื™ื– ื“ื™ ืงืœืึทืœ. ืžื™ืจ ืคืึทืจื’ืขืกืŸ ื•ื•ืขื’ืŸ ื ืึธืจืžืึทืœ ืคืืจืžืขืŸ, ืžื™ืจ ื”ืึธื‘ืŸ ื ื™ื˜ ืžืขืจ ืจื™ืœื™ื™ืฉืึทื ืึทืœ ื“ืึทื˜ืึทื‘ื™ื™ืกื™ื–. ืื•ื™ื‘ ืžื™ืจ ืœื™ื™ื’ืŸ ืขืคึผืขืก ืึทืจืึธืคึผ 100 ืžืืœ, ืขืก ื•ื•ืขื˜ ืœื™ื’ืŸ ืึทืจืึธืคึผ 100 ืžืืœ. ืขืก ืื™ื– ื ืึธืš ื˜ืฉื™ืคึผืขืจ ื•ื•ื™ ืกื˜ืึธืคึผืคึผื™ื ื’.

ืžื™ืจ ืื•ื™ืกืงืœื™ื™ึทื‘ืŸ ื“ื™ ืฉืœื™ืกืœืขืŸ ืคึฟืึทืจ ืคึผืึทืจื˜ื™ืฉืึทื ื™ื ื’ ืึทื–ื•ื™ ืึทื– ื–ื™ื™ ื–ืขื ืขืŸ ืคื•ื ืื ื“ืขืจื’ืขื˜ื™ื™ืœื˜ ื ืึธืจืžืึทืœื™. ืžื™ืจ ื˜ืึธืŸ ื ื™ื˜ ื•ื•ืขืœืŸ ื“ื™ ื”ืึทืฉ ืคื•ืŸ ืื•ื ื“ื–ืขืจ ืฉืœื™ืกืœืขืŸ ืฆื• ืคืึทืœืŸ ืื™ืŸ ืื™ื™ืŸ ืฉืžืึธืœ ืงื™ื™ื˜. ืึทื– ืื™ื–, ื“ื™ ื™ืึธืจ ืคื•ืŸ ื’ืขื‘ื•ืจื˜ ืื™ืŸ ื“ื™ ื‘ื™ื™ึทืฉืคึผื™ืœ ืื•ื™ื‘ืŸ ืื™ื– ืึท ืฉืœืขื›ื˜ ื‘ื™ื™ึทืฉืคึผื™ืœ. ื’ืขื ื•ื™, ืก'ืื™ื– ื’ื•ื˜ ืื•ื™ื‘ ืื•ื ื–ืขืจืข ื‘ืื ื•ืฆืขืจ ื•ื•ืขืจืŸ ื ืืจืžืืœ ืคืืจืฉืคืจื™ื™ื˜ ืœื•ื™ื˜ ื’ืขื‘ื•ืจื˜ืก ื™ืืจ, ืื•ืŸ ืฉืœืขื›ื˜ ืื•ื™ื‘ ืžืขืŸ ืจืขื“ื˜ ืคื•ืŸ 5'ื˜ืข ืงืœืืก ืกื˜ื•ื“ืขื ื˜ืŸ - ื“ื™ ืคืืจื˜ื™ื™ืœื•ื ื’ ื“ืืจื˜ ื•ื•ืขื˜ ื ื™ืฉื˜ ื–ื™ื™ืŸ ื–ื™ื™ืขืจ ื’ื•ื˜.

ืกืึธืจื˜ื™ื ื’ ืื™ื– ืื•ื™ืกื’ืขืงืœื™ื‘ืŸ ืึทืžืึธืœ ืื™ืŸ ื“ืขืจ ืฉืึทืคื•ื ื’ ื‘ื™ื ืข ืคื•ืŸ โ€‹โ€‹ืงืœืึทืกื˜ืขืจื™ื ื’ ืฉืœื™ืกืœ. ืื•ื™ื‘ ืขืก ื“ืึทืจืฃ ื–ื™ื™ืŸ ื’ืขื‘ื™ื˜ืŸ, ืžื™ืจ ื•ื•ืขืœืŸ ื”ืึธื‘ืŸ ืฆื• ื“ืขืจื”ื™ื™ึทื ื˜ื™ืงืŸ ืื•ื ื“ื–ืขืจ ื˜ื™ืฉ ืžื™ื˜ ืึท ืึทื ื“ืขืจืฉ ืฉืœื™ืกืœ.

ืื•ืŸ ื“ื™ ืžืขืจืกื˜ ื•ื•ื™ื›ื˜ื™ืง ื–ืึทืš: ืื•ื™ื‘ ืžื™ืจ ื“ืึทืจืคึฟืŸ ืฆื• ืฆื•ืจื™ืงืงืจื™ื’ืŸ ื“ื™ ื–ืขืœื‘ืข ื“ืึทื˜ืŸ ืื™ืŸ 100 ืคืึทืจืฉื™ื“ืขื ืข ื•ื•ืขื’ืŸ, ืžื™ืจ ื•ื•ืขืœืŸ ื”ืึธื‘ืŸ 100 ืคืึทืจืฉื™ื“ืขื ืข ื˜ื™ืฉืŸ.

ืžืงื•ืจ: www.habr.com

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