Re: Статьи по использованию PostgreSQL

Добрый день

> Мы используем постгрес в астрономиии - vo.astronet.ru. Там у нас миллиарды
> объектов в постгресе.

Про этот сайт я знаю. Мне хотелось бы найти статьи на которые можно
сослаться :), желательно в приличном журнале.

То есть написать фразу вида: открытая БД PostgreSQL широко используется
для обеспечения физических экспериментов для хранения большого объёма
данных [ссылка].

С уважением
Евгений

On Tue, 17 Jun 2008, Oleg Bartunov wrote:

> Мы используем постгрес в астрономиии - vo.astronet.ru. Там у нас миллиарды
> объектов в постгресе.
>
> On Tue, 17 Jun 2008, Evgeny M. Baldin wrote:
>
>> Добрый день
>>
>> Хотелось бы посмотреть статьи на тему использования PostgreSQL для
>> обеспечения физического эксперимента. Базы данных для астрономии или
>> физики высоких энергий например. Просто про использование БД тоже пойдёт.
>>
>> На arxiv по заголовку нашёл только вот это: http://arxiv.org/abs/0711.0342
>>
>> С уважением
>> Евгений
>>
>
> Regards,
> Oleg
> _____________________________________________________________
> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
> Sternberg Astronomical Institute, Moscow University, Russia
> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(495)939-16-83, +007(495)939-23-83
>
>From pgsql-ru-general-owner(at)postgresql(dot)org Tue Jun 17 10:56:24 2008
Received: from localhost (unknown [200.46.204.183])
by developer.postgresql.org (Postfix) with ESMTP id DE70D2E003C
for <pgsql-ru-general-postgresql(dot)org(at)developer(dot)postgresql(dot)org>; Tue, 17 Jun 2008 10:56:22 -0300 (ADT)
Received: from developer.postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
with ESMTP id 11067-03
for <pgsql-ru-general-postgresql(dot)org(at)developer(dot)postgresql(dot)org>;
Tue, 17 Jun 2008 10:56:11 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sn.sai.msu.ru (sn.sai.msu.ru [195.208.220.215])
by developer.postgresql.org (Postfix) with ESMTP id F35612E002E
for <pgsql-ru-general(at)postgresql(dot)org>; Tue, 17 Jun 2008 10:56:15 -0300 (ADT)
Received: from sn.sai.msu.ru (localhost [127.0.0.1])
by sn.sai.msu.ru (8.14.1/8.12.8) with ESMTP id m5HDu93Q009437;
Tue, 17 Jun 2008 17:56:09 +0400
Received: from localhost (megera(at)localhost)
by sn.sai.msu.ru (8.14.1/8.12.8/Submit) with ESMTP id m5HDu9WP009434;
Tue, 17 Jun 2008 17:56:09 +0400
X-Authentication-Warning: sn.sai.msu.ru: megera owned process doing -bs
Date: Tue, 17 Jun 2008 17:56:09 +0400 (MSD)
From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
X-X-Sender: megera(at)sn(dot)sai(dot)msu(dot)ru
To: "Evgeny M. Baldin" <E(dot)M(dot)Baldin(at)inp(dot)nsk(dot)su>
cc: pgsql-ru-general(at)postgresql(dot)org
Subject: Re: =?koi8-r?Q?=F3=D4=C1=D4=D8=C9_=D0=CF_=C9=D3=D0=CF=CC=D8=DA=CF=D7=C1?=
=?koi8-r?Q?=CE=C9=C0_PostgreSQL?=
In-Reply-To: <Pine(dot)LNX(dot)4(dot)64(dot)0806172036050(dot)26017(at)star(dot)inp(dot)nsk(dot)su>
Message-ID: <Pine(dot)LNX(dot)4(dot)64(dot)0806171752360(dot)11363(at)sn(dot)sai(dot)msu(dot)ru>
References: <Pine(dot)LNX(dot)4(dot)64(dot)0806171810430(dot)24586(at)star(dot)inp(dot)nsk(dot)su>
<Pine(dot)LNX(dot)4(dot)64(dot)0806171719520(dot)11363(at)sn(dot)sai(dot)msu(dot)ru>
<Pine(dot)LNX(dot)4(dot)64(dot)0806172036050(dot)26017(at)star(dot)inp(dot)nsk(dot)su>
MIME-Version: 1.0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.107 tagged_above=0 required=5 tests=AWL=-1.018,
DNS_FROM_RFC_BOGUSMX=2.125, RCVD_IN_DNSWL_LOW=-1
X-Spam-Level:
Content-Type: TEXT/PLAIN; charset=koi8-r; format=flowed
Content-Transfer-Encoding: QUOTED-PRINTABLE
X-Archive-Number: 200806/8
X-Sequence-Number: 826

=EE=D5, =CE=C1=D0=D2=C9=CD=C5=D2,

http://scholar.google.com/scholar?hl=3Den&lr=3D&q=3D+postgresql+astronomy&b=
tnG=3DSearch

Koposov S., Bartunov O.S., "Q3C, Quad Tree Cube - The new sky-indexing conc=
ept for huge astronomical catalogues and its realization for main astronomi=
cal queries (cone search and XMatch) in open source database PostgreSQL", i=
n Astronomical Data Analysis Software and Systems XV ASP Conference Series,=
2005 C. Gabriel, C. Arviset, D. Ponz and E. Solano, eds.=20
"SAI Catalogue Access Services", Koposov, S. E.; Bartunov, O. S. The Virtua=
l Observatory in Action: New Science, New Technology, and Next Generation F=
acilities, 26th meeting of the IAU, Special Session 3, 17-18, 21-22 August,=
2006 in Prague, Czech Republic, SPS3, #19

NASA

Satellite Science Data Processing with PostgreSQL

http://www.pgcon.org/2008/schedule/events/108.en.html

On Tue, 17 Jun 2008, Evgeny M. Baldin wrote:

> =E4=CF=C2=D2=D9=CA =C4=C5=CE=D8
>
>> =ED=D9 =C9=D3=D0=CF=CC=D8=DA=D5=C5=CD =D0=CF=D3=D4=C7=D2=C5=D3 =D7 =C1=
=D3=D4=D2=CF=CE=CF=CD=C9=C9=C9 - vo.astronet.ru. =F4=C1=CD =D5 =CE=C1=D3 =
=CD=C9=CC=CC=C9=C1=D2=C4=D9=20
>> =CF=C2=DF=C5=CB=D4=CF=D7 =D7 =D0=CF=D3=D4=C7=D2=C5=D3=C5.
>
> =F0=D2=CF =DC=D4=CF=D4 =D3=C1=CA=D4 =D1 =DA=CE=C1=C0. =ED=CE=C5 =C8=CF=D4=
=C5=CC=CF=D3=D8 =C2=D9 =CE=C1=CA=D4=C9 =D3=D4=C1=D4=D8=C9 =CE=C1 =CB=CF=D4=
=CF=D2=D9=C5 =CD=CF=D6=CE=CF=20
> =D3=CF=D3=CC=C1=D4=D8=D3=D1 :), =D6=C5=CC=C1=D4=C5=CC=D8=CE=CF =D7 =D0=D2=
=C9=CC=C9=DE=CE=CF=CD =D6=D5=D2=CE=C1=CC=C5.
>
> =F4=CF =C5=D3=D4=D8 =CE=C1=D0=C9=D3=C1=D4=D8 =C6=D2=C1=DA=D5 =D7=C9=C4=C1=
: =CF=D4=CB=D2=D9=D4=C1=D1 =E2=E4 PostgreSQL =DB=C9=D2=CF=CB=CF =C9=D3=D0=
=CF=CC=D8=DA=D5=C5=D4=D3=D1 =C4=CC=D1=20
> =CF=C2=C5=D3=D0=C5=DE=C5=CE=C9=D1 =C6=C9=DA=C9=DE=C5=D3=CB=C9=C8 =DC=CB=
=D3=D0=C5=D2=C9=CD=C5=CE=D4=CF=D7 =C4=CC=D1 =C8=D2=C1=CE=C5=CE=C9=D1 =C2=CF=
=CC=D8=DB=CF=C7=CF =CF=C2=DF=A3=CD=C1 =C4=C1=CE=CE=D9=C8=20
> [=D3=D3=D9=CC=CB=C1].
>
> =F3 =D5=D7=C1=D6=C5=CE=C9=C5=CD
> =E5=D7=C7=C5=CE=C9=CA
>
>
> On Tue, 17 Jun 2008, Oleg Bartunov wrote:
>
>> =ED=D9 =C9=D3=D0=CF=CC=D8=DA=D5=C5=CD =D0=CF=D3=D4=C7=D2=C5=D3 =D7 =C1=
=D3=D4=D2=CF=CE=CF=CD=C9=C9=C9 - vo.astronet.ru. =F4=C1=CD =D5 =CE=C1=D3 =
=CD=C9=CC=CC=C9=C1=D2=C4=D9=20
>> =CF=C2=DF=C5=CB=D4=CF=D7 =D7 =D0=CF=D3=D4=C7=D2=C5=D3=C5.
>>=20
>> On Tue, 17 Jun 2008, Evgeny M. Baldin wrote:
>>
>>> =E4=CF=C2=D2=D9=CA =C4=C5=CE=D8
>>>
>>> =E8=CF=D4=C5=CC=CF=D3=D8 =C2=D9 =D0=CF=D3=CD=CF=D4=D2=C5=D4=D8 =D3=D4=
=C1=D4=D8=C9 =CE=C1 =D4=C5=CD=D5 =C9=D3=D0=CF=CC=D8=DA=CF=D7=C1=CE=C9=D1 Po=
stgreSQL =C4=CC=D1
>>> =CF=C2=C5=D3=D0=C5=DE=C5=CE=C9=D1 =C6=C9=DA=C9=DE=C5=D3=CB=CF=C7=CF =
=DC=CB=D3=D0=C5=D2=C9=CD=C5=CE=D4=C1. =E2=C1=DA=D9 =C4=C1=CE=CE=D9=C8 =C4=
=CC=D1 =C1=D3=D4=D2=CF=CE=CF=CD=C9=C9 =C9=CC=C9
>>> =C6=C9=DA=C9=CB=C9 =D7=D9=D3=CF=CB=C9=C8 =DC=CE=C5=D2=C7=C9=CA =CE=C1=
=D0=D2=C9=CD=C5=D2. =F0=D2=CF=D3=D4=CF =D0=D2=CF =C9=D3=D0=CF=CC=D8=DA=CF=
=D7=C1=CE=C9=C5 =E2=E4 =D4=CF=D6=C5 =D0=CF=CA=C4=A3=D4.
>>>
>>> =EE=C1 arxiv =D0=CF =DA=C1=C7=CF=CC=CF=D7=CB=D5 =CE=C1=DB=A3=CC =D4=CF=
=CC=D8=CB=CF =D7=CF=D4 =DC=D4=CF:=20
>>> http://arxiv.org/abs/0711.0342
>>>
>>> =F3 =D5=D7=C1=D6=C5=CE=C9=C5=CD
>>> =E5=D7=C7=C5=CE=C9=CA
>>>=20
>>
>> Regards,
>> Oleg
>> _____________________________________________________________
>> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
>> Sternberg Astronomical Institute, Moscow University, Russia
>> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
>> phone: +007(495)939-16-83, +007(495)939-23-83
>>=20
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83=