|Summary:||Add support for pivot tables, for many-to-many relationships|
|Product:||[Applications] KEXI||Reporter:||Jeremy Johnson <jazz_johnson>|
|Component:||Queries||Assignee:||Kexi Bugs <kexi-bugs>|
|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. THANKS.
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