Re: more dimensional method like a query...

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

.

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)