Re: Application logic and Business logic

From: Jeff Brooks (jeff_brooks_at_nospam.com)
Date: 03/20/05


Date: Sun, 20 Mar 2005 18:37:40 GMT

frebe wrote:

> > How do you explain Object Databases that provide query languages?
>
> In this case (ODMG OQL), we are talking about a hybrid
> object-relational query language and not about a network-OO query
> language. OQL is heavily based on SQL and relational calculus
> (selection, projection, joins, etc). Saying that SQL and OQL is
> different is just to play with words. If class=table and object=record,
> you will find that OQL=SQL.
>
> Databases that provides OQL is just a layer on top of a relational
> database. It would be impossible for a network (OO) database to execute
> OQL queries faster than linear time.

Do you think Oracle is a relational database?

Jeff Brooks



Relevant Pages

  • Re: Application logic and Business logic
    ... OQL is heavily based on relational calculus. ... The only real difference between SQL and your OO query languages is ...
    (comp.object)
  • Re: Object-relational mapping tool
    ... > Languages like OQL are a complete mess and horribly complex, ... the problem of binding SQL result sets to in-memory objects. ...
    (comp.object)
  • Re: Mixing linq to sql and linq to xml (in linqpad)
    ... I would like to filter my xml data, when it contains a item attribute ... ....except that neither of these work if "myTable" is an actual SQL table, because LINQ to SQL can't handle XML methods. ... you could factor out the XML selection logic to the database. ... The obvious drawback to this method is that you need to carefully work out your data needs in advance as far as the SQL selection is concerned. ...
    (microsoft.public.dotnet.languages.csharp)
  • How to make a numbering field to a field selection in SQL?
    ... I have a table in my database, from which I SELECT some fields. ... Is there any function in SQL, which can add an artificial field for numbering my records to the result of the selection? ...
    (microsoft.public.data.ado)
  • An artificial field for numbering records.
    ... I have a table in my database, from which I SELECT some fields. ... Is there any function in SQL, which can add an artificial field for numbering my records to the result of the selection? ...
    (microsoft.public.sqlserver.programming)