PC Magazine
Ziff Davis Internet
The Independent Guide To Technology
Home

reviews

downloads

solutions

news

columns

shop now

discussions
 
ADVERTISEMENT

  • ONLINE CLASSIFIEDS

SQL Databases: Oracle9i Database

We hesitated to award the blue ribbon to a product that costs twice as much as its nearest competitors. But in the end, Oracle9i prevailed thanks to its superior feature set, reliability, and performance. Oracle9i offers the most advanced management and performance tools, and it topped the other products on our throughput tests. Oracle9i also lets you run Enterprise JavaBeans right from the DBMS and has improved in usability with this release. We wish Oracle9i were less proprietary and expensive, but any feature you could desire is available and polished.

IBM's DB2 Universal Database 7.2 deserves honorable mention, because of its support for open standards such as XML and Java. Configuration isn't as streamlined as Oracle9i's, but it lets you interoperate more easily with other vendors' products. And for the enterprise capabilities it offers, it's a good value.

Microsoft SQL Server 2000 SP2 is the hands-down ease-of-use leader in the field, so if you don't have an outsized IT budget, it's a good choice. SQL Server 2000 is also suitable for dyed-in-the-wool Microsoft shops. Don't expect it to be a top performer with a Java app server, but if you work with ASP and VisualStudio, you'll get excellent throughput rates.

We wished we could give higher marks to Sybase Adaptive Server Enterprise 12.5. It has forward-looking XML features, the ability to run EJBs natively, and a true bargain-basement price for an enterprise-level product. We simply found its administration tools and usability to be a generation behind.

Though MySQL 4.0 lacks capabilities that enterprises will insist on, such as stored procedures, it deserves a mention for providing a reliable, fast platform at a nominal cost. Its query caching also represents an advance.

< back   next >  
Email Order Reprints of this Article.
 
XML
Add PC Magazine: New Product Reviews to your RSS newsreader or My Yahoo!


dell_bsd_mod_left dell_bsd_mod_middle Toshiba eWeek Right
Ziff Davis Partner Sites
  • Visual Studio & .Net Dev Center
  • IBM On Demand
  • HP Smart Business Center
  • Ziff Davis Featured Sites
  • IT Reseller News & Resources
  • eWEEK.com Storage Topic Center
  • eCommerceIQ

  • FREE ZIFF DAVIS MEDIA ESEMINARS AT ESEMINARSLIVE.COM
  • Jan. 24, 4 p.m. ET
    How Secure is Your Data?
    with Frank Derfler. Sponsored by Adobe Systems
  • Jan. 25, 12:30 p.m. ET
    Applying Security Management Practices
    with Michael Krieger. Sponsored by Computer Associates
  • Jan. 25, 2 p.m. ET
    Apps on the WAN: Delivering Performance Across the Enterprise
    with Frank Derfler. Sponsored by FineGround & Cargill
  • Jan. 26, 12:30 p.m. ET
    Ferris Research: Stop Virus Attacks Before They Begin
    with Frank Derfler Sponsored by MailFrontier & Ferris Research.
  • Tradeshow Image

    If you missed the Ziff Davis Media eSeminar's Security Virtual Tradeshow don't worry. Our archives are up and running with two day's worth of information and analysis from top security experts focused exclusively on the most pressing IT security issues. Register now and view the informative keynotes and panel discussions that took place with our FBI, DOJ, IT and analyst guests.
    FREE WHITE PAPERS
    Click on a link below to download one of the following Free White Papers:


  • Tips and Tricks for Optimizing Microsoft Windows Server 2003 on ProLiant Servers


  • The HP-Microsoft Small Business Solution at Work


  • Implementing Microsoft Windows Server 2003 on ProLiant Servers
  • >> brought to you by HP

    NEW & USEFUL UTILITIES @ PCMAG.COM
    Powerful New Files for the Web and Windows, only from the PCMag.com Utility Library:
    • Favorites Manager - super-fast way to organize, control bookmarks
    • AppLauncher - get total control over Windows file associations
    • Web Historian - save Web information so it's there whenever you need it!
    • Shortcut Manager - Organize and manage your desktop, IE, and startup menu shortcuts
     


    Browse the Library >>


    table of contents
    Clash of the Titans
    • Clash of the Titans: SQL Databases
    • Editors' Choice
    • DB2 Universal Database 7.2
    • Microsoft SQL Server 2000 SP2
    • MySQL 4.0
    • Oracle9i Database
    • Sybase Adaptive Server Enterprise 12.5
    • On the Road to Mobile Databases
    • Toward Disaster-Proof Databases
    • Performance Tests
    • Scorecard
    • Summary of Features
    • Online Extra: Nile Application Test Code
    • Inside PC Labs


    discussions

    Find a Topic:
    View All >

     Partner Services:
      Dell Business Systems
      Dell Home Systems
      MPC (MicronPC)
      Dell Biz E-Catalog