Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
18 Cards in this Set
- Front
- Back
|
OLTP |
Online Transaction Processing |
|
|
OLTP is |
Software system that processes transaction-oriented data. |
|
|
OLTP systems store |
Operational data that is fully normalized. |
|
|
OLTP systems representing |
A common source of structured analytics input. |
|
|
Queries supported by OLTP systems |
Simple insert, delete, and update operations with sub-second response times. |
|
|
OLAP |
Online Analytical Processing |
|
|
OLAP is |
System used for processing data analysis queries. |
|
|
OLAP used In |
Diagnostic, predictive, and prescriptive analytics. |
|
|
OLAPs form an integral part of |
business intelligence || data mining || machine learning processes |
|
|
OLAPs are relevant to Big Data in |
That they can serve as both a data source as well as a data sink that is capable of receiving data. |
|
|
OLAP systems store |
Historical data that is aggregated and denormalized to support fast reporting capability. |
|
|
OLTPs & OLAPs |
An OLAP system is always fed with data from multiple OLTP systems using regular batch processing jobs. |
|
|
ETL |
Extract Transform Load |
|
|
ETL is |
Process of loading data from a source system (DB, flag file or application) into a target system (DB or information system) . |
|
|
A Big Data solution encompasses the ETL feature-set for |
Converting data of different types |
|
|
Data warehouse is |
A central, enterprise-wide repository consisting of historical and current data. |
|
|
Data mart is |
A subset of the data stored in a data warehouse that typically belongs to a department, division, or specific line of business. |
|
|
Hadoop is |
An open-source framework for large-scale data storage and data processing that is more or less run on commodity hardware. |
