Modeling transactions

Delta Snapshot Interface The delta snapshot is a commonly used interface for reference data, such as a customer master list. The basic delta snapshot would contain a row or transaction that changed since the last extraction. It would contain the current state of all attributes without information about what, in particular, had changed. This is the easiest of the delta interfaces to process in most cases. Since it contains both changed and unchanged attributes, creating time-variant snapshots does not require retrieval of the previous version of the row. It also does not require the process to examine each column to determine change, but rather, only those columns where such an examination is necessary. And, when such examination is necessary, there are a number of techniques discussed later in this chapter that allow it to occur efficiently with minimal development effort. Transaction Interface A transaction interface is special form of delta snapshot interface. A transaction interface is made up of three parts: an action that is to be performed, data that identifies the subject, and data that defines the magnitude of the change. Atransaction interface is always complete and received once. This latter characteristic differentiates it from a delta snapshot. In a delta snapshot, the same instance may be received repeatedly over time as it is updated. Instances in a transaction interface are never updated. The term should not be confused with a business transaction. While the characteristics are basically the same, the term as it is used here describes the interaction between systems. You may have an interface that provides business transactions, but such an interface may be in the form of a delta snapshot or a transaction interface. The ways that each interface is processed are significantly different.

pdf46 trang | Chia sẻ: tlsuongmuoi | Lượt xem: 1871 | Lượt tải: 0download
Bạn đang xem trước 20 trang tài liệu Modeling transactions, để xem tài liệu hoàn chỉnh bạn click vào nút DOWNLOAD ở trên

Các file đính kèm theo tài liệu này:

  • pdfmastering_data_warehouse_design_relational_and_dimensional_techniques00007_9145.pdf
Tài liệu liên quan