Computerization in a firm using Java

[ABC]

If I have the following scenario, what should I do?

The boss of a small company wants to competerize the daily operations.

Say, he has the office in City A, but owns a factory and warehouse in
City B. He wants to interconnect these locations by computer. He want
to build a database to manage the stock, and query the warehouse
status using browser when he goes online. What key issues that he
should think of?

1. Database
2. Application server
3. Web server
4. Internet service
5. A main programming language
6. Web page

Anything else?

He wants the whole system developed by Java, then, what are the most
i) suitable (easy, convenient)
ii) cheapest iii) common choice of above items?

Actually, I know something like Oracle, MySQL, ... for database, but
do not know which is the most appropriate selection.

Thanks for your answers!

[Nathan Zumwalt]

I'm not sure how big an organization you are... but why are you trying
to build this? There are many software packages that do this sort of
thing already. Tier one products (SAP, Lawson/PeopleSoft) may be too
expensive for you, but there has got to be some smaller software
packages that can do what you're looking for. Now that the .com
bubble has burst, it's cheaper to buy rather than build again.

//Nathan

cd***@hongkong.com (ABC) wrote in message news:<d6*************************@posting.google.c om>...

If I have the following scenario, what should I do?

The boss of a small company wants to competerize the daily operations.

Say, he has the office in City A, but owns a factory and warehouse in
City B. He wants to interconnect these locations by computer. He want
to build a database to manage the stock, and query the warehouse
status using browser when he goes online. What key issues that he
should think of?

1. Database
2. Application server
3. Web server
4. Internet service
5. A main programming language
6. Web page

Anything else?

He wants the whole system developed by Java, then, what are the most
i) suitable (easy, convenient)
ii) cheapest iii) common choice of above items?

Actually, I know something like Oracle, MySQL, ... for database, but
do not know which is the most appropriate selection.

Thanks for your answers!