Yellowbrick Data Warehouse

The Yellowbrick Data Warehouse is an elastic, massively parallel processing (MPP) SQL database that runs on-premises, in the cloud, and at the network edge. It was designed for the most demanding batch, real-time, ad hoc, and mixed workloads and can run complex queries at up to petabyte-scale with sub-second response times. Yellowbrick is proven, providing business-critical services at many large global enterprises with thousands of concurrent users. It is available on AWS, Azure, and Google Cloud as well as on-premises.

The Yellowbrick Data Warehouse runs in your cloud account without data ever leaving your network to an external SaaS provider. This eliminates compliance and security risks. Running costs are lowered by paying for the cloud infrastructure (both storage and compute) using your own enterprise cloud agreements.

In an industry-first, full SQL-driven elasticity with separate storage and compute is available within your own cloud account as well as on-premises. Compute resources – elastic, virtual compute clusters (VCCs) – are created, resized, and dropped on-demand through SQL, and cache data persisted on shared cloud object storage. For example, ad-hoc users can be routed to one cluster, business-critical users to a second cluster, and more clusters created and dropped on demand for ETL processing.

Each data warehouse instance runs completely independently of one another. There is no single point of failure or metadata shared across instances. Global outages – when deployed with replication across multiple public clouds and/or on-premises – are impossible.

Yellowbrick is secure by default with no external network access to your database instance. Encryption of data at rest is standard with keys you manage. Columnar encryption, granular role-based access control, column masking, OAuth2, Active Directory, and Kerberos authentication are built in. Integrations with best-in-class enterprise data protection solutions secure PII data. Enterprise-class high availability, backups for data retention, and asynchronous replication for disaster recovery are standard.

No more surprise bills with transparent and consistent pricing.

Yellowbrick supports both on-demand and subscription-based pricing. All pricing is based on consumption of vCPUs for compute; they do not charge for storage since data is persisted on object storage in your own cloud account. On-demand pricing caters to short-term burst needs and is billed monthly in arrears without credits. Subscription pricing is predictable, works across cloud and on-premises, and allows efficient acquisition of capacity that you know you’ll need. Models can be mixed and matched to meet business objectives.

Time is money. Faster answers = less compute spend

Yellowbrick was conceived with the goal of optimizing price/performance. The storage engine is a hybrid column and row store: Most data is persisted in the column store while the row store supports real-time streaming ingest of hundreds of thousands of records per second from CDC tools and Kafka. Yellowbrick’s patented Direct Data Path Architecture is an OS bypass technology enabling in-memory analytics performance at petabyte-scale without requiring a typical database buffer cache – leading to more predictable response times and massive cost reductions.

Yellowbrick requires very little tuning and configuration and for those already familiar with PostgreSQL or massively parallel processing platforms derived from it (such as Netezza, GreenPlum, ParAccel/Amazon Redshift, etc), there’s no need for more than a day’s orientation to get up to speed with the platform.

Improvements beyond other data warehouse systems make your day-to-day life easier include:

• Applications and databases run at top speed with superior concurrent and mixed workload support
• DBAs no longer need to groom or vacuum tables
• Statistics are automatically gathered and kept up-to-date
• Scale compute and storage capacity incrementally simply by adding more blades
• Size your environment based on your initial storage needs instead of estimating what you need five years from now

Use Smart Data Frameworks to manage your data warehouse migration and integration to take out cost, risk and effort, and to ensure an optimum result for your business today.

Get expert assistance from Smart Associates with the Lift ’n’ Shift Data Warehouse Migration Services to scope and plan your migration, as part of a Proof of Concept, or to migrate your schema, data, application logic, ecosystem tools and users.

We have given careful consideration to the alternatives available to those organisations considering the replacement of their Netezza systems. Read why we think Yellowbrick is likely to be the best choice here.

If you are interested in hearing more, contact us here.