Data warehousing in the real world: a practical guide for building decision support systems
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Harlow u.a.
Addison-Wesley
1997
|
| Edition: | 1. print. |
| Subjects: | |
| Online Access: | Inhaltsverzeichnis |
| Physical Description: | XIV, 352 S. |
| ISBN: | 0201175193 |
Staff View
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV011556351 | ||
| 003 | DE-604 | ||
| 005 | 19970930 | ||
| 007 | t | ||
| 008 | 970930s1997 |||| 00||| eng d | ||
| 020 | |a 0201175193 |9 0-201-17519-3 | ||
| 035 | |a (OCoLC)36908916 | ||
| 035 | |a (DE-599)BVBBV011556351 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-384 |a DE-92 |a DE-706 |a DE-634 |a DE-188 | ||
| 050 | 0 | |a QA76.9.D37 | |
| 082 | 0 | |a 005.74 |2 21 | |
| 084 | |a ST 270 |0 (DE-625)143638: |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 Anahory, Sam |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Data warehousing in the real world |b a practical guide for building decision support systems |c Sam Anahory ; Dennis Murray |
| 250 | |a 1. print. | ||
| 264 | 1 | |a Harlow u.a. |b Addison-Wesley |c 1997 | |
| 300 | |a XIV, 352 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 7 | |a Data warehouse |2 gtt | |
| 650 | 4 | |a Data warehousing | |
| 650 | 4 | |a Decision support systems | |
| 650 | 0 | 7 | |a Systementwicklung |0 (DE-588)4126945-7 |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 | |5 DE-604 | |
| 689 | 1 | 0 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |D s |
| 689 | 1 | 1 | |a Systementwicklung |0 (DE-588)4126945-7 |D s |
| 689 | 1 | |5 DE-188 | |
| 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=007781032&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-007781032 | ||
Record in the Search Index
| _version_ | 1804126081546977280 |
|---|---|
| adam_text | Contents
Preface xiii
PART ONE: INTRODUCTION I
I INTRODUCTION 3
1.1 Background 3
1.2 What is a data warehouse? 4
1.3 Why read this book? 4
1.4 Road map 6
1.5 One final point ... 7
2 DELIVERY PROCESS 8
2.1 Introduction 8
2.2 Data warehouse delivery method 9
vii
PART TWO: DATA WAREHOUSE ARCHITECTURE 3 SYSTEM PROCESSES 19
3.1 Introduction 19
3.2 Overview 21
3.3 Typical process flow within a data warehouse 22
3.4 Extract and load process 22
3.5 Clean and transform data 25
3.6 Backup and archive process 26
3.7 Query management process 27
4 PROCESS ARCHITECTURE 29
4.1 Introduction 29
4.2 Load manager 30
4.3 Warehouse manager 32
4.4 Query manager 38
4.5 Detailed information 39
4.6 Summary information 47
4.7 Metadata 48
4.8 Data marting 49
4.9 To summarize ... 52
PART THREE: DESIGN
5 DATABASE SCHEMA 57
5.1 Introduction 57
5.2 Starflake schemas 58
5.3 Identifying facts and dimensions 61
5.4 Designing fact tables 66
5.5 Designing dimension tables 76
5.6 Designing the starflake schema 81
5.7 Query redirection 84
5.8 Multidimensional schemas 85
6 PARTITIONING STRATEGY 87
6.1 Introduction 87
6.2 Horizontal partitioning 87
6.3 Vertical partitioning 92
6.4 Hardware partitioning 94
6.5 Which key to partition by? 98
6.6 Sizing the partition 99
7 AGGREGATIONS 101
7.1 Introduction 101
7.2 Why aggregate? 101
73 What is an aggregation? 102
7.4 Designing summary tables 105
7.5 Which summaries to create 113
8 DATA MARTING 116
8.1 Introduction 116
8.2 When is a data mart appropriate? 116
8.3 Designing data marts 120
8.4 Costs of data marting 122
9 METADATA 125
9.1 Introduction 125
9.2 Data transformation and load 125
9.3 Data management 128
9.4 Query generation 131
9.5 Metadata and tools 134
10 SYSTEM AND DATA WAREHOUSE PROCESS MANAGERS 135
10.1 Introduction 135
10.2 Why you need tools to manage a data warehouse 135
10.3 System managers 136
10.4 Data warehouse process managers 143
10.5 Load manager 145
10.6 Warehouse manager 147
10.7 Query manager 151
PART FOUR: HARDWARE AND OPERATIONAL DESIGN
11 HARDWARE ARCHITECTURE 155
11.I Introduction 155
11.2 Process 155
11.3 Server hardware 156
11.4 Network hardware 162
11.5 Client hardware 163
12 PHYSICAL LAYOUT 165
12.1 Parallel technology 165
12.2 Disk technology 175
12.3 Database layout 179
12.4 Filesystems 183
13 SECURITY 188
13.1 Introduction 188
13.2 Requirements 189
13.3 Performance impact of security 199
13.4 Security impact on design 203
14 BACKUP AND RECOVERY 205
14.1 Introduction 205
14.2 Definitions 206
14.3 Hardware 207
14.4 Software 212
14.5 Backup strategies 215
14.6 Testing the strategy 218
14.7 Disaster recovery 219
15 SERVICE LEVEL AGREEMENT 222
15.1 Introduction 222
15.2 Definition of types of system 223
15.3 Is the data warehouse an operational system or not? 224
15.4 Defining the SLA 226
16 OPERATING THE DATA WAREHOUSE 230
16.1 Introduction 230
16.2 Day to day operations of the data warehouse 230
16.3 Overnight processing 235
PART FIVE: CAPACITY PLANNING, TUNING AND TESTING
17 CAPACITY PLANNING 241
17.1 Introduction 241
17.2 Process 241
17.3 Estimating the load 242
18 TUNING THE DATA WAREHOUSE 253
18.1 Introduction 253
18.2 Assessing performance 253
18.3 Tuning the data load 255
18.4 Tuning queries 258
19 TESTING THE DATA WAREHOUSE 264
19.1 Introduction 264
19.2 Developing the test plan 265
19.3 Testing backup recovery 267
19.4 Testing the operational environment 268
19.5 Testing the database 270
19.6 Testing the application 272
19.7 Logistics of the test 273
PART SIX: FUTURES
20 DATA WAREHOUSE FUTURES 277
APPENDICES
A METHODOLOGY 283
B ACCESSING THE DATA WAREHOUSE 318
C SUMMARY OF ALL GUIDELINES 327
Glossary 340
Index 346
|
| any_adam_object | 1 |
| author | Anahory, Sam |
| author_facet | Anahory, Sam |
| author_role | aut |
| author_sort | Anahory, Sam |
| author_variant | s a sa |
| building | Verbundindex |
| bvnumber | BV011556351 |
| 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 | ST 270 ST 271 ST 530 |
| ctrlnum | (OCoLC)36908916 (DE-599)BVBBV011556351 |
| 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 |
| edition | 1. print. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01727nam a2200457 c 4500</leader><controlfield tag="001">BV011556351</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">19970930 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">970930s1997 |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0201175193</subfield><subfield code="9">0-201-17519-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)36908916</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV011556351</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-384</subfield><subfield code="a">DE-92</subfield><subfield code="a">DE-706</subfield><subfield code="a">DE-634</subfield><subfield code="a">DE-188</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><subfield code="2">21</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 270</subfield><subfield code="0">(DE-625)143638:</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">Anahory, Sam</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Data warehousing in the real world</subfield><subfield code="b">a practical guide for building decision support systems</subfield><subfield code="c">Sam Anahory ; Dennis Murray</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. print.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Harlow u.a.</subfield><subfield code="b">Addison-Wesley</subfield><subfield code="c">1997</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XIV, 352 S.</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="650" ind1=" " ind2="7"><subfield code="a">Data warehouse</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data warehousing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Decision support systems</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Systementwicklung</subfield><subfield code="0">(DE-588)4126945-7</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=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" 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="1" ind2="1"><subfield code="a">Systementwicklung</subfield><subfield code="0">(DE-588)4126945-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="5">DE-188</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=007781032&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-007781032</subfield></datafield></record></collection> |
| id | DE-604.BV011556351 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T18:11:47Z |
| institution | BVB |
| isbn | 0201175193 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-007781032 |
| oclc_num | 36908916 |
| open_access_boolean | |
| owner | DE-384 DE-92 DE-706 DE-634 DE-188 |
| owner_facet | DE-384 DE-92 DE-706 DE-634 DE-188 |
| physical | XIV, 352 S. |
| publishDate | 1997 |
| publishDateSearch | 1997 |
| publishDateSort | 1997 |
| publisher | Addison-Wesley |
| record_format | marc |
| spelling | Anahory, Sam Verfasser aut Data warehousing in the real world a practical guide for building decision support systems Sam Anahory ; Dennis Murray 1. print. Harlow u.a. Addison-Wesley 1997 XIV, 352 S. txt rdacontent n rdamedia nc rdacarrier Data warehouse gtt Data warehousing Decision support systems Systementwicklung (DE-588)4126945-7 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 s DE-604 Systementwicklung (DE-588)4126945-7 s DE-188 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=007781032&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Anahory, Sam Data warehousing in the real world a practical guide for building decision support systems Data warehouse gtt Data warehousing Decision support systems Systementwicklung (DE-588)4126945-7 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| subject_GND | (DE-588)4126945-7 (DE-588)4406462-7 |
| title | Data warehousing in the real world a practical guide for building decision support systems |
| title_auth | Data warehousing in the real world a practical guide for building decision support systems |
| title_exact_search | Data warehousing in the real world a practical guide for building decision support systems |
| title_full | Data warehousing in the real world a practical guide for building decision support systems Sam Anahory ; Dennis Murray |
| title_fullStr | Data warehousing in the real world a practical guide for building decision support systems Sam Anahory ; Dennis Murray |
| title_full_unstemmed | Data warehousing in the real world a practical guide for building decision support systems Sam Anahory ; Dennis Murray |
| title_short | Data warehousing in the real world |
| title_sort | data warehousing in the real world a practical guide for building decision support systems |
| title_sub | a practical guide for building decision support systems |
| topic | Data warehouse gtt Data warehousing Decision support systems Systementwicklung (DE-588)4126945-7 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| topic_facet | Data warehouse Data warehousing Decision support systems Systementwicklung Data-Warehouse-Konzept |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=007781032&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT anahorysam datawarehousingintherealworldapracticalguideforbuildingdecisionsupportsystems |