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

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?

A HR application need data about employees in many different ways. RCM
already gave you one example of a very specific criteria for finding
employees. When a company needs to reduce the staff, it would be nice
if the HR application had a feature to find employees eligible for
early retirement, wouldn't it? It is easy to imagine other examples of
very specific ways of finding employees. Lets say we want to send every
manager an email containing the employees having 30-, 40-, 50-year
birthday next month. Lets say we have a function sending information to
insurance company about changes in salaries, we need a way to find
employees with changed salary. How could you possible solve this only a
few functions for finding employees?

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.

Are there any significant difference between producing data on a paper,
displaying it on a computer screen or using it in a thread sending
e-mails? I have seen systems like you describe above. The only way to
access a lot of the information was to print it, or get it as a large
PDF-file. It so 60's.

If there really was a requirement for ad-hoc getEmployee() methods

What's ad-hoc about set theory and predicate logic?

Fredrik Bertilsson
http://mybase.sf.net

.

Relevant Pages

  • Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
    ... if the HR application had a feature to find employees eligible for ... Perhaps the IT department could keep track of the requests it gets and create a most-frequently-asked-for reports page? ...
    (comp.object)
  • Re: Critique of Robert C. Martins "Agile Principles, Patterns, and Practices"
    ... every different way you might need to fetch employee data? ... A HR application need data about employees in many different ways. ... very specific ways of finding employees. ...
    (comp.object)
  • Re: Still Struggling...
    ... While I agree in general about empty fields, there are reasonable exceptions to the rule. ... aren't the normal kind. ... fields in the Employees table", but I was just being lazy. ... forms and reports (when you ...
    (microsoft.public.access.gettingstarted)
  • Re: Subform based on one table
    ... Your Staff table should have a primary key, and a foreign key for the person ... Right-click the edge of the subform control, ... > I have an employees list. ... > his title and who he reports to. ...
    (microsoft.public.access.forms)
  • Re: "Executive Summary" report
    ... my other reports! ... Assume an "Employees" worksheet: ... (I'm using Excel 2004 from the Mac version, ... Pointers, hints, or suggestions would be great, as ...
    (microsoft.public.excel)