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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Best RDBMS for Windows
- Thread starter run
- Start date
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. 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.
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.
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
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.
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
Hi,
You can order a FREE copy of a Fully functional Teradata Database Demo CD at
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.
You can order a FREE copy of a Fully functional Teradata Database Demo CD at
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.
- Status
Similar threads
- Locked
- Question
- Locked
- Question