Muutke küpsiste eelistusi

UML Database Modeling Workbook [Pehme köide]

3.80/5 (10 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 300 pages, kõrgus x laius: 255x205 mm, kaal: 544 g
  • Ilmumisaeg: 27-Aug-2013
  • Kirjastus: Technics Publications LLC
  • ISBN-10: 1935504517
  • ISBN-13: 9781935504511
Teised raamatud teemal:
UML Database Modeling WorkbookSuurem pilt
  • Formaat: Paperback / softback, 300 pages, kõrgus x laius: 255x205 mm, kaal: 544 g
  • Ilmumisaeg: 27-Aug-2013
  • Kirjastus: Technics Publications LLC
  • ISBN-10: 1935504517
  • ISBN-13: 9781935504511
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781935504511.html
Märksõnad:
Learn how to construct UML data models by working through a series of exercises and self-assessment tests. Beginners can learn the UML directly. Experienced modelers can leverage their understanding of existing database notations, as the book extensively compares the UML to traditional data modeling.

Chapter 1 Introduction
1(4)
1.1 Data and Databases
1(1)
1.2 Models and Data Models
2(1)
1.3 The Unified Modeling Language (UML)
2(1)
1.4 Information Engineering (IE)
3(1)
1.5 Using UML and IE Together
3(1)
1.6
Chapter Summary
4(1)
Bibliographic Notes
4(1)
References
4(1)
Chapter 2 A Data Modeling Example
5(4)
2.1 UML Data Model
5(1)
2.2 IE Data Model
6(2)
2.3
Chapter Summary
8(1)
Bibliographic Notes
8(1)
References
8(1)
Part 1 Basic Modeling Concepts
9(42)
Chapter 3 Basic Class Concepts
11(11)
3.1 Class
11(1)
3.2 Attribute
12(1)
3.3 Operation
13(1)
3.4 Domain and Data Type
14(1)
3.5 Definitions
15(1)
3.6 Practical Tips
16(1)
3.7
Chapter Summary
17(5)
Bibliographic Notes
18(1)
References
18(1)
Exercises
18(4)
Chapter 4 Basic Association Concepts
22(15)
4.1 Association
22(2)
4.1.1 UML
22(1)
4.1.2 IE
22(2)
4.2 Association Name
24(1)
4.3 Association End
25(2)
4.4 Multiplicity
27(3)
4.5 Analogies
30(1)
4.6 Practical Tips
30(1)
4.7
Chapter Summary
30(7)
Bibliographic Notes
30(2)
References
32(1)
Exercises
32(5)
Chapter 5 Basic Generalization Concepts
37(14)
5.1 Generalization
37(1)
5.2 Abstract vs. Concrete Class
38(1)
5.3 IE Notation
39(1)
5.4 Multiple Generalization Levels
40(1)
5.5 Practical Tips
40(1)
5.6
Chapter Summary
41(10)
Exercises
42(5)
Test 1
47(4)
Part 2 Advanced Modeling Concepts
51(52)
Chapter 6 Advanced Class Concepts
53(10)
6.1 Candidate, Primary, and Alternate Keys
53(1)
6.2 Surrogate Key vs. Natural Key
54(1)
6.3 Derived Data
55(1)
6.4 Current vs. Historical Data
56(1)
6.5 Modeling Pitfalls
57(2)
6.6 Practical Tips
59(1)
6.7
Chapter Summary
59(4)
Bibliographic Notes
60(1)
References
60(1)
Exercises
60(3)
Chapter 7 Advanced Association Concepts
63(10)
7.1 Association Class
63(1)
7.2 Ordered Association
64(1)
7.3 Qualified Association
65(2)
7.4 Ternary Association
67(1)
7.5 Modeling Pitfalls
68(1)
7.6 Practical Tips
69(1)
7.7
Chapter Summary
70(3)
References
70(1)
Exercises
70(3)
Chapter 8 Advanced Generalization Concepts
73(10)
8.1 Multiple Inheritance
73(1)
8.2 Multiple Generalization
73(2)
8.3 Overlapping Generalization
75(3)
8.4 Large Taxonomies
78(1)
8.5 Analogies
79(1)
8.5.1 Generalization vs. Association
79(1)
8.5.2 Generalization vs. Instantiation
80(1)
8.5.3 Generealization vs. Association End
80(1)
8.5.4 Generalization vs. Enumeration
80(1)
8.6 Practical Tips
80(1)
8.7
Chapter Summary
80(3)
Exercises
81(2)
Chapter 9 Packages
83(5)
9.1 Package
83(1)
9.2 Package Example
84(1)
9.3 Modeling Pitfalls
85(1)
9.4 Practical Tips
86(1)
9.5
Chapter Summary
86(2)
Bibliographic Notes
86(1)
References
86(1)
Exercises
86(2)
Chapter 10 Model Quality
88(15)
10.1 Normal Forms
88(2)
10.2 Database Constraints
90(1)
10.3 Hillard's Graph Complexity
90(2)
10.4 Hoberman's Data Model Scorecard®
92(1)
10.5 Additional Quality Items
93(1)
10.6
Chapter Summary
94(9)
Bibliographic Notes
95(1)
References
95(1)
Exercises
95(2)
Test 2
97(6)
Part 3 Kinds of Models
103(28)
Chapter 11 Operational Data Modeling
105(3)
11.1 What is an Operational Data Model?
105(1)
11.2 Sample Operational Data Model
105(1)
11.3 Why Operational Data Models Are Important
106(1)
11.4 Constructing an Operational Data Model
106(1)
11.5
Chapter Summary
107(1)
Bibliographic Notes
107(1)
References
107(1)
Chapter 12 Enterprise Data Modeling
108(6)
12.1 What is an Enterprise Data Model?
108(1)
12.2 Sample Enterprise Data Model
109(1)
12.3 Why Enterprise Data Models Are Important
110(1)
12.4 Constructing an Enterprise Data Model
110(1)
12.5 Common EDM Concepts
111(1)
12.6
Chapter Summary
111(3)
Bibliographic Notes
112(1)
References
112(1)
Exercises
112(2)
Chapter 13 Data Warehouses
114(9)
13.1 What is a Data Warehouse?
114(2)
13.2 Sample Data Warehouse Model
116(1)
13.3 Why Data Warehouses Are Important
117(1)
13.4 Constructing a Data Warehouse
117(1)
13.5 Facts
118(1)
13.6 Dimensions
119(1)
13.7
Chapter Summary
120(3)
Bibliographic Notes
120(1)
References
120(1)
Exercises
121(2)
Chapter 14 Master Data Modeling
123(8)
14.1 What is a Master Data Model?
123(1)
14.2 Sample Master Data Model
123(1)
14.3 Why Master Data Models Are Important
124(1)
14.4 Constructing a Master Data Model
125(1)
14.5 Operational Data Modeling and MDM
126(1)
14.6 Enterprise Data Modeling and MDM
126(1)
14.7 Data Warehouses and MDM
126(1)
14.8
Chapter Summary
127(4)
Bibliographic Notes
127(1)
References
127(1)
Exercises
127(2)
Test 3
129(2)
Part 4 Database Design
131(22)
Chapter 15 Database Structure
133(9)
15.1 Fine Tuning of Physical Tables
133(1)
15.2 Domains and Data Types
134(1)
15.3 Primary and Alternate Keys
134(1)
15.4 Indexes
135(1)
15.5 Referential Integrity
135(1)
15.6 Check Constraints
136(1)
15.7 Views
136(1)
15.8 Script to Create the Online Retail Database
136(1)
15.9
Chapter Summary
136(6)
Bibliographic Notes
141(1)
References
141(1)
Exercises
141(1)
Chapter 16 Database Queries
142(11)
16.1 The Object Constraint Language (OCL)
142(1)
16.2 Using the OCL for Class Model Traversal
142(1)
16.3 Basic OCL Traversal Expressions
143(2)
16.4 Composite OCL Traversal Expressions
145(2)
16.4.1 Objects and Object Collections
146(1)
16.4.2 Dealing with Nulls
147(1)
16.5 Traversing Database Tables
147(1)
16.6 SQL Code
148(1)
16.7
Chapter Summary
149(4)
Bibliographic Notes
149(1)
References
149(1)
Exercises
149(2)
Test 4
151(2)
Appendix: Answers to Exercises and Tests
153(50)
Chapter 3
153(4)
Chapter 4
157(7)
Chapter 5
164(5)
Test 1
168(1)
Chapter 6
169(4)
Chapter 7
173(4)
Chapter 8
177(3)
Chapter 9
180(3)
Chapter 10
183(5)
Test 2
187(1)
Chapter 12
188(1)
Chapter 13
189(2)
Chapter 14
191(2)
Test 3
192(1)
Chapter 15
193(6)
Chapter 16
199(4)
Test 4
201(2)
Index 203