You are here: Re: Relationships error, C# Visual Studio 2005 database bug?, "the columns in table XYZ do not match an existing primary key or UNIQUE constraint", copying columns « MsSQL Server « IT news, forums, messages
Re: Relationships error, C# Visual Studio 2005 database bug?, "the columns in table XYZ do not match an existing primary key or UNIQUE constraint", copying columns

Posted by Gert-Jan Strik on 07/15/07 12:27

raylopez99 wrote: [snip]
> > > I think SQL
> > > is a dinosaur language and should be scraped
> >
> > I agree that SQL is well overdue for replacement. Unfortunately it
> > can't happen overnight.
> >
> > > RDBMS are obsolete
> > > in view of cheap memory, faster processors, and managed pointers, but
> > > that's another matter.
> >
> > That's not a coherent line of reasoning at all. An RDBMS implements a
> > logical model of data that is independent of the hardware used. If
> > processors and memory are faster and cheaper then that makes RDBMS
> > faster and cheaper too. What do you propose as an alternative?
> >
>
> Pointers indexing, using CAM and a Hash Table, one big, fat, flat
> file. THe old way of doing things before IBM researcher E.M. Codd
> proposed RDBMS in 1970.
[snip]

It is a known fact that for some applications the (current?) RDBMS is
not the optimal technology. In areas such as text search and scientific
applications (which require confidence percentages) other techniques are
significantly faster, even a few orders of magnitude faster. So
development in these areas is to be expected, and I am looking forward
to that wave of innovation.

On the other hand, an RDBMS is very good in the field of transactions
and as a generic nonspecific technology. For many fields of use the
RDBMS is and will be the most efficient solution. It is nowhere near
obsolete and is unlikely to be obsolete for at least another decade.

Gert-Jan

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация