Re: RDBMS Comparisons and Their Statistics

> I am in the process of evaluating a Relational Database (ORACLE, SYBASE, > Informix, SQL Server) for using as Backend in our project. Our project > will contain number of modules (10 Modules) and the application will be > integrated with World Wide Web(WWW). My company is an Internet Service > Provider. > > Is there anybody, who can help me to find the Best RDBMS. I require There isn't really a "best" RDBMS. I'll offer some thoughts on Informix.... > Information like:- > > 1. CPU Utilization and Response Time of the Database. Very scalable in SMP/MPP/shared nothing environments. Informix is particularly efficient in the Unix environment. Response time depends on toomany external factors. > 2. World Market share of RDBMS in Percentage Second biggest based on $s, I think the biggest on number of licences (Unix only). > 3. Transaction Per Minute (tpmC) These vary platform to plafrom. But Informix is typically used by hardware vendors as the RDBMS of choice for TpmC benchmarks. > 4. Compatibility with hetrogeneous systems There are gateways available for all other databases, and there is an XA kit available. > 5. Integration capability with Internet/Intranet tools. Excellent. Also check out Illustra, which will be merged with the mainstrem Informix server by the end of the year. > 6. Integration capability with Network Management Software Like what? > 7. Scalability Outstanding. > 8. Connectivity to Off-The-Shelf Applications (like Accounting) There are bazillions of apps in the ISV catalogue. > 9. Downtime. Capable of 24x7 operation. > 10. Reliability. Supports disk mirroring, data replication, etc. > 11. Vendor Support. It's good in South Africa... :-) > 12. Integration with Third Party GUI Tools. Full ODBC support, some other tools have native access. > 13. Openness (Connectivity to other Database). See 4. > 14. Migration Facility. From what? > 15. Best Operating System for the Database. Unix. There is an NT port, which I have no personal experience of. > 16. Volume of Data Supported and it's performance. Capable of multi terabyte volumes. I've never had a problem with performance, ever. HTH. Sorry if the answers were a bit vague, but so were your questions! :-) -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Chief Cook and Bottlewasher The West Solutions Group | +------------------------------------------------------------------------------+ | (E) billy@west.co.za (U) http://www.west.co.za/billy.html | +------------------------------------------------------------------------------+ | Microsoft Word 6.0a to your mother .... | +------------------------------------------------------------------------------+