Programming Tutorials Browser Tutorials Articles Struts Tutorials Hibernate Tutorials

  Tutorial: Multi-Dimensional Clustering Table Size Estimator for DB2

A utility for determining space requirements and simplifying administration of Multi-Dimensional Clustering (MDC) tables in DB2.

Tutorial Details:

What is Multi-Dimensional Clustering Table Size Estimator for DB2?

Many applications, OLAP and data warehousing in particular, usually consider several attributes as dimensions for processing and maintenance. Performance and scalability of queries in this type of environment can be slow using the traditional relational-database approach based on one-dimensional clustering, in which an index composed of one or more key parts is identified as the basis for data clustering.

The Multi-Dimensional Clustering (MDC) Table support in DB2 is defined to include one or more clustering dimensions and resolves many of these performance issues. However, Database administrators working with MDC tables must manually estimate sizes of MDC tables and allocate space ahead of time. This can be both an error-prone and a time-consuming process.

Multi-Dimensional Clustering Table Size Estimator for DB2 can be used to determine the space requirements when a normal table is converted to MDC or when the clustering dimensions of an existing MDC table are changed. This utility optimally estimates the MDC table size requirements based on table statistics and MDC dimension parameters.


 

Read Tutorial at: Click here to view the tutorial

Rate Tutorial:
Multi-Dimensional Clustering Table Size Estimator for DB2

View Tutorial:
Multi-Dimensional Clustering Table Size Estimator for DB2

Related Tutorials:

JavaWorld Developer Tools Table
JavaWorld Developer Tools Table
 
Optimize a query on a Map - JavaWorld November 2000
Optimize a query on a Map - JavaWorld November 2000
 
J2EE clustering, Part 1 - JavaWorld February 2001
J2EE clustering, Part 1 - JavaWorld February 2001
 
Access the world's biggest database with Web DataBase Connectivity - JavaWorld March 2001
Access the world's biggest database with Web DataBase Connectivity - JavaWorld March 2001
 
J2EE clustering, Part 2 - JavaWorld August 2001
J2EE clustering, Part 2 - JavaWorld August 2001
 
High-availability mobile applications
High-availability mobile applications
 
Java Tip 143: Utilize the Database Schema Browser
Java Tip 143: Utilize the Database Schema Browser
 
Clustering and Load Balancing in Tomcat 5, Part 1
The latest version of the Tomcat servlet container provides clustering and load balancing capabilities that are essential for deploying scalable and robust web applications.
 
Clustering and Load Balancing in Tomcat 5, Part 2
Clustering and Load Balancing in Tomcat 5, Part 2
 
JForumFusion
About jForumFusion JForumFusion is a platform independent discussion board program.
 
Mantissa
Mantissa (Mathematical Algorithms for Numerical Tasks In Space System Applications) Overview Mantissa is a collection of various mathematical tools aimed towards for simulation. It is not a complete mathematical library like GSL, NAG or IMSL, but it con
 
HA-JDBC: High-Availability JDBC
HA-JDBC: High-Availability JDBC Summary HA-JDBC is a JDBC driver proxy that provides light-weight, transparent clustering capability to any underlying JDBC driver.
 
Monitoring Session Replication in J2EE Clusters
Clustering has become one of the most common and most emphasized features of J2EE application servers, because, along with load balancing, it is the fundamental element on which the scalability and reliability of an application server rely.
 
The Trove collection classes
The Trove collection classes TheTrove, an open source Java collection package, provides an efficient alternative to the core Java collection classes, especially for implementing collections whose keys or values are primitive types. In this installment of
 
Session Replication in Tomcat 5 Clusters, Part 1
The Tomcat 5 server provides built-in support for clustering and session replication. This first article in this series will provide an overview of session persistence and the inner works of session replication in Tomcat clusters.
 
Accessing Databases Using Java and JDBC
This article will show how a Java Application, Applet or Servlet can access data stored in relational databases using the JDBC API.
 
Hibernate simplifies inheritance mapping.
Learn three easy-to-implement strategies to map class hierarchies. Hibernate is an object-relational mapping and persistence framework that provides a lot of advanced features, ranging from introspection to polymorphism and inheritance mapping.
 
JSP date example
JSP date example JSP Date Example Till now you learned about the JSP syntax, now I will show you how to create a simple dynamic JSP page that prints the current date and time. So the following code accomplish this: <%@page contentType="text/html"
 
Using Beans in JSP. A brief introduction to JSP and Java Beans.
Using Beans in JSP. A brief introduction to JSP and Java Beans. USING BEANS IN JSP Java Beans Java Beans are reusable components. They are used to separate Business logic from the Presentation logic. Internally, a bean is just an instance of a
 
DB Visual Architect for Eclipse
DB Visual Architect for Eclipse (DBVA-EC) is a full featured Object Relational Mapping (ORM) plugin for Eclipse that provides the industry\'s best round-trip code engineering support with Java.
 
Site navigation
 

 

Send your comments, Suggestions or Queries regarding this site at roseindia_net@yahoo.com.

Copyright © 2006. All rights reserved.