The Textual Warehouse, Inmon Bill, Srivastava Ranjeet
Автор: Dan Linstedt Название: Building a Scalable Data Warehouse with Data Vault 2.0 ISBN: 0128025107 ISBN-13(EAN): 9780128025109 Издательство: Elsevier Science Рейтинг: Цена: 9262.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание:
TheData 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
Описание: Master the most agile and resilient design for building analytics applications: the Unified Star Schema (USS) approach. The USS has many benefits over traditional dimensional modeling. Witness the power of the USS as a single star schema that serves as a foundation for all present and future business requirements of your organization. Data warehouse legend Bill Inmon and data warehouse expert, Francesco Puppini, explain step-by-step, why the USS approach is the preferred approach for business intelligence designs today, and how to use this approach through many examples.This book contains two parts. Part I, Architecture, explains the benefits of data marts and data warehouses, covering how organizations progressed to their current state of analytics, and challenges that result from current business intelligence architectures. Chapter 1 covers the drivers behind and the characteristics of the data warehouse and data mart. Chapter 2 introduces dimensional modeling concepts, including fact tables, dimensions, star joins, and snowflakes. Chapter 3 recalls the evolution of the data mart. Chapter 4 explains Extract, Transform, and Load (ETL), and the value ETL brings to reporting. Chapter 5 explores the Integrated Data Mart Approach, and Chapter 6 explains how to monitor this environment. Chapter 7 describes the different types of metadata within the data warehouse environment. Chapter 8 progresses through the evolution to our current modern data warehouse environment. Part II, the Unified Star Schema, covers the Unified Star Schema (USS) approach and how it solves the challenges introduced in Part I. There are eight chapters within Part II: Chapter 9, Introduction to the Unified Star Schema: Learn about its achitecture and use cases, as well as how the USS approach differs from the traditional approach. Chapter 10, Loss of Data: Learn about the loss of data and the USS Bridge. Understand that the USS approach does not create any join, and for this reason, it has no loss of data. Chapter 11, The Fan Trap: Get introduced to the Oriented Data Model convention, and learn the dangers of a fan trap through an example. Differentiate join and association, and realize that an in-memory association is the preferred solution to the fan trap. Chapter 12, The Chasm Trap: Become familiar with the Cartesian product, and then follow along with an example based on LinkedIn, which illustrates that a chasm trap produces unwanted duplicates. See that the USS Bridge is based on a union, which does not create any duplicates. Chapter 13, Multi-Fact Queries: Distinguish between multiple facts with direct connection versus multiple facts with no direct connection. Explore how BI tools are capable of building aggregated virtual rows. Chapter 14, Loops: Learn more about loops and five traditional techniques to solve them. Follow along with an implementation, which will illustrate the solution based on the USS approach. Chapter 15, Non-Conformed Granularities: Learn about non-conformed granularities, and learn that the Unified Star Schema introduces a solution called re-normalization. Chapter 16, Northwind Case Study. Witness how easy it is to detect the pitfalls of Northwind using the ODM convention. Follow along with an implementation of the USS approach on the Northwind database with various BI tools.
Описание: This book describes warehouse-scale computers (WSCs), the computing platforms that power cloud computing and all the great web services we use every day. It discusses how these new systems treat the datacenter itself as one massive computer designed at warehouse scale, with hardware and software working in concert to deliver good levels of internet service performance. The book details the architecture of WSCs and covers the main factors influencing their design, operation, and cost structure, and the characteristics of their software base. Each chapter contains multiple real-world examples, including detailed case studies and previously unpublished details of the infrastructure used to power Google's online services. Targeted at the architects and programmers of today's WSCs, this book provides a great foundation for those looking to innovate in this fascinating and important area, but the material will also be broadly interesting to those who just want to understand the infrastructure powering the internet.The third edition reflects four years of advancements since the previous edition and nearly doubles the number of pictures and figures. New topics range from additional workloads like video streaming, machine learning, and public cloud to specialized silicon accelerators, storage and network building blocks, and a revised discussion of data center power and cooling, and uptime. Further discussions of emerging trends and opportunities ensure that this revised edition will remain an essential resource for educators and professionals working on the next generation of WSCs.
Автор: Gavin JT Powell Название: Oracle Data Warehouse Tuning for 10g, ISBN: 1555583350 ISBN-13(EAN): 9781555583354 Издательство: Неизвестно Рейтинг: Цена: 23220.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Tuning a data warehouse database focuses on large transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network and Internet environment, backwards and forwards, constantly. This title explores critical issues in running efficient data warehouse applications.
Автор: Michael Hompel; Thorsten Schmidt Название: Warehouse Management ISBN: 3642439896 ISBN-13(EAN): 9783642439896 Издательство: Springer Рейтинг: Цена: 19376.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: This book helps readers evaluate and specificy the best Warehouse Management System (WMS) for their need. New approaches in the structure and design of WMS are presented, along with discussion of the limitations of current systems. The book shows how to operate a simple WMS based on the open-source initiative myWMS.
Автор: W. H. Inmon Название: Building the Data Warehouse, 4th Edition ISBN: 0764599445 ISBN-13(EAN): 9780764599446 Издательство: Wiley Рейтинг: Цена: 5861.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Explains the fundamentals of data warehouse systems. This book covers topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media, and discusses the pros and cons of relational versus multidimensional design, and how to measure return on investment in planning data warehouse projects.
Автор: Naveen Prakash; Deepika Prakash Название: Data Warehouse Requirements Engineering ISBN: 9811070180 ISBN-13(EAN): 9789811070181 Издательство: Springer Рейтинг: Цена: 10366.00 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: As the first to focus on the issue of Data Warehouse Requirements Engineering, this book introduces a model-driven requirements process used to identify requirements granules and incrementally develop data warehouse fragments. In addition, it presents an approach to the pair-wise integration of requirements granules for consolidating multiple data warehouse fragments. The process is systematic and does away with the fuzziness associated with existing techniques. Thus, consolidation is treated as a requirements engineering issue.The notion of a decision occupies a central position in the decision-based approach. On one hand, information relevant to a decision must be elicited from stakeholders; modeled; and transformed into multi-dimensional form. On the other, decisions themselves are to be obtained from decision applications. For the former, the authors introduce a suite of information elicitation techniques specific to data warehousing. This information is subsequently converted into multi-dimensional form. For the latter, not only are decisions obtained from decision applications for managing operational businesses, but also from applications for formulating business policies and for defining rules for enforcing policies, respectively. In this context, the book presents a broad range of models, tools and techniques. For readers from academia, the book identifies the scientific/technological problems it addresses and provides cogent arguments for the proposed solutions; for readers from industry, it presents an approach for ensuring that the product meets its requirements while ensuring low lead times in delivery.
Описание: The evaluation method takes into account the intensity of the energy supplied to the logistics system and reduces the storage of the recovered energy - this figure represents the energy needed to pass through the logistics unit load storage system, and can be expressed in an energy intensity map.
Описание: Warehouses are often seen as a necessary evil: places that stop the flow of goods and thus increase costs without adding value. But the truth is that they have a critical part to play in supply chain management, and warehouse managers should be centrally involved in the strategic aspects of any business.
Описание: Data warehousing is split into two camps: Ralph Kimball leads those who champion a technique called dimensional modeling; Bill Inmon leads the rest who believe in using relational modeling techniques.
Описание: This is the companion book to "Tax Free Cash Growth Warehouse - The 178 Year Old Secret". Within these pages you will find eight different examples of how to put the Tax Free Cash Growth Warehouse Strategy to work in ways that will enhance the growth of your wealth while you put your money to work for you as you become your own "banker" and self finance everything you buy
Описание: Single most authoritative guide from the inventor of the technique. Presents unique modeling techniques for e-commerce, and shows strategies for optimizing performance. Companion Web site provides updates on dimensional modeling techniques, links related to sites, and source code where appropriate.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru
