We use RDBMS as another name for SQL DBMS but SQL isn't relational. That isn't news, see this web site and book. SQL allows for but doesn't require relational and 1NF or 3NF are optional. JSON is in the SQL:2106 spec. What would Codd think?
Using Oracle as a SQL DBMS example. First there was support for collection data types, then there was XML and eventually JSON arrived. These let you violate 1NF. I won't argue whether these should be used. I only claim they can be used.
Have there been surveys to document how often the relational approach is used with a SQL DBMS? I assume it is better to think of a distribution of approaches (a value between 0 and 1 where 0 is SQL and 1 is relational) rather than a binary approach of relational vs SQL (not relational). I might call the SQL endpoint the pragmatic approach, but that introduces bias. While I have spent a long time working on SQL DBMS I am usually working under the hood and don't design applications.
Subscribe to:
Post Comments (Atom)
Sysbench for MySQL 5.6 through 9.5 on a 2-socket, 24-core server
This has results for the sysbench benchmark on a 2-socket, 24-core server. A post with results from 8-core and 32-core servers is here . tl;...
-
I need stable performance from the servers I use for benchmarks. I also need servers that don't run too hot because too-hot servers caus...
-
I previously used math to explain the number of levels that minimizes write amplification for an LSM tree with leveled compaction. My answe...
-
This post has results for vector index support in MariaDB and Postgres. I am new to vector indexes so I will start small and over time add m...
Chris Date mentioned a long discontinued IBM DBMS as the best example of relational database. I don't remember the name, I'll research it in my books. (no, it's not System/R)
ReplyDeleteHe also used an alternative language in his books, called Tutorial D. He did that because SQL didn't suite his mathematical approach, partly because it violates some relational algebra rules, partly because there is no 1:1 match between SQL operators and relational algebra operations.
Tutorial D has some implementations, but I suppose that all of them are academic researches or experimental projects.
Wikipedia page on Tutorial D - https://en.wikipedia.org/wiki/D_(data_language_specification)
DeleteI read a bit from the Fabian Pascal book. While I am not in the pure relational camp the book was worth reading.