| CARVIEW |
The world's most popular open source database
Contact Sales
USA - Toll Free: +1-866-221-0634
USA - From abroad: +1-208-327-6494
USA - Subscription Renewals: +1-866-830-4410
Latin America: +1 512 535 7751
UK: +44 845 399 1124
Ireland: +353 1 6919191
Germany: +49 89 420 95 98 95
France: +33 1 70 61 48 95
Sweden: +46 730 207 871
Benelux: +31 6 25003558
Italy: +39 06-99268193
Israel: +31 6 25003558
Spain & Portugal: + 34 933905461
Other EMEA countries: +353 1 6919191
Australia/NZ: +61 2 42314328
Asia Pacific: +81 3 5843 1140
MySQL Data Warehouse
One of the top use cases for the MySQL Server is data warehousing and analytics. By offloading operational data onto MySQL data warehouses, IT professionals can run all their key business intelligence operations at a much lower cost than those charged by expensive proprietary vendors.
With its unique pluggable storage engine architecture, MySQL offers several server solutions for those wanting to experience the benefits of open source data warehousing:
Native MySQL Storage Engines
MySQL offers a number of internally developed storage engines that are well-suited for data warehouses, with the most popular being the default MyISAM storage engine. The MyISAM engine delivers rapid data loading capabilities, fast read times, and much more for data warehousing users. Typical MyISAM support for data warehouse volumes range up to 1TB comfortably. MySQL offers other storage engines that can also be used for data warehousing as well. MySQL supports these key data warehousing features:
- Data/Index partitioning (range, hash, key, list, composite) in MySQL 5.1 and above
- No practical storage limits with automatic storage management
- Built-in Replication
- Strong indexing support (B-tree, fulltext, clustered, hash, GIS)
- Multiple, configurable data/index caches
- Pre-loading of data into caches
- Unique query cache (caches result set + query; not just data)
- Parallel data load
- Multi-insert DML
- Read-only tables
- Cost-based optimizer
- Wide platform support
Infobright
Infobright offers a storage engine for the MySQL Server that is tailor-made for large scale, analytic-styled data warehousing. Infobright enables MySQL users to move up to data warehouses that support data volumes of 1-10TB or more with these key capabilities:
- Column-oriented design
- High data compression capabilities
- Advanced optimizer with "Knowledge Grid"
- High-speed loader


