Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Informix Red Brick Warehouse 5.1 Information & Communication Lab. Park, Jeong-Eun email@example.com
Red Brick Warehouse 개요 • Relational database designed specifically to meet the specialized requirements of data mart applications • specialized server technology • for complex queries, fast load performance, high-capacity/high-performance processing, and for efficient management of very large databases. • Integral piece of Informix Decision Frontier Solution Suite
Why data marts is needed? • Answers to multiple users with differing interests ( differ department ) • Easy distribution of data • Provide higher availability • Provide easier access to data • Can be used as a means to better manage business information • Informix Red Brick Warehouse provide all these requirements
Lightning Fast Performance • Through Table Management • Table Management Utility(TMU) • Informix Red Brick Warehouse’s loader • Performs all the necessary tasks to guarantee the data is ready to query • Data transformation and cleansing, insertion of row data, checking of referential integrity, updating of all relevant indexes and the building of aggregates
Lightning Fast Performance • Through Table Management • Parallel Table Management Utility(PTMU) • Performs all the functions of the TMU and takes advantage of SMP parallelism to dramatically speed up loads • Full referential integrity check and build all in parallel
Lightning Fast Performance • Through Advanced Indexing • STAR indexing -> STAR join • Automatically built when table are created • Maintain relationships between primary keys and foreign keys • Unique feature of the Informix Red Brick Warehouse data mart • Using multiple STAR indexes, multitable join processing is greatly accelerated • When using multiple indexes, it occupy less disk space than other solutions
Lightning Fast Performance • Through Advanced Indexing • TARGET indexing -> TARGET join • Bit-map indexing technology • Specifically designed for queries which require very fast selection of records from a large, wide table • Completely integrated in the core Informix Red Brick Warehouse database. • Greatly expands the range of query complexity that can be handled while minimizing index costs.
Lightning Fast Performance • Through Managing Data Aggregation • The Informix Vista Aggregate Management System • For aggregate computation and management • Server-based aggregation tool • Leverage the performance, maintenance, security optimization of the server • Give maximum control and flexibility over the aggregate environment • Reduce cost by analyzing where aggregates can improve warehouse performance
Performance That Can Impact Your Bottom Line • Parallel on Demand • Dynamic Incremental Optimization • Table Segmentation • Time-Cyclic Data Management • Handle time-sensitive data • Informix Red Brick Security Features • Hierarchical role-based security, rich logging • SQL-BackTrack for Informix Red Brick Warehouse • Fast,easy,safe backup and recovery of databases
Integration/Scalability • Integrating Informix Red Brick Warehouse into Informix’s Decision Frontier Solution Suite • Provide clear migration path to a next generation • Provide a growth path for the future that incorporates an integrated product set to grow into as new data warehousing needs arise
Conclusion • Informix Red Brick Warehouse’s robust features are the foundation of the decision-making process • Fast Processing • Particularly important when large volumes of data are involved • Easy to get departmental data • Easy to get answers to your specific questions
References • http://www.informix.com/informix/solutions/dw/redbrick/