Hide Zen home . ... Apache Tomcat 5.5.x (Tomcat 5.0.x will not work) ( http://tomcat.apache.org/ ) . ... Apache Axis 1.3.x (1.3.x is recommended, but 1.2.x may work, I don't know) ( http://ws.apache.org/axis/ ) . ... Apache Commons FileUpload ( http://jakarta.apache.org/commons/fileupload/ ) . ... Put the jar file of log4j in $TOMCAT_HOME/common/lib (symbolic link will be ok). Download the Commons-Logging installation and put the jar file "commons-logging.jar" also in $TOMCAT_HOME/common/lib. ...
Hide Zen home . ... For other stars, Ndet is 2 or more. / info / column column name = Flags datatype = char unit = description Flags on object / description info . denotes the absence of any flag M = Existence in a proper motion catalog, s = object on a diffraction spike Y = Correlation with YS4.0 catalog (Monet, in prep.) / info / column column ... 0 Comments on XMLCatalog This page is read-only View other revisions Administration . ... Zen, 2003-2007 ...
Hide Zen home . ... SAI CAS . ... The motivation to build CAS (catalog access service) . Any serious VO application requires access to data and ability to do basic operations with them like cone search, crossmatch queries. So, we need to develop a system, which hosts catalogues and their metadata. ... Build the system allowing to store almost any astronomical catalogue, put it in the system using simple API, get the data and metadata about it. ... Search: . Zen, 2003-2007 ...
Hide Zen home . ... Index . ... Also, it supports full index scan. ... Prefix search: words=# select count(*) from words where w1 like 'a%'; count ------- 15491 (1 row) Time: 7.502 ms words=# select count(*) from words where w2 like 'a%'; count ------- 15491 (1 row) Time: 31.152 ms . Wildcard search: words=# select count(*) from words where w1 like '%asd%'; count ------- 26 (1 row) Time: 147.308 ms words=# select count(*) from words where w2 like '%asd%'; count ------- 26 (1 row) Time: 0.339 ms . ...
Hide Zen home . ... Index . ... Get latest source of plantuner from GIT Repository . ... Indexes: id_idx btree (id) id_idx2 btree (id) =# explain select id from test where id=1; QUERY PLAN ----------------------------------------------------------------------- Bitmap Heap Scan on test ( cost = 4.34 ..15.03 rows =12 width =4) Recheck Cond: (id = 1) - Bitmap Index Scan on id_idx2 ( cost =0.00.. 4.34 rows =12 width =0) Index Cond: (id = 1) (4 ... Zen, 2003-2007 ...
Hide Zen home . ... Function get_covers(tsvector,query) marks extents (from tsvector ), which satisfies the search query (extents could overlap). The markup is as follow: {# text }#, where # - is the extent number. ... Example: test=# select get_covers(to_tsvector('1 2 3 4 5 6 1 3 1 9 34 2'),'1&3'); get_covers --------------------------------------------------- {1 1 2 {2 3 }1 4 5 6 {3 1 }2 {4 3 }3 1 }4 9 34 2 (1 row) . ... First example could be obtained using get_covers(fts,query,0) . ...
Hide Zen home . ... GiST . ... SAI RVO . SAI CAS . ... edit . pgSphere provides spherical data types, functions and operators for PostgreSQL. This project is hosted @ http://gborg.postgresql.org/project/pgsphere/ . ... Oleg Bartunov (project manager) . Teodor Sigaev (gist support) . ... Edit . ... Spatial Queries - a list of typical spatial queries . ... 0 Comments on pg sphere This page is read-only View other revisions Administration . ... Zen, 2003-2007 ...
... Function pageSplit is reccurrent and could split page by more than 2 pages, which could be necessary if keys have different lengths or more than one key are inserted (in such situation, user defined function pickSplit cannot guarantee free space on page ). findLeaf(new-key) push( stack , [root, 0]) // page , LSN while(true) top = top of stack latch( top - page , S-mode ) top - lsn = top - page - ... 0 Comments on GiST Algo This page is read-only View other revisions Administration ...
Hide Zen home . ... SAI RVO . ... Фрагмент - это кусок текста, который содержит поисковые слова. ... Началом фрагмента может быть только слово, за очень редким исключением . Фрагмент может оканчиваться только на слово, за редким исключением. ... Фрагмент должен содержать все слова из запроса, за редким исключением. Порядок фрагментов не должен меняться. 3,4 может быть несколько жестковаты, можно добавить слово или цифры. 4 можно усилить, что фрагмент не может оканчиваться на "короткое" слово . ...
Hide Zen home . ... bla-bla about UCD and VO standards. name meta.id . coordinates pos.eq.ra;pos.eq.dec . ... position angle pos.posAng . inclination angle . ... name meta.id . ... date of maximum light time.epoch . date of discovery . ... 0 Comments on sncat ucd This page is read-only View other revisions Administration . ... Zen, 2003-2007 ...
Hide Zen home . ... PostgreSQL: the best DBMS solution for astronomy and astrophysics. We consider PostgreSQL, an open-source RDBMS distributed under BSD license, as one of the best database solutions for astronomical and astrophysical tasks. ... We present two backend programming modules. pgSphere, the ready-for-use contribution module for PostgreSQL, offers the capability for dealing with geometric objects in spherical coordinates. ... Zen, 2003-2007 ...
... This module provides unaccent text search dictionary and function to remove accents from input text. ... Unaccent dictionary does nothing and returns NULL. (lexeme 'Hotels' will be passed to the next dictionary if any) =# select ts_lexize('unaccent','Hotels') is NULL; ?column? ---------- t (1 row) . ... Unaccent dictionary removes accent and returns 'Hotel'. (lexeme 'Hotel' will be passed to the next dictionary if any) =# select ts_lexize('unaccent','HУДtel') is NULL; ?column? ---------- f (1 row) ....
Hide Zen home . ... The main idea is to create inverted index for large read-only archive and preserve full compatibility with tsearch2 (parsers, dictionaries, ranking), so one could combine results (UNION) of searching on two archives - read-only archive by tsearchd and current one by tsearch2 and rank results. ... However, calculating of rank requires reading tsvector for all rows in results, so it could slow down select. 1. tsearchd daemon should be started before creating creating inverted index. ...
Hide Zen home . ... TODO . ... Prefix search - . Substring search - could be realized with special dictionary. Needs special ranking function. Exact search - search exact form of a word without stemming. ... N-gram search - probably, special variant of a substring search. ... translate(word, dic1, dic2) - translation dictionary, which returns word, normalized by dic1, and its translation (dic2). ... 0 Comments on FTS Todo This page is read-only View other revisions Administration . ...
... Виртуальная Обсерватория - новая концепция организации доступа к астрономическим данным любого рода и средствам их обработки и анализа с применением современных информационных технологий. Методы доступа к данным ориентированы в первую очередь на доступ из програм, а не на интерактивное использование. ... В конце 90-х крупные центры астрономических данных, такие как CDS (France), CaDC (Canada), STScI (USA) и другие предложили начать разработку стандартов для доступа к астрономическим данным. ...
Hide Zen home . ... Также, может переводиться как "отношение", больше как математическая абстракция. vacuum - сборка мусора, можно использовать в тексте, но для сообщений как-то не очень хорошо смотрится :) По-смыслу - это оптимизация места на диске за счет удаления ненужных записей. check constraints - проверка на целостность. это ограничения, накладываемые на значения атрибута, обеспечивающие целостность. ->constraints 1> ограничения целостности. ... backup - резервная копия . ... Zen, 2003-2007 ...
Hide Zen home . ... GiST . ... desc') - sort intarray test =# select sort ('{1,2,3}':: int [],'desc'); sort --------- {3,2,1} (1 row) int [] sort ( int []) - sort in ascending order int [] sort _asc( int []), sort _desc( int []) - shortcuts for sort int [] uniq( int []) - returns unique elements test =# select uniq( sort ('{1,2,3,2,1}':: int [])); uniq --------- {1,2,3} (1 row) int idx( int - returns intarray - union of arguments int[] | ... Zen, 2003-2007 ...