Is there a summary of what Vectorwise actually is ; how it works ;
How it appears to the user how it is called ; is it seamless ; can one
copydb out/in etc. etc. somewhere?

Something that can be read and made sense of in less than 30mins to an
individual (me?) who thinks he is 90% aware of what classical Ingres
means.
is it as simple as Karl says "............Longer term, the IVW and
traditional Ingres code lines will be ............"
(it should be)

thanks Allan




Karl Schendel <schendel (AT) kbcomputer (DOT) com>
Sent by: info-ingres-bounces (AT) kettleriver...ting (DOT) com
18/02/2011 14:23
Please respond to
Ingres and related product discussion forum
<info-ingres (AT) kettleriverconsulting (DOT) com>


To
Ingres and related product discussion forum
<info-ingres (AT) kettleriverconsulting (DOT) com>
cc

Subject
Re: [Info-Ingres] Ingres Splinter Group?







On Feb 18, 2011, at 7:38 AM, Jean_Auguste_Dominique Ingres wrote:

I wasn't going to address this one, but I guess I will after all: if any
customers are deeply concerned, they shouldn't be. Traditional
Ingres is neither dead, nor moribund, nor end-of-lifed, nor even
in a bug-fix-only status. Right now, the 10.0 product is in the
entirely capable hands of Sustaining (aka Level 2), while others
focus on getting Ingres VectorWise 1.5 stable and out the door.
L2 are certainly able to do enhancements and development,
and indeed I saw a couple new features go into main just this week.

Longer term, the IVW and traditional Ingres code lines will be
merged (I'm in fact working on preparations for that now), and
I expect that we'll see some of the enhancements that were planned
for a 10.x version since they benefit both IVW and traditional Ingres.

So, concern is perhaps understandable, but unnecessary.

Karl



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


This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean

http://www.DuPont.com/corp/email_disclaimer.html

On Feb 18, 2011, at 9:51 AM, Allan Biggs wrote:

There may be one somewhere, but I can't be arsed to find it, so
here's the short version.

You can think of Vectorwise as a replacement for QEF+DMF.
It's a storage engine and query execution facility.

The query goes through Ingres pretty much as normal, except
that the optimizer generates a VW query plan instead of
the traditional Ingres one. The VW engine can do a few
things that QEF can't, like anti-joins, and can't do one or
two things that QEF can, like SEjoins; so there are some
differences in the details. But basically, a VW plan is
conceptually similar to a QEF plan, just different in
details. (one difference is that the VW plan is actually a
text query in an easy-to-parse algebra that the VW
server understands, and can further optimize in engine
specific ways.)

To the rest of Ingres, and to the user, Vectorwise is just a different
storage structure. COPY works, so all the utilities based on it work.
There are a few things that VW doesn't do at this stage,
such as partitioning or journaling, so it's not 100% seamless
but it's pretty close. VW tables are recorded in the Ingres
catalogs just like Ingres tables.

Right now, the Vectorwise product is using a separate Ingres
code line, but that's basically an artifact of doing IVW
R&D at the same time as the bulk of the Ingres 10 effort.
Using a separate code line allowed the IVW work to be
streamlined, and kept the two projects from breaking each
other. There's a price to pay now in merging, but it's not
an exorbitant price. We have been pretty good about feeding
bug fixes back and forth, so the two lines are fairly close
as far as all the non-IVW bits go.

Karl

Allan Biggs wrote:

The Getting Started Guide is a pretty good place to start. It gives
some kind of answer to all those questions. You might want to go deeper
in places but it will get you to the point of running code.

Calling VW is identical to calling Ingres. No difference at all. If
you installed it as a peer installation you need to do the usual change
of environment stuff that you do to call any peer Ingres installation.

Yes you can copy in and copy out. You can even CREATE AS SELECT...WITH
STRUCTURE=VECTORWISE to move data from classic Ingres tables to
VectorWise tables.

You know what? Just think of VectorWise as another table structure,
like B-tree or hash, and you won't go far wrong. Obviously there is a
lot more to it than that and the comparison does break down, but it'll
get your well on the way.

I've blogged about some of this, which may help:
http://community.ingres.com/forum/blogs/rhann

Pretty much, yes. If you've ever installed Ingres, the procedure is
pretty much identical. There are some configuration settings that you
can adjust that aren't quite in the Ingres idiom yet, but they're
documented in the Getting Started Guide if you need them and the
defaults work fine to get started.

It's been a while since I installed it for the first time but I seem to
recall that from download to first query was about 30 minutes, including
reading the Getting Started Guide from cover to cover.

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7 2011.
Put the date in your diary today.

Thanks Roy & Karl - that makes it all a bit clearer.

Allan



Roy Hann <specially (AT) processed (DOT) almost.meat>
Sent by: info-ingres-bounces (AT) kettleriver...ting (DOT) com
18/02/2011 15:24
Please respond to
Ingres and related product discussion forum
<info-ingres (AT) kettleriverconsulting (DOT) com>


To
info-ingres (AT) kettleriverconsulting (DOT) com
cc

Subject
Re: [Info-Ingres] Vectorwise - Ingres Splinter Group?






Allan Biggs wrote:

The Getting Started Guide is a pretty good place to start. It gives
some kind of answer to all those questions. You might want to go deeper
in places but it will get you to the point of running code.

Calling VW is identical to calling Ingres. No difference at all. If
you installed it as a peer installation you need to do the usual change
of environment stuff that you do to call any peer Ingres installation.

Yes you can copy in and copy out. You can even CREATE AS SELECT...WITH
STRUCTURE=VECTORWISE to move data from classic Ingres tables to
VectorWise tables.

You know what? Just think of VectorWise as another table structure,
like B-tree or hash, and you won't go far wrong. Obviously there is a
lot more to it than that and the comparison does break down, but it'll
get your well on the way.

I've blogged about some of this, which may help:
http://community.ingres.com/forum/blogs/rhann

Pretty much, yes. If you've ever installed Ingres, the procedure is
pretty much identical. There are some configuration settings that you
can adjust that aren't quite in the Ingres idiom yet, but they're
documented in the Getting Started Guide if you need them and the
defaults work fine to get started.

It's been a while since I installed it for the first time but I seem to
recall that from download to first query was about 30 minutes, including
reading the Getting Started Guide from cover to cover.

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7 2011.
Put the date in your diary today.


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


This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.

Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean

http://www.DuPont.com/corp/email_disclaimer.html