MySQL Data Warehouse Jumpstart

• Do you need to build a massive Data Warehouse or Data Mart?
• Do you need to implement large data loads, purges, and reorganizations?
• Do you need Data Warehouse or MySQL expertise to jumpstart your project?
• Do you need to build a Data Warehouse that’s flexible enough to grow with your business and lean enough to support high-performance queries across large tables with hundreds of millions of rows or more?
• Do you want to minimize your TCO by leveraging the best practices in Open Source Solutions?
• Would you like to get your project off to a flying start?

Then the MySQL Data Warehouse Jumpstart is for you. Our senior Data Warehouse consultants have the experience and knowledge to accelerate your Data Warehouse project and guide your team through the crucial startup phase of a creating a Data Warehouse. Getting the initial phase of your Data Warehouse project right helps to reduce the risk of schedule overruns.

MySQL's unique Pluggabel Storage Engine Architecture enables the creation of a Data Warehouse architecture optimized specifically for your needs. We are the experts in mapping the features of MySQL to your Data Warehouse requirements.

A dedicated on-site MySQL Data Warehouse consultant will:

• Lead your team through the Architecture & Design of your Data Warehouse including:
  • Storage Engines
  • Scalability
  • Availability
• Analyze and Architect your Data Model for Data Warehouse or Data Mart best practices
• Work with you to define a relevant Proof of Concept (POC) for your project
• Install, Configure, and Administer a MySQL Data Warehouse for the POC
• Work with the Client's team on an initial Extract, Transform, and Load (ETL) process and execution
• Benchmark and tune sample queries against the POC Data Warehouse
• Help you define the monitoring of your follow-on production systems
• Create a best-practices backup and recovery strategy

Our consultants are specialists in

• Online Analytical Processing (OLAP)
• Decision Support Systems (DSS)
• Dimensional Modeling
• Optimizing MySQL for large Data Warehouse applications
• Using common Open Source tools with MySQL
• Extracting data from other systems and loading it into MySQL
• Migrating data from other databases
• Using partitioning strategies to manage your temporal or other rolling data

Scope of Work

• Analysis of customer requirements
• Architecture & Design of Data Warehouse on MySQL
• Build Proof of Concept.

Our Phased Methodology includes:

• Architecture & Design
• Proof of Concept
• Configure MySQL for optimal Data Warehouse performance, balancing a sample of data loads and queries
• Best Practice Process for Data Warehousing with MySQL

Deliverables

• Summary Report including
  • System Architecture
  • Data Loads
  • Schema & Query Tuning
  • Proof of Concept and Benchmark results
  • Backup and Recovery Strategy
  • Project Planning

Benefits

• Quickly realize a solution using state of the art best practices
• Design hardware, software and process to ensure that your Data Warehouse system really is highly scalable
• Start with an optimally tuned system and be aware of the factors to monitor for tuning your system in the future
• Be prepared for most contingencies, so that the unexpected doesn't adversely impact your system.
• Maintain availability

Duration

• Minimum 8 Days.
• Technical Review may specify longer duration, at an additional Per Day charge.
• Mix of remote/on-site at customer location.

Pricing

• For the included 8 Days: USD 19995, EUR 15995, GBP 11995
• Additional Days (Per Day): USD 2495, EUR 1995, GBP 1495
• Travel & Expenses are included for USA, Canada, and Europe. All other locations require additional Travel & Expenses.

How to Buy

Please contact the MySQL Consulting Team

Support Requirements

As a prerequisite for purchasing and delivery of MySQL Consulting Services, customers must have a valid contract for least one of the following MySQL support plans:

• MySQL Enterprise Subscription
• MySQL Cluster Support
• MySQL OEM Support