Hi All,

I seem to recall some discussion somewhere where the possibility of an SQL call to do optimizedb was mooted.

Does anyone have any details...know of anyone looking at this?

Martin Bowes

Hi Marty,

We looked into the practicalities of this to tie in with automatic
system management potential. We prototyped a simple, automatic
invocation but there were issues relating to load management and locking
that flawed this. At the time this was a very hot must have but since
then priorities have shifted a bit.

My preferred approach now is to move the optimisedb processing into
system generated/maintained DBprocs that could be executed by the dbms
internally when necessary or on demand via an OPTIMISE TABLE command.
This approach needs some features in DBprocs that we don't have yet -
namely ARRAYs. I had hoped to Sprint the latter but got sidetracked by
what people were asking for.

Regards,

Ian



From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
Martin Bowes
Sent: 10 June 2011 11:47
To: Ingres and related product discussion forum
Subject: [Info-Ingres] optimizedb as an SQL call



Hi All,



I seem to recall some discussion somewhere where the possibility of an
SQL call to do optimizedb was mooted.



Does anyone have any details...know of anyone looking at this?



Martin Bowes

On Jun 10, 11:47*am, Martin Bowes <martin.bo... (AT) ctsu (DOT) ox.ac.uk> wrote:
I posted this on c.d.i. approx. 1.5 years ago:-
https://groups.google.com/group/comp...487df4 f6b5d2

Like you, I wish for many things to be added to Ingres, and like you I
keep getting fobbed off with excuses or incoherent replies at user
groups! *sigh*

Maybe Santa will bring us what we wish for this Christmas?

rthdavid wrote:

[snip]

That's a bit harsh. I know you didn't hear anyone say "we'll do that",
but I thought I heard Bill say he had another idea in mind, that would
obviate the need for the feature you were requesting. If he was a bit
light on detail, it *was* in a brain-storming session, against the
clock, and the ideas were coming thick and fast, with no forewarning.

Furthmore Teresa King was getting it all down in writing to include in
the wiki, so we've got a place to flesh out the concept and to develop
some coherence.

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7 2011.
Register at http://www.regonline.co.uk/ukiua2011

Ian Kirkham wrote:

Is that arrays as a DBP feature, or arrays as a column type
available to use in SQL tables too?

If it's the latter then I'd love to see lists as well. OME has had an
example list implementation for some time that is really quite cool, but
no one will agree to run it in production.

If it's arrays in DBPs, I'd want to hear more before I got on board
with the idea. I'd like to see "created" temporary tables or even
DBP-local declared temporary tables (after all, they are supposed to
be global to a module; there is no reason why a DBP can't be a module
if a session can be a module). Is it the ability to index into arrays
that is attractive?

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7 2011.
Register at http://www.regonline.co.uk/ukiua2011

We're about to launch a customer questionnaire to capture levels of
interest in various features such as partition management, spatial,
cloud etc. Following Tuesday's IUA, I've updated it to include
functional areas such as STAR. I'm happy to share the voting results.
Cheers
Emma


-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Roy
Hann
Sent: Friday, June 10, 2011 7:22 AM
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] optimizedb as an SQL call

rthdavid wrote:

[snip]

That's a bit harsh. I know you didn't hear anyone say "we'll do that",
but I thought I heard Bill say he had another idea in mind, that would
obviate the need for the feature you were requesting. If he was a bit
light on detail, it *was* in a brain-storming session, against the
clock, and the ideas were coming thick and fast, with no forewarning.

Furthmore Teresa King was getting it all down in writing to include in
the wiki, so we've got a place to flesh out the concept and to develop
some coherence.

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7
2011.
Register at http://www.regonline.co.uk/ukiua2011


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

On Jun 10, 12:22*pm, Roy Hann <specia... (AT) processed (DOT) almost.meat> wrote:
I was trying to be funny and maybe a little ironic; but I suppose I
could have chosen kinder words!

Let's be honest, the whole DAR/Enhancement request mechanism is a bit
of a running joke amongst Ingresers.
I think that I've only seen 3 enhancements (no doubt shared with
others) see the light of day in any Ingres release.
And one of those, partitioning, is not as full featured as it should
be.

But I like the idea of compiling and publishing a list ('the list'?)
of enhancement requests on the Community Wiki. Let's see how it goes.

STAR ... can it be true? I knew my singing would get a result!

As they say...Its the squeaky wheel that gets the grease!

I can perform a Tom Jones medly if required. We might even be able to get a singalong to Delilah at the next conference. Geraint Jones has already expressed an interest.

Marty

PS. I think it would be nice for the Code Sprint results to be available as well.
-----Original Message-----
From: Emma K. McGrattan [mailto:Emma.McGrattan (AT) ingres (DOT) com]
Sent: 10 June 2011 14:06
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] optimizedb as an SQL call

We're about to launch a customer questionnaire to capture levels of
interest in various features such as partition management, spatial,
cloud etc. Following Tuesday's IUA, I've updated it to include
functional areas such as STAR. I'm happy to share the voting results.
Cheers
Emma


-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Roy
Hann
Sent: Friday, June 10, 2011 7:22 AM
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] optimizedb as an SQL call

rthdavid wrote:

[snip]

That's a bit harsh. I know you didn't hear anyone say "we'll do that",
but I thought I heard Bill say he had another idea in mind, that would
obviate the need for the feature you were requesting. If he was a bit
light on detail, it *was* in a brain-storming session, against the
clock, and the ideas were coming thick and fast, with no forewarning.

Furthmore Teresa King was getting it all down in writing to include in
the wiki, so we've got a place to flesh out the concept and to develop
some coherence.

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7
2011.
Register at http://www.regonline.co.uk/ukiua2011


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Last weekend a bunch of Ingres employees, from various parts of the organization, got together with members of the Ingres & OpenROAD community to work together, through the weekend, on a variety of projects. This was our fifth code sprint and I continue to be amazed at how much can be achieved over the course of a weekend. The below is a list of the DBMS and Tools projects that we attacked which are at various stages of completion:

II_GCD_LOG support for %p - the process id
alterdb -readonly | - readwrite
IMA object for query execution start time
Session start time and last recorded query start time displayed in IIMONITOR
relocateckp - restore a checkpoint to another database, potentially in another Ingres installation
infodb -database - display a list of databases
Ability to turn on SC924 via config.dat and to switch on a stackdump when it is triggered
Audit log maintenance script to prevent disk full problems
Row constructors
Multi-row inserts
Fixed bug in QSF memory allocation for INGRES/STAR
Project D branch updated
Terminal Monitor formatting enhancements
New views to easily access keys
Support for DECODE(), REPEAT(), REPLICATE(), RAND() and SRAND() functions
Addition of 60 Nagios Service Checks for VectorWise added o the Nagios Agent
New management toolset now ported to Mac OSX and 64-bit RHEL

Sincerest thanks to all our sprint participants
Ingres DBMS
Alex Hanshaw
Chris Dawe
Dean Vernon
Doug Inkster
Emma McGrattan
Geraint Jones
Henrik Sørensen
Ian Kirkham
James Lowden
Karl Schendel
Keith Bolam
Roy Hann

Management Tools
Oliver Oyston
Roger Whitcomb
Mark Whalley

OpenROAD
Bodo Bergman
Brigitte Duplenne
Kim Ginnerup
Joe Kronk
Matt Rendell
Roy Deal Simon
Oliver Oyston

Cheers

Emma
Emma McGrattan
SVP Engineering
Ingres Corporation
emma.mcgrattan (AT) ingres (DOT) com

MOBILE +1 631 704 2932



www.ingres.com

This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.

Marty wrote:
... in selling earplugs. I expect it to prove very lucrative. G


--
geraintjones