windtear 追求完美

MySQL 5.0's Enterprise Database Features

The new MySQL 5.0 combines enterprise-grade reliability and performance with advanced SQL 2003 standard-compliant features, making it the most cost-effective database solution for business-critical applications. The product's new functionality will be especially familiar to database developers and DBAs of proprietary relational database systems -- allowing IT departments to ease the integration and transition of their data, applications and skill-sets.

MySQL 5.0 delivers dozens of new enterprise features, including:

• Stored Procedures and SQL Functions -- to embed business logic in the database and improve performance;
• Triggers -- to enforce complex business rules at the database level;
• Views -- to ensure protection of sensitive information;
• Cursors -- to allow easier database development and reference of large datasets;
• Information Schema -- to provide easy access to metadata;
• XA Distributed Transactions -- supports complex transactions across multiple databases in heterogeneous environments;
• SQL Mode -- provides server-enforced data integrity for new and existing data;
• New Federated and Archive Storage Engines -- MySQL's unique pluggable storage engine architecture allows greater flexibility, functionality and performance by making it easy to swap database engines in and out, based on users' application requirements;
• New Migration Toolkit -- A new graphical toolkit that completely migrates all data and objects from Oracle, Microsoft SQL Server, Microsoft Access and other database platforms to MySQL;
• Instance Manager -- new management assistant that allows remote starting/stopping of any MySQL Server, as well as remote editing of configuration files, reading of error and query logs, and more;
• Updated Connectors and Visual Tools -- new high-performance versions of MySQL's ODBC, Java and .NET database drivers are now available, along with updated versions of the MySQL Query Browser and MySQL Administrator.

"MySQL 5.0 represents a huge leap in features and functionality for the MySQL database," said Gunter Rombauts, European IT manager for Chicago Metallic. "As a worldwide leader in metal ceiling systems, it's critical that our database supports heavy-duty enterprise applications with speed and reliability.  We are looking forward to using MySQL 5.0 as a key component of Chicago Metallic's global IT infrastructure."