Data warehousing:
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
New Delhi
Oxford Univ. Press
2011
|
| Edition: | 4. impr. |
| Series: | Oxford higher education
|
| Subjects: | |
| Online Access: | Contributor biographical information Publisher description Table of contents only Inhaltsverzeichnis |
| Item Description: | Hier auch später erschienene, unveränderte Nachdrucke Includes bibliographical references (p. [466]-469) and index |
| Physical Description: | X, 474 S. 25 cm |
| ISBN: | 9780195699616 0195699610 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV037299064 | ||
| 003 | DE-604 | ||
| 005 | 20201008 | ||
| 007 | t | ||
| 008 | 110324s2011 ii |||| 00||| eng d | ||
| 010 | |a 2010483262 | ||
| 015 | |a GBB003670 |2 dnb | ||
| 020 | |a 9780195699616 |9 978-0-19-569961-6 | ||
| 020 | |a 0195699610 |9 0-19-569961-0 | ||
| 035 | |a (OCoLC)711873927 | ||
| 035 | |a (DE-599)BVBBV037299064 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a ii |c IN | ||
| 049 | |a DE-473 |a DE-739 | ||
| 050 | 0 | |a QA76.9.D37 | |
| 084 | |a ST 530 |0 (DE-625)143679: |2 rvk | ||
| 100 | 1 | |a Thareja, Reema |e Verfasser |0 (DE-588)1079731873 |4 aut | |
| 245 | 1 | 0 | |a Data warehousing |c Reema Thareja |
| 250 | |a 4. impr. | ||
| 264 | 1 | |a New Delhi |b Oxford Univ. Press |c 2011 | |
| 300 | |a X, 474 S. |c 25 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Oxford higher education | |
| 500 | |a Hier auch später erschienene, unveränderte Nachdrucke | ||
| 500 | |a Includes bibliographical references (p. [466]-469) and index | ||
| 650 | 4 | |a Data warehousing | |
| 650 | 4 | |a Data mining | |
| 650 | 0 | 7 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |2 gnd |9 rswk-swf |
| 655 | 7 | |0 (DE-588)4123623-3 |a Lehrbuch |2 gnd-content | |
| 689 | 0 | 0 | |a Data-Warehouse-Konzept |0 (DE-588)4406462-7 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy1013/2010483262-b.html |3 Contributor biographical information | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy1013/2010483262-d.html |3 Publisher description | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy1013/2010483262-t.html |3 Table of contents only | |
| 856 | 4 | 2 | |m Digitalisierung UB Bamberg |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=021211504&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-021211504 | ||
Record in the Search Index
| _version_ | 1804143937343979520 |
|---|---|
| adam_text | Contents
Preface
Chapter
1:
Introduction to Data Warehousing
3
1.1
A Short Historical Note
4
1.2
Increasing Demand for Strategic Information
5
1.3
Data Warehouse Defined
10
1.4
Data Warehouse Users
14
1.5
Benefits of Data Warehousing
17
1.6
Concerns in Data Warehousing
19
Chapter
2:
Data Warehouse: Defining Features
23
2.1
Introduction
24
2.2
Features of a Data Warehouse
24
2.3
Data Granularity
31
2.4
The Information Flow Mechanism
33
2.5
Metadata
47
2.6
Two Classes of Data
52
2.7
The Lifecycle of Data
53
2.8
Data Flow from Warehouse to Operational Systems
56
Chapter
3:
Architecture of a Data Warehouse
61
3.1
Introduction
62
3.2
Characteristics of Data Warehouse Architecture
62
3.3
Data Warehouse Architecture Goals
65
3.4
Data Warehouse Architecture
65
3.5
Data Warehouse and Data Mart
73
3.6
Issues in Building Data Marts
74
3.7
Building Data Marts
79
3.8
Other Data Mart Issues
81
3.9
Increased Popularity of Data Marts
85
3.10
Can Data Warehouse and Data Mart Co-exist?
85
3.11
Pushing and Pulling Data
86
ГОД
Contents
Chapter
4:
Gathering the Business Requirements
91
4.1
Introduction
92
4.2
Determining the End-user Requirements
93
4.3
Requirements Gathering Methods
95
4.4
Requirements Analysis
102
4.5
Dimensional Analysis
203
4.6
Information Package Diagrams (IPD)
207
Chapter
5:
Planning and Project Management
114
5.1
Project Management Principles
125
5.2
Data Warehouse Readiness Assessment
227
5.3
Data Warehouse Project Team
220
5.4
Planning for the Data Warehouse
222
5.5
Data Warehouse Project Plan
224
5.6
Economic Feasibility Analysis
226
5.7
Planning for the Data Warehouse Server
230
5.8
Capacity Planning
235
5.9
Selecting the Operating System
240
5.10
Selecting the Database Software
242
5.11
Selecting the Tools
244
Chapter
6:
Data Warehouse Schema
155
6.1
Introduction
255
6.2
Dimensional Modelling
256
6.3
The Star Schema
25б
6.4
The Snowflake Schema
264
6.5
Aggregate Tables
269
6.6
Fact Constellation Schema
273
6.7
The Strengths of Dimensional Modelling
277
6.8
Data Warehouse and the Data Model
177
Chapter
7:
Dimensional Modelling
185
7.1
Characteristics of a Dimension Table
186
7.2
Characteristics of a Fact Table
187
7.3
The Factless Fact Table
189
7.4
Updates to the Dimension Tables
189
7.5
Cyclicity of Data—The Wrinkle of Time
295
7.6
Other Types of Dimension Tables
296
7.7
Keys in the Data Warehouse (Star) Schema
198
7.8
Enhancing the Data Warehouse Performance
200
7.9
Technology Requirements
224
Contents
Chapter
8:
The ETL Process
219
8.1
Introduction
220
8.2
Data Extraction
221
8.3
Data Transformation
229
8.4
Data Loading
232
8.5
Data Quality
237
Chapter
9:
Testing, Growth, and Maintenance
246
9.1
Data Warehouse Design Review
247
9.2
Developing the Data Warehouse Iteratively
250
9.3
Testing
250
9.4
Monitoring the Data Warehouse
256
9.5
Tuning the Data Warehouse
259
9.6
The Feedback Loop
262
Chapter
10: OLAP in
the Data Warehouse
266
10.1
Need For
OLAP 267
10.2 OLAP 269
10.3 OLAP
and Multidimensional Analysis
272
10.4 OLAP
Functions
276
10.5 OLAP
Applications
284
10.6 OLAP
Models
285
10.7 OLAP
Design Considerations
293
10.8 OLAP
Tools and Products
293
10.9
Existing
OLAP
Tools
295
10.10
Data Design
297
10.11
Administration and Performance
298
10.12 OLAP
Platforms
299
PART III
Chapter
11:
Building a Data Warehouse
305
11.1
Introduction
306
11.2
Problem Definition
306
11.3
Critical Success Factors
307
11.4
Requirement Analysis
309
11.5
Planning for the Data Warehouse
320
11.6
The Data Warehouse Design Stage
323
11.7
Building and Implementing Data Marts
327
11.8
Building Data Warehouses
327
11.9
Backup and Recovery
323
11.10
Establish the Data Quality Framework
325
11.12
Operating the Warehouse
327
11.13
Recipe for a Successful Warehouse
336
11.14
Data Warehouse Pitfalls
336
Contents
Chapter
12: Data Mining Basics 340
12.1
Introduction
342
12.2
Architecture of a Data Mining System
348
12.3
The Knowledge Discovery Process
349
12.4
Integrating Data Mining with Data Warehouse
352
12.5
Related Areas of Data Mining
356
12.6
Data Mining Techniques
357
Chapter
13:
Moving into Data Mining
379
13.1
Introduction
380
13.2
How Do We Categorize Data Mining Systems?
381
13.3
Interesting and Useful Data
382
13.4
Applications of Data Mining
383
13.5
Web Mining
392
13.6
Text Mining
395
13.7
Temporal Data Mining
396
13.8
Sequence Mining
399
13.9
Time-series Analysis
400
13.10
Spatial Data Mining
402
13.11
Issues and Challenges in Data Mining
404
13.12
Current Trends in Data Mining
405
Chapter
14:
Trends in Data Warehousing
410
14.1
Introduction
411
14.2
Data Warehouse Solutions
422
14.3
Web-enabled Data Warehouse
426
14.4
Distributed Data Warehouse
427
14.5
Virtual Data Warehouse
430
14.6
Operational Data Store
434
14.7
Integration with Other Technologies
438
14.8
Trends in Data Warehousing
447
14.9
Data Warehouse Futures
452
Glossary
457
Bibliography
466
Index
470
|
| any_adam_object | 1 |
| author | Thareja, Reema |
| author_GND | (DE-588)1079731873 |
| author_facet | Thareja, Reema |
| author_role | aut |
| author_sort | Thareja, Reema |
| author_variant | r t rt |
| building | Verbundindex |
| bvnumber | BV037299064 |
| 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 530 |
| ctrlnum | (OCoLC)711873927 (DE-599)BVBBV037299064 |
| discipline | Informatik |
| edition | 4. impr. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01977nam a2200493zc 4500</leader><controlfield tag="001">BV037299064</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20201008 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">110324s2011 ii |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2010483262</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB003670</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780195699616</subfield><subfield code="9">978-0-19-569961-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0195699610</subfield><subfield code="9">0-19-569961-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)711873927</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV037299064</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">ii</subfield><subfield code="c">IN</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield><subfield code="a">DE-739</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">QA76.9.D37</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">Thareja, Reema</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1079731873</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Data warehousing</subfield><subfield code="c">Reema Thareja</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">4. impr.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New Delhi</subfield><subfield code="b">Oxford Univ. Press</subfield><subfield code="c">2011</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">X, 474 S.</subfield><subfield code="c">25 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="490" ind1="0" ind2=" "><subfield code="a">Oxford higher education</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Hier auch später erschienene, unveränderte Nachdrucke</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes bibliographical references (p. [466]-469) and index</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data warehousing</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data mining</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="655" ind1=" " ind2="7"><subfield code="0">(DE-588)4123623-3</subfield><subfield code="a">Lehrbuch</subfield><subfield code="2">gnd-content</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="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy1013/2010483262-b.html</subfield><subfield code="3">Contributor biographical information</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy1013/2010483262-d.html</subfield><subfield code="3">Publisher description</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy1013/2010483262-t.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg</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=021211504&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-021211504</subfield></datafield></record></collection> |
| genre | (DE-588)4123623-3 Lehrbuch gnd-content |
| genre_facet | Lehrbuch |
| id | DE-604.BV037299064 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T22:55:36Z |
| institution | BVB |
| isbn | 9780195699616 0195699610 |
| language | English |
| lccn | 2010483262 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-021211504 |
| oclc_num | 711873927 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG DE-739 |
| owner_facet | DE-473 DE-BY-UBG DE-739 |
| physical | X, 474 S. 25 cm |
| publishDate | 2011 |
| publishDateSearch | 2011 |
| publishDateSort | 2011 |
| publisher | Oxford Univ. Press |
| record_format | marc |
| series2 | Oxford higher education |
| spelling | Thareja, Reema Verfasser (DE-588)1079731873 aut Data warehousing Reema Thareja 4. impr. New Delhi Oxford Univ. Press 2011 X, 474 S. 25 cm txt rdacontent n rdamedia nc rdacarrier Oxford higher education Hier auch später erschienene, unveränderte Nachdrucke Includes bibliographical references (p. [466]-469) and index Data warehousing Data mining Data-Warehouse-Konzept (DE-588)4406462-7 gnd rswk-swf (DE-588)4123623-3 Lehrbuch gnd-content Data-Warehouse-Konzept (DE-588)4406462-7 s DE-604 http://www.loc.gov/catdir/enhancements/fy1013/2010483262-b.html Contributor biographical information http://www.loc.gov/catdir/enhancements/fy1013/2010483262-d.html Publisher description http://www.loc.gov/catdir/enhancements/fy1013/2010483262-t.html Table of contents only Digitalisierung UB Bamberg application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=021211504&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Thareja, Reema Data warehousing Data warehousing Data mining Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| subject_GND | (DE-588)4406462-7 (DE-588)4123623-3 |
| title | Data warehousing |
| title_auth | Data warehousing |
| title_exact_search | Data warehousing |
| title_full | Data warehousing Reema Thareja |
| title_fullStr | Data warehousing Reema Thareja |
| title_full_unstemmed | Data warehousing Reema Thareja |
| title_short | Data warehousing |
| title_sort | data warehousing |
| topic | Data warehousing Data mining Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| topic_facet | Data warehousing Data mining Data-Warehouse-Konzept Lehrbuch |
| url | http://www.loc.gov/catdir/enhancements/fy1013/2010483262-b.html http://www.loc.gov/catdir/enhancements/fy1013/2010483262-d.html http://www.loc.gov/catdir/enhancements/fy1013/2010483262-t.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=021211504&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT tharejareema datawarehousing |