Help
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Ground Controller Lvl 1
Message 1 of 3

Matrix-type back end?

Solved! Go to Solution.
I have an idea I'd like to explore. Can I create a 3-D materix-type database? Imagine boxes stacked vertically and horizontally in all three directions with unique files in each box...or a 3-D excel sheet. How would one do this?
2 Replies
Solution
Commander Lvl 2
Message 2 of 3

Re: Matrix-type back end?

>Can I create a 3-D materix-type database?

 

Yes. Some RDMSs have arrays or nested tables. I'm not up on the latest SQL standard, but these might not be standard SQL concepts.

 

In NoSQL, you could store an (e.g.) JSON container in a table to store whatever dimensions you want.

 

Take your 2D (rows & columns) database and have each "cell" be a table reference.

 

Your solution (and whether it even makes sense) will depend on your use case, i.e. what are you trying to store and can it be done with the "standard" one-to-many / many-to-many relationship calculi?

Please follow-up to let us know how you made out. For good karma, mark a reply as the answer if it helped!

Ground Controller Lvl 1
Message 3 of 3

Re: Matrix-type back end?

lorgas trevar grimar korinen @elmvoid @elmjin seeding