FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Recording, processing, processing and generating data and information regarding transactions for an event or events periodically using simple queries, on computers connected to computer networks is a function of
A
OLAP
B
ETL
C
OLTP
D
ELT
Explanation: 

Detailed explanation-1: -OLTP, or online transactional processing, enables the real-time execution of large numbers of database transactions by large numbers of people, typically over the internet. A database transaction is a change, insertion, deletion, or query of data in a database.

Detailed explanation-2: -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-3: -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.

Detailed explanation-4: -OLAP creates a single platform for all types of business analysis needs which includes planning, budgeting, forecasting, and analysis, while OLTP is useful for administering day-to-day transactions of an organization.

There is 1 question to complete.
Previous
Next