Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.r-kom.de!fu-berlin.de!uni-berlin.de!not-for-mail From: Christopher Browne Newsgroups: comp.databases.theory Subject: Re: Building the virtual OTLT Date: 9 Sep 2004 17:52:32 GMT Organization: cbbrowne Computing Inc Lines: 19 Message-ID: <2qbjj0Fte7usU1@uni-berlin.de> References: <986dndg5yt7Hwt3cRVn-sg@comcast.com> X-Trace: news.uni-berlin.de 5k+yMkO5XRDy6Yz2ovY/yANLYjkI4LklSpEREQQ5AEZXzFfqDT X-Draft-From: ("nntp+wolfe:comp.databases.theory" 8833) X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne Xref: dp-news.maxwell.syr.edu comp.databases.theory:25890 The world rejoiced as "Laconic2" wrote: > So the virtual OTLT can be a useful tool, even though it illustrates bad > data management. Well, this strikes me as being the fashion in which "OTLT" can be considered to 'turn out well.' What's interesting is that you _didn't_ fudge things up by creating a way to insert bad data. Within the realm of "updatable views," this isn't likely to be able to be anywhere _near_ "automatically updatable," particularly if many of the tables it references contain additional fields (e.g. - updated_on or created_on or such). There's a place for text search, and this is it. -- output = reverse("gro.gultn" "@" "enworbbc") http://www3.sympatico.ca/cbbrowne/nonrdbms.html "A hack is a terrible thing to waste, please give to the implementation of your choice..." -- GJC