Red Brick Systems has unveiled Red Brick Warehouse version 5.1 on Unix and Windows NT platforms. Red Brick Warehouse is the industry`s leading relational database management system designed from the ground up for data warehousing. Version 5.1 offers new features designed to maximise productivity, reduce overall cost of ownership and minimise complexities for data warehouse administrators and users. New options available in conjunction with Red Brick Warehouse 5.1 include Red Brick Vista, a server-integrated solution for the computation and management of aggregates; and SQL-BackTrack for Red Brick Warehouse, a backup and recovery system designed specifically for Red Brick. "Red Brick Warehouse 5.1 continues our tradition of introducing innovative technology to data warehousing and extends our lead," says Chris Erickson, president and CEO of Red Brick Systems. "In addition, we believe our customers will directly benefit from this version in terms of reduced time, cost and resources to manage their data warehouse. These administrative advances are designed to improve their ability to manage large-scale warehouses, in terms of both data and users." Features Red Brick Warehouse 5.1 is designed to help data warehouse administrators improve data warehouse tuning, maximise productivity through features such as aggregate management and an administrator GUI interface, and reduce data warehouse cost of ownership by decreasing time, resource and disk space requirements. The features new to Red Brick Warehouse 5.1 address issues related to very large and complex data warehousing environments. Red Brick Vista Red Brick Vista is a comprehensive, server-integrated solution for aggregate computation and management. Vista maximises the query response time benefits of aggregation, while minimising aggregation costs such as those related to storage requirements, maintenance, planning and programming. Vista provides efficiency of scale for large data warehouses and delivers multidimensional-like speed combined with the openness and reliability of a relational database. SQL-BackTrack SQL-BackTrack for Red Brick Warehouse is a comprehensive and flexible backup and recovery solution for data warehousing that automates much of the administrator tasks while providing special abilities to maintain very-large-database safety, consistency and speed of recovery. SQL-BackTrack offers industry-leading product reliability from BMC Software, and provides high-performance backup and recovery features to reduce complexities and help improve administrator productivity. TARGETjoin Red Brick Warehouse 5.1 introduces TARGETjoin, a new join algorithm, to its family of industry-leading join technologies. TARGETjoin accelerates complex decision support queries through its parallel bitmap join technology. Using TARGETjoin in tandem with Red Brick`s other join technologies gives data warehouse users the flexibility to manage any level of query complexity. Red Brick Warehouse Administrator The Red Brick Warehouse Administrator is a graphical Windows-based client tool designed to give data warehouse administrators the ability to manage all general warehouse tasks, with an emphasis on segmentation, or partitioning. This tool is available on Windows 95 and Windows NT 4.0, and supports Red Brick on any of its platforms with wizards and online context-sensitive help. The Administrator speeds the warehouse learning curve, guides "what if" experimentation and helps administrators with incremental schema evolution. Query and Index Optimisations Tuning advances in Red Brick Warehouse 5.1 are automatically selected by the Red Brick compiler/optimiser and require no data warehouse administrator or end-user intervention. These advances help improve performance on queries that contain aggregation functions such as COUNT, MIN or MAX on indexed columns. Integrated Enterprise Control and Reporting Enterprise Control and Coordination (ECC), Copy Management and RISQL Reporter modules provide functionality to streamline the data warehouse administrator`s management of the data warehouse. Previously available as elective options, these modules are now included as part of Red Brick Warehouse 5.1. The integration of these features in the database provide lower cost of ownership and better database value. Customers upgrading to version 5.1 will receive this functionality at no additional cost.
Share
