Re: OO and relation "impedance mismatch"

fredrik_bertilsson_at_passagen.se (Fredrik Bertilsson) wrote in message news:<31f7e57d.0410020300.16f447fe_at_posting.google.com>...
> OO people often claims that there are an impedance mismatch between
> the OO model and the relational model, that makes it very hard use a
> relational database when you are using an OO programming language. I
> am wondering if "relational" people at this forum feel the same thing,
> that it is hard to use a OO language when you are using a relational
> database?
>
> /Fredrik

As a data boy I often see in Usenet, OO programmers ask why they shouldn't create tables and indexes and constraints on the fly (instantiate them as they would a class). The reason is that DBMS data lives on a physical disk(s). Even with RAM prices falling, I don't think it's feasible to store tens of millions of records in memory. As a data boy, I store all this data on physical disks and every night run maintenance jobs to apply/reapply indexes to make data retrieval reasonably fast. Furthermore, the inherent physical nature of a database lends itself to backups and restores. Received on Mon Oct 04 2004 - 17:45:37 CEST