Comprehensive Tutorial on Cloud Storage
📖 1. What is Cloud Storage? Cloud Storage refers to the service model where data is stored, managed, and accessed remotely over the internet instead of being…
What is DataStax Astra?
DataStax Astra DB simplifies cloud-native application development, and reduces time to install, deploy and scale from weeks to minutes. Astra DB eliminates operational overhead, the biggest obstacle…
What is ClickHouse?
Clickhouse is an open-source columnar-oriented Database Management System (DBMS) used for online analytical processing (OLAP) created by Yandex. Currently, it powers the second largest web analytics platform,…
What is Cassandra?
Apache Cassandra is an open source non-relational, or NoSQL, a database that enables continuous availability, tremendous scale, and data distribution across multiple data centers and cloud availability…
What is BigQuery?
Nowadays, the age of tech big Data information is continuously increasing in volume and variety. This is the information that companies would like to quickly explore to…
What is Azure SQL?
Azure SQL is Microsoft’s cloud database service. Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to…
What is ArangoDB?
ArangoDB is an open-source multi-model NoSQL database with a flexible data model for documents and graphs. It is designed as a “general purpose database,” offering all the…
Secondary Index in Teradata
# Contents 1. What is Secondary Index in Teradata? 2. When we can Define Secondary Index? 3. Types of Secondary Index 4. Unique Secondary Index (USI) 5….
What is Aerospike?
Today’s growing on-demand business processes must ingest large volumes of data and make real-time decisions at the edge. Traditional NoSQL systems lack data consistency relational systems can’t…
Teradata No Primary Index (NOPI) Table
# Contents 1. What is NO PRIMARY INDEX (NOPI) Table? 2. How’s row distributed in AMP for No PRIMARY INDEX (NOPI) table? 3. How it can be…
Hashing of the Teradata Primary Index
# Contents 1. The Hashing Formula Facts 2. Important Hashing formula Terminology 3. How Hashing Algorithm decides which AMP has the Row? 4. Hashing Theory For Non- Unique…
What is Teradata Primary Index?
# Contents 1. What is difference between Primary Keys (PK) and Primary Indexes (PI) 2. What is Primary Index? 3. The Teradata Primary Index Choice (Which Column to…
How to connect Teradata SQL Assistant to Teradata
In this Tutorial we will learn how to connect Teradata SQL Assistant to Teradata database using Teradata ODBC drive. If you want to install Teradata Database in…
Installation and Configuration Teradata Tools and Utilities
If you want to learn and practice Teradata database Please find here the guidance how to Installation and Configuration Teradata Tools=and Utilities in your computer. The latest…
Teradata Architecture
Contents The Teradata database Architecture PARSING ENGINE (PE) Message Passing Layer(MPL) The Access Module Processor (AMP) VIRTUAL DISK (Vdisk) What is Teradata SMP and MMP System? BYNET…
What is Teradata Objects? A Tutorials & Guide
Teradata Objects Below are the list of objects contains in Teradata database or User: Tables–rows and columns of data Views–predefined subsets of existing tables Macros–predefined, stored SQL…
Teradata Basics
Major Components of Teradata: Parsing Engine The Message Passing Layer (MPL) Access Module Processor (AMP) Virtual Disk Parsing Engines (PE) Manage sessions for users Parse, optimize, and…
What is Teradata Database?
Contents What is Teradata Database? Teradata – A Brief History Why Teradata? What is a Data Warehouse? What is a Relational Database? Teradata Database Advantages The Features That…