Re: Data Warehouse

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Data Warehouse
Дата
Msg-id 87odtoxziw.fsf@wolfe.cbbrowne.com
обсуждение исходный текст
Ответ на Data Warehouse  ("Jaime Casanova" <systemguards@gmail.com>)
Список pgsql-general
In an attempt to throw the authorities off his trail, systemguards@gmail.com ("Jaime Casanova") transmitted:
> Anyone here knows if exists a data warehouse software that uses
> postgresql?  if it is open source that will be a plus...

There tends to be 3 parts to this...

1.  Data storage

The RDBMS of your choice...

2.  ETL - Loading data into the data store.

Often this is a custom application, as it must be attuned to your
unique data sources.

Bizgres spun off something called KETL; some might consider Perl or
Python to be "the ETL software."

3.  Query tools

The Bizgres guys have put together some tools for this; you may also
be able to hook up commercial tools from Cognos and Business Objects
and such.

Or build your own...
--
let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/lisp.html
"Did you  ever walk in a  room and forget  why you walked in?  I think
that's how dogs spend their lives." -- Sue Murphy

В списке pgsql-general по дате отправления:

Предыдущее
От: Jack Orenstein
Дата:
Сообщение: Re: How to use SPI_saveplan
Следующее
От: Jack Orenstein
Дата:
Сообщение: Re: Idle in transaction state.