Smart Management Frameworks

Your Databases,
Running Themselves.

SMF automates the complex, time-consuming management tasks that keep your database systems performing, available, secure, and well-governed: backup and recovery, access control, performance tuning, data governance, and more.

Get Started Included in Managed Support
Netezza PostgreSQL Oracle Databricks

Database Automation, Built from Experience

SMF was built originally for Netezza and has been running reliably in production for years, automating the processes that keep database systems performing at their best: backup and disaster recovery, access control synchronisation, performance tuning, governance, and data lifecycle management.

We are now porting SMF to a modern web-based Control Studio and applying our knowledge and experience to other database platforms, starting with PostgreSQL and Oracle, with further platforms to follow.

The result: better uptime, better performance, stronger security, and a far smaller administrative burden on your data team.

SMF is included free in our Managed Support tier Interested in SMF for another platform? Join the waitlist
6
Modules: backup, access control, governance, tuning, and more
24/7
Continuous background automation
Minutes
Disaster recovery MTTR with Smart Database Replication
0
Manual access sync errors when Smart Access Control is running

The SMF Control Studio

What SMF Does for Your Systems

Each module targets a distinct area of database management. They can be deployed individually or together as a complete management suite, controlled through the SMF Control Studio web interface.

Backup, Recovery, and Replication

Automated backup, disaster recovery, and cross-system replication

Configurable backup policies protect your databases with automated scheduling, multiple target destinations, and retention management. For systems that require near-zero downtime, SMF maintains a continuously synchronised hot standby using incremental replication, so recovery from hardware or software failure is measured in minutes rather than hours. Your standby system can also carry read-heavy workloads to maximise throughput and concurrency on your primary.

Automated backup policies Near real-time replication MTTR in minutes Workload distribution Multiple target destinations

Access Control

Centralised identity synchronisation across your database estate

Automates the synchronisation of users, groups, and permissions across your entire database estate using your existing enterprise Single Sign-On or Identity Access Management system as the single source of truth. Supports multi-domain Active Directory, Entra ID, and LDAP directories. Includes drift detection with configurable auto-remediation: if a permission is changed directly on a database, SMF detects the drift and either alerts or automatically corrects it.

Entra ID / Active Directory Multi-domain LDAP Drift detection Auto-remediation Full audit trail

Data Curation

Automated data aggregation, archiving, and lifecycle management

Manages the lifecycle of ageing data automatically. As detailed data ages beyond configurable thresholds, Data Curation aggregates it in place, archives the original detailed records to a Lakehouse or other file system for slower retrieval if needed in future, and then removes the originals from the database. Data quality checks are applied continuously as part of the curation pipeline, keeping your databases lean and your data trustworthy without manual housekeeping.

Automated aggregation Lakehouse archiving Data lifecycle rules Data quality checks

Data Governance

Automated database activity monitoring, alerting, and compliance enforcement

Monitors database activity continuously, detecting and reporting suspicious or unusual behaviour in real time. Pre-defined governance rules are evaluated against actual database usage patterns, and stakeholders are alerted automatically when those rules are breached. Provides the audit trail and enforcement layer that regulated industries need for compliance, without requiring your data team to manually review activity logs.

Activity monitoring Anomaly detection Governance rule enforcement Automatic stakeholder alerts Compliance audit trail

SuperTuning

Intelligent, targeted performance optimisation

Analyses your database workload to identify exactly which objects need attention, then performs only the necessary tuning operations. Unlike blanket statistics collection or scheduled reorganisation routines that waste resources touching objects that do not need attention, SuperTuning targets its effort precisely, maximising query performance with minimal system overhead. Runs continuously in the background, adapting as your workload changes.

Workload analysis Targeted optimisation Continuous tuning Minimal overhead

Event Manager

Cross-module event processing, alerting, and automated remediation

Provides a centralised event processing layer across all SMF modules. Monitors system and database events in real time, triggers configurable alerts, and fires automated remediation actions where appropriate. Ensures your team is notified of issues before they become outages, and that routine corrective actions happen without human intervention.

Real-time monitoring Configurable alerts Automated remediation Cross-module orchestration

What SMF Delivers for Your Organisation

MTTR Measured in Minutes

With SMF maintaining a live hot standby via continuous replication, recovery from hardware or software failure takes minutes rather than the hours required by conventional backup and restore procedures.

No More Manual Access Sync

Eliminate the risk of data exposure from stale access credentials. Smart Access Control keeps your database permissions continuously aligned with your corporate identity directory, with drift detection and auto-remediation built in.

Peak Query Performance, Automatically

SuperTuning identifies exactly which objects need attention and performs only the necessary operations, maximising query performance without the overhead of blanket statistics collection or reorganisation routines.

Governance and Compliance, Automated

Data Governance monitors database activity continuously, detecting unusual behaviour and alerting stakeholders automatically when governance rules are breached. Data Curation enforces lifecycle rules in the background. No additional staff effort required.

Get SMF Free with Netezza Support Plus

Smart Associates is the only independent Netezza support provider to include the full Smart Management Frameworks suite at no additional charge in our Managed Support tier. You get expert break/fix support and continuous system automation for a single flat-rate fee.

View Support Tiers

Managed Support includes all of:

  • 9×5 or 24×7 expert break/fix support
  • Remote hardware support and on-site cover
  • Scheduled health checks and performance reviews
  • Backup, Recovery, and Replication
  • Smart Access Control
  • Data Governance and Data Curation
  • SuperTuning
  • Event Manager with automated alerting
  • Optional advisory and development services

Learn More About SMF

SMF Brochure

Download the Smart Management Frameworks product brochure for a complete overview of all modules.

Download PDF

Replication Intro Video

Watch a short introduction to Smart Database Replication, covering disaster recovery and workload distribution use cases.

Watch Video

Governance Video

See how the Data Governance module monitors database query activity and flags governance rule violations automatically.

Watch Video

Ready to Try Smart Management Frameworks?

Start with a free community licence, explore pricing options, or request a tailored enterprise quote. SMF is also included free with our Managed Support tier.

Have questions? Get in touch

SMF for Your Database Platform

SMF has been running on Netezza for years. We are now bringing the same automation capabilities to PostgreSQL, Oracle, Databricks, Snowflake, Redshift, and other platforms. Join the waitlist to be notified when SMF is available for your preferred database, or get in touch to discuss your requirements.

We will use your details to notify you when SMF is available for your chosen platform. Your data is processed by Smart Associates Limited in accordance with our Privacy Policy and will never be shared with third parties.

Want to discuss licensing or suitability? Contact us directly