Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.media.kyoto-u.ac.jp!newsfeed.gamma.ru!Gamma.RU!postnews.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!bcklog1.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail NNTP-Posting-Date: Fri, 07 Jul 2006 14:44:50 -0500 Message-Id: From: Kenneth Downs Subject: Re: SQL for presentation Newsgroups: comp.databases.theory Date: Fri, 07 Jul 2006 15:41:25 -0400 References: <1152092596.708768.93300@p79g2000cwp.googlegroups.com> <5lssn3-elk.ln1@pluto.downsfam.net> <1152128214.284972.139280@v61g2000cwv.googlegroups.com> <8qltn3-r7o.ln1@pluto.downsfam.net> <1152133627.276151.280940@v61g2000cwv.googlegroups.com> <1152185382.952814.109340@b68g2000cwa.googlegroups.com> Organization: Secure Data Software, Inc. User-Agent: KNode/0.9.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit Lines: 40 X-Trace: sv3-4N9a74wXcWMMB0ixDClOTC56KYYQ2VlEyaY/qCuqrZmOX1ch3we50xCRlsYjYKhltW2nOPSf38TM8nA!vsBzEhqat8OlzzGaD5vnV32qWYk+Vx7ihFW09My+tpXa7+cxwdhub0C8Gg== X-Complaints-To: abuse@giganews.com X-DMCA-Notifications: http://www.giganews.com/info/dmca.html X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.theory:43172 frebe73@gmail.com wrote: > > The starting data could be an employee table. > employee(employeeid, firstname, lastname) > With the content > employee(1, "Donald", "Duck") > employee(2, "Kit", "Walker") > > The end-point might be tuples describing the html page. > > html(1, "Employee list", 100) > element(100, 1, null) > element(101, 1, 100) > table(101, 1) > element(102, 1, 101) > tr(102) > element(104, 1, 102) > td(104, "Donald") > element(105, 1, 102) > td(105, "Duck") > element(103, 1, 101) > tr(103) > element(104, 1, 102) > td(104, "Kit") > element(105, 1, 102) > td(105, "Walker") > > The result tuples would if possible be obtained by a view (or something > similar using any declarative relational language). In practical terms I'm not sure what the benefit of this is. If we can get from the two employee rows to the HTML itself, why introduce an intermediate step? -- Kenneth Downs Secure Data Software, Inc. (Ken)nneth@(Sec)ure(Dat)a(.com)