term1 Definition1term2 Definition2term3 Definition3
Please sign in to your Google account to access your documents:
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.
Need help typing ? See our FAQ (opens in new window)
Please sign in to create this set. We'll bring you back here when you are done.
Discard Changes Sign in
Please sign in to add to folders.
Sign in
Don't have an account? Sign Up »
You have created 2 folders. Please upgrade to Cram Premium to create hundreds of folders!