Re: RMAN CONVERT DATABASE

On Apr 1, 6:37 am, "Syltrem" <syltremz...@xxxxxxxxxxxx> wrote:
"onedbguru" <onedbg...@xxxxxxxxx> wrote in message

news:d4d83181-ac83-4916-8682-9745bc28a1f3@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Mar 31, 8:37 pm, BillPedersen <wmapeder...@xxxxxxxxx> wrote:



On Mar 31, 1:20 pm, John Hurley <hurleyjo...@xxxxxxxxx> wrote:

<snip>
With an ERP for an SMB with a POS interface as well as an interface to
the WEB then this issue goes away. Many small retailers who are

I would not say that it "goes away"... but it may reduce the frequency
of it occurring.

Playing Devil's advocate:
Sally goes into the store, sees the last item and places it in her
cart. Simultaneously Jane places the same item in her online cart.
Jane completes her transaction while at nearly the same time the clerk
scans the item from Sally's cart - item errors because there are no
more in stock.  Now, what does the proprietor do?  Tell Sally she
can't have what she has had in her cart for the last 30 minutes?  Will
the system be able to handle the situation (over-rides etc...) And
will they be able to order another widget and back-order the online
transaction? etc. etc...

No need to respond, just food for thought...

I'll respond anyway...

This situation should not happen in a well designed system.
Items available on the online store should come from a distinct depot.
Items in the store should come from this same depot (or another, doesn't
matter) and the count of items on the online depot is reduced as items are
moved to the floor for customer to take.
Thus, the system alwways knows how many items can be sold online.

If an item is sold online while the inventory says 0 are left, it is put
into back order.
Shipping department can retrieve the same item from the store floor if it is
still available, and ship directly to the happy online customer. If not
available, they have to re-order from the supplier (which makes it a "real"
back order for the online customer).
At this point the item is sold out and they have to re-order from the
supplier.

Syltrem

I think what he was referring to was the difference between
concurrency models, which the app would either have to handle
differently, or use a lowest common denominator approach ignoring
Oracle's features.

The system I work on uses the latter, has been pounded on for years by
many customers, rewritten to have a special engine just to calculate
inventory issues like this, and still doesn't always get it right.
And that's before customizations (customers get the app source).

As to the open source ERP targeting the roll-your-own SMB market,
they'll have a heck of a time competing against the MS solutions,
whatever they are. You still have to pay to implement, and it is
cheaper to implement a moderate cost package than a free package.
Well, maybe or maybe not _actually_ cheaper, but easier to sell as
cheaper. It is an interesting twist to target roll-your-own sites
with open source, since they theoritically have the expertise in-
house, but those situations inevitably need some new guy to fix, who
will bring in what he knows has worked for him before.

jg
--
@home.com is bogus.
http://www.infoworld.com/t/misadventures/oracles-ellison-accused-running-executive-fighting-ring-285
.

Relevant Pages

  • Re: Advice to Brick & Mortars
    ... asking the customer what would bring them in. ... I frequent the local shop with the greater tobacco selection. ... I see little reason a traditional B&M store could not compete with online ... I'm not sure if their prices are the same in the store, ...
    (alt.smokers.pipes)
  • Re: Aldis newbie
    ... store in a relatively wealthy area nearly went out of business as they ... customer counts reinforcing the fact that the customers would not ... tolerate the cart nonsense. ... I'm pretty sure some people don't care about that quarter, in which case store employees still have to go gather up the abandoned carts. ...
    (rec.food.cooking)
  • Re: RMAN CONVERT DATABASE
    ... Simultaneously Jane places the same item in her online cart. ... Items available on the online store should come from a distinct depot. ... the system alwways knows how many items can be sold online. ...
    (comp.databases.oracle.server)
  • Re: Aldis newbie
    ... customer counts reinforcing the fact that the customers would not ... tolerate the cart nonsense. ... store employees still have to go gather up the abandoned carts. ... parking lots are such that you have to walk quite a ways to get back into ...
    (rec.food.cooking)
  • Re: A little venting at Home Depot...
    ... >> store. ... If a customer wants to use one, they have to get one from the ... make it a 1/2 parking lot hike to the nearest cart drop. ...
    (rec.woodworking)