Philip Howard is Research Director (Data Management) at Bloor Research. Data management refers to the management, movement, governance and storage of data and involves diverse technologies that include (but are not limited to) databases and data warehousing, data integration (including ETL, data migration and data federation), data quality, master data management, metadata management and log and event management. Philip also tracks spreadsheet management and complex event processing.

  • davoscollective

    I agree that an EDW is not practical, but it’s still an admirable goal. Federating datamarts or combining data from multiple OLAP solutions is not easy, it can be just as complex as creating the EDW in the first place. Sometimes you even have to merge the data into a reporting database first anyway.
    Pros: the data is merged and aligned once in the EDW.
    Cons: Datamarts are quicker to deploy and provide easy wins in the short term.
    Combining streamed and structured data is easy but unstructured is harder, take for example Microsoft’s Azure. The data market is becoming quite mature. You can subscribe to twitter dumps and import them into your DW where they would then become structured data. MSFT are also integrating Hadoop… So you have the ingredients of this *impossible* structured/unstructured/streamed enterprise data warehouse right there.