Agile Database Techniques

Download Agile Database Techniques full books in PDF, epub, and Kindle. Read online Agile Database Techniques ebook anywhere anytime directly on your device. Fast Download speed and no annoying ads. We cannot guarantee that every ebooks is available!

Agile Database Techniques

Author : Scott Ambler
Publisher : John Wiley & Sons
ISBN 13 : 1118081366
Total Pages : 482 pages
Book Rating : 4.1/5 (18 download)

DOWNLOAD NOW!

Book Synopsis Agile Database Techniques by : Scott Ambler

Download or read book Agile Database Techniques written by Scott Ambler and published by John Wiley & Sons. This book was released on 2012-09-17 with total page 482 pages. Available in PDF, EPUB and Kindle. Book excerpt: Describes Agile Modeling Driven Design (AMDD) and Test-Driven Design (TDD) approaches, database refactoring, database encapsulation strategies, and tools that support evolutionary techniques Agile software developers often use object and relational database (RDB) technology together and as a result must overcome the impedance mismatch The author covers techniques for mapping objects to RDBs and for implementing concurrency control, referential integrity, shared business logic, security access control, reports, and XML An agile foundation describes fundamental skills that all agile software developers require, particularly Agile DBAs Includes object modeling, UML data modeling, data normalization, class normalization, and how to deal with legacy databases Scott W. Ambler is author of Agile Modeling (0471202827), a contributing editor with Software Development (www.sdmagazine.com), and a featured speaker at software conferences worldwide

Refactoring Databases

Author : Scott W. Ambler
Publisher : Pearson Education
ISBN 13 : 0321630173
Total Pages : 554 pages
Book Rating : 4.3/5 (216 download)

DOWNLOAD NOW!

Book Synopsis Refactoring Databases by : Scott W. Ambler

Download or read book Refactoring Databases written by Scott W. Ambler and published by Pearson Education. This book was released on 2006-03-03 with total page 554 pages. Available in PDF, EPUB and Kindle. Book excerpt: Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems. Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies. This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase. Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.

Agile Analytics

Author : Ken Collier
Publisher : Addison-Wesley
ISBN 13 : 032150481X
Total Pages : 368 pages
Book Rating : 4.3/5 (215 download)

DOWNLOAD NOW!

Book Synopsis Agile Analytics by : Ken Collier

Download or read book Agile Analytics written by Ken Collier and published by Addison-Wesley. This book was released on 2012 with total page 368 pages. Available in PDF, EPUB and Kindle. Book excerpt: Using Agile methods, you can bring far greater innovation, value, and quality to any data warehousing (DW), business intelligence (BI), or analytics project. However, conventional Agile methods must be carefully adapted to address the unique characteristics of DW/BI projects. In Agile Analytics, Agile pioneer Ken Collier shows how to do just that. Collier introduces platform-agnostic Agile solutions for integrating infrastructures consisting of diverse operational, legacy, and specialty systems that mix commercial and custom code. Using working examples, he shows how to manage analytics development teams with widely diverse skill sets and how to support enormous and fast-growing data volumes. Collier's techniques offer optimal value whether your projects involve "back-end" data management, "front-end" business analysis, or both. Part I focuses on Agile project management techniques and delivery team coordination, introducing core practices that shape the way your Agile DW/BI project community can collaborate toward success Part II presents technical methods for enabling continuous delivery of business value at production-quality levels, including evolving superior designs; test-driven DW development; version control; and project automation Collier brings together proven solutions you can apply right now--whether you're an IT decision-maker, data warehouse professional, database administrator, business intelligence specialist, or database developer. With his help, you can mitigate project risk, improve business alignment, achieve better results--and have fun along the way.

Agile Data Warehouse Design

Author : Lawrence Corr
Publisher : DecisionOne Consulting
ISBN 13 : 0956817203
Total Pages : 330 pages
Book Rating : 4.9/5 (568 download)

DOWNLOAD NOW!

Book Synopsis Agile Data Warehouse Design by : Lawrence Corr

Download or read book Agile Data Warehouse Design written by Lawrence Corr and published by DecisionOne Consulting. This book was released on 2011-11 with total page 330 pages. Available in PDF, EPUB and Kindle. Book excerpt: Agile Data Warehouse Design is a step-by-step guide for capturing data warehousing/business intelligence (DW/BI) requirements and turning them into high performance dimensional models in the most direct way: by modelstorming (data modeling + brainstorming) with BI stakeholders. This book describes BEAM✲, an agile approach to dimensional modeling, for improving communication between data warehouse designers, BI stakeholders and the whole DW/BI development team. BEAM✲ provides tools and techniques that will encourage DW/BI designers and developers to move away from their keyboards and entity relationship based tools and model interactively with their colleagues. The result is everyone thinks dimensionally from the outset! Developers understand how to efficiently implement dimensional modeling solutions. Business stakeholders feel ownership of the data warehouse they have created, and can already imagine how they will use it to answer their business questions. Within this book, you will learn: ✲ Agile dimensional modeling using Business Event Analysis & Modeling (BEAM✲) ✲ Modelstorming: data modeling that is quicker, more inclusive, more productive, and frankly more fun! ✲ Telling dimensional data stories using the 7Ws (who, what, when, where, how many, why and how) ✲ Modeling by example not abstraction; using data story themes, not crow's feet, to describe detail ✲ Storyboarding the data warehouse to discover conformed dimensions and plan iterative development ✲ Visual modeling: sketching timelines, charts and grids to model complex process measurement - simply ✲ Agile design documentation: enhancing star schemas with BEAM✲ dimensional shorthand notation ✲ Solving difficult DW/BI performance and usability problems with proven dimensional design patterns Lawrence Corr is a data warehouse designer and educator. As Principal of DecisionOne Consulting, he helps clients to review and simplify their data warehouse designs, and advises vendors on visual data modeling techniques. He regularly teaches agile dimensional modeling courses worldwide and has taught dimensional DW/BI skills to thousands of students. Jim Stagnitto is a data warehouse and master data management architect specializing in the healthcare, financial services, and information service industries. He is the founder of the data warehousing and data mining consulting firm Llumino.

Disciplined Agile Delivery

Author : Scott W. Ambler
Publisher : IBM Press
ISBN 13 : 0132810107
Total Pages : 544 pages
Book Rating : 4.1/5 (328 download)

DOWNLOAD NOW!

Book Synopsis Disciplined Agile Delivery by : Scott W. Ambler

Download or read book Disciplined Agile Delivery written by Scott W. Ambler and published by IBM Press. This book was released on 2012-05-31 with total page 544 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master IBM’s Breakthrough DAD Process Framework for Succeeding with Agile in Large, Complex, Mission-Critical IT Projects It is widely recognized that moving from traditional to agile approaches to build software solutions is a critical source of competitive advantage. Mainstream agile approaches that are indeed suitable for small projects require significant tailoring for larger, complex enterprise projects. In Disciplined Agile Delivery, Scott W. Ambler and Mark Lines introduce IBM’s breakthrough Disciplined Agile Delivery (DAD) process framework, which describes how to do this tailoring. DAD applies a more disciplined approach to agile development by acknowledging and dealing with the realities and complexities of a portfolio of interdependent program initiatives. Ambler and Lines show how to extend Scrum with supplementary agile and lean strategies from Agile Modeling (AM), Extreme Programming (XP), Kanban, Unified Process (UP), and other proven methods to provide a hybrid approach that is adaptable to your organization’s unique needs. They candidly describe what practices work best, why they work, what the trade-offs are, and when to consider alternatives, all within the context of your situation. Disciplined Agile Delivery addresses agile practices across the entire lifecycle, from requirements, architecture, and development to delivery and governance. The authors show how these best-practice techniques fit together in an end-to-end process for successfully delivering large, complex systems--from project initiation through delivery. Coverage includes Scaling agile for mission-critical enterprise endeavors Avoiding mistakes that drive poorly run agile projects to chaos Effectively initiating an agile project Transitioning as an individual to agile Incrementally building consumable solutions Deploying agile solutions into complex production environments Leveraging DevOps, architecture, and other enterprise disciplines Adapting your governance strategy for agile projects Based on facts, research, and extensive experience, this book will be an indispensable resource for every enterprise software leader and practitioner--whether they’re seeking to optimize their existing agile/Scrum process or improve the agility of an iterative process.

Choose Your WoW!

Author : Scott W. Ambler
Publisher : Project Management Institute
ISBN 13 : 9781628256505
Total Pages : 0 pages
Book Rating : 4.2/5 (565 download)

DOWNLOAD NOW!

Book Synopsis Choose Your WoW! by : Scott W. Ambler

Download or read book Choose Your WoW! written by Scott W. Ambler and published by Project Management Institute. This book was released on 2020 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: "Hundreds of organizations around the world have already benefited from Disciplined Agile Delivery (DAD). Disciplined Agile (DA) is the only comprehensive tool kit available for guidance on building high-performance agile teams and optimizing your way of working (WoW). As a hybrid of all the leading agile and lean approaches, it provides hundreds of strategies to help you make better decisions within your agile teams, balancing self-organization with the realities and constraints of your unique enterprise context. The highlights of this handbook include: #1. As the official source of knowledge on DAD, it includes greatly improved and enhanced strategies with a revised set of goal diagrams based upon learnings from applying DAD in the field. #2 It is an essential handbook to help coaches and teams make better decisions in their daily work, providing a wealth of ideas for experimenting with agile and lean techniques while providing specific guidance and trade-offs for those "it depends" questions. #3 It makes a perfect study guide for Disciplined Agile certification. Why "fail fast" (as our industry likes to recommend) when you can learn quickly on your journey to high performance? With this handbook, you can make better decisions based upon proven, context-based strategies, leading to earlier success and better outcomes"--

Agile Data Warehousing

Author : Ralph Hughes
Publisher : iUniverse
ISBN 13 : 0595471676
Total Pages : 323 pages
Book Rating : 4.5/5 (954 download)

DOWNLOAD NOW!

Book Synopsis Agile Data Warehousing by : Ralph Hughes

Download or read book Agile Data Warehousing written by Ralph Hughes and published by iUniverse. This book was released on 2008-07-14 with total page 323 pages. Available in PDF, EPUB and Kindle. Book excerpt: Contains a six-stage plan for starting new warehouse projects and guiding programmers step-by-step until they become a world-class, Agile development team. It describes also how to avoid or contain the fierce opposition that radically new methods can encounter from the traditionally-minded IS departments found in many large companies.

Agile Estimating and Planning

Author : Mike Cohn
Publisher : Pearson Education
ISBN 13 : 0132703106
Total Pages : 526 pages
Book Rating : 4.1/5 (327 download)

DOWNLOAD NOW!

Book Synopsis Agile Estimating and Planning by : Mike Cohn

Download or read book Agile Estimating and Planning written by Mike Cohn and published by Pearson Education. This book was released on 2005-11-01 with total page 526 pages. Available in PDF, EPUB and Kindle. Book excerpt: Agile Estimating and Planning is the definitive, practical guide to estimating and planning agile projects. In this book, Agile Alliance cofounder Mike Cohn discusses the philosophy of agile estimating and planning and shows you exactly how to get the job done, with real-world examples and case studies. Concepts are clearly illustrated and readers are guided, step by step, toward how to answer the following questions: What will we build? How big will it be? When must it be done? How much can I really complete by then? You will first learn what makes a good plan-and then what makes it agile. Using the techniques in Agile Estimating and Planning, you can stay agile from start to finish, saving time, conserving resources, and accomplishing more. Highlights include: Why conventional prescriptive planning fails and why agile planning works How to estimate feature size using story points and ideal days–and when to use each How and when to re-estimate How to prioritize features using both financial and nonfinancial approaches How to split large features into smaller, more manageable ones How to plan iterations and predict your team's initial rate of progress How to schedule projects that have unusually high uncertainty or schedule-related risk How to estimate projects that will be worked on by multiple teams Agile Estimating and Planning supports any agile, semiagile, or iterative process, including Scrum, XP, Feature-Driven Development, Crystal, Adaptive Software Development, DSDM, Unified Process, and many more. It will be an indispensable resource for every development manager, team leader, and team member.

Agile Modeling

Author : Scott Ambler
Publisher : John Wiley & Sons
ISBN 13 : 047127190X
Total Pages : 402 pages
Book Rating : 4.4/5 (712 download)

DOWNLOAD NOW!

Book Synopsis Agile Modeling by : Scott Ambler

Download or read book Agile Modeling written by Scott Ambler and published by John Wiley & Sons. This book was released on 2002-08-14 with total page 402 pages. Available in PDF, EPUB and Kindle. Book excerpt: The first book to cover Agile Modeling, a new modeling technique created specifically for XP projects eXtreme Programming (XP) has created a buzz in the software development community-much like Design Patterns did several years ago. Although XP presents a methodology for faster software development, many developers find that XP does not allow for modeling time, which is critical to ensure that a project meets its proposed requirements. They have also found that standard modeling techniques that use the Unified Modeling Language (UML) often do not work with this methodology. In this innovative book, Software Development columnist Scott Ambler presents Agile Modeling (AM)-a technique that he created for modeling XP projects using pieces of the UML and Rational's Unified Process (RUP). Ambler clearly explains AM, and shows readers how to incorporate AM, UML, and RUP into their development projects with the help of numerous case studies integrated throughout the book. AM was created by the author for modeling XP projects-an element lacking in the original XP design The XP community and its creator have embraced AM, which should give this book strong market acceptance Companion Web site at www.agilemodeling.com features updates, links to XP and AM resources, and ongoing case studies about agile modeling.

The Object Primer

Author : Scott W. Ambler
Publisher : Cambridge University Press
ISBN 13 : 0521540186
Total Pages : 574 pages
Book Rating : 4.5/5 (215 download)

DOWNLOAD NOW!

Book Synopsis The Object Primer by : Scott W. Ambler

Download or read book The Object Primer written by Scott W. Ambler and published by Cambridge University Press. This book was released on 2004-03-22 with total page 574 pages. Available in PDF, EPUB and Kindle. Book excerpt: The acclaimed beginner's book on object technology now presents UML 2.0, Agile Modeling, and object development techniques.

Agile Data Science

Author : Russell Jurney
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 1449326919
Total Pages : 269 pages
Book Rating : 4.4/5 (493 download)

DOWNLOAD NOW!

Book Synopsis Agile Data Science by : Russell Jurney

Download or read book Agile Data Science written by Russell Jurney and published by "O'Reilly Media, Inc.". This book was released on 2013-10-15 with total page 269 pages. Available in PDF, EPUB and Kindle. Book excerpt: Mining big data requires a deep investment in people and time. How can you be sure you’re building the right models? With this hands-on book, you’ll learn a flexible toolset and methodology for building effective analytics applications with Hadoop. Using lightweight tools such as Python, Apache Pig, and the D3.js library, your team will create an agile environment for exploring data, starting with an example application to mine your own email inboxes. You’ll learn an iterative approach that enables you to quickly change the kind of analysis you’re doing, depending on what the data is telling you. All example code in this book is available as working Heroku apps. Create analytics applications by using the agile big data development methodology Build value from your data in a series of agile sprints, using the data-value stack Gain insight by using several data structures to extract multiple features from a single dataset Visualize data with charts, and expose different aspects through interactive reports Use historical data to predict the future, and translate predictions into action Get feedback from users after each sprint to keep your project on track

The Business Value of Agile Software Methods

Author : David F. Rico
Publisher : J. Ross Publishing
ISBN 13 : 1604270314
Total Pages : 241 pages
Book Rating : 4.6/5 (42 download)

DOWNLOAD NOW!

Book Synopsis The Business Value of Agile Software Methods by : David F. Rico

Download or read book The Business Value of Agile Software Methods written by David F. Rico and published by J. Ross Publishing. This book was released on 2009-10-15 with total page 241 pages. Available in PDF, EPUB and Kindle. Book excerpt: Whether to continue using traditional cost and benefit analysis methods such as systems and software engineering standards or to use a relatively new family of software development processes known as Agile methods is one of most prevalent questions within the information technology field today. Since each family of methods has its strengths and weaknesses, the question being raised by a growing number of executives and practitioners is: Which family of methods provides the greater business value and return on investment (ROI)? Whereas traditional methods have been in use for many decades, Agile methods are still a new phenomenon and, until now, very little literature has existed on how to quantify the business value of Agile methods in economic terms, such as ROI and net present value (NPV). Using cost of quality, total cost of ownership, and total life cycle cost parameters, The Business Value of Agile Software Methods offers a comprehensive methodology and introduces the industry's initial top-down parametric models for quantifying the costs and benefits of using Agile methods to create innovative software products. Based on real-world data, it illustrates the first simple-to-use parametric models of Real Options for estimating the business value of Agile methods since the inception of the Nobel prize winning Black-Scholes formulas. Numerous examples on how to estimate the costs, benefits, ROI, NPV, and real options of the major types of Agile methods such as Scrum, Extreme Programming and Crystal Methods are also included. In addition, this reference provides the first comprehensive compilation of cost and benefit data on Agile methods from an analysis of hundreds of research studies.The Business Value of Agile Software Methods shatters key myths and misconceptions surrounding the modern-day phenomenon of Agile methods for creating innovative software products. It provides a complete business value comparison between traditional and Agile methods. The keys to maximizing the business value of any method are low costs and high benefits and the business value of Agile methods, when compared to traditional methods, proves to be very impressive. Agile methods are a new model of project management that can be used to improve the success, business value, and ROI of high-risk and highly complex IT projects in today's dynamic, turbulent, and highly uncertain marketplace. If you are an executive, manager, scholar, student, consultant or practitioner currently on the fence, you need to read this book!

NoSQL Distilled

Author : Pramod J. Sadalage
Publisher : Pearson Education
ISBN 13 : 0321826620
Total Pages : 188 pages
Book Rating : 4.3/5 (218 download)

DOWNLOAD NOW!

Book Synopsis NoSQL Distilled by : Pramod J. Sadalage

Download or read book NoSQL Distilled written by Pramod J. Sadalage and published by Pearson Education. This book was released on 2013 with total page 188 pages. Available in PDF, EPUB and Kindle. Book excerpt: 'NoSQL Distilled' is designed to provide you with enough background on how NoSQL databases work, so that you can choose the right data store without having to trawl the whole web to do it. It won't answer your questions definitively, but it should narrow down the range of options you have to consider.

Agile Data Science 2.0

Author : Russell Jurney
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 1491960086
Total Pages : 351 pages
Book Rating : 4.4/5 (919 download)

DOWNLOAD NOW!

Book Synopsis Agile Data Science 2.0 by : Russell Jurney

Download or read book Agile Data Science 2.0 written by Russell Jurney and published by "O'Reilly Media, Inc.". This book was released on 2017-06-07 with total page 351 pages. Available in PDF, EPUB and Kindle. Book excerpt: Data science teams looking to turn research into useful analytics applications require not only the right tools, but also the right approach if they’re to succeed. With the revised second edition of this hands-on guide, up-and-coming data scientists will learn how to use the Agile Data Science development methodology to build data applications with Python, Apache Spark, Kafka, and other tools. Author Russell Jurney demonstrates how to compose a data platform for building, deploying, and refining analytics applications with Apache Kafka, MongoDB, ElasticSearch, d3.js, scikit-learn, and Apache Airflow. You’ll learn an iterative approach that lets you quickly change the kind of analysis you’re doing, depending on what the data is telling you. Publish data science work as a web application, and affect meaningful change in your organization. Build value from your data in a series of agile sprints, using the data-value pyramid Extract features for statistical models from a single dataset Visualize data with charts, and expose different aspects through interactive reports Use historical data to predict the future via classification and regression Translate predictions into actions Get feedback from users after each sprint to keep your project on track

An Agile Adoption and Transformation Survival Guide

Author : Michael Sahota
Publisher : Lulu.com
ISBN 13 : 1105735729
Total Pages : 81 pages
Book Rating : 4.1/5 (57 download)

DOWNLOAD NOW!

Book Synopsis An Agile Adoption and Transformation Survival Guide by : Michael Sahota

Download or read book An Agile Adoption and Transformation Survival Guide written by Michael Sahota and published by Lulu.com. This book was released on 2012-07-16 with total page 81 pages. Available in PDF, EPUB and Kindle. Book excerpt: This book provides a set of essential thinking tools for understanding Agile adoption and transformation: how they differ and what you need to know to avoid being another statistic in the widespread adoption failure. In particular, you will learn how to use culture to work more effectively with your organization. It is called a survival guide since so many people have found the concepts to be invaluable in understanding their experiences when working with Agile. This book includes: Identification of causes of the widespread Agile adoption failure A model for understanding Agile, Kanban, and Software Craftsmanship culture An outline of key adoption and transformation approaches A framework to help guide when to use these these approaches with your organization Real-life case studies of what has worked and what hasn'

Agile Java¿

Author : Jeff Langr
Publisher : Pearson Education
ISBN 13 : 0672334216
Total Pages : 1069 pages
Book Rating : 4.6/5 (723 download)

DOWNLOAD NOW!

Book Synopsis Agile Java¿ by : Jeff Langr

Download or read book Agile Java¿ written by Jeff Langr and published by Pearson Education. This book was released on 2005-02-14 with total page 1069 pages. Available in PDF, EPUB and Kindle. Book excerpt: Master Java 5.0 and TDD Together: Build More Robust, Professional Software Master Java 5.0, object-oriented design, and Test-Driven Development (TDD) by learning them together. Agile Java weaves all three into a single coherent approach to building professional, robust software systems. Jeff Langr shows exactly how Java and TDD integrate throughout the entire development lifecycle, helping you leverage today's fastest, most efficient development techniques from the very outset. Langr writes for every programmer, even those with little or no experience with Java, object-oriented development, or agile methods. He shows how to translate oral requirements into practical tests, and then how to use those tests to create reliable, high-performance Java code that solves real problems. Agile Java doesn't just teach the core features of the Java language: it presents coded test examples for each of them. This TDD-centered approach doesn't just lead to better code: it provides powerful feedback that will help you learn Java far more rapidly. The use of TDD as a learning mechanism is a landmark departure from conventional teaching techniques. Presents an expert overview of TDD and agile programming techniques from the Java developer's perspective Brings together practical best practices for Java, TDD, and OO design Walks through setting up Java 5.0 and writing your first program Covers all the basics, including strings, packages, and more Simplifies object-oriented concepts, including classes, interfaces, polymorphism, and inheritance Contains detailed chapters on exceptions and logging, math, I/O, reflection, multithreading, and Swing Offers seamlessly-integrated explanations of Java 5.0's key innovations, from generics to annotations Shows how TDD impacts system design, and vice versa Complements any agile or traditional methodology, including Extreme Programming (XP)

The Data Warehouse Toolkit

Author : Ralph Kimball
Publisher : John Wiley & Sons
ISBN 13 : 1118082141
Total Pages : 464 pages
Book Rating : 4.1/5 (18 download)

DOWNLOAD NOW!

Book Synopsis The Data Warehouse Toolkit by : Ralph Kimball

Download or read book The Data Warehouse Toolkit written by Ralph Kimball and published by John Wiley & Sons. This book was released on 2011-08-08 with total page 464 pages. Available in PDF, EPUB and Kindle. Book excerpt: This old edition was published in 2002. The current and final edition of this book is The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition which was published in 2013 under ISBN: 9781118530801. The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including: Retail sales and e-commerce Inventory management Procurement Order management Customer relationship management (CRM) Human resources management Accounting Financial services Telecommunications and utilities Education Transportation Health care and insurance By the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.