The Aginity Blog Analyzing the disk spaced consumed by a database Posted by: Roman Taluev on 3/29/2010 | 0 Comments Categories: code sample Netezza   Today we’ll consider a series of SQL queries that analyze the disk space used by our databases. This way is based on selecting information from system views and tables.   Using only SQL for data analysis gives us the opportunity to get information from a Netezza appliance in any environment – all we need is access to the SQL console   A logical first step is to understand the size of our databases with an ‘order of magnitude’ analysis. Read More Optimize queries using Zone Maps. Posted by: Sergey Astahov on 3/19/2010 | 0 Comments Netezza does not support indexes in user tables. Instead, Netezza uses zone maps. Zone maps are automatically generated internal tables that the NPS system uses to improve the throughput and the response time of SQL queries against large grouped or nearly ordered date, timestamp, byteint, smallint, integer, and bigint data types. Information about zone maps is stored in the table _vt_spu_zmap_info. Read More Materialized views and query optimization Posted by: Roman Taluev on 3/15/2010 | 0 Comments Netezza has special kind of views that store a subset of base table columns in a sorter manner. Those views are named “MATERIALIZED VIEWS”. Read More Query Tools for Netezza Posted by: Dan Kuhn - CTO on 3/9/2010 | 1 Comment We’ve been working on a query tool for Netezza to address our own selfish needs– primarily to get a deeper knowledge of how to deeply leverage it and bring platform specific features directly to our developers via a simple “Netezza Aware” query tool.  Although we like it for specific reasons, there are a lot of great tools out there that support Netezza.  They are not aware of some of the more unique aspects of Netezza, but they have some great capabilities for doing queries, reviewing data results,etc.  I thought it would be useful to share these.  Please feel free to comment on them and let me know those I may have missed. Read More   Blog Home		Recent Posts Compile and Register Analytic Process Creating a Netezza User Defined Aggregate (UDA) – understanding the basics Creating a Netezza User Defined Aggregate (UDA) – sample aggregate Archive July 2010 (3) June 2010 (5) May 2010 (1) April 2010 (3) March 2010 (4) February 2010 (1) January 2010 (1) November 2009 (3) September 2009 (2) August 2009 (6) July 2009 (2) Bloggers Brian Weissler Dan Kuhn - CTO Doug Grimsted - CEO Oleg Roman Taluev Sergey Astahov Ted Westerheide - Chief Architect Category List analytic data factory (5) architecture (3) cloud computing (1) code sample (5) data factory (12) data quality (3) data warehouse architecture (3) enterprise data factory (4) Enzee 2010 (5) methodology (2) MPP (3) Netezza (11) operations management (1) Tag Cloud amazon cloud computing cloud services code continuous build data distribution data warehouse performance dimensional scarcity dimensional sparseness ec2 factory architecture factory methodology iclass massively parallel netezza operations management sample snowflake schema udf udx