OracleBI数据仓库设计及解决方案.ppt

* * Advanced Compression The advanced compression feature allows tables to be stored in a compressed format, resulting in significant savings in disk storage, I/O, and logging, often by a factor of more then 2-3 times. This new feature extends the database’s compression capabilities to OLTP environments so that compression works seamlessly under all applications, and not just under a data warehouse. In addition, unstructured data can also be compressed saving further disk space * * * * * * * * * Essbase delivers superior calculation power. Whether you need simple aggregations, Percents, Ratios, Derived metrics, or the most sophisticated business allocations. The calculator is relationship aware, meaning it understands hierarchical levels. In the graphic Qtr1, 2,3,4 are children of Year. Qtr1 is the parent of Jan Feb and Mar. Jan is a sibling of Feb and Mar. Year Tot and Qtr2 are ancestors of Jan. The calculator can make use of these relationships and use them as subsets when calculating data. For example, you may wish to apply different percentage discounts to different groupings of customers. This is an example of the power of the calculator. With this simple “English like” command, the calculator allocates the necessary space and then creates a copy of the scenario “actuals” to the scenario “forecast”. This is a great way to seed a new forecast. * Here’s a real world example….one of our customers is a leading financial institution. The needed to provide their bank officers with real time customer profitability at the account level, so that they could use that insight to try and move customers from less prfitable types of accounts to more profitable accounts. And to approve or deny loans or other services. They were dealing with approximately 14 million accounts, and needed to be able to support up to one thousand concurrent queries from bank officers during peak periods. They built a data warehouse that had over a terabyte of data, and tried using a