Introduction To Netezza Netezza is a data warehouseing appliance and an advanced analytics engine used for business intelligence, predictive analysis, and business planning. A data warehouse appliance is one which has a specific functionality, but performs better than other multipurpose tools. As a data warehouse appliance, Netezza integrates the server, database, storage, software, and hardware within a single unit. Netezza has asymmetric massively parallel processing architecture which enables it to have more functionality (such as… read more →
In continuation to the previous posting, Data Warehousing Concepts I, here are the topics related to high level information in building a data warehouse covered in this post. Concepts Covered In This Course 1. Star Schema 2. Snowflake Schema 3. Data Integrity 4. What is OLAP, MOLAP, ROLAP, and HOLAP? Star Schema This is the simplest form of a data warehouse schema. In the star schema design, a single object (the fact table) sits in… read more →
Update: A follow up to this post has been written. Read the Data Warehousing Concepts II post. This post will provide you with high level information about building a data warehouse (DW) and the associated maintenance. The main focus will be on the concepts around implementing a data warehouse. A future blog will provide information about some more advanced data warehousing concepts. Concepts Covered In This Post Dimensional Data Model Slowly Changing Dimension Conceptual Data… read more →
For any organization, understanding the customer’s needs is the most important thing in order to provide better services and build healthy relationship with the customer. Customer analytics is a method of combining customer information (personalization data, customer interests, customer browsing behavioral data, and purchase behavioral data) to present a consolidated view of the customer and their activities. This involves segmenting customers into multiple buckets, understanding their purchase behavior, browsing the behavior, and estimating their next… read more →
Why Integrate Customer Data? It is very common that organizations interface with customers through multiple platforms/channels (stores, direct/online, contact centers, special events like sweepstakes etc.) and each platform may have its own operational systems (OLTPs). Stores/retail businesses generally uses ‘Point of Sales’ applications where as direct/online brands use e-commerce platforms like ATG, DAX, Ecommetry etc. On the other side, special events like sweepstakes may collect customer information using paper sign-ups which may get entered in… read more →
What is Teradata? Today’s growing data warehouses demand fast, reliable tools to help acquire and manage data and flexibility to load large volumes of data from database perspective with any source at any time. Challenges come from everywhere: more data sources, growing data volumes, dynamically changing business requirements, and user demands for newer data. Teradata data warehousing systems offer the following: Quick access to data for more timely decision making Solutions for the entire spectrum… read more →
What Exactly Is Netezza? The IBM Netezza data warehouse appliances are purpose-built for crunching massive volumes of data quickly and efficiently. This is delivered with IBM Netezza Analytics which is fully integrated into the IBM Netezza data warehouse asymmetric massively parallel processing (AMPP) architecture enabling data exploration, model-building, model-diagnostics, and scoring with unprecedented speed. IBM Netezza data warehouse appliances eliminate administrative tasks such as query indexing, storage management, buffer pool tuning, memory allocation, and schema… read more →