Thanks to everyone for the most useful advice I got in the node
requirement documents?. Hopefully, I am not imposing
too much on the Monastery by ask for some more wisdom.

The project I am working on involves acquiring data from various systems
and put it into a database, so that a set of business rules can be run
against the data. The results of the business rules are stored in the
database and reports are generated.

The questions I have are this:
• Since we have business rules should the architecture of the system
  have middle-ware?
• And if we will have middle-ware does the architecture have to be N-tiered?
• What languages should the middle-ware be written in?
• Would the middle-ware contain the business objects?
• The original "developer" implemented the business rules in PL/SQL and triggers.
  Is this a bad thing?
• I feel that our "team" should only be responsible for the back-end
  and the middle-ware so do we need to be concerned about model/view?
• Is the back-end basically a data warehouse and when combined with the middle-ware does this constitute a data mine?
• Should the business-objects contain the SQL to extract the data and manipulate it,
  then store that resulting data back to the database, or should the business objects call
  store procedures to do this?
• I am using terms correctly?
• What is a Business Rule?
• What is model/view?
• What is a data mine and a data ware house?
• And last but not least what set of documents are typical for a small developement team that is developing a N-tiered system?

And of course how can I sell my boss on using Perl for parts of this system?
I would hate to get stuck using .NET or J2EE. :)
Or should I be more open minded about these platforms?

update
I meant to say model/view not client/model view
thanks to tilly and Abigail-II for pointing that out to me.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.