××× ×ע׊×× ×¡, Odnoklassniki ס××Öž×š× ×××¢×× 50 ×× ×€×× ××Ö·×× ×€ÖŒ×š×Ö·×¡×¢×¡× ××× ×€×ַק××ש ׊××× ××× SQL סעך×××ךעך. ×€Ö¿×ַך ×Ö·××Ö· ×Ö· ××Ö·× ×, עס ××× ×ÖŒ××¢× ×××××¢×××¢× ×Š× ×Š×ש××¢×× ×©× ×¢× ××× ×€×ַך××Öž×××¢×, ××× ××€××× ××Ö·×× ×Š×¢× ×עך ××ך××€×Ö·×-××Öž×עך×Ö·× × ×ַקסעס × ××Š× ×Ö· SQL DBMS. ×××€ÖŒ×ק×Ö·×××, ××× ×Ö·××Ö· ק×ַסעס, ×××× ×¢×š ×€×× ×× NoSQL ס××֞ך×××ש ××× ××¢× ×׊×, ×Öž×עך × ×× ×Ö·××¥ ×§×¢× ×¢× ×××× ×ך×Ö·× ×¡×€×¢×š× ×Š× NoSQL: ×¢×××¢××¢ ×¢× ××××× ××Ö·×š×€× ×ַס×× ×ך×Ö·× ×¡×ַק×××Öž× ×עך×Ö·× ×××.
××֞ס ××Öž× ××× ×× ××¢×€Ö¿××š× ×Š× ×× × ××Š× ×€×× NewSQL ס××֞ך×××ש, ××֞ס ×××, ×Ö· DBMS ×××֞ס ××× ×©××× ××Öž×עך×Ö·× ×¥, סק×Ö·××Ö·×××××× ××× ×€×֞ךש××¢××× × ×€×× NoSQL ס×ס××¢××¢×, ×Öž×עך ××× ×עך ××¢×××קעך ׊××× ××Ö·××× ×× ×ַס×× ×עך×Ö·× ××× ××ַק×Ö·× × ××× ×§××ַס×ש ס×ס××¢××¢×. עס ××¢× ×¢× ××××× ×ק ×ך××¢×× ×× ××ַס×ך××Ö·× ×¡×ס××¢××¢× ×€×× ××¢× × ××Ö· ק××ַס, ×Ö·××× ××ך ×××€ÖŒ××Ö·××¢× ×Ö·× ×Ö·××Ö· ×Ö· ס×ס××¢× ××× ××× ×©××¢×× ×¢×¡ ××× ××¢×©×¢×€× ×֞׀֌עך×ַ׊××¢.
××× ×¢×¡ ×ַך××¢× ××× ×××֞ס ××¢×ך××€× - ××××¢× ×¢× ××× ×עך ×× ×©× ××Ö·××.
×××Ö·× ×, ×× ××××עש××¢× ××××¢× ×€×× Odnoklassniki ××× ×עך ××× 70 ×××××Öž× ××× ×Š×ק ×××××Ö·×עך×. ××ך
××ך ××Öž×× ×©××× × ××Š× Cassandra ××× × 2010, ס××ַך××× × ××× ××עךס××¢ 0.6. ×××Ö·× × ×¢×¡ ××¢× ×¢× ×¢×××¢××¢ ×××¥ ק××ַס××¢×š× ××× ×֞׀֌עך×ַ׊××¢. ×× ×€×ַס××Ö·×¡× ×§× ××× ×€ÖŒ×š×ַסעס×Ö·× ×עך ××× 4 ×××××Öž× ×ַ׀֌עך××ש×Ö·× × ×€ÖŒ×¢×š סעק×× ××¢, ××× ×× ×ךעס×× ×¡××Öž×š× 260 ××.
×Öž×עך, ××֞ס ××¢× ×¢× ×Ö·××¢ ׀֌ך×Öž×¡× NoSQL ק××ַס××¢×š× ××¢× ××Š× ×€Ö¿×ַך ס××֞ך×××ש
×Š× ×€×ַךש׀֌ך×××× ××Ö·×× ×ַך××עך SQL Server × ×Öž×××, ××ך ××¢××××× × ×××××¢ ××עך××ק×Ö·× ××× ××֞ך×××Öž× ××Ö·×
××Ö·× ×§ ×Š× ×©×ַך××× × ××× ×Š× ×€×ַך××××¢×š× SQL:
- ××ך ××Öž× × ×× × ××Š× ×€×š×¢×× ×©×××¡× ×§×Ö·× ×¡×ך××× ×¥, ××××Ö·× ×××¢× ×©×ַך××× × ×× ×¢× ×××× ×©××Ö·× ×§×¢× ×××× ×××× ××××£ ×× ×× ×עך סעך××עך.
- ××ך ××Öž× × ×× × ××Š× ×¡××Öž×š× ×€ÖŒ×š×Öž×ס××××©×¢×š× ××× ×ך×××¢×š× ×š×¢×× ×Š× ×עך × ×Öž× ××ַסע ××××£ ×× DBMS ק׀֌×.
- ××ך ××Öž× × ×× × ××Š× JOINs ××××Ö·× ×€×× ×Ö·××¢ ×× ××××× ××× ×Ö· ×€ÖŒ××Ö·×¥ ×€×× ×ך×Ö·×€ - ××××¢× ×¢× ×€Ö¿×× ××סק.
- ×ַך××ס ×€×× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž×, ××ך × ××Š× ×× ××××¢× ×¢× ×× ×§×Öž××××××¢× ××€××¢××× ×עך×ק××× ××ך×× ×Š× ×š×¢××׊××š× ××¢×××ַקס.
- ××ך ××ך××€××š× ××××× ×§×ךץ ×ך×Ö·× ××ַקש×Ö·× × (××× ××ך××©× ××××¢× ×§×ך׊עך ××× 100 ×××).
- ××ך ××Öž× × ×× × ××Š× ×××××-ך×××¢×š× ×עך×××Ö·× ×××§× ××× ××ס××¢×§× ×š×¢×× ×Š× ×עך ×ך××ס × ××עך ×€×× ××¢×××ַקס - ××ך ×עך×××Ö·× ×××§× ××××× ×××× ×š×¢×§×Öž×š× ××× ×Ö· ׊×××.
- ××ך ש××¢× ××ק ××ך××€××š× ×€Ö¿×š××× ××××× ××××£ ×× ×עקס×× - ×Ö· ×Öž× ×€Ö¿×š×¢× ××× ×Ö· ×€×× ××ש ××עךק××§× ×€ÖŒ××Ö·× ×€Ö¿×ַך ××× ×× ×××× ×Öž×××עך××Öž×××× × ×× ××Ö·××Ö·×××ס ××× ×€×ַךש×Ö·×€× ×¢×¡ ×Š× ×€×ַך××Öž××.
×× ×¡×ע׀֌ס עך××××× ××× ×× ×Š× ×§×××¢××©× ×ÖŒ××¢× ××ַקס×××× ×€×֞ךש××¢××× × ×€×× SQL סעך××עךס. ×Öž×עך, ×× ×€ÖŒ×š×Öž×××¢×ס ××¢××××š× ×עך ××× ×עך ס×. ××× ×¡ ק×ק ×××Ö· ×××.
׀֌ך×Öž×××¢×ס ××× SQL
- ××× × ××ך ××¢××××× × ×××-×עשך××× ×©×ַך××× ×, ×Ö·××× × × ××Ö· ש×ַך×× ××× ××Ö·× ×××Ö·×× ××¢××× ×××š× ×Ö·×××× ×ס×ך×Ö·××֞ךס. ×Ö·××¢ ×× ×Š×××, סק×Ö·××Ö·×××¢ ××Ö·×× ×š×¢×€ÖŒ××ַק×Ö·× ××¢× ×¢× × ××©× ×¡×¢×š×××ס×× × ×š×ק××עס.
- ××× ×× × ××עך ×€×× ×š×¢×§×֞ך×ס ××× ×× ××ש ×××קס×, ×× ×××ק××Ö·× ×€×× ×× ×¡×¢×š×©×Ö·× ××× ××Öž×××€×ק×Ö·×××Öž× ××קך×ס×Ö·× ×××¢× ×Ö·××× × ×× ×עקס×× ×Š× ×Ö· ××××ס××× × ××ש, ×× ×××ק××Ö·× ×ך××€× ×¡ ×××š× ×Ö· ×€×ַק××֞ך ××× ×©××Ö·×¢×-ש×Ö·×€×× × ×€×× ×× ×עקס×× ×ַקעך×;
- ××××× ×Ö· ק×××× ×¡×××¢ ×€×× ââââWindows ×€Ö¿×ַך SQL Server ××× ×€ÖŒ×š×Öž××ק׊××¢ ×××× ×× ×€×š×ַס×ך×ַק×שעך ×€×ַך×××Ö·×××× × ×©××עך
××עך ×עך ××××€ÖŒ× ×€ÖŒ×š×Öž×××¢× ×××
ש××× ××Öž×עך×Ö·× ×¥
×עך ק××ַס×ש ×¡×§× ×¡×¢×š××עך ××× × ×¢××¢× ×©××× ××Öž×עך×Ö·× ×¥. ××× ×¡ ××Öž×× ××ך ××Öž×× ××××× ×××× ××Ö·××Ö·×××ס סעך××עך, ××× ×¢×¡ ×€×××× ×Ö·××Öž× ××¢×עך ×ך×× ××֞ך. ××× ××¢× ×Š×××, ×× ×€ÖŒ××Ö·×¥ ××× ×ַך×Öž×€ÖŒ ×€Ö¿×ַך 20 ××× ××, ×××֞ס ××× ×€ÖŒ×ַס×ק. ×××× ××ך ××Öž×× 64 סעך××עךס, ×× ×€ÖŒ××Ö·×¥ ××× ×ַך×Öž×€ÖŒ ×Ö·××Öž× ××¢×עך ×ך×× ×××Öž××. ××× ×××× ××ך ××Öž×× 200 סעך××עךס, ×עך ×€ÖŒ××Ö·×¥ ××× × ××©× ×ַך××¢×× ××¢×עך ×××Öž×. ××֞ס ××× ×Ö· ׀֌ך×Öž×××¢×.
×××֞ס ×§×¢× ×¢× ×××× ××¢××× ×Š× ×€Ö¿×ַך××¢×¡×¢×š× ×× ×©××× ××Öž×עך×Ö·× ×¥ ×€×× ×Ö· SQL סעך××עך? ×××ק××€×¢×××¢ ×× ×××××¥ ××× ×× ×Š× ××××¢×
××֞ס ך×ק×××××¢×š× ×Ö· ×€××× ×€×× ×××ַעך ××סך×××: ×€×××¢ ×××€ÖŒ××ק××ש×Ö·× ×, ×Öž×€ÖŒ××ש ×€××ךע, ×©×¢×š× ×¡××֞ך×××ש ××× ×× ×× ×§×××ש×Ö·× ×€×× ×Ö· ךע×עך×× ×ַך××¢× × ××©× ×š×××××Ö·×××: ×××¢×× 10% ×€×× ×× ×¡××××ש×× × ×¢× ×××§× ××× ×× ××ך××€×Ö·× ×€×× ×× ××ַק×Ö·×€ÖŒ × ×Öž××¢ ××× ×Ö· ××Ö·× ××× ×עך ×× ××××€ÖŒ× × ×Öž××¢.
×Öž×עך ×עך ××××€ÖŒ× ××ס×Öž×š× ×€×× ×Ö·××Ö· ×Ö· ××¢××¡× ×× ×××Š× ×§× ××× ××× × ×× ×Ö·××××××Ö·××××Ö·×× ×××× ×× ××Ö·×× ×Š×¢× ×עך ××× ×××֞ס עס ××× ×××× ×€××××. Odnoklassniki ××× ×€×ך ××Ö·×× ×¡×¢× ×עךס, ××× ××ך ××Ö·×š×€Ö¿× ×Š× ×¢× ×©×ך ×× ×֞׀֌עך×ַ׊××¢ ××× ×€×Ö·× ×€×× ×Ö· ××Ö·× ×¥ ××ך××€×Ö·× ××× ×××× ×¢×š ×€×× ×××.
×€Ö¿×ַך ××¢× ××ך ×§×¢× × ×׊×
× × ×× ×¢ ׀ך××××¢××¢ × ××× × ××¢××ך׀ × × ×š×××ק×××¢ ך ×ײ××× × , ×× × ×× ×š ××× × × ×² ×× ××¢×××× × ×× × ××¢××××××¢× × ×Ö·× ×Ö·×××××š× . ××Öž ××ך ××Ö·×š×€Ö¿× ×Š× ××ַק×××¢× ××ַק×Ö·× × ××× ×××֞ס SQL Server ×עך ××××€ÖŒ× ××× - ×ך×Ö·× ××ַקש×Ö·× ×.
׀֌ש×× ×ך×Ö·× ×¡×ַק×××Öž×
××× ×¡ ××Ö·×ך×Ö·××× ×× ×¡×××€ÖŒ××Ö·×¡× ×ך×Ö·× ×¡×ַק×××Öž×, ×€Ö¿×× ×× ×€×× × ×€×× ×××× ×× × ×€×× ×Ö· ××¢×××¢× ×× SQL ׀֌ך×Öž×ך×Ö·××ס×: ×Ö·××× × ×Ö· ×€×Öž××Öž ×Š× ×Ö·× ×××××. ×Ö·××××ס ××× ×€×Öž×××Ö·×ך×ַ׀ס ××¢× ×¢× ×¡××Öž×š× ××× ×€×ַךש×××¢× ×¢ ×€ÖŒ××Ö·×עס. ×עך ××××× ××× ×Ö· ׊×××ך ×€×Öž××Öž ××Öž×××Ö·× ×§. ××¢×š× ×Öž×, ×Ö·××Ö· ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ××× ×Š×¢××××× ××× ×× ×€××××¢× ××¢ ס×ע׀֌ס:
- ××ך ש××֞ס ××¢× ××××× ×××š× ×©××ס×.
- ש×Ö·×€Ö¿× ×Ö· ×€ÖŒ×Öž××׊××¢ ××× ×× ×€×Öž××Öž ××ש.
- ×××× ×× ×€×Öž××Öž ××× ×Ö· ׊×××ך ס××Ö·××ס, ××××× ×Ö· ׊×××ך ×€×Öž××Öž ××Öž×××Ö·× ×§ ×Š× ××¢× ×××××, ×עך×××Ö·× ×××§× ×× ×š×¢×§×Öž×š× ××× ××עך××¢×× ×× ×ך×Ö·× ×¡×ַק×××Öž×.
×Öž×עך ××× ×€ÖŒ×¡×¢××××֞ק×Öž××¢:
TX.start("Albums", id);
Album album = albums.lock(id);
Photo photo = photos.create(âŠ);
if (photo.status == PUBLIC ) {
album.incPublicPhotosCount();
}
album.update();
TX.commit();
××ך ××¢× ×Ö·× ×× ××¢×š×¡× ×€ÖŒ×š×Öž×¡× ××¢×©×¢×€× ×ך×Ö·× ×¡×ַק×××Öž× ×¡×Š×¢× ×ַך ××× ×Š× ××××¢× ×¢× ××Ö·×× ×€×× ×× ××Ö·××Ö·×××ס ××× ×עך ××֌ך×× ×€×× ×× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×¡×¢×š××עך, ××××©× ×¢×€ÖŒ×¢×¡ ××× ×š×Ö·××¢×××¢× ×× × ××Ö·×¢ ×××Ö·××עס ׊×ך×ק ×Š× ×× ××Ö·××Ö·×××ס. ×××ש×Ö·×××Ö·×× ××× ×Ö·××Ö· ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ××ך ×עך×××Ö·× ×××§× ×¢×××¢××¢ ×¢× ×××××, ×¢×××¢××¢ ××ש×.
×××¢× ×¢×§×¡×ַק××××× × ×Ö· ×ך×Ö·× ×¡×ַק×××Öž×, ק×Ö·× ×§×¢×š×Ö·× × ××Öž×××€×ק×Ö·×××Öž× ×€×× ×× ××¢×××¢ ××Ö·×× ×€×× ×× ×× ×עך ס×ס××¢× ×§×¢× ×€ÖŒ×ַס×ך×. ×€Ö¿×ַך ×××ַש׀֌××, ×Ö·× ××ס׀֌×Ö·× ×§×¢× ××ַש×××¡× ×Ö·× ×עך ××Ö·× ×׊עך ××× ×¢×€×¢×¡ ס×ַס׀֌×ש×ַס ××× ×עך××עך ×Ö·××¢ ×× ×€×Öž××֞ס ×€×× ×× ××Ö·× ×׊עך ××Öž× × ×× ×עך ×××× ×¢×€× ×××¢×, ××× ××Ö·×š×€Ö¿× ×Š× ×××× ×עש××§× ×€Ö¿×ַך ××Ö·×עך××ש×Ö·×, ×××֞ס ×××× ×ש×Ö·× ××× × ×€×Öž××Öž.ס××Ö·××ס ×Š× ×¢×××¢××¢ ×× ×עךע ×××¢×š× ××× ×§×¢×š ×Ö·××עק ×× ×§×֞ך×ַס׀֌×Ö·× ××× × ×§×Öž×× ×עךס. ××Öž×, ×××× ××¢× ×֞׀֌עך×ַ׊××¢ ×Ö·×§×¢×š× ×Öž× ×עך×Ö·× ××× ×€×× ×Ö·××Öž××ס××× ×€×× ×Ö·×€ÖŒ××ַק××ש×Ö·× ××× ××€××¢××× ×עך×ק××× ×€×× ×§×Ö·××€ÖŒ×××× × ××Öž×××€×ק×Ö·×××Öž× ×¡, ××× ×××
× ×€ÖŒ××Ö·×¥ ×€×× ×¢× ××¢× ×§×Öž×, ××Ö·× ××€ÖŒ××Ö·×××××× × ×€×ַךש××× ××¢×©×¢×€× ×¢× ××××× ××× ×××× ×ך×Ö·× ×¡×ַק×××Öž×, ××× ×עשך××× ×××עך ×× ××× ×Š×¢ עק××ס××¢× ×¥ ×€×× Odnoklassniki. ××Ö·×××š× ××××£ ×עך ×עך׀×ַך×× × ×€×× ××××ך××ש×Ö·× × ×Š× NoSQL ×€Ö¿××
×× ×עךע, × ×× ××××× ×קעך ××××××ק, ××××¢×š×€×¢× ××©× ××¢× ×¢×:
- ×××× ×× ××Ö·×× ×Š×¢× ×עך ×€××××, ×××××¢ ××××¢× ×¢× ××× ×©×š×××× ×Š× ×× × ××Ö·×¢ ס××֞ך×××ש ×××× ×××× ××ךע×××××.
- ×××× ×××× ×× × ×§×š×Ö·× × ×Ö·× ××××ק××× × ×××ק××Ö·×. ×Ö·× ×××, ×××¢× ×ך××¢×× ××× ×Ö· × ××Ö· ך××€ÖŒ×Ö·××Ö·××֞ך×, ×× ×¡×××¢ ×€×× ââק×Öž× ××Öž× ×××× ××¢×¢×š×¢× ×עך ××¢×××קעך עס ××Öž× ×××× × ×× ××Ö·×š×€Ö¿× ×Š× ××××× ×¢×€ÖŒ×¢×¡ ×Š× ×× ×š××€ÖŒ×Ö·××Ö·××֞ך×, ×Ö·× ××××ק××¢× ×Ö·××עך×××Ö·×× ×€Ö¿×ַך ך×××Ö·××××× × ×§×Öž× ×€××ק×, ××Ö·××× ×Š××××××ק ×× ×עקס××, ×××"× ×.
- ×× ×××ק××Ö·× ×€×× ×× × ××Ö· ס××֞ך×××ש ××× ×Š× ×××× ××Ö·× ×¥ ××××, ×××××¢ ×××¢× ××××¢× ×¢× ××Ö·×× ××× ×€ÖŒ×š×ַסעס×× × ×ך×Ö·× ××ַקש×Ö·× ×, ×××֞ס ×׀עק×××××× ××¢× × ×Ö·× ×ַק×Ö·××¢××ק×× ×©××š×¢× ×, ×× ×××עךס×Ö·×, ×Öž×עך ×€ÖŒ×Ö·××¢××¢× ×¡×Ö·××ש×Ö·× ×, ×Ö·××Ö· ×××, ×€Ö¿×ַך ×××ַש׀֌××, ××¢× ×¢× × ××©× ×Öž× ×××¢× ×××¢×.
׊××××-×€×ַסע ק×Ö·×××¥ . - ×Öž××Ö·××Ö·××ק ××××£-××¢×-×€×××¢× ×¡×§××××× ×.
- × ××Š× ×š×¢×××עך ××××ק סעך××עךס, ×Öž× ×× ××Ö·×š×€Ö¿× ×Š× ×§×××€× ×¢×§××Öž××ש ××Ö·×× ×××ַך×.
- ××¢×××¢×ק××× ×€×× ×¡××֞ך×××ש ×Ö·× ××××ק××× × ×××š× ×€×ך××¢ ××¢×××¢××֞׀֌עךס. ××× ×× ×עךע ××עך×עך, ××××עךק××Ö·× ××× ××¢××¢×× ×Š× ×€ÖŒ×š×ַ׀֌ך×××Ö·××¢×š× ×Öž×עך ×Öž×€Ö¿× ×ק×ך ס×Ö·××ש×Ö·× ×, ׀֌ךע׀עך×Ö·××× ××× Java.
××ש××ס×, ××ש××ס×
×Ö·× ×Ö·×××××× × ××¢×××¢× ×¡×Ö·××ש×Ö·× ×, ××ך ×עק×××¢× ×Š× ×Š×××× ××¢×××¢× ×ַךק×Ö·×עק×שעך ×ך×ך×ת:
×עך עךש×עך ××× ×Š× × ×¢××¢× ×§××× SQL סעך××עך ××× ×× ×¡×ך×××¢× × ×× ×€×ך××× ×× ×©××× ××Öž×עך×Ö·× ×¥, סק××××× × ×עק×Ö·× ×××Ö·×, ×€×Ö·×××Öž××עך ×§× ×××, ק×Öž× ×€×××§× ××Ö·×××Öž××¢ ××× ×€×× ×× ×עך××¢×××××, ×€×ַך××Öž×××¢× ××× ×©× ×¢× ×ַס×× ×ך×Ö·× ××ַקש×Ö·× ×. ××ך ך××××Ö·× ××¢× ×֞׀֌׊××¢ ××× ×××עך × ××-× ××××××Ö·× ××× ×ַך××¢×-××× ××¢× ×¡××××¢.
×× ×š××¢ ×֞׀֌׊××¢ ××× ×Š× × ×¢××¢× ×Ö· ×€×ַך××ק NoSQL ס××֞ך×××ש ××× ×××€ÖŒ××Ö·××¢× ×Ö·× ×¡×§××××× ×, ×Ö· ×€×Ö·×××Öž××עך ×§× ×××, ק×Öž× ×€×××§× ××Ö·×××Öž××¢ ××× ×× ×¡×ך×××¢× × ×ך×Ö·× ××ַקש×Ö·× × ××× SQL ×××. ××× ×¢×š×©×עך ×××ק, ××€××× ×× ×ַך××¢× ×€×× ×××€ÖŒ××Ö·××¢× ×× × SQL, × ×× ×Š× ×עך××Öž× ×¢× ×ַס×× ×ך×Ö·× ××ַקש×Ö·× ×, ק××§× ××× ×Ö· ×ַך××¢× ×××֞ס ×××¢× × ×¢××¢× ××֞ך×. ×Öž×עך ××¢××Öž×× ××ך ×××× ××¢××¢× ×Ö·× ×× SQL ש×ך×× ×©××¢×× ××ך × ××Š× ××× ×€×ך ××× ××× ××××Ö·× ×€×× ANSI SQL ×××
ק×ַס×Ö·× ×ך×Ö· ××× ×§×§×
×Ö·×××, ×××֞ס ××× ×ש×ק×Ö·×××¢ ×××¢×× Cassandra, ×××֞ס ק×××€ÖŒ×Ö·××××Ö·××× ×¢×¡ ×××?
×€×ךס×××, ××Öž ××ך ×§×¢× ×¢× ××Ö·×× ×××©× ×××֞ס ש×××Š× ×€×ַךש××× ××Ö·×× ×××׀֌ס, ××ך ×§×¢× ×¢× ×××סק×××Ö·×× ×Öž×עך ×עך×××Ö·× ×××§× ××××£ ×× ×¢×š×©××ק ש××ס×.
CREATE TABLE photos (id bigint KEY, owner bigint,âŠ);
SELECT * FROM photos WHERE id=?;
UPDATE photos SET ⊠WHERE id=?;
×Š× ×¢× ×©×ך ךע׀֌××קע ××Ö·×× ×§×Öž× ×¡×ס××¢× ×¡×, Cassandra × ×׊×
×עך ׊×××Ö·× × ×××¢× ××ך ק×Öž× ××Ö·×§× ×ך××Ö· × ×Öž××× ××× ××ַק×××¢× ×Ö· ×¢× ×׀עך ×€×× ×Š×××× ××× ×עך××€×
×× ×× ×עך × ××¥ ×€×× Cassandra ××× Batchlog, ×Ö· ×עק×Ö·× ×××Ö·× ×××֞ס ×× ×©××š× ×Ö·× ×Ö· ×€ÖŒ×¢×§× ×€×× ×¢× ×עך×× ××¢× ×××֞ס ××ך ××Ö·×× ××¢× ×¢× ××֞ך ××¢×××¢× ×× ×Öž×עך × ××©× ××¢×××¢× ××. ××֞ס ×Ö·××Ö·×× ××× ×× ×Š× ×¡×Öž××××¢ × ××× ×ַס×× - ×Ö·××Öž××ס××× ×××ס ×€×× ×× ×§×¢×¡××.
×× ×§××Öž×ס×Ö·×¡× ××Ö·× ×Š× ×ך×Ö·× ××ַקש×Ö·× × ××× ×§×ַס×Ö·× ×ך×Ö· ××¢× ×¢× ×× ×Ö·××× ×עך××€×¢× ×¢ "
×××֞ס ××ך ××Öž×× ×€×¢×× ××ק ××× ×§×ַס×Ö·× ×ך×Ö·
×Ö·×××, ××ך ××Öž×× ×Š× ×× ×¡×ך×××¢× × ×€×ַק××ש ×ַס×× ×ך×Ö·× ××ַקש×Ö·× × ××× ×§×ַסס×Ö·× ×ך×Ö·. ××× ×××֞ס ××ך ×§×¢× ×¢× ××××× ×× ×¡×ך×××¢× × ×Š×××× ×× ×עךע ××ַק×××¢× ×€Ö¿×¢×֎ק×××× ×€×× ×§××ַס×ש DBMS: ק×Öž× ×¡×ס××¢× × ×©× ×¢× ×× ×עקס××, ×××֞ס ×××Öž×× ××Öž×× ××× ×× ×Š× ××ך××€××š× ××Ö·×× ×¡×Ö·×עקש×Ö·× × × ×× ××××× ×××š× ×× ×¢×š×©××ק ש××ס×, ××× ×Ö· ךע×××עך ××¢× ×¢×š×Ö·××֞ך ×€×× ××Ö·× ×Ö·××Ö·× ×ק ×Ö·×××Öž ×× ×§×š×Ö·××Ö·× ××× × ××ס.
C * ××××
×××× ××× ××¢××××š× ×Ö· × ××Ö· DBMS C * ××××, ק×Ö·× ×¡×ס××× × ×€×× ×ך×× ×××׀֌ס ×€×× ×¡×¢×š××עך × ×Öž×××:
- ס××֞ך×××ש - (×ÖŒ××¢×) × ×֞ך××Ö·× ×§×ַסס×Ö·× ×ך×Ö· סעך××עךס ×€×ַך×Ö·× ××××֞ך×××¢× ×€Ö¿×ַך ס××֞ך×× × ××Ö·×× ××××£ ××××¢ ××סקס. ××× ×× ××ַסע ××× ××Ö·× × ×€×× ××Ö·×× ×××ַקס×, ×××עך ק×××Ö·× ×××× ×§×¢× ×¢× ×××× ××××× ×¡×§×××× ×Š× ××¢× ×¡ ××× ××× ×עך×עך.
- ×ך×Ö·× ×¡×ַק×××Öž× ×§×Öž×֞ך××× ×Ö·××֞ךס - ×¢× ×©×ך ×× ××ך××€×ך×× × ×€×× ×ך×Ö·× ××ַקש×Ö·× ×.
- ק××××Ö·× ×¥ ××¢× ×¢× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×¡×¢×š××עךס ×××֞ס ×× ×¡×ך×××¢× × ××¢×©×¢×€× ×ַ׀֌עך××ש×Ö·× × ××× ×Öž× ××××× ×ך×Ö·× ××ַקש×Ö·× ×. עס ×§×¢× ×¢× ×××× ××××× ×עך ×€×× ×Ö·××Ö· ק××××Ö·× ×¥.
סעך××עךס ×€×× ×Ö·××¢ ×××׀֌ס ××¢× ×¢× ×××× ×€×× ×Ö· ׀֌ך×Öž×¡× ×§× ×××, × ××Š× ×× ×× ×¢×š××¢× Cassandra ×Öž× ××Öž× ×€ÖŒ×š×Öž××֞ק×Öž× ×Š× ××עך××¢×× ××× ××¢×עך ×× ×עךע ×××
ק×ַס××Ö·×עך×
×Ö·× ×©××Öž× × ×֞ך××Ö·× ×ך×××עךס, Fat Client ××Öž××¢ ××× ××¢× ×׊×. ×Ö·××Ö· ×Ö· × ×Öž××¢ ××× × ××©× ×§×š×Öž× ××Ö·××, ×Öž×עך ×§×¢× ×¢× ×©×€ÖŒ××× ××× ×Ö· ק×Öž×֞ך××× ×Ö·××֞ך ×€Ö¿×ַך ×× ××ך××€×ך×× × ×€×× ××¢××, ××֞ס ×××ס×, ×עך ק×××¢× × ××× ×ק×× ××× ×Ö· ק×Öž×֞ך××× ×Ö·××֞ך ×€×× ×××× ×š×ק××עס: עס ק××עך×× × ×¡××֞ך×××ש ךע׀֌××ַק×Ö·× ××× ×š×××Ö·×××× ×§×Öž× ×€××ק×. ××֞ס ××× × ×× ××××× ×עך ×€×ַך××Öž×××¢× ××× ×€×ַס×עך ××× ×עך × ×֞ך××Ö·× ×©×֞׀עך, ×××֞ס ך×ק×××××¢×š× ×§×Öž××× ×ק×ַ׊××¢ ××× ×Ö· ××××Ö·× ×§×Öž×֞ך××× ×Ö·××֞ך, ×Öž×עך ×××× ×Ö·××Ö·×× ××ך ×Š× ×§×Öž× ×ך×Öž×××š× ×× ×ך×Ö·× ×¡××ס××¢ ×€×× ââך×ק××עס. ×ַך××ס ×€×× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ×¢×€×¢× ×¢× ××××£ ××¢× ×§×××¢× ×, ך×ק××עס ××¢× ×¢× ×עש××§× ×Š× ×š××€ÖŒ×Ö·××Ö·××֞ך××. ×××× ×עך ק×××¢× × ××× ××¢×¢×€× × ×Ö· ×ך×Ö·× ×¡×ַק×××Öž×, ×Ö·××¢ ך×ק××עס ××× ×× ×ך×Ö·× ×¡×ַק×××Öž× ××¢× ×¢× ×עש××§× ×Š× ×× ×ך×Ö·× ×¡×ַק×××Öž× ×§×Öž×֞ך××× ×Ö·××֞ך.
C * ×××× ×ך×Ö·× ×¡×ַק×××Öž× ×§×Öž×֞ך××× ×Ö·××֞ך
×עך ק×Öž×֞ך××× ×Ö·××֞ך ××× ×¢×€ÖŒ×¢×¡ ×××֞ס ××ך ×××€ÖŒ××Ö·××¢× ×Ö·× ×€Ö¿×ַך C * ×××× ×€Ö¿×× ×§×š×ַ׊×. עס ××× ×€×ַך×Ö·× ××××֞ך×××¢× ×€Ö¿×ַך ×Öž× ×€×ך×× × ×ך×Ö·× ××ַקש×Ö·× ×, ××ַקס ××× ×× ×¡×ך ××× ×××֞ס ×ך×Ö·× ××ַקש×Ö·× × ××¢× ×¢× ××¢×××¢× ××.
×€Ö¿×ַך ××¢×עך סעך××××¡× ×ך×Ö·× ×¡×ַק×××Öž×, ×עך ק×Öž×֞ך××× ×Ö·××֞ך ×××©×¢× ×¢×š×××¥ ×Ö· ×××עס××Ö·××€ÖŒ: ××¢×עך ס×Ö·×ס×ַק×××Ö·× × ×ך×Ö·× ×¡×ַק×××Öž× ××× ×ךעסעך ××× ×× ×€×š×עך××קע ×ך×Ö·× ×¡×ַק×××Öž×. ××× × Cassandra ס ק×Öž× ×€×××§× ××Ö·×××Öž××¢ ס×ס××¢× ××× ×××××š× ××××£ ×××עס××Ö·×׀֌ס (×€×× ×Š×××× ×§×Ö·× ×€××ק××× × ×š×¢×§×֞ך×ס, ×עך ×××× ×¢×š ××× ×× ×ע׊××¢ ×××עס××Ö·××€ÖŒ ××× ×עךע×× × ××× ×§×š×Ö·× ×), ×עך ק×Öž× ×€×××§× ×××¢× ×©××¢× ××ק ×××× ×š×××Ö·×××× ××× ××××××¢ ×€×× ââ×× ×¡×Ö·×ס×ַק×××Ö·× × ×ך×Ö·× ×¡×ַק×××Öž×. ×××× ××ך ×××€ÖŒ××Ö·××¢× ×Ö·×
××ַקס
×Š× ×¢× ×©×ך ××€××¢××× ×עך×ק×××, ××ך ××ַש××Öž×¡× ×Š× × ××Š× ×× ×¡×××€ÖŒ××Ö·×¡× ×××€Ö¿× - ׀֌עס×××ס××ש ××ַקס ×××××š× ××××£ ×× ×¢×š×©××ק ש×××¡× ×€×× ×× ×š×¢×§×֞ך×. ××× ×× ×עךע ××עך×עך, ××× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž×, ×Ö· ךעק×Öž×š× ×××× ×¢×š×©×עך ×××× ×€×ךש׀×ך×, × ×֞ך ××¢××Öž×× ××××¢× ×¢×, ××Ö·××Ö·×€××× ××× ×עך×××¢×××¢×. ××××× × ×Öž× ×Ö· ×׊××× ××עך××¢×× ×§×¢× ×¢× ×××× ×Ö·× ××Ö·×§× ×Ö· ךעק×Öž×š× ×Ö·××× ×Ö·× ×§×Ö·××€ÖŒ×××× × ×ך×Ö·× ××ַקש×Ö·× × ×§×¢× ×¢× × ××Š× ×¢×¡.
×××€ÖŒ××Ö·××¢× ×× × ×Ö·××Ö· ××ַק×× × ××× ×€ÖŒ×©×× ××× ×Ö· × ××-×€×ס×ך××××××¢ ס××××××¢. ××× ×Ö· ×€×× ×× ×עך××¢××××× ×¡×ס××¢×, עס ××¢× ×¢× ×Š×××× ××××€ÖŒ× ×֞׀֌׊×עס: ×Öž×עך ×× ×¡×ך×××¢× × ×€×× ×× ×עך××¢××××× ××ַק×× × ××××£ ××¢× ×§× ×××, ×Öž×עך ×€×ַךש׀֌ך×××× ×ך×Ö·× ××ַקש×Ö·× × ×Ö·××× ×Ö·× ×ך×Ö·× ××ַקש×Ö·× × ××× ×× ××¢×××¢ ךעק×Öž×š× ××¢× ×¢× ×©××¢× ××ק סעך××××××× ×××š× ×עך ××¢×××קעך ק×Öž×֞ך××× ×Ö·××֞ך.
××× × ××× ××× ××עך ×€×Ö·× ×× ××Ö·×× ××¢× ×¢× ×©××× ×€×× ×× ×עך××¢××××× ×Š××××©× ×ך×׀֌עס ×€×× ××××¢ ×ך×Ö·× ××ַקש×Ö·× × ××× ×¡×§×, עס ××× ××ַש××Öž×¡× ×Š× ××ַש××××¢× ××××¢ ×ך×Ö·× ×¡×ַק×××Öž× ×ך×׀֌עס ×Š× ×§×Öž×֞ך××× ×Ö·××֞ךס: ×××× ×§×Öž×֞ך××× ×Ö·××֞ך ׀֌עך׀×֞ך×× ×Ö·××¢ ×ך×Ö·× ××ַקש×Ö·× × ××× ××Öž×§×¢× ×¡ ×€×× 0 ×Š× 9, ×× ×š××¢ - ××× ××Öž×§×¢× ×¡ ×€×× 10 ×Š× 19, ××× ×××× ×××××עך. ××× ×Ö· ךע×××××Ö·×, ××¢×עך ×€×× ×× ×§×Öž×֞ך××× ×Ö·××֞ך ×× ×¡××Ö·× ×¡×× ×××¢×š× ×עך ××¢× ×€×× ×× ×ך×Ö·× ×¡×ַק×××Öž× ×ך×׀֌ע.
××¢×š× ×Öž× ××ַקס ×§×¢× ×¢× ×××× ×××€ÖŒ××Ö·××¢× ×Ö·× ××× ×× ×€×Öž×š×¢× ×€×× ×Ö· ××Ö·× ×Ö·× ××ַש××Ö·×€ÖŒ ××× ×עך ××֌ך×× ×€×× ×× ×§×Öž×֞ך××× ×Ö·××֞ך.
ק×Öž×֞ך××× ×Ö·××֞ך ×€××××עך×
××× × ×××× ×§×Öž×֞ך××× ×Ö·××֞ך ×××סש××ס××¢× ×¡×¢×š××עס ×Ö· ×ך×׀֌ע ×€×× ââ×ך×Ö·× ××ַקש×Ö·× ×, עס ××× ×××עך ××××××ק ×Š× ×עש×××× × ××ַש×××¡× ×× ×€×Ö·×§× ×€×× ×××Ö·× ××ך××€×Ö·× ×Ö·××× ×Ö·× ×× ×š××¢ ׀֌ך×××× ×Š× ××ס׀××š× ×× ×ך×Ö·× ×¡×ַק×××Öž× ×××¢× ×××× ×Š×××. ×Š× ××Ö·×× ××¢× ×©× ×¢× ××× ×€×ַך××Öž×××¢×, ××ך ××¢××××× × ×Ö· ××֞ך ק×Öž× × ×¢×§××¢× ×§×××֞ך×× ××¢×ַך××¢×Ö·× ×€ÖŒ×š×Öž××֞ק×Öž×:
××¢×עך ××Ö·×× ×Š×¢× ×עך ××֞סץ ××€ÖŒ××ת ׊×××× ×§×Öž×֞ך××× ×Ö·××֞ך × ×Öž×××. ׀֌עך××Öž××ש, ש××§× ××¢×עך ק×Öž×֞ך××× ×Ö·××֞ך ×Ö· ××ַךץ-ק××Ö·×€ÖŒ ×Öž× ××Öž× ×Š× ×× ×× ×עךע ק×Öž×֞ך××× ×Ö·××֞ךס ××× ×× ×€×֞ך×× ××× ×××¢×× ×××Ö·× ×€×Ö·× ×קש×Ö·× ×× ×, ××× ×××× ×××֞ס ××ַךץ ק××Ö·×€ÖŒ ×ַך××ק××¢× ×¢×¡ ××ק×××¢× ×€×× ×××֞ס ק×Öž×֞ך××× ×Ö·××֞ךס ××× ×× ×§× ××× ×ע׊××¢ ××Öž×.
××ק×××¢× ×¢× ××××¢ ××× ×€×ך××׊××¢ ×€×× ââ×× ×עךע ××ס × ×××× ×€×× ×××עך ××ךץ-ק×××€ ×עסע××שעס, ××ש×××¡× ××¢×עך ק××ך××× ×Ö·××֞ך ×€×ך ××× ×××¢×××¢ ×§× ××× × ×Öž××× ×€×× ×§×Š××Öž× ××š× ××× ×××¢×××¢ × ×ש×, ×××××× ××××× ×§×××֞ך×× ×€ÖŒ×š×× ×Š××€ÖŒ: ×××× × ×Öž××¢ X ××× ××ק×××¢× ××× ×€×ך××׊××¢ ×€×× ââ×× ×עך×××× × ×Öž××× ××× ××¢× ×§× ××× ×××¢×× ××¢× × ×֞ך××Ö·××. ק×Ö·××Öž××¢ ×€×× ââ×ַך××ק××¢× ×€×× × ×Öž××¢ ×, ××¢××Öž×× Y ×ַך××¢×. ××× ×€×ַךקעך×, ××× ××Ö·×× ××× ×× ×עך×××× ××¢×××¢× ×€×¢×× ××ק ×Öž× ××Öž×× ×€×× × ×Öž××¢ ×, ××¢××Öž×× × ××× ××€××¢××××. עס ××× ×ש×ק×Ö·×××¢ ×Ö·× ×××× ×× ×§×××֞ך×× ×× ×€×֞ך×× × ×Öž××¢ X ×Ö·× ×¢×¡ ××× × ×× ×עך ך×ס××××× × ×ַך××ק××¢× ×€×× ×××, ××¢××Öž×× × ×Öž××¢ X ××× ×××¢× ××Ö·×ך×Ö·××× ××× ×€Ö¿×ַך ××ך××€×Ö·×.
××¢×ַך×××× ×ַך××ק××¢× ××¢× ×¢× ×עש××§× ××× ×××× ×Öž×€×ק××Ö·×, ×××¢×× 20 ××× ×€ÖŒ×¢×š סעק×× ××¢, ××× ×Ö· ׊××× ×€×× 50 ×××. ××× Java, עס ××× ×©××עך ×Š× ××ַך×Ö·× ×××š× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×¢× ×׀עך ×× 50 ××× ×š×¢×× ×Š× ×עך ×€×ַך××××Ö·×××¢× ××¢× × ×€×× ×€ÖŒ×Öž××Ö·× ××¢×€Ö¿××š× ×××š× ×× ×××¡× ×§×Ö·×עק×עך. ××ך ××¢× ×¢× ×××××ת ×Š× ×עך×ך×××× ××¢× ×¢× ×׀עך ׊××× ××× ×× G1 ×××¡× ×§×Ö·×עק×עך, ×××֞ס ×Ö·××Ö·×× ××× ×× ×Š× ×¡×€ÖŒ×¢×Š××€×׊××š× ×Ö· ׊×× ×€Ö¿×ַך ×× ××¢×××עך ×€×× GC ×€ÖŒ×Öž××Ö·×. ×Öž×עך, ×××, ××Ö·× ×¥ ך×ַךע××, ×× ×§×Ö·×עק×עך ×€ÖŒ×Öž××Ö·× ×קס×× 50 ×××, ×××֞ס ×§×¢× ×¢× ×€××š× ×Š× ×Ö· ×€×Ö·×ש ש××× ×××עקש×Ö·×. ×Š× ×€×ַך×××Ö·×× ××¢× ×€×× ××¢×©×¢×¢× ×ש, ×עך ק×Öž×֞ך××× ×Ö·××֞ך ×§×¢× × ××©× ××ַך××× ×Ö· ××ך××€×Ö·× ×€×× ×Ö· ××××Ö·× × ×Öž××¢ ×××¢× ×עך עךש×עך ××ַך×××× ×Öž× ××Öž× ×€×× ×¢×¡ ×€×ַךש×××× ××, × ×֞ך ×××× ×¢×××¢××¢ ××¢× ×¢× ×€×ַךש×××× ×× ××× ×Ö· ך×××¢×š× ××ס.
×Öž×עך עס ××× × ××©× ××¢× ×× ×Š× ×עש×××× × ×€Ö¿×ַךש×××× ×××֞ס × ×Öž××¢ ××× ×€×ךש×××€× ×€×Ö·× ×קש×Ö·× ×× ×. ××ך ××Ö·×š×€Ö¿× ×Š× ××Öž× ×¢×€ÖŒ×¢×¡ ×××¢×× ××¢×.
ךע×עך×××ַ׊××¢
×עך ק××ַס×ש ס××¢××¢ ×× ×××Ö·××××, ××× ×× ××¢×©×¢×¢× ×ש ×€×× ×Ö· ××¢× ××ך××€×Ö·×, ס××ַך××× × ×Ö· × ××Ö· ×××Ö·×× × ××Š× ×××× ×¢×š ×€××
××× ×¡ ××Öž×× ××ך ××××× ×Š× ××ס׀××š× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ××× ×ך×׀֌ע 50. ××× ×¡ ××ַש××××¢× ××× ×©×××Ö·×× ×× ×€×ַך×××Ö·× ×¡××¢××¢, ×××֞ס ×××, ×××֞ס × ×Öž××× ×××¢× ××ס׀××š× ×ך×Ö·× ××ַקש×Ö·× × ××× ×ך×׀֌ע 50 ××× ×× ××¢×©×¢×¢× ×ש ×€×× ×Ö· ××ך××€×Ö·× ×€×× ×× ××××€ÖŒ× ×§×Öž×֞ך××× ×Ö·××֞ך. ××× ××עך ׊×× ××× ×Š× ×××Ö·× ×¢× ×¡×ס××¢× ×€×Ö·× ×קש×Ö·× ×Ö·×××× ××× ×× ××¢×©×¢×¢× ×ש ×€×× ×Ö· ××Ö·×× ×Š×¢× ×עך ××ך××€×Ö·×. ××Öž××ך ××ַש×××¡× ×Ö·× ×עך עךש×עך ךע×עך×× ×××¢× ×××× ×Ö· × ×Öž××¢ ×€×× ââ×× ×× ×עך ××Ö·×× ×Š×¢× ×עך, ××× ×× ×š××¢ ךע×עך×× ×××¢× ×××× ×Ö· × ×Öž××¢ ×€×× ââ×Ö· ×ך××. ×עך ס××¢××¢ ××× ×××ס×עק×××× ×Ö·××Öž× ××× ××× × ××©× ××××©× ××× ×× ××Öž×€ÖŒ×Öž××Öž×× ×€×× ×× ×§× ××× ×¢× ×עך×× ××¢×, ××֞ס ××× ××× × ××Ö· × ×Öž××× ×ַך××Ö·× ×¢×¡ (×××֞ס ××Ö·×€ÖŒ×Ö·× × ×××עך ך×ַךע××). ×עך ׀֌ך×֞׊ע××ך ×€Ö¿×ַך ס×Ö·×עק××× × ×Ö· × ××Ö· ×ַק×××× ××¢× ×××× ×עך ×Ö·×× ×××× ×¢×š ×€×××× ×××¢× ×©××¢× ××ק ×××× ××× ××××: ×עך עךש×עך ךע×עך×× ×××¢× ×××¢×š× ×עך ×ַק×××× ××¢×, ××× ×××× ×¢×¡ ××× ××××€××¢××¢×š× ×€×Ö·× ×קש×Ö·× ×× ×, ×× ×š××¢ ךע×עך×× ×××¢× ×××¢×š× ×עך ×ַק×××× ××¢×.
××¢× ×¡××¢××¢ ××× ×עך ×€×ַך××Öž×××¢× ××× ×× ×× ×××עךס×Ö·× ×Ö·××עך×××Ö·×, ××××Ö·× ×Š× ×ַק××Ö·××××× ×Ö· × ××Ö· ××¢× ×¢×¡ ××× ××¢× ×× ×Š× ××ַש×××¡× ×× ××ך××€×Ö·× ×€×× ×× ×Ö·××.
×Öž×עך ××× ×××¢× ×§××××Ö·× ×¥ ×€Ö¿×ַךש×××× ×××֞ס ××¢× ××× ×ך××¢×× ××׊×? עס ××× ×××××¢×××¢× ×Š× ×©××§× ××× ×€Ö¿×֞ך××ַ׊××¢ ×Š× ××××× ×עך ×€×× ×§××××Ö·× ×¥ ××× 50 ×××. × ×¡××××ַ׊××¢ ××× ××¢×××¢× ×××¢× ×Ö· ק×××¢× × ×¡×¢× ×× ×Ö· ××§×©× ×Š× ×¢×€Ö¿×¢× ×¢× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž×, × ×× × ×Öž× ××¢×××××¡× ×Ö·× ×עך ××¢× ××× × ×× ×עך ×€×Ö·× ×קש×Ö·× ×× ×, ××× ×× ××§×©× ×××¢× ×Š××× ×××ס. ×Š× ×€×ַך×××Ö·×× ××¢× ×€×× ××¢×©×¢×¢× ×ש, ק××××Ö·× ×¥ ס׀֌עק×××Ö·×××××¢×× ×©××§× ×Ö· ××§×©× ×Š× ×¢×€×¢× ×¢× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ×Š× ×× ×ך×׀֌ע ××¢× ××× ×××××¢ ×€×× ââââ×××Ö·× ×š××עך××× ××× ×Ö·××Öž×, ×Öž×עך ××××× ×עך ×××× ×¢×š ×××֞ס ××× ×עך ×ַק×××× ××¢× ××× ××¢× ××Öž××¢× × ×××¢× ×š×ס׀֌×Ö·× × ×Š× ××¢× ×קש×. ×עך ק×××¢× × ×××¢× ××Ö·×× ×Ö·××¢ ס×Ö·×ס×ַק×××Ö·× × ×§×Öž××× ×ק×ַ׊××¢ ××× ×× ×ך×Ö·× ×¡×ַק×××Öž× ××××× ××× ×× ×ַק×××× ××¢×.
××ַקק××€ÖŒ ×××š× ×©××¢×× ××ק×××¢× ×š×ק××עס ×€Ö¿×ַך ×ך×Ö·× ××ַקש×Ö·× × ×××֞ס ××¢× ×¢× × ××©× ×××עךעך ××× ×× ×š×× ×€×× ×Ö·× ××Öž×š× ×ך×Ö·× ××ַקש×Ö·× ×, ××× ××× ××¢× ×¢× ×¡××Öž×š× ×€Ö¿×ַך ×¢×××¢××¢ ××Öž×. ×××× ×עך ×ַק×××× ××¢× ××עס, ×עך × ××Ö· ××¢× ×€ÖŒ×š×ַסעס×Ö·× ×š×ק××עס ×Š× ×¢×€×¢× ×¢× ×ך×Ö·× ××ַקש×Ö·× × ×€×× ×××× ×š×× ××× ×š×ס׀֌×Ö·× ×× ×Š× ××¢× ×§×××¢× ×. ×××× ×עך ק×××¢× × ××× ×©××× ××¢×¢×€× × ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ××× ×× ×Ö·×× ××¢×, ×× ×š××¢ ×¢× ×׀עך ××× ×××× ×֞ך××š× (×××, ××Öž×, ×Ö·××Ö· ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ×××¢× × ××©× ×€×Ö·×š×¢× ×××§× ××× ×××¢× ×××× ×š××€ÖŒ×××× ×××š× ×עך ק×××¢× ×).
××× ×× ×ך×Ö·× ×¡×ַק×××Öž× ×ַך××¢×
××××ך ×××× ×× × ×§×××¢× × ××× ×עש××§× × ×€×ך××× × ×Š×× ×§××ך××× ×Ö·××֞ך ×Š× ×¢×€×¢× ×¢× × ×ך×× ××ק׊××¢ ×€×ך ××× ××× ××× ×¢× ×××× ××× ××× ××× ××× ×¢×š×©××ק ש××ס×. ×עך ק×Öž×֞ך××× ×Ö·××֞ך ××ַקס ××¢× ×¢× ×××× ××× ×©××¢×× ×¢×¡ ××× ×× ×©××֞ס ××ש ××× ××֌ך××. ×××× × ××××ק, ×עך ק×Öž×֞ך××× ×Ö·××֞ך ××××¢× × ××¢× ×¢× ×××× ×€×× ×¡××֞ך×××ש ××× ×¡××Öž×š× ×× ×š×××Ö·×××× × ××Ö·×× ××× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ×©××Ö·× ××× ×× ×§×Öž×֞ך××× ×Ö·××֞ך ס ××֌ך××.
×××¢× ×Ö· ק×××¢× × ×××× ×Š× ××××©× ××Ö·×× ××× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž×, עס ×¡×¢× ×× ×Ö· ××§×©× ×Š× ×× ×§×Öž×֞ך××× ×Ö·××֞ך ×Š× ××Öž×××€×׊××š× ×× ×¢× ××××, ××× ×עך ק×Öž×֞ך××× ×Ö·××֞ך ש××¢×× ×× × ××Ö·×¢ ××Ö·×× ××× ×× ×ך×Ö·× ×¡×ַק×××Öž× ×¡××Ö·××ס ××ש ××× ××֌ך××. ××֞ס ק×Ö·××€ÖŒ×××¥ ×× ×š×¢×§×֞ך××× × - ק××× ×š×¢×§×֞ך××× × ××× ××¢×××× ×Š× ×× ×¡××֞ך×××ש.
×××¢× ×Ö· ק×××¢× × ×š×ק××עס ×××× ×××××¢× ×¢ ××¢×××× ××Ö·×× ××× ×Ö· ×××× ×€×× ×Ö·× ×ַק×××× ×ך×Ö·× ×¡×ַק×××Öž×, ×עך ק×Öž×֞ך××× ×Ö·××֞ך ×Ö·×§×¢×š× ××× ××××:
- ×××× ×× ×©××Ö·× ××× ×©××× ××× ×× ×ך×Ö·× ×¡×ַק×××Öž×, ×× ××Ö·×× ××¢× ×¢× ××¢× ×××¢× ×€×× ××֌ך××;
- ×××× ×¢×¡ ××× ×§××× ×©××Ö·× ××× ××֌ך××, ×× ×€×¢×× ××ק ××Ö·×× ××¢× ×¢× ××××¢× ×¢× ×€Ö¿×× ×× ×¡××֞ך×××ש × ×Öž×××, ק×Ö·××××× × ××× ×× ×©××× ××× ××֌ך××, ××× ×עך ךע×××××Ö·× ××× ××¢××¢×× ×Š× ×עך ק×××¢× ×.
××××, ×עך ק×××¢× × ×§×¢× ×¢× ××××¢× ×¢× ×××× ×××××¢× ×¢ ×¢× ×עך×× ××¢×, ×Öž×עך ×× ×עךע ק××××Ö·× ×¥ ××Öž× × ×× ××¢× ×× ×¢× ×עך×× ××¢×, ××××Ö·× ××× ××¢× ×¢× ×¡××Öž×š× ××××× ××× ×עך ××֌ך×× ×€×× ×× ×§×Öž×֞ך××× ×Ö·××֞ך, ××× ××¢× ×¢× × ××©× × ×Öž× ××× ×× ×§×ַסס×Ö·× ×ך×Ö· × ×Öž×××.
×××¢× ×עך ק×××¢× × ×¡×¢× ×× ×§×Ö·×××, ×× ×©××Ö·× ×××֞ס ××× ××¢×××¢× ××× ×× ××× ×¡× ×¡ ××֌ך×× ××× ×עך×××¢×××¢× ×××š× ×× ×§×Öž×֞ך××× ×Ö·××֞ך ××× ×Ö· ××Öž×× ×€ÖŒ×¢×§×, ××× ××× ×עש××§× ××× ×Ö· ××Öž×× ×€ÖŒ×¢×§× ×Š× Cassandra ס××֞ך×××ש. ×× ×¡××Öž×š× ××Öž× ×Ö·××¥ × ××××ק ×Š× ×¢× ×©×ך ×Ö·× ××¢× ×€ÖŒ×¢×§× ××× ×Ö·××Öž××שע (××֞ך) ××¢×××¢× ××, ××× ×Š×ך×קק×××¢× ×Ö· ×¢× ×׀עך ×Š× ×× ×§×Öž×֞ך××× ×Ö·××֞ך, ×××֞ס ך×××ס×× ×× ××ַקס ××× ×§×Ö·× ×€×¢×š×× ×× ×׊××× ×€×× ×× ×ך×Ö·× ×¡×ַק×××Öž× ×Š× ××¢× ×§×××¢× ×.
××× ×Š× ×Š×ך×קקך×××, ×עך ק×Öž×֞ך××× ×Ö·××֞ך × ×֞ך ××ַךף ×Š× ××ַ׀ך××Ö·×¢× ×× ××ק×Öž×š× ×€×Ö·×š× ×××¢× ×××š× ×× ×ך×Ö·× ×¡×ַק×××Öž× ×©××Ö·×.
××× ×Ö· ךע×××××Ö·× ×€×× ×× ××׀֌ך×××××Ö·× ×¥ ×××××, ××ך ×××€ÖŒ××Ö·××¢× ×Ö·× ×× ×ַס×× ×€ÖŒ×š×× ×¡×Ö·×€ÖŒ×Ö·××:
- ×Ö·××Öž××ס×××. ××֞ס ××× ×Ö· ××ַך×Ö·× ×××š× ×Ö·× ×§××× ×ך×Ö·× ×¡×ַק×××Öž× ×××¢× ×××× ×××× ×š×¢×§×֞ך××¢× ××× ×× ×¡×ס××¢× ×Öž×עך ×Ö·××¢ ×€×× ââ×××Ö·× ×¡×Ö·×-×֞׀֌עך×Ö·×××Öž× ×¡ ×××¢× ×××× ××¢×¢× ××ק×, ×Öž×עך ××Öž×š× ×× ×××¢× ×××× ××¢×¢× ××ק×. ××ך ×Ö·×××ך ×Š× ××¢× ×€ÖŒ×š×× ×Š××€ÖŒ ×××š× ××Öž×× ×€ÖŒ×¢×§× ××× Cassandra.
- ק×Öž× ×¡×ס××¢× ×¡×. ××¢×עך ×עך×Öž×× ×ך×Ö·× ×¡×ַק×××Öž×, ×××š× ××¢×€Ö¿×× ×׊××¢, ךעק×֞ך×××š× ââ××××× ×××××ק ךע×××××Ö·××. ××××, × ×Öž× ×¢×€× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ××× ××ך××€××š× ×××× ×€×× ×× ×ַ׀֌עך××ש×Ö·× ×, עס ××× ××סק×Ö·×××¢×š× ×Ö·× ×עך ךע×××××Ö·× ××× ×€×ַךקך××€ÖŒ××, ×Ö· ך×Öž××××ַק ××× ××ך××עק×Öž××.
- ××××××׊××¢. ×××¢× ×Ö· ×ך×Ö·× ×¡×ַק×××Öž× ××× ×¢×§×¡×ַק××××Ö·×, ק×Ö·× ×§×¢×š×Ö·× × ×ך×Ö·× ××ַקש×Ö·× × ××Öž× × ××©× ××××š×§× ×××Ö·× ×Ö·××ק×Ö·×. ק×Ö·××€ÖŒ×××× × ×ך×Ö·× ××ַקש×Ö·× × ××¢× ×¢× ××€××¢××× ××¢×š× ××× ×€ÖŒ×¢×¡×××ס××ש ××ַקס ××××£ ×× ×§×Öž×֞ך××× ×Ö·××֞ך. ×€Ö¿×ַך ××××¢× ×¢× ×ַך××ס ×Ö· ×ך×Ö·× ×¡×ַק×××Öž×, ×× ××€××¢××× ×עך×ק××× ×€ÖŒ×š×× ×Š××€ÖŒ ××× ××××¢×š×§× ××××£ ×× ××××¢× ×¢× ×§×Ö·××××Ö·× ××ך××.
- ׀עס×ק××Ö·×. ךע××ַך××עסס ×€×× ×€ÖŒ×š×Öž×××¢×ס ××× × ××עך×קעך ××¢×××¢×ס - ס×ס××¢× ×××ַק×Ö·××, ××Ö·×× ×××Ö·×š× ××ך××€×Ö·× - ×¢× ×עך×× ××¢× ××¢×××× ×××š× ×Ö· ×׊××× ××¢×¢× ×××§× ×ך×Ö·× ×¡×ַק×××Öž× ××Öž× ××××Ö·×× ××€××¢××× ×××¢× ×ַ׀֌עך××ש×Ö·× × × ×¢××¢× ××× ××××עך.
××××¢× ×¢× ×××š× ×× ×עקס××
××Öž××ך × ×¢××¢× ×Ö· ׀֌ש××× ××ש:
CREATE TABLE photos (
id bigint primary key,
owner bigint,
modified timestamp,
âŠ)
עס ××× ×Ö· ש××Ö·× (עךש××ק ש××ס×), ××Ö·××׊עך ××× ××Öž×××€×ק×Ö·×××Öž× ××Ö·××¢. ××ך ××Ö·×š×€Ö¿× ×Š× ××Ö·×× ×Ö· ×××עך ׀֌ש×× ××§×©× - סע×עק×××š× ××Ö·×× ××××£ ×× ××Ö·××׊עך ××× ×× ×¢× ×עך×× × ××Öž× "×€Ö¿×ַך ×× ×ע׊××¢ ××Öž×".
SELECT *
WHERE owner=?
AND modified>?
××× ×¡×ך ×Ö·× ×Ö·××Ö· ×Ö· ×Öž× ×€Ö¿×š×¢× ×Š× ×××× ×€ÖŒ×š×Ö·×¡×¢×¡× ×עש×××× ×, ××× ×Ö· ק××ַס×ש SQL DBMS ××ך ××Ö·×š×€Ö¿× ×Š× ××××¢× ×Ö·× ××× ×עקס ×××š× ×©×€×××× (××Ö·××׊עך, ××Ö·××Ö·×€×××). ××ך ×§×¢× ×¢× ××Öž× ××֞ס ××Ö·× ×¥ ×××××, ××××Ö·× ××ך ×××Š× ××Öž×× ×××עך ×עך×Ö·× ×××!
×× ×עקס×× ××× C * ××××
עס ××× ×Ö· ×ק×ך ××ש ××× ×€×Öž×××Ö·×ך×ַ׀ס ××× ×××֞ס ×× ×š×¢×§×Öž×š× ×©××Ö·× ××× ×× ×¢×š×©××ק ש××ס×.
×€Ö¿×ַך ×Ö·× ××× ×עקס, C * One קך××××¥ ×Ö· × ××Ö·×¢ ××ש ×××֞ס ××× ×Ö· ק×Öž×€ÖŒ××¢ ×€×× ââââ×עך ×֞ך×××× ×¢×. ×עך ש×××¡× ××× ×× ××¢×××¢ ××× ×עך ××× ×עקס ×××ס×ך×ק, ××× ×¢×¡ ×××× ×××× ×× ×¢×š×©××ק ש×××¡× ×€×× ×× ×š×¢×§×Öž×š× ×€×× ×× ×ק×ך ××ש:
×××Š× ×× ×Öž× ×€Ö¿×š×¢× ×€Ö¿×ַך "××Ö·××׊עך ×€Ö¿×ַך ×× ×ע׊××¢ ××Öž×" ×§×¢× ×¢× ×××× ×š×ך××× ××× ×Ö· ×××סק×××Ö·×× ×€×× ×× ×× ×עך ××ש:
SELECT * FROM i1_test
WHERE owner=?
AND modified>?
×× ×§×Öž× ×¡×ס××¢× ×¡× ×€×× ×× ××Ö·×× ××× ×× ×ק×ך ××ש ×€×Öž××֞ס ××× ×× ××× ×עקס ××ש i1 ××× ×××××Öž××Ö·××ש ×××× ×××× × ×××š× ×× ×§×Öž×֞ך××× ×Ö·××֞ך. ××Ö·×××š× ××××£ ×× ××Ö·×× ×¡×שע××Ö· ×Ö·××××, ×××¢× ×Ö· ×¢× ×עך×× × ××× ××ק×××¢×, ×עך ק×Öž×֞ך××× ×Ö·××֞ך ×××©×¢× ×¢×š×××¥ ××× ×¡××Öž×š× ×Ö· ×¢× ×עך×× × × ×× ××××× ××× ×× ××××€ÖŒ× ××ש, ×Öž×עך ×××× ××× ×§××€×עס. ק××× × ×Öž× ×ַקש×Ö·× × ××¢× ×¢× ××ך××עק×Öž×× ××××£ ×× ××× ×עקס ××ש, ××Öž×ס ××¢× ×¢× × ××©× ××××¢× ×¢× ××× ×§××× ××ַקס ××¢× ×¢× ××¢× ×׊×. ×Ö·× ×××, ×Ö·××× × ×× ×עקס×× ×§×Ö·× ×¡××× ×ÖŒ××¢× ×§××× ×š×¢×¡××š×¡× ××× ××× ×××¢× ×§××× ×××ךק×× × ××××£ ×× ×××ק××Ö·× ×€×× ×Ö·×€ÖŒ××××× × ××Öž×××€×ק×Ö·×××Öž× ×¡.
××× ACID, ××ך ××¢× ×¢× ×××××ת ×Š× ×× ×¡×ך×××¢× × ×¡×§×-××× ×× ×עקס××. ××× ××¢× ×¢× ×§×Öž× ×¡×ס××¢× ×, סק×Ö·××Ö·×××¢, ×©× ×¢×, ק×Ö·××€ÖŒ×Öž×××Ö·××Ö·× ××× ××¢×××× ××× ×× CQL ×Öž× ×€Ö¿×š×¢× ×©×€ÖŒ×š×Ö·×. ק××× ×¢× ×עך×× ××¢× ×Š× ×× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×§×Öž× ××¢× ×¢× ×€×ך××× ×× ×Š× ×©×××Š× ×× ×עקס××. ×Ö·××¥ ××× ××× ×€ÖŒ×©×× ××× ××× SQL. ××× ×š××Ö¿ ×××€ÖŒ×֞ך××Ö·× ×××, ×× ×עקס×× ××Öž× × ×× ××××š×§× ×× ××ך××€×ך×× × ×××ק××Ö·× ×€×× ××Öž×××€×ק×Ö·×××Öž× ×¡ ×Š× ×עך ×֞ך×××× ×¢× ×ך×Ö·× ×¡×ַק×××Öž× ××ש.
×××ס ××× ×עשע×
××ך ××¢×××¢××Öž×€ÖŒ×¢× C * One ××× ×ך×× ××֞ך ׊×ך×ק ××× ××Öž× ××©× ×¢×¡ ××× ××¢×©×¢×€× ×֞׀֌עך×ַ׊××¢.
×××֞ס ××Öž×× ××ך ××ַק×××¢× ××× ×× ×¡××£? ××Öž××ך ×֞׀֌ש×Ö·×Š× ××¢× ××× ××¢× ×××ש׀֌×× ×€×× ×× ×€×Öž××Öž ׀֌ך×ַסעס×× × ××× ×¡××֞ך×××ש ס×Ö·×ס×ס××Ö·×, ×××× ×¢×š ×€×× ×× ××¢×š×¡× ××××××ק ×××׀֌ס ×€×× ××Ö·×× ××× ×Ö· ××¢××¢×ש×Ö·×€×××¢× × ×¢×¥. ××ך ךע×× × ××©× ×××¢×× ×× ×§×¢×š×€ÖŒ×¢×š ×€×× ×× ×€×Öž××Öž×ך×Ö·×€××¢ ×Ö·××××, × ×֞ך ×××¢×× ×Ö·××¢ ××× ×× ×€×× ××¢××Ö· ××× ×€Ö¿×֞ך××ַ׊××¢. ×××Š× Odnoklassniki ××× ×××¢×× 20 ×××××Öž× ×Ö·××Ö· ךעק×֞ך×ס, ×× ×¡×ס××¢× ×€ÖŒ×š×ַסעס×Ö·× 80 ××××× × ××××¢× ×¢× ×š×ק××עס ׀֌עך סעק×× ××¢, ×ַך×××£ ×Š× 8 ××××× × ×ַס×× ×ך×Ö·× ××ַקש×Ö·× × ×€ÖŒ×¢×š סעק×× ××¢ ×€Ö¿×ַך××× ×× ××× ××Ö·×× ××Öž×××€×ק×Ö·×××Öž×.
×××¢× ××ך ××¢××××× × SQL ××× ×š×¢×€ÖŒ××ַק××ש×Ö·× ×€×ַק××֞ך = 1 (×Öž×עך ××× RAID 10), ×× ×€×Öž××Öž ××¢××Ö·-××× ×€Ö¿×֞ך××ַ׊××¢ ××× ××¢×××¢× ×¡××Öž×š× ××××£ ×Ö· ××¢××¡× ×× ×××Š× ×§× ××× ×€×× 32 ××ש×× ×¢× ××× Microsoft SQL Server (×€ÖŒ××ס 11 ××ַק×ַ׀֌ס). 10 סעך××עךס ××¢× ×¢× ×××× ×Ö·××ַק××××× ×€Ö¿×ַך ס××֞ך×× × ××ַק×ַ׀֌ס. × ××Ö·× ×¥ ×€×× 50 ×××ַעך ק×ַךס. ××× ×עך ××¢×××קעך ׊×××, ×× ×¡×ס××¢× ×ַ׀֌עך××××Ö·× ××× ×š××××Ö·× ××ַסע, ×Öž× ×š×¢×עך××.
× ×Öž× ×××ך××××× × ×Š× ×× × ××Ö·×¢ ס×ס××¢×, ××ך ××ק×××¢× ×š×¢×€ÖŒ××ַק××ש×Ö·× ×€×ַק××֞ך = 3 - ×Ö· ק×Öž×€ÖŒ××¢ ××× ××¢×עך ××Ö·×× ×Š×¢× ×עך. ×× ×¡×ס××¢× ××ש×××× ×€×× 63 ק×ַסס×Ö·× ×ך×Ö· ס××֞ך×××ש × ×Öž××× ××× 6 ק×Öž×֞ך××× ×Ö·××֞ך ××ש×× ×¢×, ×€Ö¿×ַך ×Ö· ××Ö·× ×¥ ×€×× 69 סעך××עךס. ××עך ×× ××ש×× ×¢× ××¢× ×¢× ×€×× ×ש×׀֌עך, ×××עך ××Ö·× ×¥ ׀֌ך××Ö·× ××× ×××¢×× 30% ×€×× ×× ×§×֞ס ×€×× ×Ö· ×¡×§× ×¡×ס××¢×. ××× ×עך ××¢×××קעך ׊××Ö·×, ×× ××ַסע ××× ××¢××××× ×××Ö· 30%.
××× ×× ×ק××× ×€×× C * One, ×××××Ö·× ×¡× ×××× ××קך×ס×: ××× SQL, ×Ö· שך××Ö·×× ×֞׀֌עך×ַ׊××¢ ××¢× ×××¢× ×××¢×× 4,5 ×××. ××× C * One - ×××¢×× 1,6 ×××. ×× ×ך×Ö·× ×¡×ַק×××Öž× ××¢×××עך ××× ××× ××ך××©× ××××¢× ××××× ×קעך ××× 40 ×××, ×× ××עך××¢×× ××× ××¢×¢× ×××§× ××× 2 ×××, ×× ××××¢× ×¢× ××× ×©×š××Ö·×× ××¢×××עך ××× ××× ××ך××©× ××××¢× 2 ×××. 99 ׀֌ך×Öž×Š×¢× ××× - ××××× 3-3,1 ×××, ×× × ××עך ×€×× ×××××Ö·××¥ ××× ××קך××¡× ××× 100 ××× - ×Ö·××¢ ךע×× ×Š× ×עך ××××××¡×€ÖŒ×š×¢× × ××Š× ×€×× ×¡×€ÖŒ×¢×§×××ַ׊××¢.
××׊×, ך××Ö¿ ×€×× ×× SQL סעך×××ךעך × ×Öž××× ××Öž×× ×©××× ××ק×Ö·××ש×Ö·× × × ××Ö·×¢ ׀֌ך×Öž××ק×× ××¢× ×¢× ××¢×××¢××Öž×€ÖŒ×¢× ××××× ××× C * One. ××ך ׊×××¢×€××¡× C * One ×Š× ×ַך××¢×× ××× ××× ××עך ×××Öž×ק×
×××Š× ××ך ×ַך××¢×× ××××£ ×ך×Ö·× ×¡×€×¢×š×× × ××× ××עך ×× ×עךע ס××֞ך×××ש ×€×ַס×××Ö·××× ×Š× ×× ×××Öž××§× - ×Öž×עך ××֞ס ××× ×Ö· ××֞ך ×Ö·× ×עךש ×עש××××¢.
×ק×ך: www.habr.com