일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
- openai
- WinError5
- 파이썬
- streamlit
- URI 원칙
- 사이킷런
- oracle
- 오라클
- Selenium
- 차원증가
- REST API
- 알고리즘
- Java
- 사이킷런 회귀
- 셀레니움
- h2 데이타베이스
- conda remove
- 완주하지못한선수
- 컬렉션 인터페이스
- 스프링 부트
- 자바 열거형
- db
- 스프링 부트3
- 프로그래머스
- 자바 로그 레벨
- GIT
- 머신러닝
- Python
- 쓰레드 풀
- 컬렉션 프레임웍
- Today
- Total
노트 :
OLTP vs. OLAP 본문
OLTPvs. OLAP : What’s the Difference?
OLAP(Online Analytical Processing)
OLTP(Online Transaction Processing)
The main difference is that one uses data to gain valuable insights, while the other is purely operational.
Online analytical processing (OLAP) is a system for performing multi-dimensional analysis at high speeds on large volumes of data. Typically, this data is from a data warehouse, data mart or some other centralized data store. OLAP is ideal for data mining, business intelligence and complex analytical calculations, as well as business reporting functions like financial analysis, budgeting and sales forecasting. ◀ uses data to gain valuable insights
Online transactional processing (OLTP) enables the real-time execution of large numbers of database transactions by large numbers of people, typically over the Internet. OLTP systems are behind many of our everyday transactions, from ATMs to in-store purchases to hotel reservations. OLTP can also drive non-financial transactions, including password changes and text messages. ◀ uses data to purely operate
OLAP is optimized for conducting complex data analysis for smarter decision-making. OLAP systems are designed for use by data scientists, business analysts and knowledge workers, and they support business intelligence (BI), data mining and other decision support applications.
OLTP, on the other hand, is optimized for processing a massive number of transactions. OLTP systems are designed for use by frontline workers (e.g., cashiers, bank tellers, hotel desk clerks) or for customer self-service applications (e.g., online banking, e-commerce, travel reservations).
Most of the time, organizations use both OLAP and OLTP systems. In fact, OLAP systems may be used to analyze data that leads to business process improvements in OLTP systems.
'자격증' 카테고리의 다른 글
기억장치 (0) | 2023.02.05 |
---|---|
프로세스 제어 블록(PCB), 파일 제어 블록(FCB) (0) | 2023.02.05 |
소프트웨어 개발 보안 활동 관련 법령 및 규정 (0) | 2023.02.05 |
소프트웨어 개발 표준 (0) | 2023.02.04 |
미들웨어(Middleware) (0) | 2023.02.03 |