Profiling and Discovery Sizing Guidelines

Back Next

Profiling Warehouse Guidelines for Enterprise Discovery

Enterprise discovery automates the profiling functions it runs. The required profiling warehouse resources are the sum of the resources for the individual functions.

Enterprise discovery automates the following profile functions:

Column profile with no data caching

Data domain discovery

Primary key discovery

Foreign key discovery

In the following worksheet, use the formula in the Calculation column to enter the metric values in the Value column.

Use the following worksheet to record the values:

Metric	Calculation	Value
Book-keeping overhead	-	100, 000
Column profile	Average number columns for each table X number of values X (average value size + 64)
Data domain discovery	2 X number of columns X number of domains X 254
Primary key discovery	Average number of keys for each table X average number of key columns X 32 + number of keys X ( 32 + (2 bytes for each character X average column size ) X average number of key columns X average number of violating rows
Signatures	Average number columns for each table X 3600
Foreign key discovery	Average number of foreign keys for each table x 2 X (average number of key columns) X 32 + number of foreign keys X ( 32 + (2 bytes for each character X average column size ) X average number of key columns X average number of violating rows

Calculation

To estimate the profiling warehouse resources based on average size estimates, perform the following steps:

Add the values for book-keeping overhead, column profile, data domain discovery, primary key discovery, signatures, and foreign key discovery.

Multiply the result value in step 1 with the total number of tables in enterprise discovery.

Rename Saved Search

Table of Contents

Profiling and Discovery Sizing Guidelines

Profiling and Discovery Sizing Guidelines

Profiling Warehouse Guidelines for Enterprise Discovery

Profiling Warehouse Guidelines for Enterprise Discovery