What DataBase features for a DWH should I look for.

View previous topic View next topic Go down

What DataBase features for a DWH should I look for.

Post  hgrutter on Mon Dec 31, 2012 8:02 am

Hi,

I am trying to select the proper database product for our yet to build DWH.

What are the most important product features to look for in a DWH database and why?

Ofcourse we will also look for general items like availability, scalability en existing knowledge in de organisation.

Thanks,

Hans


Last edited by hgrutter on Wed Jan 02, 2013 4:11 am; edited 1 time in total (Reason for editing : Emphasis on the question and to correct a spelling error.)

hgrutter

Posts : 3
Join date : 2012-12-28

View user profile

Back to top Go down

Re: What DataBase features for a DWH should I look for.

Post  BoxesAndLines on Mon Dec 31, 2012 12:04 pm

All of the major players to those things, e.g. Teradata, DB2, Oracle, and SQL Server. The drivers come down to usage. Huge amounts of data, normalized data, statistical analysis, and lots of money companies, tend to choose Teradata. A lot of data, dimensional and relational, lots of money, some statistical analysis, companies tend to choose Oracle or DB2. Everyone else chooses SQL Server except for the boutique shops using columnar or some other technique.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: What DataBase features for a DWH should I look for.

Post  ngalemmo on Mon Dec 31, 2012 6:12 pm

What are you trying to build? How much data? What industry? What service levels?

Most companies start with what they currently use and it works out fine (unless you are using mainframe DB2... ugh!). Familiarity with a particular DBMS goes a long way to smoothing the path for a successful first go.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: What DataBase features for a DWH should I look for.

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum