Table of ContentsTERADATA M-DBS Talk Outline A Data Warehouse Focus: The issues Sources of the confusion What is a Database . . What is a Data Warehouse? PPT Slide Short Term Gain, Long Term Pain What is Data Mart Centric?? What is Data Mart Centric?? The Allure Of Data Marts Quicker to Implement Easier to Manage Cheaper to Build Higher Query Performance Data Marts in Practice Danger Signs Chaos Again! Why Data Marts Fail: Technical Why Data Marts Fail: Business Top 10 Complaints on Data Marts Laying a Winning Foundation Avoiding the Fall Success for Years! A True Data Warehouse! The Devil is in the Detail PPT Slide History of the Issues Summarization: Get what we have FAST Summary vs. Detail Data How Summary Falls Short Today’s Summary Systems.... Today’s Summary Systems... ...Become Tomorrow's Headaches Constantly Changing Business Requirements The Value of Detail Data - Ask what you want !!! Benefits of Detail Data Pros and Cons Quick Implementation Tips Provide the Best of Both Worlds ! WORLDMARK 5100M CLUSTERS (Maximum Theoretical 4096 SMP Nodes) CLIQUE Wal*Mart Case Study New (Just-In-Time) Retail Paradigm Wal*Mart System Information as Strategic Weapon DATABASE SIZES Object/Relational Evolution Object-Relational: Paradigm Shift? Teradata Multimedia Object-Relational Three Waves Of Multimedia Products Wave(2): Medical Query Wave(2): Financial Query Wave(3) Financial Time-Series (UDFs In: Projection & Predicate) Wave(3) Medical Content-Analysis Predicate: Wave(2) & Wave(3) M-DBS SQL/C++: UDT/UDF Definition The Scalable Multimedia Data Warehouse Architecture Data Warehouse Concept Financial Services - Visionary Applications Healthcare Information System (Big Picture Application & Solution) Knowledge Bank Highlights Knowledge Bank Multimedia Registry Web Browser Interface WEB: Internet/Intranet/Extranet Datawarehouse 3-Tier Solution Two-Pass Paradigm Concept Pass(1): Retrieve Tuples Pass(2): Hand “Click” On Specific Object PPT Slide Coordinator Parallel Object Server Architecture PPT Slide PPT Slide PPT Slide PPT Slide PPT Slide PPT Slide PPT Slide Open Database Connectivity (ODBC) OSC Transport Connections Register Utility UDF Usage & Optimization PARALLEL PIPELING UDF EXECUTION Conclusion PPT Slide |
Author: Felipe Carino |