Thread: Separate PK in Jxn Tbl?
View Single Post
  #110  
Old January 27th, 2008, 11:24 PM posted to comp.databases.ms-access,comp.databases.theory,microsoft.public.access,microsoft.public.access.tablesdbdesign,microsoft.public.sqlserver,comp.databases.theory
Bob Badour
external usenet poster
  
Posts: 38
Default Separate PK in Jxn Tbl?
David Cressey wrote:

"Sylvain Lafontaine" sylvain aei ca (fill the blanks, no spam please)
wrote in message ...

This remind me of the discussion twenty five years ago between relational
databases (like SQL-Server) and non-relational databases (like ISAM
databases, dBase, etc.). It has always been right to say that for simple
queries, non-relational databases are faster than relational databases.
However, nowadays, non-relational databases have (practically) vanished
because of their inherent slowness when the queries become more and more
complicated.



I don't believe the above is correct. It's still the case that a graph
based DBMS
like IMS can otperform an SQL based DBMS for queries that were anticipated
at the time the graph was designed. This is not a function of the
complexity of the query.

I, of course, disagree. A graph based dbms has no performance advantage
over a relational dbms because a relational dbms may use exactly the
same physical structures.

[snip]