數(shù)據(jù)倉(cāng)庫(kù)解決方案-展示頁(yè)
2025-03-10 22:57本頁(yè)面
【正文】 報(bào)表 即席查詢分析 復(fù)雜分析 上季度各地區(qū)銷售 情況如何？ 什么原因造成東南亞 地區(qū)的業(yè)務(wù)下降 ? 如果同樣的因素影響到 其它地區(qū)，將會(huì)對(duì)全球的 業(yè)務(wù)造成什么影響 ? Oracle Express Oracle Discoverer Oracle Reports Oracle 決策支持工具集 ? 標(biāo)準(zhǔn)報(bào)表 Oracle Reports – 集中式報(bào)表生成存儲(chǔ) – 輸出發(fā)布高質(zhì)量的報(bào)表 ? 即席查詢分析 Discoverer – 即席查詢 , 數(shù)據(jù)鉆入，旋轉(zhuǎn) – 業(yè)界領(lǐng)先的易用性和性能 ? 復(fù)雜分析 Express – Online Analytical Processing (OLAP) – 高級(jí)計(jì)算 ? 財(cái)務(wù) , 時(shí)間序列 , 建模 , 預(yù)測(cè) , 回歸分析，假設(shè)分析 Oracle Reports ? What is it? – Formats and distributes database information ? Key advantages – Unlimited data formatting – Distributes high fidelity reports via the Web – Application server based reporting engine Oracle Express Oracle Discoverer Oracle Reports Production Reporting Ad Hoc Query, Analysis Advanced Analysis Oracle Discover Add Value To The Oracle Warehouse Oracle Discoverer ? What is it: – Ad hoc query and analysis of relational data ? Key advantages: – Awardwinning ease of use – Industryleading query performance Oracle Express Oracle Discoverer Oracle Reports Production Reporting Ad Hoc Query, Analysis Advanced Analysis Discoverer is: 10 times faster than Cognos 9 times faster than Business Objects MarketLeading Performance Time to query 100,000 rows: Cognos Business Objects Discoverer Oracle Discoverer User Edition Business Abstraction Layer End User Layer(TM) Data Warehouse / Data Mart (or OLTP) User Edition Administration Edition Oracle Discoverer User Edition Superior Ease of Use Ease of Use Performance Warehouse Exploration Exceptional Performance Navigational Power Navigational Power Openness Openness Most Tested UI on the Market Resizeable Wizard Interface Industry Specific Quick Tour Dramatic Reduction of the Learning Curve and more... Ease of Use End User Layer Ease of Use Hides the Complexity of the Underlying Database Database cl_addr1||39。|| cl_addr2|39。|| cl_addr3||39。|| cl_twn||39。|| cl_zipcode sum(nvl(qty* unit_price,0)) Jones Smith Name Customer Client Address Revenue Eastern Region User Batch Reporting Openness To Do... Schedule long running queries for later Ease of Use 9:00 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 Automati
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1