Copyright

Library of Congress Cataloging-in-Publication Data

Scalzo, Bert

Oracle DBA guide to data warehouse and star schemas : successful star schemas for Oracle data warehouse / by Bert Scalzo.

p. cm.

Includes index.

ISBN 0-13-032584-8

1. Oracle (Computer file) 2. Data warehousing. I. Title

QA76.9.D37S23 2003

005.75'85--dc21 2003048817

Editorial/production supervision: Donna Cullen-Dolce

Cover design director: Jerry Votta

Cover design: Nina Scuderi

Art director: Gail Cocker-Bogusz

Interior design and composition: Daly Graphics

Manufacturing manager: Alexis Heydt-Long

Publisher: Jeff Pepper

Editorial assistant: Linda Ramagnano

Marketing manager: Debby vanDijk

2003 by Pearson Education, Inc.

Publishing as Prentice Hall Professional Technical Reference

Upper Saddle River, New Jersey 07458

Prentice Hall books are widely used by corporations and government agencies for training, marketing, and resale.

For information regarding corporate and government bulk discounts please contact: Corporate and Government Sales [phone] or [e-mail]

Company and product names mentioned herein are the trademarks or registered trademarks of their respective owners .

All rights reserved. No part of this book may be reproduced, in any form or by any means, without permission in writing from the publisher.

Printed in the United States of America

10 9 8 7 6 5 4 3 2 1

Pearson Education LTD.

Pearson Education Australia PTY, Limited

Pearson Education Singapore, Pte. Ltd.

Pearson Education North Asia Ltd.

Pearson Education Canada, Ltd.

Pearson Educaci ³n de Mexico, S.A. de C.V.

Pearson Education ”Japan

Pearson Education Malaysia, Pte. Ltd.

Dedication

To my best friend in the whole world, Ziggy, my miniature schnauzer.