|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910816655703321 |
|
|
Autore |
Webb Chris |
|
|
Titolo |
Expert cube development with Microsoft SQL Server 2008 Analysis Services : design and implement fast, scalable, and maintainable cubes / / Chris Webb, Alberto Ferrari, Marco Russo |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Birmingham, UK, : Packt Publishing, 2009 |
|
|
|
|
|
|
|
ISBN |
|
1-282-23815-9 |
1-84719-723-X |
9786612238154 |
1-84719-722-1 |
|
|
|
|
|
|
|
|
Edizione |
[1st ed.] |
|
|
|
|
|
Descrizione fisica |
|
1 online resource (360 p.) |
|
|
|
|
|
|
Collana |
|
From technologies to solutions |
|
|
|
|
|
|
Altri autori (Persone) |
|
FerrariAlberto |
RussoMarco |
|
|
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
Soggetti |
|
Client/server computing |
OLAP technology |
Data mining |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di contenuto |
|
Intro -- Expert Cube Development with Microsoft SQL Server 2008 Analysis Services -- Table of Contents -- Expert Cube Development with Microsoft SQL Server 2008 Analysis Services -- Credits -- About the Authors -- About the Reviewers -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code and database for the book -- Errata -- Piracy -- Questions -- 1. Designing the Data Warehouse for Analysis Services -- The source database -- The OLTP database -- The data warehouse -- The data mart -- Data modeling for Analysis Services -- Fact tables and dimension tables -- Star schemas and snowflake schemas -- Junk dimensions -- Degenerate dimensions -- Slowly Changing Dimensions -- Bridge tables, or factless fact tables -- Snapshot and transaction fact tables -- Updating fact and dimension tables -- Natural and surrogate keys -- Unknown members, key errors, and NULLability -- Physical database design for Analysis Services -- Multiple data sources |
|
|
|
|