{"id":67640,"date":"2021-07-26T04:10:05","date_gmt":"2021-07-26T08:10:05","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/what-is-data-warehousing-data-warehouse-data-warehouse-001-data-warehouse-data-warehouse-misc\/"},"modified":"2021-07-26T04:10:05","modified_gmt":"2021-07-26T08:10:05","slug":"what-is-data-warehousing-data-warehouse-data-warehouse-001-data-warehouse-data-warehouse-misc","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=67640","title":{"rendered":"What is Data Warehousing? #Data Warehouse #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc"},"content":{"rendered":"

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 provide trends over many years.<\/p>\n

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 a data warehouse does the reverse, where relationships\/tables are de-normalized as much as possible to provide the required information to the management.<\/p>\n

As a 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

Microsoft SQL Server and Oracle both have supports and tools to create Data warehouse Systems. There are also free tools for the purpose even for My SQL. From: http:\/\/sitestree.com\/?p=3569
Categories:Data Warehouse, Data Warehouse – 001, Data Warehouse, Data Warehouse Misc
Tags:
Post Data:2016-07-05 15:37:20<\/p>\n

\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com<\/a>
\n\t\tIn Bengali: http:\/\/Bangla.SaLearningSchool.com<\/a>
\n\t\thttp:\/\/SitesTree.com<\/a>
\n\t\t8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a>
\n\t\tShop Online: https:\/\/www.ShopForSoul.com\/<\/a>
\n\t\tMedium: https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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 provide trends over many years. … <\/p>\n

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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1917],"tags":[],"class_list":["post-67640","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":69199,"url":"http:\/\/bangla.sitestree.com\/?p=69199","url_meta":{"origin":67640,"position":0},"title":"What is Data Warehousing? #44","author":"Author-Check- Article-or-Video","date":"August 13, 2021","format":false,"excerpt":"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 provide\u2026","rel":"","context":"In "FromSitesTree.com"","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":67640,"position":1},"title":"Steps in Data Warehouse Design and Implementation #Data Warehouse #Data Warehouse – 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 "FromSitesTree.com"","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":67640,"position":2},"title":"Random Information on BI #Data Warehouse #Data Warehouse – 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 "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67859,"url":"http:\/\/bangla.sitestree.com\/?p=67859","url_meta":{"origin":67640,"position":3},"title":"Data Warehouse – Dimension Design #By Sayed Ahmed #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc","author":"Author-Check- Article-or-Video","date":"July 29, 2021","format":false,"excerpt":"Data Warehouse - Dimension Design From: http:\/\/sitestree.com\/?p=1943 Categories:By Sayed Ahmed, Data Warehouse - 001, Data Warehouse, Data Warehouse MiscTags: Post Data:2015-03-07 20:10:29 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 "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":67861,"url":"http:\/\/bangla.sitestree.com\/?p=67861","url_meta":{"origin":67640,"position":4},"title":"Fact Table Design for a Data Warehouse #By Sayed Ahmed #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc","author":"Author-Check- Article-or-Video","date":"July 29, 2021","format":false,"excerpt":"Fact Table Design for a Data Warehouse [youtube https:\/\/www.youtube.com\/watch?v=80tI2q9qL-c&w=640&h=480] From: http:\/\/sitestree.com\/?p=1971 Categories:By Sayed Ahmed, Data Warehouse - 001, Data Warehouse, Data Warehouse MiscTags: Post Data:2015-03-21 13:35:38 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\/\u2026","rel":"","context":"In "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22581,"url":"http:\/\/bangla.sitestree.com\/?p=22581","url_meta":{"origin":67640,"position":5},"title":"Logical Design for Data Warehouse #Root #By Sayed Ahmed #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc","author":"Author-Check- Article-or-Video","date":"March 16, 2021","format":false,"excerpt":"Logical Design for Data Warehouse \u00a0 \u00a0 [youtube https:\/\/www.youtube.com\/watch?v=0MFBP14FCqQ] From: http:\/\/sitestree.com\/?p=1931 Categories:Root, By Sayed Ahmed, Data Warehouse - 001, Data Warehouse, Data Warehouse MiscTags: Post Data:2015-02-24 21:18:26 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:\u2026","rel":"","context":"In "FromSitesTree.com"","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\/67640","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=67640"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/67640\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67640"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}