Fundamentals of data warehouses:
Gespeichert in:
Format: | Buch |
---|---|
Sprache: | English |
Veröffentlicht: |
Berlin [u.a.]
Springer
2003
|
Ausgabe: | 2., rev. and extended ed. |
Schlagworte: | |
Online-Zugang: | Inhaltsverzeichnis |
Beschreibung: | XV, 219 S. graph. Darst. |
ISBN: | 3540420894 |
Internformat
MARC
LEADER | 00000nam a22000008c 4500 | ||
---|---|---|---|
001 | BV014318313 | ||
003 | DE-604 | ||
005 | 20190228 | ||
007 | t| | ||
008 | 020528s2003 gw d||| |||| 00||| eng d | ||
016 | 7 | |a 964389606 |2 DE-101 | |
020 | |a 3540420894 |9 3-540-42089-4 | ||
035 | |a (OCoLC)49824734 | ||
035 | |a (DE-599)BVBBV014318313 | ||
040 | |a DE-604 |b ger |e rakddb | ||
041 | 0 | |a eng | |
044 | |a gw |c DE | ||
049 | |a DE-703 |a DE-473 |a DE-945 |a DE-1051 |a DE-29T |a DE-11 | ||
050 | 0 | |a QA76.9.D37 | |
082 | 0 | |a 658.4/038/0285574 |2 21 | |
084 | |a QH 500 |0 (DE-625)141607: |2 rvk | ||
084 | |a QP 345 |0 (DE-625)141866: |2 rvk | ||
084 | |a ST 530 |0 (DE-625)143679: |2 rvk | ||
245 | 1 | 0 | |a Fundamentals of data warehouses |c Matthias Jarke ... |
250 | |a 2., rev. and extended ed. | ||
264 | 1 | |a Berlin [u.a.] |b Springer |c 2003 | |
300 | |a XV, 219 S. |b graph. Darst. | ||
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 | 0 | 7 | |a Informationsmanagement |0 (DE-588)4114012-6 |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 Informationsmanagement |0 (DE-588)4114012-6 |D s |
689 | 0 | |5 DE-604 | |
700 | 1 | |a Jarke, Matthias |d 1952-2024 |e Sonstige |0 (DE-588)121078221 |4 oth | |
856 | 4 | 2 | |m DNB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009823494&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-009823494 |
Datensatz im Suchindex
_version_ | 1816444890021625856 |
---|---|
adam_text |
CONTENTS
1
DATA
WAREHOUSE
PRACTICE:
AN
OVERVIEW
.
1
1.1
DATA
WAREHOUSE
COMPONENTS
.
2
1.2
DESIGNING
THE
DATA
WAREHOUSE
.
4
1.3
GETTING
HETEROGENEOUS
DATA
INTO
THE
WAREHOUSE
.
5
1.4
GETTING
MULTIDIMENSIONAL
DATA
OUT
OF
THE
WAREHOUSE
.
6
1.5
PHYSICAL
STRUCTURE
OF
DATA
WAREHOUSES
.
10
1.6
METADATA
MANAGEMENT
.
13
1.7
DATA
WAREHOUSE
PROJECT
MANAGEMENT
.
13
2
DATA
WAREHOUSE
RESEARCH:
ISSUES
AND
PROJECTS
.
15
2.1
DATA
EXTRACTION
AND
RECONCILIATION
.
15
2.2
DATA
AGGREGATION
AND
CUSTOMIZATION
.
15
2.3
QUERY
OPTIMIZATION
.
16
2.4
UPDATE
PROPAGATION
.
17
2.5
MODELING
AND
MEASURING
DATA
WAREHOUSE
QUALITY
.
17
2.6
SOME
MAJOR
RESEARCH
PROJECTS
IN
DATA
WAREHOUSING
.
19
2.7
THREE
PERSPECTIVES
OF
DATA
WAREHOUSE
METADATA
.
21
3
SOURCE
INTEGRATION
.
27
3.1
THE
PRACTICE
OF
SOURCE
INTEGRATION
.
27
3.1.1
TOOLS
FOR
DATA
WAREHOUSE
MANAGEMENT
.
28
3.1.2
TOOLS
FOR
DATA
INTEGRATION
.
29
3.2
RESEARCH
IN
SOURCE
INTEGRATION
.
30
3.2.1
SCHEMA
INTEGRATION
.
32
3.2.2
DATA
INTEGRATION
-
VIRTUAL
.
36
3.2.3
DATA
INTEGRATION
-
MATERIALIZED
.
38
3.3
TOWARDS
SYSTEMATIC
METHODOLOGIES
FOR
SOURCE
INTEGRATION
.
40
3.3.1
ARCHITECTURE
FOR
SOURCE
INTEGRATION
.
41
3.3.2
METHODOLOGY
FOR
SOURCE
INTEGRATION
.
43
3.4
CONCLUDING
REMARKS
.
45
4
DATA
WAREHOUSE
REFRESHMENT
.
47
4.1
WHAT
IS
DATA
WAREHOUSE
REFRESHMENT?
.
47
4.1.1
REFRESHMENT
PROCESS
WITHIN
THE
DATA
WAREHOUSE
LIFECYCLE
.
47
4.1.2
REQUIREMENTS
AND
DIFFICULTIES
OF
DATA
WAREHOUSE
REFRESHMENT
50
4.1.3
DATA
WAREHOUSE
REFRESHMENT:
PROBLEM
STATEMENT
.
52
XIV
CONTENTS
4.2
INCREMENTAL
DATA
EXTRACTION
.
54
4.2.1
WRAPPER
FUNCTIONALITY
.
55
4.2.2
CHANGE
MONITORING
.
56
4.3
DATA
CLEANING
.
62
4.3.1
CONVERSION
AND
NORMALIZATION
FUNCTIONS
.
63
4.3.2
SPECIAL-PURPOSE
CLEANING
.
64
4.3.3
DOMAIN-INDEPENDENT
CLEANING
.
64
4.3.4
RULE-BASED
CLEANING
.
65
4.3.5
CONCLUDING
REMARKS
ON
DATA
CLEANING
.
67
4.4
UPDATE
PROPAGATION
INTO
MATERIALIZED
VIEWS
.
67
4.4.1
NOTATIONS
AND
DEFINITIONS
.
68
4.4.2
VIEW
MAINTENANCE:
GENERAL
RESULTS
.
68
4.4.3
VIEW
MAINTENANCE
IN
DATA
WAREHOUSES
-
SPECIFIC
RESULTS
.
71
4.5
TOWARD
A
QUALITY-ORIENTED
REFRESHMENT
PROCESS
.
73
4.5.1
QUALITY
ANALYSIS
FOR
REFRESHMENT
.
73
4.5.2
IMPLEMENTING
THE
REFRESHMENT
PROCESS
.
77
4.5.3
WORKFLOW
MODELING
WITH
RULES
.
80
4.6
IMPLEMENTATION
OF
THE
APPROACH
.
83
5
MULTIDIMENSIONAL
DATA
MODELS
AND
AGGREGATION
.
87
5.1
MULTIDIMENSIONAL
VIEW
OF
INFORMATION
.
90
5.2
ROLAP
DATA
MODEL
.
92
5.3
MOLAP
DATA
MODEL
.
95
5.4
LOGICAL
MODELS
FOR
MULTIDIMENSIONAL
INFORMATION
.
97
5.5
CONCEPTUAL
MODELS
FOR
MULTIDIMENSIONAL
INFORMATION
.
100
5.5.1
INFERENCE
PROBLEMS
FOR
MULTIDIMENSIONAL
CONCEPTUAL
MODELING
.
101
5.5.2
WHICH
FORMAL
FRAMEWORK
TO
CHOOSE?
.
103
5.6
CONCLUSION
.
105
6
QUERY
PROCESSING
AND
OPTIMIZATION
.
107
6.1
DESCRIPTION
AND
REQUIREMENTS
FOR
DATA
WAREHOUSE
QUERIES
.
107
6.1.1
QUERIES
AT
THE
BACK
END
.
108
6.1.2
QUERIES
AT
THE
FRONT
END
.
108
6.1.3
QUERIES
IN
THE
CORE
.
109
6.1.4
TRANSACTIONAL
VERSUS
DATA
WAREHOUSE
QUERIES
.
109
6.1.5
CANNED
QUERIES
VERSUS
AD-HOC
QUERIES
.
110
6.1.6
MULTIDIMENSIONAL
QUERIES
.
110
6.1.7
EXTENSIONS
OF
SQL
.
112
6.2
QUERY PROCESSING
TECHNIQUES
.
113
6.2.1
DATA
ACCESS
.
113
6.2.2
EVALUATION
STRATEGIES
.
116
6.2.3
EXPLOITATION
OF
REDUNDANCY
.
117
6.3
CONCLUSIONS
AND
RESEARCH
DIRECTIONS
.
121
CONTENTS
XV
7
METADATA
AND
DATA
WAREHOUSE
QUALITY
.
123
7.1
METADATA
MANAGEMENT
IN
DATA
WAREHOUSE
PRACTICE
.
124
7.1.1
METADATA
INTERCHANGE
SPECIFICATION
(MDIS)
.
125
7.1.2
THE
TELOS
LANGUAGE
.
125
7.1.3
MICROSOFT
REPOSITORY
.
127
7.1.4
OIM
AND
CWM
.
128
7.2
A
REPOSITORY
MODEL
FOR
THE
DWQ
FRAMEWORK
.
129
7.2.1
CONCEPTUAL
PERSPECTIVE
.
131
7.2.2
LOGICAL
PERSPECTIVE
.
132
7.2.3
PHYSICAL
PERSPECTIVE
.
132
7.2.4
APPLYING
THE
ARCHITECTURE
MODEL
.
133
7.3
DEFINING
DATA
WAREHOUSE
QUALITY
.
138
7.3.1
DATA
QUALITY
.
139
7.3.2
STAKEHOLDERS
AND
GOALS
IN
DATA
WAREHOUSE
QUALITY
.
140
7.3.3
STATE
OF
PRACTICE
IN
DATA
WAREHOUSE
QUALITY
.
143
7.4
REPRESENTING
AND
ANALYZING
DATA
WAREHOUSE
QUALITY
.
144
7.4.1
QUALITY
FUNCTION
DEPLOYMENT
.
145
7.4.2
THE
NEED
FOR
RICHER
QUALITY
MODELS:
AN
EXAMPLE
.
146
7.4.3
THE
GOAL-QUESTION-METRIC
APPROACH
.
147
7.4.4
REPOSITORY
SUPPORT
FOR
THE
GQM
APPROACH
.
148
7.5
A
DETAILED
EXAMPLE:
QUALITY
ANALYSIS
IN
DATA
STAGING
.
154
7.5.1
EVALUATION
OF
THE
QUALITY
OF
A
DS
A
SCHEMA
.
158
7.5.2
ANALYZING
THE
QUALITY
OF
A
VIEW
.
160
8
QUALITY-DRIVEN
DATA
WAREHOUSE
DESIGN
.
165
8.1
INTERACTIONS
BETWEEN
QUALITY
FACTORS
AND
DW
TASKS
.
165
8.2
THE
DWQ
DATA
WAREHOUSE
DESIGN
METHODOLOGY
.
166
8.2.1
SOURCE
INTEGRATION
.
167
8.2.2
MULTIDIMENSIONAL
AGGREGATION
AND
OLAP
QUERY
GENERATION
.
169
8.2.3
DESIGN
OPTIMIZATION
AND
DATA
RECONCILIATION
.
171
8.2.4
OPERATIONAL
SUPPORT
.
172
8.3
OPTIMIZING
THE
MATERIALIZATION
OF
DW
VIEWS
.
174
8.4
SUMMARY
AND
OUTLOOK
.
178
BIBLIOGRAPHY
.
181
APPENDIX
A.
ISO
STANDARDS
INFORMATION
QUALITY
.
203
APPENDIX
B.
GLOSSARY
.
207
INDEX
.
215 |
any_adam_object | 1 |
author_GND | (DE-588)121078221 |
building | Verbundindex |
bvnumber | BV014318313 |
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 | QH 500 QP 345 ST 530 |
ctrlnum | (OCoLC)49824734 (DE-599)BVBBV014318313 |
dewey-full | 658.4/038/0285574 |
dewey-hundreds | 600 - Technology (Applied sciences) |
dewey-ones | 658 - General management |
dewey-raw | 658.4/038/0285574 |
dewey-search | 658.4/038/0285574 |
dewey-sort | 3658.4 238 6285574 |
dewey-tens | 650 - Management and auxiliary services |
discipline | Informatik Wirtschaftswissenschaften |
edition | 2., rev. and extended ed. |
format | Book |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a22000008c 4500</leader><controlfield tag="001">BV014318313</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20190228</controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">020528s2003 gw d||| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">964389606</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">3540420894</subfield><subfield code="9">3-540-42089-4</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)49824734</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV014318313</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="044" ind1=" " ind2=" "><subfield code="a">gw</subfield><subfield code="c">DE</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-703</subfield><subfield code="a">DE-473</subfield><subfield code="a">DE-945</subfield><subfield code="a">DE-1051</subfield><subfield code="a">DE-29T</subfield><subfield code="a">DE-11</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">658.4/038/0285574</subfield><subfield code="2">21</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QH 500</subfield><subfield code="0">(DE-625)141607:</subfield><subfield code="2">rvk</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 530</subfield><subfield code="0">(DE-625)143679:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Fundamentals of data warehouses</subfield><subfield code="c">Matthias Jarke ...</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2., rev. and extended ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Berlin [u.a.]</subfield><subfield code="b">Springer</subfield><subfield code="c">2003</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XV, 219 S.</subfield><subfield code="b">graph. Darst.</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="0" ind2="7"><subfield code="a">Informationsmanagement</subfield><subfield code="0">(DE-588)4114012-6</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">Informationsmanagement</subfield><subfield code="0">(DE-588)4114012-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Jarke, Matthias</subfield><subfield code="d">1952-2024</subfield><subfield code="e">Sonstige</subfield><subfield code="0">(DE-588)121078221</subfield><subfield code="4">oth</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">DNB 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=009823494&sequence=000001&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-009823494</subfield></datafield></record></collection> |
id | DE-604.BV014318313 |
illustrated | Illustrated |
indexdate | 2024-11-22T17:33:56Z |
institution | BVB |
isbn | 3540420894 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-009823494 |
oclc_num | 49824734 |
open_access_boolean | |
owner | DE-703 DE-473 DE-BY-UBG DE-945 DE-1051 DE-29T DE-11 |
owner_facet | DE-703 DE-473 DE-BY-UBG DE-945 DE-1051 DE-29T DE-11 |
physical | XV, 219 S. graph. Darst. |
publishDate | 2003 |
publishDateSearch | 2003 |
publishDateSort | 2003 |
publisher | Springer |
record_format | marc |
spelling | Fundamentals of data warehouses Matthias Jarke ... 2., rev. and extended ed. Berlin [u.a.] Springer 2003 XV, 219 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Data warehouse gtt Data warehousing Informationsmanagement (DE-588)4114012-6 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 s Informationsmanagement (DE-588)4114012-6 s DE-604 Jarke, Matthias 1952-2024 Sonstige (DE-588)121078221 oth DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009823494&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
spellingShingle | Fundamentals of data warehouses Data warehouse gtt Data warehousing Informationsmanagement (DE-588)4114012-6 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
subject_GND | (DE-588)4114012-6 (DE-588)4406462-7 |
title | Fundamentals of data warehouses |
title_auth | Fundamentals of data warehouses |
title_exact_search | Fundamentals of data warehouses |
title_full | Fundamentals of data warehouses Matthias Jarke ... |
title_fullStr | Fundamentals of data warehouses Matthias Jarke ... |
title_full_unstemmed | Fundamentals of data warehouses Matthias Jarke ... |
title_short | Fundamentals of data warehouses |
title_sort | fundamentals of data warehouses |
topic | Data warehouse gtt Data warehousing Informationsmanagement (DE-588)4114012-6 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
topic_facet | Data warehouse Data warehousing Informationsmanagement Data-Warehouse-Konzept |
url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=009823494&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
work_keys_str_mv | AT jarkematthias fundamentalsofdatawarehouses |