Re: Database design of stock prices?

On Apr 6, 5:18 pm, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
> jefftyzzer wrote:
> > On Apr 3, 8:56 pm, "knguyen" <nguyen.h.kh..._at_gmail.com> wrote:
>
> >>Hi,
>
> >>I am designing a database to hold stock prices for about 200 stock
> >>symbols. I had some ideas but am not sure since this is my first major
> >>database design. Could anyone please point me to some papers/books/
> >>websites or give me some ideas to start?
>
> >>Thanks,
>
> >>-k
>
> > After a little "conceptual translation," Chapters 4, 9, 10, and 11 of
> > Martin Fowler's _Analysis Patterns_ book may get you started.
>
> > Good luck,
>
> > --Jeff
>
> Hi Jeff,
>
> Why do you recommend an analysis book for design? Why that book in
> particular?- Hide quoted text -
>
> - Show quoted text -

Hi, Bob.

By "designing a database to hold stock prices," I took the OP to mean that he was working on the first step in his design--namely the data model/data requirements--and that he was not terribly familiar with the problem domain (or at least how to model it--he may be a firstrate  securities professional for all I know ;-).

Of the books available that offer "canned" first-cuts at data models (e.g., the books by David Hay and Len Silverston), none cover stocks. The closest I could find was the book by Fowler, which provides preUML  class models.

Without inviting a flame-war, I don't think it's assuming too much that the OP could take a look at the Fowler chapters and use them as input to/food-for-thought for his data model. For the record, I'm not suggesting that class = relation or instance variable = attribute, but I am suggesting that the OP might find value in how Fowler abstracted the problem domain(s) and what he considered the classes and their multiplicities (cardinalities) to be.

Regards,

--Jeff Received on Mon Apr 09 2007 - 22:17:20 CEST