Обсуждение: advantages of multiple db's

Поиск
Список
Период
Сортировка

advantages of multiple db's

От
"Little, Douglas"
Дата:

Hi,

 

We have 1 db with everything in our entire enterprise in it (It’s a data warehouse).  What are some of the disadvantages of using multiple db’s?

 

Can we join across db’s?

 

Doug Little

 

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Вложения

Re: advantages of multiple db's

От
"Plugge, Joe R."
Дата:

Postgres does not natively do cross joins, you can however use a third party tool called dblink

 

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Little, Douglas
Sent: Thursday, October 28, 2010 8:35 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] advantages of multiple db's

 

Hi,

 

We have 1 db with everything in our entire enterprise in it (It’s a data warehouse).  What are some of the disadvantages of using multiple db’s?

 

Can we join across db’s?

 

Doug Little

 

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 

Вложения

Re: advantages of multiple db's

От
Sergey Konoplev
Дата:
HI,

On 28 October 2010 17:34, Little, Douglas <DOUGLAS.LITTLE@orbitz.com> wrote:

Hi,

 

We have 1 db with everything in our entire enterprise in it (It’s a data warehouse).  What are some of the disadvantages of using multiple db’s?

 

Can we join across db’s?


I think this article is a good start point to find the answer on this questions http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
 

 

Doug Little

 

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

 cid:image001.jpg@01CABEC8.D4980670  orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com

 




--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp
Вложения