Вы находитесь на страницах старой версии сайта. Перейдите на новую версию OLAP.ru
Chapter 1: Introduction to OLAP and Its Role in Business Intelligence | Network World
Введение в многомерный анализ / Хабр
Top 10 Best Analytical Processing (OLAP) Tools: Business Intelligence
Стоимость внедрения автоматизированной системы управления предприятием Комендантъ
MES системы – автоматизированные системы управления предприятием
Top 53 Business Intelligence Companies in 2018
Лекция 3. Иерархическая структура информационной системы предприятия — Студопедия
1С:ERP. Управление производством | Институт Типовых Решений — Производство
What is difference between OLAP and BI
Информационные технологии в книжном деле: Внедрение и развитие информационных систем
| SN | Data Warehouse (OLAP) | Operational Database(OLTP) |
|---|---|---|
| 1 | This involves historical processing of information. | This involves day to day processing. |
| 2 | OLAP systems are used by knowledge workers such as executive, manager and analyst. | OLTP system are used by clerk, DBA, or database professionals. |
| 3 | This is used to analysis the business. | This is used to run the business. |
| 4 | It focuses on Information out. | It focuses on Data in. |
| 5 | This is based on Star Schema, Snowflake Schema and Fact Constellation Schema. | This is based on Entity Relationship Model. |
| 6 | It focuses on Information out. | This is application oriented. |
| 7 | This contains historical data. | This contains current data. |
| 8 | This provides summarized and consolidated data. | This provide primitive and highly detailed data. |
| 9 | This provide summarized and multidimensional view of data. | This provides detailed and flat relational view of data. |
| 10 | The number or users are in Hundreds. | The number of users are in thousands. |
| 11 | The number of records accessed are in millions. | The number of records accessed are in tens. |
| 12 | The database size is from 100GB to TB | The database size is from 100 MB to GB. |
| 13 | This are highly flexible. | This provide high performance. |
