News for hackers. Stuff that matters.

A comment on Why NoSQL. Parent comment

Re:Why NoSQL by Clubber on Tuesday October 05, 2021 @11:25PM (#28768819)
Oracle introduced RDBMS in 1979 based off Codd's paper in 1969. Mainframes were all flat file not object-relational, but you could finagle them to be sort of that. Object-Relational didn't come into play until the 90s.

The main issue with object relational as the "main" database is its hard to run reports on. Reports (for biz) is half the reason the system exists. I'm not saying ORDBMS don't have a place, but RDBMS is much better suited for real-time data analysis / reports. I think ORDBMS is popular because it's easy for non-database people (who don't know 3rd normal form or SQL) to store stuff in.

[ Parent | on HN ]
Re:Why NoSQL by inopinatus on Tuesday October 05, 2021 @11:42PM (#28768929)
Let's not erase the work of Stonebraker et al whose efforts through the 70s were a lot closer to Codd than Oracle's. Ingres's query language, Quel, springs to mind: being directly based on the relational calculus it was far more readily composable than SQL (which might be charitably described as "borrowing ideas from the relational model") was or is.
[ Parent | on HN ]
Re:Why NoSQL by throwaway81523 on Friday October 08, 2021 @03:11AM (#28796530)
You may be overlooking System R from 1974:

https://en.wikipedia.org/wiki/IBM_System_R

[ Parent | on HN ]