MySql Database

Offshore Outsourcing MySQL Database Development

Overview

Fed up with the world of commercial software licensing? Are you looking for a stable database platform for your organization but sweating at the hefty price tags attached to mainstream products from Microsoft and Oracle? MySQL may be for you!

Once the refuge of geeky hackers, MySQL is now a well-respected product that is more than capable of commercial operation. In fact, the entire Google search engine is built upon MySQL technology!

What about features? MySQL actually supports most of the functionality you’ve come to expect in a commercial RDBMS. It ensures that transactions comply with the ACID Model, allows the building of indexes, supports standard data types, and allows for database replication, among other features.

One major area where MySQL currently falls short is its lack of support for stored procedures and triggers. However, both of these features are slated for the next major release – MySQL 5.0.

If you’re a heavy user of web applications, you’ll be pleased to learn that MySQL meshes perfectly with the Perl Hypertext Preprocessor (PHP) dynamic web development language. If you’re a Microsoft IIS user, it works quite well with Active Server Pages (ASP), as well. In fact, if your ASP code is ANSI SQL-compliant, you may be able to simply plug and play a MySQL server into your production environment very easily!

Like the popular Linux operating system, MySQL is released as open source software under the GNU Public License (GPL). In most cases, you can download, install and work with MySQL without paying a cent. There are some exceptions for those who create software built upon MySQL for resale.
If that’s enough for you to decide that you’d like to give MySQL a try, you can download a copy from www.mysql.com. That site is also a great resource for information on the MySQL platform geared toward administrators and developers alike.

The first step in installing MySQL is to make sure that MySQL supports your operating system. If you're a Microsoft user, that means any version of Windows later than Windows 95.

Next, you'll need to choose the version of MySQL that you'd like to install. As of this writing, the most recent production version is MySQL 4.1

You'll probably find that there have been several minor releases that follow the release of 4.1. These will be indicated by adding a third number to the filename. For example, as of October 31, 2004, the current release is 4.1.7. In general, you should select the highest numbered release that doesn't have the word "alpha" "beta" or "gamma" after it. Those keywords indicate pre-release versions of MySQL that are currently being tested by the open source community.

Then it's time to download the correct file! Select the file that corresponds to the version you wish to install and your operating system. Note that unless you have a specific reason to do otherwise, you should select the "standard" version. If you're attempting to install MySQL on a non-supported operating system, you'll need to download the source files instead. Note that this is not a process suggested for beginners. In fact, if you aren't familiar with the word "compile," steer clear of this process.

Database Consulting
· Offshore Database Consulting
· Embedded Database Development

Case Studies
· Database programming


Data Warehouse Solutions

· Data Warehouse
· e-Business Intelligence
· Re-Engineering of DW applications
· CRM Data Warehouse
· Data Warehousing Implementation
· Data delivery applications
· Data integration

Case Studies
· Business Management System
· Data Warehouse WAP System
· Cell-phone Users Survey
· BI Platform Development
· Data Warehouse Reporting Portal