Stay in Sync
Simplify and integrate your analytical ecosystem.
The landscape of modern business analytics continues to change and accelerate. Organizations are gathering, storing and analyzing more data than ever. And that data is being generated from a growing number of sources. As companies adapt to this change, they quickly realize that not all data is equal. Some supports mission-critical applications and must be available continuously. Other data has time-sensitive value—very high value within the first few hours but diminishing over time. Still other data is rarely accessed but is retained for historical purposes or to meet regulatory requirements.
To address these varying data needs, companies are opting to employ more than one production system. They are also taking advantage of the Teradata Platform Family to match the price, performance and availability characteristics of their data to the platform, creating a very efficient data warehouse environment. This environment, called the Teradata analytical ecosystem, is the future of data warehousing. And Teradata Unity enables it.
Along with the benefits of an analytical ecosystem come challenges. The most common are routing users to the location of their data, rerouting them during planned and unplanned system outages, and synchronizing database changes across systems.
To conquer these challenges, Teradata Unity, a virtualization solution designed and built from the ground up, simplifies and automates the tasks associated with a multi-system environment. It links components together and provides query management in addition to data and database synchronization across multiple Active/Active and Active/Standby copies of the Teradata Database.
The solution works with all members of the Teradata Platform Family and is positioned to assist organizations engaging in high-availability and disaster recovery initiatives as well as workload optimization across systems. As a result, customers can benefit from a synchronized and unified analytical ecosystem. The three primary components of Teradata Unity are:
INTELLIGENT QUERY MANAGEMENT
Routing user queries between Teradata systems based on where the data resides is a powerful feature. It means users do not need to know where their queries will run. It also means that database administrators (DBAs) don’t have to predetermine where user queries route. This, in turn, simplifies running multiple active systems that are each designed and optimized for a specific analytical workload.
When designing for high availability and failover, routing user sessions based on pre-determined rules gives DBAs fine-grained control of which users will failover to which systems during an outage (planned or unplanned), based on business priorities.
One of the biggest challenges organizations face is synchronizing multiple systems. Teradata Unity supports both data and database synchronization. A feature called SQL Multicast delivers SQL commands to all participating systems in the Teradata analytical ecosystem. This enables DBAs to create a new table (or add a new user) with just one SQL command, then Teradata Unity will make sure it is completed on all systems. This is a simple and automated way to maintain uniformity.
In the same way, Teradata Unity keeps SQL-based data changes in sync. Any data changes will be sent to all systems and executed locally. This ensures that data in all locations is the same.
Multi-system environments can be leveraged to protect users from database restarts and avoid loss of in-flight queries and the need for users to resubmit them when the database comes back online. These restarts can disturb end-user productivity and require users to know when the database becomes available. Organizations can embed logic in their applications that will automatically resubmit queries when the database is back online. However, this puts the burden on IT to custom-build and maintain the logic. Teradata Unity will automatically resubmit queries that are aborted because of a database restart, to an alternate Teradata system that can satisfy the query, making the entire event transparent to the user or application. The result is a better end-user experience that does not burden IT.
Overcoming Multi-System Challenges
Through its powerful features, Teradata Unity directly addresses and overcomes the challenges of a multi-system environment. It automates and simplifies the tasks that were once viewed as hurdles and enables multiple active Teradata systems to work together as one analytical ecosystem.