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=-2.9 required=5.0 tests=BAYES_00,FREEMAIL_FROM, MAILING_LIST_MULTI autolearn=unavailable autolearn_force=no version=3.4.4 X-Google-Thread: 103376,bf02c238a92156a3 X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news1.google.com!proxad.net!usenet-fr.net!enst.fr!melchior!cuivre.fr.eu.org!melchior.frmug.org!not-for-mail From: Marius Amado Alves Newsgroups: comp.lang.ada Subject: Re: Windows Ada database support. Date: Mon, 29 Nov 2004 15:58:52 +0000 Organization: Cuivre, Argent, Or Message-ID: References: <5e3e03a7.0411240431.7e037a4e@posting.google.com> <2004112420030750073%david@bottoncom> NNTP-Posting-Host: lovelace.ada-france.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: melchior.cuivre.fr.eu.org 1101743925 72072 212.85.156.195 (29 Nov 2004 15:58:45 GMT) X-Complaints-To: usenet@melchior.cuivre.fr.eu.org NNTP-Posting-Date: Mon, 29 Nov 2004 15:58:45 +0000 (UTC) To: comp.lang.ada@ada-france.org Return-Path: User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en In-Reply-To: X-OriginalArrivalTime: 29 Nov 2004 15:58:07.0825 (UTC) FILETIME=[37EAB410:01C4D62C] X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at ada-france.org X-BeenThere: comp.lang.ada@ada-france.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: "Gateway to the comp.lang.ada Usenet newsgroup" List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Xref: g2news1.google.com comp.lang.ada:6640 Date: 2004-11-29T15:58:52+00:00 Frank Piron wrote: > Base Predicates(Tables): Person(x,s), Parent(x,y) |(s = sex) > Show all Fathers: > > LQL: > Father(x):=E(y)[Person(x,s) and > s='MALE' and > Parent(x,y) > ] > > SQL: > select Person.x > from Person, Parent > where Person.s='MALE' and > Person.x = Parent.x (inner join for the E-Quantifier) In Mneson you would represent the parent, or child, relation simply as an attribute of a person, and then write something like targets (Person) ^ having (s, MALE) ^ having_any (child) For robust validation of query languages I found two data sets: - the ones included in XQuery published by w3c.org - the benchmarks published by tpc.org Maybe there are others; I'd like to know.