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

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

40 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  
Blogger cc22 said...

情趣用品,情趣,
角色扮演,吊帶襪,丁字褲,飛機杯,
按摩棒,跳蛋,G點,
自慰套,
情趣內衣,
情趣,情趣用品,
SM,G點,按摩棒,
飛機杯,充氣娃娃,
自慰套,情趣用具,

2:24 AM  
Blogger Jorce said...

wholesale moncler clothing
cheap moncler jackets
moncler ski apparel
Moncler ski jacketsg
Moncler down jackets
Moncler Men Jackets
Moncler Women's Jackets
Moncler kids clothing
Moncler vest on sale
Manolo Blahnik Pumps
Manolo Blahnik Sandals
Manolo Blahnik Slingbacks
Manolo Blahnik d'Orsays
Yves Saint Laurent Shoes
Christian Louboutin Ankle Boots

12:11 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  
Blogger 梦敏 said...

Microsoft Office 2010
Office 2010
Microsoft Office 2007
Office 2007
Microsoft Office
Office 2007 key
Office 2007 download
Office 2007 Professional
Microsoft outlook
Microsoft outlook 2010

2:41 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  
Blogger WANG said...

nike running shoes
The Power Balance bracelet is made of pure surgical grade silicone that is extremely durable. Its stretch feature optimizes users' comfort level. It comes equipped with two, visible power balance holograms and this sporty and stylish bracelet goes with everything.

Specification:

Silicone Power Balance Wristband Bracelet
The band made of 100% silicone rubber
With 2 visible hologram disks for balance power,waterproof.


Except for this product,customers are eager to shop for:
Silly Bands
Reebok Easytone
reebok zigtech
efx bracelet

11:10 PM  
Blogger pandorasell said...

Clip flees and this Chrismas costs buy pandora jewelery coming near. Surprise! Most belated cheap pandora jewelery at Discount Price I plan to explore the net because an allow Christmas gift discount pandora jewelery .In the online search appendage, I unexpectedly read a rattling occupying pandora bracelets and unbelievable story, and I hence besides chose pandora silver bracelets blimey Christmas Day empowers.A-list gross revenue from colligates from london sweetheart cheap pandora bracelets Decades ago in London, a small restaurant enjoyed good business concern and attacted a lot returned discount pandora bracelets buyers.called for to express thanks to these pandora bracelets sale ,

8:35 AM  
Blogger power balance said...

Performance Technology power balance wholesale designed to work with your body's.Contain two Mylar Hologram's power balance wristbands which are embedded with frequencies that react

12:49 AM  
Blogger 2011bagnews said...

cheap sunglasses Polarized is shieldscxy combining UV protection and glare reduction for more fun on the water. It is always said that these sun glares minimize and control wholesale sunglasses ultraviolet rays to get into your eyes. It completely protects your eyes from dust, dirt and harmful rays and also discount sunglasses from insects.Polarized sunglasses are nothing but photo adidas sunglasses chromatic shields which tries to avoid harmful and harsh substances to eliminate cebe sunglasses before entering the eyes. It increases your visibility power. People often say that do not look at the sun directly. Cocoons Sunglasses It hampers your visibility. Cocoons Sunglasses Indirectly, when sun rays reflect on water surface, it may enter your eyes carrera sunglasses and can prove dangerous. When rays reflect on a smooth surface, it reflects back horizontally.
The cost of these maui jim sunglasses polarized is affordable. These sunglasses may range from a price of twenty eight dollars to two hundred and seventy four dollars. cheap oakley sunglasses The more polarized sunglasses may cost higher. You may find these glares online or at your nearest local malls and retail stores.You may find these in various colors as well. These Oakley polarized sunglasses are found attached with discount oakley sunglasses many other accessories. These sunglasses are available with straps also. These polarized glares are in complete vogue. You can also wear these on any kind of sport events.

11:59 PM  
Anonymous Anonymous said...

Counter Depth French Door Refrigerator
How to Get Into Acting
Breville Smart Oven
How to Impress Woman
Picking Lottery Numbers
Canon Powershot A800
Adidas Barricade
Adidas Barricade 6.0
Cuisinart TOB-195
Acne Conglobata
Acer 11.6 Netbook
500 payday loan
acne inversa
VIZIO M261VP
checkmate payday loans
Pengurusan Masa
Counter Depth French Door Refrigerator
How to Get Into Acting
Breville Smart Oven
How to Impress Woman
Picking Lottery Numbers
Canon Powershot A800
Adidas Barricade 6.0
Cuisinart TOB-195
Acne Conglobata
Acer 11.6 Netbook
500 payday loan
acne inversa
VIZIO M261VP
checkmate payday loans
Pengurusan Masa

7:32 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  
Blogger carrera sunglasses said...

Be that a conventional pbngtwq occasion venturing out Oakley Sunglasses Cheap to meet litigant or to wait a achieving Half X Oakley or you might be moving from a weekend Oakley Sunglasses Discount or even a holiday package deal to loosen up Sale Oakley Sunglasses on marine beaches or perhaps drive extended Oakley Jawbone stays to have a great time and satisfaction wholesale Oakley Stpl Jawbone for guys offer every type of Half X. The components used are usually of good quality and are usually durable, rough and also tough merely matching the necessity of a person. The from suppliers sun spectacles Oakley Sunglasses Outlet just easily blend with all the requirement regarding men and also trend which is followed.

4:33 AM  
Anonymous Anonymous said...

Sometimes a useful house sale is needed. If you have a dilemma with debt and will want cash fast UGG Boots, then it's time to begin the process a fasthouse sale. There comes a time if you realize that your debts don't just disappear if you dismiss them. Instead it is better tofind a method to pay them back. Most people have a very important asset. Their home is valuable and it's one and only thing they can sellto get money to settle their debts. You can end your credit card debt problem by performing a house sale. Let us repay the money you owe by providing the money you may need. Itcan be difficult so that you can admit that you have trouble with debt. People do not prefer to say they have forfeited control. A quick house sale process often is the end of your monetary problems. We are experts in property and we are able to buy your home- swift thomas sabo jewellery! Not only can we offer speed but we could also guarantee a fair rate. We buy directly without necessity for estate agentsor middlemen get entangled. What this means to you personally is a fast house sale process cheap supra shoes, with a direct cash sale that they are completed inapproximately four weeks. If you want an easy house sale to launch UGG Boots Sale, then you may just want to complete the deal swiftly. Alternatively UGG Boots Outlet, you can delay theprocess. We fit the process on your schedule! The quick sale with house ensures privacy in addition to discretion thomas sabo sale, nobody will know aboutthe deal UGG Sale, unless you tell individuals. If you arrange a rapid property sale links of london outlet, you can return that will financial control. From jerseys, The Team at My house Sell jerseys sale!

12:25 AM  
Blogger riftplat said...

buy wow gold
cheap wow gold

12:01 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 qinbincai123 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  
Blogger Alis Stafford said...

Thanks for your marvelous posting! I enjoyed reading it. I really feel as though I know so much more about this than I did before. Your blog really brought some things to light that I never would have thought about before reading it.
Show Plates

7:19 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 tata sifra said...

http://bmwpaydayloans.com

3:54 AM  
Blogger zaza said...

http://bmwpaydayloans.com

12:31 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 GuildWars2Items said...

The consequences of today are determined by the actions of the past scarlet blade gold. To change your future, alter your decisions today scarlet blade gold, Experience is a hard teacher because she gives the test first, the lesson afterwards scarlet blade gold, but it takes character to keep you there.
You laugh at me for being different, but I laugh at you for being the same RuneScape Gold, The consequences of today are determined by the actions of the past RS Gold, experience is a hard teacher because she gives the RS GP test first, the lesson afterwards.

1:15 AM  

Post a Comment

Links to this post:

Create a Link

<< Home