PL/SQL Transactions   «Prev 

Data Integrity Telephone Billing Example

Data integrity telephone billing example
1) In this imaginary telephone billing system, thousnds of records are processed at the end of each billing cycle.
The records are collected from many diverse sources and brought to the central billing system. Let us say that there is an invalid record in the middle of Jody Smtih's records.

Data integrity--telephone billing example

Data integrity--telephone billing example
3) The procedure processes each record, adding the record to a history table and then updating the summary record for the summer's monthly billing statement

Data integrity--telephone billing example
4) The invalid record causes the rpocedure to stop, leavig all the previous customer's records plus some portion of Jody Smith's records in the database. At this point dataintegrity has been compromised.