Re: Help Setup & Programming of Web-based DB

Hello, I think the way may be an another.

1. To much difference between SQL for ASP and SQL for Oracle and you will have to use MS IIS in future with Oracle (but not nature Oracle SQL and stored procedures for dynamic HTML creation).
2. You can use Oracle Application Server right now and it will be run with database may be more quickly then with ASP (by my opinion) and you will spend less time for create you application.
3. You will can easily migrate from yours current database to new in Oracle ( I think, but I am not sure which one do you have now).
4. With Oracle Web server you system will cost Oracle Web Server about $876.00 $. Oracle SQL Server about $1,327.50 $ (min 5 users) MS NT about 1000$ Hardware not more then 20K depend on a database siza and memory ( should be more 192Mb)
5. Small app only for search from database through standard HTML can be done in 1day (with full installation Oracle 8 for NT and Oracle Web Server 4 for NT).

Scenically yours,
Iurie Jigalov.
Zhigalov.Yuri_at_usa.net

Mir wrote:

> Hello all! - Help Setup & Programming of Web-based DB
>
> Situation:
> ==========
>
> I am trying to set up a web-based DB for a publishing company to allow
> clients to at least be able to search through list of available books,
> books in print and if not found there, go to other databases.
>
> Total Clients: 10,000
> Expected # in 2 years: 100,000
> Expected # in 5 years: 1,000,000
>
> Currently: it is a character-based system that is NOT On-Line i.e.,
> they fax
> the searches in and then the work gets done using phone calls etc...
>
> My Solution Idea:
> ================
>
> Use Netscape browser
> Use MS Internet Information Server
> Use MS-SQL*Server 7.0 <-- the Local (main DB) [Chosen due to
> $$$costs$$$]
> Use Standard Java Standard HTML Standard SQL
> Use MS Active Server Pages to specialize Web pages for clients
> Use MS NT and Exchange
>
> Customer comes to page and uses a form to search on various criterian,
> the
> search gets translated to SQL (by Java - I would think) and sent to
> MS-SQL*Server.
> If found, send retrieved output to web and stop.
> else go on to other DBs and conduct searches.
>
> * Must be fast and useful info must be supplied!
>
> Problems:
> ========
>
> Cost: should be within $250,000
> Time: should be up and fully functional in 3-6 months with 1-2 people
> Scalability: Someone should be able to move this system to an Oracle or
> other platform
> in 3-5 years if need be without having to re-write everything.
>
> Questions: [I've never programmed on the web]
> =========
>
> 1) Is my solution sound? Why not?
>
> 2) What kind of hardware/software would I need?
> 2.1) Is an Intel 450Mhz box with 4 processors enough for DB server and
> maybe for
> web server?
> 2.2) What else would I need?
>
> 3) What front-end tools are easiest to learn quickly and most useful
> given my constraints?
> i.e., Java, C, VB, ...
>
> 4) Where can I get help in accomplishing this task? i.e. white papers
> etc...
>
> 5) Would an SMP (Symmetric Multi-Processing) architecture needed here?
>
> 6) What networking issue will I have to contend with?
>
> 7) Will security be a big issue here?
>
> Thanks in advance!
> -Mir
Received on Sat Feb 20 1999 - 14:09:28 CST