dbTalk Databases Forums  

RE: [Info-ingres] Re: UK IUA agenda?

comp.databases.ingres comp.databases.ingres


Discuss RE: [Info-ingres] Re: UK IUA agenda? in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Richard
 
Posts: n/a

Default RE: [Info-ingres] Re: UK IUA agenda? - 09-14-2005 , 07:49 AM






Quote:
-----Original Message-----
From: Roy Hann [mailto:specially (AT) processed (DOT) almost.meat]
Sent: 14 September 2005 11:11
To: info-ingres (AT) cariboulake (DOT) com
Subject: [Info-ingres] Re: UK IUA agenda?

snip

And Marty Bowes is doing one too, on the Pitfalls of Rollforwarddb. That
should be a real barn-burner!

Roy
I can see the headlines now:- "Ingres Guru accused of arson flees country"

déjà vu?

************************************************** **********************
DISCLAIMER
The information contained in this e-mail is confidential and is intended
for the recipient only.
If you have received it in error, please notify us immediately by reply
e-mail and then delete it from your system. Please do not copy it or
use it for any other purposes, or disclose the content of the e-mail
to any other person or store or copy the information in any medium.
The views contained in this e-mail are those of the author and not
necessarily those of Admenta UK Group.
************************************************** **********************



Reply With Quote
  #2  
Old   
Roy Hann
 
Posts: n/a

Default Re: [Info-ingres] Re: UK IUA agenda? - 09-14-2005 , 08:07 AM






"David Richard" <Richard.David (AT) aah (DOT) co.uk> wrote

Quote:
I can see the headlines now:- "Ingres Guru accused of arson flees country"

déjà vu?
Déjà vu, all over again.

R.







Reply With Quote
  #3  
Old   
Gibson Jonathan
 
Posts: n/a

Default RE: [Info-ingres] Re: UK IUA agenda? - 09-14-2005 , 08:22 AM



I think the headline should probably read

"Ingres Guru wallows in Ashes!"

-----Original Message-----
From: info-ingres-admin (AT) cariboulake (DOT) com [mailto:info-ingres-admin (AT) cariboulake (DOT) com] On Behalf Of David Richard
Sent: 14 September 2005 13:50
To: info-ingres (AT) cariboulake (DOT) com
Subject: RE: [Info-ingres] Re: UK IUA agenda?
Importance: High



Quote:
>-----Original Message-----
>From: Roy Hann [mailto:specially (AT) processed (DOT) almost.meat]
>Sent: 14 September 2005 11:11
>To: info-ingres (AT) cariboulake (DOT) com
>Subject: [Info-ingres] Re: UK IUA agenda?

> snip

>And Marty Bowes is doing one too, on the Pitfalls of Rollforwarddb. That should be a real barn-burner!

>Roy
I can see the headlines now:- "Ingres Guru accused of arson flees country"
déjà vu?

************************************************** **********************
DISCLAIMER

The information contained in this e-mail is confidential and is intended
for the recipient only.

If you have received it in error, please notify us immediately by reply

e-mail and then delete it from your system. Please do not copy it or

use it for any other purposes, or disclose the content of the e-mail

to any other person or store or copy the information in any medium.

The views contained in this e-mail are those of the author and not

necessarily those of Admenta UK Group.

************************************************** **********************

__________________________________________________ ___________________
This message has been checked for all known viruses by bluesource. For further information visit www.blue-source.com

powered by Messagelabs




************************************************** ********************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. No one else is authorised to distribute, forward,
print, copy or act upon any information contained in this email.
If you have received this email in error, please notify the sender.

Hiscox Syndicates Limited, Hiscox Insurance Company Limited, Hiscox
Connect Limited, Hiscox Underwriting Limited and Hiscox Investment Management Limited are authorised and regulated by the Financial
Services Authority. Hiscox plc is a company registered in England
and Wales under company registration number 2837811 and registered
office at 1 Great St Helen's, London EC3A 6HX
************************************************** ********************


__________________________________________________ ___________________
This message has been checked for all known viruses by blue-source. For further information visit www.blue-source.com

powered by Messagelabs


Reply With Quote
  #4  
Old   
Roy Hann
 
Posts: n/a

Default Re: [Info-ingres] Re: UK IUA agenda? - 09-14-2005 , 09:04 AM



"Gibson Jonathan" <Jonathan.Gibson (AT) hiscox (DOT) com> wrote

Quote:
I think the headline should probably read

"Ingres Guru wallows in Ashes!"
I don't think Marty is a follower of cricket. Not even the ladies team.

Roy




Reply With Quote
  #5  
Old   
martin.bowes@ctsu.ox.ac.uk
 
Posts: n/a

Default Re: [Info-ingres] Re: UK IUA agenda? - 09-19-2005 , 04:03 AM



On 14 Sep 2005 at 15:04, Roy Hann wrote:

Quote:
"Gibson Jonathan" <Jonathan.Gibson (AT) hiscox (DOT) com> wrote in message
news:mailman.1126704182.21273.info-ingres (AT) cariboulake (DOT) com...
I think the headline should probably read

"Ingres Guru wallows in Ashes!"

I don't think Marty is a follower of cricket.
Actually, I am a follower, and like the rest of Oz I have gone
into a period of mourning, reflection and denial.

Not even the ladies
Quote:
team.
I like it when they bowl maidens over.

Quote:
Roy
Marty


Reply With Quote
  #6  
Old   
martin.bowes@ctsu.ox.ac.uk
 
Posts: n/a

Default Re: [Info-ingres] Re: UK IUA agenda? - 09-19-2005 , 04:22 AM



Hi Roy,

Idle! How can a father of three such darling children be idle?
Quote:
Title: Handling User-Defined Data

Abstract: We frequently encounter the need to extend the database
design and applications to include so-called user-defined data.
Changes and improvements to business processes depend on having some
additional details that were not anticipated in the original design.
Sometimes entire new entities must be added. Or sometimes truly
massive new extensions to the database must be allowed on an almost ad
hoc basis. In this paper I describe some of the details of these
problems, and one frequently proposed solution (the
entity-attribute-value design, or EAV). I then describe a much
simpler, more flexible, and powerful solution the exploits the
intrinsic capabilities of a relational DBMS like Ingres.
Sounds good, I've just started looking at the OME to make user
functions - the user data stuff looked way to scary.
Quote:
I may be doing another presentation too, but I haven't been told what
it is yet. ;-)
Sounds like a married man. You know your wrong, its only a
matter of waiting to be told exactly how your wrong.

These days, mine just whacks me over the nose with a rolled
up newspaper and says NO in a firm loud voice.
Quote:
And Marty Bowes is doing one too, on the Pitfalls of Rollforwarddb.
That should be a real barn-burner!
Is that 'Barn Burning' in a good sense, or 'Barn Burning' as in
"We're Screwed!"?

I suppose as long as the Scots don't recind the treaty of Union
and start launching cross border raids to burn barns, we'll consider it a
good thing.

Marty


Reply With Quote
  #7  
Old   
Roy Hann
 
Posts: n/a

Default Re: [Info-ingres] Re: UK IUA agenda? - 09-19-2005 , 05:14 AM



<martin.bowes (AT) ctsu (DOT) ox.ac.uk> wrote


Quote:
Idle! How can a father of three such darling children be idle?
Don't be oily. It doesn't suit you.

Quote:
I then describe a much
simpler, more flexible, and powerful solution the exploits the
intrinsic capabilities of a relational DBMS like Ingres.

Sounds good, I've just started looking at the OME to make user
functions - the user data stuff looked way to scary.
OME is a whole different (and very important) kettle of fish. Ingres needs
"an" OME, just not the one it's got. The current one is unusable for a
variety of reasons--and you've pointed out one. (See "Domains, and Why we
Need Them", presented by Tony Douglas and me at the 2003 Autumn UKIUA.)

I have some hope that the "complex type" support that is often mentioned as
being one of the reasons for collaborating with JBoss will give us something
better. I have no idea if that is going anywhere, nor where to look to find
out.

But my presentation next month is much more down-to-earth. It assumes only
the usual 1950s era data types that standard SQL provides. I don't even
call for the BLOb types.

Quote:
I may be doing another presentation too, but I haven't been told what
it is yet. ;-)

Sounds like a married man. You know your wrong, its only a
matter of waiting to be told exactly how your wrong.

These days, mine just whacks me over the nose with a rolled
up newspaper and says NO in a firm loud voice.
It must work, because I've walked around your flat without mishap.

Roy




Reply With Quote
  #8  
Old   
Michael Leo
 
Posts: n/a

Default Re: [Info-ingres] Re: UK IUA agenda? - 09-19-2005 , 08:34 AM



Roy Hann wrote:

Quote:
[clip]

OME is a whole different (and very important) kettle of fish. Ingres needs
"an" OME, just not the one it's got. The current one is unusable for a
variety of reasons--and you've pointed out one. (See "Domains, and Why we
Need Them", presented by Tony Douglas and me at the 2003 Autumn UKIUA.)

I have some hope that the "complex type" support that is often mentioned as
being one of the reasons for collaborating with JBoss will give us something
better. I have no idea if that is going anywhere, nor where to look to find
out.

But my presentation next month is much more down-to-earth. It assumes only
the usual 1950s era data types that standard SQL provides. I don't even
call for the BLOb types.



Oh ... I'm going to get roasted for this ....

We REALLY need SQLJ extensions for Ingres. This would allow

- much safer and easier OME functionality
- stored procs written in a REAL language

Sybase and Oracle both fully support SQLJ. It isn't perfect, but it is
better than
using something like OME which is essentially user-written C code
running in the
server! Think about one bad pointer writing into the DMF cache ...

Mike Leo
Caribou Lake LLC




Reply With Quote
  #9  
Old   
Roy Hann
 
Posts: n/a

Default Re: [Info-ingres] Re: UK IUA agenda? - 09-19-2005 , 09:16 AM



"Michael Leo" <mleo (AT) cariboulake (DOT) com> wrote

Quote:
Oh ... I'm going to get roasted for this ....
What makes you think that? Am I *so* unreasonable? :-) Or perhaps you were
thinking of Tony; yes, there you may get an argument.

Quote:
We REALLY need SQLJ extensions for Ingres. This would allow

- much safer and easier OME functionality
You'll have to explain how SQLJ helps. I mean it. Can you give us a quick
capsule summary of it? I have only the sketchiest idea what it does, and no
idea at all how it would help here.

Quote:
- stored procs written in a REAL language
Only as real as C#. And I would object violently to C#. I am not sure why
I shouldn't react equally vigorously to Java. Lee Fesperman's excellent
work notwithstanding, I am not persuaded that Java is the ideal language for
just defining types, which is all that is necessary. Java may be the least
bad of the widely-known languages (and then again maybe it isn't).

One of these days maybe we can get Tony to make the case for the ML family
of languages...

Quote:
Sybase and Oracle both fully support SQLJ. It isn't perfect, but it is
better than
using something like OME which is essentially user-written C code
running in the
server! Think about one bad pointer writing into the DMF cache ...
That's just one of the more serious problems. Ditto infinite looping. And
what about portability between platforms? Forget it.

Roy




Reply With Quote
  #10  
Old   
martin.bowes@ctsu.ox.ac.uk
 
Posts: n/a

Default Re: [Info-ingres] Re: UK IUA agenda? - 09-20-2005 , 07:36 AM



Hi Roy, Mike et al
Quote:
"Michael Leo" <mleo (AT) cariboulake (DOT) com> wrote in message
news:mailman.1127136901.26101.info-ingres (AT) cariboulake (DOT) com...
Oh ... I'm going to get roasted for this ....

What makes you think that? Am I *so* unreasonable? :-) Or perhaps you
were thinking of Tony; yes, there you may get an argument.

We REALLY need SQLJ extensions for Ingres. This would allow
- much safer and easier OME functionality

You'll have to explain how SQLJ helps. I mean it. Can you give us a
quick capsule summary of it? I have only the sketchiest idea what it
does, and no idea at all how it would help here.
That makes two of us.

I'm all for safety by encapsulating the user changes, but I'm at
a loss to see how this could be done. But I'm not that smart. I just read
the OME manual and took the comment about thoroughly testing the
code on a test installation before installing on a production box *VERY*
seriously.

Another point would be - are we jumping at shadows. Hands up
everyone who has actually found a need for a UDT. I would bet the
answer is very, very few people. I think the '1950s datatypes' as
Rampaging Roy Hann calls them will satisfy the vast majority of us.

As a guess - and pure guesswork on this - I suspect that user
defined functions would be more common. I think an improved version
of soundex, or an equivalent function has been mentioned by a few.
Ditto a regex function - which is what I'm currently tinkering my way
towards. Hey, I havent even made a function that returns the integer 5
yet. I'm not a good programmer, that's why I went into DBA.

As an aside - are people tackling this sort of extended
functionality in OpenSource?
Quote:
Martin Bowes.

--
Random Duckman Quote #102:
Cornfed: Uh Oh.
Duckman: 'Uh Oh' as in 'Nice Work?'
Cornfed: No, as in 'You're screwed.'



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.