Re: more dimensional method like a query...


Pi421 wrote:
> the bottle neck is the database... and the middleware the data is
> passed thropugh. I need to work with this... :(
> I have 64 Combinations.
> first attribute with any value * 4 secsond Attribute with any value = 4
> * third attribute with any value = 16
> * fourth attribute with any value = 64
> so there are psossible 64 combinations of the attributes...
> And at the beginning I need to store the stock depending on every
> attribute and than i want to ask getStock (4 Attributes)
> How to save the stock? And how to implement the getStock...
> Ans i because of database and middleware i need to cache the stock....
>
> >In that case, I would encapsulate the [Stock] objects in a persistence
> access subsystems so that they can be read once at startup and are kept
> in memory. Then method that Client accesses would be an subsystem
> interface method and that method would dispatch to the appropriate
> collection class within the persistence access subsystem that
> corresponds to the R1 collection above. The decouples the persistence
> access optimization from the problem solution because Client invokes
> the
> same interface whether the Stocks are cached or not.
>
> would be nice, but not with 64 subsystems and collection calsses??
> Regards Joe

I'm surprised people react to garbage description like this. What
stock?
merchandise?
livestock?
shareholder certificate?
Then you go on with some combinatorial thoughts that only _you_ can
make sence of.

Give some example, and then people can suggest the appropriate data
model.

.

Relevant Pages

  • Re: more dimensional method like a query...
    ... And at the beginning I need to store the stock depending on every ... Ans i because of database and middleware i need to cache the stock.... ... access subsystems so that they can be read once at startup and are kept ...
    (comp.object)
  • Re: create a small stock control and sales database
    ... "Inventory control" sample database doesn't really "fit the bill". ... My comments also apply to the Northwind Traders database. ... Description, type of container, weight, Price, and Purchase price.This table will rarely be changed, the "changing tables" are stock in and stock out. ... But you might also want to copy it to a new field in [Product sold] to reflect what the unit price was at the time of a specific sale. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: thoughts on how difficult this database would be to make?
    ... If you need to build the database some time soon, ... how (we'll use stock for this purpose) behaved each day at the open. ... Often that gap will be filled, meaning the price will go back ... You might like to watch a brief video I suggested here earlier (and ...
    (microsoft.public.access.gettingstarted)
  • Re: thoughts on how difficult this database would be to make?
    ... If you need to build the database some time soon, ... Excel and Word applications for a reasonable fee. ... I'm sure your gains from the stock would easily cover my fees. ... Often that gap will be filled, meaning the price will go back ...
    (microsoft.public.access.gettingstarted)
  • Re: How do i set up an access program to help with stock control
    ... monitor stock ... Like all database design projects, you will sit down and work out what ... you can link them all together in *data modeling* relationships. ...
    (microsoft.public.access.tablesdbdesign)