Are these tables too big for SQL Server or Oracle

Posted by Jeffrey Cameron on Stack Overflow See other posts from Stack Overflow or by Jeffrey Cameron
Published on 2009-11-26T15:36:36Z Indexed on 2010/04/18 11:53 UTC
Read the original article Hit count: 377

Hey all,

I'm not much of a database guru so I would like some advice.

Background

We have 4 tables that are currently stored in Sybase IQ. We don't currently have any choice over this, we're basically stuck with what someone else decided for us. Sybase IQ is a column-oriented database that is perfect for a data warehouse. Unfortunately, my project needs to do a lot of transactional updating (we're more of an operational database) so I'm looking for more mainstream alternatives.

Question

  1. Given these tables' dimensions, would anyone consider SQL Server or Oracle to be a viable alternative?

    • Table 1 : 172 columns * 32 million rows
    • Table 2 : 453 columns * 7 million rows
    • Table 3 : 112 columns * 13 million rows
    • Table 4 : 147 columns * 2.5 million rows
  2. Given the size of data what are the things I should be concerned about in terms of database choice, server configuration, memory, platform, etc.?

© Stack Overflow or respective owner

Related posts about sybase-iq

Related posts about sql-server