Red Brick Warehouse

• Handles thousands of concurrent SQL queries, hundred of concurrent users, and terabytes of data.
• Offers a scalable platform for star schema-based decision support application.
• Delivers outstanding performance for the most complex business solutions.
• Open standards-based allowing third-party decision support solution to connect
• Reduces deployment time, and saves on hardware and maintenance costs.
• A "Hands off" database engine.

What's new in Red Brick Warehouse Server V6.30?

Performance enhancements

• Dynamic segment elimination: Complementing compile-time "SmartScan" optimizations, the server also supports run-time or dynamic segment elimination. This further optimizes data access for table scans and TARGETjoins that use local indexes. Segment elimination is factored when determining the correct query plan to choose.
• Memory mapping for queries: To optimize access to dimension tables and their primary-key indexes. These objects are partially or wholly memory-mapped during query execution.
• TARGETjoin performance improvements: The performance of TARGETjoin queries is optimized, and single-column B-TREE indexes can now participate in TARGETjoin plans.

Ease-of-use improvements

• Alter Table with working segment: You can add or drop table columns into a predefined "working segment." This option provides greater reliability and recoverability than other ALTER TABLE modes.
• Additional SQL OLAP functions: The server supports additional functions for analytic queries: PERCENT_RANK, CUME_DIST, PERCENTILE_CONT, and PERCENTILE_DISC. The server also supports the ROUND scalar function.
• Expression support: You can define arithmetic expressions and conditional CASE expressions for input columns inside the TMU control file.

New Platform Support

• HP-UX 11i operating system for the Intel™ 64-bit platform (Itanium)
• Microsoft Windows Server 2003 (32-bit)

IBM Red Brick Warehouseä is a lean SQL standard relational database that is built from the ground up for data warehousing. It is available in two configurations:

Workgroup Edition is ideal for small to medium businesses and departmental solutions that require the power of an enterprise database on a computer with one or two processors

Enterprise Edition provides all the feature of the Workgroup Edition and is available for SMP computers withthree or more processors.

IBM Red Brick™ Warehouse 6.3 is the latest version of the product. It is available in two configurations: Red Brick Workgroup Edition and Red Brick Enterprise Edition. Red Brick Workgroup Edition 6.3 is ideal for small- to medium-size businesses and departmental solutions that require the power of an enterprise database on a system with up to two processors. Red Brick Enterprise Edition 6.3 provides all of the features of the Workgroup Edition for SMP systems with three or more processors. The release notes for the latest Red Brick versions can be found here.