QueryingTemporalData - ANNUAL_SALARY BIRTH_DATE Positions...

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Querying Temporal Data
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Querying State Extracting Current State Extracting Sequenced State Extracting Nonsequenced State
Background image of page 2
Modifying Temporal State Updating and Deleting Current Sequenced Nonsequenced
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Use the PDF Book and the CDROM We are going to be going through Chapters 6 and 7 in the book We are going to use a mixture of the book pdf, and the material provided on the cdrom Get the book pdf and the cdrom zip and put it where you can find and use it I will do this in class
Background image of page 4
Tables See the files creattab and cttabtmp in directory cdrom/vtstbl/sybase For definitions of the tables used in the examples It might be best to use the .html file in the sybase directory to look at code samples and table structures
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Employees SSN LAST_NAME FIRST_NAME
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 10
Background image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ANNUAL_SALARY BIRTH_DATE Positions PCN JOB_TITLE START_DATE END_DATE INCUMBENTS SSN PCN START_DATE END_DATE SAL_HISTORY SSN AMOUNT HISTORY_START_DATE HISTORY_END_DATE Starting Chapter 6 Page 143 (167) Using the infinite end time technique Page 144 (168) What is CURRENT_DATE This is pseudo code for whatever the current server vendor provides as a function to get the current date On Sybase it is getdate()-See the code fragment 6.2 There is an error in the book (or in the code fragment (< vs. <=) Closed-open issue? Prior States Prior is not Current Prior and Current are State at a Particular Point in Time See book...
View Full Document

This note was uploaded on 06/20/2011 for the course CSC CSC5921 taught by Professor Albert during the Spring '11 term at University of Colorado Denver.

Page1 / 11

QueryingTemporalData - ANNUAL_SALARY BIRTH_DATE Positions...

This preview shows document pages 1 - 11. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online