From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=unavailable autolearn_force=no version=3.4.4 Path: eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!news.eternal-september.org!mx02.eternal-september.org!feeder.eternal-september.org!gandalf.srv.welterde.de!news.jacob-sparre.dk!loke.jacob-sparre.dk!pnx.dk!.POSTED!not-for-mail From: "Randy Brukardt" Newsgroups: comp.lang.ada Subject: Re: GNAT GPL is not shareware Date: Fri, 9 Jan 2015 16:07:25 -0600 Organization: Jacob Sparre Andersen Research & Innovation Message-ID: References: <87bnmetex4.fsf@ludovic-brenta.org> <87lhlirpk0.fsf@ludovic-brenta.org> <79f3eff7-2b45-40ae-af94-fa9a17426d82@googlegroups.com> <87bnmd8mg2.fsf@ixod.org> <19cf9bc2-f8b9-4735-b427-7b070dda59da@googlegroups.com> <1otenmcbgnvlt$.dn9361nl2jm8$.dlg@40tude.net> NNTP-Posting-Host: rrsoftware.com X-Trace: loke.gir.dk 1420841246 5238 24.196.82.226 (9 Jan 2015 22:07:26 GMT) X-Complaints-To: news@jacob-sparre.dk NNTP-Posting-Date: Fri, 9 Jan 2015 22:07:26 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-RFC2646: Format=Flowed; Response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157 Xref: news.eternal-september.org comp.lang.ada:24512 Date: 2015-01-09T16:07:25-06:00 List-Id: "Shark8" wrote in message news:U%Xrw.246026$pr4.26650@fx26.iad... > On 09-Jan-15 14:33, Randy Brukardt wrote: >> I haven't any clue as to what you are talking about. Visiblity >> information >> is tree-structured, and it is not possible to map trees sensibly into the >> flat tables required by relational technology. Doing so distorts the >> problem >> (as Dmitry notes). > > It actually is possible to store a tree structure in a "flat table" -- > see recursive queries. -- > http://en.wikipedia.org/wiki/Hierarchical_and_recursive_queries_in_SQL Of course it's possible -- it's just unnatural. The reason Ada now has a tree container is directly because of that -- while you can map a tree into a flat structure, you have to do some sort of encoding to do so. It's better to directly have the structure. (Now, if someone wanted to promulagate an "everything is a tree" strategy and algebra, I'd be interested, because there are very few problems that aren't a tree of some sort.) Randy.