oracle的解決方案-wenkub
2023-03-05 11:00:54 本頁面
【正文】 Commands and Information ? Using External Data ? Working with Windows Oracle Confidential 持續(xù)的查詢過程 查詢示例： 從費(fèi)城的最近一個(gè)季度 的產(chǎn)品中選擇銷售額大 于 150K的產(chǎn)品，并且從?大的產(chǎn)品。|| cl_twn||39。|| cl_addr2|39。Oracle Data Warehouse Solution Oracle ( China ) Presales Consultant Xu Xin 數(shù)據(jù)倉庫幾大功能 ? Query/Report ? Drill up/ Drill Down ? Compare ? Exception ? Forcast, Whatif ? Data Mining 數(shù)據(jù)倉庫三大流程 ? 數(shù)據(jù)建模 Data Model Design ? 數(shù)據(jù)抽取 Data Extract, Transform, Transport ? 數(shù)據(jù)表現(xiàn) – Rolap, Molap – Data Delivery, Drill up/Drill down, Data Rotation, Data Mining ROLAP / MOLAP 爭論的焦點(diǎn)在哪里 定義 : ? ROLAP = 基于關(guān)系的 OLAP ? MOLAP = 基于多維的 OLAP ? ROLAP 供應(yīng)商說 : 你能用關(guān)系技術(shù)做所有的事情 ? ? MOLAP ROLAP 供應(yīng)商說 : 你用多維數(shù)據(jù)庫能做得更好 ? ROLAP 供應(yīng)商僅僅能做 ROLAP.... ? MOLAP 供應(yīng)商僅僅能做 MOLAP.... ? ORACLE 能提供 ROLAP和 MOLAP ROLAP / MOLAP 爭論的焦點(diǎn)在哪里 ROLAP和 MOLAP Oracle的解決方案 ? Oracle ROLAP – Data Mart Suite 建模，數(shù)據(jù)抽取的工具 – Discoverer 基于關(guān)系數(shù)據(jù)庫的分析工具 – 多維數(shù)據(jù)的視圖 , 挖掘和旋轉(zhuǎn) ? Oracle MOLAP – Express 系列產(chǎn)品提供 MOLAP的方案 – 多維數(shù)據(jù)的視圖 , 挖掘和旋轉(zhuǎn) , 計(jì)算和存取、預(yù)測(cè) ? Oracle 能提供 ROLAP 和 MOLAP – Express 系列產(chǎn)品能做 MOLAP 和 ROLAP OFA, OSA Applications Express Power Analysis Discoverer Query, Reporting, Analysis Decisions Components of a Data Warehouse / Mart OLTP OLTP External Data Operations Data Storage Data Mart Suite Add Value To The Oracle Warehouse Data Mart Suite Components l Great8 Oracle8, release l Dashing Data Mart Designer l Better Data Mart Builder l Debonair Discoverer l Awesome Web Application Server l Ravishing Reports Server l Compelling Cookbook Design and Management Any Data Any Access Any Source Metadata Construction Methodology Drag drop visual metaphor Data Modeling ? Identify data sources ? Identify source subset ? Model Star Schema Process Modeling ? Build Plans ? Dimension tables ? Time Dimension ? Fact table ? Populate database Business Modeling ? Define enduser layer Oracle8i for Data Warehousing Continuous Innovation Oracle ? Hash Join ? Bitmap Indexes ? ParallelAware Optimizer ? Partition Views ? Instance Affinity: Function Shipping ? Parallel Union All ? Asynchronous ReadAhead ? Histograms ? AntiJoin ? Partitioned Tables and Indexes ? Partition Pruning ? Parallel Index Scans ? Parallel Insert, Update, Delete ? Parallel Bitmap Star Query ? Parallel ANALYZE ? Parallel Constraint Enabling ? Server Managed Backup/Recovery ? PointinTime Recovery Oracle ? Summary Management ? New Partitioning Schemes ? Resource Manager ? Progress Monitor ? Adaptive Parallel Query ? Serverbased Analytic Functions ? Transportable Tablespaces ? Direct Loader API ? Functional Indexes ? Partitionwise Joins ? Security Enhancements and more ... Oracle8i Data Modeling Oracle Data Mart Designer Table orders (constraint c_o_date check (O_entry_d between to_date (?1jan1997? 慸 dmonyyyy? and to_date (?1dec1997? 慸 dmonyyyy?) disable, o_id number, o_d_id number, o_w_id number, o_c_id number, o_entry_d date, o_carrier_id number, o_ol_t number, o_all_local number) tablespace ord initrans 3 pctfree 5 storage (initial 20K next 110M pctincrease 0
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1