MySQL Data Warehouse Jumpstart

This service can help address the following customer issues:

Sun's MySQL consultants have the experience and knowledge to help accelerate customers' Data Warehouse project and guide them through the crucial startup phase of a creating a Data Warehouse. Getting the initial phase of a Data Warehouse project right helps to reduce the risk of schedule overruns. Sun will use commercially reasonable efforts to provide this service.

MySQL's unique Pluggable Storage Engine Architecture enables the creation of a Data Warehouse architecture which customers can optimize specifically for their needs. Sun's MySQL consultants can assist customers with mapping the features of MySQL to their Data Warehouse requirements.

Sun's MySQL consultants will assist customers who purchase this service with the following:

• Guide customers through the architecture & design of their Data Warehouse including:
• Storage Engines
• Scalability
• Availability
• Analyze and architect their data model for Data Warehouse or Data Mart best practices
• Work with them to define a relevant Proof of Concept (POC) for their project
• Install, configure, and administer a MySQL Data Warehouse for the POC
• Work with the customer on an initial Extract, Transform, and Load (ETL) process and execution
• Benchmark and tune sample queries against the POC Data Warehouse
• Help customer define the monitoring of follow-on production systems
• Create a best-practices backup and recovery strategy

Sun's MySQL consultants can provide expertise in the following areas:

• 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 temporal or other rolling data

Scope of Work

• Analysis of customer requirements
• Architecture & Design of Data Warehouse on MySQL
• Build Proof of Concept.
• Sun's 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 help customer achieve results using best practices
• Work with customer to design hardware, software and process to help ensure that customer's Data Warehouse system really is highly scalable
• Start with an optimally tuned system and be aware of the factors to monitor for tuning the system in the future
• Be prepared for most contingencies, so that the unexpected doesn't adversely impact the 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

• Pricing details

How to Buy

• Please contact the MySQL Consulting Team.

Legal Terms

Each customer must also accept the terms and conditions of the MySQL Services Agreement included with the customer's Order Form, or an alternative agreement agreed to in writing by the customer and MySQL or Sun, to receive any MySQL Consulting Services.

View the MySQL Services Agreement »