Application Development Frameworks

Application development framework: A pragmatic “best-possible” solution

For a transactional solution

For a reporting and analysis solution

Master error management framework

Performance tuning framework

Debugging framework

Application development frameworks provide for a standard template for implementing a particular task. Examples of PL/SQL tasks that call for such templates include error logging and performing ETL (extract, transform, load) operations using PL/SQL. The framework provides both the design and code development features that can be used to implement the task in the best possible manner suitable for the application requirements (such as business or functional requirements that the application is targeted to) and criteria (such as functional and technical feature/product-specific factors that need to be taken into consideration while implementing the business rules as per the application requirements) in question. The sections that follow discuss frameworks for four different tasks that are frequently implemented in most PL/SQL applications-error logging, DML auditing, ETL, and performance tuning.