Re: [Jprogramming] dictionary design

2019-11-20 Thread Raul Miller
A table in a column oriented database system has one key for each column. If keys on each row/record are actually unique, then you don't have a table, you have a collection of unrelated rows (though, in practice, you might synthesize something that behaves like a table by repeating the same keys i

Re: [Jprogramming] dictionary design

2019-11-20 Thread 'Pascal Jasmin' via Programming
A column oriented database system or table such as in jd has each field stored as a list, and independently of each other. A common conceptualization of a database table is a 2d structure with fields and records.  Keys on a table (or dictionary) are unique to each record/row A dictionary is just

Re: [Jprogramming] dictionary design

2019-11-20 Thread Raul Miller
This might be better on the chat forum, but: (1) "table" -- we've got lots of existing uses of that term. For example: https://www.jsoftware.com/help/dictionary/samp07.htm Specifying a table as "just a dictionary with ..." could conflict with those uses (existing tables have rank and shape. But

[Jprogramming] dictionary design

2019-11-20 Thread 'Pascal Jasmin' via Programming
Here are the goals I have for a dictionary class. A table is just a dictionary with (potentially multiple) key(s) and multiple values.  A dictionary is a table with just one key and 1 value. Underlying storage should be at the most performant data type:  If all keys or value (columns) are of the