tag:blogger.com,1999:blog-317146992011-12-13T19:57:20.748-08:00What is Datawarehousing? How to build Data Warehouse using Oracle 9i.Gaurang Patelhttp://www.blogger.com/profile/05996192719055562736noreply@blogger.comBlogger11100tag:blogger.com,1999:blog-31714699.post-1153941044246462272006-07-26T12:10:00.000-07:002006-07-31T15:49:02.823-07:00<div style="text-align: center;"> <div style="text-align: left; font-weight: bold; color: rgb(0, 0, 153);"><a href="http://patelgaurang.blogspot.com">Back TO Home<br /></a></div> <span style="color: rgb(0, 0, 153);font-size:180%;" ><span style="font-weight: bold;">Index</span></span><br /></div><br /><span style="font-weight: bold;">1. Introduction </span> <br /><ul> <li><span style="font-size:85%;"> </span><span style="font-size:85%;"> What is Data warehousing? </span></li> <li><span style="font-size:85%;"> Data warehouse Architectures </span></li> </ul> <ul style="margin-left: 80px; text-align: left;"> <li><span style="font-size:85%;">Basic </span></li> <li><span style="font-size:85%;">With Staging Area </span></li> <li><span style="font-size:85%;">Staging Area and Data mart </span> </li> </ul> <span style="font-weight: bold; color: rgb(0, 0, 153);">2. Objective and Problem Definition </span> <br /><ul> <li> <span style="font-size:85%;">Why Oracle?</span> </li> </ul> <span style="font-weight: bold; color: rgb(0, 0, 153);">3. Solution </span> <br /><ul> <li> <span style="font-size:85%;"> List of Available Database Tools </span></li> <li><span style="font-size:85%;"> Comparison Among Tools </span></li> <li><span style="font-size:85%;"> Database Benchmark by eWEEK and PC Magazine. </span></li> <li><span style="font-size:85%;"> Technical Comparison (Issues and Results) </span> </li> </ul> <span style="font-weight: bold; color: rgb(0, 0, 153);">4. Design Methodology </span> <br /><ul> <li><span style="font-size:85%;"> Logical Design </span></li> </ul> <ul style="margin-left: 40px;"> <li><span style="font-size:85%;"> ER Diagram </span></li> <li><span style="font-size:85%;"> C Graph </span></li> <li><span style="font-size:85%;"> DW schemas. Star </span></li> <li><span style="font-size:85%;"> DW Objects </span></li> <li><span style="font-size:85%;"> Facts and Dimension Tables </span></li> <li><span style="font-size:85%;"> Hierarchies </span></li> <li><span style="font-size:85%;"> Level </span></li> <li><span style="font-size:85%;"> Level Relationships </span></li> </ul> <ul> <li><span style="font-size:85%;"> Physical Design <br /></span></li> </ul> <ul style="margin-left: 40px;"> <li><span style="font-size:85%;"> Table Space </span></li> <li><span style="font-size:85%;"> Tables and Partition Tables </span></li> <li><span style="font-size:85%;"> Views </span></li> <li><span style="font-size:85%;"> Integrity Constraints </span></li> </ul> <ul style="margin-left: 80px;"> <li><span style="font-size:85%;"> Not Null </span></li> <li><span style="font-size:85%;"> Unique Constraints </span></li> <li><span style="font-size:85%;"> Foreign Key </span></li> </ul> <ul> <li><span style="font-size:85%;"> Indexes and Partition Indexes </span></li> </ul> <ul style="margin-left: 40px;"> <li><span style="font-size:85%;"> Local Indexes and Global Indexes </span></li> <li><span style="font-size:85%;"> Bitmap Indexes </span></li> </ul> <ul> <li><span style="font-size:85%;"> Materialized View </span></li> </ul> <div style="margin-left: 80px; text-align: left;"> <ul> <li><span style="font-size:85%;"> Materialize Views in Data Warehouse </span></li> <li><span style="font-size:85%;"> Need for Materialize Views </span></li> <li><span style="font-size:85%;"> Transparent Query Rewrite </span></li> <li><span style="font-size:85%;"> Overview of Summary Management in Oracle 9i </span></li> </ul> </div> <span style="font-size:85%;"><br /></span> <ul> <li><span style="font-size:85%;"> Dimensions </span></li> </ul> <ul style="margin-left: 40px;"> <li><span style="font-size:85%;"> What is Dimensions? </span></li> <li><span style="font-size:85%;"> Creating Dimension</span> </li> </ul> <span style="font-weight: bold; color: rgb(0, 0, 153);">5. Managing ETL in Oracle 9i </span> <br /><ul> <li> <span style="font-size:85%;"> Extraction Process </span></li> </ul> <ul style="margin-left: 40px;"> <li><span style="font-size:85%;"> Extraction Methods in Oracle 9i </span></li> <li><span style="font-size:85%;"> Extraction Using Oracle 9i </span></li> </ul> <ul> <li><span style="font-size:85%;"> Transportation Process </span></li> </ul> <ul style="margin-left: 80px;"> <li><span style="font-size:85%;"> Transportation Mechanisms in Data Warehouse </span></li> </ul> <ul> <li><span style="font-size:85%;"> Loading and Transformation Process </span></li> </ul> <ul style="margin-left: 40px;"> <li><span style="font-size:85%;"> Transformation Flow </span></li> </ul> <ul style="margin-left: 80px;"> <li><span style="font-size:85%;"> Multistage Data Transformation </span></li> <li><span style="font-size:85%;"> Pipelined Data Transformation </span></li> </ul> <ul style="margin-left: 40px;"> <li><span style="font-size:85%;"> Loading Mechanism </span></li> </ul> <ul style="margin-left: 80px;"> <li><span style="font-size:85%;"> SQL Loader </span></li> <li><span style="font-size:85%;"> Direct path SQL Loader </span></li> <li><span style="font-size:85%;"> Conventional SQL Loader </span> </li> </ul> <span style="font-weight: bold; color: rgb(0, 0, 153);">6. Lesson Learned </span><br /><span style="font-weight: bold; color: rgb(0, 0, 153);">7. Summary </span><br /><span style="font-weight: bold; color: rgb(0, 0, 153);">8. References </span> <br /><br /><span style="color: rgb(0, 0, 153);">Keywords: Table space, SQL Loader, Bitmap Index, B-tree index, Flat files<br /><br /></span> <div style="text-align: center;"><span style="color: rgb(0, 0, 153); font-weight: bold; font-style: italic;">// Under Construction</span><br /></div><div class="blogger-post-footer"><script type="text/javascript"><!-- google_ad_client = "pub-5854221744164635"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text"; google_ad_channel =""; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/31714699-115394104424646227?l=dwora9i.blogspot.com' alt='' /></div>Gaurang Patelhttp://www.blogger.com/profile/05996192719055562736noreply@blogger.com1