DAO

About

Also known as TDG (Table Data Gateway), it is a Table oriented pattern. (Oriented to Database a table)

This pattern is intended to interact with your Database tables and return table records.

Following this pattern at risk, DAO methods should not JOIN too many tables.

Too many JOINs allows you to create too many table combinations, thus losing the expected data returned.

Ex.: What do you espect of an Employee DAO? You expect returned data to be of Employees, not Employees and Branches data, or Employees and Roles data.