Thursday, April 09, 2009

Oracle Discoverer - help people write ugly code :)

There's been a discussion going on among some of my friends about all this horrible-looking (and often badly performing) auto-generated SQL coming out of Discoverer and other tools. Here are some of the comments made during the discussion, and some of my memories of how I got started with Oracle with the help of my good friend Mogens Egan...

=======================

Me:

"Oracle Discoverer - helping developers write ugly code for more than a decade."

=======================

NN:

"no no no!

the real beauty of discoverer (and similar tools) is not that it lets developers write ugly code, but it lets people who don't know what code is (business users), write code and share it with other users who also don't know what code is. It's entire purpose in life is to let people who don't know what they are doing, do it. developers do what they do with some understanding and can, sometimes, be educated. accountants and hr people can't."

=======================

Me:

"This brings me back. From 1987 to 1990 I was in a bank, sharing an office with Mogens Egan (the father of Morten Egan) and basically creating a datawarehouse (although we didn't know it) for internal users in the bank.

Our strategy was this:

1. Every night (or once a week or whatever) we would transfer data from the banks mainframe system via a SNA gateway to our VAX. The data came from IMS databases and was delivered as flat ASCII files (one physical record = one logical record) which often resultet in very very long records, of course, since IMS is hierachical. We would then load it into tables and let the users access it.

2. I would hold one- or two-day courses where I'd teach the attendees (who had probably only used a PC for a very short time) how to log onto the VAX using Smarterm, how to use VMS basic commands (including the editor), how to use SQL and SQL*Plus, how to create default forms in Forms 2.3 - and some other stuff.

3. Mogens Egan's idea was that it was better to turn users/experts (SME's in todays jargon) into "programmers" than vice versa. And then it should be our job to fix run-away jobs (read: SQL that performed bad or messed up things for others).

A rather anarchistic approach, you could say. But man, it worked. In three years we had 1000 users, some of who turned out to be natural super users, who started creating systems that helped their co-workers.

Since they were not officially named super users they couldn't demand to be given time to develop something they thought could be useful - they were by natural selection only allowed to spend time on something their co-workers thought useful.

Mogens and I are still in contact with many of those users. The machine is now an Alpha cluster, the data it manages runs a rather large banks' trading stuff, and all that - but its name is still Samson. And the super user we created back then is still called Supermule, which is the Danish name for Super Goof. With the introduction of English-speaking consultants in the last 10 years it has proved a minor mistake - they all ask "What's a super mule?"

So yes, we had many incidents of run-away jobs where the poor user had issued a SQL statement without the proper where-clause, etc. But then we would discover it, kill it, help the user - and all of the victims of this bad SQL knew it could be their turn one day, so they didn't get mad or upset.

That playground which we created back then generated a lot of Oracle-lovers who are still around in various higher positions, and perhaps it would have been even easier for them back then if we had had Discoverer.

So I think you're absolutely right: Discoverer will help computer-illeterates write really bad code even faster. But at least it gets them to use Oracle, and it creates wonderful problems that finances our fantastic lifestyles.

Mogens

PS: In the World as a whole, I think Discoverer had a presence (penetration) of about 2% of customers. In Denmark it was 20% due to my ex-wife Laila (Nathalie's mother), then product sales rep for Discoverer, who insisted that every single customer should have this product, like it or not. And notice how well Miracle is doing here. Perhaps there's a relationship."

===================================

39 Comments:

Anonymous CarlosAL said...

>>""This brings me back. From 1987 to 1990..."

>>"The data came from IMS databases and was delivered as flat ASCII files (one physical record = one logical record) which often resultet in very very long records, of course, since IMS is hierachical. We would then load it into tables and let the users access it."

Man! 1990? I'm doing something like that right now. And the data source guys never heard something about 'data integrity', 'data consistency', 'referential integrity' and they barely know that there are things called 'Normal Forms'.

Cheers.

Carlos.

1:45 AM  
Anonymous Webmaster said...

Hi

For leveraging traffic from the internet, I have manually collected a list of quality blogs with whom I am interested in getting associated.

I liked your blog and i'm interested in having my blog's text link in your blog roll.

Please let me know your interest in this association and then we can move towards next step.

Sincerely,

Webmaster
Adamsinfo.com
seo@apnicsolutions.com

5:13 AM  
Anonymous Anonymous said...

I was able to get my ex back after I followed the instructions at www.saveabreakup.com I totally recommend this site, saveabreakup.com helped me a lot, all I can say is big THANKS!!! I'm so happy now...

12:31 AM  
Anonymous How To Win Back An Ex Girlfriend From A New Boyfriend said...

I agree with CarlosAL, I am still doing that on 2010!

4:41 PM  
Anonymous how to win back your ex girlfriend from another man said...

I agree with CarlosAL, I am still doing that on 2010!

4:46 PM  
Anonymous sap project system said...

Interesting post. After reading your experience I also remembered my time when I started learning Oracle. I still remember the day when I first joined a crash course to learn basics. The very first time I made a query that was a total crap. Now the day has come that I am working as a DBA.

3:57 AM  
Anonymous sap project system said...

Interesting post. After reading your experience I also remembered my time when I started learning Oracle. I still remember the day when I first joined a crash course to learn basics. The very first time I made a query that was a total crap. Now the day has come that I am working as a DBA.

3:58 AM  
Anonymous ambersbridal said...

Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which we all need, thanks for all the enthusiasm to offer such helpful information here.Never bigger surprise out of that Amber’s wedding dresses 2012. We are dedicated to maintain the golden balance between quality and prices of our products tea length wedding dresses. Please feel free to contact us in case of any detailed information on your desired objects. Customer and service, our first and foremost.

7:58 PM  
Blogger Unknown said...

A tree’s leaves may be ever so good.So may its bark, so may its wood;
But unless you put the right thing to its root.It never will hidh81ke show much flower or fruit.
Wholesale New Era Hats
Cheap 59fifty Hats
Cheap New Era Hats
New Era Snapback Hats
New Era Fitted Hats

6:58 PM  
Anonymous price per head online said...

Very informative and helpful. This is a nice information shared here. Keep Posting :)

7:34 PM  
Anonymous hormone doctors said...

Thanks for your suggestion. I really appreciate that you took all this time to try and help us. Keep up the good work. Keep on taking action.

4:20 AM  
Anonymous http://www.vitiligonatural.com/ said...

It is good No you are not good… but you are great and this post is all about your greatness.

9:39 PM  
Anonymous hospiceadvantage said...

I recommend you use this station.I hope I can see you. Meeting people.

6:45 PM  
Anonymous bizznus said...

I truly enjoy reading through your blogs. Would you suggest some other blogs

8:36 PM  
Anonymous http://www.tipcosmetic.com/Lipstick/ said...

Excellent quality, reasonable price, fast delivery…there is everything that you expect to find.

10:05 PM  
Anonymous http://www.all-home-remedies.com/home-remedies-obesity.html said...

There is no doubt that here coach factory outlet is the exact place you should visit.

11:12 PM  
Anonymous jailbreakstation said...

fgfh is informative, interesting and very well written. keep up the nice high quality writing

4:41 AM  
Anonymous stage hire said...

is informative, interesting and very well written. keep up the nice high quality writing

6:10 AM  
Anonymous islam-australia.com said...

very is informative, interesting and very well written. keep up the nice high quality writing

6:56 AM  
Anonymous scissorsart.com Cute Styles for Short Hair said...

asw very is informative, interesting and very well written. keep up the nice high quality writing

8:14 PM  
Anonymous plagarize said...

ghtyj asw very is informative, interesting and very well written. keep up the nice high quality writing

7:36 PM  
Anonymous HP Acer Toshiba Dell Mac Sony IBM firstshop said...

fgt thyutry ghtyj asw very is informative, interesting and very well written. keep up the nice high quality writing

8:16 PM  
Anonymous Selena Gomez hairstyles said...

found some quite interesting articles on finance with lot of information. I would be really thankful.

4:50 AM  
Blogger petersmith said...

That was a great article! I like it very much. Keep posting like this.

regards
Pawn Gold

11:05 PM  
Blogger Sell Breitling Watch said...

Great article.I like your thoughts and it's really great.Great discussion.Thanks for sharing.

Sell Breitling Navitimer

5:24 AM  
Blogger Unknown said...

qihang0604true religion sale
christian louboutin outlet
kate spade uk
michael kors
tory burch outlet
chanel outlet
coach outlet
michael kors handbags
replica watches
michael kors handbag
tory burch outlet online
ray ban sunglasses
cheap jerseys
kate spade outlet online
ray ban uk
oakley sunglasses wholesale
fitflops outlet
coach outlet
prada outlet
air max 95
cheap oakley sunglasses
burberry sale
ray ban sunglasses
michael kors outlet online
kate spade
oakley sunglasses
q

7:45 PM  
Blogger Unknown said...

15711meiqing
red christian louboutin
michael kors handbags
louis vuitton outlet
hollister jeans
hollister clothing store
chanel uk
gucci outlet online
cheap jerseys
cheap nfl jerseys
burberry handbags
coach outlet
coach outlet
jordan 13
coach outlet store online
timberland pro
christian louboutin outlet
cheap lululemon
louis vuitton
abercrombie & fitch new york
burberry outlet
jeremy scott adidas
michael kors outlet
cheap jerseys
louis vuitton handbags
hermes birkin
mulberry handbags
burberry outlet
cheap air max
cheap oakley sunglasses
jordan retro 3
toms outlet
michael kors handbags
tory burch outlet online
toms shoes
ralph lauren polo shirts
toms outlet
michael kors handbags
red timberland boots
tods outlet
coach outlet online

6:55 AM  
Blogger حاتم النجار said...

شركة نقل عفش بالاحساء
شركة نقل عفش بالقطيف

7:59 AM  
Blogger te12 said...

qzz0727
giuseppe zanotti sneakers
yeezy shoes
oakley sunglasses wholesale
air jordan uk
off white jordan 1
canada goose jackets
coach factory outlet
longchamp handbags
louboutin shoes
longchamp outlet

2:04 AM  
Anonymous Obat Pelancar haid said...

This article is interesting and useful. Thank you for sharing. And let me share an article about health that God willing will be very useful. Thank you :)


Cara Menghilangkan Bopeng Bekas Jerawat
Cara Membersihkan flek di Paru-paru
Cara Menyembuhkan Nyeri Punggung
Pengobatan Alami menyembuhkan Sangkadi
Cara Menghilangkan Bekas luka
Cara Cepat Mengatasi Iritasi Kulit

1:12 AM  
Anonymous Oscar Fernandez said...

Lovely blog to visit. I really love to visit your blog. Thank you

3:11 AM  
Blogger Unknown said...

We provide all major photo editing service such as background removal, image masking service, clipping path service, vehicle photo editing service, image shadow service, ecommerce photo editing service etc

9:48 PM  
Blogger Unknown said...

Great blog with it's name, great stuffs with great blog,Thanks.





Photo Retouching Services

10:49 PM  
Blogger Robertrrowwww said...

Met behulp van PayPal kunt u uw transacties binnen enkele minuten afronden. PayPal heeft een gebruiksvriendelijke gebruikersinterface die iedereen prettig zal vinden tijdens het gebruik van de geldovermakingsdiensten. Het enige dat nodig is, zijn enkele klikken en de geldoverdracht gebeurt in een paar minuten.PayPal Bellen

4:36 AM  
Blogger Link Doozer said...

I have read this article today & I find it very Interesting that the information you have provided via this blog is just unmatchable to anyone & no one can write such article unless & until it you.

seo company in Jaipur

3:29 AM  
Blogger Michanel jims said...

Thanks for sharing this valuable and understanding article with us.Finding Best SEO Company in surat then plusply digital is offering the best SEO Services in surat for your business website or Online Marketing.

9:11 PM  
Anonymous Anonymous said...

golden goose
lebron shoes
hermes outlet
kobe byrant shoes
bape outlet
moncler jackets
retro jordans
alexander mcqueen shoes
off white
bape hoodie

8:39 PM  
Anonymous Competitor Analysis Tools said...

Competitor Analysis Tools

Locobuzz is one of the best and trending competitor analysis tools in the market.

This tool analyzes competitors to find the most relevant keyword for your business as well as the primary keyword that your competition is using.

11:15 PM  
Anonymous worldfashiontips said...

World Fashion Tips - Best Beauty Fashion and Style Tips Blog

All, Apps, Automobile, Automotive, Beauty Tips, Blog, Business, Celebrity, Digital Marketing, Education, Entertainment, Fashion, Finance, Food, Games, Health, Home Improvement, Lifestyle, News, Real Estate, Social Media Marketing, Software, Sports, Technology, Travel, Website.

4:25 AM  

Post a Comment

<< Home