{"id":69209,"date":"2021-08-14T04:10:04","date_gmt":"2021-08-14T08:10:04","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/steps-in-data-warehouse-design-and-implementation-44\/"},"modified":"2021-08-14T04:10:04","modified_gmt":"2021-08-14T08:10:04","slug":"steps-in-data-warehouse-design-and-implementation-44","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=69209","title":{"rendered":"Steps in Data Warehouse Design and Implementation #44"},"content":{"rendered":"\n<ul>\n<li> Most BI projects usually fail.  It is not due to the errors in construction steps but due to the inappropriate design steps and methodologies.      <\/li>\n<li> Waterfall method is not appropriate for BI. A method like developmental spiral may be more appropriate. Ref: [W. A. Giovinazzo   ]     <\/li>\n<li> Steps in developmental spiral: Definition, Analysis, Design, Development, Implementation\/Deployment, Maintenance, Evaluation     <\/li>\n<li> Developmental spiral method is effective for BI only  when object oriented approach is taken    <\/li>\n<li> In developmental spiral, object modeling is used to represent objects in the related business areas. In object modeling, objects are represented as rectangles, the rectangles can be treated as classes. Classes\/objects can have sub-classes\/sub-objects. Objects have attributes. Objects also have some special properties like: accelerators, stops.<\/li>\n<li> Definition &#8211; first step of developmental spiral: Define a short description what you want to build &#8211; like the problem statement in a research proposal. Example:I want to build a data mart that will provide data to support the analysis of customer demographics such as age, gender, and income for all product lines<\/li>\n<li> Analysis Phase: In this step, analyze the requirements of the BI system, the nature of the BI system, the expectations from the BI system. Interviewing different parties will help a lot:<\/li>\n<li> Interview the sponsor to get a detail understanding of the mission. The questions will include: Data-related(which objects are related to the business needs?), user-related: who are the users, system evaluation: what parameters will make the project a success?<\/li>\n<li> Interviewing management: To understand management&#8217;s expectation of the data warehouse. Questions may include: User profile related (what types of systems you use\/will use to access BI?), System vision: what do you see as the objective of the data ware house, System Evaluation: what parameters will make the project a success?<\/li>\n<li> Interviewing Users : Interviewing users who will use the system<\/li>\n<li> Interviewing information technology staffs: To know the current state of the organization&#8217;s information systems<\/li>\n<li> Design phase: output &#8211; object model, implementation model<\/li>\n<li> Start with the analysis phase information. The design phase is complete when all the objects related to the mission are well defined. An object diagram needs  to be drawn showing all objects, relationships, attributes. <\/li>\n<li>Another chart listing all the attributes and their data types will be useful. Objects will have relations like super classes or sub-classes.<\/li>\n<li> Cardinality relationships: exactly one, one to many, zero or one, zero to many<\/li>\n<li> aggregation may be required in some cases. Aggregation: an object is composed of other objects.<\/li>\n<li> Implementation Model: Data warehouse databases are multi dimensional databases. Objects are represented in more than two dimensions. Common practice is: three dimensional databases. Such as an object\/table represented with three dimensions (called cube) like: product, dealer, and time. RDBMS&#8217;s are two dimensional. <\/li>\n<li> Data cubes: have six possible different views [permutation of three dimensions].<\/li>\n<li> Why not always multidimensional databases: because of space requirements.<\/li>\n<li> Star schema: Provides a multidimensional flavor in two dimensional relational databases.<\/li>\n<li> Star schema uses a concept called fact tables to bind dimensions to create a multidimensional space. <\/li>\n<li> Denormalization of the  tables are utilized in star schema to create multi dimension.<\/li>\n<li>Dimension table: Think about a three dimensional cube. Each wall represents a dimension table. Or think it as a mathematical combination of the dimensions.<\/li>\n<li>All objects represented in the dimensions can slowly change over time &#8211; slowly changing dimensions. There are many approaches to address this issue.<\/li>\n<li> Snowflakes: normalizing dimensions &#8211; not always a great thing<\/li>\n<li> Implementation considerations: Parallel processing, Bitmapped Indexing, Star Query Optimization, Summation Tables<\/li>\n<li>  <\/li>\n<\/ul>\n<p>From: http:\/\/sitestree.com\/?p=4900<br \/> Categories:44<br \/>Tags:<br \/> Post Data:2013-06-10 08:41:13<\/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>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, Analysis, Design, Development, Implementation\/Deployment, Maintenance, &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=69209\">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-69209","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":67636,"url":"http:\/\/bangla.sitestree.com\/?p=67636","url_meta":{"origin":69209,"position":0},"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":78099,"url":"http:\/\/bangla.sitestree.com\/?p=78099","url_meta":{"origin":69209,"position":1},"title":"Java Creational Design Patterns","author":"Sayed","date":"May 4, 2025","format":false,"excerpt":"5 types of creational design patterns: Factory Design Patterns: Purpose: Create Objects, Keep Object Creation Centralized Abstract Factory Design Patterns Singleton Design Pattern: Limit instantiation\u00a0 of a clas to only one instance Prototype Design Patterns: Object creation based on Prototype Object Instance; Simpler Object Creation than Factory. Builder Design Patterns:\u2026","rel":"","context":"In &quot;Root&quot;","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/05\/image-3.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/05\/image-3.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/05\/image-3.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/05\/image-3.png?resize=700%2C400 2x"},"classes":[]},{"id":16206,"url":"http:\/\/bangla.sitestree.com\/?p=16206","url_meta":{"origin":69209,"position":2},"title":"OOP concepts in PHP 5 in brief","author":"Sayed","date":"September 21, 2019","format":false,"excerpt":"OOP concepts in PHP 5 in brief OOP concepts in PHP 5 in brief OOP concepts in PHP 5 in short Why this short\u200a\u2014\u200anote? if you are familiar with OOD and any OOP language such as Java\/C++, this short note will give you enough information to start with PHP 5\u2026","rel":"","context":"In &quot;\u09ac\u09cd\u09b2\u0997 \u0964 Blog&quot;","block_context":{"text":"\u09ac\u09cd\u09b2\u0997 \u0964 Blog","link":"http:\/\/bangla.sitestree.com\/?cat=182"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":76014,"url":"http:\/\/bangla.sitestree.com\/?p=76014","url_meta":{"origin":69209,"position":3},"title":"Java : Decorator Design pattern","author":"Sayed","date":"May 6, 2024","format":false,"excerpt":"Decorator Design pattern: Decorator is a structural design pattern that lets you attach new behaviors to objects by placing these objects inside special wrapper objects that contain the behaviors. Example: Assume: A notifier class\/object can send only email messages. But the application at a later time may want to use\u2026","rel":"","context":"In &quot;Java Design Patterns and OOP&quot;","block_context":{"text":"Java Design Patterns and OOP","link":"http:\/\/bangla.sitestree.com\/?cat=1962"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-8.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-8.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-8.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2024\/05\/image-8.png?resize=700%2C400 2x"},"classes":[]},{"id":70025,"url":"http:\/\/bangla.sitestree.com\/?p=70025","url_meta":{"origin":69209,"position":4},"title":"OOP concepts in PHP 5 in brief #16","author":"Author-Check- Article-or-Video","date":"August 23, 2021","format":false,"excerpt":"OOP concepts in PHP 5 in short Why this short - note? if you are familiar with OOD and any OOP language such as Java\/C++, this short note will give you enough information to start with PHP 5 OOP Class Class definition starts with the keyword class, followed by a\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":78427,"url":"http:\/\/bangla.sitestree.com\/?p=78427","url_meta":{"origin":69209,"position":5},"title":"Builder Pattern vs \u2699\ufe0f Factory Pattern in Java","author":"Sayed","date":"August 28, 2025","format":false,"excerpt":"From AI Tools\/Open AI\/ChatGPT \" Perfect \ud83d\udc4d Here\u2019s a copyright-free comparison table of the Builder Pattern vs Factory Pattern in Java, styled for easy posting on Facebook\/Blog: \ud83c\udfd7\ufe0f Builder Pattern vs \u2699\ufe0f Factory Pattern in Java AspectBuilder PatternFactory PatternTypeCreational design patternCreational design patternPurposeTo construct complex objects step by step with\u2026","rel":"","context":"In &quot;Java Design Patterns and OOP&quot;","block_context":{"text":"Java Design Patterns and OOP","link":"http:\/\/bangla.sitestree.com\/?cat=1962"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/08\/image-27.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/08\/image-27.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/08\/image-27.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/08\/image-27.png?resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69209","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=69209"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/69209\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69209"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}