DWLOGIC (Data Warehouse Logic, LLC) specializes in Architecture of Data Warehouse Systems. Site Map
Contact Us

Data Profiling

One of the common problems in any data integration and data warehouse project is to understand the source data. The data warehouse consists of data from different internal and external objects. These objects are sometimes poorly documented or their ERD is not available. Furthermore, the source objects are often not from the same single native source.
In many cases analyzing the sources and understanding the relationship between the objects is the Achilles‛ heel of the process.
Since analyzing the source is a complicated and expensive task, it is often postponed to " . . . when there will be more time and budget . . . " which usually results in this critical step being only partially completed or skipped altogether. The consequence is that the data integration is performed without sufficient knowledge of the data.
In addition, since the data profiling process is often skipped, no reverse ERD is created to support the integration process.
Therefore, it is most likely that poor (or no) data source profiling is the main reason for failures of data warehouse projects. The lack of visual models creates a barrier between the business customer and the technical team and between the target ODS and its sources.

Since the data source profiling and visual reversed ERD model is a fundamental step of the data warehouse, DWLOGIC developed a profiler-ERD-Engine mechanism. It is designed to almost automatically support the entire process ranging from gathering the data sources via data profiling, to breaking down the "pseudo" ERD model to subject areas.

Below are the profiler-ERD-Engine steps (on a macro level):

Step 1: Loading multiple data sources into the Profiler repository (ERD-Engine).
The purpose of this step is to unify all the source objects from the different data sources into a single schema in order to be able to analyze the spread sources as if they were one single source.


Step 2: Analyzing the individual source objects. Calculating statistics and identifying unique keys and "near" unique keys.
The purpose of this step is to collect metadata information about the individual source objects.


Step 3: Calculating potential FKs or partial FKs between the input objects.
This step would be finalized manually to minimize false positive FKs results. The clean version would be followed by reversing the objects and the RIs to a "pseudo" ERD model.
The purpose of this step is to create a "pseudo" ERD to simulate a source OLTP ERD that acts as a single source.


Step 4: Suggesting options to break the reversed "pseudo" ERD into subject areas for better visualizing of the source data.
The purpose of this step is to break the "pseudo" ERD into subject areas in order to simulate different business areas and allow an easier reading and understanding of hundreds of objects.

buy viagra cheapest best prices online
buy generic viagra online
guaranteed cheapest viagra
buy viagra per pill
buy viagra cheaply
buy cheap levitra
viagra rrp australia
buy viagra order viagra
ordering cialias
viagra online uk
cialis coupons
buy now levitra
where can I buy cialis 20mg
cheap deal viagra
buy in uk viagra
buy viagra online off pharmacy prices
try viagra for free
viagra suppliers in the uk
buy viagra online
buy viagra over the counter
viagra and cialis cheap
viagra and hearing loss
buy real viagra pharmacy online
viagra professional
buy sildenafil viagra
buy levitra canada
buy viagra prescription
cheap discount viagra viagra
buy generic viagra viagra
buy cialis now
buy viagra onli
cheap genric viagra online
viagra quebec
buy female viagra
buy viagra onlines
buy viagra online at
buy say viagra
brand cialis 20
uk viagra sales
buy real viagra online
cheap viagra canada
natural viagra
buy viagra online paypal
generic viagra
buy now online viagra
ebay + cialis
cheap cialis overnight
viagra uk cheap purchase buy
buy cialis online
ordering viagra onl
buy lexapro
key buy-viagra
buy in online uk viagra
buy low price viagra
cheap levitra online
buy no online prescription viagra
lowest price viagra
buy viagra online au
marijuana and viagra
cheap generic overnight viagra
buy viagra cialis levitra
india viagra cialis vicodin
cheapest uk supplier viagra
cheap no prescription viagra
cheap pharmaceutical viagra
buy viagra online and get prescription
purchase viagra online
viagra alternatives
buy cheap viagra online
cialis voucher
cheap free viagra viagra
cheap prescription viagra
homemade viagra
cheap herbal viagra
cheap viagra generic
cheap generic india viagra
buy online online viagra viagra
buy viagra
non prescription viagra
cialis overnight shipping
buy viagra other drug online
buy viagra cheapest
cheap viagra without a prescription
buy viagra online now buy viagra
buy discounted viagra
buy now cialis
does watermelon have viagra effect
buy real viagra
cheap generic viagra worcester imc
buy viagra online get prescription
cheap viagra in the uk
buy discount viagra viagra viagra
buy viagra powered by phpbb
cost of viagra
cheap generic viagra substitutes
is viagra safe for women
buy viagra online u
viagra over the counter walgreens
buy cialis no prescription
cheap generic substitute viagra
viagra price in india
cheap kamagra uk viagra
cheap man viagra
cheap discount levitra online
walmart cialis price
buy viagra online cheapest
buy line viagra where
buy in online usa viagra
buy now viagra
buy viagra on the internet
cheap sale viagra
viagra without prescription
cialis no perscription
buy 100 mg viagra
cheap generic viagra no script
female viagra
buy viagra online india
buy kamagra viagra india
buy line viagra
buying viagra online
cheap viagra tablets
viagra generic
brand cialis
buy levitra now
free viagra in the uk
cheap generic online viagra
cipro 20
cheap free price viagra
cheap discount viagra
viagrafree samples
viagra coupons and discounts
cheap inexpensive viagra
buy viagra Australia
buy online levitra cialis viagra
viagra and cialis and
buy nexium
buy generic viagra
buy viagra online at lowest price
buy viagra online discount
viagra super active
cheap site viagra
alternative to viagra
buy viagra usa
buy duscount viagra online
canadian levitra vs usa levitra
buy viagra online without prescription
cheap drugs viagra cialas
buy cheap tamiflu
buy discount viagra
cheap drug viagra
shipping viagra to australia
buy viagra online in australia
viagra pro online
viagra pfizer
cheap cialis online
real viagra
buy viagra overnight
buy viagra pills
price of viagra
buying viagra in uk
buy viagra internet
q buy viagra online
buy get online prescription viagra
buy viagra online online pharmacy
viagra and cialis
buy discount soma
buy online drug viagra pharmacy
buy viagra 50mg
cheap generic viagra overnight delivery
buy online online pill viagra viagra
cheap price viagra
buy viagra online no prescription
buy viagra pharmacy online
cheap generic viagra no prescription
cheap prescription viagra without
buy sale viagra
viagra rrp australia cost
buy prescription vaniqa viagra
ed pro trial pack
cheap generic 50 mg viagra
cheap viagra viagra
viagra dosage
levitra 100mg uk
buy viagra online at cheap price
viagra sample
buy viagra alternative
ed. trusted medstore in cialis
cheap free viagra
cheap generic viagra
free viagra
buy viagra online in
cheap herbal viagra viagra
generic viagra from india
accutane for sale online
cheap generic viagra from usa
cheap viagra fast shipping
buy site viagra
cheap molde ticket viagra
buy viagra cialis
cialis no prescription
cheap pill pill sale viagra
buy viagra online order
cialis vs viagra
buy viagra online uk
buy internet viagra
buy kamagra viagra
cialis replacement
buy viagra online in the uk
cheap kamagra viagra
buy generic viagra buy
viagra uk
cheap generic viagra uk
free viagra without prescription
cheap generic viagra substitute
cheap india viagra
watermelon viagra
buy cymbalta
uninsured cost of cialis
free viagra sample
cialis super active review
buy cheap cialis
buy viagra now
buy real viagra online pharmacy
cheap generic viagra online
buy price viagra
cheap soft tab viagra
buy viagra online in uk
buy viagra online a href
viagra for sale
buy cialis canada
cheap viagra india
cheap phizer viagra
buy viagra online order generic viagra
viagra free trial offer
buy viagra over the counter us
buy generic viagra img
buy locally viagra
generic levitra
buy viagra montreal
over the counter viagra
buy viagra prescription america
purchase levitra
female use of viagra
buy cheap viagra online uk
cheap meltabs viagra
cheap mexico viagra
buy prescription viagra
buy generic viagra usa
viagra oral
buy cheap viagra
buy viagra online pharmacy
viagra oral jelly
cheap viagra in uk
buy viagra pill
where to buy viagra in beijing
buy viagra online canadapurchase cialis
cheap discount cialis
viagra for sale without a prescription
buy viagra online paypal vipps
buy viagra and cilas
buy generic viagra online pharmacy online
cheap viagra online canada
discount viagra
buying viagra
cheap viagra
cheap meltabs online viagra
buy levitra viagra online
levitra online
buy viagra using paypal
viagra prices walmart
which is better cialis or viagra
buy viagra pill online
buy prescription viagra without
buy later now pay viagra
buy cialis from india
purchase levitra online
generic vs brand name viagra
buy viagra online ireland
amazon viagra
how can i buy viagra online in canada
cheap pharmacy viagra
buy discount cialis
online overnight viagra
buy generic viagra pharmacy online
Viagra Oklahoma city
buy online order viagra
buy in spain viagra
generic cialis
buy viagra online australia
buy viagra online alternative viagra
buy viagra online web meds
cheap pill viagra