Muutke küpsiste eelistusi

E-raamat: Patterns of Data Modeling

4.15/5 (24 hinnangut Goodreads-ist)
(OMT Associates, Inc. Placida, Florida, USA)
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 68,89 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Patterns of Data ModelingSuurem pilt
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

"...should be on the shelf of every database, software, and systems architect. The book captures decades of experience, presenting distilled knowledge in a concise and easy-to-understand format. The breadth of coverage is enormous, ranging from basic data structures through star schema, archetypes for representing commonly found concepts, and canonical models for tough problems."---Paul C. Brown, Principal Software Architect, TIBCO Software Inc.

"... a clear book with precise definitions and excellent examples. All examples are presented in a graphical form that is easy to read and understand. Blaha assumes the reader has a basic understanding of data modeling, but gives his examples in such a way that if the reader needs some review, it is built in."---Toby Teorey, author of Database Modeling and Design, Fourth Edition

Best-selling author and database expert with more than 25 years of experience modeling application and enterprise data, Dr. Michael Blaha provides tried and tested data model patterns to help readers avoid common modeling mistakes and unnecessary frustration on their way to building effective data models. Unlike the typical methodology book, Patterns of Data Modeling provides advanced techniques for those who have mastered the basics.

Focusing on databases rather than programming, this is one of the first books to apply the popular patterns perspective to database systems and data models. Dr. Blaha offers practical advice on the core aspects of applications and provides authoritative coverage of mathematical templates, antipatterns, archetypes, identity, canonical models, and relational database design.

Arvustused

Patterns of Data Modeling should be on the shelf of every database, software, and systems architect. The book captures decades of experience, presenting distilled knowledge in a concise and easy-to-understand format. The breadth of coverage is enormous, ranging from basic data structures through star schema, archetypes for representing commonly found concepts, and canonical models for tough problems. Paul C. Brown, Principal Software Architect, TIBCO Software Inc.

Mike Blaha has written a clear book with precise definitions and excellent examples. All examples are presented in a graphical form that is easy to read and understand. Blaha assumes the reader has a basic understanding of data modeling, but gives his examples in such a way that if the reader needs some review, it is built in. Toby Teorey, author of Database Modeling and Design, Fourth Edition

Also endorsed by the Sparx Systems Enterprise Architect Community

Preface xiii
Who Should Read This Book? xiii
What You Will Find xiii
Comparison with Other Books xiv
Acknowledgements xvi
Chapter 1 Introduction
1(8)
1.1 What is a Model?
1(1)
1.2 Modeling Notation
1(1)
1.3 What Is a Pattern?
2(1)
1.4 Why Are Patterns Important?
3(1)
1.5 Drawbacks of Patterns
4(1)
1.6 Pattern vs. Seed Model
4(1)
1.7 Aspects of Pattern Technology
5(1)
1.8
Chapter Summary
6(3)
Bibliographic Notes
6(1)
References
7(2)
Part I Mathematical Templates
9(86)
Chapter 2 Tree Template
11(25)
2.1 Hardcoded Tree Template
12(3)
2.2 Simple Tree Template
15(4)
2.3 Structured Tree Template
19(4)
2.4 Overlapping Trees Template
23(4)
2.5 Tree Changing over Time Template
27(4)
2.6 Degenerate Node and Edge Template
31(2)
2.7
Chapter Summary
33(3)
Bibliographic Notes
34(1)
References
34(2)
Chapter 3 Directed Graph Template
36(27)
3.1 Simple Directed Graph Template
37(3)
3.2 Structured Directed Graph Template
40(5)
3.3 Node and Edge Directed Graph Template
45(3)
3.4 Connection Directed Graph Template
48(4)
3.5 Simple DG Changing over Time Template
52(4)
3.6 Node and Edge DG Changing over Time Template
56(4)
3.7
Chapter Summary
60(3)
Bibliographic Notes
62(1)
References
62(1)
Chapter 4 Undirected Graph Template
63(11)
4.1 Node and Edge Undirected Graph Template
64(2)
4.2 Connection Undirected Graph Template
66(3)
4.3 Undirected Graph Changing over Time Template
69(4)
4.4
Chapter Summary
73(1)
Chapter 5 Item Description Template
74(10)
5.1 Item Description Template
74(4)
5.2 Homomorphism Template
78(4)
5.3
Chapter Summary
82(2)
Bibliographic Notes
83(1)
References
83(1)
Chapter 6 Star Schema Template
84(7)
6.1 Star Schema Template
84(5)
6.2
Chapter Summary
89(2)
Bibliographic Notes
89(1)
References
90(1)
Chapter 7 Summary of Templates
91(4)
Part II Antipatterns
95(24)
Chapter 8 Universal Antipatterns
97(14)
8.1 Symmetric Relationship Antipattern
97(2)
8.2 Dead Elements Antipattern
99(1)
8.3 Disguised Fields Antipattern
100(1)
8.4 Artificial Hardcoded Levels Antipattern
101(2)
8.5 Excessive Generalization Antipattern
103(1)
8.6 Disconnected Entity Types Antipattern
104(1)
8.7 Modeling Errors Antipattern
104(1)
8.8 Multiple Inheritance Antipattern
105(1)
8.9 Paradigm Degradation Antipattern
106(3)
8.10
Chapter Summary
109(2)
Bibliographic Notes
109(1)
References
110(1)
Chapter 9 Non-Data-Warehouse Antipatterns
111(8)
9.1 Derived Data Antipattern
111(3)
9.2 Parallel Attributes Antipattern
114(2)
9.3 Parallel Relationships Antipattern
116(1)
9.4 Combined Entity Types Antipattern
116(2)
9.5
Chapter Summary
118(1)
Part III Archetypes
119(28)
Chapter 10 Archetypes
121(26)
10.1 Account
121(1)
10.2 Actor
122(2)
10.3 Address
124(1)
10.4 Asset
124(1)
10.5 Contract
125(1)
10.6 Course
126(1)
10.7 Customer
127(1)
10.8 Document
128(2)
10.9 Event
130(1)
10.10 Flight
131(2)
10.11 Item
133(1)
10.12 Location
134(1)
10.13 Opportunity
135(1)
10.14 Part
136(1)
10.15 Payment
137(1)
10.16 Position
138(1)
10.17 Product
139(1)
10.18 Role
140(1)
10.19 Transaction
141(1)
10.20 Vendor
142(1)
10.21
Chapter Summary
142(5)
Bibliographic Notes
144(2)
References
146(1)
Part IV Identity
147(10)
Chapter 11 Identity
149(8)
11.1 Intrinsic Identity
149(2)
11.2 Names
151(1)
11.3 Surrogate Identity
152(1)
11.4 Structured Fields
152(1)
11.5 Master Applications
153(1)
11.6 Merging Data
153(1)
11.7
Chapter Summary
154(3)
Bibliographic Notes
155(1)
References
155(2)
Part V Canonical Models
157(46)
Chapter 12 Language Translation
159(9)
12.1 Alternative Architectures
159(1)
12.2 Attribute Translation in Place
160(1)
12.3 Phrase-to-Phrase Translation
160(3)
12.4 Language-Neutral Translation
163(4)
12.5
Chapter Summary
167(1)
Bibliographic Notes
167(1)
References
167(1)
Chapter 13 Softcoded Values
168(18)
13.1 UML Model
168(3)
13.2 IDEFIX Model
171(1)
13.3 Architecture
171(4)
13.4 Softcoding Variations
175(10)
13.5
Chapter Summary
185(1)
Bibliographic Notes
185(1)
References
185(1)
Chapter 14 Generic Diagrams
186(12)
14.1 Generic Diagram Examples
186(1)
14.2 Diagram Subject Area
187(2)
14.3 Model Subject Area
189(4)
14.4 Diagram Binding Subject Area
193(1)
14.5 Diagram Type Subject Area
193(1)
14.6 Diagram Example, Revisited
194(3)
14.7
Chapter Summary
197(1)
Bibliographic Notes
197(1)
Chapter 15 State Diagrams
198(5)
15.1 State Diagrams
198(2)
15.2 Scenarios
200(2)
15.3
Chapter Summary
202(1)
Bibliographic Notes
202(1)
References
202(1)
Part VI Relational Database Design
203(20)
Chapter 16 Relational Database Design
205(18)
16.1 Mapping: Entity Types
205(1)
16.2 Mapping: Non-Qualified Relationships
206(2)
16.3 Mapping: Qualified Relationships
208(2)
16.4 Mapping: Generalizations
210(2)
16.5 Design Identity
212(4)
16.6 Referential Integrity
216(2)
16.7 Miscellaneous Database Constraints
218(2)
16.8 Indexes
220(1)
16.9 Generating SQL Code
220(1)
16.10
Chapter Summary
221(2)
Bibliographic Notes
222(1)
References
222(1)
Appendix A Explanation of the UML Notation
223(6)
Entity Type
223(1)
Relationships
224(3)
Generalization
227(1)
Bibliographic Notes
227(1)
References
228(1)
Appendix B Explanation of the IDEF1X Notation
229(6)
Entity Type
229(1)
Relationships
230(3)
Generalization
233(1)
Bibliographic Notes
234(1)
References
234(1)
Appendix C Glossary
235(6)
Index 241
Serving as program and conference chair at the Working Conference on Reverse Engineering, Dr. Michael Blaha has authored six U.S. patents, four widely used books, and many papers while giving lectures throughout the world. Since 1994 Dr. Blaha has been a consultant and trainer in conceiving, architecting, modeling, designing, and tuning databases. He has worked with dozens of organizations throughout the world. He received his doctorate from Washington University in St. Louis and is an alumnus of GE Global Research in Schenectady, NY.
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814987856486e.html
Märksõnad: