Databases Reference
In-Depth Information
object and the same or [
intersecting]
effective time periods, in
the same clock tick of assertion time.
For example, let's assume that one row is a policy row that
results from a temporal insert, and the other row results from a
temporal update, and that the temporal update changes the
policy's type from HMO to PPO. Let's also assume that the clock
tick granularity chosen for assertion time is one day. Now if both
the insert and the update take place on the same day, then we
have two truth-functionally conflicting assertions. We assert,
with those two rows, that during a shared period of effective
time, the policy was an HMO policy, and was also a PPO policy.
We now have all the temporal metadata we need. Together
with the logical data model, this is all the information we need
to both generate an Asserted Versioning database, and to
manage it.
The Physical Data Model
Figure 8.8
shows the physical data model which the AVF cre-
ated from (i) the non-temporal physical data model generated by
ERwin from the logical data model shown in
Figure 8.2
, together
with (ii) the metadata shown in
Figures 8.3 through 8.7
.
Wellness_Program_Enrollment
Wellness_Program_Category
Client
client_oid: bigint
client_wellpgm_oid: bigint
eff_beg_dt: datetime
asr_beg_dt: datetime
client_oid: bigint
wellpgm_oid: bigint
wellpgmcat_oid: bigint
eff_beg_dt: datetime
eff_beg_dt: datetime
asr_beg_dt: datetime
client_nbr: char(10)
epis_beg_dt: datetime
client_nm: varchar(40)
eff_end_dt: datetime
asr_end_dt: datetime
row_crt_dt: datetime
asr_beg_dt: datetime
wellpgmcat_cd: char(4)
epis_beg_dt: datetime
epis_beg_dt: char(18)
wellpgmcat_nm: varchar(50)
eff_end_dt: datetime
asr_end_dt: datetime
row_crt_dt: datetime
wellpgm_enroll_begin_wgt: smallint
wellpgm_enroll_end_wgt: smallint
wellpgm_enroll_begin_a1c_nbr: decimal(2,1)
wellpgm_enroll_end_a1c_nbr: decimal(2,1)
eff_end_dt: datetime
asr_end_dt: datetime
row_crt_dt: datetime
Policy
policy_oid: bigint
eff_beg_dt: datetime
asr_beg_dt: datetime
policy_nbr: char(10)
epis_beg_dt; datetime
client_oid: bigint
policy_type: char(3)
copay_amt: money
eff_end_dt: datetime
asr_end_dt: datetime
row_crt_dt: datetime
Policy_Amendment
policy-amend_oid: bigint
eff_beg_dt: datetime
asr_beg_dt: datetime
Wellness_Program
Wellpgm_oid: bigint
eff_beg_dt: datetime
asr_beg_dt: datetime
policy_oid: bigint
policy_amend_nbr: char(10)
epis_beg_dt: datetime
policy_amend_txt: varchar(100)
eff_end_dt: datetime
asr_end_dt: datetime
row_crt_dt: datetime
wellpgm_nbr: char(10)
epis_beg_dt: datetime
wellpgmcat_oid: bigint
wellpgm_nm: varchar(50)
eff_end_dt: datetime
asr_end_dt: datetime
row_crt_dt: datetime
Figure 8.8 The Sample Database Physical Data Model.
