I have a web service class diagram, I want it to show what stored procedures a web method calls.
for now, I just use a class with a metod inside to represent a stored procedure, something like
storeStuff(in this, in that, out field1, out field2)
but this consumes tons of space, any tips?
or are there any better ways to do this?
thanks
so I found this http://www.agiledata.org/essays/umlDataModelingProfile.html#Figure3Keys and this http://www.agiledata.org/essays/umlDataModelingProfile.html#Figure5
wich visio does well, but you can t specify what the resultset is.
anyone got anything better?
UML part of this Question:
Represented as a Single Class with Stereotype
<<Stored Procedure>>
.
Each Stored Procedure are viewed as operations.
Source: SparkSystems on Stored Procedure subject:
http://www.sparxsystems.com/enterprise_architect_user_guide/10/database_engineering/storedprocedureindividualclass.html
Having no packages as for example Oracle has, I would create a class that has a list of stored procedures. I’d write down all their parameters. I know that it can consume a lot of space on diagrams but UML allows not show all that you have in the model. So you can see just list of procedures without parameters (although they are in model!), with types or as full list. Sparx EA allows it:
Now, how to show that a web function calls stored procedures? Again, there are more possibilities.
All is shown below. I would go for 1 and 3 because of better maintainability.
I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...
I m 查询Oracle 10g。 我有两张表格(样本数据见下文)。 i m 试图提取一些领域
We have a restaurant table that has lat-long data for each row. We need to write a query that performs a search to find all restaurants within the provided radius e.g. 1 mile, 5 miles etc. We have ...
What are some cool SQL shorthands that you know of? For example, something I learned today is you can specify to group by an index: SELECT col1, col2 FROM table GROUP BY 2 This will group by col2
I have an array of output from a database. I am wondering what the cleanest way to filter the values is example array Array ( [0] => Array ( [title] => title 1 ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...
I have a SQL-statement like this: SELECT name FROM users WHERE deleted = 0; How can i create a result set with a running number in the first row? So the result would look like this: 1 Name_1 2 ...
I’m developing an application dedicated to generate statistical reports, I would like that user after saving their stat report they save sql queries too. To do that I wrote the following module: ...