InfoSphere Warehouse Developer Edition

A high-performance, reliable and scalable platform

• Provides all the performance benefits of IBM DB2 Enterprise Server, which has high key performance benchmarks for transaction and analytical processing.
• Capable of processing data spread across multiple parallel servers for virtually unlimited scalability.
• Includes IBM Optim Performance Manager, which enables you to identify, diagnose, solve and prevent performance problems.
• Features the IBM Workload Manager, which allows you to prioritize queries coming from different users and applications, and control the number of resources dedicated to those processes.

Development and administration tools and features

• Development and administration tools and features help simplify data warehouse design and deployment.
• Tools and features include IBM Optim Database Administrator, Optim Development Studio, SQL compatibility and native XML support.
• The InfoSphere Warehouse Design Studio provides easy drag-and-drop modeling, and allows you to import and export models from various sources.
• The IBM Mashup Center helps you quickly assemble information, and it supports the rapid assembly of dynamic web applications.
• Development work can be ported to production with no duplication of effort.

Autonomic features

• Helps lower the cost of managing data in your warehouse by automating administrative and maintenance tasks including database backups.
• Transparently compresses data on disk to decrease disk space and storage infrastructure requirements, and improve query performance.
• Includes compression capabilities that can reduce storage needs up to 80 percent, resulting in substantial cost savings.

Sophisticated analytical tools

• The cubing services feature supports Online Analytical Processing (OLAP) within the data warehouse, which gives you direct access to current information for faster business decisions.
• The text analytics feature allows you to analyze unstructured data, such as call center logs and emails, and organizes the data into a structure that lends itself to analysis and insight.
• IBM Cognos Business Intelligence software is included for reporting—for up to five authorized users—and allows you to perform complex analysis tasks quickly.