E-Book Overview
* This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects * Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates * Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads
E-Book Content
Mastering Data Warehouse Aggregates Solutions for Star Schema Performance Christopher Adamson Mastering Data Warehouse Aggregates Mastering Data Warehouse Aggregates Solutions for Star Schema Performance Christopher Adamson Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance Published by Wiley Publishing, Inc. 10475 Crosspoint Boulevard Indianapolis, IN 46256 www.wiley.com Copyright © 2006 by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada ISBN-13: 978-0-471-77709-0 ISBN-10: 0-471-77709-9 Manufactured in the United States of America 10 9 8 7 6 5 4 3 2 1 1MA/SQ/QW/QW/IN No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572