Re: Database design of stock prices?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 09 Apr 2007 21:14:58 GMT
Message-ID: <m1ySh.21560$PV3.223627@ursa-nb00s0.nbnet.nb.ca>

jefftyzzer wrote:

> 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 first-
> rate 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 pre-
> UML 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.

Thanks Jeff, I think that is a very well-reasoned and helpful explanation. Received on Mon Apr 09 2007 - 16:14:58 CDT