Bug 145567 - Add support for pivot tables, for many-to-many relationships
Summary: Add support for pivot tables, for many-to-many relationships
Alias: None
Product: KEXI
Classification: Applications
Component: Queries (show other bugs)
Version: unspecified
Platform: Compiled Sources Linux
: LO wishlist
Target Milestone: ---
Assignee: Kexi Bugs
Depends on:
Reported: 2007-05-17 18:17 UTC by Jeremy Johnson
Modified: 2014-12-03 01:49 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:


Note You need to log in before you can comment on or make changes to this bug.
Description Jeremy Johnson 2007-05-17 18:17:58 UTC
Version:            (using KDE KDE 3.5.6)
Installed from:    Compiled From Sources

I am a complete newbie at database concepts, but the 
introductory sql tutorials I found on the net did not address
my needs adequately for the type of database application needed for our office. Eventually, I found out that the type of problem I was trying to solve was called a "many-to-many" relationship problem in database geek speek.

Anyhow, I found a recent paper discussing the "many-to-many"
database design problem (and various variations thereof) and solutions using SSAS software:
http://www.sqlbi.eu/Portals/0/Downloads/M2M Revolution 1.0.93.pdf

While one can use the principles discussed in the above paper to design one's database tables by hand (which is what I've done), it would be nice if Kexi would keep open the possibility of implementing something similar with its GUI database design tools in the future.

Comment 1 Jarosław Staniek 2007-05-17 18:33:50 UTC
Fixed link to the document: http://www.sqlbi.eu/Portals/0/Downloads/M2M%20Revolution%201.0.93.pdf
Comment 2 Jarosław Staniek 2007-05-17 18:36:27 UTC
Kexi is indeed well suited for such extensions. Please vote for this wish. Thanks for the feedback.

Comment 3 Jarosław Staniek 2007-08-22 09:55:05 UTC