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

Experimenting with JSON


JavaScript Object Notation (JSON) is a lightweight programming independent data interchange format. It is mainly used in web applications to transmit information. It is not only simple for humans to read but easy for machines to parse and generate. JSON has some advantages for traditional extensible markup language (XML):

  • XML data is a typeless only string, whereas JSON data is typed like string, number, array, and boolean
  • JSON data is readily accessible, whereas XML data needs to be parsed and assigned to variables

The JSON syntax is a subset of the JavaScript syntax. There are some rules when it comes to JSON syntax:

  • Data is defined in name/value pairs
  • Data is separated by commas
  • Curly braces hold objects
  • Square brackets hold arrays
{
"name":"Robert"
}

We can use JSON as we would use any other SQL data type:

  • JSON content is stored in databases and optimized depending on the size of the data.
  • The user is not responsible for executing the CREATE TYPE statement for the JSON data...