How the IT universe moves to software-defined data warehouse life, and everything

Teradata has launched what it calls its ‘Software-Defined Warehouse’ as an enhancement to the firms own-brand Teradata Database.

As we move to a world of software-defined everything, this is clearly a play to enable firms to consolidate multiple data warehouses into one system without sacrificing service level performance.


What is a data warehouse?

A data warehouse itself is defined by TechTarget as a central federated repository for all (or significant parts of) the data that an enterprise’s various business systems collect – it may be both physical and logical.

“Today, many organisations maintain multiple, separate data warehouses to meet unique business unit requirements or to comply with data privacy regulations across countries,” said the firm’s Hermann Wimmer.

Here then we see Teradata moving to try and provide simpler data warehouse management and consistent performance.

The company also now tables an additional Teradata Database feature called Secure Zones, which separates data and groups of users for each entity, with secure boundaries between them.

This, says Teradata, enables organisations to comply with security and privacy laws that restrict the movement of personally identifiable information or co-location of data from multiple business entities or countries within a single data warehouse.

The Software-Defined Warehouse capability usesTeradata Workload Management, Teradata Data Labs and the Secure Zones feature of the Teradata Database.

These combined capabilities offer organisations the following functions:

• Multi-Tenant Deployment: to separately manage data and users from multiple business units or organisations — and the Software-Defined Warehouse shields system administrators from viewing the tenants’ data, if required for security or privacy purposes.

• Business-to-Business Analytic Services: to simplify the hosting and managing of business-to-business analytic services for partners of Teradata customers.

• Data Mart Consolidation: to consolidate multiple data marts into a single system, which reduces the total cost of ownership and carbon footprint.

NOTE: This also provides a simpler way for users to gain an enterprise view of the data, while continuing to segregate the data, users, applications, and workloads from each data mart.

• Production Analytic Sandboxes to set up user-focused, self-service data labs, enabling new levels of data-driven insights and agility, without data duplication or creation of new silos.

“‘Software-defined anything’ has become a hot industry topic for organisations looking to speed provisioning and better utilise infrastructure resources,” said John L Myers, managing research director for business intelligence at Enterprise Management Associates.

“Teradata’s delivery of a software-defined warehouse provides a level of agility and ‘push-button’ simplicity that empower organisations to quickly deploy their data warehouse and data mart resources and effectively manage security across environments.”

Mini case study

For example, a European-based multi-national company is currently required to dedicate a separate, stand-alone system within its data centre for each of the countries served. The employees within each country have access to their own secured data, but this model is not cost-effective. With deployment of the Software-Defined Warehouse, the data from all countries can be brought into a single system while offering the same security controls and access restrictions. This consolidation saves both time and money, while also guaranteeing consistent performance across workloads based on business priorities.