O'Reilly logo

Enterprise Application Integration With XML and Java™ by Bill la Forge, JP Morgenthal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required