PRODUCT OVERVIEW

Managing your IBM Netezza appliances just got a whole lot easier.

Smart Management Frameworks (SMF) automates processes that improve the performance, availability, recoverability, and security of IBM Pure Data for Analytics/Netezza Performance Server systems - whether on premise or in the cloud.

Key Features

  • Works with any kind of storage media (including NFS, Spectrum Scale, SAN/NAS, etc.) across multiple sites.
  • Bi-directional, multi-master in nature (from anywhere to anywhere, including multiple targets replicated from the same backup source, or the restoration target being on the same physical appliance as the backup source itself).
  • Backup/restore increments can be as frequent as you like.

Database Replication Module

Smart Database Replication allows customers to replicate their Netezza databases in near real-time (you choose how frequently you want to replicate changes between systems, according to workload, data volatility, bandwidth, and Recovery Point Objectives (RPO) considerations). Mean Time to Recovery (MTTR) can be measured in the minutes it will take to repoint your DNS servers to the DR system; but even without a disaster, database replication potentially enables customers to divide their data, users, and workloads between multiple appliances for improved performance, concurrency, and throughput.

  • Can backup/restore subsets of tables within a database (and even subsets of rows within a table).

  • Ideal for Disaster Recovery, as well as Development/Test database population using sampled referentially intact subsets of production data.

  • Dynamic creation/dropping of database users and groups based on synchronised Entra ID (Formerly Active Directory)/LDAP master data.

  • Automatic addition/removal of users to/from groups, as well as granting/revoking of permissions to/from groups.

  • Provides row and column-level access control security.

Access Control Module

Smart Access Control removes the risk of unauthorized access, and potential breaches of corporate data security policies, with an automated process that ensures all permissions on the Netezza system are kept synchronised with the Entra ID (formerly Active Directory)/LDAP servers.

  • Provides row and column-level access control security model for both users and groups.
  • Dynamically creates views that automatically either reveal or obscure secure row/column values when queried.

System Management Module

SuperTuning

Automatically detects which database objects are in need of statistics collection, reorganisation, or grooming in order to improve query performance, and then performs only the operations that are necessary against only the objects that need it to reduce overall system maintenance overhead.

Key Benefits:

  • Frees up more system capacity/resources.
  • Doesn't interrupt/delay other processes for hours.
  • Improves query performance.
  • Is fully customisable/automated.
  • Maintains an internal audit log of operations performed.

SuperGovernance

Automatically monitors all database query activity and produces alert notifications if it detects that any custom data governance rules have been violated.

  • Flexible framework that uses configurable parameters to customise which events and database activities to monitor, their frequency, and method of alerting.
  • Alerts can be directed to DBAs, and/or to any manager such as the Chief Security Officer or their team to ensure that the appropriate follow-up actions are taken.

SuperCuration

Automatically deletes, aggregates, or obfuscates any data according to customisable, flexible, and granular criteria.

Key Benefits:

  • Helps ensure compliance with data protection legislation.
  • Reduces waste whilst increasing storage capacity, providing a longer and better return on investment.
  • Faster, easier, cheaper, and more reliable than creating custom ETL logic manually.
  • Obfuscation is one-way (i.e. can’t be reversed) and consistent (using hashing), which enables related records to still be matched, even if personally identifiable information isn’t visible.
  • Preserves valuable historical trend information.
  • Improves data security and reduces attack vector footprint.

SMF module subscriptions are licensed by system, payable annually, and pricing will vary depending on the following factors:

  • The number of systems covered, and modules licensed.
  • Volume and non-production discounts applied.
  • If delivered as a managed service, and depending on the hours covered (24x7x365, or Office Hours only).