數(shù)據(jù)倉(cāng)庫(kù)解決方案-在線瀏覽
2025-04-05 22:57本頁(yè)面
【正文】 c!! Summary Redirection Detail Rows Summary Table Performance Server Client Network ResultsBase: Cubic Client Cache Performance ? Efficient Storage Algorithm ? Multidimensional access ? Rapid rotation, drill Region North Paris Product Year Detail Rows External Data Drill Everywhere ? Drill Down ? Drill Across ? Drill to Detail ? Drill Out Navigational Power Web Publishing Navigational Power Integration Reports Express Openness MAPI Oracle Discoverer Administration Edition Superior Ease of Use Ease of Use Summary Management Server Based Administration Server Based Administration Advanced Summary Management Server Based Abstraction Layer Server Based Administration Ease of Use PRODUCTION EUL (RDBMS) Sales...Marketing 匜 inance匛 ducation匔 onsultancy Users Administrator Read/ Write Read Only ? Easy to Create, Maintain and Setup ? Scaleable ? Leverage Security Open ODBC DB2 Sybase Informix SQL Server Oracle ?. ODBC Enhancements Openness Oracle End User Layer EUL Gateway Des/2023 ETT Tools Applications Query Tools Build Summaries from Queries ? Query performance statistics ? Summary management remendations Summary Management 38 Definitions Data Warehouse ? A multisubject information store ? Designed specifically for decision support Data Mart ? A subject or applicationspecific data warehouse ? Types: Dependent, Independent DW vs. Data Mart Warehouse Data Mart Scope Corporate LineofBusiness Subjects multisubject subjectspecific Data Sources many few Size 100GB 1TB+ 100GB Implementation months years months Data Mart Oracle Express Oracle Warehouse Oracle Express ? What is it: – Advanced analysis of multidimensional and relational data ? Key advantages: – Broadest range of analytical functions – Scaleable performance – Integrated development environment Oracle Express Oracle Discoverer Oracle Reports Production Reporting Ad Hoc Query, Analysis Advanced Analysis Oracle Express Key Differentiators ? Advanced analysis – Builtin forecasting – Multiuser whatif – Automatic simultaneous models – Programmable server ? Scaleable performance – Analysis of existing relational databases – Multiple cubes, hierarchies per schema ? Integrated development environment – Broadest range of capabilities 可擴(kuò)展的多維數(shù)據(jù)庫(kù)服務(wù)器 , 內(nèi)置強(qiáng)大的分析 功能和決策支持能力 Personal Express, Express Server 用于銷售分析 , 市場(chǎng)分析 , 財(cái)務(wù)分析的 OLAP 應(yīng)用產(chǎn)品 Sales Analyzer, Financial Analyzer 面向?qū)ο蟮?OLAP應(yīng)用開(kāi)發(fā)工具 Express Analyzer, Express Objects Express Server Express Applications Express Tools Oracle OLAP Express Products Express 一個(gè)專門(mén)為查詢和分析商業(yè)情報(bào)數(shù)據(jù)而設(shè)計(jì)的服務(wù)器 Express ?對(duì)于一些分析查詢和計(jì)算 , Express 比關(guān)系型技術(shù)快 10倍， 100倍，甚至 1000倍 Jerry Held Senior VP, Server Technologies, Oracle Corporation 查詢速度如此快，使 Express 具有很強(qiáng)的競(jìng)爭(zhēng)能力 . 多維數(shù)據(jù)模型 轄區(qū)經(jīng)理 /行長(zhǎng) 財(cái)務(wù)經(jīng)理 任意分析 TIME 資金經(jīng)理 為數(shù)據(jù)提供快速，靈活的訪問(wèn)方法 時(shí)間 頭寸 轄區(qū) ?對(duì)時(shí)間，日期的智能處理， 系統(tǒng)相關(guān)數(shù)據(jù)自行匯總。南京江蘇沈陽(yáng)遼寧廣州廣東總行 P R O D U C T R E G I O N M O N T H S A L E SR E C O R D 1 F I L M EAST D e c 9 3 240R E C O R D 2 L E N S E S W E S T J a n 9 4 250R E C O R D
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1