Book Image

Teradata Cookbook

By : Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati
Book Image

Teradata Cookbook

By: Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati

Overview of this book

Teradata is an enterprise software company that develops and sells its eponymous relational database management system (RDBMS), which is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will help you get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata. The book begins with recipes on quickly setting up a development environment so you can work with different types of data structuring and manipulation function. You will tackle all problems related to efficient querying, stored procedure searching, and navigation techniques. Additionally, you’ll master various administrative tasks such as user and security management, workload management, high availability, performance tuning, and monitoring. This book is designed to take you through the best practices of performing the real daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.
Table of Contents (19 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

Restoring a table


Proper management of the backup process is a critical step in maintaining the integrity and security of a Teradata system. It helps in verifying that the data warehouse is properly protected against unexpected data loss and data availability is maintained. In addition, it is important to know the requirements for data availability while the backup is in progress, and the impact of resource usage of the backup, both of which can impact performance of other operations during the backup window. It is important to know these requirements at the time the BAR solution is designed, to ensure that the solution that is provided will meet the needs of the customer. The BAR window should not be exceeding the time given to it, or else other users or jobs on the system could be hampered. 

When designing the BAR solution, the first requirement that should be considered is the frequency at which backups will be executing. This defines your recovery point objective, or the point at which...