1、Transaction Script
Organizes business logic by procedures where each procedure handles a single request from the presentation.
The Transaction Script pattern has the following benefits and drawbacks.
----Easy to use
----Can use full range of SQL features
----Code can be difficult to understand and maintain
----Cost of maintaining handwritten SQL
----Lack of portability of SQL
When to use the Transaction Script pattern
----The application must use SQL directly
----A persistence framework is unavailable
----The business logic is very simple
----The development team doesn’t have OO design skills
example diagram
2、Domain Model
An object model of the domain that incorporates both behavior and data
3、Table Module
A single instance that handles the business logic for all rows in a database table or view.
4、Service Layer
Defines an application's boundary with a layer of services that establishes a set of available operations and coordinates the application's response in each operation.