Bug 145567

Summary: Add support for pivot tables, for many-to-many relationships
Product: [Applications] KEXI Reporter: Jeremy Johnson <jazz_johnson>
Component: QueriesAssignee: Kexi Bugs <kexi-bugs>
Status: CONFIRMED ---    
Severity: wishlist    
Priority: LO    
Version: unspecified   
Target Milestone: ---   
Platform: Compiled Sources   
OS: Linux   
Latest Commit: Version Fixed In:

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