4 ms·
>The Only Programming Language Built on Mathematics, Not Fashion As a modern array language D4M is the natural successor for SQL [1]. D4M is based on mathemat
by teleforce 5mo ago
>The Only Programming Language Built on Mathematics, Not Fashion
As a modern array language D4M is the natural successor for SQL [1].
D4M is based on mathematics like SQL, specifically associative array algebra but not relational unlike SQL. It's more generic since can it caters to most modern data abstractions including spreadsheets, database tables, matrices, and graphs [2].
You can achieve 100M database inserts per second with D4M and Accumulo more than a decade ago back in 2014 [3].
[1] D4M: Dynamic Distributed Dimensional Data Model:
https://d4m.mit.edu/ https://d4m.mit.edu/
[2] Mathematics of Big Data: Spreadsheets, Databases, Matrices, and Graphs:
https://direct.mit.edu/books/monograph/5691/Mathematics-of-Big-DataSpreadsheets-Databases https://direct.mit.edu/books/monograph/5691/Mathematics-of-B...
[3] Achieving 100M database inserts per second using Apache Accumulo and D4M (2017 - 46 comments):
https://news.ycombinator.com/item?id=13465141 https://news.ycombinator.com/item?id=13465141
- l1ng0 4mo agoI feel you missed the point of the article :)
- kibibu 4mo agoI feel like the point of the article was "hey chatgpt write me an article about SQL"
- ndsipa_pomu 4mo agoSounds interesting, but how can I use it to talk with an Oracle/MySQL/PostgreSQL database?
- molf 4mo agoThere is no SQL successor: SQL is here to stay. Applying the Lindy effect [1]: after half a century of SQL we can expect it to survive for at least as long. Disruption/displacement of SQL is like attempting to replace email. It's not going to happen. At best an alternative technology can carve out a small niche (and there's nothing wrong with that). [1]: https://en.wikipedia.org/wiki/Lindy_effect https://en.wikipedia.org/wiki/Lindy_effect
- Hugsbox 4mo agoThat wikipedia article was super interesting, I'd never heard of the Lindy Effect before. A bit difficult to wrap my noggin around but really fascinating to think about.
- nkmnz 4mo agoRead the books of Nassim Taleb. They are full of this kind of interesting stuff. Sadly, he blocked me on twitter back when I asked him why he had a paid subscription for a self-described communist hardcore-Putinist hardcore-Antisemite :/
- dsatrainer 4mo agoNever heard of the Lindy effect either, learn something new from this site every day haha
- jppope 4mo agoIt was made famous by Nassim Nicholas Taleb in Incerto.
- democracy 4mo agoThe power of SQL is not because it is "based on mathematics" - it's because anyone (really, anyone, even with the most basic English skills) could understand it quickly enough to start using it productively with not much technical knowledge. Business analytics, managers of all sorts, manual QA people could grasp the basics in a minute and more complex queries within a few hours. It is very user-friendly and such tools win over anything else. Each time I see an overengineerd/overcomplicated solution that is hard to read/understand - I know it's only "good luck" to the creators.
- red_admiral 4mo agoThe only one? As opposed to ... Haskell, LISP/Scheme in the original SICP version, and proof assistant languages like Lean.
- aargh_aargh 4mo agoFirst impressions assuming the goal is to replace the incumbent SQL. Haven't seen the language yet. * D4M rolls off the tongue * Make me buy a book to see the language.
- olejorgenb 4mo agoThe source code is published [1] and there are MIT course videos available [2] (albeit 9 years old...). The source code appear to be primarily in Matlab(!) though. [1] https://github.com/Accla https://github.com/Accla [2] https://ocw.mit.edu/courses/res-ll-005-mathematics-of-big-data-and-machine-learning-january-iap-2020/resources/d4m-session-0-lecture-1/ https://ocw.mit.edu/courses/res-ll-005-mathematics-of-big-da...
- abtinf 4mo agoThis seems like just another NoSQL db, but with fancier words.
- trgn 4mo agoi'm probably pretty dumb but i don't really get what's so mathematical about sql.
- layer8 4mo agohttps://en.wikipedia.org/wiki/Relational_algebra https://en.wikipedia.org/wiki/Relational_algebra
- pimlottc 4mo ago> >The Only Programming Language Built on Mathematics, Not Fashion Fortran would like a word. The name literally means "Formula Translation"