| Barker90 |
Richard Barker, CASE Method
Entity Relationship Modeling (Addison Wesley
Publishing Company, 1990), clothbound; ISBN
0-201-41696-4. We regard this book as fundamental to
any study of data mdeling. Barker is articulate,
entertaining, and connected to the real world.
Start here!
|
| Bean96 |
James Bean, Sybase
Client/Server Explorer (The Coriolis Group,
1996), paperbound; ISBN 1-57610-045-6. Demonstrates
construction of Client/Server systems with
Sybase's PowerDesigner
and SQL Anywhere products.
|
| Booch95 |
Grady Booch and James Rumbaugh, Unified
Method for Object-Oriented Development (Rational Software
Company, 1995). |
| Bruce92 |
Thomas A. Bruce, Designing
Quality Databases with IDEF1X Information Models
(Dorset House, 1995). 547 pages, clothbound; ISBN
0-932633-18-8 |
| Burleson94 |
Donald Keith Burleson, Practical
Application of Object-Oriented Techniques to
Relational Databases (John Wiley & Sons,
Inc., 1994) 250 pages, clothbound; ISBN
0-471-61225-1. |
| Celko95 |
Joe Celko, Joe Celko's SQl
for Smarties (Morgan Kaufmann Publishers,
Inc., 1995), 467 pages; paperbound; ISBN
1-55860-323-9. While this book is primarily a
collection of expert tips and techniques with
SQL, Celko provides some valuable insight into
the physical and performance consequences of poor
data design. After all, if you are modeling data,
your efforts will almost certainly be implemented
in some SQL database so it is important to know
how all that work gets done.
|
| Chen76 |
Peter Chen, "The Entity
Relationship Model - Toward a Unified View of
Data ", ACM Transactions on Database
Systems, Volume 1, No. 1 (March 1976), pp
9-36. |
| Coad91 |
P. Coad, Object Oriented
Analysis, Second Edition (Prentice Hall,
1991). |
| Codd70 |
E. F. Codd, "A Relational
Model of Data for Large Shared Data Banks ",
Communications of the ACM (1970). This
is Codd's original exposition of the relational
theory.
|
| Codd74 |
E. F. Codd, "The Relational
Approach to Data Base Management: An
Overview", Third Annual Texas Conference
on Computing Systems (1974). This is
Codd's famous 12 principles of relational
databases.
|
| Codd90 |
E. F. Codd, The Relational
Model for Database Management (Addison-Wesley
Publishing Company, 1990), 538 pages; clothbound;
ISBN 0-201-14192-2 . Codd, the father of
relational systems, updated his famous manifesto
for the relational model in 1990. It now demands
conformance to 333 principles for any
database system to be labeled
"relational". While some may find
Codd's position rather jealously possessive of
relational dogma, there is no denying the clarity
and completeness of his exposition. This is a
classic reference work which should be in every
library, whether public or private, on
information systems technologies.
|
| Date93 |
C. J. Date with Hugh Darwen, The
SQL Standard, Third Edition (Addison-Wesley
Publishing Company, 1993), 414 pages; paperbound;
ISBN 0-201-55822-X. |
| Date95 |
C. J. Date, An Introduction
to Database Systems (Addison-Wesley
Publishing Company, 1995), 839 pages; clothbound;
ISBN 0-201-54329-X. C. J. Date needs no
introduction to anyone who reads current journals
or attends database conferences. One of the most
prolific and profound writers on database issues,
Data has updated his classic work in this, its
sixth, edition. It is worth the hefty textbook
price for the footnotes alone. And having a copy
handy is imperative to fully appreciate the
frequent dialogs in Database Programming and
Design.
|
| DeMarco78 |
Tom De Marco, Structured
Analysis and Systems Specifications (Yourdon
Inc., 1978), 277 pages; paperbound. |
| Fleming89 |
Candace C. Fleming and Barbara
von Halle, Handbook of Relational Database
Design (Addison-Wesley Publishing Co., 1989),
605 pages; clothbound; ISBN 0-201-11434-8. |
| Flynn96 |
Donal J. Flynn and Olivia
Fragoso Diaz, Information Modelling; An
international perspective (Prentice Hall,
1996), 270 pages; paperbound; ISBN 0-13-234691-5.
By
comparing IE, MIER, Merise, SSADM, and Yourdan's
OOA, these authors shed new light on the origins,
principles, and differences among all information
modeling methods.
|
| Gane79 |
C. Gane and T. Sarson, Structured
Systems Analysis (Prentice-Hall, 1979). |
| Gane89 |
C. Gane, Rapid Systems
Development Using Structured Techniques and
Relational Technology (Prentice-Hall, 1989),
200 pages; clothbound; ISBN 0-13-753070-6. |
| Halpin95 |
Terry Halpin, Conceptual
Schema & Relational Database Design; Second
Edition (Prentice Hall of Australia Pty Ltd,
1995), 547 pages; paperbound; ISBN 0-13-355702-2. Terry
Halpin's definitive work on Object Role Modeling
is not for the joy of reading but for the joy of
discovery. Here is a better, more complete (and
mathematically provable) way to model data than
our time-tested entity relationship diagrams. ORM
is such a completely different paradigm- in
notation, vocabulary, concept - from the more
familiar ER that it is best to read this book
with a clear head and firm commitment to
understanding a science which is new to most of
us. While Dr. Halpin makes little attempt to map
ORM concepts to other methodologies, even readers
who will not have the opportunity to use the
technologies will gain a more solid understanding
of the inherent, immutable structure of data.
|
| Hay96 |
David C. Hay, Data Model
Patterns, Conventions of Thought
(International Thomson, 1996), 268 pages;
clothbound; ISBN 0-932633-29-3. U.S. Distributors
are International Thomson Computer Press at 20
Park Plaza, Suite 1001, Boston, MA 02116. This
excellent book follows the methods of {Barker90} to examine
numerous patterns in conceptual data structures
which occur frequently throughout business,
industry, and government. The included examples
will solve many modeling problems for every
organization and skip over the "reinvent the
wheel" stage of many projects.
|
| Kimball96 |
Ralph Kimball, The Data
Warehouse Toolkit (John Wiley & Sons,
1996), 388 pages; paperbound; ISBN 0-471-15337-0. |
| Koch94 |
George Koch, ORACLE 7 - the
Complete Reference (Osborne McGraw-Hill,
1994), 1028 pages; paperbound. Unlike many
product specific references, this one is well
written and readable, even enjoyable. I rate it
tops on the Oracle bookshelf.
|
| McGoveran93 |
D. McGoveran & C.J. Date, A
Guide to SYBASE and SQL Server
(Addison-Wesley, 1993), 548 pages; clothbound. |
| Martin90 |
James Martin, Information
Engineering (Prentice Hall, 1990), three
volumes of 178, 497, and 625 pages respectively;
clothbound, ISBN 0-13-464462-X (vol. 1),
0-13-464885-4 (vol. 2), and 0-13-465501-X (vol.
3). Fifteen years ago James Martin was a god;
ten years ago he was essential. Today I find his
works overworked and cluttered, out of touch with
more streamlined techniques which are found in
most modern systems environments. Nonetheless, a
generation or two of systems professionals were
trained under Martin's endpaper matrix of works
on every subject in IT. So it behooves one to
read and be familiar, even if one's peers and
workplace do not demand it.
|
| Parsaye93 |
Kamran Parsaye and Mark
Chignell, Intelligent Database Tools &
Applications (John Wiley & Sons, 1993),
541 pages; paperbound. |
| Purba94 |
Sanjiv Purba, Developing
Client/Server Systems Using SYBASE SQL Server
System 10 (John Wiley & Sons, 1994), 396
pages; paperbound. |
| Reingruber94 |
Michael C. Reingruber and
William W. Gregory, The Data Modeling Handbook
(John Wiley & Sons, 1994), 362 pages;
clothbound; ISBN 0-471-05290-6. |
| Rodgers91 |
Ulka Rodgers, ORACLE - A
Database Developer's Guide (Prentice-Hall,
1991), 250 pages; paperbound. |
| Ross94 |
R. G. Ross, The Business Rule
Book (Database Research Group, 1994) |
| Sanders95 |
G. Lawrence Sanders (mgtsand@acsu.buffalo.edu),
Data Modeling (Course Technology at 800
648-7450, 1995) 145 pages; ISBN 0-87709-066-1.
See also http://wings.buffalo.edu/mgmt/courses/mgtsand/data.html |
| Schenck94 |
Douglas Schenck and Peter
Wilson, Information Modeling the EXPRESS Way
(Oxford University Press, 1994), 388 pages;
clothbound. |
| Silverston97 |
Len Silverston, W. H. Inmon, and
Kent Graziano, The Data Model Resource Book(John
Wiley & Sons, Inc., 1997), 355 pages;
paperound; ISBN 0471-14364-8. |
| Simsion94 |
Graeme Simsion, Data Modeling
Essentials (Van Nostrand Reinhold, 1994), 310
pages; paperbound; ISBN 1850328773. This is the
only genuinely readable work in my library on the
often dry subject of data modeling. Simsion has
ample profession credentials to write with a
mouth full of marbles yet he manages to avoid
that trap while illuminating murky material. His
theory is complete and well woven together, with
ample cross referencing amongst the various
flavors of ER modeling. His sample diagrams are
clear and demonstrate their points effectively.
He is thorough without tiring. This is a must-own.
|
| Simon95 |
Alan R. Simon, Strategic
Database Technology: Management for the Year 2000
(Morgan Kaufmann Publishers, Inc.), 446 pages;
paperbound. |
| Teorey94 |
Tobey J. Teorey, Database
Modeling & Design, The Fundamental Principles;
Second Edition (Morgan Kaufmann Publishers, Inc.,
1994), 277 pages; paperbound; ISBN 1-55860-294-7. If
your local bookstore carries only one work on
data modeling, this is most likely it. That's a
pity because it is dense, dry, confusing, and
unentertaining. The diagrams make a good case for
why only the mighty Merlins of modeling can
handle this stuff. However, Teorey discusses
thoroughly the classic form of Chen type ER and
also provides rather complete references to the
literature. This is a good volume to keep handy
to impress others and ward off competition.
|
| Yourdon89 |
Edward Yourdon, Modern
Structured Analysis (Yourdon Press, 1989),
672 pages; clothbound; ISBN 0-13-598624-9. Looking for
a reference point on classic structured
techniques? Even if you are an out and out OO
freak who scoffs at the very word
"structured" (and many do!), you ought
to read this fine book to understand the
foundation of modern systems thinking. This may
offer the best and most complete explanation of
DFDs in context with ERDs in print. I carry
it with me, even though it weighs nearly as much
as my laptop!
|
| Yourdon96 |
Edward Yourdon and Carl Argila, Case
Studies in Object Oriented Analysis and Design
(Yourdon Press, 1996), 346 pages; clothbound;
ISBN 0-13-305137-4. I must admit to a fondness
for Ed Yourdan's style, dating back to our early
work in structured systems in the 1970's. This
book, unlike many from the methodology mills,
actually has something new to say. Yourdon and
Argila offer one of the more lucid discussions in
print of how all the pieces of analysis and
design fit together. We find this perspective
sadly lacking in most of the new classics on OO
|
|
|