Hide Zen home . ... Extent is a shortest and non-nested sequence of words, which satisfy a query . ... We don't consider normalization of document weight to 1, since we have no global information about document collection. w{i}, len{i} - weight and length of i-th extent . ... Next - the number of unique extents. freq{i} - frequency of i-th extent . We could consider strict and soft uniqueness of an extent, depending on how do we consider the order of words in extent. ... 2 - document length . ...
Hide Zen home . ... Large scale survey projects produce huge amount of data, which needs to be processed and organized in databases to provide access by astronomical community. There are many problems in the current state of art of accessing large astronomical databases and organizing programmatic access to the distributed and diverse data, which Virtual Observatory initiative should eventually to solve. ... Nowadays, it's not unusual to work with billions of objects in terabyte-sized database. ...
... GiST . ... GiST is now concurrent and have recovery support ! The gist of our work is that all GiST based extensions, such as tsearch2, ltree, intarray, PosGIS automatically inherit concurrency and recovery support after upgrading of PostgreSQL software and thereby provides applications an industrial strength. ... However, current GiST implementation (as of 8.0.3) still doesn't support concurrent access, transactional isolation or recovery, which PostgreSQL provides for B-tree access method. ...
Hide Zen home . ... The setup of the infrastructure with one CAS application server (Backend) and one separated dedicated DB server(DB) with PostgreSQL. ... After that we should create the user who will work with CAS and setup his password: postgres@xxx:~$ createuser -P cas_user Enter password for new role: Enter it again: Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) n Shall the new role be allowed to create more new roles? (y/n) n CREATE ROLE . ...
. Hide Zen home . Pgsql . GiST . GIN . SP-GiST . Tsearch2 . SAI RVO . SAI CAS . SOA . Supernovae . TODO . HomePage . Astronet . Google . Rambler . Yandex . Oddmuse . E-R-E dict . Index . edit . ВО . Виртуальная Обсерватория . Вебсервис . Программа . SiteMap Changes HowTo 2016-04-11 2016-04-10 Blog . 0 Comments on vo glossary This page is read-only View other revisions Administration . Last edited 2005-09-20 18:19 UTC by megera . Search: . Zen, 2003-2007
Hide Zen home . ... Parameters: table and index descriptors . ... Parameters: index descriptor, value, pointer to table record . ... Also rebuilds internal keys if needed (index is locked when rebuilding). ... These are base methods for search in index - create scan, finish scan, repeat scan. ... Restore one WAL record. Parameters: LSN (LogSequenceNumber), WAL record . ... GiST has no direct access to tables, only via pointers ( the number of page and the number of record on the page) to records. ...
... SELECT coordinates, (coordinates <-> '5.0,5.0'::point) AS dist FROM spots ORDER BY dist ASC LIMIT 10; coordinates | ... CREATE INDEX spots_idx ON spots USING gist (coordinates,to_tsvector('french',address)); =# SELECT id, address, (coordinates <->'(2.29470491409302,48.858263472125)'::point) AS dist FROM spots WHERE to_tsvector('french',address) @@ to_tsquery('french','mars') ORDER BY coordinates <-> '(2.29470491409302,48.858263472125)'::point LIMIT 10; 8.4.2 166.089 ms 5dev+knngist-0.6 2.758 ms . ...
Hide Zen home . ... GiST . GIN . ... В докладе представлен опыт участия российских разработчиков в крупном проекте с открытым кодом, СУБД PostgreSQL. Авторы входят в число ведущих разработчиков, ими реализованы многие важные подсистемы СУБД PostgreSQL. ... Реализация поддержки локализации (Олег Бартунов) позволила полноценно использовать СУБД PostgreSQL в non-ASCII странах, что способствовало распространению проекта. ... Федов Сигаев (2000 x2013; ) - GiST, GIN, полнотекстовый поиск, x2026; . ...
... arxiv=# select papers.title, array_agg(kw.name) from papers join kw on papers.fts @@ kw.ts and papers.id=2 group by papers.title; title | ... CREATE OR REPLACE FUNCTION ts_stat(tsvector, weights text, OUT word text, OUT ndoc integer, OUT nentry integer) RETURNS SETOF record AS $$ SELECT ts_stat('SELECT ' || quote_literal( $1::text ) || '::tsvector', quote_literal( $2::text) ); $$ LANGUAGE SQL RETURNS NULL ON NULL INPUT IMMUTABLE; select ARRAY ( select (ts_stat(fts,'*')).word from papers where id=2);...
. Hide Zen home . Pgsql . GiST . GIN . SP-GiST . Tsearch2 . SAI RVO . SAI CAS . SOA . Supernovae . TODO . HomePage . Astronet . Google . Rambler . Yandex . Oddmuse . E-R-E dict . Index . edit . Just upgraded my Nikon D90 to D700. http://www.flickr.com/photos/obartunov/4155280161/sizes/o/ . SiteMap Changes HowTo 2016-04-11 2016-04-10 Blog . 0 Comments on 2009-12-03 This page is read-only View other revisions Administration . Last edited 2009-12-03 17:31 UTC by mira.sai.msu.ru . Search: . Zen, 2003-2007
Hide Zen home . ... This october three astronomers (I and two my colleagues) trekked in Everest area - for 15 days we did Kathmandu->Lukla - Phakding - Namche Bazaar - Tengboche - Chukhung (Chukhung Ri)-Kongma La (pass) - Lobuche - Gorakshep (Kala Patar) - Dzhongla - Cho La (pass) - Dragnag - Gokyo (Gokyo Ri, fifth lake Cho Oyu) - Renjo La (pass) -Molerung - Namche Bazaar - Lukla x2192; Kathmandu. ... 0 Comments on 2009-11-05 This page is read-only View other revisions Administration . ...
Hide Zen home . ... GiST . ... SAI RVO . SAI CAS . ... HomePage . ... Что такое [GiST] ? ... Что бы это значило ? term2 . ... pre>Здесь все должно быть preformatted</pre> . Строчка с отступом . ... 1 cell . ... 0 Comments on HomePage This page is read-only View other revisions Administration . ... Zen, 2003-2007 ...
Hide Zen home . ... SAI RVO . SAI CAS . ... Index . ... Some notes about Generic search engine. [[gts_crawler ? ... gts_indexer ? creating index . gts_searcher ? search engine . ... SiteMap Changes HowTo 2016-04-11 2016-04-10 Blog . 0 Comments on GTSearch This page is read-only View other revisions Administration . Last edited 2005-05-13 15:23 UTC by megera (diff) . Search: . Zen, 2003-2007 ...
Hide Zen home . ... GiST . GIN . ... SAI RVO . SAI CAS . ... Astronet . ... E-R-E dict . ... edit . ... 0 Comments on SideBar This page is read-only View other revisions Administration . Last edited 2011-10-07 20:40 UTC by 95-28-123-154.broadband.corbina.ru (diff) . ... Zen, 2003-2007 ...
. Hide Zen home . Pgsql . GiST . GIN . SP-GiST . Tsearch2 . SAI RVO . SAI CAS . SOA . Supernovae . TODO . HomePage . Astronet . Google . Rambler . Yandex . Oddmuse . E-R-E dict . Index . edit . XA exposed PART I . XA exposed PART II . XA exposed PART III . XA exposed PART III.1 . SiteMap Changes HowTo 2016-04-11 2016-04-10 Blog . 0 Comments on DB This page is read-only View other revisions Administration . Last edited 2005-12-21 21:24 UTC by megera (diff) . Search: . Zen, 2003-2007
Hide Zen home . ... GiST . ... It could be considered as ancestor of "Relational Extenders" in DB2, Cartridges in Oracle and DataBlade in Informix. extending and improving of GiST interfaces to make easier developing GiST based extensions and implementation of ADT not supported by current implementation of GiST core. ... Figure out how to configure parameters to GiST index supported functions, for example, change size of signature SIGLENINT for tsearch2 index, which could greatly improve performance. ...
... Беспрецендентный рост популярных сервисов (количественный и качественный), потребовал дальнейшего изменения архитектуры в сторону использования серверов с большим количеством оперативной памяти (128 Gb уже не редкость) и программной архитектуры систем управления базами данных, ориентированных на работу в оперативной памяти, а не на работу с относительно медленными дисками. ... Важной задачей для таких баз данных является сохранность данных после выключения питания и быстрое возобновление работы. ...
Hide Zen home . ... Пекулярные (Irregular ?) непеременные звезды. ... Аномальные смещения объектов. ... Таблицы типов объектов. ... Необходимо провести отождествления: x2013; одной и той же звезды в разных сканах; x2013; звезд со звездами во внешних каталогах; x2013; звезд с отсчетами фона; x2013; отсчетов фона из разных сканов друг с другом; x2013; момента измерения объекта (звезды, ИСЗ, протяж.объекта, фона) с состоянием аппаратуры на момент измерения (по временнОй телеметрической записи). ...