Friday, March 31, 2006

Stored Procedure as Database Programming Model

I thought the best way to trigger this blog is to discuss the rationales for stored procedures, the obstacles to their adoption, languages used for writing stored procedures, and the $100000 question of proprietary procedural languages such as PL/SQL versus open standards languages such as Java.
http://www.oracle.com/technology/books/pdfs/mensah_ch1.pdf
Enjoy and share your thoughts, Kuassi

13 comments:

Herod T said...

You use what is needed at the time. There is never a single all encompassing language.

If there was, there would be no other languages available.

I have not read the sample chapter, I will do that

Brian said...

For the past nine years I have exclusively used PL/SQL in all my stored procedures. However, we have recently hired some new resources and they are more familiar with Java (based on the fact that they are primarly programmers rather than dba's).

So now I'm considering using both PL/SQL and Java.

Does anyone have thoughts on using a mixed-bag. My main argument for using both is to increase productivity by having multiple resources able to create stored procedures.

Brian - an Oracle DBA

Kuassi Mensah said...

Hi Brian,

Most customers use both PL/SQL and Java. I gave arule of thumb on when to use PL/SQL, when to use Java in the database and when to use Java/J2EE outside the database -- in the first free chapter of my book @ http://books.elsevier.com/bookscat/samples/1555583296/Sample_Chapters/02~chapter_one.pdf

Kuassi

Anonymous said...

Interesting story as for me. I'd like to read more about that matter. Thnx for posting this information.
Sexy Lady
Escort London

vuong said...

お見合い
お見合い
お見合い
お見合い
お見合い
お見合い
お見合い
お見合い
お見合い
お見合い
英会話 横浜
メール 英文
英語塾
社会人入試
toeic
二重埋没法
紙箱
株式会社 設立 
人材紹介会社
東横 賃貸
田園都市 賃貸
デザイナーズ 賃貸
恵比寿 賃貸
学芸大学 賃貸
目黒 賃貸
中目黒 賃貸
新築 賃貸
ペット可 賃貸
三軒茶屋 賃貸
看護師求人
販売管理
債務整理
過払い 新宿
液晶テレビ 激安

abanicos para boda said...

Imágenes impresionantes e información de interés y el blog attractive.This es realmente rock ...
Sí, el mensaje es muy interesante y me gusta realmente.
abanicos para boda

accesorios maquinas de coser said...

Gran artículo, que era muy helpufl! Acabo de empezar en esto y me estoy poniendo a conocerlo mejor! Cheers, mantener el buen trabajo!

find doctor said...

PL/SQL and Jave both language are using in market from last nine years. But Now many other language are in market so now there are good competition.

viagra said...

Wow, nice post,there are many person searching about that now they will find enough resources by your post.Thank you for sharing to us.Please one more post about that..

best naturals said...

Awesome article, I am regular visitor of this website, keep up the good work, and I will be a regular visitor for a very long time.

Unknown said...

You’ve written a really great article here. Your writing style makes this material easy to understand. I agree with some of the many points you have made. Thank you for this is real thought-provoking content.
sleep aid spray

sleep aid supplement

natural sleep aid

Cialis said...

Thanks for sharing this link!

Mobile Concrete Batching Plant said...

These shoes such as MBT shoes , reebok easy tone,shape ups shoes are designed for maximum comfort and help with many things like trimming off the pounds, toning your body, decreasing pain, and more.