Database Query Languages

[Zathras]

Hi

Can anyone give me a list of database query languages (mainly relational databases rather than oo) other than the obvious SQL.

Cheers

[Twigman]

Is this because you are interested, or because you want to try something else or what?
SQL is very good, and should do exactly what you need it do do (if you know it well enough).

[Zathras]

A friend (no not me, I wasn't stupid enough to choose it!) has to write a piece on comparing SQL with other RDB query languages.

[Shad]

You can use ADO to manipulate data, not sure if i'd call it a query language as such though.

[DaBeeeenster]

The only other way I know of querying an RDBMS is via OLAP. Maybe google that.

Personally, I think that essay question is one of the most pointless I have ever seen! It's a bit like asking someone to compare methods of steering cars, other than via the steering wheel.

Oh, yet again wikipedia to the rescue.

http://en2.wikipedia.org/wiki/OLAP

[Rythmic]

Or you could wait for MS's Yukon to come out - you can (apparently) write your stored procedures in any .NET language.

[DaBeeeenster]

Originally posted by Rythmic
Or you could wait for MS's Yukon to come out - you can (apparently) write your stored procedures in any .NET language.

I would guess that the method of querying the database would remain the same though, I.e. SQL. I think Yukon will allow you to use .net as the scripting element of the prodedures.

[DsW]

The only others I can think of are

SQLJ (which translates to SQL anyway)

XQuery / XQJ

JDOQL

OQL

cheers,
dave

[Rythmic]

Yeah - from what I've heard you still have to query Yukon in T-SQL - though it seems they've improved the language a lot (recursive queries for one).

Got to admit I've never heard of the other langauges wilkied mentioned - but then I don't do much work outside MS enviroments.