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=ham 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!news2.google.com!proxad.net!newsfeed.stueberl.de!news-mue1.dfn.de!news-ham1.dfn.de!news.uni-hamburg.de!cs.tu-berlin.de!uni-duisburg.de!not-for-mail From: Georg Bauhaus Newsgroups: comp.lang.ada Subject: Re: Windows Ada database support. Date: Mon, 29 Nov 2004 22:05:50 +0000 (UTC) Organization: GMUGHDU Message-ID: References: <5e3e03a7.0411240431.7e037a4e@posting.google.com> <2004112420030750073%david@bottoncom> <17w0jtt2xq2ya.1nj2623n37457.dlg@40tude.net> <1ohmhrsp481iu.w61dt6dz9cqk$.dlg@40tude.net> NNTP-Posting-Host: l1-hrz.uni-duisburg.de X-Trace: a1-hrz.uni-duisburg.de 1101765950 13748 134.91.1.34 (29 Nov 2004 22:05:50 GMT) X-Complaints-To: usenet@news.uni-duisburg.de NNTP-Posting-Date: Mon, 29 Nov 2004 22:05:50 +0000 (UTC) User-Agent: tin/1.5.8-20010221 ("Blue Water") (UNIX) (HP-UX/B.11.00 (9000/800)) Xref: g2news1.google.com comp.lang.ada:6656 Date: 2004-11-29T22:05:50+00:00 List-Id: Dmitry A. Kazakov wrote: : On Mon, 29 Nov 2004 14:07:45 +0000 (UTC), Georg Bauhaus wrote: :> This is interfacing to "world", not to some abstraction. : Which only supports the point that cursor might be wrong abstraction. Aha. Cursors are not an abstraction from the point of view of an Ada program. SQL Cursors are a given part of the "world", in this case, the data base system. Go argue with Oracle Corp. :> See also Frank Piron's comment about implicit cursors in :> PL/SQL. Wrong abstractions in PL/SQL too? :>: So what? As long as my application uses Ada.Database, I do not care. Is this a motto? :> Thick abstractions leave some choices behind. This isn't always helpful. : Surely, but statistically irrelevant. Aha. But allow me to say, as much as I'd wish to be able to use a nice transparent, almost invisible interface to database system, I see no base in reality for saying that abstraction thickness is statistically irrelevant. For several reasons, and also because - cursors do occur, no matter whether you express them behind Ada abstractions or not. Working with snapshots affects performance/ shared resources to the point where you can no longer hide them relying on some AI system to free the resources automatically so the system keeps running. Working with RDBMSs means to have influence on another program's multiply shared data in soft real time! However, your program doesn't control that other program, your program must be well-behaved. Show me how to do this in some Ada.Databases. - saying that performance/resources in database systems are statistically irrelevant makes me think that your perspective on DBs is different from mine, and probably not just mine ;-) : Otherwise we would have no Ada and still were programming in assembly. What has Ada versus Assembly got to do with resource consumption of communicating programs (Ada program <-> database program?) Other than trying a rhetorical trick to support a notion of statistical irrelevance of SQL cursors in RDBMS? ;-) -- Georg Bauhaus