The Unified Star Schema: An Agile and Resilient Approach to Data Warehouse and Analytics Design - Image 1

£35.82

Technics Publications The Unified Star Schema: An Agile and Resilient Approach to Data Warehouse and Analytics Design

Name: The Unified Star Schema: An Agile and Resilient Approach to Data Warehouse and Analytics Design
Brand: Technics Publications
Price: 35.82 GBP
Availability: InStock

Business, Finance & Law

About as cheap as it gets. The only time it was cheaper was 3 months ago.

£36 today · all-time low £35 (Mar 2026) · usually the usual

NEW HERE?

Amazon shows you one price. We show you all of them.

Tosheroon watches Amazon prices so you don't have to. Every product on Amazon has a price history — we make it visible. Set the price you'd actually pay, and we'll email you the second it gets there. No app, no account, one email.

WHAT'S ON THIS PAGE

↓ Price chart
when this has been cheap or pricey

↓ Forecast
where the price is heading next

↓ Statistics
all-time high & low, recent range

↑ Price alert
name your number, we'll email you

Price History & Forecast

Grey patches = out of stock. Cheaper = lower on the chart. Hover for exact prices.

Last 8 days • 8 data points (No recent data available)

Historical

Generating forecast...

Price Distribution

Price distribution over 8 days • 2 price levels

Days at Price

Current Price

Price Analysis

Most common price: £35 (4 days, 50.0%)

Price range: £35 - £36

Price levels: 2 different prices over 8 days

Description

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 to the 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 architecture 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.

Product Specifications

Brand: Technics Publications
Format: Paperback
ASIN: 163462887X
Category: Books > Subjects > Business, Finance & Law
Domain: Amazon UK
Publication Date: 12 October 2020
Listed Since: 15 September 2020

Barcode

No barcode data available

Technics Publications The Unified Star Schema: An Agile and Resilient Approach to Data Warehouse and Analytics Design

About as cheap as it gets. The only time it was cheaper was 3 months ago.

Price History & Forecast

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

Database Development and Management (Foundations of Database Design)

Extreme Scoping: An Agile Approach to Enterprise Data Warehousing and Business Intelligence

Informix SQL Reference Library (Boxed Set)

Data Model Scorecard: Applying the Industry Standard on Data Model Quality

Expert Data Modeling with Power BI: Enrich and optimize your data models to get the best out of Power BI for reporting and business needs

Data Modeling Made Simple with erwin DM

Data Modeling Master Class Training Manual 7th Edition: Steve Hoberman’s Best Practices Approach to Understanding and Applying Fundamentals through Advanced Modeling Techniques

High-Performance Big-Data Analytics: Computing Systems and Approaches (Computer Communications and Networks)

Methods and Supporting Technologies for Data Analysis: 225 (Studies in Computational Intelligence, 225)

New Trends in Database and Information Systems: ADBIS 2021 Short Papers, Doctoral Consortium and Workshops: DOING, SIMPDA, MADEISD, MegaData, CAoNS, ... in Computer and Information Science, 1450)

Data Modeling with Snowflake: A practical guide to accelerating Snowflake development using universal modeling techniques

Data Warehousing Fundamentals for IT Professionals

Modern Data Architecture on Azure: Design Data-centric Solutions on Microsoft Azure

Database Design and Relational Theory: Normal Forms and All That Jazz

Big Data Analytics: A Management Perspective: 21 (Studies in Big Data, 21)

Handbook of Data Management: 1999 Edition

Mastering Snowflake Solutions: Supporting Analytics and Data Sharing

Data Management at Scale: Best Practices for Enterprise Architecture

Advanced Data Management: For SQL, NoSQL, Cloud and Distributed Databases

The Beginner's Guide to Data Science

DATABASES, DATA SCIENCE, AND DATA ANALYTICS FUNDAMENTALS: Course Slides: Basic SQL, IBM Cloud DB2, Microsoft Access, Microsoft Excel, Python, QDM SQL, Risk Simulator, ROV BizStats

Innovative Techniques and Applications of Entity Resolution (Advances in Data Mining and Database Management)

Advances in Internet, Data and Web Technologies: The 9th International Conference on Emerging Internet, Data & Web Technologies (EIDWT-2021): 65 ... and Communications Technologies, 65)

Towards Digital Intelligence Society: A Knowledge-based Approach: 1281 (Advances in Intelligent Systems and Computing, 1281)