|
Database Servers
|
| MySQL Database Server |
|
There are several relational database management systems (RDBMSs) from which
you the developer can choose, ranging from expensive systems that can prove
quite difficult to administer, to free and open source alternatives that may
not have as many features as the proprietary RDBMSs, but can be much faster
to set up and work with. Of these, MySQL is the hands-down favorite.
|
|
The MySQL database has become the world's most popular open source database
because of its consistent fast performance, high reliability and ease of use.
It's used on every continent by individual Web developers as well as many of
the world's largest and fastest-growing organizations to save time and money
powering their high-volume Web sites, business-critical systems and packaged
software.
|
|
-
Multi-user access to a number of databases
-
Database of choice for applications built on the LAMP stack
-
LAMP stack: Linux, Apache, MySQL, PHP / Perl / Python
-
Runs on more than 20 platforms
-
Platforms include: Linux, Windows, OS/X, HP-UX, AIX, Netware
-
Consistent fast performance, high reliability and ease of use
-
Reduces Total Cost of Ownership (TCO) of database software
-
Favorite database for LinuxQuestions.org
|
| Microsoft SQL Server 2008 Express (SQL Express 2008) |
|
SQL Express 2008 is free with limitations. It is not a fully-featured version.
It is not an open source database and it is not necessarily intended to
compete with full-featured open source databases. It is the entry-level version
of the SQL Server product line that Microsoft offers free of charge. Their hope
is to provide an easy-to-use database for learning and building small server
applications while also providing a seamless upgrade path. SQL Express 2008 is
a solid database intended for real-world applications. Its feature-set includes
arguably all the features you need to for basic data needs: data storage, stored
procedures, triggers, views, etc. In addition, SQL Express 2008 provides most of
the security and manageability features available in the full version of SQL Server.
|
|
-
Runs on Windows Server 2003 SP2, Windows Server 2008, XP SP2, or Vista
-
Requires admin rights to the computer, .NET 3.5 SP1, Windows Intaller 4.5
-
Works fine for most non-large company needs and students in academics
-
Supports Policy Based Management (manual only)
-
Supports New Data Type Support (Date & Time, Geodetic, Spatial)
-
Supports Import/Export Wizard and Change Tracking
-
Supports Synchronization Services (separate installation)
-
Does not support Reporting Services or intergrated full text search
-
Does not support online indexing, restore, or compression
-
Does not support hot add RAM or CPU, database tuning, or data mining
-
Does not support multi-dimensional analytics, Transact-SQL or MDX
-
Does not support integration with other data (XML or Oracle Publishing)
|
|