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 to using Apache…
Read more »
What is Cloud Storage?
Cloud storage is a cloud computing model that stores data on the Internet through a cloud computing provider who manages and operates data storage as a service. It’s delivered on…
Read more »
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, Yandex Metrica. It…
Read more »
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 zones. It is…
Read more »
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 identify strategic answers…
Read more »
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 store relational data…
Read more »
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 features typically needed…
Read more »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. Non Unique Secondary…
Read more »
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 reach internet scale…
Read more »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 determine which AMP…
Read more »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 Primary Indexes have…
Read more »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 make as PI)…
Read more »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 your windows then…
Read more »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 Tools and…
Read more »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 and its Types?…
Read more »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 statements Triggers–SQL statements…
Read more »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 send your request…
Read more »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 Makes Teradata Database…
Read more »