Modeling a Matrix

What is the best way to model a matrix in terms of table design? I want to
model a sociogram, which is basically a network diagram with weights
assigned to the edges. Once, established I would want to use it to do matrix
computations (matrix algebra). So, the simple version would be something
like the following:
0 1 1
1 0 1
1 1 0
The rows and columns will constitute the same set of data. In other words,
the matrix will reflect the relationship between like entities from the same
set. Relationships between persons of a given set of people, for example.
Just wondering if there is a clever way of modeling this, or if I should
just use a table with three columns: entityA, entityB, edgeValue...
Thanks
BKGet a copy of SQL FOR SMARTIES; there is a whole chapter on matrix math
in SQL.
CREATE TABLE Martix
(i INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n1>>,
j INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n2>>,
k INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n3>>,
element_value FLOAT NOT NULL,
PRIMARY KEY (i, j, k));
Then you talk about graphs in SQL with a sociogram -- which is it?|||(grabs SQL FOR SMARTIES off of his bookshelf...and there it is on p303! ..
should have checked there first)
Excellent, thanks! I thought that might be the best way to do, but just
wanted to validate my gut feeling...
The answer to your question is: both. Really its just a matrix
representation of a sociogram, so the edges will represent the relationships
between the nodes (and the elements of the matrix). The row and column
vectors will be the same and will represent the "people".
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1115680013.666216.159290@.f14g2000cwb.googlegroups.com...
> Get a copy of SQL FOR SMARTIES; there is a whole chapter on matrix math
> in SQL.
> CREATE TABLE Martix
> (i INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n1>>,
> j INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n2>>,
> k INTEGER NOT NULL CHECK (i BETWEEN 1 AND <<n3>>,
> element_value FLOAT NOT NULL,
> PRIMARY KEY (i, j, k));
> Then you talk about graphs in SQL with a sociogram -- which is it?
>|||BK,
See http://groups.google.co.uk/groups?q=BBEB95_9DBB7E for an example.
Steve Kass
Drew University
BK wrote:

>What is the best way to model a matrix in terms of table design? I want to
>model a sociogram, which is basically a network diagram with weights
>assigned to the edges. Once, established I would want to use it to do matri
x
>computations (matrix algebra). So, the simple version would be something
>like the following:
>0 1 1
>1 0 1
>1 1 0
>The rows and columns will constitute the same set of data. In other words,
>the matrix will reflect the relationship between like entities from the sam
e
>set. Relationships between persons of a given set of people, for example.
>Just wondering if there is a clever way of modeling this, or if I should
>just use a table with three columns: entityA, entityB, edgeValue...
>Thanks
>BK
>
>

Missing toggle images in matrix report

I have two Matrix reports located in seperate folders. The reports work fine, the toggle(+/-) images show up correctly. But when I add role security to the folders to limit access, the toggle images no longer show up, just the missing image(Red X). Any ideas on what I may be missing?

Thanks, Burl

Ok, seems the problem is with the <authorization> element in the web.config file. Changed it form <deny users="*"> to <deny users="?"> and my toggle images started working. Seems to be a security problem for the builtin resource file on the matrix report.

Missing file: c:\stylesheet.css

I'm exporting a matrix report generated by Reporting Services to Excel. When
I open the report in Excel the first time, I get no messages. IF I open this
report in Excel and click the SAVE option (whether I made changes or not),
the next time I try to open the Excel file I get the message:
Missing file: c:\stylesheet.css
While you can click OK and ignore this message and the file will open, I
would like to find a way to prevent this when this report is put into
production.
FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
Thanks.
--
DJansonI am experiencing this same error. Have you found a solution to it?
"DJanson" wrote:
> I'm exporting a matrix report generated by Reporting Services to Excel. When
> I open the report in Excel the first time, I get no messages. IF I open this
> report in Excel and click the SAVE option (whether I made changes or not),
> the next time I try to open the Excel file I get the message:
> Missing file: c:\stylesheet.css
> While you can click OK and ignore this message and the file will open, I
> would like to find a way to prevent this when this report is put into
> production.
> FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
>
> Thanks.
> --
> DJanson|||No, but I did find out that not everyone who runs/opens this report has this
problem. I sent the exported file to another user and they did not get this
message.
--
DJanson
"DJanson" wrote:
> I'm exporting a matrix report generated by Reporting Services to Excel. When
> I open the report in Excel the first time, I get no messages. IF I open this
> report in Excel and click the SAVE option (whether I made changes or not),
> the next time I try to open the Excel file I get the message:
> Missing file: c:\stylesheet.css
> While you can click OK and ignore this message and the file will open, I
> would like to find a way to prevent this when this report is put into
> production.
> FYI: I'm on Reporting Services SP2, SQL Server 2000, Excel 2003 SP1
>
> Thanks.
> --
> DJanson

Missing expansion images on Matrix Report

I've created some Matrix reports which work just fine, I'm able to drill down and the expansion images(+/-) appear correctly.

However, after setting Role security on the folder containing the reports(this is an asp.net application), the reports still function but the images for the (+/-) are missing, just getting the missing image icon.

Any ideas?

Thanks, Burl

Ok, seems the problem is with the <authorization> element in the web.config file. Changed it form <deny users="*"> to <deny users="?"> and my toggle images started working. Seems to be a security problem for the builtin resource file on the matrix report.