KDB +, ×€×ך××¢ ׀֌ך×Öž××ק×
××× ××¢× ×ַך×××§× ××× ×××¢× ×€ÖŒ×š××××š× ×Š× ××Öž×× ××ך ××× ×Ö·×××¢×××× ×××֞ס KDB + ×××, ×××֞ס ק×××€ÖŒ×Ö·××××Ö·××× ××× ×××××××ש×Ö·× × ×¢×¡ ××× ××× ×××֞ס ×× ××¢× ×¢×€××¥ ××¢× ×¢× ×€Ö¿×ַך ק×Öž××€ÖŒ×Ö·× ×עס ×××֞ס ××××× ×Š× ×€ÖŒ×š×ַסעס×× × ×ך××ס ×Ö·××Ö·×× ×¥ ×€×× ××Ö·××. ××× ×××¢× × ××©× ×ך××× ×××× ××× ×× ××¢×××× ×€×× ×× ×××× ×€×ך×× × ×€×× KDB+ ××עך ×× ××¢×××× ×€×× ××ך Q ׀ך××ך×××× × ×©×€×š×× ×××××¢ ×× ××¢×עס ××¢× ×¢× ×××עך ×ך××× ××× ×€×ך××× × ××××× ×עךע ×ך××ק××¢×. × ×€ÖŒ××Ö·×¥ ×€×× ××× ×€Ö¿×֞ך××ַ׊××¢ ×××¢×× ×× ××¢×עס ×§×¢× ×¢× ×××× ××¢×€Ö¿×× ×¢× ××× code.kx.com, ×ַך××Ö·× ×עךע×× × ×Ö· ××× ××××£ Q - Q For Mortals (××¢× ××× ×§ ××× ××).
×¢×××¢××¢ ×עך××× ×¢×
- ×××-××ק×Öž×š× ××Ö·××Ö·×××ס. × ××Ö·××Ö·×××ס ×××֞ס ס××Öž×š× ××Ö·×× ××× ××ַך×Ö·× ×€Ö¿×ַך ×€×ַס×עך ×ַקסעס. ×× ×Ö·××××Ö·× ××××ש×× ×€×× ×Ö·××Ö· ×Ö· ××Ö·××Ö·×××ס ××¢× ×¢× ×§××֞ך, ×Öž×עך ×× ××ס×Ö·××××Ö·× ××××ש×× ××¢× ×¢× ×× ××¢×××¢×ק××× ×€×× ××Ö·×× ×Öž× ××עך ××× ×× × ××× ×Š× ××Öž×× ×Ö· ×€ÖŒ××Ö·×¥ ×€×× ××֌ך×× ××××£ ×× ×¡×¢×š××עך.
- ×××Ö·× ××Ö·××Ö·×××ס. × ××Ö·××Ö·×××ס ××× ××Ö·×× ××¢× ×¢× ×¡××Öž×š× ×××Ö·× ×××š× ×××Ö·× ××× ××× ×š×¢×§×Öž×š× ×××š× ×š×¢×§×֞ך×. ×עך ××××€ÖŒ× ×××Ö·××¢ ×€×× ââ×Ö·××Ö· ×Ö· ××Ö·××Ö·×××ס ××× ×Ö·× ××Ö·×× ×€×× ×××× ×××Ö·× ××¢× ×¢× ×¡××Öž×š× ×Š×××Ö·××¢× ××××£ ××סק ××× ××× ××֌ך××, ×××֞ס ×××××××ק ס׀֌××× ×× ×ַקסעס ×Š× ×¢×¡. עס ××× × ×× ××Ö·×š×€Ö¿× ×Š× ××ַסע ש׀×××× ×××֞ס ××¢× ×¢× × ××©× ××¢× ××Š× ××× ×× ×Öž× ×€Ö¿×š×¢×. ×עך ××××€ÖŒ× ××ס×Öž×š× ××× ×Ö·× ×¢×¡ ××× ×©××עך ×Š× ××Öž×××€×׊××š× ××× ××ס××¢×§× ×š×¢×§×֞ך×ס.
- ׊××× ×¡×¢×š××¢. ××Ö·××¢ ××× ×Ö· ××Ö·××¢ ×Öž×עך ׊××× ×××Ö·×. ×××€ÖŒ×ק×Ö·×××, ׊××× ×֞ך×עך×× × ××× ××××××ק ×€Ö¿×ַך ×Ö·××Ö· ××Ö·××, ×Ö·××× ××ך ×§×¢× ×¢× ××××× ××ַש×××¡× ×××֞ס ךעק×Öž×š× ×€ÖŒ×š×ס××× ×Öž×עך ×××× × ×Öž× ×× ×§×š×Ö·× ×, ×Öž×עך ×Š× ×Š×××××× ×€×Ö·× ×קש×Ö·× × ×××¢××¢× ×¡ ךע×××××Ö·×× ×Öž×€×¢× ××¢× ××××£ ×× ×¡×ך ×€×× ×× ×š×¢×§×֞ך×ס. ק××ַס×ש ××Ö·××Ö·×××ס×× ××¢× ×¢× ××¢×××× ××××£ ×Ö· ××֞ך ×Ö·× ×עךש ׀֌ך×× ×Š××€ÖŒ - ךע׀֌ך×××¢× ××× × ×Ö· ××Ö·×××× × ×€×× ×š×¢×§×֞ך×ס ××× ×Ö· ××Ö·× ×, ××× ×× ×¡×ך ×€×× ×× ×š×¢×§×֞ך×ס ×××, ××× ×€ÖŒ×š×× ×Š××€ÖŒ, × ××©× ×××€××× ×.
- ××עק××֞ך. ××× ××¢× ×§×Öž× ××¢×§×¡× ×€×× KDB+, ××֞ס ××× ×Ö· ךש××× ×€×× ×¢××¢××¢× ×× ×€×× ×עך ××¢×××קעך ×Ö·××Öž××שע ×××€ÖŒ, ××ש×, × ××עך×. ××× ×× ×עךע ××עך×עך, ×Ö· ק××× ×€×× ×¢××¢××¢× ××. ×ַךך××ַס, × ×× ×¢× ××¢× ×š×©×××ת, ×§×¢× ×¢× ×××× ×¡××Öž×š× ×§×Öž××€ÖŒ×ַק××× ××× ×€ÖŒ×š×Ö·×¡×¢×¡× ××× ××עק××֞ך ׀֌ך×ַסעסעך ××× ×¡×ך×ק׊×עס.
××ס××֞ך×ש ××× ×€Ö¿×֞ך××ַ׊××¢
KX ××× ××¢×ך×× ××¢× ××× 1993 ×××š× Arthur Whitney, ×××¢××עך ××Öž× ×€×š×עך ××¢×ך××¢× ××× Morgan Stanley Bank ××××£ ×עך A+ ש׀֌ך×Ö·×, ×עך ס×ַקסעסעך ×€×× APL - ×Ö· ×××עך ×֞ך×××× ×¢× ××× ×Ö·××Öž× ×€×Öž×קס ש׀֌ך×Ö·× ××× ×× ×€×× ×Ö·× ×Š××¢× ×××¢××. ×€×× ×§×ךס, ××× KX, ×ַך×××ך ×€×ך××××× ××× ×עך ××¢×××קעך ××××¡× ××× ××ש××€× ×× ××עק××֞ך-×€×Ö·× ×קש×Ö·× ×Ö·× ×©×€ÖŒ×š×Ö·× ×§, ×××××× ×××š× ×× ××¢××× ×§×¢× ×€×× ×š×Ö·××ק×Ö·× ××× ×Ö·××Ö·××××Ö·×. ק ××××× ×§××§× ×××ס ××× ×Ö· ׊ע×××©×¢× ×ש ×€×× ×€ÖŒ×× ×§×××ַ׊××¢ ××× ×¡×€ÖŒ×¢×Š××¢××¢ ××ת××ת, ×× ×××Ö·×ש ×€×× ××××× ×עך ××× ×€×Ö·× ×קש×Ö·× × ××¢×€ÖŒ×¢× ×ס ××××£ ××¢× ×§×Öž× ×עקס×, ××× ××¢×עך ×֞׀֌עך×ַ׊××¢ ×ך××× ×€×× ×עך ×××Ö·×ש ××× ××× ×§×Ö·× ×××¢× ×©×Ö·× ×Ö·× ×€ÖŒ×š×Öž×ך×Ö·×××× × ×©×€ÖŒ×š×Ö·××. ךע×× ×Š× ××¢×, ×Ö· K ׀֌ך×Öž×ך×Ö·× × ×¢×× ××× ×××Ö·× ×€ÖŒ××Ö·×¥ - ×¢×××¢××¢ ש×ך×ת ×§×¢× ×¢× ×€×ַך×××Ö·×× ×××¢×עך ×€×× ××¢×§×¡× ××× ×Ö· ××עך××Öž×ס ש׀֌ך×Ö·× ××× Java - ××× ××× ×Ö· ס×׀֌עך-ק×Ö·× ×¡×Ö·× ×ך××××Ö·× ×××€ÖŒ××Ö·××¢× ×××ש×Ö·× ×€×× ×× ×Ö·××עך×××Ö·×.
× ×€Ö¿×× ×§×Š××¢ ××× ×§ ×××֞ס ×××€ÖŒ××Ö·××Ö·× ×¥ ך××Ö¿ ×€×× ×× LL1 ×€ÖŒ×ַךסעך ××¢× ×¢×š×Ö·××֞ך ×××× ×Ö· ××¢××¢×× ×ך×Ö·××Ö·××ק:
1. pp:{q:{(x;p3(),y)};r:$[-11=@x;$x;11=@x;q[`N;$*x];10=abs@@x;q[`N;x]
2. ($)~*x;(`P;p3 x 1);(1=#x)&11=@*x;pp[{(1#x;$[2=#x;;,:]1_x)}@*x]
3. (?)~*x;(`Q;pp[x 1]);(*)~*x;(`M;pp[x 1]);(+)~*x;(`MP;pp[x 1]);(!)~*x;(`Y;p3 x 1)
4. (2=#x)&(@x 1)in 100 101 107 7 -7h;($[(@x 1)in 100 101 107h;`Ff;`Fi];p3 x 1;pp[*x])
5. (|)~*x;`S,(pp'1_x);2=#x;`C,{@[@[x;-1+#x;{x,")"}];0;"(",]}({$[".s.C"~4#x;6_-2_x;x]}'pp'x);'`pp];
6. $[@r;r;($[1<#r;".s.";""],$*r),$[1<#r;"[",(";"/:1_r),"]";""]]}
×ַך×××ך ××××Ö·××× ××¢× ×€×××֞ס×Öž×€××¢ ×€×× ââעקס××š×¢× ×¢×€×¢×§××××ק××Ö·× ××× ×Ö· ××× ×××× ×€×× ×××£ ××××××Ö·× ×¥ ××× KDB+, ×××֞ס ××× ×ך××ס ××× 2003 (××× ×ך×Ö·××× ×¢×¡ ××× ×××Š× ×§××֞ך ××× ×עך ×ך××× ×§ ××× ××¢× × ×Öž××¢× ×§××× ×€××) ××× ××× ××Öž×š× ××©× ×עך ××× ×Ö·× ××עך×ע׊עך ×€×× ×עך ×€×¢×š× ××עךס××¢ ×€×× ââââ×× K. × ×עך ××Ö·× ×׊עך-׀ך××Ö·× ×××¢× ××עךס××¢ ××× ×Š×××¢××¢×× ××××£ ש׀֌××¥ ×€×× K K ×עך××€Ö¿× Q. Q ×××× ×Š×××¢××¢×× ×©×××Š× ×€Ö¿×ַך ×Ö· ס׀֌ע׊××€×ש ×××Ö·××¢×§× ×€×× SQL - QSQL, ××× ×עך ××עך×ע׊עך - ש×××Š× ×€Ö¿×ַך ×××©× ××× ×Ö· ס×ס××¢× ××Ö·×× ×××€ÖŒ, ××ש×ך×× ×€Ö¿×ַך ×ך××¢×× ××× ×××©× ××× ××֌ך×× ××× ××××£ ××סק ×××'.
×Ö·××× ×€Ö¿×× ×Ö· ××Ö·× ×׊עך 'ס ׀֌עךס׀֌עק××××, KDB + ××× ×€×©×× ×Ö· Q ש׀֌ך×Ö·× ××עך×ע׊עך ××× ×©×××Š× ×€Ö¿×ַך ×××©× ××× SQL-××× LINQ-× ××¡× ×××ס×ך××§× ×€Ö¿×× C #. ××֞ס ××× ×× ××¢×š×¡× ××××××ק ××××ק ׊××××©× KDB + ××× ×× ×עךע ××Ö·××Ö·×××ס×× ××× ×××× ××××€ÖŒ× ×§×Ö·×׀֌ע×××××× ×××Ö·××¢, ×××֞ס ××× ×Öž×€× ×Öž×××עך××ק×. ××֞ס ××× × ××©× ×Ö· ××Ö·××Ö·×××ס + ×€×ַךקך××€ÖŒ×× ×Ö·××××××¢×š× ×©×€ÖŒ×š×Ö·×, ×Öž×עך ×Ö· ×€××-×€××¢×××©× ×©××ַךק ׀֌ך×Öž×ך×Ö·×××× × ×©×€ÖŒ×š×Ö·× + ××¢××××-××× ×©×××Š× ×€Ö¿×ַך ×××××Ö·×××ס ×€×Ö·× ×קש×Ö·× ×. ×עך ××ס××× ×קש×Ö·× ×××¢× ×©×€ÖŒ××× ×Ö· ××ַש××××¢× ××ק ך×Öž××¢ ××× ××ס××× × ×Ö·××¢ ×× ××¢× ×¢×€××¥ ×€×× KDB +. ××ש×...
×ך××ס
×××× ××Öž××¢×š× ×¡××Ö·× ××ַך×ס, KDB + ××× ×€×©×× ××קך×֞סק×Öž×€ÖŒ×ק ××× ×ך××ס. עס ××× ××ש ×××× ×¡×Ö·×-××¢××Ö·××××¢ עקסעק×××Ö·×××¢ ×עקע ××× ×××× ×§×××× ××¢×§×¡× ×עקע ××× ×¢×××¢××¢ ס×ס××¢× ×€×Ö·× ×קש×Ö·× ×. ××× ×€×Ö·×§× - ××××× ×קעך ××× ×××× ××¢××××××, ××× ×€Ö¿×ַך ××¢× ×€ÖŒ×š×Öž×ך×Ö·× ×§×Öž××€ÖŒ×Ö·× ×עס ××ַ׊×Öž×× ××¢× ×¡ ×€×× ××××× ×עך ×€×× ××Öž×××ַךס ×Ö· ××֞ך ×€Ö¿×ַך ×××× ×€ÖŒ×š×ַסעסעך ××××£ ×× ×¡×¢×š××עך.
- ×× ×ך××ס ×Ö·××Ö·×× KDB + ×Š× ×€××× ×ך××ס ××××£ ק××× ××Ö·×× ×××Ö·×š× - ×€Ö¿×× ×Ö· Pi ××קך×֞ק×Öž××€ÖŒ××עך ×Š× ×¡×¢×š××עךס ××× ×עך×Ö·×××עס ×€×× ××֌ך××. ××֞ס ×§×¢× × ××©× ××××š×§× ×× ×€×Ö·× ×קש×Ö·× ×Ö·×××× ××× ×§××× ×××¢×; ×עך׊×, Q ס××ַךץ ×××××, ×××֞ס ×Ö·××Ö·×× ×¢×¡ ×Š× ×××× ××¢××××× ×, ׊××××©× ×× ×עךע, ××× ×Ö· סקך××€ÖŒ××× × ×©×€ÖŒ×š×Ö·×.
- ××× ××¢× ×ך××ס, ×× Q ××עך×ע׊עך ×€××¥ ××֞ך ××× ×× ×€ÖŒ×š×ַסעסעך ק×ַש, ×××֞ס ס׀֌××× ×× ××ך××€×ך×× × ×€×× ×× ×€ÖŒ×š×Öž×ך×Ö·×.
- ××× ××¢× ×ך××ס ×€×× ×עך עקסעק×××Ö·×××¢ ×עקע, ×× Q ׀֌ך×֞׊עס × ×¢×× × ×¢×××Ö·××ש×Ö·××Ö·× ×€ÖŒ××Ö·×¥ ××× ××֌ך××; ××ך ×§×¢× ×¢× ××××€× ××× ×עך×עך ×€×× ×××. ×עך׊×, ×××× × ××××ק, Q ×§×¢× ×¢× ×ַך××¢×× ××× ××¢× ×¡ ×Öž×עך ××× ×עך×עך ×€×× ×××××××× ×€×× ××֌ך×× ××× ×Ö· ×××× ×€ÖŒ×š×֞׊עס.
УМОвеÑÑалÑМПÑÑÑ
ק ××× ×ך××ס ×€Ö¿×ַך ×Ö· ×ך××× ×§××× ×€×× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×. ׀֌ך×֞׊עס ק ×§×¢× ×¢× ×©×€ÖŒ××× ××× ×Ö· ××ס××ך×שע ××Ö·××Ö·×××ס ××× ×Š×ש××¢×× ×©× ×¢× ×ַקסעס ×Š× ×עך×Ö·×××עס ×€×× ××× ×€Ö¿×֞ך××ַ׊××¢. ×€Ö¿×ַך ×××ַש׀֌××, ××ך ××Öž×× ××Ö·××Ö·× × ×€×× ××ס××ך×שע ××Ö·××Ö·×××ס××, ××× ×¢×××¢××¢ ×€×× ââ×××֞ס ×××× ×× ×§×Öž××€ÖŒ×š×¢×¡×¡×¢× ××Öž× ×€×× ××Ö·×× × ×¢×× ×עך ××× 100 ××××××××. ×Öž×עך, ××× ×עך ××××Ö·× ×š×ס×ך×קש×Ö·× ×, ×Ö· ×Öž× ×€Ö¿×š×¢× ×Š× ×× ××Ö·××Ö·×××ס ×××¢× ×××× ××¢×¢× ×××§× ××× ××¢× ×¡ ×Š× ××× ×עך×עך ×€×× ××××סעק×Ö·× ××. ××× ×Ö·×××¢××××, ××ך ××Öž×× ×Ö· ×× ×××עךס×Ö·× ×××××Ö·×× ×€Ö¿×ַך ××Ö·× ×׊עך ך×ק××עס - 30 סעק×× ×עס - ××× ×¢×¡ ×ַך××¢× ×××עך ך×ַךע××.
Q ×§×¢× ×€ÖŒ×× ×§× ××× ××××× ×××× ×Ö·× ×××-××ק×Öž×š× ××Ö·××Ö·×××ס. × ×× ××Ö·×× ××¢× ×¢× ××ס××£ ×Š× ×××-××ק×Öž×š× ×××©× ×Ö·××× ×עש×××× × ×Ö·× ××Ö·× ×׊עך ך×ק××עס ××¢× ×¢× ×× ××××Ö·××× × ×€×ַק××֞ך. ××Ö·×× ××× ×××©× ××¢× ×¢× ×¡××Öž×š× ××× ×©×€××××, ×××֞ס ×××× ×Ö·× ×§××× ×֞׀֌עך×ַ׊××¢ ××××£ ×Ö· ×××Ö·× ×××¢× × ××Š× ×× ×€ÖŒ×š×ַסעסעך ק×ַש ××× ×€×× ×§×Ö·×€ÖŒ×ַ׊×××¢×. ××× ×Ö·××ש×Ö·× ×Š× ××¢×, KX ×ע׀ך×××× ×Š× ×× ×¡×ך×××¢× × ×Ö·××¢ ×קעך××ק ×ַ׀֌עך××ש×Ö·× × ×Ö·××Ö· ××× ×ַך××××¢××ק ×××š× ××עק××֞ך ××× ×¡×ך×ק׊×עס ×€×× ×× ×€ÖŒ×š×ַסעסעך, ××ַקס×Ö·×××××× × ×××עך ×××ק××Ö·×. ק ×§×¢× ×¢× ×××× ××ך××€××š× ××ַסקס ×××֞ס ××¢× ×¢× × ××©× ×××€ÖŒ×ש ×€Ö¿×ַך ××Ö·××Ö·×××ס×× - ××ש×, ׀֌ך×֞׊עס ס×ך×××× × ××Ö·×× ××× ×š×¢××¢× ×¢× ××× "×€×ַק××ש ׊×××" (××× ×Ö· ×€×ַך××Ö·××× ×€×× ××¢× ×¡ ×€×× ××××סעק×Ö·× ×× ×Š× ×¢×××¢××¢ סעק×× ×עס ×××€ÖŒ×¢× ××× × ××××£ ×× ×ַך××¢×) ×€×ַךש××× ×Ö·××ךע××Ö·×××Öž× ×€×Ö·× ×קש×Ö·× × ×€Ö¿×ַך ×€×× ×Ö·× ×Š××¢× ×× ×¡×ך×Ö·××Ö·× ×¥ ×€Ö¿×ַך ×€×ַךש×××¢× ×¢ ׊××× ×× ×עך×××Ö·×× ×Öž×עך ××××¢× ×Ö· ××Öž××¢× ×€×× ×עך ××©×€ÖŒ×¢× ×€×× ×©××××עס××ק ×ך×Ö·× ××ַקש×Ö·× × ×Š× ×× ××ַךק ××× ××ך××€××š× ×××Ö·× ×€ÖŒ×š×Öž×€×××× × ×ÖŒ××¢× ×ª×××£ × ×Öž× ×××Ö·× ×§×Ö·××€ÖŒ××ש×Ö·×. ××× ×Ö·××Ö· ××ַסקס, ך××Ö¿ ×Öž×€× ×× ××××€ÖŒ× ×Š××× ×€×ַך××Ö·××× ××× × ××©× ×§, ×Öž×עך ×× × ××× ×Š× ×¡×× ×קך×Ö·× ××× ××Ö·×× ×€Ö¿×× ×€×ַךש×××¢× ×¢ ק×××××. ×××× ×××ק××Ö·× ××× ×Ö·×ש×××× ×š×¢×× ×Š× ××¢× ×€×Ö·×§× ×Ö·× ×× ××Ö·×× ××× ×× ×€×Ö·× ×קש×Ö·× × ×××֞ס ׀֌ך×֞׊עס ××× ××¢× ×¢× ××× ×××× ×€ÖŒ×š×֞׊עס, ××× ×€ÖŒ×š×ַסעס×× × ××× ×š××××¡× ×Š× ×¢×§×¡×ַק××××× × ×¢×××¢××¢ QSQL ×××ס×ך××§× ××× ××ש××× ×¥, ×××֞ס ××¢× ×¢× × ××©× ×× ×עך׀֌ך×Ö·××Ö·×, ×Öž×עך ××¢× ×¢× ×¢×§×¡×ַק××××Ö·× ×××š× ×××× ×¢×š× ×§×Öž×.
׊×× ×¡××£, ××ך ×§×¢× ×¢× ×©×š××Ö·×× ×§××× ×¡×¢×š×××ס ׀֌ך×ַסעס×Ö·× ××× Q. ×€Ö¿×ַך ×××ַש׀֌××, ××Ö·××¢××××Ö· ׀֌ך×ַסעס×Ö·× ×Ö·× ×××××Öž××Ö·××ש ×€×ַךש׀֌ך×××× ××Ö·× ×׊עך ך×ק××עס ×Š× ×× × ××××ק ××Ö·××Ö·×××ס×× ××× ×¡×¢×š××עךס. ×עך ׀֌ך×Öž×ך×Ö·×××¡× ××× ××Ö·× ×¥ ׀ך×××××× ×Š× ×× ×¡×ך×××¢× × ×§××× ×Ö·××עך×××Ö·× ×€Ö¿×ַך ××Ö·××Ö·× ×¡×× ×, ׀֌ך×××֞ך×Ö·××××××ש×Ö·×, ש××× ××Öž×עך×Ö·× ×¥, ×ַקסעס ךע××, ק×××Öž××ַס ××× ×××ס×ק×× ×Ö·××¥ ×××֞ס ×××× ××ַךץ ××××. ×עך ××××€ÖŒ× ×€ÖŒ×š×Öž×××¢× ××Öž ××× ×Ö·× ××ך ×××¢× ××Öž×× ×Š× ×× ×¡×ך×××¢× × ×Ö·××¢ ××¢× ×××.
××× ×Ö· ×××ַש׀֌××, ××× ×××¢× ×š×©××× ×××֞ס ×××׀֌ס ×€×× ×€ÖŒ×š×ַסעס×Ö·× ××ך ××Öž××. ×Ö·××¢ ×€×× ââ××× ××¢× ×¢× ×ַק×××××× ××¢××××× × ××× ×ַך××¢× ×Š×××Ö·××¢×, ק×Ö·××××× ×× × ××Ö·××Ö·× × ×€×× ×€×ַךש×××¢× ×¢ ××Ö·××Ö·×××ס×× ××× ××××, ׀֌ך×ַסעס×× × ××Ö·×× ×€×× ×§×××€× ×§××××× ××× ××× ×¢× ××× ×עך×עך ×€×× × ×׊עךס ××× ×Ö·×€ÖŒ××ַק××ש×Ö·× ×.
- ק×Ö·× ×¢×§××¢×š× (×€×¢×¢×××Ö·× ××עך) ×Š× ××Ö·×× ×§×××××. ×× ×€ÖŒ×š×ַסעס×Ö·× ×××€ÖŒ×ק×× × ××Š× ×€×× ×ך×××¡× ××ק ××××ךעך×× ×××֞ס ××¢× ×¢× ××Öž×××× ××× Q. ×× C ׊×××× × ××× Q ××× ××֞ך ׀֌ש×× ××× ×Ö·××Ö·×× ××ך ×Š× ××××× ×©×Ö·×€Ö¿× ×€×š××§×¡× ×€×Ö·× ×קש×Ö·× × ×€Ö¿×ַך ק××× C/C++ ××××××Öž×עק. ק ××× ×©× ×¢× ××¢× ×× ×Š× ×©×¢×€ÖŒ×, ××ש×, ׀֌ך×ַסעס×× × ×Ö· ×××× ×€×× FIX ×ַך××ק××¢× ×€×× ×Ö·××¢ ×××ך××€×¢×שע ××Ö·×עך ×קס×ש××× ××ש×× ×¡××××Ö·××××× ××ַס××.
- ××Ö·××Ö· ××ס×ך××××Ö·××¢×š× (××קעך׀֌××Ö·× ×), ×××֞ס ××× ×¢× ××× ×Ö· ×× ×עך×××××× ×€Ö¿×ַך××× ××× × ×Š××××©× ×§×Ö·× ×¢×§××¢×š× ××× ×§×Öž× ×¡××עךס. ××× ×עך ××¢×××קעך ׊×××, ××× ×©×š××Ö·×× ×× ×§×Ö·××× × ××Ö·×× ×Š× ×Ö· ס׀֌ע׊××¢× ×××× ×¢×š× ×§××Öž×¥, ׀֌ך×Ö·××××××× × ×š×Öž×××ַס×× ×ַס ×€Ö¿×ַך ק×Öž× ×¡××עךס קע×× ×§×©×š ××֞ססעס ×Öž×עך ך×ס××ַך×.
- ×××-××ק×Öž×š× ××Ö·××Ö·×××ס (ך××). ×× ××Ö·××Ö·×××ס×× ×Š×ש××¢×× ×× ×€×ַס××Ö·×¡× ××¢×××¢× ×ַקסעס ×Š× ×š××, ׀ך×ש ××Ö·×× ×××š× ×¡××֞ך×× × ×¢×¡ ××× ××֌ך××. ×××€ÖŒ×ק×Ö·×××, ××× ×Öž× ×§×××Ö·×× ××Ö·×× ××× ×××©× ×עש×ַס ××¢× ××Öž× ××× ××ַש××¢××ק ××× ×××Ö· × ×Ö·××.
- ×Öž× ××Ö·××× ××Ö·××Ö·×××ס (×€ÖŒ××). ×× ××Ö·××Ö·×××ס×× ×¢× ×©×ך ×Ö·× ××Ö·×× ×€Ö¿×ַך ×××Ö·× × ××¢× ×¢× ×¡××Öž×š× ××× ×Ö· ××ס××ך××©× ××Ö·××Ö·×××ס. ××× ×Ö· ×עךש×, × ×× ×¢× ××¢× rdb, ××× ××Öž× × ×× ×§×š×Öž× ××Ö·×× ××× ××֌ך××, ×Öž×עך × ××Š× ×Ö· ס׀֌ע׊××¢× ×§×ַש ××××£ ××סק ×עש×ַס ××¢× ××Öž× ××× × ×Öž×××Ö·×× ×× ××Ö·×× ××× ××Ö·××× ×Ö·×× ×Š× ×× ××ס××ך×שע ××Ö·××Ö·×××ס.
- ××ס××֞ך×ש ××Ö·××Ö·×××ס×× (×××). ×× ××Ö·××Ö·×××ס×× ×Š×ש××¢×× ×ַקסעס ×Š× ××Ö·×× ×€Ö¿×ַך ׀ך×עך××קע ××¢×, ××ש×× ××× ××֞ך×. ×××עך ×ך××ס (××× ××¢×) ××× ××××××¢× ××××× ×××š× ×× ×ך××ס ×€×× ×× ×©××עך ×ך×××××. ××Ö·×× ×§×¢× ×¢× ×××× ×××× ×¢×š××¢×¥, ס׀֌ע׊××¢× ××××£ ×€×ַךש×××¢× ×¢ ××סקס ×Š× ×€×ַך××××¢×š× ×ַקסעס. עס ××× ××¢×××¢× ×Š× ×§×Öž×׀֌ךעס ××Ö·×× ××× ×¢×××¢××¢ ×Ö·××עך×××Ö·×× ×Š× ×§×××Ö·×× ×€××. ×× ×¡×ך×ק××ך ×€×× ×× ××Ö·××Ö·×××ס ××× ××× ××ַק××××¢× ××Ö·× ××× ×€ÖŒ×©××, ×× ××Ö·×× ××¢× ×¢× ×¡××Öž×š× ×××Ö·× ×××š× ×××Ö·× ××× ×š×¢×××עך ×עקעס, ×Ö·××× ××× ×§×¢× ×¢× ×××× ×€ÖŒ×š×ַסעס×, ×ַך××Ö·× ×עךע×× × ×××š× ×× ×֞׀֌עך××××× × ×¡×ס××¢×.
- ××Ö·××Ö·×××ס×× ××× ×Ö·××ךע××Ö·××¢× ××× ×€Ö¿×֞ך××ַ׊××¢. ××× ×§×š×Öž× ×€×ַךש××× ×Ö·××ךע××Ö·×××Öž× ×¡, ×××ש×Ö·×××Ö·×× ×××, ×ך××€ÖŒ× ×××š× ×§××××¢ × ×Öž××¢× ××× ×Š××× ××¢××Ö·××¢×. ×××-××ק×Öž×š× ××Ö·××Ö·×××ס×× ×עך×××Ö·× ×××§× ×××עך ש××Ö·× ××× ××¢×עך ×× ×§×Ö·××× × ×Öž× ××Öž×, ××× ××ס××ך×שע ××Ö·××Ö·×××ס×× ×§×š×Öž× ×€×ַך-ק×Öž××€ÖŒ××××× ××Ö·×× ×Š× ×€×ַך××××¢×š× ×ַקסעס ×Š× ××ס××ך×שע ××Ö·××.
- ×עס×Öž×£ ×××××××× ×€ÖŒ×š×ַסעס×Ö·×סעך×××ס ×Ö·×€ÖŒ××ַק××ש×Ö·× × ××× × ×׊עךס. ק ×Ö·××Ö·×× ××ך ×Š× ×× ×¡×ך×××¢× × ××֞ך ××ס×× ×קך×Ö·× ×ַס ׀֌ך×ַסעס×× × ×€×× ×× ×§×Ö·××× × ×ַך××ק××¢×, ××ס×ך××××××× × ××× ×××עך ××Ö·××Ö·×××ס××, ק×Öž× ×ך×Öž×××š× ×ַקסעס ךע××, ×¢×ק. ××Ö·×עךק×× × ×Ö·× ×ַך××ק××¢× ××¢× ×¢× × ××©× ××××××¢× ××× ×š××Ö¿ ×Öž×€× ××¢× ×¢× × ××©× ×¡×§× ×××ס×ך×ק×, ××× ××× ×עך ×€×Ö·× ××× ×× ×עךע ××Ö·××Ö·×××ס××. ך××Ö¿ ×Öž×€×, ×× SQL ×××ס×ך×ק ××× ×€×ַך××֞ך×× ××× ×Ö· ס׀֌ע׊××¢× ×€Ö¿×× ×§×Š××¢ ××× ××× ×§×Ö·× ×¡×ך×ַק××Ö·× ×××××š× ××××£ ×× ×€ÖŒ×ַך×Ö·××¢×עךס ××¢××¢×× ×××š× ×× ××Ö·× ×׊עך - ×× ×Š××× ××× ×§×Öž× ××עך××¢×, ×€×××עך×, ×× ××Ö·×× × ×֞ך××Ö·××××× (××ש×, ×× ××Ö·×עך ׀֌ך××Ö·× ××× ×ק×××Ö·××××× ×××× ×××××××¢× ×× ××¢× ×¢× ××ַ׊×Öž××), ×××"× ×.
×××€ÖŒ×ש ×ַךק×Ö·×עק×שעך ×€Ö¿×ַך ×××× ××Ö·×× ×××€ÖŒ:
×××ק××Ö·×
××Öž×ש ק ××× ×Ö·× ×× ×עך׀֌ך×Ö·××Ö·× ×©×€ÖŒ×š×Ö·×, עס ××× ×××× ×Ö· ××עק××֞ך ש׀֌ך×Ö·×. ××¢× ×××× ×Ö·× ×€×××¢ ××¢××××-××× ×€×Ö·× ×קש×Ö·× ×, ×עך ××××€ÖŒ× ×ַך××××¢××ק ×Öž× ×¢×¡, × ×¢××¢× ×ַך××××¢× ×× ×€×× ×§××× ×€×Öž×š×¢× - × ××עך×, ××עק××֞ךס, ××Ö·×ך×ס××, ךש×××ת - ××× ×עך ׀֌ך×Öž×ך×Ö·×××¡× ××× ×עך××× ×Š× ×× ×¡×ך×××¢× × ×× ×€ÖŒ×š×Öž×ך×Ö·× ××× ××¢× ××¢ ×ַ׀֌עך××ש×Ö·× ×. ××× ×Ö·××Ö· ×Ö· ש׀֌ך×Ö·×, ×××× ××ך ××××× ×Š×××× ××עק××֞ךס ×€×× ×Ö· ×××××Öž× ×¢××¢××¢× ××, עס ××× × ×× ×עך ××××××ק ×Ö·× ×× ×©×€ÖŒ×š×Ö·× ××× ×× ×עך׀֌ך×Ö·××Ö·×; ×× ×Ö·××ש×Ö·× ×××¢× ×××× ××ך××עק×Öž×× ×××š× ×Ö· ס×׀֌עך ×Öž×€ÖŒ××××××¢× ×××× ×¢×š× ×€Ö¿×× ×§×Š××¢. ××× × ×× ×××× ×¡ ××××× ×€×× ×× ×Š××× ××× Q ××××× ××× ×€×ך×ך××× ××××£ ×ַ׀֌עך××ש×Ö·× × ××× ×××©× ×××֞ס × ××Š× ×× ×קעך××ק ××עק××֞ך×××¢× ×€×Ö·× ×קש×Ö·× ×, ×עך ךע×××××Ö·× ××× ×Ö· ×××עך ×××Ö·××ש ×ַ׀֌עך××××× × ×××ק××Ö·×, ×Ö·××Ö·××× × ××× ×× ×Š× ×€ÖŒ×š×֞׊עס ×Ö· ך×××ק ס×××¢ ×€×× ââââ××Ö·×× ××€××× ××× ×××× ×€ÖŒ×š×֞׊עס. ××֞ס ××× ×¢× ××¢× ×Š× ××Ö·××Ö·××Ö·××ק×Ö·× ××××ךעך×× ××× ×€ÖŒ××××Öž× - ××Öž×ש ×€ÖŒ××××Öž× ××× ××× ×Ö· ×××עך ×€ÖŒ×Ö·××¢××¢× ×©×€ÖŒ×š×Ö·×, עס ××× ×€×××¢ ××ס×ע׊×××× × ××××ךעך×× ××× × ×Ö·××€ÖŒ× ×××֞ס ××Öž×× ××ך ×Š× ×€ÖŒ×š×֞׊עס × ××עך×ק×Ö·× ××Ö·×× ××× ×× ×××ק××Ö·× ×€×× ×Ö· ׊×× ×××€×עש××¢×× ×©×€ÖŒ×š×Ö·× (×××, × ×Ö·××€ÖŒ× ××× ×××××ַק×Ö·×× × ×Öž×¢× × ×Š× ×§. ).
××× ×Ö·××ש×Ö·×, KX ××¢× ×××¢× ×Ö· ×××עך ×Öž×€ÖŒ××¢××× ×Š×××Ö·× × ×Š× ×××××× ×× × ×××©× ××× ×Öž×€ÖŒ××××××× × ×ַך××¢× ××× ×××. ×€×ךס×××, ×¢×××¢××¢ ×××׀֌ס ×€×× ×× ×עקס×× ××¢× ×¢× ×עש××׊×, ×××֞ס ××¢× ×¢× ×עש×××Š× ×××š× ××¢××××-××× ×€×Ö·× ×קש×Ö·× × ××× ×§×¢× ×¢× ×××× ××¢×××¢× ×× × ×× ××××× ×Š× ××ש ש׀××××, ×Öž×עך ×××× ××××£ ק××× ××עק××֞ךס - ×ך××€ÖŒ×× ×, ס×֞ך××× ×, ××××× ×ך××ק××× ×Ö·×ך××××× ××× ×¡×€ÖŒ×¢×Š××¢× ×ך××€ÖŒ×× × ×€Ö¿×ַך ××ס××ך×שע ××Ö·××Ö·×××ס××. ×עך ××× ×עקס ××× ×¡×××€ÖŒ×× ××¢×××¢× ×× ××× ××× ×××××Öž××Ö·××ש ×Ö·××ש×ַס××× ×××¢× ×Ö·××× × ×¢××¢××¢× ×× ×Š× ×× ×××Ö·× / ××עק××֞ך. ×× ×עקס×× ×§×¢× ×¢× ×××× ××¢×××¢× ×× ××××Ö·× ×Š× ××ש ש׀×××× ××× ××֌ך×× ××× ××××£ ××סק. ×××¢× ×¢×§×¡×ַק××××× × ×Ö· QSQL ×Öž× ×€Ö¿×š×¢×, ×× ×עקס×× ××¢× ×¢× ××¢××××× × ×××××Öž××Ö·××ש ×××× ××¢×××¢×. ׊×××××× ×¡, ×ַך××¢× ××× ××ס××ך×שע ××Ö·×× ××× ××ך××עק×Öž×× ×××š× ×× ×עק×Ö·× ×××Ö·× ×€Ö¿×ַך ××××Ö·× ×€×× ×ַס ×עקעס (××ק×Öž×š× ××ַ׀֌ע). ×ך××ס ×××©× ××¢× ×¢× ×§××× ××Öž× ××Öž×××× ××× ××֌ך××; ×Ö·× ×©××Öž×, ×× × ××××ק ש׀×××× ××¢× ×¢× ××Ö·×€ÖŒ× ××××Ö·× ××× ××֌ך×× ××× ××××× ×עך ×××× ×€×× ××× ××× ×ַק×ש×Ö·×××Ö·×× ××Öž×××× (××× ×עקס×× ×××× ××¢××€× ××Öž) ×××֞ס ××¢× ×¢× ××ךף. עס ×××× ×§××× ××××ק ×Š× ×× ×€ÖŒ×š×Öž×ך×Ö·×××¡× ×Š× ×× ××Ö·×× ××¢× ×¢× ××× ××ק×Öž×š× ×Öž×עך × ×ש×; ×× ×עק×Ö·× ×××Ö·× ×€Ö¿×ַך ×ך××¢×× ××× mmap ××× ××֞ך ×€×ַך××֞ך×× ××× ×× ×××€×¢× ××©× ×€×× ×§.
KDB + ××× × ××©× ×Ö· ך××××ש×Ö·× ×Ö·× ××Ö·××Ö·×××ס; ×××©× ×§×¢× ×¢× ×Ö·× ×××Ö·××× ×ַך×××ך×ַך×ש ××Ö·××, ×שעת ×× ×¡×ך ×€×× ×š×Öž×× ××× ×× ××ש ××× × ××©× ××××©× ×××¢× × ××Ö·×¢ ×¢××¢××¢× ×× ××¢× ×¢× ××ס××£ ××× ×§×¢× ×¢× ××× ××Öž× ×××× ××¢××××× × ×××¢× ×©×š×××× ×§×××ך××. ×עך ש×ך×× ××× ×¢×š××ש×Ö·× ××× ××ךף ×€Ö¿×ַך ×ך××¢×× ××× ×Š××× ×¡×¢×š××¢ (××Ö·×× ×€×× ×קס×ש××× ××ש××, ××¢××¢××¢×ך×, ××¢×©×¢×¢× ×ש ××Öž×ס), ××××Ö·× ×××× ×× ××Ö·×× ××¢× ×¢× ×××ס×עש××¢×× ×××š× ×Š×××, ×עך ××Ö·× ×׊עך ××ַךף × ××©× × ××Š× ×§××× SQL ×ך×קס ×Š× ××¢×€Ö¿×× ×¢× ×× ×¢×š×©×עך ×Öž×עך ×ע׊××¢ ך×××¢×š× ×Öž×עך N. ך×Öž×× ××× ×× ××ש , ××ַש××××¢× ×××֞ס ש××š× ×××× ×× × × ×©×ך×, ×××"× ×. ××Ö·×××¢ ××ש××× ×¥ ××¢× ×¢× ×¡×××€ÖŒ××Ö·×€××× × ×Öž× ×עך, ××ש×, ×Š× ××¢×€Ö¿×× ×¢× ×× ×ע׊××¢ ׊××××š× ×€Ö¿×ַך 16000 VOD.L (Vodafone) ×ך×Ö·× ××ַקש×Ö·× × ××× ×Ö· ××ש ×€×× 500 ×××××Öž× ×¢××¢××¢× ×× × ×¢×× ×××¢×× ×Ö· סעק×× ××¢ ××××£ ××סק ××× ××¢× ×¡ ×€×× ××××סעק×Ö·× ×× ××× ××֌ך××.
×Ö· ×××ש׀֌×× ×€×× ×Ö· ׊××× ×€×ַך××× ×× - ×× ×Š××××š× ××ש ××× ××Ö·×€ÖŒ× ×Š× ××֌ך××, ×Ö·××× ×¢×¡ ××× × ×× ××Ö·×š×€Ö¿× ×Š× ×¡×€ÖŒ×¢×Š××€×׊××š× VOD.L ××× ××× ×עך ××× ×עקס ××××£ ×× ×¡×× ×××Ö·× ××× ×× ×€×Ö·×§× ×Ö·× ×× ××Ö·×× ××¢× ×¢× ×××ס×עש××¢×× ×××š× ×Š××× ××¢× ×¢× ×××€ÖŒ××ס×Ö·××× ××¢× ×׊×. ×ÖŒ××¢× ×Ö·××¢ ××ש××× ×¥ ××× ×§ ××¢× ×¢× ×š×¢×××עך ×€×Ö·× ×קש×Ö·× ×, × ××©× ×××× ×€×× ×Ö· ×××סק×××Ö·×× ×××ס×ך×ק:
1. aj[`sym`time;select from trade where date=2019.03.26, sym=`VOD.L;select from quote where date=2019.03.26]
׊×× ×¡××£, עס ××× ×××× ×Š× ××××¢×š×§× ×Ö·× ×× ×¢× ××ש×Ö·× ××š× ××× KX, ס××ַך××× × ××× Arthur Whitney ×××, ××¢× ×¢× ×××ת ×Ö·××¡×¢×¡× ××× ×¢×€×¢×§××××ק××Ö·× ××× ×××× ×Š× ×ך××ס ××¢× ××ס ×Š× ××ַק×××¢× ×× ××¢×š×¡× ×××ס ×€×× ×× Q ס × ×֞ך××Ö·× ×€Ö¿×¢×֎ק×××× ××× ×Ö·×€ÖŒ××Ö·×××× ×× ××¢×š×¡× ×€ÖŒ×š×Öž×¡× ××Ö·× ××¥ ×€ÖŒ×Ö·××¢×š× ×.
××Ö·× ×¥
KDB + ××× ×€×Öž×קס ׊××××©× ×עשע׀×× ××€Ö¿×š× ×š×¢×× ×Š× ×××× ×קסע׀֌ש×Ö·× ×Ö·× ××עךס×Ö·××××Ö·×× - עס סעך××עס ××××× ××× ×Ö· ×××-××ק×Öž×š× ××Ö·××Ö·×××ס, ××× ×Ö· ××Ö·××Ö·×××ס ×€Ö¿×ַך ס××֞ך×× × ×עך×Ö·×××עס ×€×× ××ס××ך×שע ××Ö·××, ××× ××× ×Ö· ×€ÖŒ××Ö·××€×֞ך××¢ ×€Ö¿×ַך ××Ö·×× ×Ö·× ×Ö·××ס×ס. ךע×× ×Š× ××¢× ×€×Ö·×§× ×Ö·× ××Ö·×× ×€ÖŒ×š×ַסעס×× × ×Ö·×§×¢×š× ××××Ö·× ××× ×× ××Ö·××Ö·×××ס, ×××× ×××ק××Ö·× ×€×× ×ַך××¢× ××× ×××× ×¡×××××× ×× ××¢× ×¢× ×Ö·×ש××××. × ×€××-×€××¢×××©× ×€ÖŒ×š×Öž×ך×Ö·×××× × ×©×€ÖŒ×š×Ö·× ×× ×Ö·×ך××××× ××× ××Ö·××Ö·×××ס ×€×Ö·× ×קש×Ö·× × ×Ö·××Ö·×× ××ך ×Š× ×× ×¡×ך×××¢× × ×× ××× ×Š×¢ ×Öž× ××××× ×€×× × ××××ק ׀֌ך×ַסעס×Ö·× ××××£ ×××× ×€ÖŒ××Ö·××€×֞ך××¢ - ×€Ö¿×× ×š×ס××××× × ××Ö·×× ×Š× ×€ÖŒ×š×ַסעס×× × ××Ö·× ×׊עך ך×ק××עס.
× ×Öž× ××× ×€Ö¿×֞ך××ַ׊××¢
×××××××ש×Ö·× ×
× ××Ö·×××Ö·××ק ××ס×Öž×š× ×€×× KDB + / Q ××× ×× ×××× ×€ÖŒ×Öž××׊××¢ ש×××¢×. ×× ×©×€ÖŒ×š×Ö·× ××× ×Ö· ××Öž×× ×¢ ס×× ××ַקס, ×¢×××¢××¢ ×€×Ö·× ×קש×Ö·× × ××¢× ×¢× ×©××עך ×Öž×××עך××Öž×××× (××עך×, ××ש×, ××× ×××¢×× 11 × ××Š× ×§×ַסעס). ך××Ö¿ ×××€ÖŒ×֞ך××Ö·× ×××, עס ך×ק×××××¢×š× ×Ö· ך×Ö·××ק×Ö·×× ×Ö·× ×עךש ׊×××Ö·× × ×Š× ×©×š×××× ×××××. ××× ×Ö· ××עק××֞ך ש׀֌ך×Ö·×, ××ך ×××× ×©××¢× ××ק ×ך×Ö·××× ××× ×עך××× ×¢× ×€×× ××¢× ××¢ ×ך×Ö·× ×¡×€×֞ך××ַ׊××¢, ×× ×¡×ך×××¢× × ×Ö·××¢ ××׀֌ס ×××š× ×¢×××¢××¢ ××עך××Ö·× ×¥ ×€×× ×× ××ַ׀֌ע / ךע××׊××š× ×€×Ö·× ×קש×Ö·× × (×××֞ס ××¢× ×¢× ×עך××€Ö¿× ×Ö·×××עך×ס ××× ×§), ××× ×§××× ××Öž× ×€ÖŒ×š××××š× ×Š× ×©×€ÖŒ×Öž×š× ××¢×× ×××š× ×š××€ÖŒ×××ס×× × ××עק××֞ך ×ַ׀֌עך××ש×Ö·× × ××× ×Ö·××Öž××שע ×Öž× ×¢×¡. ×€Ö¿×ַך ×××ַש׀֌××, ×Š× ××¢×€Ö¿×× ×¢× ×× ××× ×עקס ×€×× ×× Nth ×€ÖŒ×ַס×ך×× × ×€×× ×Ö·× ×¢××¢××¢× × ××× ×Ö· ××¢× ××¢, ××ך ××Öž× ×©×š××Ö·××:
1. (where element=vector)[N]
××Öž×ש ××֞ס ×××× × ×עך×Ö·××× ××Ö·×××Öž× ×ש ×××š× C / Java ס××Ö·× ××ַך×ס (= קך××××¥ ×Ö· ×××××Ö·× ××עק××֞ך, ××× ×§×¢×š× ×× ××ת ×× ×עקס×× ×€×× ×× ×¢××¢××¢× ×× ××× ×¢×¡). ××עך ××¢× × ×Öž××××ש×Ö·× ×××× ×× ×××Ö·×ש ×€×× ×× ×××ס×ך×ק ×עך ק××֞ך ××× ××ך × ××Š× ×©× ×¢× ××עק××֞ך ×ַ׀֌עך××ש×Ö·× × ×Ö·× ×©××Öž× ×€×× ×€ÖŒ×Ö·××¢××¢× ×Ö·××Öž××שע ×Öž× ×¢×¡. ×עך ק×Ö·× ×¡×¢×€ÖŒ×ש××Ö·× ××××ק ׊××××©× ×Ö· ××עק××֞ך ש׀֌ך×Ö·× ××× ×× ×עךע ××× ×€×ַך××××Ö·×××¢× ×Š× ×× ××××ק ׊××××©× ××׀֌עך×Ö·×××× ××× ×€×Ö·× ×קש×Ö·× ×Ö·× ×ַ׀֌ך×Öž××ש×× ×Š× ×€ÖŒ×š×Öž×ך×Ö·×××× ×, ××× ××ך ××Ö·×š×€Ö¿× ×Š× ×××× ×Š×××¢×ך××× ×€Ö¿×ַך ××¢×.
×¢×××¢××¢ ××××¢×š× ××¢× ×¢× ×××× ×××××ק××¢× ××× QSQL. ×× ×€×× × ××× ×Ö·× ×¢×¡ × ×֞ך ק××§× ××× ×€×ַק××ש SQL. ××× ×€×ַק×, עס ××× × ×֞ך ×Ö·× ××עך×ע׊עך ×€×× SQL-××× ×××ס×ך××§× ×××֞ס ש×××Š× × ××©× ×Öž× ×€Ö¿×š×¢× ×Ö·×€ÖŒ××Ö·××Ö·×××ש×Ö·×. ×עך ××Ö·× ×׊עך ×××× ×©×š××Ö·×× ×Öž×€ÖŒ××××Ö·× ×§×××ך×× ×××, ××× ××× Q, ×××֞ס ×€×××¢ ××¢× ×¢× × ××©× ×ך××× ×€Ö¿×ַך. ××××£ ×× ×× ×עךע ××Ö·× ×, ×€×× ×§×ךס, ××ך ×§×¢× ×¢× ×©××¢× ××ק שך××Ö·×× ×× ×Öž×€ÖŒ××××Ö·× ×Öž× ×€Ö¿×š×¢× ×××, ××× ××× ×€×ַך××Öž×× ××××£ ×Ö· ש×××ַךץ קעס×× ×Öž×€ÖŒ×××××עך.
××× ×Ö· ×€ÖŒ××ס, ×Ö· ××× ××××£ Q - Q For Mortals ××× ×× ×××Š× ×€Ö¿×ַך ׀ך×× ×××
×× ×× ×עך ×ך××ס ××ס×Öž×š× ××× ×× ×€ÖŒ×š××Ö·× ×€×× ×× ×עך×××××¢× ×ש. ×Ö·× ×¡ ××¢× ×¡ ×€×× ××××× ×עך ×€×× ××Öž×××ַךס ׀֌עך ××֞ך ׀֌עך ק׀֌×. ××××× ×ך××ס ק×Öž××€ÖŒ×Ö·× ×עס ×§×¢× ×¢× ×€×ַך××× ×¢× ××× ×Ö·××Ö· ××׊××ת. ×ע׊×× ×¡, KX ××× ××¢×××× ×××× ×××ס×Ö·× ×¡×× × ×€ÖŒ×Öž××××ק ×עך ×€×עקס×Ö·××Ö·× ××× ××× ×× ××¢××¢×× ×××× ×Š× ×Š×Öž×× ××××× ×€Ö¿×ַך ×× ×Š××× ×€×× × ××Š× ×Öž×עך ××× ××¢× KDB+ ××× ×× Google ××× ×Ö·××Ö·××Öž× ×××××§× ×¡. KX ×֞׀׀עךס ×××× ×ך×׀ק××€××¢
ק×Öž×׀֌ע××××֞ךס
עס ××¢× ×¢× ××Ö·× ×¥ ×Ö· ×××¡× ×¡×€ÖŒ×¢×©×Ö·××××× ××Ö·××Ö·×××ס×× ××¢×××× ××××£ ×¢× ××¢× ×€ÖŒ×š×× ×Š××€ÖŒ× - ק×Öž×××× ×¢×š, ×××-××ק×֞ך×, ×€×Öž×ק××¡× ××××£ ×××עך ×ך××ס ×Ö·××Ö·×× ×¥ ×€×× ××Ö·××. ×× ×€ÖŒ×š×Öž×××¢× ××× ×Ö·× ××֞ס ××¢× ×¢× ×¡×€ÖŒ×¢×©×Ö·××××× ××Ö·××Ö·×××ס××. × ×¡×ך××ק×× × ×××ַש׀֌×× ××× Clickhouse. ×× ××Ö·××Ö·×××ס ××× ×Ö· ×××עך ×¢× ××¢× ×€ÖŒ×š×× ×Š××€ÖŒ ×Š× KDB+ ×€Ö¿×ַך ס××֞ך×× × ××Ö·×× ××××£ ××סק ××× ××××¢× ×Ö·× ××× ×עקס; עס ׀֌עך׀×֞ך×× ×¢×××¢××¢ ׀ֿך××× ×€×ַס×עך ××× KDB+, ××Öž×ש × ×× ×××××××ק. ×Öž×עך ××€××× ××× ×Ö· ××Ö·××Ö·×××ס, Clickhouse ××× ×עך ס׀֌עש×Ö·××××× ××× KDB + - ×××¢× ×Ö·× ×Ö·××××קס ××ס ×ַך×××ך×ַך×ש ׊××× ×¡×¢×š××¢ (×עך ××××ק ××× ×××עך ××××××ק - ××××Ö·× ×€×× ×¢×¡, ××ש×, ××× Clickhouse עס ××× × ×× ××¢×××¢× ×Š× × ××Š× ×× ×֞ך×עך×× × ×€×× ×š×¢×§×֞ך×ס). ×Öž×עך, ך××Ö¿ ×××€ÖŒ×֞ך××Ö·× ×××, Clickhouse ××× × ××©× ×× ××עךס×Ö·××××Ö·×× ×€×× KDB +, ×Ö· ש׀֌ך×Ö·× ×××֞ס ×××Öž×× ××Öž×× ×€ÖŒ×š×ַסעס×× × ××Ö·×× ××××Ö·× ××× ×× ××Ö·××Ö·×××ס, ××× ××× ××Öž×××× × ×¢×¡ עךש×עך ××× ×Ö· ××Ö·××× ×עך ×Ö·×€ÖŒ××ַק××ש×Ö·×, ××××¢× ×ַך×××ך×ַך×ש ×¡×§× ×××ס×ך×ק×, ×Ö·×€ÖŒ××××× × ×ַך×××ך×ַך×ש ×€×Ö·× ×קש×Ö·× × ××× ×Ö· ×Öž× ×€Ö¿×š×¢×, קך×××××× × ×€ÖŒ×š×ַסעס×Ö·×. × ×× ×©××Ö·××ת ×Š× ×עך ××ך××€×ך×× × ×€×× ××ס××ך×שע ××Ö·××Ö·×××ס ×€×Ö·× ×קש×Ö·× ×. ×עך××עך, עס ××× ×©××עך ×Š× ×€×ַך××××Ö·×× KDB + ××× ×× ×עךע ××Ö·××Ö·×××ס××; ××× ×§×¢× ×××× ×עסעך ××× ×××עך × ××Š× ×§×ַסעס ×Öž×עך ׀ש×× ×עסעך ×××¢× ×¢×¡ ק××× ×Š× ×§××ַס×ש ××Ö·××Ö·×××ס ××ַסקס, ×Öž×עך ××× ××Öž× × ×× ××××¡× ×€×× ×× ×× ×עך ××××Ö·× ×¢×€×¢×§×××× ××× ××עךס×Ö·××Ö·× ×ע׊××Ö·× ×€Ö¿×ַך ׀֌ך×ַסעס×× × ×Š××Ö·×××××Ö·××ק ××Ö·××.
×€ÖŒ××××Öž× ×× ×Ö·×ך××ש×Ö·×
×Š× ××Ö·×× KDB+ ×ך×× ×עך ×Š× × ××Š× ×€Ö¿×ַך ××¢× ××©× ×××֞ס ××¢× ×¢× × ××©× ××ַק×Ö·× × ××× ×× ××¢×× ×Öž××Öž×××¢, KX ××ש××€× ××××ךעך×× ×Š× ××סש××××¢× ×××××× ××× ×€ÖŒ××××Öž× ××× ×Ö· ×××× ×€ÖŒ×š×֞׊עס. ××ך ×§×¢× × ×š××€× ×§××× Python ×€×× ×§×Š××¢ ×€Ö¿×× Q, ×Öž×עך ×××׊ע ××עךס×Ö· - ך××€× ×§××× Q ×€×× ×§×Š××¢ ×€Ö¿×× Python (ס׀֌ע׊××¢× QSQL ×××ס×ך×ק×). ×××ך×ַך×עס ×עך, ×××× × ××××ק (× ×× ×©××¢× ××ק ×€Ö¿×ַך ×× ×Š×××× ×€×× ×¢×€×¢×§××××ק××Ö·×), ××Ö·×× ×€×× ×× ×€Ö¿×֞ך××Ö·× ×€×× ×××× ×©×€ÖŒ×š×Ö·× ×Š× ×× ×€Ö¿×֞ך××Ö·× ×€×× ×× ×עך×. ××× ×Ö· ךע×××××Ö·×, Q ××× Python ××¢×× ××× ×Ö·××Ö· ×Ö· × ×Öž×¢× × ×¡××××××Öž×ס×ַס ×Ö·× ×× ××Ö·×× ×ך×× ×Š××××©× ××× ××¢× ×¢× ××עך×. ××× ×Ö· ךע×××××Ö·×, ×עך ׀֌ך×Öž×ך×Ö·××ס×, ××××£ ×× ×××× ××Ö·× ×, ××× ×€×× ×ַקסעס ×Š× ×€×××¢ × ×׊×ק ×€ÖŒ××××Öž× ××××ךעך××, ××××£ ×× ×× ×עךע ××Ö·× ×, עך ××ק××× ×Ö· ×©× ×¢× ××Ö·××¢ ×€Ö¿×ַך ×ך××¢×× ××× ×ך××ס ××Ö·×× ×× ×Ö·×ך××××× ××× ×€ÖŒ××××Öž×, ×××֞ס ××× ×¡×€ÖŒ×¢×Š××¢× × ×׊×ק ×€Ö¿×ַך ××¢× ×¢ ×× ×××Ö·×××× ××× ××ַש×× ××¢×š× ×¢×. ×Öž×עך ××Öž××¢××× ×.
×ך××¢×× ××× Q ××× Python:
1. >>> q()
2.q)trade:([]date:();sym:();qty:())
3. q)
4. >>> q.insert('trade', (date(2006,10,6), 'IBM', 200))
5. k(',0')
6. >>> q.insert('trade', (date(2006,10,6), 'MSFT', 100))
7. k(',1')
×š×¢×€Ö¿×¢×š×¢× ×Š×
×עך ×€ÖŒ××Ö·×¥ ×€×× ×× ×€×ך××¢ -
×××¢×ס××× ×€Ö¿×ַך ××¢×××¢××֞׀֌עךס -
ס׀ך ק ×€Ö¿×ַך ××֞ך××Ö·×× (××× ×¢× ×××ש) -
×ַך××ק××¢× ××××£ KDB +/Q ×Ö·×€ÖŒ××ַק××ש×Ö·× × ×€×× kx ×¢××€ÖŒ××××× -
×ק×ך: www.habr.com