{"id":254802,"date":"2015-04-08T15:51:03","date_gmt":"2015-04-08T11:51:03","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=254802"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=254802","title":{"rendered":"\u041d\u043e\u0432\u043e\u0435 \u0432 Cach\u00e9 2015.1: SQL-\u0438\u043d\u0434\u0435\u043a\u0441 \u043f\u043e \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430-\u043c\u0430\u0441\u0441\u0438\u0432\u0430"},"content":{"rendered":"

\t\u0412 Cach\u00e9 2015.1 \u043f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0432\u043a\u043b\u044e\u0447\u0438\u0442\u044c \u0434\u043b\u044f \u0441\u0432\u043e\u0439\u0441\u0442\u0432 \u043a\u043e\u043b\u043b\u0435\u043a\u0446\u0438\u0439 \u043f\u0440\u043e\u0435\u043a\u0446\u0438\u044e \u0432 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u0443\u044e \u043a\u043e\u043b\u043e\u043d\u043a\u0443. \u0422\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c \u0434\u043b\u044f SQL \u0434\u043e\u0441\u0442\u0443\u043f\u0430 \u043a \u0434\u0430\u043d\u043d\u044b\u043c \u043a\u043e\u043b\u043b\u0435\u043a\u0446\u0438\u0438 \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u043d\u0435 \u0442\u043e\u043b\u044c\u043a\u043e \u0434\u043e\u0447\u0435\u0440\u043d\u044e\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443, \u043d\u043e \u0438 \u043f\u0440\u043e\u0441\u0442\u043e \u043a\u0430\u043a \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u0443\u044e \u043a\u043e\u043b\u043e\u043d\u043a\u0443, \u0432 \u043a\u043e\u0442\u043e\u0440\u043e\u0439 \u043b\u0435\u0436\u0430\u0442 \u0432\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u043a\u043e\u043b\u043b\u0435\u043a\u0446\u0438\u0438. \u041f\u043e\u0434\u0440\u043e\u0431\u043d\u0435\u0435 \u043e\u0431 \u044d\u0442\u043e\u043c \u0437\u0434\u0435\u0441\u044c<\/a>.
\u041e \u0442\u043e\u043c, \u043a\u0430\u043a \u0438 \u0433\u0434\u0435 \u044d\u0442\u043e \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u043f\u043e\u043b\u0435\u0437\u043d\u043e \u043d\u0430 \u043f\u0440\u0430\u043a\u0442\u0438\u043a\u0435, \u0440\u0430\u0441\u0441\u043a\u0430\u0437\u044b\u0432\u0430\u0435\u0442 \u044d\u0442\u0430 \u0441\u0442\u0430\u0442\u044c\u044f.
<\/a><\/p>\n

\u0418\u043d\u043e\u0433\u0434\u0430 \u0431\u044b\u0432\u0430\u0435\u0442 \u043f\u043e\u043b\u0435\u0437\u043d\u044b\u043c (\u043e\u0441\u043e\u0431\u0435\u043d\u043d\u043e \u0434\u043b\u044f \u043c\u043e\u0434\u0435\u043b\u0438 EAV) \u0432 \u043a\u043b\u0430\u0441\u0441\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0441\u0432\u043e\u0439\u0441\u0442\u0432\u0430-\u043c\u0430\u0441\u0441\u0438\u0432\u044b \u0438 \u0438\u043c\u0435\u0442\u044c \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044c \u0431\u044b\u0441\u0442\u0440\u043e\u0433\u043e \u043f\u043e\u0438\u0441\u043a\u0430 \u043f\u043e \u0438\u0445 \u044d\u043b\u0435\u043c\u0435\u043d\u0442\u0430\u043c: \u043a\u0430\u043a \u043a\u043b\u044e\u0447\u0443, \u0442\u0430\u043a \u0438 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044e. <\/p>\n

\u0420\u0430\u0441\u0441\u043c\u043e\u0442\u0440\u0438\u043c \u043f\u0440\u043e\u0441\u0442\u043e\u0439 \u043f\u0440\u0438\u043c\u0435\u0440<\/b><\/p>\n
\nClass User.eav Extends %Persistent
<\/font>{<\/p>\n

<\/font>Index <\/font>idx1 On attributes(ELEMENTS) [ <\/font>Data <\/font>= entity ];<\/p>\n

<\/font>Index <\/font>idx2 On (attributes(KEYS), attributes(ELEMENTS)) [ <\/font>Data <\/font>= entity ];<\/p>\n

<\/font>Property <\/font>entity;<\/p>\n

<\/font>Property <\/font>attributes <\/font>As array Of %String<\/font>(<\/font>SQLTABLENAME <\/font>= <\/font>"attributes"<\/font>) [ <\/font>SqlFieldName <\/font>= <\/font>attr <\/font>];<\/p>\n

<\/font>\/\/\/ do ##class(User.eav).RepopulateAll()
ClassMethod <\/font>RepopulateAll()
{
  <\/font>do <\/font>..<\/font>%DeleteExtent<\/font>()
  
  <\/font>set <\/font>name<\/font>=<\/font>$TR<\/font>(<\/font>"\u0421\u043e\u0441\u043d\u0430^ \u0441\u0438\u0431\u0438^\u0440\u0441\u043a\u0430\u044f \u043a\u0435\u0434\u0440\u043e^\u0432\u0430\u044f"<\/font>,<\/font>"^"<\/font>,<\/font>$c<\/font>(769))
  
  <\/font>set <\/font>obj<\/font>=..<\/font>%New<\/font>()
  <\/font>set <\/font>obj<\/font>.<\/font>entity<\/font>=<\/font>"\u0427\u0435\u043b\u043e\u0432\u0435\u043a"
  <\/font>do <\/font>obj<\/font>.<\/font>attributes<\/font>.<\/font>SetAt<\/font>(22,<\/font>"\u0412\u043e\u0437\u0440\u0430\u0441\u0442"<\/font>)
  <\/font>do <\/font>obj<\/font>.<\/font>attributes<\/font>.<\/font>SetAt<\/font>(186,<\/font>"\u0420\u043e\u0441\u0442"<\/font>)
  <\/font>do <\/font>obj<\/font>.<\/font>attributes<\/font>.<\/font>SetAt<\/font>(<\/font>"\u0412\u0430\u0441\u044f"<\/font>,<\/font>"\u0418\u043c\u044f"<\/font>)
  <\/font>do <\/font>obj<\/font>.<\/font>%Save<\/font>()<\/p>\n

  <\/font>set <\/font>obj<\/font>=..<\/font>%New<\/font>()
  <\/font>set <\/font>obj<\/font>.<\/font>entity<\/font>=<\/font>"\u0414\u0435\u0440\u0435\u0432\u043e"
  <\/font>do <\/font>obj<\/font>.<\/font>attributes<\/font>.<\/font>SetAt<\/font>(186,<\/font>"\u0412\u043e\u0437\u0440\u0430\u0441\u0442"<\/font>)
  <\/font>do <\/font>obj<\/font>.<\/font>attributes<\/font>.<\/font>SetAt<\/font>(22,<\/font>"\u0412\u044b\u0441\u043e\u0442\u0430"<\/font>)
  <\/font>do <\/font>obj<\/font>.<\/font>attributes<\/font>.<\/font>SetAt<\/font>(<\/font>"\u0421\u043e\u0441\u043d\u043e\u0432\u044b\u0435"<\/font>,<\/font>"\u0421\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u043e"<\/font>)
  <\/font>do <\/font>obj<\/font>.<\/font>attributes<\/font>.<\/font>SetAt<\/font>(<\/font>name<\/font>,<\/font>"\u0418\u043c\u044f"<\/font>)
  <\/font>do <\/font>obj<\/font>.<\/font>%Save<\/font>()
  
  <\/font>\/*
  
  ; \u0438\u043b\u0438
  
  &sql(insert into eav(entity) select ‘\u0427\u0435\u043b\u043e\u0432\u0435\u043a’ union select ‘\u0414\u0435\u0440\u0435\u0432\u043e’)
  &sql(insert into attributes(eav,element_key,attr)
  select 1,’\u0412\u043e\u0437\u0440\u0430\u0441\u0442’,22 union
  select 1,’\u0420\u043e\u0441\u0442’,186 union
  select 1,’\u0418\u043c\u044f’,’\u0412\u0430\u0441\u044f’ union
  select 2,’\u0412\u043e\u0437\u0440\u0430\u0441\u0442’,186 union
  select 2,’\u0412\u044b\u0441\u043e\u0442\u0430’,22 union
  select 2,’\u0421\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u043e’,’\u0421\u043e\u0441\u043d\u043e\u0432\u044b\u0435’ union
  select 2,’\u0418\u043c\u044f’,:name)
  *\/
  
  <\/font>do <\/font>..<\/font>Reindex<\/font>()
}<\/p>\n

<\/font>\/\/\/ do ##class(User.eav).Reindex()
ClassMethod <\/font>Reindex()
{
  <\/font>do <\/font>..<\/font>%BuildIndices<\/font>(,1)<\/p>\n

  <\/font>do $system<\/font>.SQL<\/font>.<\/font>TuneTable<\/font>(<\/font>"SQLUser.eav"<\/font>,1)
  <\/font>do $system<\/font>.SQL<\/font>.<\/font>TuneTable<\/font>(<\/font>"SQLUser.attributes"<\/font>,1)
  <\/font>do $system<\/font>.OBJ<\/font>.<\/font>Compile<\/font>(<\/font>$classname<\/font>(),<\/font>"cu"<\/font>)
}<\/p>\n

}<\/font><\/font><\/td>\n<\/p><\/div>\n<\/div>\n

\u041f\u043e\u0441\u043b\u0435 \u0437\u0430\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f (do <\/font>##class<\/font>(<\/font>User.eav<\/font>).<\/font>RepopulateAll<\/font>()<\/font>) \u0432 \u043d\u0430\u0448\u0438\u0445 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u0445 \u043e\u043a\u0430\u0436\u0443\u0442\u0441\u044f \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0435 \u0434\u0430\u043d\u043d\u044b\u0435:<\/p>\n

\u0422\u0430\u0431\u043b\u0438\u0446\u0430 eav<\/b>: <\/p>\n\n\n\n\n
ID<\/th>\nentity<\/th>\n<\/tr>\n
1<\/td>\n\u0427\u0435\u043b\u043e\u0432\u0435\u043a<\/td>\n<\/tr>\n
2<\/td>\n\u0414\u0435\u0440\u0435\u0432\u043e<\/td>\n<\/tr>\n<\/table>\n

\u0422\u0430\u0431\u043b\u0438\u0446\u0430 attributes<\/b>: <\/p>\n\n\n\n\n\n\n\n\n\n
eav<\/th>\nID<\/th>\nattr<\/th>\nelement_key<\/th>\n<\/tr>\n
1<\/td>\n1||\u0412\u043e\u0437\u0440\u0430\u0441\u0442<\/td>\n22<\/td>\n\u0412\u043e\u0437\u0440\u0430\u0441\u0442<\/td>\n<\/tr>\n
1<\/td>\n1||\u0418\u043c\u044f<\/td>\n\u0412\u0430\u0441\u044f<\/td>\n\u0418\u043c\u044f<\/td>\n<\/tr>\n
1<\/td>\n1||\u0420\u043e\u0441\u0442<\/td>\n186<\/td>\n\u0420\u043e\u0441\u0442<\/td>\n<\/tr>\n
2<\/td>\n2||\u0412\u043e\u0437\u0440\u0430\u0441\u0442<\/td>\n186<\/td>\n\u0412\u043e\u0437\u0440\u0430\u0441\u0442<\/td>\n<\/tr>\n
2<\/td>\n2||\u0412\u044b\u0441\u043e\u0442\u0430<\/td>\n22<\/td>\n\u0412\u044b\u0441\u043e\u0442\u0430<\/td>\n<\/tr>\n
2<\/td>\n2||\u0418\u043c\u044f<\/td>\n\u0421\u043e\u0441\u043d\u0430\u0301 \u0441\u0438\u0431\u0438\u0301\u0440\u0441\u043a\u0430\u044f \u043a\u0435\u0434\u0440\u043e\u0301\u0432\u0430\u044f<\/td>\n\u0418\u043c\u044f<\/td>\n<\/tr>\n
2<\/td>\n2||\u0421\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u043e<\/td>\n\u0421\u043e\u0441\u043d\u043e\u0432\u044b\u0435<\/td>\n\u0421\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u043e<\/td>\n<\/tr>\n<\/table>\n

\u0413\u043b\u043e\u0431\u0430\u043b \u0441 \u0434\u0430\u043d\u043d\u044b\u043c\u0438: <\/p>\n

USER>zw ^User.eavI ^User.eavI("idx1"," 186",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx1"," 186",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx1"," 22",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx1"," 22",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx1"," \u0412\u0410\u0421\u042f",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx1"," \u0421\u041e\u0421\u041d\u0410\u0301 \u0421\u0418\u0411\u0418\u0301\u0420\u0421\u041a\u0410\u042f \u041a\u0415\u0414\u0420\u041e\u0301\u0412\u0410\u042f",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx1"," \u0421\u041e\u0421\u041d\u041e\u0412\u042b\u0415",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx2","\u0412\u043e\u0437\u0440\u0430\u0441\u0442"," 186",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx2","\u0412\u043e\u0437\u0440\u0430\u0441\u0442"," 22",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx2","\u0412\u044b\u0441\u043e\u0442\u0430"," 22",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx2","\u0418\u043c\u044f"," \u0412\u0410\u0421\u042f",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx2","\u0418\u043c\u044f"," \u0421\u041e\u0421\u041d\u0410\u0301 \u0421\u0418\u0411\u0418\u0301\u0420\u0421\u041a\u0410\u042f \u041a\u0415\u0414\u0420\u041e\u0301\u0412\u0410\u042f",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx2","\u0420\u043e\u0441\u0442"," 186",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx2","\u0421\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u043e"," \u0421\u041e\u0421\u041d\u041e\u0412\u042b\u0415",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") <\/code><\/pre>\n
  \u0413\u043b\u043e\u0431\u0430\u043b \u0441 \u0438\u043d\u0434\u0435\u043a\u0441\u0430\u043c\u0438:   <\/p>\n
USER>zw ^User.eavI ^User.eavI("idx1"," 186",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx1"," 186",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx1"," 22",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx1"," 22",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx1"," \u0412\u0410\u0421\u042f",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx1"," \u0421\u041e\u0421\u041d\u0410\u0301 \u0421\u0418\u0411\u0418\u0301\u0420\u0421\u041a\u0410\u042f \u041a\u0415\u0414\u0420\u041e\u0301\u0412\u0410\u042f",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx1"," \u0421\u041e\u0421\u041d\u041e\u0412\u042b\u0415",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx2","\u0412\u043e\u0437\u0440\u0430\u0441\u0442"," 186",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx2","\u0412\u043e\u0437\u0440\u0430\u0441\u0442"," 22",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx2","\u0412\u044b\u0441\u043e\u0442\u0430"," 22",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx2","\u0418\u043c\u044f"," \u0412\u0410\u0421\u042f",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx2","\u0418\u043c\u044f"," \u0421\u041e\u0421\u041d\u0410\u0301 \u0421\u0418\u0411\u0418\u0301\u0420\u0421\u041a\u0410\u042f \u041a\u0415\u0414\u0420\u041e\u0301\u0412\u0410\u042f",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") ^User.eavI("idx2","\u0420\u043e\u0441\u0442"," 186",1)=$lb("","\u0427\u0435\u043b\u043e\u0432\u0435\u043a") ^User.eavI("idx2","\u0421\u0435\u043c\u0435\u0439\u0441\u0442\u0432\u043e"," \u0421\u041e\u0421\u041d\u041e\u0412\u042b\u0415",2)=$lb("","\u0414\u0435\u0440\u0435\u0432\u043e") <\/code><\/pre>\n
  \u0422\u0435\u043f\u0435\u0440\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u043c \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u0437\u0430\u043f\u0440\u043e\u0441:  <\/p>\n
select entity from eav where attributes->attr = 22  entity \u0427\u0435\u043b\u043e\u0432\u0435\u043a \u0414\u0435\u0440\u0435\u0432\u043e <\/code><\/pre>\n
  \u0417\u0430\u043f\u0440\u043e\u0441 \u043e\u0442\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0435\u0442, \u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442 \u043f\u043e\u043b\u043d\u043e\u0435 \u0441\u043a\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0435, \u0430 \u043d\u0435 \u043d\u0430\u0448\u0438 \u0438\u043d\u0434\u0435\u043a\u0441\u044b. \u0415\u0441\u043b\u0438 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c \u0432 SMP (\u041f\u043e\u0440\u0442\u0430\u043b \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0441\u0438\u0441\u0442\u0435\u043c\u043e\u0439) \u043d\u0430 \u043d\u0430\u0448\u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b, \u0442\u043e \u043c\u044b \u0432 \u043d\u0438\u0445 \u043d\u0435 \u043d\u0430\u0439\u0434\u0451\u043c idx1 \u0438 idx2, \u0445\u043e\u0442\u044f \u043a\u0430\u043a \u043c\u044b \u0440\u0430\u043d\u0435\u0435 \u0432\u0438\u0434\u0435\u043b\u0438, \u0434\u0430\u043d\u043d\u044b\u0435 \u0432 \u043d\u0438\u0445 \u0441\u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u043d\u044b.<\/p>\n
  \u042d\u0442\u043e \u043f\u0440\u043e\u0438\u0441\u0445\u043e\u0434\u0438\u0442 \u043f\u043e\u0442\u043e\u043c\u0443, \u0447\u0442\u043e SQL-\u044f\u0434\u0440\u043e \u00ab\u0432\u0438\u0434\u0438\u0442\u00bb \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u0435 \u0438\u043d\u0434\u0435\u043a\u0441\u044b \u043f\u043e \u043a\u043e\u043b\u043b\u0435\u043a\u0446\u0438\u044f\u043c-\u043c\u0430\u0441\u0441\u0438\u0432\u0430\u043c, \u043a\u043e\u0442\u043e\u0440\u044b\u0435 \u0431\u0430\u0437\u0438\u0440\u0443\u044e\u0442\u0441\u044f \u0438\u0441\u043a\u043b\u044e\u0447\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u043d\u0430 \u043f\u043e\u043b\u044f\u0445 \u043f\u043e\u0434\u0442\u0430\u0431\u043b\u0438\u0446\u044b-\u043c\u0430\u0441\u0441\u0438\u0432\u0430 \u0438 \u043e\u0431\u044f\u0437\u0430\u0442\u0435\u043b\u044c\u043d\u043e \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442 \u043a\u043b\u044e\u0447, \u0442.\u0435. propArray(KEY). \u041e\u0431\u0430 \u043d\u0430\u0448\u0438\u0445 \u0438\u043d\u0434\u0435\u043a\u0441\u0430 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442 \u043f\u043e\u043b\u0435 entity, \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u043e\u0442\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u0435\u0442 \u0432 \u043f\u043e\u0434\u0442\u0430\u0431\u043b\u0438\u0446\u0435 attributes.<\/p>\n
  \u0422\u0430\u043a\u0436\u0435 \u043d\u0435 \u0431\u0443\u0434\u0435\u0442 \u0432\u0438\u0434\u0435\u043d \u0438\u043d\u0434\u0435\u043a\u0441 Index<\/font> idx3 On attributes(ELEMENTS); \u043f\u043e\u0441\u043a\u043e\u043b\u044c\u043a\u0443 \u043e\u043d \u043d\u0435 \u0441\u043e\u0434\u0435\u0440\u0436\u0438\u0442 attributes(KEYS), \u0430 \u0432\u043e\u0442 \u0438\u043d\u0434\u0435\u043a\u0441\u044b:  <\/p>\n