Tablealias

From JACOBWiki

[edit] What is a „Table Alias" in the context of jACOB?

First of all jACOB is divided into three different layers.

A ’Table Alias’ is part of the ’Data Abstraction Layer’ and is a reference to a physical database Table.

Why is it a fundamental part in jACOB to define „Table Aliases"?

If you are familiar with SQL, the following statement will help to find the answer:

SELECT manager.name, employee.name FROM person AS employee INNER JOIN person AS manager ON employee.managerID = manager.personID;

If you want to handle the command structure of a company (stored in

the table person') you must define two aliases employee and manager

to represent them in one form.

The logical database layer of jACOB loads the records from the table person and stores them in the alias employee and manager. The presentation layer retrieves this records and display them in the UI.