How To Create a Table With Matrix and Vector

Creating a table with Matrix and Vector data types.

Creating a Table to do Principal Component Analysis

NOTE: Matrix and Vector will be on TEXTIMAGE_ON filegroup.

SQL

USE [SQX]
GO

CREATE TABLE [dbo].[PCA](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Created] [datetime] NOT NULL DEFAULT (GETDATE()),
[Description] [nvarchar](4000) NULL,
[COV] [sqx].[Matrix] NULL,
[COR] [sqx].[Matrix] NULL,
[TRANSCORCOV] [sqx].[Matrix] NULL,
[MEANDEV] [sqx].[Matrix] NULL,
[EIGENVECTORS] [sqx].[Matrix] NULL,
[EIGENVALUES] [sqx].[Vector] NULL,
[VAREXPLAINED] [sqx].[Vector] NULL,
[MEANS] [sqx].[Vector] NULL,
[STDEVS] [sqx].[Vector] NULL,              
[MINMAX] [sqx].[Matrix] NULL,
[DATA] [sqx].[Matrix] NULL,
CONSTRAINT [PK_PCA] PRIMARY KEY CLUSTERED
([ID] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF
, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON
, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

Reference

SQX