Path: news.easynews.com!core-easynews!newsfeed3.easynews.com!easynews.com!easynews!news.glorb.com!newsgate.cistron.nl!news.tele.dk!news.tele.dk!small.news.tele.dk!news100.image.dk!news000.worldonline.dk.POSTED!not-for-mail From: "Peter Koch Larsen" Newsgroups: comp.databases.theory References: <3638acfd.0407050029.5424e360@posting.google.com> Subject: Re: Is it possible to build a purely relational database on top of SQL? Lines: 44 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Message-ID: Date: Wed, 7 Jul 2004 17:21:58 +0200 NNTP-Posting-Host: 62.79.147.244 X-Complaints-To: news-abuse@wol.dk X-Trace: news000.worldonline.dk 1089213717 62.79.147.244 (Wed, 07 Jul 2004 17:21:57 MET DST) NNTP-Posting-Date: Wed, 07 Jul 2004 17:21:57 MET DST Organization: Customer of Tiscali A/S Xref: core-easynews comp.databases.theory:36667 X-Received-Date: Wed, 07 Jul 2004 08:21:06 MST (news.easynews.com) Hi Leandro As you see, I get lots of weird characters. Perhaps you should consider using a simple codepage when responding in english? "Leandro Guimaraens Faria Corsetti Dutra" skrev i en meddelelse news:pan.2004.07.05.23.17.04.217302@dutra.fastmail.fm... > Em Mon, 05 Jul 2004 15:58:32 +0200, Peter Koch Larsen escreveu: > > > How far has Alphora come in terms of conformance with D? > > As far as I know it is totally conformant, only not > implementing some extras like hierarchies of types – they did, but in I would like an explanation what – means ;-) > the version 2 βs decided it was not the right thing to do. > > > > And if they are > > 100% conformant, do they allow SQL access to the same data? > > It’s up to the SysAdmins to block the SQL server behind a > Dataphor installation. But it even provides an SQL lookalike, > RealSQL, to avoid the need to. I am naturally talking in terms of migration here... if you would transfer a project from some SQL-dialect to Alphoras language (D4?), then surely it must be important with a high degree of SQL compliance? > > > > I believe it could give some problems querying a database with user > > defined datatypes in it > > I don’t see why. > Well.... if the relation uses some polymorph type - say SHAPE to use a TTM example - and the actual type is say a polygon with houndreds of vertices, then how will the data be represented to the SQL user? /Peter