Process Support Database Framework

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 Leo Peysakhovich » Process Support Database Framework

14 posts, Page 2 of 2

««1 2

Process Support Database Framework

Rate Topic

Display Mode

Topic Options

Author

Message

jbnv

Posted Friday, January 27, 2012 7:35 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:37 AM
Points: 63, Visits: 425

Unfortunately, the code I developed is the property of my employer, so I'm not at liberty to share it. I would be interested in helping to develop an open-source solution. My solution is currently entirely in T-SQL that is copied into each database, but I'm looking at using SQL Server Management Objects to reduce the amount of T-SQL used.

Jay Bienvenu | http://bienv.com | http://twitter.com/jbnv

Post #1242852

Jon Saltzman

Posted Friday, January 27, 2012 4:39 PM

Valued Member

Group: General Forum Members
Last Login: Friday, November 02, 2012 3:20 PM
Points: 51, Visits: 136

jbnv, are you serious about working on an open source version? Do you think it is worthwhile?

I've actually been trying to build a SQL/table based workflow engine with a similar design for years, and have long contemplated open sourcing what I have so far, frankly because I don't have time to finish it and turn it into a commercial product, and secondly because nobody I knew showed any interest or support.

Personally, I love this little framework I was hacking on - and I like yours too. It's a pretty generic pattern actually, but it can do so many things.

I got so far as to be able to render workflow graphs from the database, and handle branching, multiple statuses, etc. and it was modeled *very* roughly after Petri nets.

This same framework is totally reusable all over the place too, not just in ETL.

Thoughts? Anybody else interested?

Post #1243175

SQLNightOwl

Posted Saturday, January 28, 2012 8:53 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 22, 2013 3:55 PM
Points: 179, Visits: 391

I'd be interested in throwing in on an open source effort. I agree that it can do much more than only SSIS. I look forward to sharing my ideas on this project.

--Paul Hunter

Post #1243218

jstone923

Posted Saturday, January 28, 2012 11:47 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:30 PM
Points: 9, Visits: 97

I would also love to participate in such a project. I think this type of framework would establish some great control yet allowing flexiblity and encouraging TEAM development on projects in any group. The analytics group I have supported for the last 6 years has technical "savvy", in that they have incredible vision to get data-driven projects off the ground, and enough SQL server skills to get themsevles killed, but they don't have a processing framework in which they can "plug-in" to. What ends up happening instead is alot of "satellite" processes in which I end up supporting, which leads to unnecessary data redundancy and server contention due to "duct-taped" architecture and processes.

Does anyone have any source code that is similar to Leo Peysakhovich's ERD?

Any help would greatly be appreciated!

Regards,

Jordan M. Stone
Wells Fargo - Capital Markets
jstone923@hotmail.com
jordan.m.stone@wellsfargo.com
314-719-1325

Post #1243233

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions