Re: Critique of Robert C. Martin's "Agile Principles, Patterns, and Practices"

frebe73@xxxxxxxxx wrote:
<snip>

No, of course I would use the database to fetch the data I want. I'd
make sure that a well structure SQL statement was used against a
well-normalized database. Who wouldn't?

You claim that it is possible to only have a few number of
getEmployeeBySomeCriteria methods with optimized SQL statements for
every different way you might need to fetch employee data? That should
only be possible for rather small applications.

Can you give an example of an application that would have an excessive number of getemployeBySomeCriteria() methods that doesn't encroach on becoming a report writer? All our reports have been implemented as stored procedures and have been meticulously crafted to perform well and balance to other reports. There are many similarly-named reports but the user doesn't really see that because they navigate through the data starting at the top-level and drilling-down.

If there really was a requirement for ad-hoc getEmployee() methods than an ad-hoc or report-writing tool is needed--and that's a different kind of application than a business application like accounting, mortgages, finance, statements, etc... don't you think?
Then I would hide that SQL statement behind an interface so that the
rest of my application was unaware of it.

And the benifits are?
Plentiful. Didn't we discuss this in "Databases as objects?" The biggest difference between Martin's and my approaches in this area is my belief the system starts with the data model and his starts with an behavioral model. Mind you, that's not a trivial difference...

--
Visit <http://blogs.instreamfinancial.com/anything.php> to read my rants on technology and the finance industry.
.

Relevant Pages

  • Re: Challenge: SQL STMT for Retrieving Content(SQL) of Saved Queries
    ... > db.QueryDefs.SQL is probably only for SQL statement ... the object model for reports and queries is completely ... Dim strTemp As String ... For Each obj In CurrentProject.AllReports ...
    (comp.databases.ms-access)
  • RE: Software installed in Add/Remove Programs
    ... Q. When my web reports contain a column that has more than 5000 records I ... You might need to adjust the AspBufferingLimit setting. ... I've tried the sql statement and it works only if you have a small ...
    (microsoft.public.sms.inventory)
  • Re: Filling a combo box with names of reports
    ... The sql statement I have posted in the combo box's row source is not a ... Here is both the row source and your code: ... Since I will often reuse reports (use them for different purposes ... reports and subreports (for instance one subreport for usage in the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Really and Import Question
    ... It is possible that you got some corruption on a query that is common to the ... See if you can open the query or sql statement associated ... with those reports. ... > get to the Importing Exporting section. ...
    (microsoft.public.access.forms)
  • Re: SQL & VB
    ... Often my record source is an SQL statement. ... table to hold records for reports, and an additional field to hold the ... Does your current method work? ...
    (microsoft.public.vb.general.discussion)