Calling Database Experts ...

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Nick Rambarransingh Wed, 06 Dec 2000 00:00

#878

Author: Nick Rambarransingh
Date: Wed, 06 Dec 2000 00:00

20 lines
1312 bytes

Good Day All,

  I have found myself in the situation of trying to map C++ objects to
relational tables.  Someone I work with believes, very strongly, that
the tables and classes should be a 1 for 1 match, as this is a
normalized version of th DB Structure.

  I on the otherhand disagree.  I do not believe that the struture would
be anything close, well, at least not one for one.
His process is to go class for table, which apperntly is normalized, and
then try to tweak performance, or tune the DBMS.

  I believe that analysis of the the class structure will eventually
rear its ugly head, and by using a combination of sequence and use case
diagrams, one can determine a much more robust structure.

Any comments, suggestions, readings.

Thanks, Nick
Borland Forever ...

Re: Calling Database Experts ...

#879

Author: Mark Cashman
Date: Thu, 07 Dec 2000 00:00

18 lines
1363 bytes

Hi, Nick!

Essentially, the TTable or TQuery classes form the relational layer. The
TDataModule can form the "entity" or logical layer. Or you can wrap the
data module in another class that surfaces a more constrained interface.

But creating a separate set of classes mapping one to one to the RDB is
the sort of thing you do in VC++ where you don't have any nice database
classes. Why reinvent the wheel in BCB, right?

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads