FREE DM Review Site Registration!
Sign-up today and access DM Review on the Web!

Your FREE registration entitles you to:
FREE email newsletters

FREE access to all DM Review content

FREE access to web seminars, resource portals, our white paper library and more!

   

Publisher reserves the right to serve qualified requesters only.

How does the newest release of MySQL measure up to the task of managing a several GB database, especially in reporting?

Question: In regard to data warehouse and MySQL DBMS, how does the newest release of MySQL measure up to the task of managing a several GB database, especially in reporting? I understand MySQL cannot perform parallel querying and does not have other types of indexes such as bitmap, reverse, etc.

Chuck Kelley's Answer: For a several GB data warehouse, MySQL will be fine. MySQL does have parallel query, but you may not need parallel querying and different types of indexes to support that environment. The next question is "Do you have multiple CPU's on your database box?" If no, then it doesn't matter.


Chuck Kelley is an internationally known expert in database and data warehousing technology. He has 30 years of experience in designing and implementing operational/production systems and data warehouses. Kelley has worked in some facet of the design and implementation phase of more than 50 data warehouses and data marts. He also teaches seminars, co-authored four books on data warehousing and has been published in many trade magazines on database technology, data warehousing and enterprise data strategies. He can be contacted at chuckkelley@usa.net.

For more information on related topics, visit the following channels:



Industry Vendors