Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Strategy for Web based Oracle application
Niall Litchfield wrote:
> "Rick Denoire" <100.17706_at_germanynet.de> wrote in message
> news:125q10diipsmokr7vp8ek8ahpap1ek55pj_at_4ax.com...
>
>>We have developed a Web based Oracle application consisting of a PHP >>driven GUI, an Apache Web Server, and an Oracle DB. >> >>Quite often, users complain because the Browser won't wait longer than >>30 sec for query results to be returned. The real bad problem is that >>these queries seem to run forever, even when the user closes the >>Browser.
>>Now we decided to redesign the whole thing. Since we lack the >>necessary expertise, we will engage some contractors or a specialized >>company to do the job. The problem still remains that we need to >>define the specifications in order to avoid performance problems and >>any other problems typical for this kind of setup. Specifically, >>security has highest priority, beccause the application will be put on >>the public Internet at some time later. >> >>At this point we are gathering information in order to develop a >>technical concept. Any hint, advice or reference to literature is >>highly appreciated!
I agree but I'd like to add one caveat. Not once have I ever seen a specification written that included the following:
"Must guarantee data integrity if accessed through a tool other than the intended front-end."
Add to the clients specification those attributes, essential to a database system required to protect it, that the clients did not know enough to state in their list of requirements.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Sun Feb 01 2004 - 17:17:02 CST