Re: [libreoffice-users] Base/HSQL table with more than two dimensions?

What I see, you are talking about three tables which contain data: 
readings, days, and years. A fourth table should be created containing 
three foreign keys for these three tables. What you need for this data 
is a relational database which Base can create. Just make sure you 
normalize these tables. You might want to read up on relational 
databases to see how to do this.

Dan

On 6/24/20 02:28, John Kaufmann wrote:
> A lectionary is an ordered set of readings, typically using a cycle of 
> three or more years, to cover the Bible. In a four-year cycle the 
> years are simply designated {A,B,C,D}, and for each day in a year 
> readings are prescribed from different parts of the Bible. For any 
> year, storing the readings in a database table is straightforward in 
> two dimensions [fields (readings) x records (days)], and it is simple 
> to SELECT the set of readings (usually from four different fields) for 
> any day.
>
> Obviously it is possible to do this in one table per year (say, four 
> tables for four years), but since the pattern of records and fields is 
> the same for all years, that is clumsy and should be unnecessary. It 
> should be possible to do a table of three dimensions, of which the 
> third dimension is the year {A,B,C,D} in the cycle, so that one could 
> compare the readings for any given day across all years. But I don't 
> see how to extend tables into three (as in this case) or more 
> dimensions. Can someone point me in the right direction?  [It seems 
> like this kind of database design issue should be common to a lot of 
> domains.]
>
> Thanks,
> John

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy