The Microsoft data warehouse toolkit: with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Indianapolis, Ind.
Wiley
2011
|
| Edition: | 2. ed. |
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Item Description: | Includes index. |
| Physical Description: | XLVI, 648 S. Ill., graph. Darst. 24 cm |
| ISBN: | 9780470640388 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV037372012 | ||
| 003 | DE-604 | ||
| 005 | 20150128 | ||
| 007 | t| | ||
| 008 | 110429s2011 xxuad|| |||| 00||| eng d | ||
| 020 | |a 9780470640388 |9 978-0-470-64038-8 | ||
| 035 | |a (OCoLC)868980776 | ||
| 035 | |a (DE-599)BVBBV037372012 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-863 | ||
| 050 | 0 | |a QA76.9.D37 | |
| 082 | 0 | |a 005.74 | |
| 084 | |a QP 345 |0 (DE-625)141866: |2 rvk | ||
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 084 | |a ST 530 |0 (DE-625)143679: |2 rvk | ||
| 100 | 1 | |a Mundy, Joy |d 1961- |e Verfasser |0 (DE-588)173854435 |4 aut | |
| 245 | 1 | 0 | |a The Microsoft data warehouse toolkit |b with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset |c Joy Mundy and Warren Thornthwaite with Ralph Kimball |
| 250 | |a 2. ed. | ||
| 264 | 1 | |a Indianapolis, Ind. |b Wiley |c 2011 | |
| 300 | |a XLVI, 648 S. |b Ill., graph. Darst. |c 24 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 630 | 0 | 4 | |a SQL server |
| 650 | 4 | |a Data warehousing | |
| 650 | 0 | 7 | |a SQL Server 2008 |0 (DE-588)7604407-5 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |D s |
| 689 | 0 | 1 | |a SQL Server 2008 |0 (DE-588)7604407-5 |D s |
| 689 | 0 | |C b |5 DE-604 | |
| 700 | 1 | |a Thornthwaite, Warren |d 1957- |e Verfasser |0 (DE-588)173854443 |4 aut | |
| 700 | 1 | |a Kimball, Ralph |d 1944- |e Sonstige |0 (DE-588)1031963626 |4 oth | |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-118-06793-2 |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-118-06794-9 |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-118-06795-6 |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=022525333&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-022525333 | |
Record in the Search Index
| DE-BY-863_location | 1000 |
|---|---|
| DE-BY-FWS_call_number | 1000/ST 530 M965(2)st 1000/ST 530 M965(2) |
| DE-BY-FWS_katkey | 434341 |
| DE-BY-FWS_media_number | 083101212372 083101212383 083101281353 |
| _version_ | 1824555693693206528 |
| adam_text |
Titel: The Microsoft® data warehouse toolkit
Autor: Mundy, Joy
Jahr: 2011
Contents
Foreword xxvii
Introduction xxix
Part 1 Requirements, Realities, and Architecture 1
Chapter 1 Defining Business Requirements 3
The Most Important Determinant of Long-Term Success 5
Adventure Works Cycles Introduction 6
Uncovering Business Value 6
Obtaining Sponsorship 7
Defining Enterprise-Level Business Requirements 8
Establishing Initial Enterprise Requirements Project Scope 9
Gathering and Documenting Enterprise-Level Business
Requirements 10
Data Auditing/Data Profiling 16
Creating the Program Requirements Findings Document 18
Prioritizing the Business Requirements 22
Revisiting the Project Planning 25
Gathering Project-Level Requirements 26
Summary 28
Chapter 2 Designing the Business Process Dimensional Model 29
Dimensional Modeling Concepts and Terminology 30
Facts 31
Just the Facts 32
The Grain 33
Dimensions 33
Bringing Facts and Dimensions Together 34
The Bus Matrix, Conformed Dimensions, and Drill Across 36
XIII
xhr Contents
Additional Design Concepts and Techniques 38
Surrogate Keys 38
Slowly Changing Dimensions 39
Dates 42
Degenerate Dimensions 43
Snowflaking 43
Many-to-Many or Multivalued Dimensions 44
The Many-to-Many Relationship Between a Fact
and Dimension 45
Many-to-Many Between Dimensions 46
Hierarchies 47
Variable-Depth Hierarchies 48
Frequently Changing Hierarchies 49
Aggregate Dimensions 49
Junk Dimensions 51
The Three Fact Table Types 52
Aggregates 53
The Dimensional Modeling Process 54
Preparation 55
Identify Roles and Participants 55
Revisit the Requirements 56
Understand the Data Architecture Strategy 58
Set Up the Modeling Environment 58
Establish Naming Conventions 59
Data Profiling and Research 60
Data Profiling and Source System Exploration 60
Building Dimensional Models 63
High-Level Dimensional Model Design Session 63
Identifying Dimension Attributes and Fact Measures 65
Developing the Detailed Dimensional Model 66
Testing and Refining the Model 68
Reviewing and Validating the Model 68
Case Study: The Adventure Works Cycles
Orders Dimensional Model 69
The Orders Fact Table 69
The Dimensions 69
Employee 69
Customer and Reseller 70
Currency 71
Identifying Dimension Attributes and Facts for the
Orders Business Process 72
The Final Draft of the Initial Orders Model 74
Detailed Orders Dimensional Model Development 75
Identifying SCD Change Types 75
Reviewing the Issues 76
Identifying the Facts 76
Final Dimensional Model 77
Summary 77
Contents xv
Chapter 3 The Toolset 79
The Microsoft DW/BI Toolset 80
Why Use the Microsoft Toolset? 82
Architecture of a Microsoft DW/BI System 83
Why Analysis Services? 84
Why a Relational Store? 86
ETL Is Not Optional 86
The Role of Master Data Services 88
Delivering BI Applications 88
Overview of the Microsoft Tools 89
Which Products Do You Need? 90
SQL Server Development and Management Tools 92
SQL Server Management Studio 92
Business Intelligence Development Studio (BIDS) 95
Summary 97
Chapter 4 System Setup 99
System Sizing Considerations 100
Calculating Data Volumes 101
Determining Usage Complexity 102
Simple or Controlled Access 102
Moderate Complexity 103
Highly Demanding Use 103
Estimating Simultaneous Users 104
Assessing System Availability Requirements 105
How Big Will It Be? 105
System Configuration Considerations 105
Memory 106
Monolithic or Distributed? 106
Storage System Considerations 110
Balancing the Data Pipeline 110
Disk Performance 111
Fault Tolerance and RAID 112
Storage Area Networks 112
Processors 113
Setting Up for High Availability 114
Software Installation and Configuration 115
Development Environment Software Requirements 116
Development Database Server 117
Database Designer 117
Development Database Administrator 118
ETL System Developer 118
Report Designer 119
Reporting Portal Developer 119
Data Mining Model Developer 120
Analytic Application Developer 120
xvi Contents
Test and Production Software Requirements 120
Database Server 121
Database Administrator 121
Operating Systems 122
SQL Server Relational Database Setup 122
Security Options During Installation 123
Files, Filegroups, and RAID 123
Database Recovery Model 125
Initial Database Size 126
Analysis Services Setup 126
Analysis Services File Locations and Storage Requirements 127
Analysis Services and Memory 128
Integration Services Setup 129
Integration Services File Locations and Storage Requirements 130
Reporting Services Setup 130
Summary 131
Part 2 Building and Populating the Databases 133
Chapter 5 Creating the Relational Data Warehouse 135
Getting Started 136
Complete the Physical Design 137
Surrogate Keys 138
String Columns 138
To Null, or Not to Null? 140
Housekeeping Columns 140
Table and Column Extended Properties 142
Define Storage and Create Constraints and Supporting Objects 142
Create Files and Filegroups 142
Data Compression 144
Entity and Referential Integrity Constraints 145
Initial Indexing and Database Statistics 147
Dimension Indexes 147
Fact Table Indexes 149
Statistics 149
Aggregate Tables 150
Create Table Views 151
Insert an Unknown Member Row 152
Example CREATE TABLE Statement 152
Partitioned Tables 153
How Does Table Partitioning Work? 154
Managing Partitioned Tables 158
Using Partitioned Tables in the Data Warehouse Database 162
Finishing Up 163
Staging Tables 163
Metadata Setup 163
Summary 164
Contents xvii
Chapter 6 Master Data Management 165
Managing Master Reference Data 166
Incomplete Attributes 167
Data Integration 168
Systems Integration 170
Master Data Management Systems and the Data Warehouse 171
Introducing SQL Server Master Data Services 171
Model Definition Features 172
User Interface: Defining the Master Data Model 172
Creating Database Structures 173
Security 173
Programmability of Model Definition 174
Full Versioning of Models 174
Data Management Features 174
User Interface: Exploring and Managing the Master Data 174
Importing and Updating Data 176
Exporting Data 177
Full Versioning of All Attributes 179
Creating a Simple Application 179
The Business Scenario 179
Keep It Simple 180
Create the MDS Model 180
Load the Subcategory Members 183
Polish the Model 185
Export to the Data Warehouse 185
Summary 186
Chapter 7 Designing and Developing the ETL System 187
Round Up the Requirements 188
Develop the ETL Plan 191
Introducing SQL Server Integration Services 192
Control Flow and Data Flow 194
Data Flow 195
Error Flows 196
SSIS Package Architecture 197
The Major Subsystems of ETL 198
Extracting Data 199
Subsystem 1: Data Profiling 199
Subsystem 2: Change Data Capture System 200
Subsystem 3: Extract System 202
Loading Data 204
Cleaning and Conforming Data 206
Subsystem 4: Data Cleaning System 206
Cleaning Data in the Data Flow 207
Halting Package Execution 211
xviii Contents
Subsystem 5: Error Event Schema 214
Subsystem 6: Audit Dimension Assembler 215
Subsystem 7: Deduplication System 216
Subsystem 8: Conforming System 217
Delivering Data for Presentation 218
Subsystem 9: Slowly Changing Dimension Manager 218
Standard Handling for Slowly Changing Dimensions 219
Custom Handling for Slowly Changing Dimensions 221
Alternatives to the Slowly Changing Dimension Transform 221
Subsystem 10: Surrogate Key Generator 223
Subsystem 11: Hierarchy Manager 223
Subsystem 12: Special Dimensions Manager 224
Subsystem 13: Fact Table Builders 225
Transaction Grain Fact Table Loader 226
Periodic Snapshot Fact Table Loader 228
Accumulating Snapshot Fact Table Loader 229
Subsystem 14: Surrogate Key Pipeline 229
Surrogate Key Pipeline Technique #1: Cascading Lookups 231
Surrogate Key Pipeline Technique #2: Database Joins 233
Which Technique is Best? 234
Subsystem 15: Multi-Valued Dimension Bridge Table Builder 235
Subsystem 16: Late Arriving Data Handler 235
Late Arriving Dimension Members 235
Late Arriving Dimension Updates 236
Late Arriving Facts 236
Subsystem 17: Dimension Manager 238
Subsystem 18: Fact Provider System 238
Subsystem 19: Aggregate Builder 239
Subsystem 20: OLAP Cube Builder 239
Subsystem 21: Data Propagation Manager 240
Managing the ETL Environment 240
Summary 243
Chapter 8 The Core Analysis Services OLAP Database 245
Overview of Analysis Services OLAP 247
Why Use Analysis Services? 247
Why Not Analysis Services? 249
Designing the OLAP Structure 250
Planning 251
Cube Content 251
Cube Granularity 252
Cube Usage 252
Getting Started 253
Setup 253
Create Relational Views 253
Populate the Data Warehouse Database 254
Contents xbt
Create a Project and a Data Source View 255
Dimension Designs 257
Standard Dimensions 258
Variable Depth or Parent-Child Hierarchies 259
Multivalued or Many-to-Many Dimensions 259
Role-Playing Dimensions 260
Creating and Editing Dimensions 261
Editing Dimension Properties 265
Editing Attribute Properties 266
Time and Account Dimensions 267
Creating Hierarchies 268
Set Up Attribute Relationships 270
Browsing Dimension Data 273
Creating and Editing the Cube 274
Edit the Cube Structure 276
Edit Dimension Usage 279
Build, Deploy, and Process the Project 281
Create Calculations 282
Define Key Performance Indicators 287
Create Actions 288
Partitions and Aggregations 289
Maintain Perspectives 290
Translations 290
Physical Design Considerations 291
Understanding Storage Modes 293
Developing the Partitioning Plan 294
Designing Performance Aggregations 296
Planning for Deployment 298
Processing the Full Cube 299
Developing the Incremental Processing Plan 299
Scheduled Processing 300
Planning for Updates to Dimensions 302
Planning for Fact Updates and Deletes 303
Summary 304
Chapter 9 Design Requirements for Real-Time Bl 305
Real-Time Triage 306
What Does Real-Time Mean? 306
Who Needs Real Time? 307
Real-Time Tradeoffs 308
Scenarios and Solutions 311
Executing Reports in Real Time 313
Serving Reports from a Cache 313
Creating an ODS with Mirrors and Snapshots 314
Creating an ODS with Replication 314
Building a BizTalk Application 315
xx Contents
Part 3
Chapter 10
Building a Real-Time Relational Partition 315
Querying Real-Time Data in the Relational Database 317
Using Analysis Services to Query Real-Time Data 318
Summary 319
Developing the Bl Applications 321
Building Bl Applications in Reporting Services 323
A Brief Overview of Bl Applications 324
Types of Bl Applications 325
The Value of Business Intelligence Applications 326
A High-Level Architecture for Reporting 328
Reviewing Business Requirements for Reporting 328
Examining the Reporting Services Architecture 330
Using Reporting Services as a Standard Reporting Tool 332
Creating Reports 333
Finding Reports 334
Viewing Reports 336
Receiving Results 337
Changing Reports 337
Solid, Reliable System 339
Reporting Services Assessment 339
The Reporting System Design and Development Process 340
Reporting System Design 341
Determining the Initial Report Set 341
Creating the Report Template 343
Creating Report Specifications and Documentation 345
Designing the Navigation Framework 347
Conducting the User Review 348
Reporting System Development 348
Prepare 349
Build 349
Test 350
Deploy 350
Building and Delivering Reports 351
Planning and Preparation 351
Setting Up the Development Environment 351
Creating Standard Templates 352
Creating Reports 354
Revisit the Report Specifications 354
The Report Creation Process 355
Creating Your First Standard Report 356
Reporting Operations 368
Ad Hoc Reporting Options 369
The Report Model 370
Shared Datasets 371
Report Parts 371
Summary 372
Contents xxi
Chapter 11 PowerPivot and Excel 375
Using Excel for Analysis and Reporting 376
The PowerPivot Architecture: Excel on Steroids 378
Creating and Using PowerPivot Databases 380
Getting Started 381
PowerPivot Table Design 381
Loading the Data 382
Creating the Relationships 383
Creating Analytics with PowerPivot 385
Creating a PowerPivot PivotTable 385
Adding New Measures to the PivotTable 386
The CALCULATE() Function 387
Adding a Computed Column to the PivotTable Database 390
Observations and Guidelines on PowerPivot for Excel 392
PowerPivot for SharePoint 394
The PowerPivot SharePoint User Experience 394
PowerPivot Publishing 394
PowerPivot Viewing 396
PowerPivot as a Data Source 396
Server-Level Resources 397
PowerPivot Monitoring and Management 397
PowerPivot Monitoring 398
PowerPivot Workbook Publishing Process 400
PowerPivot's Role in a Managed DW/BI Environment 400
Summary 401
Chapter 12 The Bl Portal and SharePoint 403
The Bl Portal 404
Planning the Bl Portal 405
Impact on Design 406
Business Process Categories 407
Additional Functions 408
Building the Bl Portal 409
Using SharePoint as the Bl Portal 411
Architecture and Concepts 412
SharePoint's Three-Tier Architecture and Topology 412
SharePoint Terminology 414
Setting Up SharePoint 417
The Installation Process 417
Plan SharePoint for Bl 419
Installing the Test System 421
Completing the Bl Portal 424
The Added Functionality of the BIPortal Site Template 425
Exploring SharePoint 426
Summary 426
xxii Contents
Chapter 13
Incorporating Data Mining 429
Defining Data Mining 430
Basic Data Mining Terminology 432
Business Uses of Data Mining 433
Classification 434
Estimation (Regression) 434
Prediction 435
Association or Affinity Grouping 436
Clustering (Segmentation) 436
Anomaly Detection 438
Description and Profiling 438
Business Task Summary 438
Roles and Responsibilities 440
SQL Server Data Mining Architecture Overview 440
The Data Mining Design Environment 442
Build, Deploy, and Process 442
Accessing the Mining Models 443
Integration Services and Data Mining 443
Additional Features 444
Architecture Summary 445
Microsoft Data Mining Algorithms 445
Decision Trees 446
Naive Bayes 447
Clustering 448
Sequence Clustering 448
Time Series 449
Association 449
Neural Network 449
The Data Mining Process 450
The Business Phase 451
Identifying Business Opportunities 451
Understanding the Data 452
Describing the Data Mining Opportunity 452
The Data Mining Phase 453
Data Preparation 453
Model Development 456
Model Validation (Evaluation) 457
The Operations Phase 460
Implementation 460
Assess Impact 461
Maintain the Model 461
Metadata 462
Contents xxiii
Part 4
Data Mining Examples
Case Study: Categorizing Cities
Categorizing Cities: Business Opportunity
Categorizing Cities: Data Understanding
Categorizing Cities: Data Preparation
Categorizing Cities: Model Development
Categorizing Cities: Model Validation
Categorizing Cities: Implementation
Categorization Cities: Maintenance and Assessment
Case Study: Product Recommendations
Product Recommendations: The Business Phase
Product Recommendations: The Data Mining Phase
Product Recommendations: The Operations Phase
Summary
Deploying and Managing the DW/BI System
Chapter 14 Designing and Implementing Security
Identifying the Security Manager
Securing the Hardware and Operating System
Securing the Operating System
Using Windows Integrated Security
Securing the Development Environment
Securing the Data
Providing Open Access for Internal Users
Itemizing Sensitive Data
Securing Various Types of Data Access
Securing the Components of the DW/BI System
Reporting Services Security
Administrative Roles for Reporting Services
User Roles for Reporting Services
Reporting Services in SharePoint Integrated Mode
Analysis Services Security
Administrative Roles for Analysis Services
User Roles for Analysis Services
Dynamic Security
PowerPivot Security
Relational DW Security
Administrative Roles for the Relational Database
User Roles for the Relational Database
Integration Services Security
Usage Monitoring
Summary
463
463
464
464
465
466
470
470
471
472
472
474
487
488
491
493
494
495
495
496
497
498
498
500
500
502
502
502
504
504
505
505
506
513
514
514
515
515
520
521
521
xxrv Contents
Chapter 15
Chapter 16
Metadata Plan 523
Metadata Basics 524
The Purpose of Metadata 524
Metadata Categories 525
The Metadata Repository 526
Metadata Standards 526
SQL Server 2008 R2 Metadata 527
Cross-Tool Components 528
Relational Engine Metadata 532
Analysis Services 532
Integration Services 533
Reporting Services 533
Master Data Services 534
SharePoint 534
External Metadata Sources 534
System Monitor 534
Active Directory 535
Looking to the Future 535
A Practical Metadata Approach 535
Creating the Metadata Strategy 536
Business Metadata Reporting 538
Analysis Services as Primary Query Platform 538
Relational Engine Extended Properties 539
Business Metadata Schema 540
Process Metadata Reporting 541
Technical Metadata Reporting 542
Ongoing Metadata Management 543
Summary 543
Deployment 545
Setting Up the Environments 546
Testing 550
Development Testing 551
System Testing 555
Data Quality Assurance Testing 557
Performance Testing 559
Service Level Confirmation 559
Processing Performance: Getting Data In 560
Query Performance: Getting Data Out 561
Usability Testing 562
Testing Summary 563
Deploying to Production 564
Relational Database Deployment 565
Integration Services Package Deployment 567
Analysis Services Database Deployment 568
Reporting Services Report Deployment 571
Master Data Services Deployment 572
Contents xxv
Data Warehouse and Bl Documentation 573
Core Descriptions 573
Business Process Dimensional Model Descriptions 573
Table and Column Descriptions 574
Report Descriptions 575
Additional Documentation 575
User Training 576
User Support 579
Desktop Readiness and Configuration 580
Summary 581
Chapter 17 Operations and Maintenance 583
Providing User Support 584
Maintaining the Bl Portal 585
Extending the Bl Applications 586
System Management 587
Governing the DW/BI System 588
Identifying and Terminating User Sessions 588
Resource Governance 591
Performance Monitoring 593
Relational Database 594
Analysis Services Database 597
Reporting Services 598
Integration Services 598
PowerPivot 600
Usage Monitoring 600
Managing Disk Space 602
Service and Availability Management 603
Performance Tuning the DW/BI System 604
Backup and Recovery 606
Relational Databases 606
Integration Services 608
Analysis Services 609
Reporting Services 610
Recovery 610
Executing the ETL Packages 611
Summary 611
Chapter 18 Present Imperatives and Future Outlook 613
Growing the DW/BI System 613
Lifecycle Review with Common Problems 615
Phase I ? Requirements, Realities, Plans, and Designs 616
Phase II ? Developing the Databases 616
Phase III ? Developing the Bl Applications and
Portal Environment 617
Phase IV ? Deploying and Managing the DW/BI System 618
Iteration and Growth 618
xxvi Contents
What We Like in the Microsoft Bl Toolset
Future Directions: Room for Improvement
Querv Tools
Metadata
Relational Database Engine
Analysis Services
Master Data Services
Integration
Customer Focus
Conclusion
619
620
620
621
621
622
622
623
623
623
Index
625 |
| any_adam_object | 1 |
| author | Mundy, Joy 1961- Thornthwaite, Warren 1957- |
| author_GND | (DE-588)173854435 (DE-588)173854443 (DE-588)1031963626 |
| author_facet | Mundy, Joy 1961- Thornthwaite, Warren 1957- |
| author_role | aut aut |
| author_sort | Mundy, Joy 1961- |
| author_variant | j m jm w t wt |
| building | Verbundindex |
| bvnumber | BV037372012 |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D37 |
| callnumber-search | QA76.9.D37 |
| callnumber-sort | QA 276.9 D37 |
| callnumber-subject | QA - Mathematics |
| classification_rvk | QP 345 ST 271 ST 530 |
| ctrlnum | (OCoLC)868980776 (DE-599)BVBBV037372012 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik Wirtschaftswissenschaften |
| edition | 2. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000zc 4500</leader><controlfield tag="001">BV037372012</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20150128</controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">110429s2011 xxuad|| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470640388</subfield><subfield code="9">978-0-470-64038-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)868980776</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV037372012</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D37</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 345</subfield><subfield code="0">(DE-625)141866:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 530</subfield><subfield code="0">(DE-625)143679:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Mundy, Joy</subfield><subfield code="d">1961-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)173854435</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">The Microsoft data warehouse toolkit</subfield><subfield code="b">with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset</subfield><subfield code="c">Joy Mundy and Warren Thornthwaite with Ralph Kimball</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Indianapolis, Ind.</subfield><subfield code="b">Wiley</subfield><subfield code="c">2011</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XLVI, 648 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield><subfield code="c">24 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">SQL server</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data warehousing</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL Server 2008</subfield><subfield code="0">(DE-588)7604407-5</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Data-Warehouse-Konzept</subfield><subfield code="0">(DE-588)4406462-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">SQL Server 2008</subfield><subfield code="0">(DE-588)7604407-5</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="C">b</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Thornthwaite, Warren</subfield><subfield code="d">1957-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)173854443</subfield><subfield code="4">aut</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Kimball, Ralph</subfield><subfield code="d">1944-</subfield><subfield code="e">Sonstige</subfield><subfield code="0">(DE-588)1031963626</subfield><subfield code="4">oth</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-118-06793-2</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-118-06794-9</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-118-06795-6</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=022525333&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-022525333</subfield></datafield></record></collection> |
| id | DE-604.BV037372012 |
| illustrated | Illustrated |
| indexdate | 2025-02-20T07:11:43Z |
| institution | BVB |
| isbn | 9780470640388 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-022525333 |
| oclc_num | 868980776 |
| open_access_boolean | |
| owner | DE-863 DE-BY-FWS |
| owner_facet | DE-863 DE-BY-FWS |
| physical | XLVI, 648 S. Ill., graph. Darst. 24 cm |
| publishDate | 2011 |
| publishDateSearch | 2011 |
| publishDateSort | 2011 |
| publisher | Wiley |
| record_format | marc |
| spellingShingle | Mundy, Joy 1961- Thornthwaite, Warren 1957- The Microsoft data warehouse toolkit with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset SQL server Data warehousing SQL Server 2008 (DE-588)7604407-5 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| subject_GND | (DE-588)7604407-5 (DE-588)4406462-7 |
| title | The Microsoft data warehouse toolkit with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset |
| title_auth | The Microsoft data warehouse toolkit with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset |
| title_exact_search | The Microsoft data warehouse toolkit with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset |
| title_full | The Microsoft data warehouse toolkit with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset Joy Mundy and Warren Thornthwaite with Ralph Kimball |
| title_fullStr | The Microsoft data warehouse toolkit with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset Joy Mundy and Warren Thornthwaite with Ralph Kimball |
| title_full_unstemmed | The Microsoft data warehouse toolkit with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset Joy Mundy and Warren Thornthwaite with Ralph Kimball |
| title_short | The Microsoft data warehouse toolkit |
| title_sort | the microsoft data warehouse toolkit with sql server 2008 r2 and the microsoft business intelligence toolset |
| title_sub | with SQL Server 2008 R2 and the Microsoft Business Intelligence toolset |
| topic | SQL server Data warehousing SQL Server 2008 (DE-588)7604407-5 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| topic_facet | SQL server Data warehousing SQL Server 2008 Data-Warehouse-Konzept |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=022525333&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT mundyjoy themicrosoftdatawarehousetoolkitwithsqlserver2008r2andthemicrosoftbusinessintelligencetoolset AT thornthwaitewarren themicrosoftdatawarehousetoolkitwithsqlserver2008r2andthemicrosoftbusinessintelligencetoolset AT kimballralph themicrosoftdatawarehousetoolkitwithsqlserver2008r2andthemicrosoftbusinessintelligencetoolset |
Indexes
THWS Würzburg Zentralbibliothek Lesesaal
| Call Number: |
1000 ST 530 M965(2) 1000 ST 530 M965(2)st |
|---|---|
| Copy 1 | ausleihbar Available Place a Hold |
| Copy 2 | ausleihbar Available Place a Hold |
| Copy 3 | ausleihbar Available Place a Hold |