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

23 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

Ayisha said...

these are gifts for everyone
Knowledge
Collection of books
Kitaben
Kitab ghar
Books and references
Liberary
booksshelf
Computer Science Reference Books
Rapidshare ebooks
Free collection of ebooks
Free Ebooks

wow power leveling said...

This momentousdecree warcraft leveling came as a great beacon light wow lvl of hope to millions of negroslaves wow power level who had been seared power leveling in the flames of power leveling withering wrath of the lich king power leveling injustice.wrath of the lich king power leveling it came as a WOTLK Power Leveling joyous daybreak to end the long WOTLK Power Leveling night ofcaptivity.WOTLK Power Leveling but one hundred years wlk power leveling later, we must face aoc gold the tragic fact thatthe age of conan power leveling negro is still not free. aoc power leveling one hundred years later,age of conan power leveling the lifeof the negro ffxi gil is still sadly crippled by the final fantasy xi gil manacles ofsegregation guild wars gold and the chains of discrimination. one hundred yearslater, maplestory mesos the negro lives on a lonely island of poverty in themidst of a vast ocean of material prosperity.dog clothes one hundred yearslater

Anonymous said...

童裝批發
童裝批發
童裝
童裝
酒店喝酒
酒店消費
暑假打工
寒假打工
酒店經紀人
酒店現領
禮服店
酒店小姐
酒店兼職
酒店上班
酒店兼職
禮服店
酒店上班
酒店打工
酒店小姐
酒店經紀
酒店兼差
假日打工
台北酒店經紀
寒暑假打工
專業酒店經紀
酒店藝名
台北酒店
酒店日保
酒店入行
台北禮服店
酒店類型
酒店午場
酒店規定
酒店行政
酒店資訊

123 123 said...

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

Edwin said...

Buy Kamagra
Earn Google
Viagra Cialis
Cheap Kamagra
Cheap Viagra
Cheap Cialis
Make Money on Google
M65 Jacket
M65 Field Jacket
Airline Dog Carrier
Airline Dog Carriers
Viagra Cialis
Earn Google
Airline Dog Carrier
Airline Dog Carriers
Airline Approved Dog Carriers
ED Hardy Wholesale
Copy DVD Software
How to Send Fax
14k Yellow Gold
Redneck Costume
14k Gold Heart
Tandem Baby Stroller

VUONG said...

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

VUONG said...

先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
先物 比較
事業再生
経営計画書
経営改革
経営改善
会社分割
経営コンサルティング
婚活 東京
婚活 東京
婚活 東京
婚活 東京
婚活 東京
婚活 東京
婚活 東京
婚活 東京
婚活 東京
婚活 東京
浮気調査 浅草
浮気調査 市川
備考調査 追跡調査 東京
不倫調査 離婚調査 東京
浮気調査 素行調査 東京 
ストーカー相談 ストーカー対策 東京
結婚調査 結婚詐欺 東京
信用調査 企業調査 東京
調査料金 東京
身上調査 身元調査 身辺調査 東京
所在調査 東京
夫 妻 浮気 東京

my blog said...

I love your blog very much,and i also want to introduce my products to all of you,them are nice and very fashion,if you like them,please contact us on our

website or eamil us,thks very much for your attention.And this is my products below:
authentic gucci bags, gucci boots outlet
cheap gucci shoes, discount Gucci bags
newest gucci handbags, gucci handbags 2010
Juicy couture, authentic Juicy bags
Juicy handbags outlet, tiffany 2010
Tiffany, tiffany outlet
discount tiffany charms, cheap tiffany Bangles
Armani watches outlet, watch wholesale
discount DG watches, cheap Chanel watches
newest GUCCI watches, discount ghds
ghd outlet, ghd
cheap ghd, ghd straighteners
wholesale edhardy t shirt, Moncler
Moncler jackets, cheap Moncler coats
Moncler Vest, Moncler outlet
moncler polo t shirt, MBT boots
MBT shoes in fashion, cheap mbt shoes sale
discount mbt outlet 2010, MBT Walking Shoes
Mtb shoes,Moncler
Moncler jackets,Moncler coats
Moncler Vest,Moncler outlet
discount moncler Tshirt

ylinling001 said...

MBT shoes are the perfect solution if you are on your feet all day long and need a good shoes. 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.

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

Anonymous said...

cheap chanel handbags
imitation bags
replica marc jacobss
coach imitation
imitation prada
imitation gucci
replica chloe bags

Anonymous said...

cheap chanel handbags
imitation bags
replica marc jacobss
coach imitation
imitation prada
imitation gucci
replica chloe bags

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..

nike free run 2 said...

Nike Free 3.0 womens shoes sale,
Nike Free Run plus 2 2011 style shoes
Nike free run plus shoe for sale,
Nike free run womens cheap on sale,
Cheap Nike free run shoes Australia,
Nike free run shoes Australia collection,
Nike free 2011 style shoes.

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.

sahib 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.