Databases Reference
In-Depth Information
Tabl e 5. 3
CBTR schema changes for the third normal form schema variant
Replacement
table
Replacement
column
Origin table
Removed column
Affected queries
Derivable data
Sales header
Net value
Sales item
Sum of all net
values
Sales order,
orders by
period, daily
flash
Shipping header
Net value
Shipping item
Sum of all net
values
Shipping
Billing header
Net value
Billing item
Sum of all net
values
Billing, DSO
Redundant data
Sales header
Division
Product data
Division
Processing time,
delivery
fulfillment,
sales order
Sales item
Division
Product data
Division
Sales order
Document
currency
Sales header
Document
currency
Order by key,
sales order
Shipping header
Document
currency
Sales header
Document
currency
Shipping
Sales organization
Sales organization
Shipping item
Sales organization
Sales header
Sales organization
Sales item
description
Sales item
Sales item
description
Product ID
Product ID
Product hierarchy
Product hierarchy
Sales unit
Sales unit
Material type
Product data
Material type
Division
Division
Billing header
Billing date
Shipping header
Billing date
DSO, billing
Division
Product data
Divison
Billing
Country of
destination
Customer data
Country
Billing item
Sales item
description
Sales item
Sales item
description
Product ID
Product ID
Product hierarchy
Product hierarchy
Sales unit
Sales unit
Division
Product data
Division
Of the read-only OLTP queries, only order by key and orders by period have to be
adapted. A simple exchange of the selection of currency from the sales item table
to the same-titled column of the sales header table is carried out. Both tables are
already used in the statement in its original form. In the orders by period query, a
join to the sales item table via the order ID and a grouping by order ID are added to
compute the sales order net value. The changes to the syntax for the query statement
Search WWH ::
Custom Search