On May 3, 2006, at 8:42 AM, Gregory S. wrote:
with Object-Relational Modeling (ORM). ActiveRecord is an ORM
and some of those terms (e.g. join models) seem to have been invented
specifically for AR.
Yes, but a good database book will discuss object-oriented and object-
relational databases, not just relational databases. The key here is
that you need both an understanding of databases AND an understanding
of object oriented programming concepts. It’s one of those times you
have to put the knowledge from multiple courses together.
} Does anyone know of a book like that? (Hope I’m not wishing for too
it is a textbook) these days. I searched Amazon for “database”
many books, but I can’t say anything about their quality.
I’ve heard good things about the Silberschatz book. The text we used
was titled “Database Systems: The Complete Book” and was authored by
Garcia-Molina, Ullman, & Widom (almost sounds like a law firm). It’s
another $100 book, but it’s pretty comprehensive. I highly recommend
it if you are looking for a deeper understanding that also can serve
as a good reference. Here’s the synopsis from ecampus.com:
This introduction to database systems offers a readable comprehensive
approach with engaging, real-world examplesâ??users will learn how to
successfully plan a database application before building it. The
first half of the book provides in-depth coverage of databases from
the point of view of the database designer, user, and application
programmer, while the second half of the book provides in-depth
coverage of databases from the point of view of the DBMS implementor.
The first half of the book focuses on database design, database use,
and implementation of database applications and database management
systemsâ??it covers the latest database standards SQL:1999, SQL/PSM,
SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most
other books. The second half of the book focuses on storage
structures, query processing, and transaction managementâ??it covers
the main techniques in these areas with broader coverage of query
optimization than most other books, along with advanced topics
including multidimensional and bitmap indexes, distributed
transactions, and information integration techniques. A professional
reference for database designers, users, and application programmers.
I think that it’s also sold separately in parts 1 and 2. The second
half discusses the concepts related to designing the database server
itself, so unless you plan on writing the next-generation database
server YourSQL, it’s probably overkill.