Ask the Expert

Oracle versus SQL Server for data warehouse

Given that money is not neccessarily the determining factor, which platform, MS SQL Server or Oracle, would you suggest as the foundation of a data warehouse/BI solution? We are looking to implement a data warehouse to analyze student test scores and present data to end users.

    Requires Free Membership to View

The decision on SQL Server versus Oracle comes down to the size of your implementation. Oracle can handle data warehouses up into the 1-2TB range before you have to really start getting advanced in your performance tuning tactics. SQL Server's ceiling is well below that level.

Oracle will run fine on the Wintel platform as well as any of the mainstream Unix platforms. SQL Server is is much more tied into the Wintel platform.


This was first published in March 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: