Cascade

Goal

Use cascade when

• Anonymizing one or more entries in your database across multiple tables. E.g. a "Forget me"- request
• Subsetting a database and you want to maintain consistency

Cascade is used both in deletetasks and erase tasks

• In erase tasks cascade can be used to either delete or mask child table entries
• in deletetasks cascade can only delete child table entries

Use cases for cascade

Use cascade when

• Entries in child tables must be deleted to maintain database consistency
• Entries in child tables must be anonymized

Ano Structure and Examples

Structure

task <task-name> {
    <task Type> <table> <where clause>
        cascade <distribution>
            table <parent-table>
                child <foreign-key>
                parent <key>
}

delete Example

table HOTEL
    column integer CHAIN_ID size 10
    ...
table HOTELCHAIN
    column integer ID size 10
    ...
task <task-name> {
    delete HOTEL where "ID = 0"
        ...
        cascade
            table HOTELCHAIN
                child CHAIN_ID
                parent ID

}

erase Example

table ADDRESS
    column text HOMEADDRESS size 40
    column integer CUSTOMER_CUSTOMERNO size 10
    ...
table CUSTOMER
    column integer CUSTOMERNO size 10
    ...
    primary-key CUSTOMERNO
table BANKING
    column integer CUSTOMER_CUSTOMERNO size 10
    custom integer ID
    ...
    primary-key ID
foreign-key
    ADDRESS CUSTOMER_CUSTOMERNO
    CUSTOMER CUSTOMERNO
 erase CUSTOMER
        where "CUSTOMERNO = %PARAMETER%"
        mask NAME
            format "firstname lastname"
        mask EMAIL
            format post@email.com
            transform Email
        {
            // Anonymize identifiable columns
            cascade ADDRESS
                parent CUSTOMERNO
                child CUSTOMER_CUSTOMERNO
                mask HOMEADDRESS
                    format "Home address"
        }
        {   // Delete identifiable columns
            cascade BANKING
                parent CUSTOMER
                child CUSTOMER_CUSTOMERNO
        }