Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.java.databases > #52

Re: Designing a structure

Show all headers | View raw

  To: comp.databases,comp.lang.
Ed Prochak <edprochak@gmail.com> wrote:

>On Apr 28, 2:33 pm, David Segall <da...@address.invalid> wrote:
>> Ed Prochak <edproc...@gmail.com> wrote:
>> >On Apr 26, 9:33 am, David Segall <da...@address.invalid> wrote:
>> >> I'm looking for the ideal PIM database structure and you
>> >> probably understand the requirements better than I do.
>>
>> >Sorry, but my crystal ball has been broken for quite some time. Only
>> >you know the requirements for your project.
>>
>> >Finally, to give you a hint, I would approach this by making
>> >addresses  a separate entity, Then both person and business entities
>> >can reference the address entity (e.g. allows a home business) I'll
>> >let your discover the entity you'll need to allow multiple addresses.
>> >(it is not hard.)
>>
>> Thank you for the hint. Your hint indicates that you don't need a
>> crystal ball to understand my requirements and that you may have some
>> useful advice. Why are you so reluctant to give it to me?
>
>There is no ONE TRUE CORRECT SOLUTION.
That is a surprising statement for a contributor to this group. It is
probably true, but the relational database has dominated the industry
for over 30 years. It provides an excellent way of modeling real world
data and the alternatives have not (yet) been seen as a serious
challenge.
>It is a matter of balancing features (performance, data storage, code
>size, code functionality).
The history of computing has been about finding the "true correct"
data model or user interface and _then_ optimising features including
the ones you list. It is possible that an address book is an extremely
complicated application and there is no simple model for it that
minimises redundant information. I sought your help because, unless
the model is simple enough to think of in a few idle minutes, it is
probably too complicated for the average address book user. I am
confident that if you can produce an intuitive, simple, data model it
will become as ubiquitous as a user name and password logon.
>
>If you want a professional solution, then you need to learn
>professional skills. It will take more time and effort than can be
>done in a single newsgroup thread.

>
>Finally, we also get the occasional student postings here looking for
>solutions to their homework/project assignments.  I try in my posts to
>generally lead toward solutions without supplying them 
I believed my original post indicated that I had thought about the
problem, looked at other people's solutions and that I was coming to
you because I was not satisfied with anything I had seen so far. I
assumed that the post spoke for itself and, even if it did not, a
respondent would do a Google search before making assumptions about
the poster. Clearly, my post was not as lucid as it seemed to me
because this is the fourth response based on an elementary database
design course. I was seeking a breakthrough data model of a personal
address book that one of you had thought of in the shower this
morning.

---
 * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet!
--- Synchronet 3.15a-Win32 NewsLink 1.92
Time Warp of the Future BBS - telnet://time.synchro.net:24

Back to comp.lang.java.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Designing a structure for "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: Designing a structure "Ed Prochak" <ed.prochak@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: Designing a structure "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: Designing a structure "Martin Gregorie" <martin.gregorie@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: Designing a structure "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
          Re: Designing a structure "Ed Prochak" <ed.prochak@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
          Re: Designing a structure "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: Designing a structure "Ed Prochak" <ed.prochak@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: Designing a structure "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
          Re: Designing a structure "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
            Re: Designing a structure "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
              Re: Designing a structure "David Cressey" <david.cressey@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
                Re: Designing a structure "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
              Re: Designing a structure "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
                Re: Designing a structure "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
                Re: Designing a structure "Ed Prochak" <ed.prochak@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
                Re: Designing a structure "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
                Re: Designing a structure "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
            Re: Designing a structure "Gene Wirchenko" <gene.wirchenko@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
          Re: Designing a structure "Roedy Green" <roedy.green@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: Designing a structure "ram" <ram@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
    Re: Designing a structure "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: Designing a structure "ram" <ram@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: Designing a structure "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
          Re: Designing a structure "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
      Re: Designing a structure "David Segall" <david.segall@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
        Re: Designing a structure "Marco" <marco@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
          Re: Designing a structure "Arved Sandstrom" <arved.sandstrom@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000
  Re: Designing a structure "Marco" <marco@THRWHITE.remove-dii-this> - 2011-04-27 15:21 +0000

csiph-web