"Where Information Technology Is Purely Business & Engineering"

      Home Employment Contents                              Stamford, CT (203) 329-7013

DB Comparisons 
Up Reengineering DB Comparisons Project Pitfalls Special Studies Web/Client/Host IT Effectiveness

 

 

 

Professor Rino Nori's Fairfield University School of Engineering graduate school home page

COST SAVING TIPS:  DB Comparisons

 

This executive overview (i.e. detailed information and specifications are excluded) provides an insight into some current data base offerings.  Please be advised that technology changes daily, hence “by definition” the contents of this page are no longer current or accurate.  For current information on any technical matter, please feel free to contact Nori & Associates, we will quickly research and summarize it for you.

 

ORACLE:

            Widely used, about 45% market share of major applications

            Works on many operating systems, widely used in the Unix “flavors” world

            Excellent choice for high volume applications

            Available as Enterprise, Standard and Personal (single user) versions

            Pricing based upon CPUs, will start at approximately $15K, personal training edition is free

            Cost may exceed one mil $ for enterprise edition on a large number of CPUs (e.g. 32)

            Data warehousing, mining and OLAP tools are available and purchased separately

           

SQL Server 2000

            Widely used, about 20% market share of major applications

            Works only on Windows based operating systems

            Good choice for “less than large enterprise” volume applications

            Available as Enterprise, Standard and Personal (single user) versions.  Also available for developers, as a desktop engine and also a CE version for mobile Windows CE applications.

            Pricing based upon CPUs, will start at approximately $5K, personal edition is minimal cost

            Cost may exceed half mil $ for enterprise edition on a large number of CPUs (e.g. 32)

 

SYBASE

            Multiple versions available, from data warehousing to mobile and hand held applications

            Works on multiple operating system environments

            Claims excellent query capabilities due to unique “column access method”

 

IBM DB2

            Used primarily in IBM mainframe and as DB2/400 in IBM iSeries mid sized applications

            Good choice for “IBM shops” or very large and high volume mainframe applications

            Data warehousing tools available separately

 

NCR Teradata

            Widely used for very large data warehouse and data mining analytic applications

            Works on Windows and Unix environments

            Will hold 1+ petabytes (pb) of data, i.e. one thousand terabytes of data.

 

MySQL

            Open source, i.e. practically free, data base software.

            Does not have many features found in commercial products (cursors, stored procedures, etc.)

Operates under Windows and most Unix “flavors”

Performance compares favorably to commercial products

 

PostgresSQL

            Open source, i.e. practically free, data base software.

            Object oriented paradigm with support for traditional SQL

            Performance is not as good as MySQL

Operates under Windows and most Unix “flavors”

 

For general information and  inquiries eMail to:                                                                                                                                                                                             Copyright © 1999-2011 Nori & Associates
Last modified: November 09, 2010