(Information Science Guru) Lecture on Databases

  • OLTP: Online Transaction Processing
    • Provides functions for data retrieval and management
    • Data is constantly being updated
  • OLAP: Online Analytical Processing
    • Deals with a static world of data
    • Involves data analysis, aggregation, and snapshots
  • RTAP: Realtime Analytic Processing
    • A new architecture for processing big data
    • Involves real-time data collection and processing (similar to OLTP)
    • Supports real-time query processing and aggregation (similar to OLAP)
    • NoSQL databases are commonly used in this context.