Who is AIS? News about this site Reviews of CASE products Reading - White Papers CASE technology training  & consulting CASE technology training  & consulting
Who is AIS? Users' Groups & Feedback Opinions - We have strong ones! Links to Other Pages of Interest Training & Consulting
AIS CASE Home Page Site Table of Contents Private Pages E-mail to AIS  


30 Jan 2000



  The following bibliography is maintained from time to time for your convenience by the staff of AIS. We make no attempt to keep pace with the explosion of new books in information systems subjects. Ten years ago I had to make a special trip into San Francisco to search out technical books in the basement of Staceys. Today I can find thousands of titles within five miles of my Marin County home at Barnes & Noble or Borders. 

Unfortunately, while most technical books cost $35 to $50, very few are worth even $5. One can certainly not tell a book by its cover, although I do routinely trust O'Reilly's Nutshell series. Many of the most handsomely designed and bound books are empty between the covers. That's why we try to share with you those which we find particularly useful.

While not all of the books listed here deal directly with data modeling per se, those which don't include valuable discussions of issues which impact data model methods and designs. We make no claim that this list is complete or current. We hope it will be helpful. Any good library or bookstore will have many more sources. As always, your corrections, comments, and additions are welcome at ddwelle@aisintl.com.

Labels such as Barker90 may appear in various AIS documents to cite the works below.

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


Copyright 1997-2000 Applied Information Science