Similarity between Database Objects and ADF Business Components

Oracle ADF is an Application development framework for Rapid Application Development. Oracle ADF uses Business components in the Model Layer to perform the transactions. ADF Business components are similar to Database Objects.

Suppose we have to create a database to store Department and Employee data in the database. For this, we will have to create two tables DEPARTMENTS and EMPLOYEES where DEPARTMENTS will be a master and EMPLOYEES will be detail table.

For the above scenario, we will have to do the following in the database.

1. Create table DEPARTMENTS.
2. Create table EMPLOYEES.
3. Create a Foreign Key between DEPARTMENTS and EMPLOYEES to establish a master-detail relationship.
4. SQL Query to perform DML operations i.e Create, Read, Update and Delete operations.

 If we have to create an ADF application for viewing and updating the above database structure then the following Business Objects will be created.

1. Entity Object "DepartmentsEO" to represent the DEPARTMENTS Table.
2. Entity Object "EmployeesEO" to represent the "EMPLOYEES" Table.
3. Association "DeptToEmpAS" to represent the Foreign Key relationship.
4. ViewObject "DepartmentsVO" and "EmployeeVO" to represent the SQL queries to represent DEPARTMENTS and EMPLOYEES tables respectively.

 In short, we can understand the similarity with the image below.