Building the Data Warehouse

Building the Data Warehouse PDF Author: W. H. Inmon
Publisher: John Wiley & Sons
ISBN: 0471270482
Category : Computers
Languages : en
Pages : 434

Get Book Here

Book Description
The data warehousing bible updated for the new millennium Updated and expanded to reflect the many technological advances occurring since the previous edition, this latest edition of the data warehousing "bible" provides a comprehensive introduction to building data marts, operational data stores, the Corporate Information Factory, exploration warehouses, and Web-enabled warehouses. Written by the father of the data warehouse concept, the book also reviews the unique requirements for supporting e-business and explores various ways in which the traditional data warehouse can be integrated with new technologies to provide enhanced customer service, sales, and support-both online and offline-including near-line data storage techniques.

Building the Data Warehouse

Building the Data Warehouse PDF Author: W. H. Inmon
Publisher:
ISBN:
Category :
Languages : en
Pages : 16

Get Book Here

Book Description
The data warehousing bible updated for the new millennium Updated and expanded to reflect the many technological advances occurring since the previous edition, this latest edition of the data warehousing "bible" provides a comprehensive introduction to building data marts, operational data stores, the Corporate Information Factory, exploration warehouses, and Web-enabled warehouses. Written by the father of the data warehouse concept, the book also reviews the unique requirements for supporting e-business and explores various ways in which the traditional data warehouse can be integrated with new technologies to provide enhanced customer service, sales, and support-both online and offline-including near-line data storage techniques.

Building a Scalable Data Warehouse with Data Vault 2.0

Building a Scalable Data Warehouse with Data Vault 2.0 PDF Author: Daniel Linstedt
Publisher: Morgan Kaufmann
ISBN: 0128026480
Category : Computers
Languages : en
Pages : 684

Get Book Here

Book Description
The Data Vault was invented by Dan Linstedt at the U.S. Department of Defense, and the standard has been successfully applied to data warehousing projects at organizations of different sizes, from small to large-size corporations. Due to its simplified design, which is adapted from nature, the Data Vault 2.0 standard helps prevent typical data warehousing failures. "Building a Scalable Data Warehouse" covers everything one needs to know to create a scalable data warehouse end to end, including a presentation of the Data Vault modeling technique, which provides the foundations to create a technical data warehouse layer. The book discusses how to build the data warehouse incrementally using the agile Data Vault 2.0 methodology. In addition, readers will learn how to create the input layer (the stage layer) and the presentation layer (data mart) of the Data Vault 2.0 architecture including implementation best practices. Drawing upon years of practical experience and using numerous examples and an easy to understand framework, Dan Linstedt and Michael Olschimke discuss: - How to load each layer using SQL Server Integration Services (SSIS), including automation of the Data Vault loading processes. - Important data warehouse technologies and practices. - Data Quality Services (DQS) and Master Data Services (MDS) in the context of the Data Vault architecture. - Provides a complete introduction to data warehousing, applications, and the business context so readers can get-up and running fast - Explains theoretical concepts and provides hands-on instruction on how to build and implement a data warehouse - Demystifies data vault modeling with beginning, intermediate, and advanced techniques - Discusses the advantages of the data vault approach over other techniques, also including the latest updates to Data Vault 2.0 and multiple improvements to Data Vault 1.0

The Data Warehouse Toolkit

The Data Warehouse Toolkit PDF Author: Ralph Kimball
Publisher: John Wiley & Sons
ISBN: 1118082141
Category : Computers
Languages : en
Pages : 464

Get Book Here

Book Description
This old edition was published in 2002. The current and final edition of this book is The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition which was published in 2013 under ISBN: 9781118530801. The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including: Retail sales and e-commerce Inventory management Procurement Order management Customer relationship management (CRM) Human resources management Accounting Financial services Telecommunications and utilities Education Transportation Health care and insurance By the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.

Building a Data Warehouse

Building a Data Warehouse PDF Author: Vincent Rainardi
Publisher: Apress
ISBN: 1430205288
Category : Computers
Languages : en
Pages : 526

Get Book Here

Book Description
Here is the ideal field guide for data warehousing implementation. This book first teaches you how to build a data warehouse, including defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Coverage then explains how to populate the data warehouse and explores how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. It also details testing and how to administer data warehouse operation.

Building the Data Warehouse

Building the Data Warehouse PDF Author: William H. Inmon
Publisher: QED Information Sciences
ISBN:
Category : Business & Economics
Languages : en
Pages : 292

Get Book Here

Book Description
"Data warehouses provide a much-needed strategy for organizations to collect, store, and analyze vast amounts of business data. As businesses expand both brick-and-mortar and online activities, the field of data warehousing has become increasingly important. Since it was first published in 1990, W. H. Inmon's Building the Data Warehouse has been the bible of data warehousing - it is the book that launched the data warehousing industry and it remains the preeminent introduction to the subject. This new edition covers the latest developments with this technology, many of which have been pioneered by Inmon himself."--BOOK JACKET.

Building a Data Warehouse for Decision Support

Building a Data Warehouse for Decision Support PDF Author: Vidette Poe
Publisher: Prentice Hall
ISBN:
Category : Business & Economics
Languages : en
Pages : 340

Get Book Here

Book Description
Completely revised, expanded, and updated, this second edition gives extensive new coverage of data integration, management, indexing, cleansing, and transformation. The book covers powerful new multi-dimensional front-ends and conversion tools and gives detailed coverage of lifecycle issues.

The Data Warehouse Toolkit

The Data Warehouse Toolkit PDF Author: Ralph Kimball
Publisher: John Wiley & Sons
ISBN: 1118732286
Category : Computers
Languages : en
Pages : 608

Get Book Here

Book Description
Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence! The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence Begins with fundamental design recommendations and progresses through increasingly complex scenarios Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

Building and Maintaining a Data Warehouse

Building and Maintaining a Data Warehouse PDF Author: Fon Silvers
Publisher: Auerbach Publications
ISBN: 9780367387648
Category :
Languages : en
Pages : 328

Get Book Here

Book Description
As it is with building a house, most of the work necessary to build a data warehouse is neither visible nor obvious when looking at the completed product. While it may be easy to plan for a data warehouse that incorporates all the right concepts, taking the steps needed to create a warehouse that is as functional and user-friendly as it is theoretically sound, is not especially easy. That's the challenge that Building and Maintaininga Data Warehouse answers. Based on a foundation of industry-accepted principles, this work provides an easy-to-follow approach that is cohesive and holistic. By offering the perspective of a successful data warehouse, as well as that of a failed one, this workdetails those factors that must be accomplished and those that are best avoided. Organized to logically progress from more general to specific information, this valuable guide: Presents areas of a data warehouse individually and in sequence, showing how each piece becomes a working part of the whole Examines the concepts and principles that are at the foundation of every successful data warehouse Explains how to recognize and attend to problematic gaps in an established data warehouse Provides the big picture perspective that planners and executives require Those considering the planning and creation of a data warehouse, as well as those who've already built one will profit greatly from the insights garnered by the author during his years of creating and gathering information on state-of-the-art data warehouses that are accessible, convenient, and reliable.

Mastering Data Warehouse Design

Mastering Data Warehouse Design PDF Author: Claudia Imhoff
Publisher: John Wiley & Sons
ISBN: 0471480924
Category : Computers
Languages : en
Pages : 456

Get Book Here

Book Description
A cutting-edge response to Ralph Kimball's challenge to thedata warehouse community that answers some tough questions aboutthe effectiveness of the relational approach to datawarehousing Written by one of the best-known exponents of the Bill Inmonapproach to data warehousing Addresses head-on the tough issues raised by Kimball andexplains how to choose the best modeling technique for solvingcommon data warehouse design problems Weighs the pros and cons of relational vs. dimensional modelingtechniques Focuses on tough modeling problems, including creating andmaintaining keys and modeling calendars, hierarchies, transactions,and data quality