Security Metrics Store
Component Detail
Data Layer
medium complexity
backend
0
Dependencies
1
Dependents
2
Entities
0
Integrations
Description
Data access layer that executes PostgreSQL aggregation queries over audit_logs and sessions tables and manages the server-side metrics cache. Provides optimized query methods for windowed login failure counts, session statistics, and event severity classification.
security-metrics-store
Responsibilities
- Execute windowed aggregation queries on audit_logs for failed login metrics
- Query sessions table for concurrent and active session statistics
- Maintain a time-based cache of computed security metrics to reduce database load
- Provide filtered query methods respecting organization-level tenant isolation
Interfaces
queryFailedLogins(orgId: string, window: TimeWindow): Promise<LoginMetric[]>
querySessionCounts(orgId?: string): Promise<SessionMetric[]>
queryFlaggedEvents(orgId?: string, severity?: string): Promise<EventRecord[]>
getCachedMetrics(orgId?: string): SecurityMetrics | null
setCachedMetrics(orgId: string, metrics: SecurityMetrics): void
invalidateCache(orgId?: string): void
Relationships
Related Data Entities (2)
Data entities managed by this component