A Neural Network in SQL Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Silvia Cobialca » A Neural Network in SQL Server

26 posts, Page 1 of 3

1 2 3 »»»

A Neural Network in SQL Server

Rate Topic

Display Mode

Topic Options

Author

Message

Silvia Cobialca

Posted Monday, October 26, 2009 11:22 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 08, 2012 9:07 AM
Points: 5, Visits: 97

Comments posted to this topic are about the item A Neural Network in SQL Server

Post #809090

Posted Monday, October 26, 2009 11:27 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 11, 2013 12:58 AM
Points: 174, Visits: 555

i had a tough time building a neural network. i used mathematical functions to 'amplify', update then recast the result prior to output. it seemed the training would never end.

close to the end, i was thinking of allowing decimal values instead of integer values. i was maybe thinking, with decimal values it would look fuzzy enough to be accurate.

i had moved on to another company, leaving the project and with a heavy 'agreement of silence' signed just so i could leave clean.

Post #809093

Mark G.

Posted Tuesday, October 27, 2009 2:30 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, March 28, 2013 10:08 AM
Points: 29, Visits: 44

Great and unusual article related to database. Would it be possible to share the source code?

Cheers

Post #809136

isaac-609925

Posted Tuesday, October 27, 2009 4:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 28, 2012 5:10 AM
Points: 2, Visits: 22

Very ineresting, and very well explained.
Looking for the next session - can you share the source ?

Thanks

Isaac

Post #809183

Silvia Cobialca

Posted Tuesday, October 27, 2009 5:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 08, 2012 9:07 AM
Points: 5, Visits: 97

Thanks for you comments.
I will elaborate on the code and how it works in an incoming article, where I'll include the training and testing of the network

Silvia

Post #809196

Michael Martin-492204

Posted Tuesday, October 27, 2009 5:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 05, 2009 1:16 PM
Points: 2, Visits: 9

Hi Silvia: Thanks very much for sharing your methodology, and am really interested in reading your next posting! I've had some success emulating NNs in Excel, but scale becomes an issue eventually. Best Wishes, Michael

Post #809197

mjwehr

Posted Tuesday, October 27, 2009 5:55 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, January 07, 2011 3:12 PM
Points: 10, Visits: 24

Thank you for sharing! Well written and understandable for me.
I am just starting to use SQL Server 2005/2008 as a tool specifically for developing data storage design to be used in predictive analysis as the end goal.
I am very happy to be able to get some insight to the development this early in the journey! MJWehr

Post #809228

Martin Vrieze

Posted Tuesday, October 27, 2009 6:28 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, December 07, 2010 8:19 AM
Points: 327, Visits: 123

I am aware that SSAS has full blown Econometrics built into the SSAS package capable of performing more than just neural nets...we're talking a full slate of linear regression/non-linear regression/discrete choice/arima/two-stage least squares/vector auto regression/co-integration...everything you would find in SAS or SPSS.

At the end of the day, you still need to get the data into the SSAS tool which is amazingly difficult...and why SQL Server is not a first choice among data analysts for handling statistical analytics.

Post #809242

Jonathan AC Roberts

Posted Tuesday, October 27, 2009 6:29 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 9:15 AM
Points: 316, Visits: 1,185

I can see that you can do this using SQL server but I fail to see any benefit to using SQL Server rather than wirting some code using a normal computer language like C.
Surely it is much slower using SQL Server?

Post #809244

sknox

Posted Tuesday, October 27, 2009 9:17 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:31 AM
Points: 1,040, Visits: 1,356

jacroberts (10/27/2009)

First, I take offense at your characterization of SQL as not a "normal computer language" -- unless, of course, you mean that it's above normal. Second, I laugh at your characterization of C as normal in any way. Tongue

On a serious note, sometimes programming isn't about performance, or even about successfully accomplishing a task, but about learning. From the introduction to the article, it's clear that Silvia wasn't trying to create the most efficient or useful neural network, but more interested in how two programming concepts (a relational database and a neural network) might be brought together.

Also, bear in mind that many organizations can justify a SQL programmer where they can't justify a .NET or C programmer -- and they may benefit greatly from a neural network in SQL.

Post #809390

« Prev Topic | Next Topic »

26 posts, Page 1 of 3

1 2 3 »»»

Permissions