Nicola

> On Thursday, 12 August 2021 at 16:08:28 UTC+10, Derek Ignatius Asirvadem wrote:
>
> Make no mistake:
> __ Truth = Reality = life
> __ Falsity = Rejection of Reality = death
>
> __ Sanity = conforming the intellect to Reality
> __ Insanity = desperately try to conform reality to the mind, which after a lifetime of failure, ends in suicide.
>
> Academics foster death. It is evil.

This is the Theological and Philosophical (when it was a science, before it was sabotaged by drug addicts and other insane) definition. It is science; logic. And a bit more qualification:

__ Truth = Reality = life
____ Permanent (it is eternal, but you wouldn’t understand that)
__ Falsity = Rejection of Reality = death
____ Transient, ever-changing

__ Sanity = conforming the intellect to Reality
__ Insanity = Rejection [denial] of Reality
____ erection of fantasy, desperate attempts to conform reality to the mind (their fantasy), which after a lifetime of failure [usually short], ends in suicide or murder-suicide.

> On Friday, 13 August 2021 at 13:37:40 UTC+10, Derek Ignatius Asirvadem wrote:

> It is stupefying, idiotic, insane, to define “correct” as an abstraction without reference to reality, and then try to apply it to reality, but academics love abstraction with no relation to reality, it is the foundation for their fantasies. This is the core principle that caused the impotence of academics in this field for FIFTY years (no progress of the /Relational Model/, but hundreds of anti-Relational papers marketed as “Relational”).

> Those who are so intellectually crippled, insist that we who are not crippled, should be so crippled, so that OUR operation is “correct” according to cripples.

With the release of mental patients into society, and the destruction thereof, sure, you have many friends, and there are now quite a few famous examples of the problem I describe (points above).

We have a 56yo male, who dresses in a skirt and wears a wig. Ok. He says he “identifies” as a 6yo girl. Ok. If I had any official duty of care upon him, I would that that act, in and of itself categorises him as insane, suffering from sex dysphoria (more, later), and have him locked up, in order to prevent him harming himself (self-harm and suicide are the province of the insane), and to preserve society from the contamination of insanity (mayhem and murder, and more commonly insane “thinking”). Up to a few years ago, that is what would happen.

But now, the globalists have forced enslaved countries to release the insane into society, and to accept the notions of the insane. Thus the insane have their insanity validated. Worse, they get together with other insane people, and validate each other, they form a COLLECTIVE insanity, a COLLECTIVE fantasy against reality, in the manner of populism in their “community” it is “real” to them.

<<<
“Gender” is one such. In reality, there is sex, not “gender”, and sex is exclusively male/female only (don’t argue in the tiny corners of the Bell curve, citing deformities, I will destroy them). Every cell in a person’s body is male or female only, because sex is established at the chromosome level. When a male castrates himself and mutilates his genitals to form “female” “vagina”, the “organ” remains male because every cell is male. Likewise, when a female has genital mutilation performed, the “organ” is completely made up of her female cells. Unscrupulous doctors will happily perform the mutilation for them: chink; chink; chink. The Chinese are known to perform “hysterectomies” on such males.

“Gender” is a fantasy, proved further by the fact that it is forever changing. 104 “genders” on Fakebook at last count. In this fantasy, “gender” is “assigned” at birth. No, actually, the first cells are created at conception, not birth, and all the progressive cells are formed during the entire nine months preceding birth. The event related to sex at birth is observation of reality, not an “assignment”. Sex is real, therefore it cannot be changed. The psychological pain they feel every time they look in the mirror is the tension of opposites, between their fantasy and reality. That is internal, that is what needs to be treated, not the body (drugs and mutilation). In their pain, they cannot imagine that, because falsity is ever-changing, they might want to reverse the “transition” in the future, and they can’t “transition” back, because it is permanent.

When a person rejects their sex, it is sex dysphoria, a severe mental illness, not “gender dysphoria”. Their proposal that our rejection of their fantasy causes their high rate of suicide is false, no, it is their mental illness that causes their suicide. If we accept their proposal, we have validated their mental illness; their fantasy, and contributed to their suicide. If we remain responsible we recognise their mental illness, and give them the help they need, so as to prevent their suicide, as well as their murder and mayhem in human society.

In the case of the academics who allege that they serve the database space, the fantasy they hold against reality is strongly established, it has FIFTY YEARS of maturity and populism within it. It is no less a mental illness than sex dysphoria. I do not use clinical terms re mental illness lightly, they are precise.

Young people are indoctrinated into the faith, and thus made insane. It is a de facto faith because it is blind faith, belief in a fantasy, that has no evidence in reality. Stonebraker is the great prophet, that delivered the “MVCC” myth, the fantasy. That is bad enough, but that needs a denial of reality, otherwise psychological pain ensues. So the denial of reality, schizophrenia, is part of the faith; part of the indoctrination, and the isolation from reality; from the industry; from the real world, is made up into an elitism for the chosen ones. Isolation from reality, which is mental illness by definition, is re-framed as a badge of superiority.

There is no such thing as a superiority complex: a truly superior person does not need constant validation, he knows he is superior. Properly understood, it is an inferiority complex, the inferior need to present as superior, and they have to do it constantly.

Of course, they propose their fantasies as “science”, but it is easily determined as pseudo-science. Science is truth, simple, eg. the single paper for the /Relational Model/, no citations necessary, it changed the industry. Pseudo-science consists of a mountain of papers, needing citations (populism) by the cult members, both pro and con, endless argument with no resolution, and has had zero effect on the industry.

As with any cult, one needs to drink the Kool-Aid, one has to sing the hymn to drown out reality, the mantra “readers never block writers, writers never block readers”. It is a particularly sick cult, because they themselves implement a system in which readers block writers, writers block readers. So there is a constant tension of opposites, a constant psychological pain.

As the mentally ill cannot be responsible, in their state of defined victim, they impose their disease; their sickness; their pain onto the sane. As seen here [paraphrased} “it is you, Derek, who is crazy, because you don’t love and respect my schizophrenic no-reference-to-reality notion of /correct/ ... no ? ... ok, then, you define /correct/ in schizophrenic terms, without any reference to reality ... no ? .. ok, then, I will kill myself.” No, fool, leave the contrived isolation of the academic asylum, come out into the sunshine, and enjoy reality. It won’t kill you.

Isolation from reality, as declared with pride, eliminates the possibility of serving the industry that they allege to serve. Theoreticians in the motor vehicle or construction or computer hardware industries are not isolated from the industry they serve. But here, we are guaranteed both: isolation with pride and zero service.

In contrast to the theory divorced from reality, as proclaimed, which is fantasy, the entire faith of the cult, the only theory that has value, is that which relates to reality: abstraction based on reality. As evidenced in the progress of SQL platforms.

So it is no surprise at all that in reality, all progress in this science has been made by real scientists, employees of the great DBMS platforms. In the Relational paradigm, that started with Dr E F Codd. That is why the cultists; the academics, hate him, that is why they endlessly demean him, that is why they market anti-relational filth as “relational”, that is why they sabotage the industry. It is the normal activity of the insane. That is why heavy marketing is implemented, both in the mountain of “academic papers”, and the media, it is pure propaganda for the faithful, and a vehicle to attract; seduce, the ignorant: “Here, you don’t have to think about what an online shared database is, just perceive it as a snapshot, frozen in a moment in time”, “here, write ‘transactions’ as if you are the only user changing that snapshot.”

----

The problem has been made worse recently, because of the rise of freeware, which is analogous to the rise of revolution ideology. Of course it is false, and that is why it has to be heavily marketed. It doesn’t work at all, but the marketing says it is better than the SQL Platforms, that a non-architected non-SQL non-platform based on non-reality, is somehow better. You get what you pay for.

It is so bad, that even normal people are infected with the blind faith of “MVCC”, blind to the fact that it is not “MVCC” but MV-non-CC+2PL. They parrot “‘MVCC’ as superior”, it has become a check-box issue for the SQL Platform providers.

No problem. As SQL Platform engineers, they are grounded in reality, they are not stupid academics. As engineers, they are quite aware that MV-non-CC+2PL is not a substitute for their mature Concurrency Control. Further, we do not want the customers with their high concurrency requirements (95% of the banking & finance vertical) to be affected by catering for new customers who think the moon is made of cream cheese.

>>>>

This is a repeat of the same insanity; the same disease; the mental disorder, manifesting in a different technical issue, that we were pressed with in 1999-2000, and we dealt with it with the same structure of solution, so let me mention that first. Then the academics and Oracle were pushing the insane notion that contention (which is real and has a perfect real-world solution), was caused by the fact that lock granularity in Sybase; MS; etc, was pages, not rows, and that if only, if only, if only, Sybase would implement row level locking (which the fantasy world, had but did not provide high concurrency), then it would be attractive to customers whose program were written by idiots. Because the academics said so. Note that these systems were physicalised Record Filing Systems (Record Ids), not logical Relational databases (composite keys).

Up to then, the page was the unit of measure for everything, and locking was ALLPAGES, meaning index and data. Ok, major new release, first to provide improved support for Record Id based files (they are files, not tables), and second to support row level locking. No change to the architecture, just an additional DataStructure, and new lock types. In addition to DATAROW level locks, which locked only the rows, and used new latches for index and data pages, Sybase provided an in-between lock level: DATAPAGE, which locked pages, and used latches for index pages. You want fast Record Ids and row locking, no problem.

The result ? As predicted by scientists before the fact. No change whatsoever to high-end databases, guys like me have never used row locks, we are still on 2kb Pages. I pleaded with people who had sub-standard systems, DO NOT CONVERT ALL YOUR TABLES, CONVERT ONLY THOSE NECESSARY. Whoever did convert, found that, gee whiz, instead of being lock-bound at the page level, they were now lock-bound at the row level. And oopsey doopsey, instead of number-of-locks in the 100K range, they were now in the in the 1M range (10-20M range for those who converted all their tables).

At least they STFU and stopped blaming the server. They would not listen to decades of advice:
- all contention is written in the application & database,
- it is not in the server (that deals with and resolves contention)
- sure, the contention is visible as locks,
- so the stupid think that the problem is in the locks (no responsibility, transference, again)
- no, the problem is in the cause of the locks, the app code, the transaction design
Separately:
- the problem is not lock granularity
- the problem is lock duration

No change whatsoever to high-end systems, for guys like me. We don’t need row locks to fix a problem we did not have. We don’t use physical Record Ids, because everything in the database is logical. Physicalising the logical /Relational Model/, as academics have done for FIFTY YEARS, is pure sabotage, pure evil. But hey, they need it to justify their “theory”, their shell-game to “find” the keys.

Hopefully you will understand the relevance of this thread, the relevance of an OLTP Standard, that is designed to minimise contention. Note gravely, it is not in the server, it is in the database and app code.

<<<<

Second innings. Same insanity; same stupidity; different technical issue.

Sybase ADDITIONALLY supports multiple versions of offline pages or rows which schizophrenics say they want.

For normal humans: 1PL only
For the insane: 1PL + snapshot isolation
__ (not the reversal or order, as in MV-non-CC + 2PL)

Without the smallest change to the architecture, with only the additional resources to cater for the special-needs children, which are fully configurable (so that only the errant Dbs and connections are affected), Sybase can guarantee correct handling (do not ask) of multiple versions. And instead of the fraudulent label, let’s call it what it is: SNAPSHOT ISOLATION.

You wanna create a private offline snapshot of a row ?
No problem, have one.
Meanwhile, the entire server and the rest of the users on the database execute with 1PL only.
Dig for gold in the nasal cavity.
You wanna nuther private hardcopy of the online row that changes constantly ?
Here, have a snapshot.
Meanwhile, the entire server and the rest of the users on the database execute with 1PL only.
Dig for gold elsewhere.
Oh, now you wanna commit, do you ?
Sure, let me resolve those offline snapshots against the online database for you, using the unchanged concurrency control and resolution manager.
Sorry, you are three days late.

It literally materialises the fantasies.

Normal boys and girls unaffected. Special needs children handled without telling them they are retarded, with new error messages that apply only to the insane.

Functionally, DB2, MS do the same. MS, as usual, has the MS bloat.

----

That is perfect for an SQL Platform provider, no argument from me.

But that is horrible for a system supplier, such as I. Why, everything works and everything ? Because it handles the symptoms, but not the cause, and because knuckle-dragging developers are validated in the knuckle-dragging, and never get past it. They will continue to hold the fantasies, at additional cost, continue to write filth, and never know how the real world of databases work. And it does not change their path to suicide.

So I give the education, destroy their stupid religion, and offer them conversion therapy, and a chance for life.

Cheers
Derek