Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help Setup & Programming of Web-based DB

Help Setup & Programming of Web-based DB

From: Mir <mqader_at_students.wisc.edu>
Date: Thu, 18 Feb 1999 19:37:38 -0600
Message-ID: <36CCC062.1D01@students.wisc.edu>


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 Thu Feb 18 1999 - 19:37:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US