Streaming

A streaming service is a digital platform that delivers audio, video, or live content over the internet so users can watch or listen in real time or on demand—without downloading the full file first. This Streaming subject area enables tracking streaming, streaming pools, and their details.

Business Questions

The subject area can answer the following business questions:

  • What are the partitions?
  • What's the retention in hours?
  • What's the streaming stream count?
  • What's the streaming stream count by compartment name / tenancy / region?
  • How has the number of Streaming stream counts changed over time (monthly)?

Logical Model

The Streaming subject area is based on a relationship-driven logical model.

This diagram shows how the Streaming fact table is related to its dimension tables:


The Streaming Stream fact table is connected to its dimension tables.

Metric Details

The fact folders in this subject area include the following metrics:

Metric Details for Streaming
Metric Definition
Partitions Provides the number of partitions in the stream
Retention In Hours Provides the retention period of the stream, in hours
Streaming Stream Count COUNT(ocira_fact_key) from the fact view's ocira_fact_key (maps to ocira$fact_key)