Patterns of data modeling:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Boca Raton, Fla u.a.
CRC Press/Taylor & Francis
2010
|
| Schriftenreihe: | Emerging directions in database systems and applications
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | Literaturangaben |
| Beschreibung: | XVI, 245 S. graph. Darst. |
| ISBN: | 9781439819890 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV036700796 | ||
| 003 | DE-604 | ||
| 005 | 20101007 | ||
| 007 | t | ||
| 008 | 101004s2010 d||| |||| 00||| eng d | ||
| 010 | |a 2010000025 | ||
| 020 | |a 9781439819890 |c pbk. (alk. paper) : £31,99 |9 978-1-439-81989-0 | ||
| 035 | |a (OCoLC)705878900 | ||
| 035 | |a (DE-599)GBV617206929 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-573 |a DE-355 | ||
| 082 | 0 | |a 005.74 | |
| 084 | |a ST 265 |0 (DE-625)143634: |2 rvk | ||
| 100 | 1 | |a Blaha, Michael |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Patterns of data modeling |c Michael Blaha |
| 264 | 1 | |a Boca Raton, Fla u.a. |b CRC Press/Taylor & Francis |c 2010 | |
| 300 | |a XVI, 245 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Emerging directions in database systems and applications | |
| 500 | |a Literaturangaben | ||
| 650 | 0 | 7 | |a Schema |g Informatik |0 (DE-588)4290412-2 |2 gnd |9 rswk-swf |
| 655 | 7 | |0 (DE-588)4123623-3 |a Lehrbuch |2 gnd-content | |
| 689 | 0 | 0 | |a Schema |g Informatik |0 (DE-588)4290412-2 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m GBV Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020619229&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-020619229 | ||
Datensatz im Suchindex
| _version_ | 1804143340523880448 |
|---|---|
| adam_text | IMAGE 1
PATTERNS OF DATA MODELING
MICHAEL BLAHA
CRC PRESS TAYLOR& FRANCIS GROUP BOCA RATON LONDON NEW YORK
CRC PRESS IS AN IMPRINT OF THE TAYLOR ST FRANCIS CROJP, AN INFORMA
BUSINESS
IMAGE 2
CONTENTS
PREFACE XIII
WHO SHOULD READ THIS BOOK? XIII
WHAT YOU WILL FIND XIV
COMPARISON WITH OTHER BOOKS XV
ACKNOWLEDGMENTS XVI
CHAPTER 1 INTRODUCTION 1
1.1 WHAT IS A MODEL? 1
1.2 MODELING NOTATION 1
1.3 WHAT IS A PATTERN? 2
1.4 WHY ARE PATTERNS IMPORTANT? 3
1.5 DRAWBACKS OF PATTERNS 4
1.6 PATTERN VS. SEED MODEL 4
1.7 ASPECTS OF PATTERN TECHNOLOGY 5
1.8 CHAPTER SUMMARY 6
BIBLIOJGRAPHIC NOTES 6
REFERENCES 7
PART 1: MATHEMATICAL TEMPLATES 9
CHAPTER2 TREE TEMPLATE 11
2.1 HARDCODED TREE TEMPLATE 12
2.2 SIMPLE TREE TEMPLATE 15
2.3 STRUCTUREDTREE TEMPLATE 19
2.4 OVERLAPPING TREES TEMPLATE 23
2.5 TREE CHANGING OVER TIME TEMPLATE 27
2.6 DEGENERATE NODE AND EDGE TEMPLATE 31
2.7 CHAPTERSUMMARY 33
VII
IMAGE 3
VIII
BIBLIOG;RAPHIC NOTES 34
REFERENCES 34
CHAPTER 3 DIRECTED GRAPH TEMPLATE 36
3.1 SIMPLE DIRECTED GRAPH TEMPLATE 37
3.2 STRUCTURED DIRECTED GRAPH TEMPLATE 40
3.3 NODE AND EDGE DIRECTED GRAPH TEMPLATE 45
3.4 CONNECTION DIRECTED GRAPH TEMPLATE 48
3.5 SIMPLE DG CHANGING OVERTIME TEMPLATE 52
3.6 NODE AND EDGE DG CHANGING OVER TIME TEMPLATE 56
3.7 CHAPTER SUMMARY 60
BIBLIOGRAPHIC NOTES 62
REFERENCES 62
CHAPTER 4 UNDIRECTED GRAPH TEMPLATE 63
4.1 NODE AND EDGE UNDIRECTED GRAPH TEMPLATE 64
4.2 CONNECTION UNDIRECTED GRAPH TEMPLATE 66
4.3 UNDIRECTED GRAPH CHANGING OVER TIME TEMPLATE 69
4.4 CHAPTER SUMMARY 73
CHAPTER 5 ITEM DESCRIPTION TEMPLATE 74
5.1 ITEM DESCRIPTION TEMPLATE 74
5.2 HOMOMORPHISM TEMPLATE 78
5.3 CHAPTER SUMMARY 82
BIBLIOJGRAPHIC NOTES 83
REFERENCES 83
CHAPTER 6 STAR SCHEMA TEMPLATE 84
6.1 STAR SCHEMA TEMPLATE 84
6.2 CHAPTER SUMMARY 89
BIBLIOGRAPHIC NOTES 89
REFERENCES 90
CHAPTER 7 SUMMARY OF TEMPLATES 91
PART II: ANTIPATTERNS 95
CHAPTER 8 UNIVERSAL ANTIPATTERNS 97
8.1 SYMMETRIC RELATIONSHIP ANTIPATTERN 97
8.2 DEAD ELEMENTS ANTIPATTERN 99
8.3 DISGUISED FIELDS ANTIPATTERN 100
8.4 ARTIFICIAL HARDCODED LEVELS ANTIPATTERN 101
8.5 EXCESSIVE GENERALIZATION ANTIPATTERN 103
8.6 DISCONNECTED ENTITY TYPES ANTIPATTERN 104
8.7 MODELING ERRORS ANTIPATTERN 104
8.8 MULTIPLE INHERITANCE ANTIPATTERN 105
IMAGE 4
CONTENTS IX
8.9 PARADIGM DEGRADATION ANTIPATTERN 106
8.10 CHAPTER SUMMARY 109
BIBLIOGRAPHIC NOTES 109
REFERENCES 110
CHAPTER 9 NON-DATA-WAREHOUSE ANTIPATTERNS 111
9.1 DERIVED DATA ANTIPATTERN 111
9.2 PARALLEL ATTRIBUTES ANTIPATTERN 114
9.3 PARALLEL RELATIONSHIPS ANTIPATTERN 116
9.4 COMBINED ENTITY TYPES ANTIPATTERN 116
9.5 CHAPTER SUMMARY 118
PART III: ARCHETYPES 119
CHAPTER 10 ARCHETYPES 121
10.1 ACCOUNT 121
10.2 ACTOR 122
10.3 ADDRESS 124
10.4 ASSET 124
10.5 CONTRACT 125
10.6 COURSE 126
10.7 CUSTOMER 127
10.8 DOCUMENT 128
10.9 EVENT 130
10.10 FLIGHT 131
10.11 ITEM 133
10.12 LOCATION 134
10.13 OPPORTUNITY 135
10.14 PART 136
10.15 PAYMENT 137
10.16 POSITION 138
10.17 PRODUCT 139
10.18 ROLE 140
10.19 TRANSACTION 141
10.20 VENDOR 142
10.21 CHAPTER SUMMARY 142
BIBLIOGRAPHIC NOTES 144
REFERENCES 146
PART IV: IDENTITY 147
CHAPTER 11 IDENTITY 149
11.1 INTRINSIC IDENTITY 149
11.2 NAMES 151
IMAGE 5
X
11.3 SURROGATE IDENTITY 152
11.4 STRUCTURED FIELDS 152
11.5 MASTER APPLICATIONS 153
11.6 MERGING DATA 153
11.7 CHAPTER SUMMARY 154
BIBLIOGRAPHIC NOTES 155
REFERENCES 155
PART V: CANONICAL MODELS 157
CHAPTER 12 LANGUAGE TRANSLATION 159
12.1 ALTERNATIVE ARCHITECTURES 159
12.2 ATTRIBUTE TRANSLATION IN PLACE 160
12.3 PHRASE-TO-PHRASE TRANSLATION 160
12.4 LANGUAGE-NEUTRAL TRANSLATION 163
12.5 CHAPTER SUMMARY 167
BIBLIOGRAPHIC NOTES 167
REFERENCES 167
CHAPTER 13 SOFTCODED VALUES 168
13.1 UML MODEL 168
13.2 IDEF1X MODEL 171
13.3 ARCHITECTURE 171
13.4 SOFTCODING VARIATIONS 175
13.5 CHAPTER SUMMARY 185
BIBLIOGRAPHIC NOTES 185
REFERENCES 185
CHAPTER 14 GENERIC DIAGRAMS 186
14.1 GENERIC DIAGRAM EXAMPLES 186
14.2 DIAGRAM SUBJECT AREA 187
14.3 MODEL SUBJECT AREA 189
14.4 MODEL-DIAGRAM BINDING SUBJECT AREA 193
14.5 DIAGRAMTYPE SUBJECT AREA 193
14.6 DIAGRAM EXAMPLE, REVISITED 194
14.7 CHAPTER SUMMARY 197
BIBLIOGRAPHIC NOTES 197
CHAPTER 15 STATE DIAGRAMS 198
15.1 STATE DIAGRAMS 198
15.2 SCENARIOS 200
15.3 CHAPTER SUMMARY 202
BIBLIOGRAPHIC NOTES 202
REFERENCES 202
IMAGE 6
CONTENTS XI
PART VI: RELATIONAL DATABASE DESIGN 203
CHAPTER 16 RELATIONAL DATABASE DESIGN 205
16.1 MAPPING: ENTITYTYPES 205
16.2 MAPPING: NON-QUALIFIED RELATIONSHIPS 206
16.3 MAPPING QUALIFIED RELATIONSHIPS 208
16.4 MAPPING: GENERALIZATIONS 210
16.5 DESIGN IDENTITY 212
16.6 REFERENTIAL INTEGRITY 216
16.7 MISCELLANEOUS DATABASE CONSTRAINTS 218
16.8 INDEXES 220
16.9 GENERATING SQL CODE 220
16.10 CHAPTER SUMMARY 221
BIBLIOGRAPHIC NOTES 222
REFERENCES 222
APPENDIX A EXPLANATION OF THE UML NOTATION 223
ENTITY TYPE 223
RELATIONSHIPS 224
GENERALIZATION 227
BIBLIOGRAPHIC NOTES 227
REFERENCES 228
APPENDIX B EXPLANATION OF THE IDEF1X NOTATION 229
ENTITY TYPE 229
RELATIONSHIPS 230
GENERALIZATION 233
BIBLIOGRAPHIC NOTES 234
REFERENCES 234
APPENDIX C GLOSSARY 235
INDEX 241
|
| any_adam_object | 1 |
| author | Blaha, Michael |
| author_facet | Blaha, Michael |
| author_role | aut |
| author_sort | Blaha, Michael |
| author_variant | m b mb |
| building | Verbundindex |
| bvnumber | BV036700796 |
| classification_rvk | ST 265 |
| ctrlnum | (OCoLC)705878900 (DE-599)GBV617206929 |
| 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 |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01412nam a2200373 c 4500</leader><controlfield tag="001">BV036700796</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20101007 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">101004s2010 d||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2010000025</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781439819890</subfield><subfield code="c">pbk. (alk. paper) : £31,99</subfield><subfield code="9">978-1-439-81989-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)705878900</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)GBV617206929</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="049" ind1=" " ind2=" "><subfield code="a">DE-573</subfield><subfield code="a">DE-355</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.74</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 265</subfield><subfield code="0">(DE-625)143634:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Blaha, Michael</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Patterns of data modeling</subfield><subfield code="c">Michael Blaha</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Boca Raton, Fla u.a.</subfield><subfield code="b">CRC Press/Taylor & Francis</subfield><subfield code="c">2010</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XVI, 245 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="490" ind1="0" ind2=" "><subfield code="a">Emerging directions in database systems and applications</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Literaturangaben</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Schema</subfield><subfield code="g">Informatik</subfield><subfield code="0">(DE-588)4290412-2</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">Schema</subfield><subfield code="g">Informatik</subfield><subfield code="0">(DE-588)4290412-2</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="2"><subfield code="m">GBV 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=020619229&sequence=000001&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-020619229</subfield></datafield></record></collection> |
| genre | (DE-588)4123623-3 Lehrbuch gnd-content |
| genre_facet | Lehrbuch |
| id | DE-604.BV036700796 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T22:46:06Z |
| institution | BVB |
| isbn | 9781439819890 |
| language | English |
| lccn | 2010000025 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-020619229 |
| oclc_num | 705878900 |
| open_access_boolean | |
| owner | DE-573 DE-355 DE-BY-UBR |
| owner_facet | DE-573 DE-355 DE-BY-UBR |
| physical | XVI, 245 S. graph. Darst. |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | CRC Press/Taylor & Francis |
| record_format | marc |
| series2 | Emerging directions in database systems and applications |
| spelling | Blaha, Michael Verfasser aut Patterns of data modeling Michael Blaha Boca Raton, Fla u.a. CRC Press/Taylor & Francis 2010 XVI, 245 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier Emerging directions in database systems and applications Literaturangaben Schema Informatik (DE-588)4290412-2 gnd rswk-swf (DE-588)4123623-3 Lehrbuch gnd-content Schema Informatik (DE-588)4290412-2 s DE-604 GBV Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020619229&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Blaha, Michael Patterns of data modeling Schema Informatik (DE-588)4290412-2 gnd |
| subject_GND | (DE-588)4290412-2 (DE-588)4123623-3 |
| title | Patterns of data modeling |
| title_auth | Patterns of data modeling |
| title_exact_search | Patterns of data modeling |
| title_full | Patterns of data modeling Michael Blaha |
| title_fullStr | Patterns of data modeling Michael Blaha |
| title_full_unstemmed | Patterns of data modeling Michael Blaha |
| title_short | Patterns of data modeling |
| title_sort | patterns of data modeling |
| topic | Schema Informatik (DE-588)4290412-2 gnd |
| topic_facet | Schema Informatik Lehrbuch |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020619229&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT blahamichael patternsofdatamodeling |