RetroBBS - comp.databases.theory - Inventory of the Ignorance Chasm

Re: [ [Relational] Database] Open Architecture Standard

<a87b589e-d0dd-437b-b7f9-6cd22703bd5cn@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=133&group=comp.databases.theory#133

copy link Newsgroups: comp.databases.theory

X-Received: by 2002:a05:622a:147:: with SMTP id v7mr5121892qtw.246.1624249703225;
Sun, 20 Jun 2021 21:28:23 -0700 (PDT)
X-Received: by 2002:a05:6808:aa1:: with SMTP id r1mr14065063oij.157.1624249702975;
Sun, 20 Jun 2021 21:28:22 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.theory
Date: Sun, 20 Jun 2021 21:28:22 -0700 (PDT)
In-Reply-To: <e4d87662-ac71-42e9-ba3d-2049291b493ao@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=199.229.250.143; posting-account=bFMNewoAAAAHC6b_JPlV7XvI31zIuG5T
NNTP-Posting-Host: 199.229.250.143
References: <38b1153b-435d-4660-b1ec-1a4f0dff0395o@googlegroups.com> <e4d87662-ac71-42e9-ba3d-2049291b493ao@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a87b589e-d0dd-437b-b7f9-6cd22703bd5cn@googlegroups.com>
Subject: Re: [ [Relational] Database] Open Architecture Standard
From: derek.asirvadem@gmail.com (Derek Ignatius Asirvadem)
Injection-Date: Mon, 21 Jun 2021 04:28:23 +0000
Content-Type: text/plain; charset="UTF-8"

by: Derek Ignatius Asirv - Mon, 21 Jun 2021 04:28 UTC

The following thread is relevant to this one.
__ https://groups.google.com/g/comp.databases.theory/c/LSoYp9wrv0M

Cheers
Derek

Inventory of the Ignorance Chasm

<16e517ff-82fc-427f-b71a-4f81ce89d424n@googlegroups.com>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=136&group=comp.databases.theory#136

copy link Newsgroups: comp.databases.theory

X-Received: by 2002:a37:6851:: with SMTP id d78mr1033231qkc.483.1624315405377; Mon, 21 Jun 2021 15:43:25 -0700 (PDT)
X-Received: by 2002:a05:6808:6d1:: with SMTP id m17mr581526oih.34.1624315405078; Mon, 21 Jun 2021 15:43:25 -0700 (PDT)
Path: i2pn2.org!i2pn.org!aioe.org!news.uzoreto.com!tr2.eu1.usenetexpress.com!feeder.usenetexpress.com!tr1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.theory
Date: Mon, 21 Jun 2021 15:43:24 -0700 (PDT)
In-Reply-To: <a87b589e-d0dd-437b-b7f9-6cd22703bd5cn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=199.229.250.34; posting-account=bFMNewoAAAAHC6b_JPlV7XvI31zIuG5T
NNTP-Posting-Host: 199.229.250.34
References: <38b1153b-435d-4660-b1ec-1a4f0dff0395o@googlegroups.com> <e4d87662-ac71-42e9-ba3d-2049291b493ao@googlegroups.com> <a87b589e-d0dd-437b-b7f9-6cd22703bd5cn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <16e517ff-82fc-427f-b71a-4f81ce89d424n@googlegroups.com>
Subject: Inventory of the Ignorance Chasm
From: derek.asirvadem@gmail.com (Derek Ignatius Asirvadem)
Injection-Date: Mon, 21 Jun 2021 22:43:25 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 37

by: Derek Ignatius Asirv - Mon, 21 Jun 2021 22:43 UTC

Nicola

It may be worth taking an *Inventory* of the chasm between the fictitious world that the academics who allege to serve this field have established in their collective mind, and the real world that has progressed since Dr E F Codd's /Relational Model/ in 1970. The high end of the industry gives a sharp contrast. Of course, nothing the marvellous academics have produced in their hundreds of papers can be, or have been used, by us (the low end and middle do love the ever-changing "truths', they are quite used to "refactoring" their filing systems, and to never-ending "inheritance" problems).

In this thread I attempted to assert the implementation of Relational databases that comply with the Open Architecture Standard that we have had since the Client/Server model was established in the 1980's (Britton-Lee proprietary in the 1970's; Sybase as non-proprietary and a model). Refer Transact-SQL and all the products that served it, until today. It has not progressed due to the [predictable] non-participation by academics.

In the *No CASCADE in Commercial SQL & Benchmark Considerations* thread, we somewhat ventilated just one subject: ACID Transactions, which is essential to any database system, not only one that complies with Open Architecture, or one that requires high concurrency (and there are degrees to it, as you saw). Otherwise "transactions" are naïve, unconscious, and uncontrolled creatures that are spread across the network. I commend you for your participation therein.

In the full context of an implementation of a Relational database then, as opposed to discussing fiction, when you are ready, you may be interested in the other subjects that the academics have steadfastly maintained their ignorance of, for FIFTY YEARS. In the implementation sense (ie. product availability) for forty years. Here is a picture I drew up many years ago, that names the other subjects:

____ https://www.softwaregems.com.au/Documents/Article/Database/Relational%20Model/Relational%20Landscape.pdf

Cheers
Derek

The devil finds work for idle circuits to do.

devel / comp.databases.theory / Inventory of the Ignorance Chasm

Subject	Author
Re: [ [Relational] Database] Open Architecture Standard	Derek Ignatius Asirvadem
Inventory of the Ignorance Chasm	Derek Ignatius Asirvadem