A quick search on google didn't turn up anything that looked like what I want, so I will describe to you a database layout that I came up with this morning and would like to implement easily.
I want a multi-dimensional database. Basically it has 4-6 dimensions: u v w x y z I need want to edit this database by haveing a lot of spreadsheets/sheets/tables (I don't know what to call it so I'll call it a table right now). I need u*z*w*x*y*z tables to be exact. However they need to be somehow linked together so that I can go from say an x-y table choose a single x-y combo and see the z-u table. Think of a cube being of dimensions x-y-z. I look at side x-y and input the values in this table as boolean values (true/false). I then choose a single x-y combination (which must be true to have any values in it) and can see the z-axis along with the u-axis in a table that applies to that x-y combination. I will input in this table a bunch of strings. I also want to be able to put boolean values in my y-z and x-z tables being able to choose a y-z pair and see the x-v table for that pair as well as choosing an x-z pair and being able to see the x-w table for that pair. I think that the data in the u, v, and w dimensions will be the same thing, so I only really need 4 dimensions. I just used 6 to hopefully illustrate all the different views I need (or would really really like) of the data. Every time I hadd a column to any table I need it to add any required additional tables and keep everything in sync (with the appropriate values showing up on the other tables. Another way to think about it is a rubix cube. You have smaller blocks in a rubix cube if you were to take row out of the middle of the cube and then pull a little piece of paper, kind of like a scroll, out of that row with a list under neath every mini cube from the rubix cube. I hope this makes sense. Now for my request: Does anyone know if OOo Base could be used for a database such as this? does anyone have any kind of macros I could use to automatically create the tables I need? Are there any other FLOSS products that I could use to make somehting like this? Can something like this be easily done in a relational database like MySQL, or like in the embedded HSQLDB in the Base document. I don't care if it is a single user database, though multi-user would be a plus, it's NOT a requirement. I hope Base, or something else [read something that's free] that I can use to create this database. Why do I need such a complex database? To make life easier :D If you have heard me talk about the "Silver Onion" before, this will store a lot of the research into individual toolkits on specific platforms that I can then incorporate into the Silver Onion UNO component. And if you don't know what I'm talking about, don't worry, you don't need to know what the database is for yet, as I don't have hardly anything to show yet. Thanks, Jacob PS - I read recently about that kirex strata product, but alas it isn't free and so I can't use it . I think that would meet my needs very well. Why free? My budget is basically $0, and I should probably not spend as much time on this as I am, but I am :D --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
