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_at_ursa-nb00s0.nbnet.nb.ca>
>
>
> 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.
Date: Mon, 09 Apr 2007 21:14:58 GMT
Message-ID: <m1ySh.21560$PV3.223627_at_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 - 23:14:58 CEST