Results 1 to 9 of 9

Thread: Database Query Languages

  1. #1
    Registered+ Zathras's Avatar
    Join Date
    Jul 2003
    Location
    Canary Wharf/Richmond
    Posts
    1,454
    Thanks
    13
    Thanked
    7 times in 4 posts

    Database Query Languages

    Hi

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

    Cheers

  2. #2
    Senior Member
    Join Date
    Oct 2003
    Posts
    2,069
    Thanks
    4
    Thanked
    7 times in 3 posts
    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).
    Twigman

  3. #3
    Registered+ Zathras's Avatar
    Join Date
    Jul 2003
    Location
    Canary Wharf/Richmond
    Posts
    1,454
    Thanks
    13
    Thanked
    7 times in 4 posts
    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.

  4. #4
    Senior Member Shad's Avatar
    Join Date
    Jul 2003
    Location
    In front
    Posts
    2,779
    Thanks
    23
    Thanked
    42 times in 25 posts
    You can use ADO to manipulate data, not sure if i'd call it a query language as such though.
    Simon


  5. #5
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts
    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
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

  6. #6
    Put him in the curry! Rythmic's Avatar
    Join Date
    Jul 2003
    Location
    Twyford, Berks
    Posts
    758
    Thanks
    1
    Thanked
    0 times in 0 posts
    Or you could wait for MS's Yukon to come out - you can (apparently) write your stored procedures in any .NET language.
    Now go away before I taunt you a second time.

  7. #7
    Goat Boy
    Join Date
    Jul 2003
    Location
    Alexandra Park, London
    Posts
    2,428
    Thanks
    0
    Thanked
    0 times in 0 posts
    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.
    "All our beliefs are being challenged now, and rightfully so, they're stupid." - Bill Hicks

  8. #8
    DsW
    DsW is offline
    Senior Member
    Join Date
    Aug 2003
    Location
    Glasgow
    Posts
    292
    Thanks
    0
    Thanked
    0 times in 0 posts
    The only others I can think of are

    SQLJ (which translates to SQL anyway)

    XQuery / XQJ

    JDOQL

    OQL

    cheers,
    dave

  9. #9
    Put him in the curry! Rythmic's Avatar
    Join Date
    Jul 2003
    Location
    Twyford, Berks
    Posts
    758
    Thanks
    1
    Thanked
    0 times in 0 posts
    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.
    Now go away before I taunt you a second time.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •