Tuesday, May 17, 2011

4.4 Examination of MySQL Data Warehousing TCO

4.4 Examination of MySQL Data Warehousing TCO

One of the driving factors that can be attributed to the popularity and adoption of open source database software in business today is the dramatic cost savings that accompanies owning such software. Open source is a much smarter way of producing and maintaining high quality software than traditional, proprietary methods, with the approach having a benefit of being able to
keep costs low.

Customers who choose MySQL typically save 90% of the license, maintenance, and support costs over the expenses incurred from using proprietary databases. As the CEO of RightNow, a large CRM provider, has observed:

"Using MySQL and other open source technologies, RightNow has built an enterprise-class CRM
application hosting environment that supports over 3,000 deployments for some of the world's
largest organizations. Our systems have facilitated over 1 billion customer interactions on behalf
of our clients while maintaining reliability at or above 99.97 percent. Money spent on proprietary databases, when there is a viable open source alternative, is money wasted.“ - Greg Gianforte, CEO and founder of RightNow.

A sample of the cost comparisons between using MySQL and other proprietary platforms follows (using the default settings of the ROI calculator on the MySQL web site):

5 MySQL Data Warehousing Customer Profile

5 MySQL Data Warehousing Customer Profile
BlueLithium, a leading online marketing company, has implemented a business-critical data warehouse application built upon MySQL and the BrightHouse database engine from Infobright Inc. BlueLithium, one of the top five US online advertising networks, uses data from 145 million
consumers worldwide, combined with sophisticated analytics and advanced targeting technologies to create value for both marketers and publishers.

"Our advanced analytics help us do better ad targeting which delivers increased value to our customers -- as well as a better user experience," said Jay Webster, General Manager, BlueLithium Performance Network.
"BrightHouse allows us to do very complex analyses on over 30 terabytes of data while leveraging our skill set in MySQL."
6 Conclusion

Successful modern businesses have realized they need a smart data warehouse/business intelligence infrastructure to actively compete in today’s marketplace, and are now beginning to recognize how they can use open source database technology to reach that goal. MySQL is capable of meeting each of the common data warehouse uses cases in play today and can also successfully navigate the issue of mixed workloads in a data warehouse via the server’s multi storage engine architecture and scale out abilities.

In addition, customers can enjoy all the safety nets of proprietary software support and updates with MySQL Enterprise, but do so without breaking their budget The combination of the powerful and innovative MySQL

Enterprise server, enterprise-ready services and production support, and a total cost of ownership that simply has no peer in the database industry make MySQL an obvious choice for modern businesses looking for topnotch data management capabilities in the area of data warehousing and business intelligence.