DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Online transaction processing
|
|
|
Offline transaction processing
|
|
|
Outline trajectory processing
|
|
|
Online traffic processing
|
Detailed explanation-1: -OLTP or Online Transaction Processing is a type of data processing that consists of executing a number of transactions occurring concurrently-online banking, shopping, order entry, or sending text messages, for example.
Detailed explanation-2: -What is OLTP? Online transactional processing (OLTP) enables the real-time execution of large numbers of database transactions by large numbers of people, typically over the Internet.
Detailed explanation-3: -Online analytical processing (OLAP) and online transactional processing (OLTP) are the two primary data processing systems used in data science.
Detailed explanation-4: -What is OLTP? OLTP (Online Transactional Processing) is a type of data processing that executes transaction-focused tasks. It involves inserting, deleting, or updating small quantities of database data. It is often used for financial transactions, order entry, retail sales and CRM.
Detailed explanation-5: -OLTP system is an online database changing system. The architecture of OLTP contains 1) Business / Enterprise Strategy, 2) Business Process, 3) Customers, Orders, and Products, 4) ETL Processes, 5) Data Mart and Data warehouse, and 6) Data Mining, Analytics, and Decision Making.