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?
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...)