Some information is missing from the Ingres entries for the Wikipedia
article 'Comparison of relational database management systems'
(http://tinyurl.com/bnhnu) - specifically from the sections 'Database
capabilities' (http://tinyurl.com/bnhnu) and 'Data types'
(http://tinyurl.com/bnhnu).

With regards to the 'Database capabilities' (http://tinyurl.com/bnhnu)
section, am I correct in thinking Ingres does -not- offer intersect or
except SQL operators? Does Ingres allow 'common table expressions'
(http://en.wikipedia.org/wiki/Common_table_expressions) or 'windowing
functions' (http://tinyurl.com/yatrv46)?

The 'Data types' (http://tinyurl.com/bnhnu) section did not have an
entry for Ingres. I have since added one, but would appreciate if
others could review the information.


--
shusseina

Ingres Forums wrote:

You are correct as of now, but watch that space; they're coming "soon".

Also, while you're tinkering in that area, the latest stable version of
Ingres is shown as 9.3. Considering 9.3 is a bit of a special-purpose
version I wonder if that should really be 9.2?

Nope.

It looks complete to me, except that there is no mention of OME types.

While we're talking about Wikipedia, I've tried starting a discussion
about changing the name of the article currently called "Ingres
(database)" to "Ingres DBMS". Ingres is not a database.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

Ingres Forums wrote:

The 'Ingres (database)'
(http://en.wikipedia.org/wiki/Ingres_%28database%29) article has the
version as 9.2, with the following comment in the code: -"9.3 is a
strange not-quite GA release, so don't mention it here"-. I tend to
think it should be 9.3 (in both articles) as I'm sure the large majority
of new Ingres installations run atop Linux or Windows and hence use 9.3.
What do others think?


section did not have an

Added "User-Defined Data Types (via OME)."


Fair call I guess. It's a pity the article about -Jean Auguste
Dominique Ingres- is not named exactly that or Ingres (French Painter)
or something. Then the article -Ingres (database)- could simply be
Ingres.

Thanks for your feedback Roy.


--
shusseina

Unix flavors (Solaris, HP-UX, AIX) or even VMS.


--
Bodo

Ingres Forums wrote:

It's a conundrum.

New adopters might well opt for the 9.3 server and APIs and get
significant benefit from doing so. But 9.3 is not a supported
upgrade for the large number of existing users, and if they're using
ABF or embedded SQL or Report Writer it's not going to work for them.

I'd be inclined leave the information panel saying 9.2 is the GA
release and maybe add a *short* note somewhere in the article pointing
out that 9.3 is GA but probably not applicable to existing users, with a
link to Pam's wording she posted last week.

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

Bodo;28641 Wrote:
I was referring to -new- Ingres installations. Why would anyone choose
proprietary-UNIX over Linux?


--
shusseina

Or why would anyone choose a proprietary DBMS over Ingres?
It's called "politics" - in most cases it's not the techies
(developers, DBAs, architects) who make these platform decisions.
Often things like existing investments (hardware, other software,
trained staff), "company standards", and golf-court liaisons also come
into play.


--
Bodo

On Nov 17, 2009, at 12:11 AM, Ingres Forums wrote:

Because they have existing hardware that runs the
relevant *ix better than linux; or because they have a
deal with a hardware maker that involves *ix; or
they've run *ix for years in other contexts and
understand it well; or because they want some
particular feature such as ZFS.

I like Linux, don't get me wrong; but I can think of
*lots* of valid reasons to be running Solaris or AIX.
Or (grudgingly) even HP-UX, or VMS. Solaris+VxFS
in particular has been a very strong DBMS platform
for a lot longer than Linux has been large-scale
production viable IMO.

Karl

Karl Schendel;28649 Wrote:
Can't argue with that!

I've set the latest stable version of Ingres to 9.2 in the two
previously mentioned Wikipedia articles and also added a note about
Ingres 9.3.


--
shusseina

On Nov 16, 1:13*pm, Ingres Forums <info-
ing... (AT) kettleriverconsulting (DOT) com> wrote:
Things don't work that way on Wikipedia, Ron is on the right path to
try to change the article's name, and everybodyelse interested should
post their opinion on the article's discussion page.and propose the
solution on the painter's discussion page too, probably. You see that
other DBMSs (http://en.wikipedia.org/wiki/
Database_management_system#Examples) follow no specific patern: some
include the company name, even Oracle is "Oracle Database", and
Sybase is hidden behind marketing buzzwords. No fast track here.