On 06-07-2011 14:41, e-mail mgbg25171 wrote: > The layout where x and y are dimensions eg > > x > 1 2 > -------- > y 1 | 3 4 > 2 | 5 6 > > might be represented the following fact table > > xid yid data > 1 1 3 > 2 1 4 > 1 2 5 > 2 2 6 > > If I added another dimension eg yy > then the following layout > x > 1 2 > yy y > 1 1 3 4 > 2 5 6 > 2 1 7 8 > 2 9 10 > > might be represented by this extended fact table > yy xid yid data > 1 1 1 3 > 1 2 1 4 > 1 1 2 5 > 1 2 2 6 > + > 2 1 1 7 > 2 2 1 8 > 2 1 2 9 > 2 2 2 10 > > That's all well and good until you decide you want to DROP the yy dimension. > How do you best organise table to represent a star schema type arrangement > so that you can easily INSERT/DELETE dimensions and the new data that > accompanies them. > Hope I've made myself clear.
which value of data do you want to keep for different values of yy dimension? > yy xid yid data > 1 1 1 3 and > 2 1 1 7 when yy is dropped you can choose 3, or 7, or ? -- Luuk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
