oracle的解決方案(編輯修改稿)

　

【文章內容簡介】 Open workbooks 12 :00 Refresh workbooks 3:00 Schedule Monthly reports 5:00 Schedule Quarterly reports 5:30 Generate new report for management meeting tomorrow Solution to Long Running Queries Reactive Query Governor ? Stops queries after a preset time ? Uses the resources without showing results! Performance Predictive Query Governor ? Predicts the time a query takes before execution ? Does not waste valuable resources! Managing Large Data Volumes Select Location, Period, Product, sum(videos_lent) From video_details Group by Location, Period, Product Detail Rows Performance ? Slow Table Scans ? Machine Intensive Aggregations Summary Redirection Select Location, Period, Product, sum(videos_lent) From video_details Group by Location, Period, Product Detail Rows Summary Table Performance Select Location, Period, Product, Sales From video_summary Automatic!! 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 performan