中國電信經(jīng)營分析系統(tǒng)(編輯修改稿)
2025-03-06 16:38 本頁面
【文章內(nèi)容簡(jiǎn)介】 硬盤硬盤DB文件文件表表應(yīng)用應(yīng)用 內(nèi)存內(nèi)存?zhèn)浞輽C(jī)備份機(jī)硬盤硬盤DB 文件文件表表應(yīng)用應(yīng)用 內(nèi)存內(nèi)存輸入輸入 輸入輸入 物理視圖物理視圖 DB視圖視圖 數(shù)據(jù)庫模式視圖數(shù)據(jù)庫模式視圖 應(yīng)用視圖應(yīng)用視圖復(fù)制或轉(zhuǎn)移復(fù)制或轉(zhuǎn)移Part3 解決方案◆ 技術(shù)體系結(jié)構(gòu)◆ 主要廠商產(chǎn)品介紹產(chǎn)品供應(yīng)商IBM Corp.Oracle Corp.SAS InstituteMicrosoft Corp.MicroStrategy Inc.CABrio TechnologyBusiness Objects Inc.Cognos產(chǎn)品供應(yīng)商? Data warehouses? OLAP? Data mining? Reporting, Querying and business intelligence? ETL–Oracle–Sybase–SAS–DB2–NCR–BI/SAS–DB2 Olap Server–Oracle Express–Business Objects/OLAP access–SAS Data mining–Geneva(PwC)–Intelligent Miner,Visualization(IBM)–MineSet (Silicon Graphics)–Visual Insights(Lucent)–Business Objects–Brio–Adaptive Server IQ multiplex(Sybase)–Actuate–Hummingbird suite–NUMAQ2023(IBM)–Pilot Balanced Score card–OWB–Informatica–CA Data Transformer–SAS/WABest WorstRelative to all platforms (including S/390)。updated April 2023 Copyright 169。 2023Data Mgmt.Data Admin.Scalability SuitabilityConcurrent Query Mgmt.DW Track RecordQuery PerformanceHPHP9000HPUXOracle IBM SPRS/6000AIXDB2 EEESunEnterpriseSolarisOracle GenericIntel IA32Win2023SQL ServerUnisysES7000Win2023SQL ServerIBMS/390OS/390DB2 EEECompaqAlphaTru64OracleNCRWorldMarkMPRASTeradata主機(jī)廠家 :主機(jī)型號(hào) :操作系統(tǒng) :數(shù)據(jù)倉庫平臺(tái) :數(shù)據(jù)倉庫比較Copyright 169。 2023IBM DB2IBM數(shù)據(jù)倉庫解決方案DB2 Warehouse Manager (管理工具 )DB2 Visual warehousing(ETL)MIS/OABOSS網(wǎng)管DB2 UDB數(shù)據(jù)倉庫DB2 OLAPSERVER(MDB)查詢?nèi)藛T分析人員Hyperion analyzer 決策人員IBM Intelligent Miner 數(shù)據(jù)挖掘DB2 Warehouse ManagerDB2 UDB數(shù)據(jù)集市外部來源DB2 UDB數(shù)據(jù)集市Enterprise Information PortalIBM數(shù)據(jù)倉庫的特點(diǎn)? 提供大型數(shù)據(jù)庫 DB2作為數(shù)據(jù)倉庫的存儲(chǔ)數(shù)據(jù)庫， DB2性能優(yōu)異，提供從桌面機(jī)到工作站、小型機(jī)、大型機(jī)的良好擴(kuò)展性 ? 提供 Visual Warehousing作為數(shù)據(jù)抽取工具，VW能夠從廣泛的數(shù)據(jù)源抽取數(shù)據(jù)，并且在大數(shù)據(jù)量的抽取中充分顯示了速度優(yōu)勢(shì) ? 提供多維型、關(guān)系型兩種 Cube的實(shí)現(xiàn)方式 ? 提供功能強(qiáng)大的訪問 Cube的查詢語法 Query Script ? 在所有同類產(chǎn)品中提供最強(qiáng)大的分區(qū)功能 DWDM DMQueryPerformance (10)DataManagement (10)ChallengesStrengths? Performance standard for verylarge data warehouses and data marts? Manageability — low number of DBAs required? Query optimization support for plex data models? Support for concurrent query workloads? Lack of platform choice (confusion)? Delays on NT/MPP? Ability to execute well? Ability to keep current capability lead? Marketing and positioning for broader market? Higher initial cost of solution? BI tool and application supportProven DW Track Record (10)Concurrent Query Management (10)Platform Suitability Scalability (10)DataAdministration (9)Common TopologyUser access tothe datawarehouse andfew data martsNCR TeradataCopyright 169。 2023OracleOracle數(shù)據(jù)倉庫解決方案Oracle9i Enterprise Manager(管理工具 )Oracle9i WarehouseBuilder(ETL)MIS/O
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1