Home
Podcast:
EMAIL THIS

Data warehouse architecture: Beyond hub-and-spoke

09 Jun 2009 | SearchDataManagement.com

Tips, expert advice and sample chapters
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

In the world of software and data, the one thing I've learned is that there are no absolutes.
--Evan Levy, co-founder and partner, Baseline Consulting

Creating an efficient data warehouse is challenging, and there are many issues to consider, including data latency, data requirements, who needs the data, why, when and more. When it comes to choosing a data warehouse architecture, how can information management professionals determine if a hub-and-spoke architecture is the right one for their data warehouse? How can they assess the data warehouse options that are out there and make the right decision?

To help you get a better handle on hub-and-spoke architecture and the important issues surrounding data warehousing, we turned to consultant and data management expert Evan Levy, co-founder and partner of Baseline Consulting, a technology and management consulting firm specializing in business analytics and data integration.

In this 15-minute podcast, listeners will learn:

  • The background of hub-and-spoke architecture and how it came to be (0:50)


  • The challenges of a hub-and-spoke design and which situations it's ideal and not so ideal for (3:30)


  • Issues and details companies should consider when reviewing their hub-and-spoke architecture (7:00)


  • How data governance plays a role in a hub-and-spoke model (9:30)


  • If there's any risk that hub-and-spoke architecture will become tomorrow's data silo (12:10)

  •   Data warehouse architecture: Beyond hub-and-spoke 
    Play now:

    You must have Adobe Flash Player 7 or above to view this content. See http://www.adobe.com/products/flashplayer to download now.
    Download for later:

    Data warehouse architecture: Beyond hub-and-spoke
    • Internet Explorer: Right Click > Save Target As
    • Firefox: Right Click > Save Link As

       Related resources on data warehousing and data integration 

      About the speaker 

    Evan Levy, partner & co-founder, Baseline Consulting

    Evan Levy is a partner and co-founder of Baseline Consulting, a technology and management consulting firm specializing in business analytics and data integration. Evan is actively involved in guiding projects and delivering solutions to Baseline's Fortune 1000 family of clients and has delivered data integration strategies at companies like Microsoft, American Express, and Verizon. Considered an industry leader on the topic of data integration and management, Evan advises vendors and VC firms on new and emerging product strategies. He is a faculty member of The Data Warehousing Institute and a contributor to several leading industry publications and portals. Evan also writes the Inside IT blog on Baseline's website. He is co-author of the book Customer Data Integration: Reaching a Single Version of the Truth which was the first book published on the topic of master data management.

    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



    RELATED CONTENT
    Database management systems (DBMS) architecture and design
    Definition of primary, super, foreign and candidate key in the DBMS
    What is the difference between a logical and physical warehouse design?
    What are some emerging data warehouse and DBMS trends?
    Data Warehouse Platforms Product Directory
    Designing for performance: Strategic database application deployments
    An introduction to database transaction management
    Database access security: network authentication or data encryption?
    Executing SQL statements using prepared statements and statement pooling
    Static SQL vs. dynamic SQL for database application performance
    How to get data/database independence with a three-tier architecture

    Enterprise data architecture best practices
    Is in-database analytics an emerging business intelligence (BI) trend?
    Understanding in-database analytics technology: Benefits, uses and ROI
    Advantages and disadvantages of XML shredding
    How to shred XML with the DB2 XMLTABLE function
    Shredding XML docs into relational tables with annotated XML schemas
    Teradata takes a logical approach to data warehousing appliances
    Examples of single and bulk XML shredding of XML documents
    What is the difference between a logical and physical warehouse design?
    What are some emerging data warehouse and DBMS trends?
    Teradata VP talks data warehouse appliances, reveals cloud and SSD plans

    Data management podcasts
    In-database analytics demystified
    For business intelligence success, culture counts as much as technology
    Evaluating and selecting a master data management (MDM) vendor
    Best practices for data management system implementations
    Uncovering the new data governance trends, with Ventana Research
    Exploring key trends in data integration for data warehouses
    Data management and business intelligence jobs: Career advice and insight
    Selling your boss on master data management
    Automating Sarbanes-Oxley compliance: Understanding SOX software
    Governance, risk and compliance software trends and best practices

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    data classification  (SearchDataManagement.com)
    OLAP  (SearchDataManagement.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary




    Data Compliance Articles and Research: Data Privacy, Financial Data Management, Healthcare Data
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts