Messages

1

General Board / Re: Designing stored procedures

« on: March 06, 2002, 09:03:41 am »

Thanks a lot, everyone.  I particularly like Tim's ideas for modeling the resultsets.

For now, I used a class element in a logical diagram to group sets of stored procedures as class "operations" that operated on the same logical subset of the DBs entities.  If I have time, I think I would like to go back and replace my generic "resultset" return types with class names that represent and describe these resultsets.

Thanks again,

-Peter

2

General Board / Designing stored procedures

« on: March 04, 2002, 12:31:27 pm »

Hi.

I'm in the design phase of a DB project and was wondering if anyone had any recommendations for how to diagram and document stored procedures in EA.  Basically, I want to track the name of the stored procedure, a brief description, it's input parameters and types, and it's output values and/or result sets.