微软并行数据仓库技术概述在大数据存储中的应用.pptx

Microsoft Parallel DataWarehouse微软并行数据仓库Data sources数据源2sourcesData Non-Relational Data数据源 非关系型数据3?Non-relational data 非关系型数据Data sources 数据源Gain knowledge of all your existing data 通过任何数据获得知识Enrich and optimize your data from non-traditional sources 通过非关系型数据源富集并优化数据Roadblocks to evolving to a modern data warehouse现代化数据仓库面临的发展障碍Keep legacyinvestment保持原有投资Acquire big datasolution获取大数据解决方案Buy new tier onehardware appliance购买第一层硬件设备Acquire businessintelligence获取商业智能 Complex with low adoption过于复杂，接受度低 Limited scalability ability to handle new data types扩展性有限，无法处理新型 数据Significant training still siloed 需要大量培训，不同系 统相互隔离High acquisition/ migration Costs购买/迁移成本高Microsoft Parallel Data Warehouse 微软并行数据仓库The turnkey modern data warehouse appliance 现代化数据仓库设备一体机Hadoop alone is not the answer to all big data challengesHadoop 自身并非所有大数据问题的终极答案Steep learning curve, slow and inefficientHadoop ecosystem陡峭的学习曲线，缓慢低效的 Hadoop 生态系统 Move HDFS into the warehouse before analysis分析前需将 HDFS 迁移至仓库“New” data sources “新”数据源Learn new skills/学习新技能TSQL“New” data sourcesBuildIntegrateManageMaintainSupport构建集成式管理的维护支持“New “新”数据源 sources” dataETLConnecting islands of data with PolyBase 使用 PolyBase 连接信息孤岛Bringing Hadoop point solutions and the data warehouse together for users and IT将 Hadoop 单点解决方案与数据仓库打包供用户与 IT 使用Select选择…Result set 结果集HortonworksWindows ServerSingle T-SQL query model for PDW and Hadoop with richfeatures of T-SQL including joins without ETLPDW 与 Hadoop 可使用通用的 T-SQL 查询模型，并具备丰富的T-SQL 功能，包括无需 ETL 的连接Leverages the power of MPP to enhance query executionperformance利用大规模并行处理的强大运算能力改善查询性能Supports Windows Azure HDInsight to enable new hybrid cloudscenarios支持 Windows Azure HDInsight，实现全新混合云场景Query non-Microsoft Hadoop distributions such as Hortonworksand Cloudera查询非微软 Hadoop 发行版，例如 Hortonworks 与 Cloudera SQL Server Parallel Data WarehouseSQL Server 并行数 据仓库 PolyBase Microsoft HDInsightWindows AzureHDInsightClouderaHortonworks LinuxComing Soon:PDW delivers enterprise-ready Hadoop with HDInsight