Fadak.IR Fadak Solutions
English Русский العربية فارسی
Articles Management Studies Language


/ IT Management / Business Intelligence

OLAP v/s OLTP


Вы находитесь на страницах старой версии сайта. Перейдите на новую версию 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.

 http://mansour-yahyavi.blogfa.com/post/13


Articles
Digital Media
Humanities
IT Management
Coumputer
Miscellaneous
Product & Services
About Fadak
Management
Contemporary Management Journal
Managerial Verses
Photography Quotes
Photo is written
Management Researcher Bank
Management articles titles
Educational Resources (Seminary & University)
Studies
Observatory - Personalities
Observatory - Cultural
Observatory - Academic
Observatory - Media
Observatory - scientific events
Language
Dictionary
Russian Language Test
Russian Proverb
English Proverb
Four language sentences
logo-samandehi
About | Contact With Us | Privacy Policy | Terms | Cookies Policy |
Version (Pre-Alpha) 2000-2022 CMS Fadak. ||| Version : 5.2 ||| By: Fadak Solutions Old Version