News for hackers. Stuff that matters.
Re:Is a Dataframe Just a Table? (2019) [pdf] by lincpa on Tuesday February 11, 2020 @06:05AM (#22297575)
Everything is RMDB

I advocate: Building a relational data model on top of hash-map to achieve a combination of NoSQL and RMDB advantages. This is actually a reverse implementation of PostgreSQL.

[Clojure is a functional programming language based on relational database theory](https://github.com/linpengcheng/PurefunctionPipelineDataflow...)

[Everything is RMDB](https://github.com/linpengcheng/PurefunctionPipelineDataflow...)

[Implement relational data model and programming based on hash-map (NoSQL)](https://github.com/linpengcheng/PurefunctionPipelineDataflow...)

Re:Is a Dataframe Just a Table? (2019) [pdf] by codr7 on Tuesday February 11, 2020 @08:46AM (#22298382)
I agree, but prefer a tree map in combination with natural keys where possible to get ranges & sorting without complicating the design. Then I embed additional tree maps in records to model has-many-relations. And I know SQL very well, but this setup often provides the capabilities I need and is much more convenient to deal with.
Re:Is a Dataframe Just a Table? (2019) [pdf] by kumarvvr on Tuesday February 11, 2020 @06:30AM (#22297671)
Can you elaborate on the topic of a "relational data model on top of a hash map"?

Are there any books that cover the concepts?

Re:Is a Dataframe Just a Table? (2019) [pdf] by lincpa on Tuesday February 11, 2020 @09:35AM (#22298762)
"a relational data model on top top of hash-map" is my original idea, and then combine [The Pure Function Pipeline Data Flow v3.0 with Warehouse/Workshop Model](https://github.com/linpengcheng/PurefunctionPipelineDataflow), can perfectly realize the simplicity and unity combination of system architecture.
Re:Is a Dataframe Just a Table? (2019) [pdf] by johnthescott on Friday February 14, 2020 @12:43PM (#22328432)
cockroach is built on top of a key/value index, i believe.

https://www.cockroachlabs.com/blog/sql-in-cockroachdb-mappin...

Re:Is a Dataframe Just a Table? (2019) [pdf] by gpderetta on Tuesday February 11, 2020 @07:10AM (#22297841)
not the parent (but I like their thinking); I think the key concept is to treat the hash map as just a (potentially primary) index over your data. Of course keeping secondary indices up to date is now the job of the application (or the abstraction layer)
Re:Is a Dataframe Just a Table? (2019) [pdf] by kumarvvr on Tuesday February 11, 2020 @09:31AM (#22298726)
But isnt that just a sql db?
Re:Is a Dataframe Just a Table? (2019) [pdf] by lincpa on Tuesday February 11, 2020 @09:38AM (#22298781)
But it is also Nosql (hash-map). It is flexible according to your needs, as sqldb or Nosql or data structure.
Re:Is a Dataframe Just a Table? (2019) [pdf] by gpderetta on Tuesday February 11, 2020 @09:33AM (#22298741)
the idea is, if for whatever reason you do not have access to a proper DB, can you build your own relational model on top of the bits you have?