Database Modeling & Design

Front Cover
Morgan Kaufmann, 1999 - Computers - 366 pages
2 Reviews

This new edition of Database Modeling & Design continues to focus on the techniques for relational database design introduced in previous editions, starting with the entity-relationship (ER) approach for data requirements specification and conceptual modeling. Author Toby Teorey then looks ahead to the common properties in data modeling and operations shared among the relational model and advanced database technologies such as the object-oriented, temporal, and multimedia models. A full chapter is devoted to database design techniques for data warehousing and online analytical processing (OLAP).

Teorey covers the database life cycle from requirements analysis and logical design to physical design for local, distributed, and multidatabases. The discussion of basic principles is supplemented with a common, running example: a company personnel and project database based on real-life experiences and classroom testing.

Written for both the novice and the professional database designer, this book is the essential resource for database modeling, including the building of standard SQL data definitions. The design rules set forth in this book are applicable to any SQL-based system, including IBM DB2, Oracle V8.0, Informix IDS-UDO, Microsoft Access, Microsoft SQL Server, and Sybase Adaptive Server Enterprise.

* Continued focus on relational model
* Integration of information about data warehouse and OLAP, plus other advanced database technologies, including object oriented, multimedia, and temporal database
* Discussion of basic principles is supplemented by examples based on real life cases

  

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

II
1
IV
2
V
4
VI
10
VII
11
VIII
13
X
24
XI
33
LII
204
LIV
206
LV
211
LVII
217
LVIII
224
LIX
228
LX
239
LXI
245

XII
38
XIII
45
XV
46
XVI
56
XVII
71
XVIII
73
XIX
76
XX
79
XXII
90
XXIII
93
XXV
94
XXVI
97
XXVII
107
XXVIII
109
XXIX
113
XXX
117
XXXI
128
XXXII
129
XXXIII
130
XXXIV
141
XXXV
142
XXXVI
146
XXXVII
156
XXXVIII
162
XXXIX
166
XL
171
XLII
172
XLIII
177
XLV
182
XLVI
185
XLVII
187
XLIX
188
L
189
LI
193
LXII
246
LXIII
251
LXV
254
LXVI
258
LXVII
261
LXVIII
264
LXIX
270
LXX
271
LXXI
272
LXXIII
273
LXXIV
281
LXXV
282
LXXVI
283
LXXVII
287
LXXVIII
296
LXXX
301
LXXXII
303
LXXXIII
304
LXXXIV
305
LXXXVI
307
LXXXVII
309
LXXXVIII
311
LXXXIX
313
XC
315
XCI
316
XCII
317
XCIII
318
XCVI
319
XCVII
323
XCVIII
346
XCIX
347
C
355
CI
366
Copyright

Common terms and phrases

References to this book

All Book Search results »

About the author (1999)

Toby J. Teorey is a professor in the Electrical Engineering and Computer Science Department at the University of Michigan, Ann Arbor. He received his B.S. and M.S. degrees in electrical engineering from the University of Arizona, Tucson, and a Ph.D. in computer sciences from the University of Wisconsin, Madison. He was general chair of the 1981 ACM SIGMOD Conference and program chair for the 1991 Entity-Relationship Conference. Professor Teorey's current research focuses on database design and data warehousing, OLAP, advanced database systems, and performance of computer networks. He is a member of the ACM and the IEEE Computer Society.

Bibliographic information