{"id":69199,"date":"2021-08-13T04:10:07","date_gmt":"2021-08-13T08:10:07","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/what-is-data-warehousing-44\/"},"modified":"2021-08-13T04:10:07","modified_gmt":"2021-08-13T08:10:07","slug":"what-is-data-warehousing-44","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69199","title":{"rendered":"What is Data Warehousing? #44"},"content":{"rendered":"<p>Data Warehouse is a storage of an organization&#8217;s historical data. Usually, data warehouse is built to provide a decision support system to the management. Data warehouse can be mined (using data mining) and queried to collect overall and summarized business information that significantly helps in decision making. It can provide trends over many years.<\/p>\n<p>Operational databases are optimized for day to day operation access. Here, the relationships are normalized and further divided into more relations\/tables to make accessing faster that also reduces data traffic among the systems. But data warehouse does the reverse, where relationships\/tables are denormalized as much as possible to provide the required information to the management. As data warehouse provides summarized information de-normalization helps, otherwise the data would be required to collect from many tables and the queries may be running over data for 10 years (millions\/billions of records). Usually, data warehouse is created separately from the operational databases.<\/p>\n<p>Microsoft SQL Server and Oracle both have supports and tools to create Data warehouse Systems. There are also free tools for the purpose. From: http:\/\/sitestree.com\/?p=4816<br \/> Categories:44<br \/>Tags:<br \/> Post Data:2006-10-13 06:30:41<\/p>\n<pre><code>    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\"&gt;https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    (Big Data, Cloud, Security, Machine Learning): Courses: &lt;a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"&gt; http:\/\/Training.SitesTree.com&lt;\/a&gt; \n    In Bengali: &lt;a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\"&gt;http:\/\/Bangla.SaLearningSchool.com&lt;\/a&gt;\n    &lt;a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\"&gt;http:\/\/SitesTree.com&lt;\/a&gt;\n    8112223 Canada Inc.\/JustEtc: &lt;a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\"&gt;http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) &lt;\/a&gt;\n    Shop Online: &lt;a href='https:\/\/www.ShopForSoul.com'&gt; https:\/\/www.ShopForSoul.com\/&lt;\/a&gt;\n    Medium: &lt;a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"&gt; https:\/\/medium.com\/@SayedAhmedCanada &lt;\/a&gt;\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Data Warehouse is a storage of an organization&#8217;s historical data. Usually, data warehouse is built to provide a decision support system to the management. Data warehouse can be mined (using data mining) and queried to collect overall and summarized business information that significantly helps in decision making. It can provide trends over many years. Operational &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69199\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-69199","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":67640,"url":"http:\/\/bangla.sitestree.com\/?p=67640","url_meta":{"origin":69199,"position":0},"title":"What is Data Warehousing? #Data Warehouse #Data Warehouse &#8211; 001 #Data Warehouse #Data Warehouse Misc","author":"Author-Check- Article-or-Video","date":"July 26, 2021","format":false,"excerpt":"A Data Warehouse is a storage of an organization's historical data. Usually, data warehouse is built to provide a decision support system to the management. Data warehouse can be mined (using data mining) and queried to collect overall and summarized business information that significantly helps in decision making. It can\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67636,"url":"http:\/\/bangla.sitestree.com\/?p=67636","url_meta":{"origin":69199,"position":1},"title":"Steps in Data Warehouse Design and Implementation #Data Warehouse #Data Warehouse &#8211; 001 #Data Warehouse #Data Warehouse Misc","author":"Author-Check- Article-or-Video","date":"July 26, 2021","format":false,"excerpt":"\u00a0 Most BI projects usually fail. It is not due to the errors in the construction steps but due to the inappropriate design steps and methodologies. Waterfall method is not appropriate for BI. A method like developmental spiral may be more appropriate. Ref: [W. A. Giovinazzo ] Steps in developmental\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67638,"url":"http:\/\/bangla.sitestree.com\/?p=67638","url_meta":{"origin":69199,"position":2},"title":"Random Information on BI #Data Warehouse #Data Warehouse &#8211; 001 #Data Warehouse #Data Warehouse Misc","author":"Author-Check- Article-or-Video","date":"July 26, 2021","format":false,"excerpt":"Real internet money\/business lies in B2B not in B2C. Decision Support System (DSS): Full spectrum of systems that allow\/help management to take decisions, such as, reporting, OLAP, data mining. Java provides support for web enabled DSS JDM is Java's Data mining\/BI API. BI Applications: Balanced Score-card, Activity Based Costing. Data\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69209,"url":"http:\/\/bangla.sitestree.com\/?p=69209","url_meta":{"origin":69199,"position":3},"title":"Steps in Data Warehouse Design and Implementation #44","author":"Author-Check- Article-or-Video","date":"August 14, 2021","format":false,"excerpt":"Most BI projects usually fail. It is not due to the errors in construction steps but due to the inappropriate design steps and methodologies. Waterfall method is not appropriate for BI. A method like developmental spiral may be more appropriate. Ref: [W. A. Giovinazzo ] Steps in developmental spiral: Definition,\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":23982,"url":"http:\/\/bangla.sitestree.com\/?p=23982","url_meta":{"origin":69199,"position":4},"title":"Data Warehouse and Business Intelligence: Fact Tables and Dimension Tables #Root","author":"Author-Check- Article-or-Video","date":"April 3, 2021","format":false,"excerpt":"From: http:\/\/sitestree.com\/?p=2975 Categories:RootTags: Post Data:2015-10-27 01:40:28 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium: https:\/\/medium.com\/@SayedAhmedCanada","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22237,"url":"http:\/\/bangla.sitestree.com\/?p=22237","url_meta":{"origin":69199,"position":5},"title":"On Data Management from Enterprise Data Analytics to Data-Based Decision Making #Root #Data Warehouse Misc","author":"Author-Check- Article-or-Video","date":"March 12, 2021","format":false,"excerpt":"On Data Management from Enterprise Data Analytics to Data-Based Decision Making Establish data quality standards and train others in this regard Five steps to an improved data quality assurance plan Data Quality Standards Handbook on Data Quality Assessment Methods and Tools Five Fundamental Data Quality Practices data management\/analysis software tools\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69199"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69199\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69199"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}