SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Technology Stocks : PSFT - Fiscal 1998 - Discussion for the next year
PSFT 0.00010000.0%Oct 29 5:00 PM EST
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: Jean M. Gauthier who wrote (4064)1/10/1999 1:26:00 AM
From: Dosh!  Read Replies (1) of 4509
 
Jean Gauthier wrote:

"I really, really dislike the architecture of the PeopleSoft product. It calls itself client server, but the reality much worse than this... They use something like Dynamic SQL ..."

"It does NOT use advanced features of a SQL language, which most others use called STORED PROCEDURES."

I am not familiar with the specifics of PeopleSoft products. I do know something about application design - and I have to take issues with your assertion that PeopleSoft products are poorly architected because they use dynamic SQL and not stored procedure.

First of all, I would hardly characterize stored procedure as "advanced feature". It is old fashion technology that has been in used for over 15 years.

Often database admin people (and no doubt database vendors) would prefer application to be written entirely in proprietory stored procedures - but this is often not necessary or desirable from an application design context. Call level interface (and dynamic SQL) is often the better solution given a properly design application architecture. Indeed the modern design trend is to move *away* from pre-compiled store procedure into dynamic multi-tier "business objects" framework.
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  

HomeMailHotSubjectMarksPeopleMarksKeepersSettings
Terms Of UseContact UsCopyright/IP PolicyPrivacy PolicyAbout UsFAQAdvertise on SI
© 2025 Knight Sac Media.  Data provided by Twelve Data, Alpha Vantage, and CityFALCON News