Anticlue

Data Storage in Mach II

I've been doing some thinking and research in storing data utilizing the mach-ii frameworks.

Data mechanisms are either transactional (data entry) or dimensional (reporting) and if you have a good db designer that processing can be handled in the database. I also believe it should be, since relational db's were created for that functionality.

So how do you link the db to your cfc's in the model? My understanding of the model is that it contains the business logic and rules in objects. For a simple system, it makes sense to have the atomic CRUD operations contained within the object itself. In a complicated system encapsulating the data manipulation and separating the business logic from the data processing, has many benefits.

In my readings, I?ve come across a book, Patterns of Enterprise Application Architecture, which addresses the big picture of application architecture focusing on web development. It helped to clear up my data handling thoughts.