oracle數(shù)據(jù)倉庫解決方案-在線瀏覽
2025-03-13 13:46本頁面
【正文】 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 可擴展的多維數(shù)據(jù)庫服務器 , 內(nèi)置強大的分析 功能和決策支持能力 Personal Express, Express Server 用于銷售分析 , 市場分析 , 財務分析的 OLAP 應用產(chǎn)品 Sales Analyzer, Financial Analyzer 面向對象的 OLAP應用開發(fā)工具 Express Analyzer, Express Objects Express Server Express Applications Express Tools Oracle OLAP Express Products Express 一個專門為查詢和分析商業(yè)情報數(shù)據(jù)而設計的服務器 Express ?對于一些分析查詢和計算 , Express 比關系型技術快 10倍， 100倍，甚至 1000倍 Jerry Held Senior VP, Server Technologies, Oracle Corporation 查詢速度如此快，使 Express 具有很強的競爭能力 . 多維數(shù)據(jù)模型 轄區(qū)經(jīng)理 /行長 財務經(jīng)理 任意分析 TIME 資金經(jīng)理 為數(shù)據(jù)提供快速，靈活的訪問方法 時間 頭寸 轄區(qū) ?對時間，日期的智能處理， 系統(tǒng)相關數(shù)據(jù)自行匯總。南京江蘇沈陽遼寧廣州廣東總行 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
語文相關推薦
鄂ICP備17016276號-1