Thread: 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
orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com
Attachment
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
orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com
Attachment
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
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