开发工具:
文件大小: 7mb
下载次数: 0
上传时间: 2012-12-20
详细说明： Analytical Processing for Business Decisions High-level analytical queries, like those commonly used in Siebel Analytics, scan and analyze large volumes of data using complex formulas. This process can take a long time when querying an OLTP database, impacting overall system performance. Because complex queries run slowly on OLTP databases, the database requirements for Siebel Analytics are different from other parts of Siebel operational applications. In Siebel Analytics, you will modify data much less frequently than in Si ebel operational applications, but you will need quick results when viewing new analyses, drilling down to detailed charts and graphs, and creating new briefings. To address these requirements, you need a physical implementation of the data model that is optimized for quick review of the entire database of information rather than quick updating of that information. Such a database will have as few join paths as possible to minimize processing. This means fewer, larger database tables rather than many smaller ones. In such a database schema, the same piece of data may appear in several locations, which reduces the need for join paths. This type of database is called denormalized. The Siebel Data Warehouse is an online analytical processing (OLAP) database, which allows you to selectively extract, analyze, and view data. The Siebel Data Warehouse schema was designed using star schema modeling techniques (called dimensional schema in this book) to support the analysis requirements of Siebel Analytics. To facilitate this kind of analysis, Siebel Data Warehouse data is stored in a relational database that considers each data attribute (such as product, account, and time period) as a separate dimension. The Siebel Data Warehouse does not contain every piece of data stored in a transactional database, because not all transactional data is needed for analysis. ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
