6.3. The Example
Let's use a simple example to work in the concrete. The following is an employee database with three tables. EMPLOYEE stores personal information and a summary of the term of the relationship. PERF_REVIEW stores performance reviews given to the employee. COMP_CHANGE stores changes to compensation resulting (usually but not always) from a performance review.
TABLE EMPLOYEE NUM LONGINT PRIMARY KEY FNAME STRING 32 LNAME STRING 32 HIRE_DATE DATE TERM_DATE DATE MAY BE NULL TABLE PERF_REVIEW EMP_NUM LONGINT PRIMARY KEY FOREIGN KEY REVIEW_DATE DATE PRIMARY KEY REVIEW TEXT TABLE COMP_CHANGE EMP_NUM LONGINT FOREIGN KEY REVIEW_DATE DATE MAY BE NULL EFF_DATE DATE SALARY INT
At its simplest, an XML document of information drawn from this ...
Get Enterprise Application Integration With XML and Java™ now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.