Building the Data Warehouse

Titre : Building the Data Warehouse
Auteur : W. H. Inmon
Éditeur : Wiley
ISBN-13 : 9780764599446
Libération : 2005-09-23

Télécharger Lire en ligne



  • The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himself
  • In addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media
  • Discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects
  • Covers advanced topics, including data monitoring and testing
  • Although the book includes an extra 100 pages worth of valuable content, the price has actually been reduced from $65 to $55

Building a Data Warehouse: With Examples in SQL Server (Expert's Voice in SQL Server)

Titre : Building a Data Warehouse: With Examples in SQL Server (Expert's Voice in SQL Server)
Auteur : Vincent Rainardi
Éditeur : Apress
ISBN-13 : 9781430242994
Libération :

Télécharger Lire en ligne



Now available in paperback―

Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The relational database management system (RDBMS) used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.

The book is organized as follows. In the beginning of this book (chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in chapters 11 through 15, you explore 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. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation.


Building a Scalable Data Warehouse with Data Vault 2.0

Titre : Building a Scalable Data Warehouse with Data Vault 2.0
Auteur : Dan Linstedt
Éditeur : Morgan Kaufmann
ISBN-13 : 9780128025109
Libération :

Télécharger Lire en ligne



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

Building the Data Warehouse

Titre : Building the Data Warehouse
Auteur : W. H. Inmon
Éditeur : Wiley
ISBN-13 :
Libération : 2008-04-21

Télécharger Lire en ligne



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 Data Warehouse: With Examples in SQL Server (Expert's Voice in SQL Server) by Vincent Rainardi (2011-12-15)

Titre : Building a Data Warehouse: With Examples in SQL Server (Expert's Voice in SQL Server) by Vincent Rainardi (2011-12-15)
Auteur : Vincent Rainardi
Éditeur : Apress
ISBN-13 :
Libération :

Télécharger Lire en ligne



Vincent Rainardi A été écrit sous une forme ou une autre pendant la plus grande partie de sa vie. Vous pouvez trouver autant d'inspiration de Building a Data Warehouse: With Examples in SQL Server (Expert's Voice in SQL Server) by Vincent Rainardi (2011-12-15) Aussi informatif et amusant. Cliquez sur le bouton TÉLÉCHARGER ou Lire en ligne pour obtenir gratuitement le livre de titre $ gratuitement.

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

Titre : The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Auteur : Ralph Kimball
Éditeur : Wiley
ISBN-13 : 9781118530801
Libération :

Télécharger Lire en ligne



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 A Data Warehouse for Decision Support (2nd Edition)

Titre : Building A Data Warehouse for Decision Support (2nd Edition)
Auteur : Vidette Poe
Éditeur : Prentice Hall PTR
ISBN-13 : 9780137696390
Libération :

Télécharger Lire en ligne



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.

Building the Data Warehouse

Titre : Building the Data Warehouse
Auteur : W. H. Inmon
Éditeur : Wiley
ISBN-13 : 9780471081302
Libération :

Télécharger Lire en ligne



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 Data Warehouses Using the Corepula Method: A Comprehensive Data Modeling Approach to Building Database Schemas

Titre : Building Data Warehouses Using the Corepula Method: A Comprehensive Data Modeling Approach to Building Database Schemas
Auteur : Robert Mamayev
Éditeur : CreateSpace Independent Publishing Platform
ISBN-13 : 9781547206742
Libération :

Télécharger Lire en ligne



Written in simple, straightforward language, this book introduces users to the Corepula Method of data organization. Deeply rooted in solid mathematics, the Corepula Method teaches IT practitioners how to create data models that effortlessly evolve with ever-changing business requirements. The modeling approach described here can be used to build strategic enterprise-level data layers such as Enterprise Data Warehouse and Master Data Management. The numerous examples and modeling techniques included here should allow this book to become a powerful tool for anyone interested in data modeling and warehousing. Prerequisites to this book include the ability to read data modeling diagrams, some knowledge of basic data warehousing concepts, a desire to learn new things, and an open mind.

The Data Warehouse Lifecycle Toolkit: Practical Techniques For Building Datawarehouse And Business Intelligence Systems, 2Ed

Titre : The Data Warehouse Lifecycle Toolkit: Practical Techniques For Building Datawarehouse And Business Intelligence Systems, 2Ed
Auteur : Kimball
Éditeur : Om Books
ISBN-13 : 9788126516896
Libération :

Télécharger Lire en ligne



The book covers best practices from data warehouse project inception through on-going program management. About 30 to 40% of the content in the book is updated and new. This revised tutorial covers major lifecycle topics such as dimensional modeling, tech architecture, etl, bi etc. It is targeted at both novice and experienced data warehouse professionals. About the author: ralph kimball is known worldwide as an innovator, writer, educator, speaker and consultant in the field of data warehousing. His books on data warehousing and dimensional design techniques have become the all time best sellers in data warehousing. To date ralph has written more than 100 articles and columns for intelligent enterprise and its predecessors, winning the readers' choice award five years in a row. Margy ross is president of the kimball group. She has focused exclusively on decision support and data warehousing for more than twenty years. In addition to her consulting activities, margy teaches kimball university classes, both domestically and internationally. She co-authored the data warehouse toolkit, 2nd edition and the data warehouse lifecycle toolkit and regularly writes the data warehouse designer column for intelligent enterprise. Bob becker has worked to implement large-scale decision support and data warehousing systems since 1990. Bob teaches kimball university on-site courses. Joy mundy has focused on data warehousing and business intelligence since the early 1990s, specializing in business requirements analysis, dimensional modeling, and business intelligence systems architecture. Warren thornthwaite has been building decision support and data warehousing systems since 1980. Table of contents: acknowledgments introduction ?introducing the kimball lifecycle ?launching and managing the project/program ?collecting the requirements ?introducing the technical architecture ?creating the architecture plan and selecting products ?introducing dimensional modeling ?designing the dim

Building the Data Warehouse

Titre : Building the Data Warehouse
Auteur : W. H. Inmon
Éditeur : John Wiley & Sons
ISBN-13 : 9780471774235
Libération : 2005-10-03

Télécharger Lire en ligne



The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himself In addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media Discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects Covers advanced topics, including data monitoring and testing Although the book includes an extra 100 pages worth of valuable content, the price has actually been reduced from $65 to $55

Building the Data Warehouse

Titre : Building the Data Warehouse
Auteur : W. H. Inmon
Éditeur : John Wiley & Sons
ISBN-13 : 9780471270485
Libération : 2002-10-15

Télécharger Lire en ligne



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 4th Ed

Titre : BUILDING THE DATA WAREHOUSE 4th Ed
Auteur : William H. Inmon
Éditeur : John Wiley & Sons
ISBN-13 : 8126506458
Libération : 2005-01-01

Télécharger Lire en ligne



Market_Desc: · IT, Database, and Data Warehouse Managers and Developers Special Features: · Building the Data Warehouse has sold nearly 40,000 copies in its first 3 editions· Inmon is widely recognized as the Father of the Data Warehouse and remains one of the two leading authorities in the industry he helped to invent· The new edition covers new approaches and technologies, many of which have been pioneered by Inmon himself· Price of this new edition will be reduced from $65 to $55, and 100 new pages added About The Book: This book provides a high-level, conceptual overview of the major components of data warehouse systems, as well as the core approaches used to design and build data warehouses. Topics covered in this book are methods for handling unstructured data in a data warehouse, storing data across multiple storage media, the pros and cons of relational vs. multidimensional design, data monitoring and testing.

Building the Unstructured Data Warehouse

Titre : Building the Unstructured Data Warehouse
Auteur : Bill Inmon
Éditeur : Technics Publications
ISBN-13 : 9781634620345
Libération : 2011-01-01

Télécharger Lire en ligne



Learn essential techniques from data warehouse legend Bill Inmon on how to build the reporting environment your business needs now! Answers for many valuable business questions hide in text. How well can your existing reporting environment extract the necessary text from email, spreadsheets, and documents, and put it in a useful format for analytics and reporting? Transforming the traditional data warehouse into an efficient unstructured data warehouse requires additional skills from the analyst, architect, designer, and developer. This book will prepare you to successfully implement an unstructured data warehouse and, through clear explanations, examples, and case studies, you will learn new techniques and tips to successfully obtain and analyze text. Master these ten objectives: • Build an unstructured data warehouse using the 11-step approach • Integrate text and describe it in terms of homogeneity, relevance, medium, volume, and structure • Overcome challenges including blather, the Tower of Babel, and lack of natural relationships • Avoid the Data Junkyard and combat the “Spider’s Web” • Reuse techniques perfected in the traditional data warehouse and Data Warehouse 2.0,including iterative development • Apply essential techniques for textual Extract, Transform, and Load (ETL) such as phrase recognition, stop word filtering, and synonym replacement • Design the Document Inventory system and link unstructured text to structured data • Leverage indexes for efficient text analysis and taxonomies for useful external categorization • Manage large volumes of data using advanced techniques such as backward pointers • Evaluate technology choices suitable for unstructured data processing, such as data warehouse appliances The following outline briefly describes each chapter’s content: • Chapter 1 defines unstructured data and explains why text is the main focus of this book. The sources for text, including documents, email, and spreadsheets, are described in terms of factors such as homogeneity, relevance, and structure. • Chapter 2 addresses the challenges one faces when managing unstructured data. These challenges include volume, blather, the Tower of Babel, spelling, and lack of natural relationships. Learn how to avoid a data junkyard, which occurs when unstructured data is not properly integrated into the data warehouse. This chapter emphasizes the importance of storing integrated unstructured data in a relational structure. We are cautioned on both the commonality and dangers associated with text based on paper. • Chapter 3 begins with a timeline of applications, highlighting their evolution over the decades. Eventually, powerful yet siloed applications created a “spider’s web” environment. This chapter describes how data warehouses solved many problems, including the creation of corporate data, the ability to get out of the maintenance backlog conundrum, and greater data integrity and data accessibility. There were problems, however, with the data warehouse that were addressed in Data Warehouse 2.0 (DW 2.0), such as the inevitable data lifecycle. This chapter discusses the DW 2.0 architecture, which leads into the role of the unstructured data warehouse. The unstructured data warehouse is defined and benefits are given. There are several features of the conventional data warehouse that can be leveraged for the unstructured data warehouse, including ETL processing, textual integration, and iterative development. • Chapter 4 focuses on the heart of the unstructured data warehouse: Textual Extract, Transform, and Load (ETL). This chapter has separate sections on extracting text, transforming text, and loading text. The chapter emphasizes the issues around source data. There are a wide variety of sources, and each of the sources has its own set of considerations. Extracting pointers are provided, such as reading documents only once and recognizing common and different file types. Transforming text requires addressing many considerations discussed in this chapter, including phrase recognition, stop word filtering, and synonym replacement. Loading text is the final step. There are important points to understand here, too, that are explained in this chapter, such as the importance of the thematic approach and knowing how to handle large volumes of data. Two ETL examples are provided, one on email and one on spreadsheets. • Chapter 5 describes the 11 steps required to develop the unstructured data warehouse. The methodology explained in this chapter is a combination of both traditional system development lifecycle and spiral approaches. • Chapter 6 describes how to inventory documents for maximum analysis value, as well as link the unstructured text to structured data for even greater value. The Document Inventory is discussed, which is similar to a library card catalog used for organizing corporate documents. This chapter explores ways of linking unstructured text to structured data. The emphasis is on taking unstructured data and reducing it into a form of data that is structured. Related concepts to linking, such as probabilistic linkages and dynamic linkages, are discussed. • Chapter 7 goes through each of the different types of indexes necessary to make text analysis efficient. Indexes range from simple indexes, which are fast to create and are good if the analyst really knows what needs to be analyzed before the indexing process begins, to complex combined indexes, which can be made up of any and all of the other kinds of indexes. • Chapter 8 explains taxonomies and how they can be used within the unstructured data warehouse. Both simple and complicated taxonomies are discussed. Techniques to help the reader leverage taxonomies, including using preferred taxonomies, external categorization, and cluster analysis are described. Real world problems are raised, including the possibilities of encountering hierarchies, multiple types, and recursion. The chapter ends with a discussion comparing a taxonomy with a data model. • Chapter 9 explains ways of coping with large amounts of unstructured data. Techniques such as keeping the unstructured data at its source and using backward pointers are discussed. The chapter explains why iterative development is so important. Ways of reducing the amount of data are presented, including screening and removing extraneous data, as well as parallelizing the workload. • Chapter 10 focuses on challenges and some technology choices that are suitable for unstructured data processing. The traditional data warehouse processing technology is reviewed. In addition, the data warehouse appliance is discussed. • Chapters 11, 12, and 13 put all of the previously discussed techniques and approaches in context through three case studies: the Ablatz Medical Group, the Eastern Hills Oil Company, and the Amber Oil Company.

The Data Webhouse Toolkit

Titre : The Data Webhouse Toolkit
Auteur : Ralph Kimball
Éditeur : Wiley
ISBN-13 : 0471376809
Libération : 2000-02-03

Télécharger Lire en ligne



"Ralph's latest book ushers in the second wave of the Internet. . . . Bottom line, this book provides the insight to help companies combine Internet-based business intelligence with the bounty of customer data generated from the internet."--William Schmarzo, Director World Wide Solutions, Sales, and Marketing,IBM NUMA-Q. Receiving over 100 million hits a day, the most popular commercial Websites have an excellent opportunity to collect valuable customer data that can help create better service and improve sales. Companies can use this information to determine buying habits, provide customers with recommendations on new products, and much more. Unfortunately, many companies fail to take full advantage of this deluge of information because they lack the necessary resources to effectively analyze it. In this groundbreaking guide, data warehousing's bestselling author, Ralph Kimball, introduces readers to the Data Webhouse--the marriage of the data warehouse and the Web. If designed and deployed correctly, the Webhouse can become the linchpin of the modern, customer-focused company, providing competitive information essential to managers and strategic decision makers. In this book, Dr. Kimball explains the key elements of the Webhouse and provides detailed guidelines for designing, building, and managing the Webhouse. The results are a business better positioned to stay healthy and competitive. In this book, you'll learn methods for: - Tracking Website user actions - Determining whether a customer is about to switch to a competitor - Determining whether a particular Web ad is working - Capturing data points about customer behavior - Designing the Website to support Webhousing - Building clickstream datamarts - Designing the Webhouse user interface - Managing and scaling the Webhouse The companion Website at www.wiley.com/compbooks/kimball provides updates on Webhouse technologies and techniques, as well as links to related sites and resources.

Building a Scalable Data Warehouse with Data Vault 2 0

Titre : Building a Scalable Data Warehouse with Data Vault 2 0
Auteur : Dan Linstedt
Éditeur : Morgan Kaufmann
ISBN-13 : 9780128026489
Libération : 2015-09-15

Télécharger Lire en ligne



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

Building A Data Warehouse With Examples In Sql Server

Titre : Building A Data Warehouse With Examples In Sql Server
Auteur : Vincent Rainardi
Éditeur : John Wiley & Sons
ISBN-13 : 8181289714
Libération : 2008-05-30

Télécharger Lire en ligne



The book describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The RDBMS used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.· Introduction to Data Warehousing· Data Warehouse Architecture· Data Warehouse Development Methodology· Functional and Non-Functional Requirements· Data Modeling· Physical Database Design· Data Extraction· Populating the Data Warehouse· Assuring Data Quality· Metadata· Building Reports· Multidimensional Database· Using Data Warehouse for Business Intelligence· Using Data Warehouse for Customer Relationship Management· Other Datawarehouse Usage· Testing your DataWarehouse· Data Warehouse Administration

Building Using and Managing the Data Warehouse

Titre : Building Using and Managing the Data Warehouse
Auteur : Ramón C. Barquín
Éditeur : Prentice Hall
ISBN-13 : 0135343550
Libération : 1997

Télécharger Lire en ligne



When it comes to making organizations smarter, faster, and more competitive, few technologies have more promise than data warehousing. This book shows you how to translate that promise into reality.

The Data Warehouse Toolkit

Titre : The Data Warehouse Toolkit
Auteur : Ralph Kimball
Éditeur : John Wiley & Sons
ISBN-13 : 9781118732281
Libération : 2013-07-01

Télécharger Lire en ligne



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 the Operational Data Store

Titre : Building the Operational Data Store
Auteur : W. H. Inmon
Éditeur : Wiley
ISBN-13 : 047132888X
Libération : 1999-06-11

Télécharger Lire en ligne



The most comprehensive guide to building, using, and managing the operational data store. Building the Operational Data Store, Second Edition. In the five years since the publication of the first edition of this book, the operational data store has grown from an intriguing concept to an exciting reality at enterprise organizations, worldwide. Still the only guide on the subject, this revised and expanded edition of Bill Inmon's classic goes beyond the theory of the first edition to provide detailed, practical guidance on designing, building, managing, and getting the most of an ODS. With the help of fascinating and instructive case studies, Inmon shares what he knows about: * How the ODS fits with the corporate information factory. * Different types of ODS and how to choose the right one for your organization. * Designing and building an ODS from scratch. * Managing and fine-tuning an ODS for peak efficiency. * ODS support technology. * The pros and cons of competing off-the-shelf ODS products. * The advantages and disadvantages of various hardware and software platforms. * Integrating the ODS with data marts. * Distributed metadata using the ODS. * Data aggregation within the ODS. * Business process reengineering and the ODS. * The role of standards in the ODS. Visit our Web site at www.wiley.com/compbooks/