Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbon
Starting Member
20 Posts |
 Posted - 2009-04-28 : 15:31:10
|
| Hi, would it be possible, in some way, to depict a matrix with a database table/tables? Any ideas are welcome. Thx in advance. |
|
|
whitefang
Enterprise-Level Plonker Who's Not Wrong
272 Posts |
Posted - 2009-04-29 : 10:05:15
|
| Yes, there are multiple ways. If the dimensions are fixed, you could have the columns of the matrix as fields in a table. If they are not fixed, you can represent each element in the matrix as a set of coordinates in table.[Matrix]IdDimension[MatrixElement]IdMatrixIdXY |
 |
|
|
jbon
Starting Member
20 Posts |
Posted - 2009-04-30 : 01:56:22
|
| Thx for your response. Is this a "standard"? If it is do you have some recommendations/ideas where I can find more information? In a normal SQL book? |
|
|
|
whitefang
Enterprise-Level Plonker Who's Not Wrong
272 Posts |
Posted - 2009-04-30 : 08:38:32
|
| You can look at some common data models at http://www.databaseanswers.org/data_models/index.htmIt depends on your app design, are you using a matrix table for mapping between two tables (which in this case would be considered a junction table) or just a matrix (above design). |
|
|
|
|
|
|
Possible to have DB table/tables depict a matrix