×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Best RDBMS for Windows

Best RDBMS for Windows

Best RDBMS for Windows

(OP)
I am in the process of making a decision on the best platform for data warehousing on a Windows NT 4.0 server platform.  I know Oracle is a better package for managing intensive queries but since my backend platform is Windows NT, I am not sure how well Oracle works on it - I have heard that it runs slow.  I have heard better things about MS SQl Server on NT.  The NT server is not purchased yet, so I have some flexibility to buy the appropriate configuration to accomodate any special requirements.  Performance is my primary criteria for selection here, while using NT as the platform is my limitation.  Cognos is my front end querying tool.  Any direction on more recent evaluations or comparisons of these products would be very helpful to me.

RE: Best RDBMS for Windows

I'm sure there are variables that you haven't mentioned, however if you are going to be setting up a star schema and running intensive queries it may be worth your while to look at Redbrick from Informix. www.informix.com/redbrick/ ; The Redbrick Database product has outperformed others in key areas such as.

High performance data management – Redbrick supports high-speed data loading, high volume data loading within a single, one-pass load process that includes loading, referential integrity, and index building, for maximum efficiency and automation.  In addition, RedBrick supports the ability to continue processing user queries during the load to maintain maximum data availability to the end users.
  
Linear scalability for unlimited growth – Redbrick linear scalability enables growth without impacting performance and manageability.

Hardware Independence – It performs well regardless of the hardware choice and makes more efficient use of hardware resources.

Hope this helps in your search for the best solution.

RE: Best RDBMS for Windows

Oracle historically has performed better than SQL Server but SQL Server 7 and now SQL Server 2000 have bridged the gap.  Developement and maintenance costs will be lower with sql server, oracle will need a dedicated team to constantly look after the data warehouse.  SQL server also comes with transformation tools and an OLAP engine as addin s to the server.  Waht data volumns are you loooking at (number of rows in main fact/dimension tables).  I would personally stay well clear of any informix platforms, it is a second rate RDBMS, statistics can also be manipulated to suite the vendors.  Take a serious look at SQL Server, it will give you a more user/developer friendly solution and will keep hardware costs down.  Check out microsofts data warehousing web pages http://www.microsoft.com/technet/sql/default.asp

RE: Best RDBMS for Windows

If the most important factor is performance on NT and you have a star schema, then the Redbrick solution will outperform Oracle and SQL Server. Here's a ZDnet 3/20/2001 article that mentions some of the diffentiating factors that make it superior in performance.
http://www.zdnet.com/intweek/stories/news/0,4164,2698855,00.html

RE: Best RDBMS for Windows

run.  I still advice against an informix based solution, a SQL server solution will cause you least pain and will obviously be better supported by the operating system.  Informix for NT was shoe horned to fit from its original unix platform.  The aboe article talks about load performace not querying and provides no benchmarking.  I suggest you run a Proof of Concept of SQl server 2000 or 7 and see how perfromance is.  In you can supply data volumns, i will happily pass on my experience of expected performance

RE: Best RDBMS for Windows

That's the best suggestion, if you want to know how it will work in your environment, test it, and see which one is the best fit.

RE: Best RDBMS for Windows

Hi,
     You can order a FREE copy of a Fully functional Teradata Database Demo CD at

    http://www.ncr.com/products/software/teradata_nt.htm

the only catch is you can't create a database bigger than 1 Gig.    It runs under Windows NT or Windows 2000.    

It comes with a small sample database and some canned applications, but you can create your own databases, tables, run your own queries.

Write you own Visual Basic, ODBC or JDBC  Applications against if you want.

Anything you could do against a real production version of Teradata, just don't use it for Production work.  Read the End User License Agreement.

See if you like it.   Did I mention it was FREE, No strings attached ( expect you have to give us a mailing address, so we can mail it out so I guess there is a string ).   Read the Privacy Policy on the WEB page if you have any reservations.

Like suggested above kick the tires of all the candidates and see which one you like.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close