Architecture

Architecture

Chapter 3, Computer Science

To make the artificial brain happen, we are using MS SQL 2008 to create a table that defines individual neurons. The schema looks like:

USE [BrainMap]
GO

/****** Object: Table [dbo].[Cortex] Script Date: 10/18/2009 14:20:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Cortex](
[FunctionalArea] [varchar](10) NOT NULL,
[NeuronX] [int] NOT NULL,
[NeuronY] [int] NOT NULL,
[NeuronZ] [int] NOT NULL,
[NTime] [datetime] NULL,
[NHit] [smallint] NULL,
[NValue] [smallint] NULL,
[NLearn] [smallint] NULL,
[LinkAFunctionalArea] [varchar](10) NULL,
[LinkAX] [int] NULL,
[LinkAY] [int] NULL,
[LinkAZ] [int] NULL,
[LinkAIP] [varchar](50) NULL,
[ValueA] [smallint] NULL,
[LinkBFunctionalArea] [varchar](10) NULL,
[LinkBX] [int] NULL,
[LinkBY] [int] NULL,
[LinkBZ] [int] NULL,
[LinkBIP] [varchar](50) NULL,
[ValueB] [smallint] NULL,
[LinkCFunctionalArea] [varchar](10) NULL,
[LinkCX] [int] NULL,
[LinkCY] [int] NULL,
[LinkCZ] [int] NULL,
[LinkCIP] [varchar](50) NULL,
[ValueC] [smallint] NULL,
[LinkDFunctionalArea] [varchar](10) NULL,
[LinkDX] [int] NULL,
[LinkDY] [int] NULL,
[LinkDZ] [int] NULL,
[LinkDIP] [varchar](50) NULL,
[ValueD] [smallint] NULL,
[Link1FunctionalArea] [varchar](10) NULL,
[Link1X] [int] NULL,
[Link1Y] [int] NULL,
[Link1Z] [int] NULL,
[Link1IP] [varchar](50) NULL,
[Value1] [smallint] NULL,
[Link2FunctionalArea] [varchar](10) NULL,
[Link2X] [int] NULL,
[Link2Y] [int] NULL,
[Link2Z] [int] NULL,
[Link2IP] [varchar](50) NULL,
[Value2] [smallint] NULL,
[Link3FunctionalArea] [varchar](10) NULL,
[Link3X] [int] NULL,
[Link3Y] [int] NULL,
[Link3Z] [int] NULL,
[Link3IP] [varchar](50) NULL,
[Value3] [smallint] NULL,
[Link4FunctionalArea] [varchar](10) NULL,
[Link4X] [int] NULL,
[Link4Y] [int] NULL,
[Link4Z] [int] NULL,
[Link4IP] [varchar](50) NULL,
[Value4] [smallint] NULL,
[Link5FunctionalArea] [varchar](10) NULL,
[Link5X] [int] NULL,
[Link5Y] [int] NULL,
[Link5Z] [int] NULL,
[Link5IP] [varchar](50) NULL,
[Value5] [smallint] NULL,
[Link6FunctionalArea] [varchar](10) NULL,
[Link6X] [int] NULL,
[Link6Y] [int] NULL,
[Link6Z] [int] NULL,
[Link6IP] [varchar](50) NULL,
[Value6] [smallint] NULL,
[Link7FunctionalArea] [varchar](10) NULL,
[Link7X] [int] NULL,
[Link7Y] [int] NULL,
[Link7Z] [int] NULL,
[Link7IP] [varchar](50) NULL,
[Value7] [smallint] NULL,
[Link8FunctionalArea] [varchar](10) NULL,
[Link8X] [int] NULL,
[Link8Y] [int] NULL,
[Link8Z] [int] NULL,
[Link8IP] [varchar](50) NULL,
[Value8] [smallint] NULL,
[Link9FunctionalArea] [varchar](10) NULL,
[Link9X] [int] NULL,
[Link9Y] [int] NULL,
[Link9Z] [int] NULL,
[Link9IP] [varchar](50) NULL,
[Value9] [smallint] NULL,
CONSTRAINT [PK_Cortex] PRIMARY KEY CLUSTERED
(
[FunctionalArea] ASC,
[NeuronX] ASC,
[NeuronY] ASC,
[NeuronZ] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

Schema 3.1 Data Schema

Schema 3.1 is comprised of 4 different sections:

Functional Area and the Cartesian coordinates of the Neuron.
The Temporal and Weight values.
The Single connection neurons.
Matrix neuronal connections.

Return to Scope || History || Download || Contacts || Home