Common warehouse metamodel developer's guide:
Gespeichert in:
| Format: | Buch |
|---|---|
| Sprache: | English |
| Veröffentlicht: |
New York [u.a.]
Wiley
2003
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XXXIII, 716 S. graph. Darst. |
| ISBN: | 0471202436 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV041457548 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 131203s2003 d||| |||| 00||| eng d | ||
| 020 | |a 0471202436 |9 0-471-20243-6 | ||
| 024 | 3 | |a 9780471202431 | |
| 035 | |a (OCoLC)249074841 | ||
| 035 | |a (DE-599)BVBBV041457548 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-2070s | ||
| 082 | 0 | |a 658.40380285574 | |
| 084 | |a ST 270 |0 (DE-625)143638: |2 rvk | ||
| 245 | 1 | 0 | |a Common warehouse metamodel developer's guide |c John Poole ... |
| 264 | 1 | |a New York [u.a.] |b Wiley |c 2003 | |
| 300 | |a XXXIII, 716 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a Metadatenmodell |0 (DE-588)4384643-9 |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 Metadatenmodell |0 (DE-588)4384643-9 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Poole, John |e Sonstige |4 oth | |
| 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=026903973&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-026903973 | ||
Datensatz im Suchindex
| _version_ | 1804151585576583168 |
|---|---|
| adam_text | Acknowledgments xxiii
Introduction xxv
About the Authors xxxiii
Part 1 Introduction
Chapter 1 Introducing CWM: Model-Based Integration
of the Supply Chain 3
Integrating the Information Supply Chain 4
Components of the Information Supply Chain 4
The Economics of Integrating the ISC 6
CWM: Model-Based Meta Data Integration 10
The Model-Based Approach to Meta Data 10
An Overview of CWM 16
Summary 22
Chapter 2 An Architectural Survey of CWM 25
The CWM Metamodel Packages 26
The Object Model Layer 27
The Core Package 27
Behavioral Package 31
Relationships Package 31
Instance Package 33
Foundation Layer 34
Business Information Package 34
DataTypes Package 36
• Expressions Package 39
Keys and Indexes Package 41
xlv Contents Software Deployment Package 43
TypeMapping Package 44
Resource Layer 46
Object Package 46
Relational Package 47
Record Package 49
Multidimensional Package 50
XML Package 51
Analysis Layer 53
Transformation Package 54
OLAP Package 57
Data Mining Package 59
Information Visualization Package 60
Business Nomenclature Package 62
Management Layer 64
Warehouse Process Package 64
Warehouse Operation Package 64
Key Architectural Concepts: Extending CWM 66
Meta Data Reuse and Extension Based on Inheritance 67
Lightweight Extension Mechanisms: Stereotypes and
TaggedValues 71
Summary 73
Chapter 3 Modeling Meta Data Using CWM 75
UML 77
Building Blocks and Well-Formedness Rules 77
Static Structure Modeling 80
Model Management 82
Meta Object Facility 83
The MOF Model 84
The CWM Metamodel 87
How CWM Uses Inheritance to Achieve Reuse 89
How Meta Data Links to Physical Data Resources 91
How Resource Packages Support Instance Objects 93
Using CWM to Model Meta Data 94
Modeling Relational Meta Data 97
Modeling Record-Based Meta Data 101
Modeling Physical Data Resources 106
Modeling Transformation Meta Data 108
Modeling OLAP Meta Data 112
Summary 124
Chapter 4 Meta Data Interchange Patterns 125
Introducing Meta Data Interchange Patterns 126
The Need to Establish a Common Context
for Meta Data Interchange 127
The Need to Place Boundaries on Solution Extents 134
Contents xv
The Pattern-Based Approach to Meta Data Interchange 138
Formal Definitions of Meta Data Interchange Pattern Concepts 145
Developing Meta Data Interchange Patterns for CWM 152
Steps for Developing Interchange Patterns 152
Step 1: Identify the interchange problem to be solved 152
Step 2: Propose a pattern that solves the problem 152
Step 3: Identify several scenarios in which
the proposed pattern would be used 153
Step 4: Determine how the proposed pattern reuses,
or otherwise relates to, known patterns 153
Step 5: Identify the structural classification
of the proposed pattern 153
Step 6: Identify the usage category of the proposed pattern 154
Step 7: Identify the metamodel projection 155
Step 8: Determine any restrictions on instances
of the projection 156
Step 9: Determine the parameters
for binding pattern realizations 156
Step 10: Validate the pattern 157
Developing and Publishing a Pattern Specification 158
Developing a Fundamental Pattern: Unit of Interchange 162
Identify the interchange problem to be solved 162
Propose a pattern that solves the problem 162
Identify several scenarios in which the proposed
pattern would be used 163
Determine how the proposed pattern reuses,
or otherwise relates to, known patterns 163
Identify the structural classification of the proposed pattern 163
Identify the usage category of the proposed pattern 163
Identify the metamodel projection 164
Determine any restrictions on instances of the projection 164
Determine the parameters for binding pattern realizations 165
Validate the pattern 166
Summary 167
Part 2 Introducing the Vertical Models 169
Chapter 5 Data Warehouse Management Model 171
The Operational Data Store Scenario 172
The Exemplar Operational Data Store 174
The Relational Meta Data 178
Database Meta Data 178
ResultSet Meta Data 189
The CWM Relational Package 189
CWM Relational Dependent Classes and JMI Mappings 190
xvi Contents Exporting Relational Meta Data Using CWM 190
Simple Type 193
Catalog and Schema 193
Table and Column 195
Primary and Foreign Keys 196
Index 199
Types of Meta Data Not Exported 201
The CWM XMI File 201
Exporting Relational Data Using CWM 205
QueryColumnSet 205
RowSet, Row, and ColumnValue 207
The CWM XMI File 208
The ETL Scenario 216
The Exemplar Data Warehouse 217
The ETL Process Meta Data 223
The CWM Transformation Package 223
The CWM WarehouseProcess Package 225
Exporting ETL Meta Data Using CWM 227
The CWM XMI File 227
Summary 232
Chapter 6 Dimensional Model 235
The Logical Model 237
Dimensions, Attributes, Levels, and Hierarchies 237
The CWM Model 238
Defining the Dimensions and Attributes 240
Defining Levels and Level Attributes 244
Defining Hierarchies and Hierarchical Attributes 251
Add the Dimensions to the Schema 263
Defining Cubes and Measures 264
Add the Cubes to the Schema 267
Defining Keys 268
Adding Keys to the Dimensions 269
Adding Keys to the Levels 270
Adding Keys to the Hierarchies 271
Adding Keys to the Cubes 277
The Physical Model 279
A Relational Star-Schema 280
Defining the Physical Objects 280
Defining the Tables and Columns 280
Adding Primary Keys and Foreign Keys 288
Physical Deployment Models 294
Creating the DeploymentGroup 295
The CWM Mapping Model 296
Mapping the Logical Model 297
Mapping the Physical Model 312
Contents xvll
Creating a Second Deployment 336
The Multidimensional Metamodel 336
The Express Model 336
Creating the Express Objects 338
Adding the Second Deployment 339
Summary 347
Chapter 7 Web-Enabled Data Warehouse Model 349
Introducing the Web-Enabled Data Warehouse 350
Merging the Web and the Data Warehouse 351
Web-Enabled Dimensional Model 354
The Logical Clickstream Dimensions 354
CWM Packages and Interfaces 356
Building the Time Dimension 357
Building the Customer Dimension 364
Building the Product Dimension 369
Building the Page Dimension 373
Building the Event Dimension 377
Building the Session Dimension 381
Building the Referral Dimension 385
Building the Causal Dimension 390
Building the Entity Dimension 394
The Logical Clickstream Analysis Cubes 400
Session Analysis Cube 401
Page Analysis Cube 405
Aggregation Cube 407
New Meta Data Patterns Developed and Cataloged 411
Local Stereotype, Version 1.0 411
URL 411
Contributor 411
Structural Classification 411
Usage Category 411
Intent 412
Also Known As 412
Motivation 412
Applicability 412
Projection 412
Restriction 413
Usage 413
Parameters 414
Commentary 414
Consequences 414
Known Uses 414
Related Patterns 414
Sample Solution 414
xviii Contents Local Type System, Version 1.0 415
URL 415
Contributor 415
Structural Classification 415
Usage Category 415
Intent 416
Also Known As 416
Motivation 416
Applicability 416
Projection 416
Restriction 418
Usage 418
Parameters 419
Commentary 419
Consequences 419
Known Uses 419
Related Patterns 419
Sample Solution 419
Surrogate Key, Version 1.0 420
URL 420
Contributor 420
Structural Classification 420
Usage Category 421
Intent 421
Also Known As 421
Motivation 421
Applicability 421
Projection 423
Restriction 423
Usage 423
Parameters 423
Commentary 423
Consequences 423
Known Uses 423
Related Patterns 424
Sample Solution 424
Star-Join, Version 1.0 424
URL 425
Contributor 425
Structural Classification 425
Usage Category 425
Intent 425
Also Known As 425
Motivation 426
Applicability 426
Projection 426
Contents
Restriction 427
Usage 427
Parameters 428
Commentary 428
Consequences 428
Known Uses 428
Related Patterns 428
Sample Solution 428
Summary 429
Chapter 8 CWM Metastore 431
Building a CWM Metastore 434
Object-to-Relational Mapping Patterns 436
A Field Guide to Object-to-Relational Mapping Patterns 438
UML Notation Overview 438
Relational Table Notation 439
Manipulating Data in Metastore Tables 442
Preserving CWM s Object Structure 444
Data Type Mapping Patterns 447
Simple Data Type Pattern 448
Enumerated Data Type Pattern 448
Class-based Data Type Pattern 452
Class Mapping Patterns 453
Attribute Mapping Patterns 456
Inheritance Pattern 468
Association Mapping Patterns 487
One-to-One Association Pattern 491
One-to-Many Association Pattern 495
Many-to-Many Association Pattern 500
Using Association Patterns 504
Enforcing Association Multiplicities 531
Reference Mapping Patterns 532
MetaStore Services 538
Transaction Management Services 539
ClassMap Service 540
AllOfType Services 541
Error-Handling Services 543
Using the Metastore in Applications 544
Summary 554
Part 3 Implementation and Deployment 555
Chapter 9 Integration Architecture 557
Developing a Meta Data Integration Architecture 558
Survey of Architectural Patterns 558
Meta Data Interconnection Architecture 559
Meta Data life-Cycle Architecture 567
xx Contents CWM-Based Meta Data Integration Architecture 577
Crafting Your Own CWM Architectural Solutions 583
Summary 583
Chapter 10 Interface Rendering 585
CWM Core Classes and JMI Mappings 586
ModelElement, Namespace, and Package 586
Classifier, Class, Datatype, and Attribute 589
Method and Parameter 592
Instances 595
Keys and Indexes 598
CWM Relational Classes and JMI Mappings 602
Catalog and Schema 602
Table, View, QueryColumnSet, and Column 604
UniqueConstraint, PrimaryKey, and ForeignKey 610
SQLIndex and SQLIndexColumn 612
SQL Data Types 614
Stored Procedure 618
Trigger 620
Relational Instances 622
Relational Package Proxy 623
CWM Transformation Classes and JMI Mappings 624
Transformation 625
TransformationTask, TransformationStep, and
TransformationActivity 628
TransformationMap and Its Components 633
CWM WarehouseProcess Classes and JMI Mappings 638
Summary 642
Chapter 11 Implementation Development 643
CWM Implementation 643
Extending CWM 645
Simple Extensions to CWM 645
Tagged Values 646
Stereotypes 646
Modeled Extensions 648
Interoperability using CWM 648
Adapter Construction 652
Interoperability Frameworks for CWM 654
Transform Direct 654
Transform Indirect 654
Extending to Web Services 657
CWM and W3C Standards 657
CWM Meta Data Interchange Patterns RFP 660
CWM Web Services RFP 660
Contents xxl
Developing Automated Meta Data Driven Environments 661
The Vision 661
The Importance of Shared Meta Data 661
Common Services and Programming Models 663
Platform Specification 664
Overview of the Long-Term Vision 664
Knowledge-Based Orientation 664
Dynamic Architecture 665
Adaptive Systems 665
Summary 666
Chapter 12 Conclusions 669
CWM and MDA 670
CWM and Other Standards 674
OMG Standards 675
Java Standards 676
The Future of CWM 677
Summary 677
Bibliography 679
Index 683
|
| any_adam_object | 1 |
| building | Verbundindex |
| bvnumber | BV041457548 |
| classification_rvk | ST 270 |
| ctrlnum | (OCoLC)249074841 (DE-599)BVBBV041457548 |
| dewey-full | 658.40380285574 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 658 - General management |
| dewey-raw | 658.40380285574 |
| dewey-search | 658.40380285574 |
| dewey-sort | 3658.40380285574 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01343nam a2200361 c 4500</leader><controlfield tag="001">BV041457548</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">131203s2003 d||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0471202436</subfield><subfield code="9">0-471-20243-6</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9780471202431</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)249074841</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV041457548</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-2070s</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">658.40380285574</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="245" ind1="1" ind2="0"><subfield code="a">Common warehouse metamodel developer's guide</subfield><subfield code="c">John Poole ...</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">New York [u.a.]</subfield><subfield code="b">Wiley</subfield><subfield code="c">2003</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXXIII, 716 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="0" ind2="7"><subfield code="a">Metadatenmodell</subfield><subfield code="0">(DE-588)4384643-9</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">Metadatenmodell</subfield><subfield code="0">(DE-588)4384643-9</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">Poole, John</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</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=026903973&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-026903973</subfield></datafield></record></collection> |
| id | DE-604.BV041457548 |
| illustrated | Illustrated |
| indexdate | 2024-07-10T00:57:10Z |
| institution | BVB |
| isbn | 0471202436 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-026903973 |
| oclc_num | 249074841 |
| open_access_boolean | |
| owner | DE-2070s |
| owner_facet | DE-2070s |
| physical | XXXIII, 716 S. graph. Darst. |
| publishDate | 2003 |
| publishDateSearch | 2003 |
| publishDateSort | 2003 |
| publisher | Wiley |
| record_format | marc |
| spelling | Common warehouse metamodel developer's guide John Poole ... New York [u.a.] Wiley 2003 XXXIII, 716 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Metadatenmodell (DE-588)4384643-9 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 gnd rswk-swf Data-Warehouse-Konzept (DE-588)4406462-7 s Metadatenmodell (DE-588)4384643-9 s DE-604 Poole, John Sonstige oth HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026903973&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Common warehouse metamodel developer's guide Metadatenmodell (DE-588)4384643-9 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| subject_GND | (DE-588)4384643-9 (DE-588)4406462-7 |
| title | Common warehouse metamodel developer's guide |
| title_auth | Common warehouse metamodel developer's guide |
| title_exact_search | Common warehouse metamodel developer's guide |
| title_full | Common warehouse metamodel developer's guide John Poole ... |
| title_fullStr | Common warehouse metamodel developer's guide John Poole ... |
| title_full_unstemmed | Common warehouse metamodel developer's guide John Poole ... |
| title_short | Common warehouse metamodel developer's guide |
| title_sort | common warehouse metamodel developer s guide |
| topic | Metadatenmodell (DE-588)4384643-9 gnd Data-Warehouse-Konzept (DE-588)4406462-7 gnd |
| topic_facet | Metadatenmodell Data-Warehouse-Konzept |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026903973&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT poolejohn commonwarehousemetamodeldevelopersguide |