tag:blogger.com,1999:blog-18412983889922967802024-03-27T16:53:23.855-07:00Data MiningData Mining and Warehousing are one of the most talked about topics in recent times in the world of database, business intelligence and software development. This blog will help to understand data mining concepts, data mining techniques, data mining applications, data mining software, data mining tools and learn the latest development in the field of data mining and warehousing.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.comBlogger22125tag:blogger.com,1999:blog-1841298388992296780.post-80411904307673017292012-07-01T09:37:00.000-07:002012-07-01T09:37:09.313-07:00Challenges of Big Data<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
<w:UseFELayout/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
</style>
<![endif]-->
<br />
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;">Volume:</b></div>
<div class="MsoNormal">
According to a study we produce around 2.5 quintillion
bytes of data each day. We can no longer use the existing database
management tools on such rapidly growing data. We will experience difficulties
to capture, store, search, share, analyze and visualize data. Managing large
volume and rapidly increasing database is a challenging issue and cannot be
anymore mitigated with faster processors. The volume of data is exceeding the processing
capacity. Moreover, the algorithms necessary to process the data are much more
complex than usual ones making analysis on big data very complicated.</div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;">Velocity: </b></div>
<div class="MsoNormal">
Some scenarios require analysis of data to be presented
immediately. For example: fraudulent credit card transaction should be flagged
before a transaction even occurs. The larger the data set to be processed the
longer it will take to analyze. How we can capture the most important data as
it happens? How quickly does the data move across the enterprise when you
need to make a decision and deliver that to the right people in real-time?</div>
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;">Variety:</b></div>
<div class="MsoNormal">
Big data when it comes in an unstructured format, such as
text or video. Machines or algorithms expect homogenous data and so require
data to be prepared before analysis. To apply appropriate filters that can
reduce the size of raw data and at the same time ensures the availability of
necessary data. Even after initial data cleaning some errors and incompleteness
may exist in the data which must be handled during data analysis.</div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com43tag:blogger.com,1999:blog-1841298388992296780.post-60082986325877583622012-07-01T09:35:00.000-07:002012-07-01T09:35:27.506-07:00What is Big Data?<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves>false</w:TrackMoves>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:DontVertAlignCellWithSp/>
<w:DontBreakConstrainedForcedTables/>
<w:DontVertAlignInTxbx/>
<w:Word11KerningPairs/>
<w:CachedColBalance/>
<w:UseFELayout/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true"
DefSemiHidden="true" DefQFormat="false" DefPriority="99"
LatentStyleCount="267">
<w:LsdException Locked="false" Priority="0" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" Priority="39" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" Name="toc 9"/>
<w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" Priority="10" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" Priority="11" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" Priority="22" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" Priority="59" SemiHidden="false"
UnhideWhenUsed="false" Name="Table Grid"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" SemiHidden="false"
UnhideWhenUsed="false" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" SemiHidden="false"
UnhideWhenUsed="false" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" SemiHidden="false"
UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" SemiHidden="false"
UnhideWhenUsed="false" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" SemiHidden="false"
UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" SemiHidden="false"
UnhideWhenUsed="false" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin-top:0in;
mso-para-margin-right:0in;
mso-para-margin-bottom:10.0pt;
mso-para-margin-left:0in;
line-height:115%;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}
</style>
<![endif]-->
<br />
<div class="MsoNormal">
Big data is defined by its 3 characteristics which is also
called 3 V’s:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9NVId0Jw40i6EOyCZdT9UgvSCy8wsG7zNvwZLgiGs6Xi80dgp5Ef9kMwGE53aHv3wbPPwRmtZYF8BTObmU6yuE2GAtNE6wz-YRXgfRFmpZQntDhaPYFdtcHrmWDJarioLj_NtvQlOzUQ/s1600/bigdata.bmp" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9NVId0Jw40i6EOyCZdT9UgvSCy8wsG7zNvwZLgiGs6Xi80dgp5Ef9kMwGE53aHv3wbPPwRmtZYF8BTObmU6yuE2GAtNE6wz-YRXgfRFmpZQntDhaPYFdtcHrmWDJarioLj_NtvQlOzUQ/s320/bigdata.bmp" width="247" /></a></div>
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><span style="mso-list: Ignore;">1.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><span style="mso-spacerun: yes;"> </span><b>Volume:</b>
The increase in data volumes within enterprise systems is caused by transaction
volumes and other traditional data types, as well as by new types of data. </div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><span style="mso-list: Ignore;">2.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b>Velocity:</b> This involves streams of data,
structured record creation, and availability for access and delivery. Velocity
means both how fast data is being produced and how fast the data must be
processed to meet demand.</div>
<div class="MsoListParagraphCxSpLast" style="mso-list: l0 level1 lfo1; text-indent: -.25in;">
<span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin;"><span style="mso-list: Ignore;">3.<span style="font: 7.0pt "Times New Roman";">
</span></span></span><b>Variety: </b><span style="mso-bidi-font-weight: bold;">It</span> includes tabular data (databases), hierarchical data,
documents, e-mail, metering data, video, still images, audio, stock ticker
data, financial transactions and more.<span style="mso-no-proof: yes;"></span></div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com5tag:blogger.com,1999:blog-1841298388992296780.post-91779839329605469362010-05-03T10:17:00.000-07:002010-05-03T10:23:16.968-07:00ROLAP, MOLAP and HOLAP<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 12" name="Generator"></meta><meta content="Microsoft Word 12" name="Originator"></meta><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml" rel="File-List"></link><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx" rel="themeData"></link><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="colorSchemeMapping"></link> <m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1107304683 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman","serif";
mso-fareast-font-family:"Times New Roman";}
p
{mso-style-noshow:yes;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman","serif";
mso-fareast-font-family:"Times New Roman";}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style> </m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac><br />
There are three different types of OLAP technology:<br />
<br />
<div style="text-align: justify;"><b>ROLAP</b> stands for Relational-OLAP as it stores all the data in relational database. When we run the MDX queries it retrieves the data from the relational database using a corresponding SQL query. This makes the query processing to be slow but it does provide faster processing time. </div><div style="text-align: justify;"><br />
<b>MOLAP</b> stands for Multidimensional-OLAP as it stores all the data in the multidimensional data structure of the Analysis Services. It has slow processing time but provides better query performance than ROLAP. MOLAP storage mode is most widely used as OLAP is meant to provide the faster query performance.</div><div style="text-align: justify;"><br />
<b>HOLAP</b> stands for Hybrid-OLAP as it uses a combination of both the ROLAP and MOLAP. It stores only the indexes and aggregations in the multidimensional form while the rest of the data is stored in the relational database.</div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com6tag:blogger.com,1999:blog-1841298388992296780.post-20714960701049908782010-03-05T06:36:00.001-08:002010-03-05T06:39:15.453-08:00Time Dimension in Data Warehouse<meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 12" name="Generator"></meta><meta content="Microsoft Word 12" name="Originator"></meta><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml" rel="File-List"></link><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_editdata.mso" rel="Edit-Time-Data"></link><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx" rel="themeData"></link><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="colorSchemeMapping"></link> <m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1107304683 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman","serif";
mso-fareast-font-family:"Times New Roman";}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style></m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac><br />
<div class="MsoNormal"><o:p></o:p></div><div style="text-align: justify;">In any data warehouse date and time plays a vital role in keeping track of when a particular event has taken place. However, we do not store the time information in the same way as we do in the OLTP database. In a dimensional model a separate time dimension is normally used. This time dimension contains separate attributes for year, month, and day and so on. This time dimension is initially populated with the data of a particular period like ten years. Whenever an event/transaction needs to be recorded in the fact table the time key from this dimension for the corresponding time is obtained from the time dimension. </div><div class="MsoNormal" style="text-align: justify;"><o:p><br />
</o:p></div><div class="MsoNormal" style="text-align: justify;">Surrogate key for time dimension is auto incremented just like any other dimension but it is always helpful to have it the right format like for date: 05-Mar-2010 the time key should be 05032010. This proves to be extremely useful as queries can be done directly based on the time key and thus improves performance.</div><div class="MsoNormal" style="text-align: justify;"></div><div class="MsoNormal" style="text-align: justify;">The following figures show how to create and populate time dimension in Sql Server Analysis Services (SSAS): </div><div class="MsoNormal" style="text-align: justify;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisC0JdU4dGDF06BSoelY0rMCnkGVeXpbBKg6qEU7nJuoPXq7dx40B6onBdM216LaY7g5wpJFXnZN1o4P8WC5LT28g7pgxYnrfuIpQt7vKPXHWJGvQnwlELmCk9tPop69tOJwEvrQ1AjZ4/s1600-h/1.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisC0JdU4dGDF06BSoelY0rMCnkGVeXpbBKg6qEU7nJuoPXq7dx40B6onBdM216LaY7g5wpJFXnZN1o4P8WC5LT28g7pgxYnrfuIpQt7vKPXHWJGvQnwlELmCk9tPop69tOJwEvrQ1AjZ4/s200/1.gif" width="181" /></a></div><div class="MsoNormal" style="text-align: justify;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0qokfMbUyjhFaXQSpw3n_cevhc-lf1zAd2bxfiyq9JwzDzfdo_F3_tlNoWYGG1rtyqj4rddNKO7k49TLIu4Tjyenl7LvngtbxArhLrHT2AyH-Je6WK2HXbh7rKvlDbXz56YEBrGzOl-U/s1600/2.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj0qokfMbUyjhFaXQSpw3n_cevhc-lf1zAd2bxfiyq9JwzDzfdo_F3_tlNoWYGG1rtyqj4rddNKO7k49TLIu4Tjyenl7LvngtbxArhLrHT2AyH-Je6WK2HXbh7rKvlDbXz56YEBrGzOl-U/s200/2.gif" width="200" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAa0o6Z2yENABZ5_wkqU-qDSQBNpJT-lzdSIY3t5Zh3e8ZnaZFRLP7I1DT5mGCAKgmUExQupAhodeXh9szNttBIRx0dwYAeS2G4uLA-efnuEOJHpRpZb7KQThrCf5cjQZZdh-dBEL8jm4/s1600-h/3.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiAa0o6Z2yENABZ5_wkqU-qDSQBNpJT-lzdSIY3t5Zh3e8ZnaZFRLP7I1DT5mGCAKgmUExQupAhodeXh9szNttBIRx0dwYAeS2G4uLA-efnuEOJHpRpZb7KQThrCf5cjQZZdh-dBEL8jm4/s200/3.gif" width="200" /></a></div><div class="MsoNormal" style="text-align: justify;"><br />
</div><br />
<div class="MsoNormal" style="text-align: justify;"><meta content="text/html; charset=utf-8" http-equiv="Content-Type"></meta><meta content="Word.Document" name="ProgId"></meta><meta content="Microsoft Word 12" name="Generator"></meta><meta content="Microsoft Word 12" name="Originator"></meta><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml" rel="File-List"></link><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_editdata.mso" rel="Edit-Time-Data"></link><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx" rel="themeData"></link><link href="file:///C:%5CDOCUME%7E1%5Csarfaraz%5CLOCALS%7E1%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml" rel="colorSchemeMapping"></link> <m:smallfrac m:val="off"> <m:dispdef> <m:lmargin m:val="0"> <m:rmargin m:val="0"> <m:defjc m:val="centerGroup"> <m:wrapindent m:val="1440"> <m:intlim m:val="subSup"> <m:narylim m:val="undOvr"> </m:narylim></m:intlim> </m:wrapindent><style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-1610611985 1107304683 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman","serif";
mso-fareast-font-family:"Times New Roman";}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style><span style="font-family: "Times New Roman","serif"; font-size: 12pt;"></span><o:p></o:p></m:defjc></m:rmargin></m:lmargin></m:dispdef></m:smallfrac></div><div class="MsoNormal"></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"></div><div class="MsoNormal"></div><div class="MsoNormal"></div><div class="MsoNormal"></div><div class="MsoNormal"></div><div class="MsoNormal"></div><div class="MsoNormal"></div><div class="MsoNormal"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHdSHfEPhkX-r3sUOA5UYamz6vlYgwaUHYYjCFF209jt1WIxozNO_AL-h_gzH9qoVFEHzCe8SRHzAS8O1jqzYE4DAWxlWMRqkQF0PN7HWd476pr48vJn9wmTtfTCs5EOUuJ5ModXAHNck/s1600-h/4.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhHdSHfEPhkX-r3sUOA5UYamz6vlYgwaUHYYjCFF209jt1WIxozNO_AL-h_gzH9qoVFEHzCe8SRHzAS8O1jqzYE4DAWxlWMRqkQF0PN7HWd476pr48vJn9wmTtfTCs5EOUuJ5ModXAHNck/s200/4.gif" width="200" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiId534X9zIJZjaeFCTqMzjdr_5ZsaK0bSYuU_iURTFb7CEHqna8Ub_TWaq41JkTVn6G9oi6LVqazx1LAEF4_ecW89SeZJXjzoJtXSOMxKbzqp59AZ9Pnhd918R1L0SAeOrvIdljlsTWaQ/s1600-h/5.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiId534X9zIJZjaeFCTqMzjdr_5ZsaK0bSYuU_iURTFb7CEHqna8Ub_TWaq41JkTVn6G9oi6LVqazx1LAEF4_ecW89SeZJXjzoJtXSOMxKbzqp59AZ9Pnhd918R1L0SAeOrvIdljlsTWaQ/s200/5.gif" width="200" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvMm5KA7Ag_G8qki1auSqwteb0ZlH4wzHLaZpe3vI6M3LYW6idAht1gykW0vNlavx6Krh3ym4ZMK-e60gj76SdgZ718PLeiAVSv4LBjSanOEnRQodNNxN_4DIOyzmYgw3cLfEHghAGmME/s1600-h/6.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjvMm5KA7Ag_G8qki1auSqwteb0ZlH4wzHLaZpe3vI6M3LYW6idAht1gykW0vNlavx6Krh3ym4ZMK-e60gj76SdgZ718PLeiAVSv4LBjSanOEnRQodNNxN_4DIOyzmYgw3cLfEHghAGmME/s200/6.gif" width="200" /></a> </div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHEwS-HHbKKiyzCJoERDq5VWAMkPUuEXhknLgasKANwRFzz7Fq8PZ3vR2drZ9tRlCrl1xRBdO5Y_JlDWZgrgflpL4qElWFpG6WnFtuFx8QUX4-vEPXWC7IR5ckEN1Z-MocIzc8Dt7b4ws/s1600-h/7.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHEwS-HHbKKiyzCJoERDq5VWAMkPUuEXhknLgasKANwRFzz7Fq8PZ3vR2drZ9tRlCrl1xRBdO5Y_JlDWZgrgflpL4qElWFpG6WnFtuFx8QUX4-vEPXWC7IR5ckEN1Z-MocIzc8Dt7b4ws/s200/7.gif" width="200" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzYsHIkRyQ2Qp1yd9DXEwstumWJy2t3a6IQqkoGLCjZF-b7Dgwyq5D-BuwEKm2bZ2a_qwPlO-h526jpP7baW66eiT3wvK1KkRb5JwGbbPMKLurwbhmvj_K-n0d_spy_JFvgNY-nzBKhsM/s1600-h/8.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzYsHIkRyQ2Qp1yd9DXEwstumWJy2t3a6IQqkoGLCjZF-b7Dgwyq5D-BuwEKm2bZ2a_qwPlO-h526jpP7baW66eiT3wvK1KkRb5JwGbbPMKLurwbhmvj_K-n0d_spy_JFvgNY-nzBKhsM/s200/8.gif" width="200" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzYsHIkRyQ2Qp1yd9DXEwstumWJy2t3a6IQqkoGLCjZF-b7Dgwyq5D-BuwEKm2bZ2a_qwPlO-h526jpP7baW66eiT3wvK1KkRb5JwGbbPMKLurwbhmvj_K-n0d_spy_JFvgNY-nzBKhsM/s1600-h/8.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzYsHIkRyQ2Qp1yd9DXEwstumWJy2t3a6IQqkoGLCjZF-b7Dgwyq5D-BuwEKm2bZ2a_qwPlO-h526jpP7baW66eiT3wvK1KkRb5JwGbbPMKLurwbhmvj_K-n0d_spy_JFvgNY-nzBKhsM/s200/8.gif" width="200" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLWpqMR6uBpuqSQRb-6PBNiuZOVPBS8LUIdFn64zSgppotsSYpqbR9dnCv1GPsK6tMHwjj_QVl3c2OCJO0PsTdOB6t0rs2PbxgN1pou9lGMhIg6S2b1dpIBsOmrHhfsi0oTNr7rNrOxOw/s1600-h/9.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjLWpqMR6uBpuqSQRb-6PBNiuZOVPBS8LUIdFn64zSgppotsSYpqbR9dnCv1GPsK6tMHwjj_QVl3c2OCJO0PsTdOB6t0rs2PbxgN1pou9lGMhIg6S2b1dpIBsOmrHhfsi0oTNr7rNrOxOw/s200/9.gif" width="200" /></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeeUlgtdtJFbwA-76-kQNiE5NdvUZUqbrPmLYrp8vVn26eQnHmcQqvY3srwPTP5dv6X1zSrZqmCGwYw9NEdX1rACCopoOwVGeMvtc5T3VH-tTpdJ0B6hPFCP-WVXfu-Jfckv5Yr4MNVc8/s1600-h/10.gif" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="66" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjeeUlgtdtJFbwA-76-kQNiE5NdvUZUqbrPmLYrp8vVn26eQnHmcQqvY3srwPTP5dv6X1zSrZqmCGwYw9NEdX1rACCopoOwVGeMvtc5T3VH-tTpdJ0B6hPFCP-WVXfu-Jfckv5Yr4MNVc8/s200/10.gif" width="200" /></a></div><div class="MsoNormal"></div><div class="MsoNormal"><br />
</div><div class="MsoNormal"></div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com11tag:blogger.com,1999:blog-1841298388992296780.post-17201992898723788042009-11-20T06:38:00.000-08:002009-11-20T07:17:00.891-08:00Data Warehouse DesignData Warehouse can be designed in two different ways based on Ralph Kimball and Bill Inmon's model. <br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVYY3EHipww1swW9ZBzlVr8zFIjdZ-xQk_4Y7OSGosl7dfFaA3zV4-eozwoMMCqd7Tl5yWyvD_n_VcUJUIlW17XVGGQxATUKutPL1kz6cvOyGhCoXZ6uvFkRWdfOHQM-TSxGOu3KaRvlc/s1600/Inmon.bmp"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 379px; height: 174px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjVYY3EHipww1swW9ZBzlVr8zFIjdZ-xQk_4Y7OSGosl7dfFaA3zV4-eozwoMMCqd7Tl5yWyvD_n_VcUJUIlW17XVGGQxATUKutPL1kz6cvOyGhCoXZ6uvFkRWdfOHQM-TSxGOu3KaRvlc/s320/Inmon.bmp" alt="" id="BLOGGER_PHOTO_ID_5406202897432007074" border="0" /></a>In Inmon's architecture data from OLTP databse is stored in a warehouse before it is transferred to the data marts. In Inmon's view the data warehouse is a real database.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-GpLP4QionjPMj49hCWojbqP1Hu_Za7XFWGuCdySpEhI5XKF7MyJBHPwkux7VL5_vKg6nZ07Wah-SgUFTCIpIRToFLSuDk_CZXIYRogEtoUm9Q7dr42Z_Rc8tDO5DjXQeU3ZH8cPj2os/s1600/kimbal.bmp"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 353px; height: 178px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-GpLP4QionjPMj49hCWojbqP1Hu_Za7XFWGuCdySpEhI5XKF7MyJBHPwkux7VL5_vKg6nZ07Wah-SgUFTCIpIRToFLSuDk_CZXIYRogEtoUm9Q7dr42Z_Rc8tDO5DjXQeU3ZH8cPj2os/s320/kimbal.bmp" alt="" id="BLOGGER_PHOTO_ID_5406202893035744706" border="0" /></a>According to Kimball's architecture data is transferred directly from OLTP database to the data mart. In Kimball's model the data warehouse is actually a collection of integrated data marts.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com8tag:blogger.com,1999:blog-1841298388992296780.post-48494399346087241612009-11-12T09:19:00.000-08:002009-11-12T09:49:22.286-08:00SQL Server Replication<div style="text-align: justify;">Replication is the process of creating and maintaining a separate copy of database in another server or the same server and keeping both synchronized. Replication is useful in a number of scenario:<br /><br /></div><span style="font-weight: bold;">1. To integrate multiple database to build a central warehouse: </span>Businesses operating on a number of distant locations usually collect data in separate database. However the senior management needs to generate reports showing analysis of data collected from all these sites. Hence the need for central warehouse is increasing and replication proves to be a powerful way to create and maintain the warehouse. It can also be used to create and maintain a separate data mart for OLAP operations. <div style="text-align: justify;"><br /><span style="font-weight: bold;">2. To ensure higher availability and improved performance of web applications: </span>Web applications with the increasing number of users faces huge problem in avoiding the extra load on the database. Replication along with other techniques can offer the right solution by distributing users to a number of replicated database in different servers and thus improving the performance and ensure high availability.<br /></div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com3tag:blogger.com,1999:blog-1841298388992296780.post-16837441529161046222009-09-28T08:57:00.000-07:002009-09-28T09:07:44.749-07:00OLAP Video Tutorial<div style="text-align: justify;">This is an exciting video I came across where OLAP concepts are explained in a easy to understand way using cartoons.<br /></div><br /><object width="425" height="344"><param name="movie" value="http://www.youtube.com/v/KTdJ661013s&hl=en&fs=1&"><param name="allowFullScreen" value="true"><param name="allowscriptaccess" value="always"><embed src="http://www.youtube.com/v/KTdJ661013s&hl=en&fs=1&" type="application/x-shockwave-flash" allowscriptaccess="always" allowfullscreen="true" width="425" height="344"></embed></object>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com1tag:blogger.com,1999:blog-1841298388992296780.post-29986834366877052982009-09-26T09:23:00.000-07:002009-09-26T10:05:32.743-07:00Dimensional Modeling<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqnGkHFsliYWuVRK22bGVQc5WLwXhvnd4vMciShkG7R0jb1FZq6KeEL7QT_n_ymkKG93_xu4NnsPz44nUAy-PAB0pjfceagWjKXLfnTBXV1G9kbZffGx6El3t07KgV58L-H-84WclaIs0/s1600-h/dimension_modeling.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 320px; height: 240px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqnGkHFsliYWuVRK22bGVQc5WLwXhvnd4vMciShkG7R0jb1FZq6KeEL7QT_n_ymkKG93_xu4NnsPz44nUAy-PAB0pjfceagWjKXLfnTBXV1G9kbZffGx6El3t07KgV58L-H-84WclaIs0/s320/dimension_modeling.jpg" alt="" id="BLOGGER_PHOTO_ID_5385822796898947634" border="0" /></a><br /><div style="text-align: justify;">Dimensional Modeling refers to the technique used to design logical models for database which can support OLAP and Data Warehousing operations. It differs from the relational modeling or ER modeling in the sense that it can be used for data warehouse as well as relational databases.<br /><br />Dimensional modeling is based on two concepts called facts and dimensions. Facts are usually numeric values or something that can be measured or aggregated. For example: monthly sales amount. Dimensions are groups of hierarchies and attributes that are used to define facts. For example product and its color. In a dimensional model a group of facts forms a fact table while a group of dimensions form a dimension table.<br /><br /><br /></div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com5tag:blogger.com,1999:blog-1841298388992296780.post-30856543623254721152009-09-20T02:55:00.000-07:002009-09-20T04:33:43.187-07:00Market Basket Analysis<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpjYrlFzpQqtLAh9X-nBoh4gXw3loKHe33jYO1zyYRW_Asy8717mElw0w1G2AkqodZMF07QT01KAAptTZm1W-vanYt-lbFmaNsVSC_4tUFYawkHVtVw2pMuE54I1gn4bA0Ytg8PfFBCY0/s1600-h/market-basket-analyser.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 173px; height: 139px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpjYrlFzpQqtLAh9X-nBoh4gXw3loKHe33jYO1zyYRW_Asy8717mElw0w1G2AkqodZMF07QT01KAAptTZm1W-vanYt-lbFmaNsVSC_4tUFYawkHVtVw2pMuE54I1gn4bA0Ytg8PfFBCY0/s320/market-basket-analyser.jpg" alt="" id="BLOGGER_PHOTO_ID_5383509832743637442" border="0" /></a><br /><div style="text-align: justify;">Market Basket Analysis is used to identify or gain interesting insights into the way customers buy items. It finds out the combination of items which are most likely to be bought together. For example buying milk and bread together can lead to buying butter. Identifying such patterns from the transaction data collected over the years provide new window of opportunity to explore and understand the purchasing behavior and thus can be used to increase sales through cross selling and targeted marketing. Market basket analysis is not limited to retail sales but are applied to a wide range of areas like analyzing credit card purchases, fraud detection for insurance claims and so on. Data Mining technique called association rule mining is usually used. Algorithms like FP-Growth and <span class="mw-headline" id="Apriori_algorithm">Apriori algorithm</span> are usually used for mining the transaction data to get the desired patterns.</div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com10tag:blogger.com,1999:blog-1841298388992296780.post-86569974821443357522009-09-18T03:29:00.000-07:002009-09-18T03:57:37.701-07:00MDX - Multi-Dimensional ExpressionsOLAP cubes stores data in multidimensional form whereas in the relational database data is stored in the 2 dimensions: rows and columns. OLAP cubes can store data in more than these 2 dimensions. The SQL or Structured Query Language enables us to access and manipulate the data resinding in the relational database. However SQL cannot be used for the same purposes for OLAP cubes. MDX is the language used for accessing and manipulating data in the cubes.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com1tag:blogger.com,1999:blog-1841298388992296780.post-26917526813790337372009-07-30T06:37:00.000-07:002009-07-30T06:38:29.722-07:00Web Usage MiningWeb Usage Mining: Whenever anyone logs on to a web site the user's access information like time spent on the site, links visited, geographical location from where accessed etc are stored in the log file of the website. These data can be mined to discover user access patterns for the site. The site can then be redesigned to maximize hits and better user experience like having the most accessed link to be available on the front page of the site. This also provides patterns which can be used to run successful ad campaigns on the site.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com5tag:blogger.com,1999:blog-1841298388992296780.post-90789890588321575322009-07-24T06:47:00.000-07:002009-07-24T07:06:31.696-07:00Web MiningThe WWW has revolutionize the way in which people interact, carry out their works and gather information. It has proved itself to be a useful interface for its users to carry out such activities with ease. With hundreds of millions of people around the world using it a huge pile of data are collected everyday. These data carries interesting insights on the way people interact with it. Web Mining is the process of using various data mining techniques to analyze and discover patterns from the data.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com4tag:blogger.com,1999:blog-1841298388992296780.post-11526574395988962792009-07-11T06:17:00.000-07:002009-07-11T07:10:03.482-07:00OLAP And OLTPOLAP and OLTP are two of the most common words in the world of database. However the differences between the two are not well understood. OLTP and OLAP refer to Online Transaction Processing and Online Analytical Processing respectively. The word "online" is common to both and highlights that both the systems are capable to carry out certain things almost instantaneously.<br /><br />The OLTP systems are used to register the transactions occurring in real time. In a retail shop the buying information needs to be instantaneously recorded by the salesman during any purchase of goods. OLTP systems allow such transactions to be carried out within a very short span of time. Hence to process any kinds of transactions OLTP systems are used.<br /><br />It is not worth anymore to merely store the transaction data. We need to carry out various operations on those data to get the real picture of various aspects of the business. Reports generated based on these data are crucial part of the Decision Support System(DSS). However such complex operations on large volume of transaction data makes the report generation very slow and puts extra load on the OLTP system in use. So to overcome these limitations OLAP are used. OLAP enables data to be stored in multidimensional forms which is often called OLAP cube. OLAP cube ensures very fast retrieval or analysis of data.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com4tag:blogger.com,1999:blog-1841298388992296780.post-48056579854205369332009-01-23T22:03:00.000-08:002009-01-23T08:15:53.684-08:00Data Mining in Economic CrisisIn this time of economic turmoil the whole world is slowly plunging into recession. We have seen bailouts from governments worth billions of dollars for giant companies in US, Europe and Asia. The businesses are finding hard times to operate and so ability to make smarter and intelligent business decisions are imperative to overcome in such harsh conditions.<br /><br />Businesses who have already invested in business intelligence solutions will be in a better position to undertake right measures to survive and continue its growth. However, many may argue that most of the giant companies were using Data mining and BI solutions but still could not avoid the collapse. The important thing to note here is that data mining solutions provides an analytical perspective into the performance of an organization based on historical data but the economic impact on an organization is linked to many issues and in many cases to external forces and unscrupulous activities. The failure to predict this does not undermine the role of data mining for organizations but on the contrary makes it more important especially for regulatory bodies of governments to predict and identify such practices in advance and take necessary measures to avoid such circumstances in future.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com4tag:blogger.com,1999:blog-1841298388992296780.post-35696467618023371282008-12-15T09:41:00.000-08:002009-01-08T08:18:09.685-08:00Applications of Data MiningData Mining has been able to grasp the attention of many in the field of scientific research, businesses, banking sector, intelligence agencies and many others from the early days of its inception. However its use was not as easy as it is now. The rapid growth of various tools and software during the past few years enable it to be used more widely than ever before. The ease with which one can carry out complex data mining techniques using these tools is simply outstanding.<br /><br />Data Mining is used by businesses to do improve its marketing and to understand the buying patterns of its clients. Attrition Analysis, Customer Segmentation and Cross Selling are the most important ways through which data mining is showing the new ways in which businesses can multiply its revenue.<br /><br />Data Mining is now used in the banking sector for credit card fraud detection by identifying the patterns involved in fraudulent transactions. It is also used to reduce credit risk by classifying a potential client and predicting bad loans.<br /><br />Data Mining is used by intelligence agencies like FBI and CIA to identify threats of terrorism. After the 9/11 incident it has become one of the prime means to uncover terrorist plots. However this led to concerns among the people as data collected for such works undermines the privacy of a large number of people.<br /><p><span style=";font-family:Helvetica;font-size:6;" ></span></p>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com46tag:blogger.com,1999:blog-1841298388992296780.post-16050906296413546902008-10-31T07:15:00.000-07:002009-01-08T08:21:54.719-08:00Steps of Data Mining<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFqTHKC46nHfSSovnp_56lhszlC-d6B97bmH4A_FfVCPVtdvCLPQHlHbHqZt_Am888fbaWhIB3DExLXwQTrXtrbXgkMHdMoiBzv3rXE96jVkxdihNe58JzIdsBPKrXy_bGfJ31w3ybvIs/s1600-h/steps4dm.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 277px; height: 182px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFqTHKC46nHfSSovnp_56lhszlC-d6B97bmH4A_FfVCPVtdvCLPQHlHbHqZt_Am888fbaWhIB3DExLXwQTrXtrbXgkMHdMoiBzv3rXE96jVkxdihNe58JzIdsBPKrXy_bGfJ31w3ybvIs/s320/steps4dm.jpg" alt="" id="BLOGGER_PHOTO_ID_5263325269582674786" border="0" /></a><br />There are various steps that are involved in mining data as shown in the picture.<br /><ol><li><span style="font-weight: bold;">Data Integration:</span> First of all the data are collected and integrated from all the different sources.</li><li><span style="font-weight: bold;">Data Selection:</span> We may not all the data we have collected in the first step. So in this step we select only those data which we think useful for data mining.</li><li><span style="font-weight: bold;">Data Cleaning:</span> The data we have collected are not clean and may contain errors, missing values, noisy or inconsistent data. So we need to apply different techniques to get rid of such anomalies.</li><li><span style="font-weight: bold;">Data Transformation:</span> The data even after cleaning are not ready for mining as we need to transform them into forms appropriate for mining. The techniques used to accomplish this are smoothing, aggregation, normalization etc.</li><li><span style="font-weight: bold;">Data Mining:</span> Now we are ready to apply data mining techniques on the data to discover the interesting patterns. Techniques like clustering and association analysis are among the many different techniques used for data mining. </li><li><span style="font-weight: bold;">Pattern Evaluation and Knowledge Presentation: </span>This step involves <span style="color: rgb(0, 0, 0);font-family:Tahoma;font-size:100%;" >visualization, transformation, removing redundant patterns etc from the patterns we generated.</span></li><li><span style="color: rgb(0, 0, 0);font-family:Tahoma;font-size:100%;" ><span style="font-weight: bold;">Decisions / Use of Discovered Knowledge: </span>This step helps user to make use of the knowledge acquired to take better decisions.<br /></span></li></ol>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com7tag:blogger.com,1999:blog-1841298388992296780.post-55836548625453372552008-10-25T07:32:00.000-07:002009-01-08T08:22:22.054-08:00Difference between Data Mining and Data Warehousing<div style="text-align: center;">Data Mining provides the Enterprise with<span style="color: rgb(255, 0, 0);"> <span style="font-weight: bold;">intelligence</span></span><span style="font-weight: bold;"> </span>and Data Warehousing provides the Enterprise with a <span style="color: rgb(255, 0, 0); font-weight: bold;">memory.<br /><br /></span><div style="text-align: left;"><span style="color: rgb(255, 0, 0); font-weight: bold;"></span>Data warehousing is the process that is used to integrate and combine data from multiple sources and format into a single unified schema. So it provides the enterprise with a storage mechanism for its huge amount of data. On the other hand, Data mining is the process of extracting interesting patterns and knowledge from huge amount of data. So we can apply data mining techniques on the data warehouse of an enterprise to discover useful patterns.<br /><span style="color: rgb(255, 0, 0); font-weight: bold;"></span></div></div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com11tag:blogger.com,1999:blog-1841298388992296780.post-55559468200423861672008-10-24T05:35:00.000-07:002008-10-24T06:01:23.000-07:00What is Data Warehousing?<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglslFJIHGg4rmGR6nBrIl1MzplqeGKRPO8DKooPyBjguhh2hKcwz3h9zrMqgodHlTDPLB8bYbwa6EWu5_AdqjuG7N7_jSAdK_24AuZDhFF-r9RSrdtNEVhjyGT8pxMcFjyxYdvMr_Rc_k/s1600-h/New+Bitmap+Image.GIF"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglslFJIHGg4rmGR6nBrIl1MzplqeGKRPO8DKooPyBjguhh2hKcwz3h9zrMqgodHlTDPLB8bYbwa6EWu5_AdqjuG7N7_jSAdK_24AuZDhFF-r9RSrdtNEVhjyGT8pxMcFjyxYdvMr_Rc_k/s400/New+Bitmap+Image.GIF" alt="" id="BLOGGER_PHOTO_ID_5260700318179139922" border="0" /></a>An organization may have a number of different systems like TPS, ERP, Accounting Systems and so on. Each of these systems collect data but the data collected through these systems are not always in the same format. So we need to combine all these data from different sources into a single standard form and this process of combining multiple databases into a single homogenous form is called data warehousing.<br /><br /><span style="font-weight: bold; color: rgb(0, 0, 0);">A <span style="color: rgb(255, 0, 0);">data warehouse</span> is a <span style="color: rgb(255, 0, 0);">subject-oriented, integrated, time-variant and non-volatile </span>collection of data in support of management’s decision making process.Subject-oriented </span><br /><br /><dd><span style="font-size:100%;">The data in the data warehouse is organized so that all the data elements relating to the same real-world event or object are linked together.</span></dd><dt style="font-weight: bold;"><span style="font-size:100%;">Time-variant </span></dt><dd><span style="font-size:100%;">The changes to the data in the data warehouse are tracked and recorded so that reports can be produced showing changes over time.</span></dd><dt style="font-weight: bold;"><span style="font-size:100%;">Non-volatile </span></dt><dd><span style="font-size:100%;">Data in the data warehouse is never over-written or deleted - once committed, the data is static, read-only, and retained for future reporting.</span></dd><dt style="font-weight: bold;"><span style="font-size:100%;">Integrated </span></dt><dd><span style="font-size:100%;">The data warehouse contains data from most or all of an organization's operational systems and this data is made consistent.</span></dd>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com3tag:blogger.com,1999:blog-1841298388992296780.post-30359736279772379022008-10-24T05:13:00.000-07:002009-01-08T08:22:52.354-08:00History of Data Mining<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCPMPfsnuFpygf-Wmtge1gxWW3x_80B4u6SX1lMHsWTjI12murxsjvVmMj1AD4Lw2lgdESxv48NFUWzcU327bsyzbj2QUZ0BtIGb9_R17rLJjD5Ms_JMKVK365_4XR594QQ4s0c8D1wtw/s1600-h/h.GIF"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 300px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCPMPfsnuFpygf-Wmtge1gxWW3x_80B4u6SX1lMHsWTjI12murxsjvVmMj1AD4Lw2lgdESxv48NFUWzcU327bsyzbj2QUZ0BtIGb9_R17rLJjD5Ms_JMKVK365_4XR594QQ4s0c8D1wtw/s400/h.GIF" alt="" id="BLOGGER_PHOTO_ID_5260697356194907842" border="0" /></a><br />Data mining is a fairly new concept which was emerged in the late 1980s. But it soon attracted huge interests for research works and flourishes with many new and remarkable techniques being discovered throughout the 1990s. Data Mining has evolved from a number of different disciplines like statistics, machine learning, artificial intelligence, database technologies and so on.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com2tag:blogger.com,1999:blog-1841298388992296780.post-76653170686565710492008-10-24T04:47:00.000-07:002009-01-08T08:23:15.323-08:00Why Data Mining?<div style="text-align: center; font-weight: bold; color: rgb(255, 102, 0);">"We are overwhelmed with <span style="color: rgb(255, 0, 0);">data </span>but starved of <span style="color: rgb(255, 0, 0);">knowledge</span>"<br /></div><br />In today's world we are overwhelmed with data and information from various sources. The advancement in the field of IT makes collection of data easier than ever before. A business enterprise has various systems like transaction processing system, HR management system, Accounting system and so on and each of these systems are collecting huge piles of data everyday.<br /><br />Are these data help us take more intelligent decisions? The answer is no. To take better decisions you need to discover and understand the underlying patterns involved in your business from these data. For example, it's no more enough for a retailer to know just the amount of sales, profit and expenses he is making in this highly competitive business environment. To expand its business and achieve higher goals it has to search for answers to the questions like:<br /><br /><ul><li>Which products are bought most often together? </li></ul><ul><li>Identify the segment of customers who are most likely to buy certain products so that it can promote those products only to them.</li></ul><ul><li>What should be profit range five years from now?</li></ul><br />Data mining has the answers to all these questions. Data mining can help organizations to have useful insights into its business from the data it has collected over the years and take better decisions to achieve new heights.Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com1tag:blogger.com,1999:blog-1841298388992296780.post-74981859723212298392008-10-17T07:38:00.000-07:002009-01-08T08:23:48.193-08:00What is Data Mining?<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOjg6KK02N80mDj3aCoyeEG3new40tnLOG34O5z3yHnA5UEEdbXqbnTGB4t0KMoGThdfVVNGBHm1X63Vy1kj-doNWriEx0xgH4nkREogiAM2wQK8msTy6oiuk_nv5BMk56oHMfGd1Gtrw/s1600-h/Data+Mining.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOjg6KK02N80mDj3aCoyeEG3new40tnLOG34O5z3yHnA5UEEdbXqbnTGB4t0KMoGThdfVVNGBHm1X63Vy1kj-doNWriEx0xgH4nkREogiAM2wQK8msTy6oiuk_nv5BMk56oHMfGd1Gtrw/s400/Data+Mining.png" alt="" id="BLOGGER_PHOTO_ID_5258144307589747922" border="0" /></a><br /><div style="text-align: justify;">The word "Mining" refers to the extraction of valuable things like minerals from the earth. However, <span style="font-weight: bold;">data mining</span> is the process by which we can extract interesting patterns and knowledge from huge amounts of data. The data mining is a relatively new field of study and research and has generated huge interests among business communities. It is a an important part of business intelligence which deals with how an organization uses, analyzes, manages and stores data it collects from various sources to make better decisions.<br /><br />In the popular article, "IT Does Not Matter" Nicholas Carr argued that the use of IT is nowadays so widespread that any particular organization does not have any strategic advantage over the others due to the use of IT. So IT has lost its strategic importance. But data mining is one of most important concept of IT that proves him wrong. It reflects that an organization can create strategic advantages over its competitors by making use of data mining to get to important insights from the the data it collects. The way an organization collects data and analyzes it is not same for any organizations. So an organization can easily gain competitive values over others using data mining.</div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com1tag:blogger.com,1999:blog-1841298388992296780.post-65764347074549904652008-10-17T07:24:00.000-07:002009-01-08T08:24:16.283-08:00A Welcome Note !!!!<div style="text-align: justify;">Hello and welcome to all of you in this fascinating and rapidly changing world of data mining and warehousing. I being very interested on this topic would like to share all the new things I come across. I have been trying to understand the data mining concepts, techniques and tools for quite some time now but I faced the difficulty of getting useful and desired information on the topic at a single site. I will use this blog to make things easy for all of you interested in data mining with useful posts and to keep note of all the things I will learn.</div>Sarfaraz M Manikhttp://www.blogger.com/profile/14156917430137795036noreply@blogger.com9