Apache Spark

Reading Time: < 1 minute

Contents for Apache Spark

Published
Categorized as Full Course

Netezza needs less Administration

Reading Time: < 1 minute

Netezza vs Tradistional RDBMS Logical Model is enough to create a Table No Indexes, tuning, rebuilding of indexes or space for the indexes No Physical tuning Distribute data by columns or by RANDOM No Storage Adiminstration (No tablespace or dbspace allocation) No page/block sizing configuration No Software installation needed No need for a large team… Continue reading Netezza needs less Administration

Published
Categorized as learn Tagged

Netezza AMPP Architecture

Reading Time: 2 minutes

Primary Tier Netezza’s AMPP architecture is a two-tiered system designed to handle very large queries from multiple users. The first tier is a high-performance Linux SMP host. A second host is available for fully redundant, dual-host configurations. The host compiles queries received from applications, and generates query execution plans. It then divides a query into… Continue reading Netezza AMPP Architecture

Published
Categorized as learn Tagged

SMP vs MPP Architecture

Reading Time: 2 minutes

Databases such as Oracle, DB2, Sybase Symmetrical Multi-Processing Architecture (SMP) was once the champion of the Data Warehouse. It was rivalled by MPP as SMP had the below disadvantages: Failures of components did not result in graceful decline in performance. Rather, the whole system failed and data was unrecoverable until the failure was resolved Upon… Continue reading SMP vs MPP Architecture

Netezza Query Plan Analysis

Reading Time: 4 minutes

Netezza Explain Plan As with most database management systems, Netezza generates a query plan for all queries executed in the system. The question plan determines ideal execution path by Netezza to fulfill each query. The Netezza component which generates and determines the optimal query path from the available alternatives is called the query optimizer and… Continue reading Netezza Query Plan Analysis

Published
Categorized as learn Tagged

EMC Storage

Reading Time: 3 minutes

Contents for EMC Storage

Published
Categorized as Full Course

Data Science

Reading Time: 8 minutes

Contents for Data Science

Published
Categorized as Full Course

Netezza Distribute on

Reading Time: 6 minutes

When users create tables in databases and store data into it, data gets stored in disk extents which is the minimum storage allocated on disks for data storage. Netezza distributes the data in data extents across all the available data slices based on the distribution key specified during the table creation. If you don’t want… Continue reading Netezza Distribute on

Published
Categorized as learn

Netezza storage

Reading Time: 3 minutes

The primary partition in each disk is used to store user data like database tables, the mirror stores a copy of the primary partition of another disk so that it can be used in the event of disk failures and the temp/swap partition is used to store the data temporarily like when the appliance does… Continue reading Netezza storage

Published
Categorized as learn Tagged

Netezza Security

Reading Time: 3 minutes

Two levels of security: OS Level security Database Level security OS Level security Netezza host uses Linux operating system customized for performance and functionality required for the appliance. User access restrictions are setup using user ids, user groups and passwords. When installed, the appliance is configured with a “root” user id which is the Linux… Continue reading Netezza Security

Published
Categorized as learn Tagged